U.S. States CSV / SQL

I needed a mySQL table containing the common names of the U.S. States and their two letter abbreviations. I quickly Googled and couldn’t find anything. Maybe I didn’t search long enough. All I found was a Wikipedia article that listed them.

I grabbed the contents, formatted them with BBEdit to a CSV and imported them into mySQL. Just so no one else has to do that, here you go: state.csv, state.sql

Hope this helps someone.

22 Responses to “U.S. States CSV / SQL”

  1. Anonymous says:

    Very handy, thanks!

  2. Anonymous says:

    Thank you so much.

  3. Sam says:

    Much appreciated. Thank you!

  4. John says:

    thanks!!! This really helped me and saved a lot of time!!!

  5. Spoom says:

    Hi Scott,

    Found your list quite useful. I added Canadian provinces for a site I’m working on so I figured I would post it here.

    “British Columbia “,”BC”
    “New Brunswick”,”NB”
    “New Foundland”,”NL”
    “Northwest Territories”,”NT”
    “Nova Scotia”,”NS”
    “Prince Edward Island”,”PE”
    “Yukon Territory”,”YT”
    “New Hampshire”,”NH”
    “New Jersey”,”NJ”
    “New Mexico”,”NM”
    “New York”,”NY”
    “North Carolina”,”NC”
    “North Dakota”,”ND”
    “Rhode Island”,”RI”
    “South Carolina”,”SC”
    “South Dakota”,”SD”
    “West Virginia”,”WV”

  6. Nikolai Rasputin says:

    Thank you oh so very much.

  7. Anonymous says:


    Dan Moore

  8. Jarett says:

    Thanks. This page is the first result in Google for “us states list csv”, by the way.

  9. ROIGuy says:

    Thanks. Just what the doctor ordered. Let me know if we can return the favor to you sometime.

  10. tbone says:

    http://www.Broomfield-Designers.com thanks you for the custom code. We needed cities too…..

    For cities, we used this.
    Gov’t census data by state. Cut out the first row from each one for the city data. Add them as you need them. Alabama is 461 cities for instance.


  11. Kudithipudi says:

    Thank you very much for the SQL..Saved me a bunch of time..

  12. Anonymous says:

    Thanks a million… Or at least 50.

  13. nomadic says:

    Thanks a lot for the data

  14. JRedd Designs says:

    Awesome! Thanks for the time saver!!

  15. chris hough says:

    awesome, thank you so much for this time saver

  16. Justin says:

    You are the man!!! Many thanks from New York! 😉

  17. Jessica says:

    this is exactly what i needed! saves me many valuable minutes. thanks from a busy non-profiteer!

  18. Michael says:

    Just like everyone else, this saved me a ton of time. It's people like you who make the internet so wonderful. Thanks!

  19. Travis says:

    Thank you, saved me some time.

  20. Victor says:

    Thanks a lot

  21. JohnF says:

    Thanks – your site is at the top of Google search, so nice job on the SEA..

  22. JohnF says:

    Sorry, SEO..