crash_reports
1 row where intersection = 0, keywords contains "Airbag" and "retrieved" is on date 2021-09-02
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-08-28
Time:
22:03
Address:
326 CHERRY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV 1 was traveling northbound on Cherry Street when she struck a parked vehicle MV2 and then struck an additional parked vehicle MV3. Both MV2 and MV3 were unoccupied. Operator of MV1 states she was on her way home from getting ice cream and does not know how the accident occurred. Operator of MV1 states she does not remember anything happening prior to the accident. A bystander who wishes to remain anonymous states that when the operator of MV1 got out of the vehicle she stated that she thought she had fallen asleep. Operator of MV1 was evaluated due to airbag deployment and her father signed a AMA refusal, stating they would take her on their own to the hospital. MV1 and MV2 towed from the scene by Tody's, owner of MV3 was able to be move MV3 into driveway.
Keywords:
Airbag, Crash, Hospital, Ice
Dcc:
Inattention, Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3532099
Longitude:
-71.228882
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);