crash_reports
2 rows where keywords contains "Ped" 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:
Case
number:
Date:
2021-08-01
Time:
14:36
Address:
AUSTIN ST & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 8-1-21 AT APPROX. 1436HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF AUSTIN AND WALNUT ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING S-BOUND ON WALNUT. WHILE DRIVING HE WAS HIT IN THE RIGHT SIDE BY VEHICLE #2 AS HE EXITED AUSTIN ST. DRIVER OF VEHICLE #2 STATES HE WAS STOPPED AT THE STOP SIGN ON AUSTIN ST WAITING TO MERGE ONTO WALNUT. HE STATES HE WAITED FOR A PEDESTRIAN WHO DECIDED TO NOT CROSS THE STREET. AS HE ENTERED ONTO WALNUT HE HIT VEHICLE #1. VEHICLE #1 HAD RIGHT SIDE DAMAGE. VEHICLE #2 HAD FRONT LEFT SIDE DAMAGE. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT. NEITHER VEHICLE WAS TOWED.
Keywords:
Crash, Ped
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3505802
Longitude:
-71.2069457
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);