crash_reports
2 rows where keywords contains "Pictures" and "retrieved" is on date 2021-03-11
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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-03-08
Time:
12:49
Address:
25 ARMORY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 03/08/2021 at 1249hrs I responded to 25 Armory St for a motor vehicle crash involving a city of Newton owned motor vehicle. Vehicle 1 described as city of Newton Fire Engine #4 (MA Fire Reg 444) backed into Vehicle 2 which was parked and unoccupied facing northbound on Armory St. As a result of the impact Vehicle 1 sustained little to no visible damage, Vehicle 2 sustained minor damage to the passenger side front bumper. No injuries were reported on scene. No tows were required. Photographs were taken and submitted to the NPD IT Bureau.
Keywords:
Crash, Fire, Pictures
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3503557
Longitude:
-71.2198091
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);