crash_reports
2 rows where dcc contains "Failed to yield" and "retrieved" is on date 2022-05-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-26
Time:
17:01
Address:
345 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 stated he was attempting to pull into traffic when he made contact with MV2 causing minor damage. MV2 stated he was travelling straight when MV1 pulled out and hit him causing minor damage. No injuries reported & no tows required.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3568934
Longitude:
-71.1877425
Location:
Case
number:
Date:
2022-04-27
Time:
08:26
Address:
CHESTNUT ST & DAVIS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of Vehicle #1 stated that as he was travelling Southbound on Chestnut St, he collided with Vehicle #2 as it attempted to make a left turn from Davis St onto Chestnut St. The operator of Vehicle #2 stated that he looked prior to the left turn, but didn't see any vehicles in his path prior to the collision with Vehicle #1. The operator of Vehicle #1 was transported to Newton-Wellesley Hospital as a result of the collision. The operator of Vehicle #2 was seen by the medics, but declined to be transported. A routine query revealed that Vehicle #2 was unregistered. As a result, the vehicle was cited, and towed.
Keywords:
Citation, Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3485635
Longitude:
-71.2252516
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);