crash_reports
2 rows where "datetime" is on date 2019-02-12 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-02-12
Time:
14:59
Address:
PEARL ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of vehicle # 1 stated that he was traveling EB on Watertown Street and was going through intersection when MV # 2 came into intersection from Pearl Street. Both streets are public ways maintained by the city of Newton. Unsure if it slid on ice or just went through red light. Oper 1 swerved in an attempt to avoid collision but vehicles still collided. Vehicle # 2 immediately left the area. Bumper was hanging off of vehicle # 1. And Oper # 2 stated he had a witness that I was unable to talk too. MV 2 was described as a gray Nissan Pathfinder with RI reg XS837. Dispatch ran XS837 and it came back registered to a gray 2007 Nissan Pathfinder. Due to amount of damage and description given I mailed the owner of MV 2 a citation for Leaving the Scene of Property Damage. No injuries. No tows.
Keywords:
Citation, Ice
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3614737
Longitude:
-71.1969079
Location:
Case
number:
Date:
2019-02-12
Time:
21:32
Address:
85 CHARLESBANK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 was travelling northbound on St James Street. As he approached the intersection of Charlesbank Rd, he began to brake to turn right. Due to the slippery snow and ice conditions, his brakes locked up and he skidded straight into the median in front of 85 Charlesbank Rd. The vehicle sustained major damage to the drivers side front axle, hood and under carriage. Operator of MV1 stated he was not injured and declined medical attention. He had called for a private tow. Tonys Towing responded to towed the vehicle.
Keywords:
Ice, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3588929
Longitude:
-71.1800115
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);