crash_reports
1 row where "datetime" is on date 2020-06-26, dcc = "["Failed to yield"]" and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-06-26
Time:
08:54
Address:
SUTCLIFFE PK & WINCHESTER ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of veh #1 stated he was driving due North on Winchester St. when veh #2 suddenly turned in front of him. Heavy damage to veh #1 as it was towed from the scene by Tody's Towing. The operator of veh #2 stated he was driving his work delivery truck due South on Winchester St. when he looked down the road and then down Sutcliffe Pk as he turned. The operator stated he failed to look back at Winchester St and that's when he struck veh #1. Light damage to veh #2. Operator of veh #2 cited in hand Mass# T2080844 N.C.O. Ch19/Sec75-Failure to use care in turning. No reported injuries on scene. All roads mentioned/traveled upon in this report are public ways in this city as they are serviced and maintained by the City of Newton.
Keywords:
Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3080595
Longitude:
-71.2066997
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);