米国の州のSQLデータ

ご自由にご利用ください。country_idは1にしています:

INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (1,'Alabama','AL',1,990);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (2,'Alaska','AK',1,980);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (3,'Arizona','AZ',1,970);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (4,'Arkansas','AR',1,960);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (5,'California','CA',1,950);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (6,'Colorado','CO',1,940);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (7,'Connecticut','CT',1,930);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (8,'Delaware','DE',1,920);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (9,'Florida','FL',1,910);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (10,'Georgia','GA',1,900);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (11,'Hawaii','HI',1,890);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (12,'Idaho','ID',1,880);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (13,'Illinois','IL',1,870);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (14,'Indiana','IN',1,860);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (15,'Iowa','IA',1,850);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (16,'Kansas','KS',1,840);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (17,'Kentucky','KY',1,830);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (18,'Louisiana','LA',1,820);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (19,'Maine','ME',1,810);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (20,'Maryland','MD',1,800);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (21,'Massachusetts','MA',1,790);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (22,'Michigan','MI',1,780);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (23,'Minnesota','MN',1,770);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (24,'Mississippi','MS',1,760);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (25,'Missouri','MO',1,750);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (26,'Montana','MT',1,740);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (27,'Nebraska','NE',1,730);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (28,'Nevada','NV',1,720);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (29,'New Hampshire','NH',1,710);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (30,'New Jersey','NJ',1,700);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (31,'New Mexico','NM',1,690);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (32,'New York','NY',1,680);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (33,'North Carolina','NC',1,670);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (34,'North Dakota','ND',1,660);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (35,'Ohio','OH',1,650);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (36,'Oklahoma','OK',1,640);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (37,'Oregon','OR',1,630);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (38,'Pennsylvania','PA',1,620);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (39,'Rhode Island','RI',1,610);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (40,'South Carolina','SC',1,600);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (41,'South Dakota','SD',1,590);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (42,'Tennessee','TN',1,580);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (43,'Texas','TX',1,570);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (44,'Utah','UT',1,560);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (45,'Vermont','VT',1,550);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (46,'Virginia','VA',1,540);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (47,'Washington','WA',1,530);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (48,'West Virginia','WV',1,520);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (49,'Wisconsin','WI',1,510);
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (50,'Wyoming','WY',1,500);