crash_reports
1 row where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2021-05-17
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-05-12
Time:
09:46
Address:
BROOKLINE ST & VINE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Wednesday 5/12/21 at approx 0946hrs, while assigned to N499, I responded the intersection on Brookline St and Vine St(both public ways) in Newton for a 2 car MVA. Operator of MV1 states that he was traveling northbound straight on Brookline St. He said that MV2 came out of Vine St, didn't stop and struck his vehicle. Operator of MV2 states that he was on Vine St and stopped at the stop sign at the Brookline St intersection. He then stopped again past the crosswalk while waiting for all traffic on Brookline St to pass. He said that MV1 came "out of nowhere" at a high rate of speed NB on Brookline St before striking his vehicle. Both vehicles were towed by Tody's towing service. Operator of MV2 was given citation T2015012 for failing to stop, yield at an intersection.
Keywords:
Citation, Crosswalk, Speed
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3038766
Longitude:
-71.1759984
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);