crash_reports
1 row where dcc = "["Failed to yield"]", intersection = 0 and "retrieved" is on date 2021-08-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-08-13
Time:
11:39
Address:
716 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated she was travelling straight ahead on Beacon St E/B (right of way) in the area of #716 Beacon. To no avail, #1 stated she quickly veered left in an attempt to avoid being struck by Mv#2 that was exiting the Newton Centre Post Office driveway. #1 was struck passenger side broadside, which appeared to sustain more significant damage to the passenger side rear door. #2 operator stated she was exiting the Post Office driveway (posted stop sign) attempting to turn left onto Beacon St W/B. #2 stated #1 was travelling at a high rate of speed. at which time #2 pulled out turning left and struck #1 passing by. #2 passenger side front end struck #1, #2 appeared to sustain less than moderate damage to that area of the MV. No injuries reported and both vehicles could be safely driven away.
Keywords:
Moderate, Speed
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3306362
Longitude:
-71.1900994
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);