crash_reports
2 rows where dcc_code = "[10, 97]" and keywords contains "Alcohol"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-28
Time:
15:32
Address:
CRAFTS ST & MORRILL ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 (2010 Honda Fit; MA Reg: 94CY78) was traveling East on Crafts St, and came to a complete stop signaling to turn left onto Morrill St. MV2 (2015 Ford F250; MA Con: R43023) rear ended MV1, resulting in severe damage to the Honda. No damage was done to MV2. No injuries were reported. MV1 operator, Victoria Thurston, called AAA for a tow. Tody's was called for the Ford F250 due to MV2 operator, Brian Cernabentura's level of intoxication and unlicensed operation of the vehicle. Brian spoke Spanish and a passerby was able to translate some of my questions to him. I asked for identification and if he had been drinking. Brian did not give me any form of identification and he was very unsteady on his feet, glassy and bloodshot eyed. He was taken into custody by myself and booked at headquarters in the usual manner. Incident report 19041143
Keywords:
Alcohol, Severe
Dcc:
Reckless driving, Other improper action
Report
url:
Image
url:
Latitude:
42.360485
Longitude:
-71.2205598
Location:
Case
number:
Date:
2021-09-18
Time:
01:16
Address:
324 CRAFTS ST.
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1 was traveling Westbound on Crafts St. when MV1 crossed the double yellow solid line, hopped the curb and crashed into a telephone pole just prior to the intersection of Crafts St. and California St. Owner/ operator of MV1 stated he was rear ended causing him to crash. Located in front of 324 Crafts St. There were no indications of a second vehicle and the operator was concluded to be under the influence of alcohol. See incident report 21039916 for further information. The vehicle had not been towed yet, since the vehicle was trapped under a broken/ hanging part of the telephone pole. The vehicle will be towed as soon as the power company is able to replace the pole.
Keywords:
Alcohol, Crash
Dcc:
Reckless driving, Other improper action
Report
url:
Image
url:
Latitude:
42.358981
Longitude:
-71.2127317
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);