crash_reports
1 row where dcc = "["Reckless driving", "Inattention"]" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-20
Time:
11:58
Address:
330 HOMER ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was in the parking lot of 330 Homer St (Newton Free Library) attempting to park into a parking spot when her vehicle all of the sudden accelerated, went over the burm striking MV#2 (Parked and unoccupied), striking MV#3 (Parked unoccupied) and pushing MV#3 into MV#4 (Parked and occupied with 4 people). The operator of MV#1 stated she was not distracted and her vehicle just accelerated forward by itself. The front passenger of MV#1 stated they were attempting to park into a parking spot when the vehicle accelerated on its own. MV#1 sustained moderate damages to its front end. There were no reported injuries to the operator of MV#1 or its passenger. MV#1 was deemed mechanically sound and left the scene after being provided with the necessary information pretraining to this accident. MV#2 was parked next to MV#3 and was unoccupied when it was struck by MV#1. MV#2 sustained minor damages to its front passenger's side bumper. The owner of this vehicle was provided with the necessary information pertaining to this accident. MV#3 was parked in between MV#2 and MV#4 and was unoccupied. MV#3 was struck by MV#1 which pushed MV#3 into MV#4. MV#3 sustained heavy front end damages (Broken driver's side axle). The operator of MV#4 was inside his vehicle along with 3 other passengers when they were struck by MV#3. MV#4 sustained heavy damages to its driver's side rear door. There were no reported injuries to the operator of MV#4 or its 3 passengers. The witness stated he was inside his vehicle a few parking spots over from MV#4 and observed MV#1 drive over the burm striking MV#2 then striking MV#3 and pushing MV#3 into MV#4. MV#3 sustained the heaviest damage and was inoperable. MV#3 was towed by AAA Towing Services. I took digital photographs of the damages sustained to the city's burm.
Keywords:
Crash, Distracted, Moderate, Pictures
Dcc:
Reckless driving, Inattention
Report
url:
Image
url:
Latitude:
42.3358776
Longitude:
-71.2080211
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);