crash_reports
1 row where dcc_code = "[3]" and "retrieved" is on date 2021-01-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-21
Time:
14:33
Address:
CENTRE ST & WEST WILLOW
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 stated she was traveling northbound on Centre St when vehicle 2 suddenly pulled out from Willow St attempting to turn left (southbound) onto Centre St striking her vehicle. Operator of vehicle 2 stated she was stopped on Willow St stopped at the stop sign. Operator 2 stated she saw vehicle 1 coming northbound on Centre but felt she had enough time to pull out. She then pulled out of Willow St and struck vehicle 1. Witness was in her vehicle behind vehicle 2 on Centre St. Witness stated she saw vehicle 1 traveling northbound on Centre and she did not appear to be traveling in excess speed or in an erratic manner. Witness said she saw vehicle 2 pull out quickly from the stop sign and strike vehicle 1. Neither operator reported any injuries. Vehicle 1 had minor damage and vehicle two had to be towed from the scene by AAA.
Keywords:
Speed
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3332817
Longitude:
-71.19346
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);