crash_reports
1 row where dcc = "["Swerving", "Over-steering"]" and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-18
Time:
08:57
Address:
700 CENTRE STREET
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated that he was traveling North on Centre Street. He passed through the intersection of Cabot and Centre street where he proceeded downhill on an icy road. Operator stated that he "fishtailed" and lost control of his vehicle before leaving the roadway and coming to rest in the shrubs and trees in the front yard of 700 Centre Street. At the time of this incident there is a reported water main break at the intersection of Centre street and Sargent street with City Water Crews addressing the issue. I observed a large collection of ice in the intersection and in the northbound lane of Centre street. No injuries were reported. Tody's was notified and removed the truck from the bushes. Operator #1 drove the vehicle away. I notified the home owner, Mr. Watkins of the damage. He estimated the damage to the landscaping to be approximately $2000.
Keywords:
Bus, Ice, Tree
Dcc:
Swerving, Over-steering
Report
url:
Image
url:
Latitude:
42.3476813
Longitude:
-71.1881338
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);