crash_reports
2 rows where dcc_code = "[]" and keywords contains "Alcohol"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-05-31
Time:
15:14
Address:
FRANKLIN ST & WAVERLEY AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 stated he was traveling northbound on Waverly Ave and slowed down to turn when he was struck from behind by MV2. Operator of MV2 stated she was traveling northbound on Waverly Ave when she was struck from behind by MV3 pushing her into MV1. Operator of MV3 stated she was traveling northbound on Waverly Ave when she was struck from behind by MV4 pushing her into MV2. Operator of MV4 stated he was traveling to close to MV3 and had no time to stop and struck the vehicle causing the accident. Operator of MV4 was determined to be operating under the influence of alcohol and was placed under arrest for 90/24 OUI (See incident #19021959). No operators reported any injuries. MV3 and MV4 were towed by Todys due to damage.
Keywords:
Alcohol, Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3492419
Longitude:
-71.1804564
Location:
Case
number:
Date:
2021-05-03
Time:
15:38
Address:
CHURCH ST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Ms. Kerri James stated that as she was travelling Westbound on Washington St at the intersection with Church St, her vehicle was struck in the rear by an unidentified Subaru operated by an unidentified White Female. The collision caused damage to the rear of her vehicle. This woman then exited her vehicle and claimed that there was no damage before getting back in her vehicle, and driving away. Ms. James stated that the woman appeared to be intoxicated. Ms. James, and her 2 passengers declined medical attention when it was offered, but stated that they may follow-up later with their doctor. I was unable to locate the other vehicle
Keywords:
Alcohol
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3558456
Longitude:
-71.1904222
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);