crash_reports
3 rows where dcc = "["Glare"]", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-17
Time:
09:45
Address:
2040 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Francis Vincent was operating vehicle #1 W/B on Comm Ave. Francis states that he was driving and looking at traffic straight ahead. Francis states that he drove into a green dumpster that was left on the side of the road by Star Market. Francis states that he did not see the dumpster because it blended in with the tree line. I spoke with Star Market Manager Joe Granata. Joe stated that the disposal company was brining a new dumpster and the dumpster was left in the street so the exchange could be made. No injures, vehicle #1 towed by Todys
Keywords:
Tree
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
Case
number:
Date:
2019-11-15
Time:
06:55
Address:
258 DERBY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 was travelling eastbound on Derby Street when she collided with the rear of the attached trailer on MV2, which was parked on the side of the road in front of 258 Derby St. Operator of MV1 stated due to the sun glare she did not see the landscaping truck and trailer. MV1 sustained heavy front end damage and was towed by Tody's Towing. MV2 had very minor damage to the rear trailer and license plate. Operator of MV1 was evaluated by Cataldo and signed a patient refusal. MV2 was unoccupied at the time of the crash.
Keywords:
Crash, Glare, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3593744
Longitude:
-71.2344741
Location:
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);