This doesn't even have to be scripted--someone can probably do this by hand in about 1 hour. Here is all we need.
1. Go to [url removed, login to view] You will see a list of US states and territories.
2. If you click on any of the states, you will see a list of cities within that state.
All we need is the following:
An excel (or csv) file that has all of the cities in the first column and their corresponding states in the second column. We need this done for all cities for all states and we want it to be in a single file. If you use Excel, please put it in a single tab in the file. Example of a few data entries attached.