crash_reports
1 row where dcc contains "Wrong way", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-01
Time:
02:50
Address:
191 NEEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV #1 was traveling southbound on Needham St. when it crashed head on into parked MV #2 before crashing into a utility pole in front of 191 Needham St. Vehicle #2 was parked north bound on Needham St. in the south bound lane with its emergency lights on. Operator of Vehicle #1 had minor injuries and was transported to NWH. Operator of Vehicle #2 had minor injuries and was transported to NWW. Vehicle #1 sustained major damage and was towed by Tody's Towing. Vehicle #2 sustained minor damage was able to drive away from the scene. Operator of Vehicle #1 was issued MA citation T2079096 for MGL 90-24 OUI liquor, MGL 90-24(2)(a) Operating to endanger / negligent operation, and MGL 89-4A marked lanes violation. See incident #19046864 in regards to charges for this incident.
Keywords:
Citation, Crash
Dcc:
Wrong way, Reckless driving
Report
url:
Image
url:
Latitude:
42.3113604
Longitude:
-71.213892
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);