crash_reports
1 row where dcc = "["Failed to yield"]" and "retrieved" is on date 2021-01-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-14
Time:
16:17
Address:
582 BEACON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
On 1/14/21 I was working N496 when I responded to the area of 582 Beacon for a two car MVA. Upon arrival I spoke with the operator of Veh 1 (Linda Feeley) and the operator of Veh 2 (Sharon King). Linda Feeley stated that she had taken a left onto Beacon St. from the right lane of the Hammond pond parkway. As the two lanes turned into one the driver behind her refused to merge and sideswiped her vehicle. I then spoke with the operator of vehicle 2 Sharon King who stated she was in the left hand lane turning left from Hammond pond parkway onto Beacon St., as the two lanes turn into one the driver in front of her refused to merge and sideswiped her vehicle. Both parties stated they were not injured. Both parties were provided an accident report number.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3315682
Longitude:
-71.1838318
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);