29

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 than 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 | Tagged , , | 29 Responses

29 responses to “US Cities and State SQL Dump”

  1. Yash
    Yash September 20, 2009 at 8:38 am |

    Thanks for sharing with us

  2. yep
    yep September 30, 2009 at 8:50 pm |

    all the props – you have save me a great deal of time

  3. Lucianoc
    Lucianoc January 22, 2010 at 10:10 am |

    Thanks a lot!

  4. Dinesh samarasekara
    Dinesh samarasekara March 10, 2010 at 3:08 am |

    thanks you very much,

    it was very help full

  5. Rooky
    Rooky April 6, 2010 at 10:38 pm |

    非常感谢 (Thanks)

  6. huge
    huge May 13, 2010 at 2:39 am |

    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;

  7. Santosh Maurya
    Santosh Maurya December 2, 2010 at 11:32 pm |

    Thanks for your kind help…. its really very useful and usable….:)

  8. Antonio
    Antonio April 30, 2011 at 11:04 pm |

    thanks a lot, this is very helpful

  9. Yogendra
    Yogendra May 18, 2011 at 12:47 am |

    Hi, Thank you so much. It helps me a lots.

  10. gregor
    gregor July 3, 2011 at 1:31 am |

    thanks a lot man!

  11. Roman
    Roman July 6, 2011 at 2:32 am |

    Thanksssssssssssssss

  12. Eventi in Emilia Romagna
    Eventi in Emilia Romagna January 14, 2012 at 6:58 am |

    Thank you so much for this great DB!

  13. pkwebmarket
    pkwebmarket January 22, 2012 at 5:26 am |

    Thanks so much for sharing this.
    It help me a lot.
    🙂

  14. BrainRaider
    BrainRaider February 28, 2012 at 7:21 am |

    Thanks so much for sharing this.
    It help me a lot too )

  15. ashish
    ashish February 29, 2012 at 12:18 am |

    Great 🙂 thanks for sharing.

  16. Asif
    Asif May 25, 2012 at 10:54 pm |

    Thanks A ton, my friend 🙂

  17. Dilip
    Dilip June 28, 2012 at 5:38 am |

    Its really helps man. thanks a lot. 🙂

  18. shashank
    shashank July 23, 2012 at 12:51 pm |

    thanks a ton man…….

  19. jer
    jer July 29, 2012 at 1:55 am |

    hi,
    how would i go about importing this into a wordpress database in order to use it like a directory? thanks.

  20. overclucker
    overclucker August 5, 2012 at 9:49 pm |

    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.

  21. gembel
    gembel August 10, 2012 at 11:45 am |

    Holly Shit! You’ve made my day…!

    Thanks

  22. Jang Hedel
    Jang Hedel August 24, 2012 at 4:16 pm |

    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!

  23. Marc
    Marc September 21, 2012 at 11:53 am |

    Thanks a million. This is the only listing of US cities in a downloadable file I found, period. -Marc

  24. pep
    pep October 25, 2012 at 4:21 pm |

    thanks a lot, and thank you for sharing this

  25. Anton
    Anton November 6, 2012 at 12:11 am |

    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 😉

  26. Truong Vu
    Truong Vu December 11, 2012 at 6:41 pm |

    Very thanks dude.

  27. Eoin H
    Eoin H March 29, 2013 at 2:28 pm |

    Thanks for sharing 🙂 Its gonna make life designing sites that need a state and city search much quicker to set up the database.. cheers!

  28. SLB
    SLB July 25, 2013 at 5:41 am |

    this is really useful,
    but how can i get such resource (Cities and State SQL Dump) for every other country.

  29. Dimas
    Dimas July 25, 2013 at 10:42 am |

    Try geonames.org or List of cities by country