crash_reports
3 rows where keywords contains "Ice" and "retrieved" is on date 2021-02-22
This data as json, CSV (advanced)
Suggested facets: date, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-02-02
Time:
02:15
Address:
WILTSHIRE CT
Speed
limit:
15
Violation
cited:
no
Narrative:
MV 1 was plowing the driveway of 46 Wiltshire Ct when the vehicle slid on some ice on the surface and temporarily lost control. MV 1 slid into the right front of MV 1. MV 2 was parked in the driveway. MV 1 is construction vehicle owned by Antone Construction Company contracted by the City of Newton. Photos of both vehicles were taken and placed into IT.
Keywords:
Ice, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3574277
Longitude:
-71.1961494
Location:
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:
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);