US Cities and State SQL Dump

US Map

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)

Posted in Downloads | Tagged data, Downloads, sql dump | 27 Responses

27 responses to “US Cities and State SQL Dump”

Yash September 20, 2009 at 8:38 am | Permalink

Thanks for sharing with us
yep September 30, 2009 at 8:50 pm | Permalink

all the props – you have save me a great deal of time
Lucianoc January 22, 2010 at 10:10 am | Permalink

Thanks a lot!
Dinesh samarasekara March 10, 2010 at 3:08 am | Permalink

thanks you very much,

it was very help full
Rooky April 6, 2010 at 10:38 pm | Permalink

非常感谢 (Thanks)
huge May 13, 2010 at 2:39 am | Permalink

thanks a mil. the cities_extended doesnt have a key primary field.. if people need this (should really) here is the code to add it in phpmyadmin etc.
ALTER TABLE cities_extended AUTO_INCREMENT = 0;
ALTER TABLE cities_extended ADD id INT NOT NULL AUTO_INCREMENT KEY;
Santosh Maurya December 2, 2010 at 11:32 pm | Permalink

Thanks for your kind help…. its really very useful and usable….:)
Antonio April 30, 2011 at 11:04 pm | Permalink

thanks a lot, this is very helpful
Yogendra May 18, 2011 at 12:47 am | Permalink

Hi, Thank you so much. It helps me a lots.
gregor July 3, 2011 at 1:31 am | Permalink

thanks a lot man!
Roman July 6, 2011 at 2:32 am | Permalink

Thanksssssssssssssss
Eventi in Emilia Romagna January 14, 2012 at 6:58 am | Permalink

Thank you so much for this great DB!
pkwebmarket January 22, 2012 at 5:26 am | Permalink

Thanks so much for sharing this.
It help me a lot.
BrainRaider February 28, 2012 at 7:21 am | Permalink

Thanks so much for sharing this.
It help me a lot too )
ashish February 29, 2012 at 12:18 am | Permalink

Great thanks for sharing.
Asif May 25, 2012 at 10:54 pm | Permalink

Thanks A ton, my friend
Dilip June 28, 2012 at 5:38 am | Permalink

Its really helps man. thanks a lot.
shashank July 23, 2012 at 12:51 pm | Permalink

thanks a ton man…….
jer July 29, 2012 at 1:55 am | Permalink

hi,
how would i go about importing this into a wordpress database in order to use it like a directory? thanks.
overclucker August 5, 2012 at 9:49 pm | Permalink

Thank you very much! Data like this is so tedious to collect and insert. You should consider creating a repository for this.

@jer
phpmyadmin is probably the tool you are looking for.
gembel August 10, 2012 at 11:45 am | Permalink

Holly Shit! You’ve made my day…!

Thanks
Jang Hedel August 24, 2012 at 4:16 pm | Permalink

I used your SQL for my web site: Distance calculator and I have to say thank you for sharing this.

Very handy sql data to use in projects, thanks again!
Marc September 21, 2012 at 11:53 am | Permalink

Thanks a million. This is the only listing of US cities in a downloadable file I found, period. -Marc
pep October 25, 2012 at 4:21 pm | Permalink

thanks a lot, and thank you for sharing this
Anton November 6, 2012 at 12:11 am | Permalink

Thx a lot! I’ll be using it for my website. It’s very usefull!

And yes, cities_extended should have ID key or something