crash_reports
1 row where date = "2020-10-07" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-07
Time:
11:40
Address:
791 WALNUT ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On Wednesday, October 7th 2020 while in N526 I responded to 791 Walnut Street the Newton Cemetery Corp for a motor vehicle accident involving a pedestrian. At the time of the accident the weather was sunny and the road surface was dry. The accident occurred inside the cemetery on the public way by the entrance. Upon arrival I spoke with the pedestrian identified as Tova Goldring. Tova stated she was walking in the roadway when she was struck by MV1. Tova stated MV1 was turning left onto the road that leads to the exit and when she realized the operator was not stopping she put out both her hands and made contact with the hood of MV1. Tova stated the impact caused her to fall to the ground and roll into a grassy area next to the road. Tova had minor scrapes from the accident and signed a patient refusal. The operator of MV1 identified as Antonio Domenico Ricci was on scene and his primary language was Italian. I was able to contact his daughter, Daniela Boccia who arrived on scene and translated Antonio's statements. Antonio stated he was turning left onto the main road that leads to the exit of the cemetery and had his left signal activated. Antonio states the sun was glaring into his eyes and made it hard for him to see. Antonio stated he took the left turn and never saw the pedestrian. Antonio states he heard a thud on his hood and stopped the vehicle and that is when he realized he had struck a pedestrian. Antonio was not injured and there was no damage to his vehicle. Pictures of the scene and Tova's injuries were taken by Officer Wilson and submitted to the IT Bureau. Daniela took possession of MV1 and drove Antonio to his residence.
Keywords:
Crash, Ped, Pictures, Solar, Walk
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.333885
Longitude:
-71.2079645
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);