crash_reports
2 rows where dcc = "["Speeding", "Reckless driving"]", 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-25
Time:
20:28
Address:
107 SHERIDAN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of MV1, Nicole Laurin, sates that she was driving southbound on Sheridan Street when she lost control of her vehicle causing her to crash into MV2 which was parked in front of 107 Sheridan Street. Both vehicles sustained major damage and airbag deployment and were towed from the scene by Tody's. Due to the high rate of speed of the crash and air bag deployment, the operator of MV1 was transported to Newton Wellesley Hospital to be evaluated. It should be noted that prior to the reported crash there was a 911 call regarding a white sedan traveling at a high rate of speed going through numerous traffic signals and signs in a densely populated neighborhood with narrow streets. After the crash several more 911 calls were received stating that a vehicle traveling at an excessive rate of speed just crashed into a parked vehicle. Based on these calls and the nature of the crash, Ms. Nicole Laurin was issued in hand Massachusetts Unifrom Citation T2013231 for 90-24, Operating to Endanger, and 90-17, Speeding over the reasonable and proper rate. Sheridan Street is a public way in the city of Newton.
Keywords:
Airbag, Citation, Crash, Hospital, Speed
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3560213
Longitude:
-71.2349613
Location:
Case
number:
Date:
2021-02-12
Time:
23:25
Address:
996 WALNUT ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Operator of MV1 states he was traveling northbound on Walnut Street at a speed of approximately 45mph when he struck the snowbank with the front right tire causing the vehicle to leave the roadway, hit the utility pole and come to rest on the hood of the vehicle in the front yard of 996 Walnut Street. Operator of MV1 stated he was coming from a friends house where he consumed two alcoholic beverages. Operator of MV1 sustained injuries to his hand and forehead and was evaluated by Fallon medics who recommended transport to the hospital due to the severity of the crash. Pictures were taken of the scene. Tody's towing responded and took possession of the vehicle. Towed motor vehicle inventory form completed. Verizon and Eversource were notified for the utility pole. I issued Massachusetts Uniform Citation #T2012865 for the following: MGL Ch. 90 Sec. 24 OUI Alcohol, MGL Ch. 90 Sec. 24 (2) Operating to Endanger, Negligent, MGL Ch. 89 Sec. 4A Marked Lanes Violation and MGL Ch. 90 Sec. 17 Speeding greater than reasonable
Keywords:
Alcohol, Citation, Crash, Hospital, Pictures, Snow, Speed
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3271198
Longitude:
-71.2060023
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);