crash_reports
2 rows where "datetime" is on date 2019-01-02, intersection = 0 and "retrieved" is on date 2020-10-06
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-02
Time:
10:15
Address:
250 BROOKLINE ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV1 was parked in the corner spot in the center island of the parking lot. MV2 was turning right around the MV to approach the dumpster and misjudged the distance and struck MV1. MV2 is a Waste Management truck contracted by the City of Newton. I took pictures and they were TOT IT.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3020871
Longitude:
-71.177714
Location:
Case
number:
Date:
2019-01-02
Time:
18:33
Address:
414 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/2/19 I was working N503 when I responded to Watertown St. at West St. for a report of an MVA hit and run. Upon arrival I met with Jennifer Nave who stated that she had rear ended a white colored SUV style vehicle in front of 414 Watertown St. Nave stated after she struck the vehicle she pulled over to the side of the road and the other vehicle drove away. Nave stated she was uninjured however had minor front end damage. Nave was unable to give any other description besides white SUV style vehicle.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3597079
Longitude:
-71.2023358
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);