crash_reports
2 rows where dcc contains "Too fast for conditions", intersection = 0 and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: 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:
2021-06-27
Time:
14:06
Address:
275 DUDLEY RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 06/27/21 at approximately 14:06 I responded across from #295 Dudley Rd. for a single vehicle crash.When I arrived I witnessed Veh#1 was on its drivers side resting against pole #34. The operator was already out of the car sitting on the stone wall next to it. The Operator of veh #1 stated he was driving due North on Dudley Rd. driving the speed limit when he saw a jogger (witness #2) in his lane. He then swerved into the left lane when he saw an oncoming car. He then swerved back to the right and rolled his vehicle coming to rest beside Eversource Pole #34. The vehicle was towed by Tody's towing. The operators father showed up on scene before he signed a patient refusal to go to the hospital. Father stated he would take his son later by car to have his right forearm checked out because of airbag rash. Operator of veh #1 cited in hand Mass. #T2080856 for Ch 90/ Sec 17 Speeding estimated 50mph in a 25 Zone.
Keywords:
Airbag, Citation, Crash, Hospital, Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3123404
Longitude:
-71.1818448
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);