crash_reports
3 rows where "datetime" is on date 2021-02-15 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-02-15
Time:
20:14
Address:
41 ALGONQUIN RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 02/25/2021, while assigned to N494, I, Officer Conary responded to 41 Algonquin Road for a motor vehicle that struck a parked motor vehicle. The weather was cold outside and the ground in the area had iced over. I spoke with Operator of MV1 who stated he was driving Northbound on Algonquin Road when he lost control of his vehicle due to the ice on the road, and hit MV2 and then hit a snow bank. I asked he wanted medical attention and he declined. There was damage to MV2 left rear bumper and tire. MV1 had damage to the front bumper. MV2 remained parked on scene, and MV1 was able to be driven. Owner of MV2 and Operator of MV1 exchanged necessary paperwork. City was notified of the ice and also debris in the road.
Keywords:
Ice, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3406637
Longitude:
-71.1699163
Location:
Case
number:
Date:
2021-02-15
Time:
20:39
Address:
MANDALAY RD & WOODCHESTER DR
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was traveling north on Woodchester Rd, attempting to make a left turn onto the west bound side of Mandalay Rd. Due to freezing conditions and light rain, both of these roads were covered in a layer of ice. When MV#1 attempted to make the left turn, the vehicle slipped around the corner and struck a fire hydrant at the corner of above mentioned roads. City of Newton water department was called out to inspect the hydrant, and N522 arrived on scene and took pictures. Passenger in MV#1 was transported to NWH for possible neck injury. MV#1 was driven off scene by operator.
Keywords:
Fire, Ice, Pictures, Rain
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.339096
Longitude:
-71.17788
Location:
Case
number:
Date:
2021-02-15
Time:
23:03
Address:
55 GROVE HILL PK
Speed
limit:
5
Violation
cited:
no
Narrative:
On Monday, February 15th 2021, at approximately 11pm, I, Officer Brooks, responded to 55 Grove Hill pk, for a report of a car into a house. Upon my arrival I observed MV1(73DE81) resting against the house. The operator stated she pulled into the driveway and due to the icy conditions the car did not stop until it came to rest against the house. The house did not sustain any damage and the operator was uninjured.
Keywords:
Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3393092
Longitude:
-71.2096412
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);