crash_reports
1 row where date = "2019-06-05" and dcc contains "Lane departure"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-05
Time:
00:12
Address:
163 LEXINGTON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Wednesday, June 5th 2019, at approximately 12:12am, I, Officer Brooks, responded to 163 Lexington street for a report of a 2 car MVA. Upon my arrival I observed that MV1(MA REG 574PF5) had struck MV2(FL REG CWWE22) which was parked legally in front of 163 Lexington street. I spoke with the operator of MV1 who stated he was traveling southbound on Lexington street, and had reached over to his passenger side to grab a Burger King bag. When he reached for the bag he drifted to the right and struck MV2. MV1 had heavy damage to the passenger side and airbag deployment. The operator was checked out by Cataldo and signed a patient refusal. MV1 was towed by Tody's. The operator was issued a citation for an expired registration. I spoke with the owner of MV2 who was inside of 163 Lexington street at the time of the accident. His vehicle had been legally parked when struck. MV2 sustained major damage to the driver's side. MV2 was towed by Tody's. Both operators were provided the report number.
Keywords:
Airbag, Citation, Crash
Dcc:
Lane departure, Inattention
Report
url:
Image
url:
Latitude:
42.3552534
Longitude:
-71.2426722
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);