Firelight

Illumination from the residents of Firefall, LLC

U.S. States CSV / SQL

by

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.

Comments

  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.

    “Alberta”,”AB”
    “British Columbia “,”BC”
    “Manitoba”,”MB”
    “New Brunswick”,”NB”
    “New Foundland”,”NL”
    “Northwest Territories”,”NT”
    “Nova Scotia”,”NS”
    “Nunavut”,”NU”
    “Ontario”,”ON”
    “Prince Edward Island”,”PE”
    “Quebec”,”QC”
    “Saskatchewan”,”SK”
    “Yukon Territory”,”YT”
    “Alabama”,”AL”
    “Alaska”,”AK”
    “Arizona”,”AZ”
    “Arkansas”,”AR”
    “California”,”CA”
    “Colorado”,”CO”
    “Connecticut”,”CT”
    “Delaware”,”DE”
    “Florida”,”FL”
    “Georgia”,”GA”
    “Hawaii”,”HI”
    “Idaho”,”ID”
    “Illinois”,”IL”
    “Indiana”,”IN”
    “Iowa”,”IA”
    “Kansas”,”KS”
    “Kentucky”,”KY”
    “Louisiana”,”LA”
    “Maine”,”ME”
    “Maryland”,”MD”
    “Massachusetts”,”MA”
    “Michigan”,”MI”
    “Minnesota”,”MN”
    “Mississippi”,”MS”
    “Missouri”,”MO”
    “Montana”,”MT”
    “Nebraska”,”NE”
    “Nevada”,”NV”
    “New Hampshire”,”NH”
    “New Jersey”,”NJ”
    “New Mexico”,”NM”
    “New York”,”NY”
    “North Carolina”,”NC”
    “North Dakota”,”ND”
    “Ohio”,”OH”
    “Oklahoma”,”OK”
    “Oregon”,”OR”
    “Pennsylvania”,”PA”
    “Rhode Island”,”RI”
    “South Carolina”,”SC”
    “South Dakota”,”SD”
    “Tennessee”,”TN”
    “Texas”,”TX”
    “Utah”,”UT”
    “Vermont”,”VT”
    “Virginia”,”VA”
    “Washington”,”WA”
    “West Virginia”,”WV”
    “Wisconsin”,”WI”
    “Wyoming”,”WY”

  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.

  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!

  21. JohnF says

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