crash_reports
1 row where dcc = "["Failed to yield"]", intersection = 0 and "retrieved" is on date 2021-09-28
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-15
Time:
08:00
Address:
945 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 09/15/21 at approximately 08:00 I responded to the intersection of the Rt. 9 East off ramp and Chestnut St for a report of a two vehicle crash. Upon arrival I found the operator of veh #1 pulled into the driveway of #742 Chestnut St. The operator of veh #1 stated she was driving South on Chestnut St when veh #2 drove from her right off the exit ramp without stopping and struck her in the passenger side front. Operator #1 stated operator #2 gave her a license but she never got the license plate or insurance company. I queried operator #2 and came up with the registration and insurance company to give operator #1. Unknown damage to vehicle #2. Veh #1 was towed by David and Tody's Towing with moderate damage. I tried calling Operator #2 and leaving a message but it is unknown if I have the correct phone number for her at this time.
Keywords:
Crash, Moderate, Phone
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3165095
Longitude:
-71.2260176
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);