crash_reports
1 row where "datetime" is on date 2019-07-01, dcc contains "Followed too closely" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-01
Time:
15:15
Address:
31 NAHANTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated that she was traveling on Nahanton street and stopped to let a golfer cross the street from one side of the country club to the other. Vehicle #1 was rear ended by Vehicle #2 and sustained heavy rear end damage. Vehicle #1 was towed from the scene by David from Tody's. The operator of Vehicle #2 stated that he was traveling on Nahanton Street when a golfer ran across the street in front of Vehicle #1. Operator stated that he couldn't stop and struck Vehicle #1. Vehicle #2 sustained front end damage and was towed from the scene by Bobby from Todys. Both operators were picked up from the scene. No injuries were reported. It should be noted that there is no crosswalk at the location of the crash.
Keywords:
Crash, Crosswalk
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3002782
Longitude:
-71.1892941
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);