crash_reports
2 rows where dcc = "["Failed to yield", "Inattention"]", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-29
Time:
16:31
Address:
716 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPMV#1 Was traveling Eastbound on Beacon St when she was struck by the OPMV#2 pulling out of the Gulf Gas Station located at 716 Beacon St. OPMV#1 Stated she was driving straight on Beacon St when a car pulled out of the gas station and collided with her vehicle. OPMV#2 Was pulling out of the Gulf Gas Station attempting to make a right turn onto Beacon St traveling Eastbound when he collided with the OPMV#1. OPMV#2 Stated he looked both ways before making a right turn but believes a utility pole blocked his view causing a blind spot, when he struck a vehicle driving on Beacon St..
Keywords:
[]
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3306362
Longitude:
-71.1900994
Location:
Case
number:
Date:
2019-12-02
Time:
16:20
Address:
853 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV 1 was traveling Westbound on Beacon St when MV 2 pulled out of the driveway of 853 Beacon St and struck his right rear side. MV 2 was traveling Southbound entering traffic from the 853 Beacon St driveway when she struck the right side of MV 1. The operator of MV 2 suffered minor back injury and was transported by Cataldo Ambulance to Newton Wellesley.
Keywords:
Ems
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3304045
Longitude:
-71.1960787
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);