crash_reports
1 row where "datetime" is on date 2019-03-04 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-04
Time:
18:07
Address:
1917 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV#1 stated he was travelling westbound on Commonwealth Ave with his dog in the front seat when he slid on ice and off the roadway. The roadway was wet from previous snow fall but was very well plowed and sanded. MV#1 hit a curb, drove through a snowbank, hit a tree with the left front of his vehicle and then hit a pole with the right front side of his vehicle. The car then came to a rest in the median. The operator appeared confused by the accident and did not realize the extent of the damage to his car.He asked what he had hit. He continuously asked if it was driveable even though the entire front end was totaled. He was able to provide me with his license and all pertinent information but spoke in a slow manner. There was no odor of alcohol. Operator declined medical attention. When asked if he was on any medication he stated he was on heart medication. We were able to contact the operator's son who was transported to the scene and stated the operator had previously suffered a stroke. David Donahue arrived on scene towed the vehicle to Tody's. A licensed driver picked up the operator. A search of the immediate area yielded negative results for ice in the roadway. A request for Immediate Threat License Suspension/Revocation was filed.
Keywords:
Alcohol, Crash, Ice, Snow, Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3453735
Longitude:
-71.2405313
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);