29 responses to “US Cities and State SQL Dump”

  1. Yash

    Thanks for sharing with us

  2. yep

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

  3. Lucianoc

    Thanks a lot!

  4. Dinesh samarasekara

    thanks you very much,

    it was very help full

  5. Rooky

    非常感谢 (Thanks)

  6. huge

    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;

  7. Santosh Maurya

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

  8. Antonio

    thanks a lot, this is very helpful

  9. Yogendra

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

  10. gregor

    thanks a lot man!

  11. Roman


  12. Eventi in Emilia Romagna

    Thank you so much for this great DB!

  13. pkwebmarket

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

  14. BrainRaider

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

  15. ashish

    Great 🙂 thanks for sharing.

  16. Asif

    Thanks A ton, my friend 🙂

  17. Dilip

    Its really helps man. thanks a lot. 🙂

  18. shashank

    thanks a ton man…….

  19. jer

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

  20. overclucker

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

    phpmyadmin is probably the tool you are looking for.

  21. gembel

    Holly Shit! You’ve made my day…!


  22. Jang Hedel

    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

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

  24. pep

    thanks a lot, and thank you for sharing this

  25. Anton

    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

    Very thanks dude.

  27. Eoin H

    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

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