crash_reports
1 row where dcc = "["Lane departure", "Glare"]" and dcc contains "Glare"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-09-10
Time:
21:54
Address:
183 ADAMS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 9/10/2020 I was working N491 when I responded to the area of Adams St. for a report of an MVA unknown injuries. Upon arrival I spoke with Hasibullah Wahab who stated he was traveling southbound on Adams St. when an unknown vehicle traveling northbound on Adams St. approached with "blinding" headlights. Wahab stated he "was unable to see due to the headlights and swerved" striking Veh 2. Wahab was evaluated by Newton medics and signed a patient refusal. I located the Owner of Veh 2 Tim White. White requested his vehicle be towed off the street due to the fact it was leaking fluids and he did not feel safe driving it. Both Vehicles were towed by Todys. Both parties were provided accident report numbers.
Keywords:
Crash
Dcc:
Lane departure, Glare
Report
url:
Image
url:
Latitude:
42.3584221
Longitude:
-71.200665
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);