crash_reports
1 row where "date" is on date 2020-04-17 and dcc = "["Failed to yield", "Inattention"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-04-17
Time:
08:18
Address:
926 CHESTNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated she came to a stop at the stop sign on the Boylston St E/B access ramp at the intersection of Chestnut St. #1 stated she proceeded straight across into the intersection at which time #1 struck Mv#2 that was travelling on Chestnut St N/B. After impact, #1 crashed to the left into the bushes and yard of 926 Chestnut St. The impact also pushed #2 to the right into the same bushes. #2 operator stated she was travelling on Chestnut St N/B (right of way) and was about to clear the intersection when #1 suddenly appeared from her left and struck #2 broadside (driver's side). #1 operator had pain on the left side of her body and #2 had chest pain from striking her steering wheel. Both were transported to NWH for further evaluation. #1 sustained heavy damage to the front end with multiple airbag deployment. #2 sustained heavy damage to the driver's side and front end. Both were towed by Tody's to their storage yard.
Keywords:
Airbag, Bus, Crash
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3174679
Longitude:
-71.2256788
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);