crash_reports
3 rows where dcc = "["Too fast for conditions"]", intersection = 0 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-30
Time:
10:03
Address:
268 DEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 12/30/19 I responded to a single vehicle crash on Dedham St. outside of #268. The operator stated she was traveling due North on Dedham St at 25mph when she lost control of her vehicle due to icy conditions. Tracing back the vehicles tires marks in the slush, the car appeared to cross the double yellow lines near Brush Hill Rd and then back to the correct lane sideways before striking the curb, then a city tree in front of #268 Dedham St. There were multiple air bag deployments in the vehicle. Ambulance #1 arrived on scene and transported the operator due to a complaint of right chest pain from the seatbelt. N523 Traffic Officer Wilson arrived on scene and took pictures of the damage to the city tree. The vehicle was towed by Tody's Towing and the operator was mailed Mass. citation # T2013422 for Ch90/sec17-Speeding (too fast for conditions).
Keywords:
Citation, Crash, Ems, Ice, Pictures, Tree
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3109112
Longitude:
-71.202243
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:
Case
number:
Date:
2021-09-06
Time:
01:12
Address:
561 WATERTOWN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 was parked facing southbound on Crafts Street at a red light. MV1 attempted to turn westbound onto Watertown Street and lost control causing the vehicle to swerve. MV1 crashed onto the sidewalk on the other side of the road on Watertown Street. Due to the damage to MV1 the vehicle had to be towed away by Tody's. Operator of MV1 suffered no injuries and was cited. Incident Report 21038084 was generated regarding this incident.
Keywords:
Citation, Crash
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3566035
Longitude:
-71.2081372
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);