crash_reports
2 rows where dcc = "["Glare"]", intersection = 0 and keywords contains "Ems"
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:
Case
number:
Date:
2021-07-28
Time:
16:30
Address:
991 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was exiting the parking lot of 991 Watertown St when he collided with MV2. MV2 was travelling EB on Watertown St when she was struck on the drivers side by MV1. No injuries to Operator 1, Operator 2 was transported by Fallon ambulance with minor injuries. MV1 was driven from the scene with very minor damage. MV2 was parked on Watertown St awaiting Operator 2's release from the hospital. MV2 sustained minor damage to the drivers side Photos taken and placed into IT.
Keywords:
Ems, Hospital, Pictures
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.349735
Longitude:
-71.225836
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);