home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2022-04-21 and keywords contains "Tree"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000325
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:
report
Image url:
image
Latitude:
42.3100736
Longitude:
-71.2236379
Location:
1144 Chestnut St, Newton, MA 02464, USA
Case number:
22000330
Date:
2022-04-21
Time:
23:52
Address:
318 CRAFTS ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 4/21/22, I was dispatched to the intersection of Crafts St./California St. for a motor vehicle collision involving a single vehicle into a tree. Upon arrival, I observed MV#1 had crashed into a tree in front of 315 Craft St. The operator stated the "road was slippery" and he veered off the roadway, hitting the curb, before traveling 20-25 yards on the sidewalk, hitting two tree's. MV#1 sustained heavy front end damage and air bag deployment consistent with colliding into a tree at a decent rate of speed. MV#1 was removed from the roadway by Tody's Tow Service. The operator of Mv#1 was transported to Newton-Wellesley Hospital with injuries. Charges pending at this time for OUI Liquor 2nd Offense, Marked Lanes Violation and Negligent Operation of a Motor Vehicle.
Keywords:
Crash, Hospital, Speed, Tree
Dcc:
Reckless driving
Report url:
report
Image url:
image
Latitude:
42.358935
Longitude:
-71.2125693
Location:
318 Crafts St, Newton, MA 02460, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 774.679ms