crash_reports

Table actions

2 rows where "datetime" is on date 2022-06-16, intersection = 0 and "retrieved" is on date 2022-07-26

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
22000533
Date:
2022-06-16
Time:
09:09
Address:
97 ELIOT AVE
Speed limit:
25
Violation cited:
no
Narrative:
THE OPERATOR OF MV 1 STATED HE WAS TRAVELING SOUTH ON ELIOT AVE AND AS HE WAS DRIVING DOWN THE ROAD THERE WAS A LOW HANGING TREE BRANCH WHICH STRUCK THE TOP OF HIS DELIVERY TRUCK CAUSING DAMAGE TO THE ROOF. NO INJURIES WERE REPORTED AND FORESTRY WAS ADVISED TO CLEAN UP THE BRANCHES.
Keywords:
Tree
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3544204
Longitude:
-71.2215495
Location:
97 Eliot Ave, West Newton, MA 02465, USA
Case number:
22000534
Date:
2022-06-16
Time:
10:54
Address:
64 FERNCROFT RD
Speed limit:
20
Violation cited:
yes
Narrative:
Operator of Vehicle 1 states he was travelling Northbound on Ferncroft Rd when the operator became briefly distracted by his phone. Vehicle 1 then struck the curb and a tree on the West side of the road in front of #64 Ferncroft Rd, causing extensive damage to the front of the vehicle and airbag deployment. The operator denied any injuries and declined medical treatment. Vehicle 1 was towed from the scene by Tody's Towing. Newton Fire responded to clean up engine fluids that had leaked on the roadway. The witness who initially reported the crash to 911 stated that she observed the operator of Vehicle 1 pass her location at a higher than reasonable rate of speed and was looking down at his phone. I then issued the operator Mass. Uniform Citation #T1448099 (Written Warning) in hand to the operator's mother as his agent for a violation of C90ss13B Texting While Driving
Keywords:
Airbag, Citation, Crash, Distracted, Fire, Phone, Severe, Speed, Tree
Dcc:
Lane departure, Distracted
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None

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);