crash_reports
3 rows where dcc = "["Too fast for conditions", "Inattention"]", intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-02
Time:
11:30
Address:
33 DEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 08/02/19 I responded to single vehicle crash across the street from #33 Dedham St. The operator of veh #1 stated he was driving due North on Dedham St. when his car veered into the city tree. There was airbag deployment and heavy damage to veh #1. Operator of veh #1 had some cuts and scrapes to legs but was checked out by the Medics and signed a patient refusal. The vehicle was towed by Tody's towing and the operator was issued Mass Citation #T1445105 in hand for CH89/ Sec4a Marked Lanes violation (traveling outside of breakdown lane) and Ch 90/ Sec 18 Speeding (based upon the significant amount of damage to the vehicle and how far the debris was found from the crash site) . The operator was picked up on scene by his daughter. Traffic Officer McSweeney arrived and took pictures of the damage to the city tree.
Keywords:
Airbag, Citation, Crash, Pictures, Speed, Tree
Dcc:
Too fast for conditions, Inattention
Report
url:
Image
url:
Latitude:
42.3160368
Longitude:
-71.2074874
Location:
Case
number:
Date:
2019-10-04
Time:
15:18
Address:
56 ROOSEVELT RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator 1 of vehicle 1 was traveling w/b on Roosevelt Rd when Vehicle 2 hit the curb and collided with her vehicle. Major damage to vehicle 1 and was towed by todys towing. No injuries to Operator 1. Vehicle 2 was traveling at a high rate of speed e/b on Roosevelt rd when she hit the curb and collided with vehicle 2 head on. Vehicle 2 was on the wrong side of road during the collision. Operator 2 was not injured. Passenger 1 and 2 was not injured and medical refusals were obtained through their parents. Passenger 3 was injured and taken to the NWH with minor injuries. Vehicle 2 had major damage and was towed by todys towing. Operator 2 was issued MA citation T2015492 for c89s4A Marked Lanes, c90s8 Passenger Restriction (JOL) and c90s17 for Speed.
Keywords:
Citation, Speed
Dcc:
Too fast for conditions, Inattention
Report
url:
Image
url:
Latitude:
42.3140525
Longitude:
-71.1931463
Location:
Case
number:
Date:
2022-04-08
Time:
12:30
Address:
36 GLEN AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday April 8, 2022 at approximately 1230 hours I was dispatched to 36 Glen Ave for a single car MVA into a stone wall. The sky was clear at this time of day but the roads were wet due to a previous rain storm. Witness stated MV1 was operating southbound on Glen Ave (public way) prior to 36 Glen Ave at approximately 40mph. Be advised the speed limit of Glen Ave is 25mph. Witness said MV1 crossed into the northbound lane, and operated through the driveway entrance and into the stone wall belonging to Glen Ave Association. Witness stated there were no other MVs on the road at this time and they were unsure if MV1 operator was on their cellphone while driving. Witness stated MV1 operator crawled out from the vehicle and there were no one else involved or in the car. MV1 sustained heavy and extensive front end damage, and was towed by Todys. MV1 operator stated they only had chest pains, and was not suffering from any head or neck injury at this time. Due to the nature of the incident and quick response by Newton Medics, I was unable to speak to MV1 operator, who was transported to Newton-Wellesley Hospital. I was able to speak to an employee of Glen Ave Association and advised them of the incident. The employee was the manager and they stated the damage to their stone wall was approximately $5,000 USD, and their telephone extension was x200. The employee was given the accident report number.
Keywords:
Crash, Hospital, Rain, Severe, Speed
Dcc:
Too fast for conditions, Inattention
Report
url:
Image
url:
Latitude:
42.3299883
Longitude:
-71.186118
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);