crash_reports
1 row where date = "2020-08-20" and dcc_code = "[3]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-20
Time:
07:31
Address:
HOMER ST & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated she was in the right lane (right turn only) on Homer St E/B at the Walnut St intersection. #1 stated the MV beside her in the left lane started rolling forward. #1 stated as a result, she believed the light was green but stated she never saw the light (red) prior to proceeding. #1 stated at that time, she proceeded straight ahead through the intersection and struck Mv#2 that was travelling straight ahead on Walnut St N/B. Mv#2 operator stated he was travelling straight ahead on Walnut St N/B. #2 stated while approaching the Homer St intersection he had a solid green light and proceeded straight ahead. #2 stated #1 suddenly appeared from his left going through the red light and struck him in the intersection. No injuries reported. Both Mv's sustained heavy front end damage, including airbag deployment in #2. Both were towed by Tody's. #1 operator cited in hand for violation of Ch89/Sec 4A Marked Lanes Violation and Ch89/Sec9 F/C Red Light.
Keywords:
Airbag, Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.33615
Longitude:
-71.20708
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);