crash_reports
1 row where date = "2020-08-08" and dcc_code = "[3]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-08
Time:
06:13
Address:
CHERRY ST & WEBSTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Saturday, August 8th 2020, at approximately 6:13am, I, Officer Brooks, responded to a 2 car MVA at the intersection of Cherry street and Webster street. Upon arrival I spoke with the operator of MV1(MA REG 1XKP51), who stated he was traveling southbound on Cherry streeet, and failed to stop for the red light at the intersection of Webster street. The front end of his vehicle struck MV2 (MA REG 443LP3) on the passenger side front end. MV1 had damage to the front end and was towed by Tody's. I spoke with the operator of MV2 who stated she was traveling westbound on Webster street and had the green light. As she proceeded through the intersection she was struck by MV1. MV2 had heavy damage to the front passenger side, and had airbag deployment. The operator complained of chest pain and was transported to Newton Wellesley hospital. Her vehicle was towed by Tody's. Tow inventory forms were filed.
Keywords:
Airbag, Hospital
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.350159
Longitude:
-71.228704
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);