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.
Anonymous says
Very handy, thanks!
Anonymous says
Thank you so much.
Sam says
Much appreciated. Thank you!
John says
thanks!!! This really helped me and saved a lot of time!!!
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”
Nikolai Rasputin says
Thank you oh so very much.
Anonymous says
Thanks!
Dan Moore
Jarett says
Thanks. This page is the first result in Google for “us states list csv”, by the way.
ROIGuy says
Thanks. Just what the doctor ordered. Let me know if we can return the favor to you sometime.
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.
http://www.census.gov/popest/cities/SUB-EST2007-4.html
Kudithipudi says
Thank you very much for the SQL..Saved me a bunch of time..
Anonymous says
Thanks a million… Or at least 50.
nomadic says
Thanks a lot for the data
JRedd Designs says
Awesome! Thanks for the time saver!!
chris hough says
awesome, thank you so much for this time saver
Justin says
You are the man!!! Many thanks from New York! ๐
Jessica says
this is exactly what i needed! saves me many valuable minutes. thanks from a busy non-profiteer!
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!
Travis says
Thank you, saved me some time.
Victor says
Thanks a lot
JohnF says
Thanks – your site is at the top of Google search, so nice job on the SEA..
JohnF says
Sorry, SEO..