I haven't gone state by state to look at how many duplicates there were (I went back to the original file), but there was nearly two dozen in Idaho alone. Something in your process screwed up Lat/Long because the Idaho cities in it would've been around Ohio.
(I'm honestly not trying to knock all the work you did for it, just trying to help figure out what happened...)