crash_reports
1 row where dcc contains "Failed to yield" and street1 = "SOUTH EDDY ST"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-02
Time:
18:28
Address:
EDDY ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Monday, December 2nd, 2019 at approximately 1828 hours I, Officer Newton, and Officer Brooks responded to a 3 car motor vehicle accident at Watertown St and Eddy St. The operator of vehicle 1 stated he was stopped at the stop sign on Eddy St southbound when he proceeded to pull out to cross Watertown St when Vehicle 2, traveling eastbound on Watertown St, hit their car causing them to also collide with vehicle 3. The operator of vehicle 2 stated she was driving eastbound on Watertown St. when vehicle 1 suddenly pulled out in front of her causing the collision. The operator of vehicle 3 stated she was at the stop sign on Eddy St northbound, opposite of vehicle 1's stop sign on Eddy St, when Vehicle 1 pulled out and caused vehicle 2 to hit vehicle 1 and vehicle 2 to hit her. All parties involved declined medical attention. All 3 vehicles were able to safely drive away from the scene.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3526115
Longitude:
-71.217724
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);