Useful SQL script: States and Provinces

...

INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('AL','Alabama','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('AK','Alaska','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('AS','American Samoa','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('AZ','Arizona','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('AR','Arkansas','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('CA','California','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('CO','Colorado','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('CT','Connecticut','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('DE','Delaware','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('DC','District of Columbia','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('FM','Federated States of Micronesia','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('FL','Florida','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('GA','Georgia','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('GU','Guam','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('HI','Hawaii','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('ID','Idaho','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('IL','Illinois','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('IN','Indiana','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('IA','Iowa','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('KS','Kansas','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('KY','Kentucky','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('LA','Louisiana','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('ME','Maine','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MH','Marshall Islands','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MD','Maryland','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MA','Massachusetts','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MI','Michigan','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MN','Minnesota','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MS','Mississippi','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MO','Missouri','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MT','Montana','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NE','Nebraska','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NV','Nevada','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NH','New Hampshire','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NJ','New Jersey','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NM','New Mexico','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NY','New York','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NC','North Carolina','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('ND','North Dakota','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MP','Northern Mariana Islands','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('OH','Ohio','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('OK','Oklahoma','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('OR','Oregon','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('PW','Palau','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('PA','Pennsylvania','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('PR','Puerto Rico','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('RI','Rhode Island','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('SC','South Carolina','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('SD','South Dakota','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('TN','Tennessee','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('TX','Texas','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('UT','Utah','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('VT','Vermont','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('VA','Virginia','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('VI','Virgin Islands','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('WA','Washington','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('WV','West Virginia','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('WI','Wisconsin','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('WY','Wyoming','state','USA');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('AB','Alberta','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('BC','British Columbia','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('MB','Manitoba','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NB','New Brunswick','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NF','Newfoundland','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NT','Northwest Territories','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('NS','Nova Scotia','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('ON','Ontario','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('PE','Prince Edward Island','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('QC','Quebec','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('SK','Saskatchewan','province','Canada');
INSERT INTO StatesProvinces(Abbr, State, Type, Country) VALUES('YT','Yukon','province','Canada');

Leave a Reply