crash_reports
1 row where address = "DANA RD & PARMENTER RD" and dcc contains "Signs/Signals"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-02-15
Time:
20:34
Address:
DANA RD & PARMENTER RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Vehicle #1 was traveling north on Parmenter Rd. approaching Dana Rd. Vehicle #2 was traveling east on Dana Rd. approaching Parmenter Rd. Vehicle #2 failed to come to a complete stop at the stop sign at the corner of Dana and Parmenter Rd. Vehicle #2 failed to yield to oncoming traffic and failed to yield to Vehicle #1 who had the right of way. Vehicle #1 collided with the passenger side of Vehicle #2. Both Vehicles suffered minor damage and did not need tows due to the accident. The operator of vehicle #2 admitted to failing to stop at the stop sign. Neither driver was injured. The operator of vehicle #2 was cited with: (Citation #T2080768 / T2080768) MGL 90/24/F OUI Drugs MGL 89/9 Stop Sign Violation MGL 89/8 Fail to Yield to oncoming traffic MGL 90/24/O MV, Reckless operation of a MV MGL 94C/34/I Possession of Class E Vehicle #2 was towed from the scene by Tody's due to the operator being placed under arrest.
Keywords:
Citation, Crash
Dcc:
Signs/Signals, Failed to yield
Report
url:
Image
url:
Latitude:
42.3622316
Longitude:
-71.2310709
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);