13

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 | Tagged , , | 13 Responses

13 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.
    :)

Leave a Reply