Is there a publicly available list of the US States in machine readable form?

sql csv list lookup
user59861 picture user59861 · Jan 31, 2009 · Viewed 8.2k times · Source

Where can I find a list of the US States in a form for importing into my database?

SQL would be ideal, otherwise CSV or some other flat file format is fine.

Edit: Complete with the two letter state codes

Answer

John picture John · Jan 31, 2009

I needed this a few weeks ago and put it on my blog as SQL and Tab Delimited. The data was sourced from wikipedia in early January so should be up to date.

US States: http://www.john.geek.nz/index.php/2009/01/sql-tips-list-of-us-states/

I use the Worlds Simplest Code Generator if I need to add columns or remove some of the fields - http://secretgeek.net/wscg.asp

I've also done Countries of the world and International Dialling Codes too.
Countries: http://www.john.geek.nz/index.php/2009/01/sql-tips-list-of-countries/
IDC's: http://www.john.geek.nz/index.php/2009/01/sql-tips-list-of-international-dialling-codes-idcs/

Edit: New: Towns and cities of New Zealand

Related questions

How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More
Import CSV file into SQL Server

I am looking for help to import a .csv file into SQL Server using BULK INSERT and I have few basic questions. Issues: The CSV file data may have , (comma) in between (Ex: description), so how can I make import …

Read More
Save PL/pgSQL output from PostgreSQL to a CSV file

What is the easiest way to save PL/pgSQL output from a PostgreSQL database to a CSV file? I'm using PostgreSQL 8.4 with pgAdmin III and PSQL plugin where I run queries from.

Read More