crash_reports
1 row where "datetime" is on date 2021-03-10, intersection = 0 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-10
Time:
15:41
Address:
1860 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated he was traveling East on Beacon Street. He did not see the cars ahead stop in front of him and he crashed into the rear of vehicle 2. This caused vehicle 2 to crash into vehicle 3. Vehicle 1 sustained major front end damage and was towed by Todys. The operator of vehicle 2 stated he was stopped in traffic as the vehicle in front of him had come to a stop. Vehicle 1 then crashed into the rear of vehicle 2 causing vehicle 2 to crash into vehicle 3. Vehicle 2 sustained moderate rear end damage. The operator of vehicle 3 stated he was traveling on Beacon Street when he came to a stop to allow 2 individuals to cross the street who were standing in the crosswalk. He was then rear ended by vehicle 2. Vehicle 3 sustained minor damage. The witnesses in the cross walk stated she was waiting for cars to stop to let her cross the road. Vehicle 3 stopped for her, then she saw vehicle 1 crash into vehicle 2 which then crashed into vehicle 1. She was not hit.
Keywords:
Crash, Crosswalk, Moderate, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3278177
Longitude:
-71.2402053
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);