As they say, I had an itch to scratch.

When someone registers on a site and you want their address, it’s good practice to have a “state/province” selector.  Building that requires you to have a list of states somewhere, usually in your database, and usually in a table called “state”.

So, I whipped up a little site called statetable.com, which generates the SQL script you need to create that table.  It can also include Canadian provinces, US territories, and even US Minor Outlying Islands (atolls & reefs nobody really gives a damn about).  Don’t want SQL?  It’ll spit out a CSV file you can open in Excel, OpenOffice.org Calc, Numbers, etc.