crash_reports
1 row where "date" is on date 2020-08-26, intersection = 0 and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-26
Time:
14:11
Address:
106 LEXINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The witness stated she was travelling southbound on Lexington St a few vehicles behind MV#1 and observed MV#1 veered towards the northbound travel lane and striking the city tree and retaining wall of 106 Lexington St. The witness then pulled over and assisted the operator of MV#1. The operator of MV#1 stated she was travelling southbound on Lexington St and was "multi tasking" inside her vehicle when she veered off into the northbound travel lane, jumped the curb onto the sidewalk and got wedged in between a city tree and the retaining wall of 106 Lexington St. The operator of MV#1 was not injured but could not exit her vehicle because the doors were wedged in between the tree and retaining wall. MV#1 sustained heavy front end damages, broken front passenger window, front passenger wheel and deployed driver's side airbag. The operator of MV#1 stated she was not injured and was evaluated by Newton Paramedics and signed a patient refusal. The operator of MV#1 was coherent and appeared to be of sound mind and health. I transported the operator of MV#1 to her home and Tody's Towing took possession of her vehicle. Traffic unit 535 took photographs of the damaged city tree.
Keywords:
Airbag, Pictures, Tree
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3563955
Longitude:
-71.2401015
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);