Two people were found dead in Northern California floodwaters amid an atmospheric river that dumped a record amount of rain.