crash_reports
2 rows where dcc = "["Over-steering", "Unknown"]" and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-09
Time:
02:17
Address:
450 AUBURN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator #1 states he was driving eastbound on Auburn St in MA reg 905RRM (now known as vehicle #1), when a rabbit ran in front of his car which caused him to swerve. This resulted in vehicle #1 sideswiping MA reg 445ZE2 (now known as vehicle #2), which was parked/unoccupied on Auburn St in front of the Auburndale Commuter Lot. Vehicle #1 sustained damage to the entire right side and vehicle #2 had minor damage visible near the front driver's side wheel well. Upon querying both vehicles it was discovered that vehicle #1 had an expired registration. Vehicle #1 was subsequently towed by Tody's, and operator #1 was issued MA citation T1444941 in hand. A note was left on vehicle #2 referencing this crash report. It should be noted that vehicle #2 was parked in a posted No Parking area on Auburn St. Auburn St is a public way in the City of Newton. Operator #1 declined medical attention.
Keywords:
Citation, Crash
Dcc:
Over-steering, Unknown
Report
url:
Image
url:
Latitude:
42.3470444
Longitude:
-71.2468373
Location:
Case
number:
Date:
2020-09-22
Time:
00:13
Address:
MASSACHUSETTS TPK EAST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV#1 Was traveling Eastbound off the Mass Turnpike Exit and struck the curb on Washington St causing vehicle to jump the curb and collide with the bridge. OPMV#1 Stated he didn't know what happened and believed his tire might have popped prior to the accident. MV#1 Sustained major front end damage along with damage to the bridge. Vehicle was towed by Tody's Towing.
Keywords:
Crash
Dcc:
Over-steering, Unknown
Report
url:
Image
url:
Latitude:
42.3364517
Longitude:
-71.0770265
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);