Officials in Connecticut say two women died after being swept away by floodwaters brought by torrential rains that fell there and on New York's Long Island