crash_reports
1 row where "datetime" is on date 2019-07-20, intersection = 0 and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-20
Time:
23:24
Address:
552 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
yes
Narrative:
On 7/20/19 at 23:24 hrs I responded to the area of 552 Commonwealth Avenue for a report of a MVA. Upon arrival it was determined MV#1 had struck two unoccupied parked vehicles in the eastbound parking shoulder. The operator of MV#1 stated he was on his phone while driving and when he picked his head up another vehicle coming westbound was in his lane so he swerved to avoid collision and struck the parked vehicles. The impact caused MV#1 to spin and came to final rest facing Westbound. All vehicles were towed from he scene by Tody's towing. The operator of MV#1 was transported to the hospital for potential injuries. The Operator of MV#1 is being issued MA Citation T1442692 for 90/24 OUI Drugs, 89/4a Marked Lane Violation and 90/13B Impeded Operation/Phone Use and MA Citation T1442693 for 90/24 Operating to Endanger.
Keywords:
Citation, Crash, Hospital, Phone
Dcc:
Lane departure, Distracted
Report
url:
Image
url:
Latitude:
42.3360887
Longitude:
-71.1895313
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);