crash_reports
2 rows where "datetime" is on date 2021-02-12, intersection = 0 and "retrieved" is on date 2021-02-16
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-12
Time:
15:23
Address:
157 HERRICK RD
Speed
limit:
0
Violation
cited:
no
Narrative:
MV1 was parked off to the shoulder of the roadway inside the parking lot of the Adelaide. Operator of MV1 came out from getting his COVID-19 vaccine and saw his vehicle had suffered front end damage. Operator of MV1 canvassed the area yielding negative results for any vehicle that could have struck his vehicle. Operator of MV1 spoke with the staff from the Adelaide who informed him there are no cameras in the parking lot. Operator of MV1 wanted this hit and run documented.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3255677
Longitude:
-71.1910346
Location:
Case
number:
Date:
2021-02-12
Time:
23:11
Address:
687 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/12/2021, at 2315 hrs, Newton Police were dispatched to the area of Watertown St. and Brookside Ave. for a single motor vehicle collision. Upon arrival, MV#1 (Red, Jeep Grand Cherokee) was observed parked, on the side of the road facing eastbound in front of 687 Watertown St. MV#1 was observed to have front end damage and two flat tires (driver side). The operator, who was standing outside the vehicle, stated he was traveling eastbound on Watertown St. when he became distracted, lost control of the vehicle and collided into the snow bank.The driver did not report any injuries. The vehicle was towed from the scene by Perfecton Towing of Waltham, Ma. Damage to MV#1 does not appear consistent with the operators recollection of events, but a check of the immediate area by Newton Officers did not yield any damaged property. Damage to MV#1 was photographed with the (N492) camera and will be attached to this report.
Keywords:
Distracted, Pictures, Snow
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3547391
Longitude:
-71.2134511
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);