crash_reports
1 row where keywords contains "Ped" and "retrieved" is on date 2021-02-10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-02-08
Time:
05:21
Address:
WASHINGTON ST & CRAFTS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/8/21 I was working N491 when I responded to an MVA PED on Washington St. at Crafts St.. Upon arrival I spoke with Dennis Delicata who stated that he was traveling southbound on Crafts St. when he turned left onto Washington St. during a green light a pedestrian later identified as Jamie Correia ran out in front of his truck and he struck him. Delicata stated the Jamie was traveling in the travel lane of Washington St. going Eastbound across the intersection not in the crosswalk and he did not see him in time. Delicata stated he slammed on his brakes however could not stop in time. Delicata stated he got out of his truck and rendered aid to Correia who was complaining of pain in his back and shoulder. Delicata stated that Correia said to him "I thought I could make it". I spoke with Jamie Correia who was being evaluated by the medics. Correia said he was running across the intersection headed Eastbound and thought he could make it across. Medics transported Correia to NWH. Delicata's vehicle suffered minor damage and was driven away from the scene. Pictures were taken and submitted to IT.
Keywords:
Crosswalk, Ped, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3539555
Longitude:
-71.1989863
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);