crash_reports
1 row where dcc = "["Distracted"]", intersection = 0 and "retrieved" is on date 2021-08-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-26
Time:
16:51
Address:
CHESTNUT ST.
Speed
limit:
25
Violation
cited:
no
Narrative:
On 7/26/21 I was working N495 when I was traveling northbound on Chestnut St. at Pineridge Rd. I observed a 2 car MVA. I spoke with both parties who stated they were uninjured. The operator of Veh 1 Steven Pierce stated he was traveling southbound on Chestnut St. when a pedestrian attempted to cross the road. Pierce stated he slowed down to allow the pedestrian to cross when he was rear ended by Veh 2. I spoke with the operator of Veh 2 Rielly Fitzgerald who stated he was traveling southbound on Chestnut St. when he reached down to get his water. Rielly stated when he looked back on the road the vehicle in front of him had come to stop. Reilly attempted to come to a stop but collided with Veh 1. Both parties were provided a report number. Veh 2 was towed by Todys.
Keywords:
Ped
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3307093
Longitude:
-71.2247899
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);