crash_reports
1 row where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2021-10-28
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-23
Time:
11:35
Address:
1390 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 states that he was traveling south on Washington St directly behind MV#2 in the middle lane approaching the Mass Pike off ramp. According to operator #1, MV#2 veered to the left at the island and then without warning turned to the right crashing into MV#1. Very minor damage to drivers side tire on MV#1. The operator of MV#2 states he was traveling south on Washington St in the middle travel lane and at the island used his directional to turn into the right hand lane when crash occurred with MV#1. Damage to front quarter on passengers side and MV was towed by Todys at owners request. The operator of MV#2 provided MA Reg. 7ZP982 as a witness. MV did not match description and owner stated to me when contacted that he did not witness a crash in Newton today. No injuries and no citations issued.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3483707
Longitude:
-71.2296589
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);