crash_reports
1 row where "datetime" is on date 2019-01-19, dcc contains "Too fast for conditions" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-19
Time:
19:13
Address:
173 GRANT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 stated she was traveling south bound on Grant Ave. Vehicle #1 stated that in the area where Grant Ave. bends to the left the roadway is dark and she had trouble seeing the road. Vehicle #1 stated at the last second she saw the road bending left and attempted to turn but skid on the snow and struck a small boulder in the front lawn of 173 Grant Ave. moving the rock a few feet. Vehicle #1 then skidded and came to a stop in the middle of the lawn of 173 Grant Ave. Vehicle # 1 then pulled off the lawn and to the side of the road. The owner of the property of 173 Grant Ave. was also present and was notified of the accident. Vehicle #1 had moderate damage to the front of the vehicle but was still able to be driven and was driven home. Both the operator and passenger in Vehicle #1 stated they were uninjured in the accident and refused any medical treatment.
Keywords:
Crash, Moderate, Snow
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3340429
Longitude:
-71.1883194
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);