crash_reports
1 row where "date" is on date 2019-12-17, dcc = "["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)
Case
number:
Date:
2019-12-17
Time:
10:58
Address:
1874 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated he was travelling Westbound on Washington St. The road conditions at that time was covered in Slush and ice. Operator #1 stated as he was rounding a slight bend in the Rd. His vehicle continued to slide to the left and into oncoming Eastbound traffic. Vehicle #1 Then collided with vehicle #2. Operator of vehicle #2 stated he was traveling Eastbound on Washington St. when vehicle #1 slid into his travel lane, striking his vehicle head on. He stated vehicle #2 then Struck vehicle #3 which had been driving eastbound to his right. Operator of Vehicle #3 stated he was travelling Eastbound when his vehicle was struck by Vehicle #2 which caused his vehicle to spin out of control and into the Westbound travel lane where his vehicle struck Vehicle #4. Vehicle #3 then struck the fence owned by the Woodland Golf Club. Operator #4 stated she was travelling Westbound when vehicle #3 spun out of control and struck her vehicle. Operator stated she attempted to stop but was unable to due to the poor Rd. conditions.
Keywords:
Ice
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3352873
Longitude:
-71.2420805
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);