crash_reports
1 row where intersection = 0, keywords contains "Airbag" and "retrieved" is on date 2021-09-17
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-13
Time:
16:59
Address:
885 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 09/13/2021, while assigned to N494, I, Officer Conary, and Officer Kane (N492), responded to 885 Centre Street for a report of a single motor vehicle accident with airbag deployment. Upon arrival, I observed MV1 up on the curb with significant damage to the front and front right side. Operator of MV1 explained to me that he just got out of work and was driving Northbound on Centre Street when he fell asleep. Next thing he knew he was off the roadway. He explained to me that he had an early morning at work, and this hasn't happened before. Medics arrived on scene and he signed a patient refusal. Tody's towed MV1. The City of Newton was notified because the crosswalk sign was taken down during the accident. There was also damage to a City tree. Pictures were taken and submitted to IT to be uploaded accordingly.
Keywords:
Airbag, Crash, Crosswalk, Pictures, Tree
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3433232
Longitude:
-71.1938657
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);