text: CREATE TABLE subdivision_US (id VARCHAR(6) NOT NULL, name VARCHAR(255) NOT NULL, level VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
  
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-AL', 'Alabama', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-AK', 'Alaska', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-AS', 'Amerikaans-Samoa', 'outlying area');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-AZ', 'Arizona', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-AR', 'Arkansas', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-CA', 'Californië', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-CO', 'Colorado', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-CT', 'Connecticut', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-DE', 'Delaware', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-FL', 'Florida', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-GA', 'Georgia', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-GU', 'Guam', 'outlying area');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-HI', 'Hawaï', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-ID', 'Idaho', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-IL', 'Illinois', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-IN', 'Indiana', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-IA', 'Iowa', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-KS', 'Kansas', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-KY', 'Kentucky', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-LA', 'Louisiana', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-ME', 'Maine', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MD', 'Maryland', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MA', 'Massachusetts', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MI', 'Michigan', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MN', 'Minnesota', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MS', 'Mississippi', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MO', 'Missouri', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MT', 'Montana', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-NE', 'Nebraska', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-NV', 'Nevada', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-NH', 'New Hampshire', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-NJ', 'New Jersey', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-NM', 'New Mexico', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-NY', 'New York', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-NC', 'North Carolina', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-ND', 'North Dakota', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-MP', 'Noordelijke Marianen', 'outlying area');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-OH', 'Ohio', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-OK', 'Oklahoma', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-OR', 'Oregon', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-PA', 'Pennsylvania', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-PR', 'Puerto Rico', 'outlying area');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-RI', 'Rhode Island', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-SC', 'South Carolina', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-SD', 'South Dakota', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-TN', 'Tennessee', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-TX', 'Texas', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-UM', 'Kleine afgelegen eilanden van de Verenigde Staten', 'outlying area');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-UT', 'Utah', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-DC', 'Washington D.C.', 'district');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-VT', 'Vermont', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-VI', 'Maagdeneilanden', 'outlying area');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-VA', 'Virginia', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-WA', 'Washington', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-WV', 'West Virginia', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-WI', 'Wisconsin', 'state');
  INSERT INTO `subdivision_US` (`id`, `name`, `level`) VALUES ('US-WY', 'Wyoming', 'state');
  