crash_reports
2 rows where "date" is on date 2022-04-12, keywords contains "Fire" and violation_cited = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2022-04-12
Time:
09:15
Address:
197 CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday April 12th 2022 at approximately 0915 hours I responded to the area of 197 California Street for a city of Newton fire truck that struck a fire hydrant while responding to an emergency. At the time of the accident the weather was cloudy and the road surface was dry. California Street is owned and maintained by the city of Newton. Upon arrival I spoke with the operator of Newton Fire Engine 1 identified as Joseph Frank. Joseph stated that while attempting to park the fire engine he struck the fire hydrant, causing the fire hydrant to be knocked over and inoperable. Minor damage to the front drivers side of the fire engine was photographed and submitted to the IT Bureau as well as the damaged fire hydrant. No injuries were reported. City of Newton was notified of the damaged hydrant.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3651092
Longitude:
-71.1963023
Location:
Case
number:
Date:
2022-04-12
Time:
19:04
Address:
HENSHAW ST & RIVER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV 1 was traveling straight, westbound on River St. MV 1 was approaching the intersection of River St and Henshaw St he was blinded by solar glare and struck the fire hydrant on the corner of the road. MV 1 sustained damage to the right front tire and bumper. The fire hydrant was disabled. Photos of the fire hydrant and damage to MV 1 were taken with the camera in 492 and submitted into IT. The driver of MV 1 was not injured. I assisted the driver of MV 1 with changing his tire and he was able to drive MV 1.
Keywords:
Fire, Glare, Pictures, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.352151
Longitude:
-71.228182
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);