crash_reports
2 rows where dcc contains "Unknown" 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:
Case
number:
Date:
2022-04-27
Time:
10:24
Address:
45 BEECHER TER
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of MV#1 stated she accelerated once within the driveway of 45 Beecher Ter. causing her to collide into the front right corner of the home. It appears the vehicle then slid approx. 5-10 feet into the fence which runs adjacent to the driveway causing damage to both the fence and retaining wall. Damage observed to the front right corner of 45 Beecher Ter. MV#1 sustained heavy damage to its front end and was towed by its owner. No injuries reported. Homeowner of 45 Beecher Ter. on scene and took photographs of damage to his property.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3216877
Longitude:
-71.1823438
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);