crash_reports
2 rows where speed_limit = 40
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-25
Time:
20:05
Address:
300 WASHINGTON ST
Speed
limit:
40
Violation
cited:
no
Narrative:
MV 1 was changing lanes northbound from the far left lane to the second lane when he rear ended MV 2. All air bags were deployed on all sides to MV 1 and it was towed away by Tody's due to it being disabled on a public way. MV 2 was traveling straight Northbound in the second lane when MV 1 rear ended him. MV 2 was towed due to it being disabled on a public way. Newton Fire Department responded with Cataldo ambulance due to air bags being deployed. There were no injuries to either party. Both parties were advised with crash report numbers.
Keywords:
Crash, Ems, Fire
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3567319
Longitude:
-71.1859798
Location:
Case
number:
Date:
2021-03-17
Time:
17:39
Address:
721 WASHINGTON ST
Speed
limit:
40
Violation
cited:
no
Narrative:
MV1 was traveling WESTBOUND on Washington St in the middle westbound lane when it was struck by MV2 exiting a parking lot. MV1 was t-boned on its passenger side by MV2. MV1 sustained heavy damage to its passenger door and rear passenger wheel, deeming it unsafe to drive. MV2 was exiting the parking lot of 723 Washington St, did not see MV1 coming and struck the vehicle, damaging his driver's side front. No injuries reported. Tody's towed MV1.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3527483
Longitude:
-71.2031248
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);