crash_reports
2 rows where "datetime" is on date 2019-01-19 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-19
Time:
14:14
Address:
200 BOYLSTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Aubrey Quintus states that she parked ND Reg 539AAR at 200 Boylston St in the parking lot. When she came back to her vehicle she noticed the right side had been struck by an unidentified vehicle. No witnesses, injuries or tow. Quintus was advised.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3191343
Longitude:
-71.1756718
Location:
Case
number:
Date:
2019-01-19
Time:
18:30
Address:
423 LEXINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 1/19/19 I responded to 25 Normandy Rd for a report of a past hit and run. I spoke with the Operator of MV#1 who stated the accident had taken place in front of Tom's Pizza, 423 Lexington St, at approximately 1830 hrs. Operator of MV#1 stated she parked her vehicle in a parking spot directly in front of the restaurant and went inside. When she returned approximately 5 minutes later she realized her vehicle had been rear ended. Two witnesses provided her with information about the accident and the plate number. (See witness narratives.) MV#1 suffered moderate damage to the rear and was driven from the scene. Waltham PD responded to the address listed for MV#2 and were not able to locate the vehicle. At approximately 2000 hrs, I was contacted at the police station by the owner of MV#2's wife. After further investigation (see incident report #19002425) it was determined that the operator of MV#2 at the time of the accident was the vehicle owner's brother. I spoke with Operator of MV#2 on the phone and he stated that the road was icy and slippery due to snow and he crashed into the back of MV#1. He stated he was nervous and thought he had only hit the sidewalk curb. Operator of MV#2 was issued citation T1440626 by mail for 90/24C Leaving the Scene of Property Damage, 90/10A Unlicensed Operation and 90/24 Use of MV Without Authority. He stated the vehicle suffered minor damage to the front.
Keywords:
Citation, Crash, Ice, Moderate, Phone, Snow
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3473356
Longitude:
-71.2472474
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);