crash_reports
1 row where "datetime" is on date 2021-04-10, hit_run = 0 and "retrieved" is on date 2021-04-12
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-10
Time:
21:47
Address:
CENTRE ST & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was traveling south on Centre St approaching the lights at the intersection of Centre and Walnut. MV#2 was at the lights of Centre and Walnut waiting to take a left onto Walnut St. MV#1 went straight though the lights, while MV#2 took a left onto walnut causing MV#1 to crash into MV#2. Operator of MV#1 stated that she had a green light as she continued though the intersection. Operator of MV#1 stated that as she was going though the intersection, MV#2 took a left in front of her and she crashed into him. Operator of MV#2 stated that he was waiting at the intersection for a clear turn. He stated that he believed that MV#1 had a red light, which gave him the right of wary to turn left on to Walnut St, when he was crashed into MV#1 Both vehicles were towed away by Todys. No injuries occurred.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3204602
Longitude:
-71.2050785
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);