crash_reports
1 row where "datetime" is on date 2019-02-08 and keywords contains "Ped"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-08
Time:
19:56
Address:
309 TREMONT STREET
Speed
limit:
35
Violation
cited:
no
Narrative:
On 02/08/2019, I, Officer Conary, responded to 309 Tremont Street for a past hit and run involving a pedestrian. Upon arrival, I was met by FEBLOWITZ, Colleen, who stated at approximately 1745 hours, she was crossing in the crosswalk at Tremont at Hibbard when her foot was hit by a car. FEBLOWITZ explained to me that she was in the crosswalk and she saw a silver sedan, MV1, traveling Eastbound on Tremont Street approaching her but it was far away where she felt safe to walk across the street. She said she also raised her hand to draw attention to herself. FEBLOWITZ was halfway in the crosswalk when she felt severe pain in her right foot. She looked behind her and saw MV1 was very close to her. MV1 continued to drive down Tremont Street and not stop. There were no witnesses. FEBLOWITZ went to Partner's Urgent Care to be treated for minor injuries. The crosswalk is in a lighted roadway. FEBLOWITZ was unable to gain any other information on MV1. No further incident to report.
Keywords:
Crosswalk, Ped, Severe, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3549421
Longitude:
-71.1808005
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);