crash_reports
3 rows where date = "2019-12-17" and keywords contains "Rain"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-12-17
Time:
12:05
Address:
GROVE ST & PIERREPONT RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of Vehicle # 1 states she was traveling straight ahead at the speed limit (30 mph) (SB) on Grove Street approaching Pierrepont Road when she lost control of the vehicle due to the ice/slush on the roadway. She then veered off to the right side of the road and struck Verizon utility pole number 85/155 with her front end head on at Grove and Pierrepont Rd. I observed heavy front end damage to the front end/passenger side front of the vehicle and it was towed by Tody's. There was no damage to the utility pole. There is a decline in elevation to the roadway in this area and the road conditions were slippery due to the current snowstorm that was producing snow and freezing rain at the time.
Keywords:
Ice, Rain, Snow, Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3320655
Longitude:
-71.2565313
Location:
Case
number:
Date:
2019-12-17
Time:
13:58
Address:
OLDE FIELD RD & BOYLSTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1(MA reg.8TX383) was traveling eastbound on Boylston Street when she attempted to turn right onto Olde Field Road. MV1 began to slide due to the heavy slush from rain and snow fall. MV1 struck the stop sign on the east side corner. The street sign was knocked over and MV1 had minor damage to the front drivers side bumper No one was injured, damage was minimal and dispatch notified DPW of the damage to the stop sign. Photos were not taken.
Keywords:
Pictures, Rain, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3188446
Longitude:
-71.192125
Location:
Case
number:
Date:
2019-12-17
Time:
14:47
Address:
717 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date and time I responded to 717 Centre St for a report of a crash involving two vehicles. The weather was snowy / rainy/ sleeting, and the roadway was a mixture of ice/ snow. Upon arrival on scene I spoke with the operator of V1 Ms. Howe, she stated she was traveling south on Centre St when V2 stopped abruptly. Ms. Howes stated she applied the brakes and her vehicle would nt stop due to the icy roadway and she had contact with V2. I then spoke with the operator of V2, Ms. Nunnally stated that a vehicle had abruptly pulled out of the driveway of 717 Centre St. She stated she applied her brakes immediately to avoid contact and pulled to the right. She stated when she stopped she felt rear impact from V2. Both parties had no injuries at this time. V2 was towed by Todys towing to 1354 Washington Street Newton. Ms. Howe removed valuables from the vehicle. At this time it appears the icy roadway was a contributing factor of the crash.
Keywords:
Crash, Ice, Rain, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.347321
Longitude:
-71.1892941
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);