crash_reports
1 row where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2021-04-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-08
Time:
17:07
Address:
BEACON ST & WALNUT ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Operator of MV1 states she was traveling southbound on Walnut Street entering the intersection at Beacon Street when MV2 failed to yield to MV1 by attempting to take a left hand turn onto Beacon Street westbound causing MV2 to crash into MV1. MV1 sustained damage to the front left fender and was towed from the scene. Operator of MV2 states he was traveling northbound on Walnut Street approaching the intersection at Beacon Street where he wanted to make a left hand turn onto Beacon Street westbound. Operator of MV2 states the left arrow traffic signal was yellow then turned green and he still proceeded to take a left hand turn while there was oncoming traffic traveling southbound on Walnut Street. Operator of MV2 states he failed to yield to MV1 causing MV2 to crash into MV1. MV2 sustained front end damage and was towed from the scene. Operator of MV2 was issued in hand Massachusetts Uniform Citation #T2012867 for MGL Ch. 89 Sec. 8 Fail to Yield, Right of way No injuries reported.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
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);