crash_reports
2 rows where intersection = 0, keywords contains "Moderate" and "retrieved" is on date 2021-03-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-10
Time:
15:41
Address:
1860 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated he was traveling East on Beacon Street. He did not see the cars ahead stop in front of him and he crashed into the rear of vehicle 2. This caused vehicle 2 to crash into vehicle 3. Vehicle 1 sustained major front end damage and was towed by Todys. The operator of vehicle 2 stated he was stopped in traffic as the vehicle in front of him had come to a stop. Vehicle 1 then crashed into the rear of vehicle 2 causing vehicle 2 to crash into vehicle 3. Vehicle 2 sustained moderate rear end damage. The operator of vehicle 3 stated he was traveling on Beacon Street when he came to a stop to allow 2 individuals to cross the street who were standing in the crosswalk. He was then rear ended by vehicle 2. Vehicle 3 sustained minor damage. The witnesses in the cross walk stated she was waiting for cars to stop to let her cross the road. Vehicle 3 stopped for her, then she saw vehicle 1 crash into vehicle 2 which then crashed into vehicle 1. She was not hit.
Keywords:
Crash, Crosswalk, Moderate, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3278177
Longitude:
-71.2402053
Location:
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);