Full SQL dump of cities and states data. There are three tables in all: states, cities, and cities_extended. All packaged in a nice (less then 1MB) ZIP file for your convenience!
If you’ve found this post you are more then likely searching for a quick and easy SQL dump of USA cities and states to add to your project. I do not claim this data to be my own, like you, I was also searching online for a simple SQL dump, only to find pages that took forever to load and dumps that I had to copy and paste, what a pain.
The Goods
states (state, state_code)
cities (city, state_code)
cities_extended (city, state_code, zip, latitude, longitude, county)
This is the extended version of the cities table allowing you to do a lot more cool things with the additional data provided (think google maps, geocoding, distance calculators, etc.)
Download
US Cities and States (880 KB)
Very thanks dude.
Thanks for sharing
Its gonna make life designing sites that need a state and city search much quicker to set up the database.. cheers!