crash_reports
2 rows where "datetime" is on date 2019-02-13 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-02-13
Time:
21:26
Address:
2000 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Stated while traveling westbound down Commonwealth ave he struck a patch of ice. The ice caused his vehicle to rotate 360 degrees and proceeded to slide on the roadside shoulder striking a verizon poll ( 102/285). MV#1 traveled approximately 12ft from the road before striking the poll. MV#1 sustained heavy front end damage. MV#1 had all airbags deployed and had a small fire under the front end. I observed multiple other vehicles passing having difficulties and vehicles sliding due to significant ice conditions. Driver of MV#1 had injuries to his left arm, possible broken forearm/wrist. Passenger of MV#1 stated she had chest pains. Medics transported both parties to Newton Wellesley Hospital for further evaluation. Tody's Towed the vehicle due to heavy front end damage.
Keywords:
Airbag, Fire, Hospital, Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3470319
Longitude:
-71.2431985
Location:
Case
number:
Date:
2019-02-13
Time:
22:18
Address:
73 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/13/19 at approximately 2230 hours, I responded to Chestnut St for a single vehicle accident. The operator of the motor vehicle stated he was driving northbound on Chestnut st at approximately 15 miles per hour due to the icy conditions and felt his car starting to slip down the hill. He stated that the car lost control and spun out onto the sidewalk and rested up against a utility pole. The drivers side door was caved in and the operator got out through the back seat passenger door. There were no injuries reported. The vehicle was towed by Todys. The city was notified of the black ice.
Keywords:
Crash, Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3475221
Longitude:
-71.2251229
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);