crash_reports
1 row where keywords contains "Fire" and "retrieved" is on date 2022-05-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-21
Time:
06:15
Address:
1144 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
At 0630 hrs.on 4/21/22, Newton Police and Fire were dispatched to the area of 1146 Chestnut St. for a motor vehicle collision into a tree. Upon arrival, MV#1 was observed with damage to its front end and cracked/broken front windshields. The operator of MV#1 stated he had worked all night and had fallen asleep causing the garbage truck he was operating to veer off of the roadway and into the city owned tree in front of 1146 Chestnut St. The tree itself had been knocked over and was across the roadway. A second tree on the property of 1146 Chestnut St. suffered damage. Further, several large tree limbs had fallen a top of MV#2 which was parked in the driveway of 1146 Chestnut St, but no visible damage was observed. The operator of MV#1 declined medical attention and contacted a private tow to remove MV#1 from the roadway. The operator of MV#2 as well as the homeowner of 1146 Chestnut St. were apprised of the situation. Pictures of the damage were taken on the N498 camera and attached to this report.
Keywords:
Fire, Night, Pictures, Tree
Dcc:
Fatigue/Sleep, Unknown
Report
url:
Image
url:
Latitude:
42.3100736
Longitude:
-71.2236379
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);