May
21
Written by:
Steve Gray
5/21/2010 2:47 PM
-- State Table courtesy statetable.com
CREATE TABLE FPState (id integer, name varchar(255), abbreviation varchar(255), country varchar(255), type varchar(255), sort integer, status varchar(255), occupied varchar(255), notes varchar(255));
INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('1','Alabama','AL','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('2','Alaska','AK','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('3','Arizona','AZ','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('4','Arkansas','AR','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('5','California','CA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('6','Colorado','CO','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('7','Connecticut','CT','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('8','Delaware','DE','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('9','Florida','FL','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('10','Georgia','GA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('11','Hawaii','HI','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('12','Idaho','ID','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('13','Illinois','IL','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('14','Indiana','IN','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('15','Iowa','IA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('16','Kansas','KS','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('17','Kentucky','KY','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('18','Louisiana','LA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('19','Maine','ME','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('20','Maryland','MD','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('21','Massachusetts','MA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('22','Michigan','MI','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('23','Minnesota','MN','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('24','Mississippi','MS','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('25','Missouri','MO','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('26','Montana','MT','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('27','Nebraska','NE','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('28','Nevada','NV','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('29','New Hampshire','NH','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('30','New Jersey','NJ','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('31','New Mexico','NM','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('32','New York','NY','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('33','North Carolina','NC','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('34','North Dakota','ND','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('35','Ohio','OH','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('36','Oklahoma','OK','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('37','Oregon','OR','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('38','Pennsylvania','PA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('39','Rhode Island','RI','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('40','South Carolina','SC','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('41','South Dakota','SD','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('42','Tennessee','TN','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('43','Texas','TX','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('44','Utah','UT','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('45','Vermont','VT','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('46','Virginia','VA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('47','Washington','WA','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('48','West Virginia','WV','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('49','Wisconsin','WI','USA','state','10','current','occupied','');INSERT INTO FPState (id,name,abbreviation,country,type,sort,status,occupied,notes) VALUES ('50','Wyoming','WY','USA','state','10','current','occupied','');