crash_reports
3 rows where dcc contains "Speeding" and keywords contains "Alcohol"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-08
Time:
20:25
Address:
719 WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Thursday, August 8th 2019, at approximately 8:25pm, I, Officer Brooks, was parked in front of 719 Washington street facing westbound. I looked into my side view mirror to pull into traffic and observed MV1 (MA REG 118GL4) parked behind me with the driver's side door open. The operator was leaning into the car to retrieve an item, and then stood up and turned around to close the door. I observed MV2(IN REG VWI565) traveling westbound, at what I estimated to be 45 miles per hour. MV2 struck the open door of MV1, narrowly missing operator #1. MV1 sustained major damage to the driver's side door and was towed by Tody's. MV2 had heavy damage to the passenger side front end. The operator of MV2 was placed under arrest for Operating under the influence of alcohol after investigation. MV2 was towed by Tody's. There were no injuries as a result of the accident.
Keywords:
Alcohol, Crash
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3527843
Longitude:
-71.2030088
Location:
Case
number:
Date:
2019-10-27
Time:
04:36
Address:
RIVER ST & ELM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of MV1 stated that he was texting and traveling at a high rate of speed when his vehicle lost control and crashed into parked vehicles 2 and 3. All three vehicles sustained major damage and were towed from the scene by Todys. The operator of MV1 had no apparent injuries but due to the high rate of speed of the vehicle at the time of the crash was transported to Newton Wellesley Hospital for precautionary reasons. Photographs of the crash as well as the open container of "Chum Churum" alcoholic beverage were taken and placed in IT's mailbox.
Keywords:
Alcohol, Crash, Hospital, Phone, Pictures, Speed
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.352661
Longitude:
-71.231082
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);