crash_reports
4 rows where intersection = 0, keywords contains "Ice" and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, violation_cited, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-17
Time:
10:58
Address:
1874 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated he was travelling Westbound on Washington St. The road conditions at that time was covered in Slush and ice. Operator #1 stated as he was rounding a slight bend in the Rd. His vehicle continued to slide to the left and into oncoming Eastbound traffic. Vehicle #1 Then collided with vehicle #2. Operator of vehicle #2 stated he was traveling Eastbound on Washington St. when vehicle #1 slid into his travel lane, striking his vehicle head on. He stated vehicle #2 then Struck vehicle #3 which had been driving eastbound to his right. Operator of Vehicle #3 stated he was travelling Eastbound when his vehicle was struck by Vehicle #2 which caused his vehicle to spin out of control and into the Westbound travel lane where his vehicle struck Vehicle #4. Vehicle #3 then struck the fence owned by the Woodland Golf Club. Operator #4 stated she was travelling Westbound when vehicle #3 spun out of control and struck her vehicle. Operator stated she attempted to stop but was unable to due to the poor Rd. conditions.
Keywords:
Ice
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3352873
Longitude:
-71.2420805
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:
Case
number:
Date:
2019-12-17
Time:
19:29
Address:
244 LEXINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was traveling SOUTH on Lexington St when it collided with MV2 while it was backing out of a driveway ( 244 Lexington St). MV2 sustained damage to its rear driver's side. MV1 did not have any damage as it was suited with a plow mounted in front. MV2 operator was transported to NWH due to head/facial injuries from the steering wheel. Conditions of the road were extremely icy. Tody's towed MV2 from the driveway of 244 Lexington St.
Keywords:
Ice
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3534427
Longitude:
-71.2447531
Location:
Case
number:
Date:
2019-12-30
Time:
10:03
Address:
268 DEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 12/30/19 I responded to a single vehicle crash on Dedham St. outside of #268. The operator stated she was traveling due North on Dedham St at 25mph when she lost control of her vehicle due to icy conditions. Tracing back the vehicles tires marks in the slush, the car appeared to cross the double yellow lines near Brush Hill Rd and then back to the correct lane sideways before striking the curb, then a city tree in front of #268 Dedham St. There were multiple air bag deployments in the vehicle. Ambulance #1 arrived on scene and transported the operator due to a complaint of right chest pain from the seatbelt. N523 Traffic Officer Wilson arrived on scene and took pictures of the damage to the city tree. The vehicle was towed by Tody's Towing and the operator was mailed Mass. citation # T2013422 for Ch90/sec17-Speeding (too fast for conditions).
Keywords:
Citation, Crash, Ems, Ice, Pictures, Tree
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3109112
Longitude:
-71.202243
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);