Eight states along the Mississippi River endured the longest period of flooding since the Great Flood of 1927