text: CREATE TABLE subdivision_US (id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-AL', E'Alabama', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-AK', E'Alasca', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-AS', E'Samoa Americana', E'outlying area');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-AZ', E'Arizona', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-AR', E'Arkansas', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-CA', E'Califórnia', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-CO', E'Colorado', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-CT', E'Connecticut', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-DE', E'Delaware', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-FL', E'Flórida', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-GA', E'Geórgia', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-GU', E'Guam', E'outlying area');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-HI', E'Havaí', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-ID', E'Idaho', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-IL', E'Illinois', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-IN', E'Indiana', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-IA', E'Iowa', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-KS', E'Kansas', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-KY', E'Kentucky', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-LA', E'Luisiana', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-ME', E'Maine', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MD', E'Maryland', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MA', E'Massachusetts', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MI', E'Michigan', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MN', E'Minnesota', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MS', E'Mississippi', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MO', E'Missouri', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MT', E'Montana', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-NE', E'Nebraska', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-NV', E'Nevada', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-NH', E'Nova Hampshire', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-NJ', E'Nova Jersey', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-NM', E'Novo México', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-NY', E'Nova Iorque', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-NC', E'Carolina do Norte', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-ND', E'Dakota do Norte', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-MP', E'Marianas Setentrionais', E'outlying area');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-OH', E'Ohio', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-OK', E'Oklahoma', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-OR', E'Oregon', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-PA', E'Pensilvânia', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-PR', E'Porto Rico', E'outlying area');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-RI', E'Rhode Island', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-SC', E'Carolina do Sul', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-SD', E'Dakota do Sul', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-TN', E'Tennessee', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-TX', E'Texas', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-UM', E'Ilhas Menores Distantes dos Estados Unidos', E'outlying area');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-UT', E'Utah', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-DC', E'Washington, D.C.', E'district');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-VT', E'Vermont', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-VI', E'Ilhas Virgens', E'outlying area');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-VA', E'Virgínia', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-WA', E'Washington', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-WV', E'Virgínia Ocidental', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-WI', E'Wisconsin', E'state');
  INSERT INTO "subdivision_US" ("id", "name", "level") VALUES (E'US-WY', E'Wyoming', E'state');
  