crash_reports
1 row where keywords contains "Hospital" and "retrieved" is on date 2021-01-12
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-01-08
Time:
07:06
Address:
FARWELL ST & NORTH ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated they were traveling Southbound on North St. and attempted to take a left Eastbound onto Farwell St. Operator of MV1 stated they hit a pedestrian with the left front end of their vehicle at the intersection. Operator of MV1 stated they did not see the pedestrian attempting to cross the street. There was minor surface damage to the left front end of the vehicle. Pedestrian 1 stated they were attempting to walk across at the intersection of Farwell St. @ North St. when MV1 struck them in their left hip causing them to fall down. Pedestrian 1 was wearing a green shirt and gray pants. Pedestrian 1 was transported by Waltham EMS to Newton-Wellesley Hospital. Pictures of the scene were taken and submitted to the IT Bureau.
Keywords:
Ems, Hospital, Ped, Pictures, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3623524
Longitude:
-71.2177025
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);