text: CREATE TABLE subdivision (country VARCHAR(2) NOT NULL, id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AD', E'AD-07', E'Andorra la Vella', E'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AD', E'AD-02', E'Parrocchia di Canillo', E'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AD', E'AD-03', E'Parrocchia di Encamp', E'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AD', E'AD-08', E'Parrocchia di Escaldes-Engordany', E'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AD', E'AD-04', E'Parrocchia di La Massana', E'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AD', E'AD-05', E'Parrocchia di Ordino', E'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AD', E'AD-06', E'Parrocchia di Sant Julià de Lòria', E'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-1', E'Burgenland', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-2', E'Carinzia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-3', E'Bassa Austria', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-5', E'Salisburgo', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-6', E'Stiria', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-7', E'Tirolo', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-4', E'Alta Austria', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-9', E'Vienna', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'AT', E'AT-8', E'Vorarlberg', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BY', E'BY-HM', E'Minsk', E'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-VAN', E'Anversa', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-BRU', E'Regione di Bruxelles-Capitale', E'capital region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-VOV', E'Provincia delle Fiandre Orientali', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-VBR', E'Provincia del Brabante Fiammingo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-WLG', E'Liegi', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-WLX', E'Lussemburgo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-WAL', E'Vallonia', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-WBR', E'Provincia del Brabante Vallone', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'BE', E'BE-VWV', E'Provincia delle Fiandre Occidentali', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-AB', E'Alberta', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-BC', E'Columbia Britannica', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-MB', E'Manitoba', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-NB', E'Nuovo Brunswick', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-NL', E'Terranova e Labrador', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-NT', E'Territori del Nord-Ovest', E'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-NS', E'Nuova Scozia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-NU', E'Nunavut', E'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-ON', E'Ontario', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-PE', E'Isola del Principe Edoardo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-QC', E'Québec', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-SK', E'Saskatchewan', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CA', E'CA-YT', E'Yukon', E'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-AN', E'Antofagasta', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-AP', E'Regione di Arica e Parinacota', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-AT', E'Deserto di Atacama', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-AI', E'Regione di Aysén', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-CO', E'Coquimbo', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-LL', E'Los Lagos', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-LR', E'Los Ríos', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-MA', E'Magallanes', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-ML', E'Maule', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-RM', E'Regione Metropolitana di Santiago', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-TA', E'Tarapacá', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CL', E'CL-VS', E'Valparaíso', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-070', E'Aarhus', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-040', E'Bornholm', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-84', E'Capitale', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-82', E'Jutland centrale', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-015', E'Copenaghen', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-020', E'Frederiksborg', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-042', E'Fionia', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-83', E'Syddanmark', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-055', E'Ribe', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-065', E'Ringkøbing', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-025', E'Roskilde', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-050', E'Jutland meridionale', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-035', E'Storstrøm', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-030', E'Zelanda occidentale', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DK', E'DK-85', E'Zelanda', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-37', E'Harjumaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-39', E'Hiiumaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-44', E'Ida-Virumaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-51', E'Järvamaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-49', E'Jõgevamaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-59', E'Lääne-Virumaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-57', E'Läänemaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-67', E'Pärnumaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-65', E'Põlvamaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-70', E'Raplamaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-74', E'Saaremaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-78', E'Tartumaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-82', E'Valgamaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-84', E'Viljandimaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'EE', E'EE-86', E'Võrumaa', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-01', E'Ain', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-02', E'Aisne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-03', E'Allier', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-06', E'Alpi Marittime', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-A', E'Alsazia', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-B', E'Aquitania', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-08', E'Ardenne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-07', E'Ardèche', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-09', E'Ariège', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-10', E'Aube', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-11', E'Aude', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-12', E'Aveyron', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-67', E'Basso Reno', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-13', E'Bocche del Rodano', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-D', E'Borgogna', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-14', E'Calvados', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-15', E'Cantal', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-F', E'Center', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-G', E'Champagne-Ardenne', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-16', E'Charente', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-17', E'Charente Marittima', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-18', E'Cher', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-CP', E'Clipperton', E'dependency');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-19', E'Corrèze', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-2A', E'Corsica del Sud', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-H', E'Corsica', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-23', E'Creuse', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-79', E'Deux-Sèvres', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-24', E'Dordogna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-25', E'Doubs', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-26', E'Drôme', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-91', E'Essonne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-27', E'Eure', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-28', E'Eure-et-Loir', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-29', E'Finistère', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-I', E'Franca Contea', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-30', E'Gard', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-32', E'Gers', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-33', E'Gironda', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-GP', E'Guadalupa', E'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-68', E'Alto Reno', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-2B', E'Alta Corsica', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-31', E'Alta Garonna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-P', E'Bassa Normandia', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-GF', E'Guyana francese', E'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-43', E'Alta Loira', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-52', E'Alta Marna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-74', E'Alta Savoia', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-70', E'Alta Saona', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-87', E'Alta Vienne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-05', E'Alte Alpi', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-65', E'Alti Pirenei', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-92', E'Hauts-de-Seine', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-34', E'Hérault', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-35', E'Ille-et-Vilaine', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-36', E'Indre', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-37', E'Indre e Loira', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-38', E'Isère', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-39', E'Giura', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-K', E'Linguadoca-Rossiglione', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-41', E'Loir-et-Cher', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-42', E'Loira', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-44', E'Loira Atlantica', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-45', E'Loiret', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-M', E'Lorraine', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-46', E'LOT', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-47', E'Lot e Garonna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-48', E'Lozère', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-49', E'Maine e Loira', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-50', E'Manica', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-51', E'Marna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-MQ', E'Martinica', E'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-53', E'Mayenne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-YT', E'Mayotte', E'territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-54', E'Meurthe e Mosella', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-55', E'Mosa', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-N', E'Midi-Pirenei', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-56', E'Morbihan', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-57', E'Mosella', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-58', E'Nièvre', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-59', E'Nord', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-O', E'Nord-Passo di Calais', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-60', E'Oise', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-61', E'Orne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-75', E'Parigi', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-62', E'Passo di Calais', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-R', E'Paesi della Loira', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-S', E'Piccardia', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-T', E'Poitou-Charentes', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-Q', E'Alta Normandia', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-PF', E'Polinesia francese', E'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-NC', E'Nuova Caledonia', E'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-RE', E'Riunione', E'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-U', E'Provenza-Alpi-Costa Azzurra', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-63', E'Puy-de-Dôme', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-64', E'Pirenei Atlantici', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-66', E'Pirenei Orientali', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-69', E'Rodano', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-V', E'Rodano-Alpi', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-72', E'Sarthe', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-73', E'Savoia', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-71', E'Saona e Loira', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-76', E'Senna Marittima', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-93', E'Senna-Saint-Denis', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-77', E'Senna e Marna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-80', E'Somme', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-82', E'Tarn e Garonna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-90', E'Territorio di Belfort', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-94', E'Valle della Marna', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-83', E'VAR', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-84', E'Vaucluse', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-85', E'Vandea', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-86', E'Vienne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-88', E'Vosgi', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-89', E'Yonne', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-78', E'Yvelines', E'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-J', E'Île-de-France', E'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-MF', E'Saint-Martin', E'overseas territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-BL', E'Saint-Barthélemy', E'overseas territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-PM', E'Saint-Pierre e Miquelon', E'territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'FR', E'FR-WF', E'Wallis e Futuna', E'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-BW', E'Baden-Württemberg', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-BY', E'Baviera', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-BE', E'Berlino', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-BB', E'Brandeburgo', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-HB', E'Brema', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-HH', E'Amburgo', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-HE', E'Assia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-NI', E'Bassa Sassonia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-MV', E'Meclemburgo-Pomerania Anteriore', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-NW', E'Renania Settentrionale-Vestfalia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-RP', E'Renania-Palatinato', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-SL', E'Saarland', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-SN', E'Sassonia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-ST', E'Sassonia-Anhalt', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-SH', E'Schleswig-Holstein', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'DE', E'DE-TH', E'Turingia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GH', E'GH-AH', E'Ashanti', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GH', E'GH-BA', E'Regione di Brong-Ahafo', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GH', E'GH-CP', E'Central', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GH', E'GH-AA', E'Regione della Grande Accra', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GH', E'GH-UE', E'Regione Nordorientale', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GH', E'GH-TV', E'Volta', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GH', E'GH-WP', E'Western', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-AN', E'Andamane e Nicobare', E'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-AP', E'Andhra Pradesh', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-AR', E'Arunachal Pradesh', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-AS', E'Assam', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-BR', E'Bihar', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-CH', E'Chandigarh', E'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-CT', E'Chhattisgarh', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-DN', E'Dadra e Nagar Haveli', E'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-DD', E'Daman e Diu', E'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-DL', E'Delhi', E'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-GA', E'Goa', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-GJ', E'Gujarat', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-HR', E'Haryana', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-HP', E'Himachal Pradesh', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-JK', E'Jammu e Kashmir', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-JH', E'Jharkhand', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-KA', E'Karnataka', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-KL', E'Kerala', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-LD', E'Laccadive', E'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-MP', E'Madhya Pradesh', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-MH', E'Maharashtra', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-MN', E'Manipur', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-ML', E'Meghalaya', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-MZ', E'Mizoram', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-NL', E'Nagaland', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-OR', E'Orissa', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-PY', E'Pondicherry', E'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-PB', E'Punjab', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-RJ', E'Rajasthan', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-SK', E'Sikkim', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-TN', E'Tamil Nadu', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-TR', E'Tripura', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-UP', E'Uttar Pradesh', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-UT', E'Uttarakhand', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IN', E'IN-WB', E'Bengala Occidentale', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-CW', E'Carlow', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-CN', E'Cavan', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-CE', E'Clare', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-LS', E'Laois', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-OY', E'Offaly', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-WH', E'Westmeath', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-DL', E'Donegal Town', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-D', E'Dublino', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-G', E'Galway', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-KY', E'Kerry', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-KE', E'Kildare', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-KK', E'Kilkenny', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-L', E'Leinster', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-LK', E'Limerick', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-LD', E'Longford', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-LH', E'Louth', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-MO', E'Mayo', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-MN', E'Monaghan', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-M', E'Munster', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-RN', E'Roscommon', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-SO', E'Sligo', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-TA', E'Tipperary', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-U', E'Ulster', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-WD', E'Waterford', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-WX', E'Wexford', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IE', E'IE-WW', E'Wicklow', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IL', E'IL-M', E'Distretto Centrale', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IL', E'IL-HA', E'Haifa', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IL', E'IL-JM', E'Gerusalemme', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IL', E'IL-D', E'Distretto Meridionale', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IL', E'IL-TA', E'Tel Aviv', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-65', E'Abruzzo', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AG', E'Agrigento', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AL', E'Alessandria', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AN', E'Ancona', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AO', E'Aosta', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AR', E'Arezzo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AP', E'Ascoli Piceno', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AT', E'Asti', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-AV', E'Avellino', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BA', E'Bari', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-77', E'Basilicata', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BL', E'Belluno', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BN', E'Benevento', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BG', E'Bergamo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BI', E'Biella', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BO', E'Bologna', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BZ', E'Bolzano', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BS', E'Brescia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BR', E'Brindisi', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CA', E'Cagliari', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-78', E'Calabria', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CL', E'Caltanissetta', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-72', E'Campania', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CB', E'Campobasso', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CE', E'Caserta', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CT', E'Catania', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CZ', E'Catanzaro', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CH', E'Chieti', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CO', E'Como', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CS', E'Cosenza', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CR', E'Cremona', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-KR', E'Crotone', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CN', E'Cuneo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-45', E'Emilia-Romagna', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-EN', E'Enna', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-FM', E'Fermo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-FE', E'Ferrara', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-FI', E'Firenze', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-FG', E'Foggia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-FO', E'Forlì', E'');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-36', E'Friuli-Venezia Giulia', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-FR', E'Frosinone', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-GE', E'Genova', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-GO', E'Gorizia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-GR', E'Grosseto', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-IM', E'Imperia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-IS', E'Isernia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-BT', E'Provincia di Barletta-Andria-Trani', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-CI', E'Provincia di Carbonia-Iglesias', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-FC', E'Provincia di Forlì-Cesena', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-75', E'Puglia', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-SP', E'La Spezia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-62', E'Lazio', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-LE', E'Lecce', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-LC', E'Lecco', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-42', E'Liguria', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-LI', E'Livorno', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-LO', E'Lodi', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-25', E'Lombardia', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-LU', E'Lucca', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MC', E'Macerata', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MN', E'Mantova', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-57', E'Marche', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MT', E'Matera', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-ME', E'Messina', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MI', E'Milano', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MO', E'Modena', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-67', E'Molise', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-NA', E'Napoli', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-NO', E'Novara', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-NU', E'Nuoro', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-OR', E'Oristano', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PD', E'Padova', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PA', E'Palermo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PR', E'Parma', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PV', E'Pavia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PG', E'Perugia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PE', E'Pescara', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PC', E'Piacenza', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-21', E'Piemonte', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PI', E'Pisa', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PT', E'Pistoia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PN', E'Pordenone', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PZ', E'Potenza', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PO', E'Prato', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MS', E'Provincia di Massa e Carrara', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MA', E'Provincia del Medio Campidano', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-MB', E'Provincia di Monza e della Brianza', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-OL', E'Provincia di Olbia-Tempio', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-PU', E'Provincia di Pesaro e Urbino', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-RG', E'Ragusa', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-RA', E'Ravenna', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-RC', E'Reggio Calabria', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VB', E'Provincia del Verbano-Cusio-Ossola', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-RI', E'Rieti', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-RN', E'Rimini', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-RM', E'Roma', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-RO', E'Rovigo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-SA', E'Salerno', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-88', E'Sardegna', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-SS', E'Sassari', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-SV', E'Savona', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-82', E'Sicilia', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-SI', E'Siena', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-SO', E'Sondrio', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TA', E'Taranto', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TE', E'Teramo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TR', E'Terni', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TP', E'Trapani', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-32', E'Trentino-Alto Adige', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TN', E'Trento', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TV', E'Treviso', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TS', E'Trieste', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-TO', E'Torino', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-52', E'Toscana', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-UD', E'Udine', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-55', E'Umbria', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VA', E'Varese', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-34', E'Veneto', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VE', E'Venezia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VC', E'Vercelli', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VR', E'Verona', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VV', E'Vibo Valentia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VI', E'Vicenza', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'IT', E'IT-VT', E'Viterbo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'LU', E'LU-D', E'Diekirch', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'LU', E'LU-G', E'Grevenmacher', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'LU', E'LU-L', E'Lussemburgo', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-AW', E'Aruba', E'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-BQ1', E'Bonaire', E'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-CW', E'Curaçao', E'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-DR', E'Drenthe', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-FL', E'Flevoland', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-FR', E'Frisia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-GE', E'Gheldria', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-GR', E'Groninga', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-NB', E'Brabante Settentrionale', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-NH', E'Olanda Settentrionale', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-OV', E'Overijssel', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-BQ2', E'Saba', E'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-BQ3', E'Sint Eustatius', E'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-SX', E'Sint Maarten', E'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-ZH', E'Olanda Meridionale', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-UT', E'Utrecht', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NL', E'NL-ZE', E'Zelanda', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-02', E'Akershus', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-09', E'Aust-Agder', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-06', E'Buskerud', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-20', E'Finnmark', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-04', E'Hedmark', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-12', E'Hordaland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-22', E'Jan Mayen', E'');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-15', E'Møre og Romsdal', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-17', E'Nord-Trøndelag', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-18', E'Nordland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-05', E'Oppland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-03', E'Oslo', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-11', E'Rogaland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-14', E'Sogn og Fjordane', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-21', E'Isole Svalbard', E'');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-16', E'Sør-Trøndelag', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-08', E'Telemark', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-19', E'Troms', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-10', E'Vest-Agder', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-07', E'Vestfold', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'NO', E'NO-01', E'Østfold', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-WP', E'Voivodato della Grande Polonia', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-KP', E'Voivodato della Cuiavia-Pomerania', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-MA', E'Voivodato della Piccola Polonia', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-DS', E'Voivodato della Bassa Slesia', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-LU', E'Voivodato di Lublino', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-LB', E'Voivodato di Lubusz', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-MZ', E'Voivodato della Masovia', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-OP', E'Voivodato di Opole', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-PK', E'Voivodato della Precarpazia', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-PD', E'Voivodato della Podlachia', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-PM', E'Voivodato della Pomerania', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-SL', E'Voivodato della Slesia', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-WN', E'Voivodato della Varmia-Masuria', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-ZP', E'Voivodato della Pomerania Occidentale', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PL', E'PL-SK', E'Voivodato della Santacroce', E'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-01', E'Aveiro', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-20', E'Azzorre', E'autonomous region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-02', E'Beja', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-03', E'Braga', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-04', E'Bragança', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-06', E'Coimbra', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-08', E'Faro', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-09', E'Guarda', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-10', E'Leiria', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-11', E'Lisbona', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-30', E'Madera', E'autonomous region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-12', E'Portalegre', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-13', E'Oporto', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-14', E'Santarém', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-15', E'Setúbal', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-18', E'Viseu', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'PT', E'PT-07', E'Évora', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-BC', E'Bacău', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-BN', E'Distretto di Bistrița-Năsăud', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-BT', E'Botoșani', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-BV', E'Brașov', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-BR', E'Brăila', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-B', E'Bucarest', E'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-BZ', E'Buzău', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-CS', E'Distretto di Caraș-Severin', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-CJ', E'Cluj-Napoca', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-CT', E'Costanza', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-CV', E'Covasna', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-CL', E'Călăraşi', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-DJ', E'Distretto di Dolj', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-GL', E'Galați', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-GR', E'Giurgiu', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-GJ', E'Distretto di Gorj', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-HR', E'Distretto di Harghita', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-HD', E'Hunedoara', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-IS', E'Iași', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-IF', E'Distretto di Ilfov', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-MM', E'Maramureş', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-MH', E'Distretto di Mehedinți', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-MS', E'Distretto di Mureș', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-NT', E'Distretto di Neamț', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-SM', E'Satu Mare', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-SB', E'Sibiu', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-SV', E'Suceava', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-TR', E'Distretto di Teleorman', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-TL', E'Tulcea', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-VS', E'Vaslui', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RO', E'RO-VL', E'Distretto di Vâlcea', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-00', E'Belgrado', E'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-14', E'Distretto di Bor', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-11', E'Distretto di Braničevo', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-02', E'Distretto del Banato Centrale', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-23', E'Distretto di Jablanica', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-09', E'Distretto di Kolubara', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-08', E'Distretto di Mačva', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-17', E'Distretto di Moravica', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-20', E'Distretto di Nišava', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-03', E'Distretto del Banato Settentrionale', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-01', E'Distretto della Bačka Settentrionale', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-22', E'Distretto di Pirot', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-10', E'Distretto di Podunavlje', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-13', E'Distretto di Pomoravlje', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-24', E'Distretto di Pčinja', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-19', E'Distretto di Rasina', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-04', E'Distretto del Banato Meridionale', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-07', E'Distretto della Sirmia', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-16', E'Distretto di Zlatibor', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-12', E'Distretto di Šumadija', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-28', E'Distretto di Kosovska Mitrovica', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-26', E'Distretto di Peć', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'RS', E'RS-27', E'Distretto di Prizren', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SK', E'SK-BC', E'Regione di Banská Bystrica', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SK', E'SK-BL', E'Regione di Bratislava', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SK', E'SK-KI', E'Regione di Košice', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SK', E'SK-NI', E'Regione di Nitra', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SK', E'SK-PV', E'Regione di Prešov', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SK', E'SK-TA', E'Regione di Trnava', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SK', E'SK-ZI', E'Regione di Žilina', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-C', E'La Coruña', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-AB', E'Albacete', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-A', E'Alicante', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-AL', E'Almería', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-AN', E'Andalusia', E'');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-AS', E'Asturie', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-BA', E'Badajoz', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-IB', E'Isole Baleari', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-B', E'Barcellona', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-BU', E'Burgos', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CA', E'Cadice', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-S', E'Cantabria', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CS', E'Castelló', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CM', E'Castiglia-La Mancia', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CL', E'Castiglia e León', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CT', E'Catalogna', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CE', E'Ceuta', E'autonomous city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CR', E'Ciudad Real', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CU', E'Cuenca', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CC', E'Cáceres', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-CO', E'Córdoba', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-EX', E'Estremadura', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-GA', E'Galizia', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-SS', E'Guipúzcoa', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-GI', E'Girona', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-GR', E'Granada', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-GU', E'Guadalajara', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-H', E'Huelva', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-HU', E'Huesca', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-J', E'Jaen', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-GC', E'Las Palmas de Gran Canaria', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-LE', E'Leon', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-L', E'Lleida', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-LU', E'Lugo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-MD', E'Madrid', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-ML', E'Melilla', E'autonomous city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-MC', E'Murcia', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-MA', E'Málaga', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-NC', E'Navarra', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-OR', E'Ourense', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-P', E'Palencia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-PO', E'Pontevedra', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-SA', E'Salamanca', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-TF', E'Santa Cruz de Tenerife', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-SG', E'Segovia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-SE', E'Siviglia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-SO', E'Soria', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-T', E'Tarragona', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-TE', E'Teruel', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-TO', E'Toledo', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-V', E'Valencia', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-VC', E'Comunità Valenzana', E'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-VA', E'Valladolid', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-ZA', E'Zamora', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-Z', E'Saragozza', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'ES', E'ES-VI', E'Álava', E'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-K', E'Blekinge', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-W', E'Dalarna', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-I', E'Gotland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-X', E'Gävleborg', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-N', E'Halland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-Z', E'Jämtland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-F', E'Jönköping', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-H', E'Kalmar', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-G', E'Kronoberg', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-BD', E'Norrbotten', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-M', E'Scania', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-AB', E'Stoccolma', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-D', E'Södermanland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-C', E'Uppsala', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-S', E'Värmland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-AC', E'Västerbotten', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-Y', E'Västernorrland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-U', E'Västmanland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-O', E'Västra Götaland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-T', E'Örebro', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'SE', E'SE-E', E'Östergötland', E'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-AG', E'Canton Argovia', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-AR', E'Canton Appenzello Esterno', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-AI', E'Canton Appenzello Interno', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-BL', E'Canton Basilea Campagna', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-BS', E'Canton Basilea Città', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-BE', E'Berna', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-FR', E'Friburgo', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-GL', E'Glarona', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-GR', E'Cantone dei Grigioni', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-JU', E'Giura', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-NE', E'Neuchâtel', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-NW', E'Canton Nidvaldo', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-OW', E'Canton Obvaldo', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-SG', E'San Gallo', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-SH', E'Sciaffusa', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-SZ', E'Svitto', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-SO', E'Soletta', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-TG', E'Canton Turgovia', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-TI', E'Canton Ticino', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-UR', E'URI', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-VS', E'Canton Vallese', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-VD', E'Canton Vaud', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-ZG', E'Zugo', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-GE', E'Ginevra', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-LU', E'Lucerna', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'CH', E'CH-ZH', E'Zurigo', E'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'UA', E'UA-43', E'Crimea', E'autonomous republic');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'UA', E'UA-30', E'Kiev', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'UA', E'UA-40', E'Sebastopoli', E'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ARD', E'ARD', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ABE', E'Aberdeen', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ABD', E'Aberdeenshire', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ANS', E'Angus', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ANT', E'Antrim', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-AGB', E'Argyll e Bute', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ARM', E'Armagh', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BLA', E'Ballymena', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BNB', E'Banbridge', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BNS', E'Barnsley', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BAS', E'Bath and North East Somerset', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BDF', E'Bedfordshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BFS', E'Belfast', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BIR', E'Birmingham', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BBD', E'Blackburn with Darwen', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BPL', E'Blackpool', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BGW', E'Blaenau Gwent', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BOL', E'Bolton', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BMH', E'Bournemouth', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BRC', E'Bracknell Forest', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BRD', E'Bradford', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BEN', E'Brent', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BGE', E'Bridgend', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BNH', E'Brighton & Hove', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BST', E'Bristol', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BKM', E'Buckinghamshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BUR', E'Bury', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CAY', E'Caerphilly', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CLD', E'Calderdale', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CAM', E'Cambridgeshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CMD', E'Camden', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CRF', E'Cardiff', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CMN', E'Carmarthenshire', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CKF', E'Carrickfergus', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CGN', E'Ceredigion', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CHS', E'Cheshire', E'');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CLK', E'Clackmannanshire', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CLR', E'Coleraine', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CWY', E'Conwy', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CON', E'Cornovaglia', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-COV', E'Coventry', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-BDG', E'Barking e Dagenham', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-FER', E'Fermanagh', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-CMA', E'Cumbria', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DAL', E'Darlington', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DEN', E'Denbighshire', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DER', E'Derby', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DBY', E'Derbyshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DRY', E'Derry', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DEV', E'Devon', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DNC', E'Doncaster', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DOR', E'Dorset', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DOW', E'Down', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DUD', E'Dudley', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DGY', E'Dumfries e Galloway', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DND', E'Dundee', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DGN', E'Distretto di Dungannon e South Tyrone', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-DUR', E'Durham', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-EAL', E'Ealing', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-EAY', E'Ayrshire Orientale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-EDU', E'Dunbartonshire Orientale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ELN', E'East Lothian', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ERW', E'Renfrewshire Orientale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ERY', E'East Riding of Yorkshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ESX', E'East Sussex', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-EDH', E'Edimburgo', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ENF', E'Enfield', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ESS', E'Essex', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-FAL', E'Falkirk', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-FIF', E'Fife', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-FLN', E'Flintshire', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-GAT', E'Gateshead', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-GLG', E'Glasgow', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-GLS', E'Gloucestershire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-GRE', E'Greenwich', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-GWN', E'Gwynedd', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-HAL', E'Halton', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-HAM', E'Hampshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-HPL', E'Hartlepool', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-HEF', E'Herefordshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-HRT', E'Hertfordshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-IVC', E'Inverclyde', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-HMF', E'Hammersmith e Fulham', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-HAV', E'Havering', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ELS', E'Ebridi Esterne', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-AGY', E'Anglesey', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LND', E'Città di Londra', E'city corporation');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-IOW', E'Isola di Wight', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-IOS', E'Isole Scilly', E'');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-KEN', E'Kent', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-KHL', E'Kingston upon Hull', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-KTT', E'Kingston upon Thames', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-KIR', E'Kirklees', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LBH', E'Lambeth', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LAN', E'Lancashire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LRN', E'Larne', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LDS', E'Leeds', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LCE', E'Leicester', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LEC', E'Leicestershire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LIN', E'Lincolnshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LSB', E'Lisburn', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LIV', E'Liverpool', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NWM', E'Newham', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-LUT', E'Luton', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MAN', E'Manchester', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MDW', E'Medway', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MTY', E'Merthyr Tydfil', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MDB', E'Middlesbrough', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MLN', E'Midlothian', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MIK', E'Milton Keynes', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MON', E'Monmouthshire', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-MRY', E'Moray', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NTL', E'Neath Port Talbot', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NET', E'Newcastle upon Tyne', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NWP', E'Newport', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NYM', E'Distretto di Newry e Mourne', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NFK', E'Norfolk', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NAY', E'Ayrshire Settentrionale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NEL', E'North East Lincolnshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NLK', E'Lanarkshire Settentrionale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NLN', E'North Lincolnshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NSM', E'North Somerset', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NTY', E'North Tyneside', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NYK', E'North Yorkshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NTH', E'Northamptonshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NBL', E'Northumberland', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-RIC', E'Richmond upon Thames', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NGM', E'Nottingham', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-NTT', E'Nottinghamshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-OLD', E'Oldham', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-OMH', E'Omagh', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ORK', E'Isole Orcadi', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-OXF', E'Oxfordshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-PEM', E'Pembrokeshire', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-PKN', E'Perth e Kinross', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-PTE', E'Peterborough', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-PLY', E'Plymouth', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-POL', E'Poole', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-POR', E'Portsmouth', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-POW', E'Powys', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-RDG', E'Reading', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-RCC', E'Redcar and Cleveland', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-RFW', E'Renfrewshire', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-RCH', E'Rochdale', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ROT', E'Rotherham', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-RUT', E'Rutland', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SAW', E'Sandwell', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SCB', E'Scottish Borders', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SHF', E'Sheffield', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-ZET', E'Isole Shetland', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SHR', E'Shropshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SLG', E'Slough', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SOL', E'Solihull', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SOM', E'Somerset', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SAY', E'Ayrshire Meridionale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SGC', E'South Gloucestershire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SLK', E'Lanarkshire Meridionale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STY', E'South Tyneside', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STH', E'Southampton', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SOS', E'Southend-on-Sea', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SHN', E'St. Helens', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STS', E'Staffordshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STG', E'Stirling', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SKP', E'Stockport', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STT', E'Stockton-on-Tees', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STE', E'Stoke-on-Trent', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STB', E'Strabane', E'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SFK', E'Suffolk', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SND', E'Sunderland', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SRY', E'Surrey', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-STN', E'Sutton', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'ENG', E'Inghilterra', E'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-TWH', E'Tower Hamlets', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WFT', E'Waltham Forest', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'NIR', E'Irlanda del Nord', E'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WNM', E'Royal Borough of Windsor and Maidenhead', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'SCT', E'Scozia', E'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SWA', E'Swansea', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-SWD', E'Swindon', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-TAM', E'Tameside', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-TFW', E'Telford and Wrekin', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-THR', E'Thurrock', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-TOB', E'Torbay', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-TOF', E'Torfaen', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-TRF', E'Trafford', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-VGL', E'Vale of Glamorgan', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WKF', E'Wakefield', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'WLS', E'Galles', E'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WLL', E'Walsall', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WRT', E'Warrington', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WAR', E'Warwickshire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WBK', E'West Berkshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WDU', E'Dunbartonshire Occidentale', E'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WSX', E'West Sussex', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WSM', E'Westminster', E'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WGN', E'Wigan', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WIL', E'Wiltshire', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WRL', E'Wirral', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WOK', E'Wokingham', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WLV', E'Wolverhampton', E'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WOR', E'Worcestershire', E'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-WRX', E'Wrexham', E'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'GB', E'GB-YOR', E'York', E'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-AL', E'Alabama', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-AK', E'Alaska', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-AS', E'Samoa Americane', E'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-AZ', E'Arizona', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-AR', E'Arkansas', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-CA', E'California', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-CO', E'Colorado', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-CT', E'Connecticut', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-DE', E'Delaware', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-FL', E'Florida', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-GA', E'Georgia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-GU', E'Guam', E'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-HI', E'Hawaii', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-ID', E'Idaho', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-IL', E'Illinois', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-IN', E'Indiana', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-IA', E'Iowa', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-KS', E'Kansas', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-KY', E'Kentucky', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-LA', E'Louisiana', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-ME', E'Maine', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MD', E'Maryland', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MA', E'Massachusetts', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MI', E'Michigan', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MN', E'Minnesota', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MS', E'Mississippi', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MO', E'Missouri', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MT', E'Montana', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-NE', E'Nebraska', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-NV', E'Nevada', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-NH', E'New Hampshire', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-NJ', E'New Jersey', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-NM', E'Nuovo Messico', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-NY', E'New York', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-NC', E'Carolina del Nord', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-ND', E'Dakota del Nord', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-MP', E'Isole Marianne Settentrionali', E'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-OH', E'Ohio', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-OK', E'Oklahoma', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-OR', E'Oregon', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-PA', E'Pennsylvania', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-PR', E'Porto Rico', E'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-RI', E'Rhode Island', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-SC', E'Carolina del Sud', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-SD', E'Dakota del Sud', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-TN', E'Tennessee', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-TX', E'Texas', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-UT', E'Utah', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-DC', E'Washington', E'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-VT', E'Vermont', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-VI', E'Isole Vergini', E'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-VA', E'Virginia', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-WA', E'Washington', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-WV', E'Virginia Occidentale', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-WI', E'Wisconsin', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'US', E'US-WY', E'Wyoming', E'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-01', E'Attard', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-02', E'Balzan', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-03', E'Vittoriosa', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-04', E'Birchircara', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-05', E'Birzebbugia', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-06', E'Cospicua', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-07', E'Dingli', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-08', E'Figura', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-09', E'Floriana', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-10', E'Fontana', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-11', E'Gudia', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-13', E'Għajnsielem', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-14', E'Garbo', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-15', E'Gargur', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-16', E'Għasri', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-17', E'Asciac', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-12', E'Gezira', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-35', E'Marfa', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-21', E'Calcara', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-22', E'Kerċem', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-23', E'Chircop', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-24', E'Lia', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-25', E'Luca', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-26', E'Marsa', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-27', E'Marsascala', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-28', E'Marsa Scirocco', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-29', E'Medina', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-30', E'Mellieħa', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-32', E'Musta', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-33', E'Micabba', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-34', E'Msida', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-36', E'Monsciar', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-31', E'Mugiarro', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-37', E'Nadur', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-38', E'Nasciaro', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-39', E'Paola', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-40', E'Pembroke', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-41', E'Pietà', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-43', E'Curmi', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-44', E'Crendi', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-47', E'Safi', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-49', E'San Giovanni', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-20', E'Senglea', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-48', E'San Giuliano', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-18', E'Ħamrun', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-46', E'Rabat', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-50', E'San Lorenzo', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-45', E'Rabat', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-52', E'Sannat', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-53', E'Santa Lucia', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-54', E'Santa Venera', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-55', E'Suggeui', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-56', E'Sliema', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-57', E'Swieqi', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-59', E'Tarscen', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-60', E'La Valletta', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-61', E'Caccia', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-62', E'Xeuchia', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-63', E'Sciaira', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-64', E'Zabbar', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-67', E'Zeitun', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-68', E'Zurrico', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-65', E'Żebbuġ', E'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES (E'MT', E'MT-66', E'Casal Zebbugi', E'local council');
  