crash_reports
1 row where address = "BEACON ST & CENTRE ST" and dcc contains "Signs/Signals"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-11-13
Time:
15:00
Address:
BEACON ST & CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated he was travelling on Centre St S/B approaching the Beacon St intersection. #1 stated he was in the left lane turning left and had a green light. #1 stated the light turned yellow before he turned. At this time, #1 struck Mv#2 that was travelling straight ahead on Centre St N/B. #1 sustained heavy driver's side front end damage with airbag deployment. #1 was not injured. #2 operator stated she was travelling on Centre St N/B in the right lane going straight through the Beacon St intersection on a green light. #2 stated she was struck on her driver's broadside by #1 that turned left into her. #2 sustained heavy driver's broadside and front end damage with airbag deployment. #2 was very shaken up and transported by medics to NWH for evaluation. The scene remained active for a period time as the collision occured near the middle of the intersection during heavy traffic. Officers were required to safely direct traffic and pedestrians to avoid further accidents. As a result, no citation was written on scene. #1 was advised he would receive a citation in the mail. Both MVs towed by Tody's. Court/RMV citation processing note: #1 operator student/temporary residence was added to the bottom of the citation.
Keywords:
Airbag, Citation, Crash, Ped
Dcc:
Signs/Signals, Failed to yield
Report
url:
Image
url:
Latitude:
42.3300268
Longitude:
-71.1948254
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);