crash_reports

Table actions

2 rows where dcc contains "Visibility obstructed", keywords contains "Tree" and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2000000434
Date:
2020-08-08
Time:
09:41
Address:
310 PARKER ST
Speed limit:
30
Violation cited:
no
Narrative:
#1 VEHICLE WAS STOPPED ON KENDALL RD, AT THE INTERSECTION OF PARKER ST. VEHICLE #2 WAS TRAVELING DOWN PARKER ST, HEADING SOUTHBOUND. SEEING THE COAST WAS CLEAR IN BOTH DIRECTIONS, VEHICLE #1 PULLED OUT ONTO PARKER ST, IN AN ATTEMPT TO TAKE A LEFT HAND TURN. AT THIS TIME VEHICLE #2 WAS NOT PAYING ATTENTION, WAS APPARENTLY DISTRACTED AND HIS VIEW WAS OBSTRUCTED BY A TREE PARTIALLY BLOCKING HIS VIEW THEN IN TURN, DROVE INTO VEHICLE #1. VEHICLE #2 OPERATOR STATED THAT THE ACCIDENT WAS HIS FAULT AS WAS NOT PAYING ATTENTION. NO INJURIES REPORTED, VEHICLE #2 TOWED BY TODYS TOWING OF NEWTON. THERE IS A TREE AT THE INTERSECTION OF KENDALL & PARKER ST, THAT NEEDS TRIMMING THAT OBSTRUCTED BOTH DRIVERS VIEW. CITY NOTIFIED TO TRIM TREE TO PREVENT FURTHER OBSTRUCTED VIEWS.
Keywords:
Crash, Distracted, Tree
Dcc:
Visibility obstructed, Inattention
Report url:
report
Image url:
image
Latitude:
42.31672
Longitude:
-71.1946315
Location:
310 Parker St, Newton, MA 02459, USA
Case number:
2000000452
Date:
2020-08-14
Time:
13:31
Address:
BRAELAND AVE & HERRICK RD
Speed limit:
25
Violation cited:
no
Narrative:
Operator 1 states that he came to a complete stop on Herrick Rd at Braeland Ave. and then proceeded forward. Operator 2 was traveling Westbound on Braeland Ave and did not stop at the stop sign. Vehicle 2 pulled in front of vehicle 1 and operator 1 did not have time to stop striking vehicle 2. Operator 2 states she was traveling Westbound on Braeland Ave. She did not see the stop signs because they were covered by tree branches and leaves and proceeded forward. While traveling through the intersection vehicle 2 was struck by vehicle 1. Both vehicle sustained moderate damage and vehicle 1 was towed by Tody's. There were no injuries.
Keywords:
Moderate, Tree
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3288168
Longitude:
-71.1933968
Location:
Herrick Rd & Braeland Ave, Newton, MA 02459, 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);