crash_reports
1 row where "datetime" is on date 2019-12-20 and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-20
Time:
12:39
Address:
175 BOYLSTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of vehicle one, Christopher Sermak, stated that while turning north bound in the parking lot of 175 Boylston St he was blinded by solar glare. Sermak stated that the diver's side visor was down and the he was not wearing sun glasses. Sermak stated that he heard a loud bang coming from the front driver's side of his vehicle and realized that his vehicle had stuck something. Sermak stated that he stopped his vehicle and saw a male identified as John Baker laying on his back on the ground. Baker stated that he had step off the side walk in front of 175 Boylston St and was walking to his car when he saw Sermak's vehicle approaching him and realized it was not slowing, Baker sated that the front driver's side of Sermak's vehicle struck his right arm and shoulder causing him to be knocked to the ground on his back. Baker stated that his head struck the ground but he did not lose consciousness. Baker was transported to Newton Wellesley Hospital via EMS for treatment. While on scene I observed that the rear passenger side brake light of Sermak's vehicle was out. I issued Sermak MA Citation T 2012527 and cited him for violations of City of Newton City Ordnance 19-75, failure to use care while tuning , and MGL 90/7 , defective lights.
Keywords:
Citation, Ems, Glare, Hospital, Solar, Walk
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3216347
Longitude:
-71.1749764
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);