crash_reports
2 rows where dcc contains "Visibility obstructed" and keywords contains "Distracted"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-24
Time:
16:46
Address:
COMMONWEALTH AVE & LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPMV#1 Was traveling Southbound on Lexington St in the right turn only lane about to enter Commonwealth Ave traveling Westbound when she was struck by the OPMV#2. OPMV#1 Stated she was making a right turn onto Commonwealth Ave and the OPMV#2 started entering her lane with no signal and struck the left side of her vehicle. OPMV#2 Was traveling Southbound on Lexington St entering the right turn only lane when she struck the OPMV#1. OPMV#2 Stated she was entering the turn lane to make a right turn onto Commonwealth Ave and didn't notice there was a car already in the lane. OPMV#2 Stated she felt distracted due to the heavy rain and lights at the intersection.
Keywords:
Distracted, Rain
Dcc:
Visibility obstructed, Distracted
Report
url:
Image
url:
Latitude:
42.3478859
Longitude:
-71.247136
Location:
Case
number:
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:
Image
url:
Latitude:
42.31672
Longitude:
-71.1946315
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);