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 ('AD', 'AD-07', 'Andorra la Vella', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AD', 'AD-02', 'Canillo', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AD', 'AD-03', 'Encamp', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AD', 'AD-08', 'Escaldes-Engordany', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AD', 'AD-04', 'La Massana', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AD', 'AD-05', 'Ordino', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AD', 'AD-06', 'Sant Julià de Lòria', 'parish');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-1', 'Burgenland', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-2', 'Kärnten', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-3', 'Niederösterreich', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-5', 'Salzburg', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-6', 'Steiermark', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-7', 'Tirol', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-4', 'Oberösterreich', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-9', 'Wien', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('AT', 'AT-8', 'Vorarlberg', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BY', 'BY-HM', 'Minsk', 'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-VAN', 'Antwerpen', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-BRU', 'Region Brüssel-Hauptstadt', 'capital region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-VOV', 'Ostflandern', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-VBR', 'Flämisch-Brabant', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-VLI', 'Limburg', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-WLG', 'Lüttich', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-WLX', 'Luxemburg', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-WAL', 'Wallonische Region', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-WBR', 'Wallonisch-Brabant', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('BE', 'BE-VWV', 'Westflandern', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-AB', 'Alberta', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-BC', 'British Columbia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-MB', 'Manitoba', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NB', 'New Brunswick', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NL', 'Neufundland und Labrador', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NT', 'Nordwest-Territorien', 'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NS', 'Nova Scotia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-NU', 'Nunavut', 'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-ON', 'Ontario', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-PE', 'Prince Edward Island', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-QC', 'Québec', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-SK', 'Saskatchewan', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CA', 'CA-YT', 'Yukon', 'territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-AN', 'Antofagasta', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-AR', 'Arauco', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-AP', 'Región de Arica y Parinacota', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-AT', 'Atacamawüste', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-AI', 'Región de Aysén', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-BI', 'Bío-Bío', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-CO', 'Coquimbo', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-LI', 'Región del Libertador General Bernardo O’Higgins', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-LL', 'Los Lagos', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-MA', 'Magallanes', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-ML', 'Maule', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-RM', 'Región Metropolitana de Santiago', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-TA', 'Tarapacá', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CL', 'CL-VS', 'Valparaíso', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-070', 'Aarhus', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-040', 'Bornholm', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-84', 'Kapital', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-82', 'Region Midtjylland', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-015', 'Kopenhagen', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-042', 'Fünen', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-83', 'Region Syddanmark', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-055', 'Ribe', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-065', 'Ringkøbing', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-025', 'Roskilde', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-050', 'Sønderjylland', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-035', 'Storstrøms Amt', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-060', 'Vejle', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-076', 'Viborg', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-030', 'Vestsjællands Amt', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DK', 'DK-85', 'Provinz Zeeland', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-37', 'Kreis Harju', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-39', 'Hiiumaa', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-44', 'Kreis Ida-Viru', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-51', 'Kreis Järva', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-49', 'Kreis Jõgeva', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-59', 'Kreis Lääne-Viru', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-57', 'Kreis Lääne', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-67', 'Kreis Pärnu', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-65', 'Kreis Põlva', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-70', 'Kreis Rapla', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-74', 'Saaremaa', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-78', 'Kreis Tartu', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-82', 'Kreis Valga', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-84', 'Kreis Viljandi', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('EE', 'EE-86', 'Kreis Võru', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-01', 'Département Ain', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-02', 'Département Aisne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-03', 'Département Allier', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-06', 'Département Alpes-Maritimes', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-04', 'Département Alpes-de-Haute-Provence', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-A', 'Elsass', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-B', 'Aquitanien', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-08', 'Ardennen', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-07', 'Département Ardèche', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-09', 'Département Ariège', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-10', 'Département Aube', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-11', 'Département Aude', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-12', 'Département Aveyron', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-67', 'Département Bas-Rhin', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-13', 'Département Bouches-du-Rhône', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-D', 'Burgund', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-14', 'Département Calvados', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-15', 'Département Cantal', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-G', 'Champagne-Ardenne', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-16', 'Département Charente', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-17', 'Département Charente-Maritime', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-18', 'Cher', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-CP', 'Clipperton-Insel', 'dependency');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-19', 'Département Corrèze', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-2A', 'Département Corse-du-Sud', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-H', 'Korsika', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-23', 'Département Creuse', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-21', 'Département Côte-d’Or', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-22', 'Département Côtes-d’Armor', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-79', 'Département Deux-Sèvres', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-24', 'Département Dordogne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-25', 'Département Doubs', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-26', 'Département Drôme', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-91', 'Département Essonne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-27', 'Département Eure', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-28', 'Département Eure-et-Loir', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-29', 'Département Finistère', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-I', 'Franche-Comté', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-30', 'Département Gard', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-32', 'Département Gers', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-33', 'Département Gironde', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-GP', 'Guadeloupe', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-68', 'Département Haut-Rhin', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-2B', 'Département Haute-Corse', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-31', 'Département Haute-Garonne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-P', 'Basse-Normandie', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-GF', 'Französisch-Guayana', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-43', 'Département Haute-Loire', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-52', 'Département Haute-Marne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-74', 'Département Haute-Savoie', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-70', 'Département Haute-Saône', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-87', 'Département Haute-Vienne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-05', 'Département Hautes-Alpes', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-65', 'Département Hautes-Pyrénées', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-92', 'Département Hauts-de-Seine', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-34', 'Département Hérault', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-35', 'Département Ille-et-Vilaine', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-36', 'Département Indre', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-37', 'Département Indre-et-Loire', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-38', 'Département Isère', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-39', 'Jura', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-40', 'Landes', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-K', 'Languedoc-Roussillon', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-41', 'Département Loir-et-Cher', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-42', 'Département Loire', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-44', 'Département Loire-Atlantique', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-45', 'Département Loiret', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-M', 'Lorraine', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-46', 'Lot', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-47', 'Département Lot-et-Garonne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-48', 'Département Lozère', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-49', 'Département Maine-et-Loire', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-50', 'Département Manche', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-51', 'Département Marne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-MQ', 'Martinique', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-53', 'Département Mayenne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-YT', 'Mayotte', 'territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-54', 'Département Meurthe-et-Moselle', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-55', 'Département Meuse', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-N', 'Midi-Pyrénées', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-56', 'Département Morbihan', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-57', 'Département Moselle', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-58', 'Département Nièvre', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-59', 'Nord', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-O', 'Nord-Pas-de-Calais', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-60', 'Département Oise', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-61', 'Département Orne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-75', 'Paris', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-62', 'Département Pas-de-Calais', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-R', 'Pays de la Loire', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-S', 'Picardie', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-T', 'Poitou-Charentes', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-Q', 'Haute-Normandie', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-PF', 'Französisch-Polynesien', 'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-NC', 'Neukaledonien', 'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-RE', 'Réunion', 'overseas regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-U', 'Provence-Alpes-Côte d’Azur', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-63', 'Département Puy-de-Dôme', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-64', 'Département Pyrénées-Atlantiques', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-66', 'Département Pyrénées-Orientales', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-69', 'Rhone', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-V', 'Rhône-Alpes', 'metropolitan regions');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-72', 'Département Sarthe', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-73', 'Département Savoie', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-71', 'Département Saône-et-Loire', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-76', 'Département Seine-Maritime', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-93', 'Département Seine-Saint-Denis', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-77', 'Département Seine-et-Marne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-80', 'Département Somme', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-81', 'Tarn', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-82', 'Département Tarn-et-Garonne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-90', 'Territoire de Belfort', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-95', 'Département Val-d’Oise', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-94', 'Département Val-de-Marne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-83', 'Var', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-84', 'Département Vaucluse', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-85', 'Département Vendée', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-86', 'Département Vienne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-88', 'Département Vosges', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-89', 'Département Yonne', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-78', 'Département Yvelines', 'metropolitan department');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-MF', 'Saint-Martin', 'overseas territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-BL', 'Saint-Barthélemy', 'overseas territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-PM', 'Saint-Pierre und Miquelon', 'territorial collectivity');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('FR', 'FR-WF', 'Wallis und Futuna', 'overseas territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BW', 'Baden-Württemberg', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BY', 'Bayern', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BE', 'Berlin', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-BB', 'Brandenburg', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-HB', 'Bremen', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-HH', 'Hamburg', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-HE', 'Hessen', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-NI', 'Niedersachsen', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-MV', 'Mecklenburg-Vorpommern', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-NW', 'Nordrhein-Westfalen', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-RP', 'Rheinland-Pfalz', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-SL', 'Saarland', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-SN', 'Sachsen', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-ST', 'Sachsen-Anhalt', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-SH', 'Schleswig-Holstein', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('DE', 'DE-TH', 'Thüringen', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-AH', 'Aschanti', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-BA', 'Brong-Ahafo Region', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-CP', 'Central', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-EP', 'Eastern', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-AA', 'Greater Accra Region', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-NP', 'Northern', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-UE', 'Upper East Region', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-TV', 'Volta', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GH', 'GH-WP', 'Western', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-AN', 'Andamanen und Nikobaren', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-AP', 'Andhra Pradesh', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-AR', 'Arunachal Pradesh', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-AS', 'Assam', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-BR', 'Bihar', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-CH', 'Chandigarh', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-CT', 'Chhattisgarh', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-DN', 'Dadra und Nagar Haveli', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-DD', 'Daman und Diu', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-DL', 'Delhi', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-GA', 'Goa', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-GJ', 'Gujarat', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-HR', 'Haryana', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-HP', 'Himachal Pradesh', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-JK', 'Jammu und Kashmir', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-JH', 'Jharkhand', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-KA', 'Karnataka', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-KL', 'Kerala', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-LD', 'Lakshadweep', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MP', 'Madhya Pradesh', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MH', 'Maharashtra', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MN', 'Manipur', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-ML', 'Meghalaya', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-MZ', 'Mizoram', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-NL', 'Nagaland', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-OR', 'Orissa', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-PY', 'Puducherry', 'union territory');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-PB', 'Punjab', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-RJ', 'Rajasthan', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-SK', 'Sikkim', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-TN', 'Tamil Nadu', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-TR', 'Tripura', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-UP', 'Uttar Pradesh', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-UT', 'Uttarakhand', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IN', 'IN-WB', 'Westbengalen', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-CW', 'Carlow', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-CN', 'Cavan', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-CE', 'Clare', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-CO', 'Cork', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-LS', 'County Laois', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-OY', 'County Offaly', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-WH', 'County Westmeath', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-DL', 'Donegal', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-D', 'Dublin', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-G', 'Galway', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-KY', 'Kerry', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-KE', 'Kildare', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-KK', 'Kilkenny', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-L', 'Leinster', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-LK', 'Limerick', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-LD', 'Longford', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-LH', 'Louth', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-MO', 'Mayo', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-MN', 'Monaghan', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-M', 'Munster', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-RN', 'Roscommon', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-SO', 'Sligo', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-TA', 'Tipperary', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-U', 'Provinz Ulster', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-WD', 'Waterford', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-WX', 'Wexford', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IE', 'IE-WW', 'Wicklow', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IL', 'IL-M', 'Zentralrajon', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IL', 'IL-HA', 'Haifa', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IL', 'IL-JM', 'Jerusalem', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IL', 'IL-TA', 'Tel Aviv-Jaffa', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-65', 'Abruzzen', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AG', 'Agrigent', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AL', 'Alessandria', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AN', 'Ancona', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AO', 'Aosta', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AR', 'Arezzo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AP', 'Ascoli Piceno', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AT', 'Asti', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AV', 'Avellino', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BA', 'Bari', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-77', 'Basilikata', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BL', 'Belluno', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BN', 'Benevento', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BG', 'Bergamo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BI', 'Biella', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BO', 'Bologna', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BZ', 'Bozen', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BS', 'Brescia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BR', 'Brindisi', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CA', 'Cagliari', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-78', 'Kalabrien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CL', 'Caltanissetta', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-72', 'Kampanien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CB', 'Campobasso', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CE', 'Caserta', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CT', 'Catania', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CZ', 'Catanzaro', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CH', 'Chieti', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CO', 'Como', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CS', 'Cosenza', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CR', 'Cremona', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-KR', 'Crotone', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CN', 'Cuneo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-45', 'Emilia-Romagna', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-EN', 'Enna', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FM', 'Fermo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FE', 'Ferrara', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FI', 'Florenz', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FG', 'Foggia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FO', 'Forlì', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-36', 'Friaul-Julisch Venetien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FR', 'Frosinone', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-GE', 'Genua', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-GO', 'Görz', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-GR', 'Grosseto', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-IM', 'Imperia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-IS', 'Isernia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-BT', 'Provinz Barletta-Andria-Trani', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-CI', 'Provinz Carbonia-Iglesias', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-FC', 'Provinz Forlì-Cesena', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-75', 'Apulien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-AQ', 'L’Aquila', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SP', 'La Spezia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-62', 'Latium', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LE', 'Lecce', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LC', 'Lecco', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-42', 'Ligurien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LI', 'Livorno', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LO', 'Lodi', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-25', 'Lombardei', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LU', 'Lucca', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MC', 'Macerata', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MN', 'Mantua', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-57', 'Marken', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MT', 'Matera', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-ME', 'Messina', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MI', 'Mailand', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MO', 'Modena', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-67', 'Molise', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-NA', 'Neapel', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-NO', 'Novara', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-NU', 'Nuoro', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-OR', 'Oristano', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PD', 'Padua', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PA', 'Palermo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PR', 'Parma', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PV', 'Pavia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PG', 'Perugia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PE', 'Pescara', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PC', 'Piacenza', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-21', 'Piemont', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PI', 'Pisa', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PT', 'Pistoia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PN', 'Pordenone', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PZ', 'Potenza', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PO', 'Prato', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MS', 'Provinz Massa-Carrara', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MA', 'Provinz Medio Campidano', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-MB', 'Provinz Monza und Brianza', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-OG', 'Provinz Ogliastra', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-OL', 'Provinz Olbia-Tempio', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-PU', 'Provinz Pesaro und Urbino', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RG', 'Ragusa', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RA', 'Ravenna', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RC', 'Reggio Calabria', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RE', 'Reggio nell’Emilia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-LT', 'Latino', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-23', 'Aostatal', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VB', 'Provinz Verbano-Cusio-Ossola', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RI', 'Rieti', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RN', 'Rimini', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RM', 'Roma', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-RO', 'Rovigo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SA', 'Salerno', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-88', 'Sardinien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SS', 'Sassari', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SV', 'Savona', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-82', 'Sizilien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SI', 'Siena', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-SO', 'Sondrio', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TA', 'Tarent', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TE', 'Teramo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TR', 'Terni', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TP', 'Trapani', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-32', 'Trentino-Südtirol', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TN', 'Trient', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TV', 'Treviso', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TS', 'Triest', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-TO', 'Turin', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-52', 'Toskana', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-UD', 'Udine', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-55', 'Umbrien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VA', 'Varese', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-34', 'Venetien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VE', 'Venedig', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VC', 'Vercelli', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VR', 'Verona', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VV', 'Vibo Valentia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VI', 'Vicenza', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('IT', 'IT-VT', 'Viterbo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('LU', 'LU-D', 'Diekirch', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('LU', 'LU-G', 'Grevenmacher', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('LU', 'LU-L', 'Luxemburg', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-AW', 'Aruba', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-BQ1', 'Bonaire', 'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-CW', 'Curaçao', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-DR', 'Provinz Drenthe', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-FL', 'Provinz Flevoland', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-FR', 'Provinz Friesland', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-GE', 'Provinz Gelderland', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-GR', 'Groningen', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-LI', 'Limburg', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-NB', 'Provinz Nordbrabant', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-NH', 'Provinz Nordholland', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-OV', 'Provinz Overijssel', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-BQ2', 'Saba', 'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-BQ3', 'Sint Eustatius', 'special municipality');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-SX', 'Sint Maarten', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-ZH', 'Provinz Südholland', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-UT', 'Utrecht', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NL', 'NL-ZE', 'Provinz Zeeland', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-02', 'Akershus', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-09', 'Aust-Agder', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-06', 'Buskerud', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-20', 'Finnmark', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-04', 'Hedmark', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-12', 'Hordaland', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-22', 'Jan Mayen', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-15', 'Møre og Romsdal', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-17', 'Nord-Trøndelag', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-18', 'Nordland', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-05', 'Oppland', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-03', 'Oslo', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-11', 'Rogaland', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-14', 'Sogn og Fjordane', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-21', 'Spitzbergen', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-16', 'Sør-Trøndelag', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-08', 'Telemark', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-19', 'Troms', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-10', 'Vest-Agder', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-07', 'Vestfold', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('NO', 'NO-01', 'Østfold', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-WP', 'Woiwodschaft Großpolen', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-KP', 'Woiwodschaft Kujawien-Pommern', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-MA', 'Woiwodschaft Kleinpolen', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-DS', 'Woiwodschaft Niederschlesien', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-LU', 'Woiwodschaft Lublin', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-LB', 'Woiwodschaft Lebus', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-MZ', 'Woiwodschaft Masowien', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-OP', 'Woiwodschaft Oppeln', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-PK', 'Woiwodschaft Karpatenvorland', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-PD', 'Woiwodschaft Podlachien', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-PM', 'Woiwodschaft Pommern', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-SL', 'Woiwodschaft Schlesien', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-WN', 'Woiwodschaft Ermland-Masuren', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-ZP', 'Woiwodschaft Westpommern', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PL', 'PL-SK', 'Woiwodschaft Heiligkreuz', 'voivodship');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-01', 'Aveiro', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-20', 'Azoren', 'autonomous region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-02', 'Beja', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-03', 'Braga', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-04', 'Bragança', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-05', 'Castelo Branco', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-06', 'Coimbra', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-08', 'Faro', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-09', 'Guarda', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-10', 'Leiria', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-11', 'Lissabon', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-30', 'Autonome Region Madeira', 'autonomous region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-12', 'Portalegre', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-13', 'Porto', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-14', 'Santarém', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-15', 'Setúbal', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-17', 'Vila Real', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-18', 'Viseu', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('PT', 'PT-07', 'Évora', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-AR', 'Arad', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BC', 'Bacău', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BN', 'Kreis Bistrița-Năsăud', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BT', 'Botoșani', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BV', 'Brașov', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BR', 'Brăila', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-B', 'Bukarest', 'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-BZ', 'Buzău', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-CS', 'Kreis Caraș-Severin', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-CJ', 'Cluj-Napoca', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-CT', 'Constanța', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-CV', 'Covasna', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-CL', 'Călărași', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-DJ', 'Kreis Dolj', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-DB', 'Dâmbovița', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-GL', 'Galați', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-GR', 'Giurgiu', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-GJ', 'Kreis Gorj', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-HR', 'Kreis Harghita', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-HD', 'Hunedoara', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-IL', 'Ialomița', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-IS', 'Iași', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-IF', 'Kreis Ilfov', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-MM', 'Komitat Máramaros', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-MH', 'Kreis Mehedinți', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-MS', 'Kreis Mureș', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-NT', 'Kreis Neamț', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-PH', 'Prahova', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-SM', 'Satu Mare', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-SB', 'Sibiu', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-SV', 'Suceava', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-SJ', 'Salaj', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-TR', 'Kreis Teleorman', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-TM', 'Timiș', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-TL', 'Tulcea', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-VS', 'Vaslui', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RO', 'RO-VL', 'Kreis Vâlcea', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-00', 'Belgrad', 'city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-14', 'Okrug Bor', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-11', 'Okrug Braničevo', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-02', 'Okrug Srednji Banat', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-23', 'Okrug Jablanica', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-09', 'Okrug Kolubara', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-29', 'Okrug Kosovo-Pomoravlje', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-25', 'Okrug Kosovo', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-08', 'Okrug Mačva', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-17', 'Okrug Moravica', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-20', 'Nišavski okrug', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-03', 'Okrug Severni Banat', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-01', 'Okrug Severna Bačka', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-22', 'Okrug Pirot', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-10', 'Okrug Podunavlje', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-13', 'Okrug Pomoravlje', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-24', 'Okrug Pčinja', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-19', 'Okrug Rasina', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-04', 'Okrug Južni Banat', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-07', 'Okrug Srem', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-16', 'Okrug Zlatibor', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-12', 'Okrug Šumadija', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('RS', 'RS-26', 'Okrug Peć', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-BC', 'Banskobystrický kraj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-BL', 'Bratislavský kraj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-KI', 'Košický kraj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-NI', 'Nitriansky kraj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-PV', 'Prešovský kraj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-TA', 'Trnavský kraj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SK', 'SK-ZI', 'Žilinský kraj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-C', 'A Coruña', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-AB', 'Albacete', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-A', 'Alicante', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-AL', 'Almería', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-AN', 'Andalusien', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-AS', 'Asturien', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-BA', 'Badajoz', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-PM', 'Baleares', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-IB', 'Balearische Inseln', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-B', 'Barcelona', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-BU', 'Burgos', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CA', 'Cádiz', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CN', 'Canarias', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-S', 'Kantabrien', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CM', 'Kastilien-La Mancha', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CL', 'Kastilien und León', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CT', 'Katalonien', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CE', 'Ceuta', 'autonomous city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CR', 'Ciudad Real', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CU', 'Cuenca', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CC', 'Cáceres', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-CO', 'Córdoba', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-EX', 'Extremadura', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SS', 'Gipuzkoa', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-GI', 'Girona', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-GR', 'Granada', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-GU', 'Guadalajara', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-H', 'Huelva', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-HU', 'Huesca', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-J', 'Jaen', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-GC', 'Las Palmas de Gran Canaria', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-LE', 'Leon', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-L', 'Lleida', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-LU', 'Lugo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-MD', 'Madrid', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-ML', 'Melilla', 'autonomous city');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-MC', 'Murcia', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-MA', 'Málaga', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-NC', 'Navarra', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-OR', 'Ourense', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-P', 'Palencia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-LO', 'Rioja', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-PO', 'Pontevedra', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SA', 'Salamanca', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-TF', 'Santa Cruz de Tenerife', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SG', 'Segovia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SE', 'Sevilla', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-SO', 'Soria', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-T', 'Tarragona', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-TE', 'Teruel', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-TO', 'Toledo', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-V', 'Valencia', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-VC', 'Valencianische Gemeinschaft', 'autonomous community');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-VA', 'Valladolid', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-ZA', 'Zamora', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-Z', 'Saragossa', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('ES', 'ES-VI', 'Álava', 'province');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-K', 'Blekinge län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-W', 'Dalarnas län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-I', 'Gotlands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-X', 'Gävleborgs län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-N', 'Hallands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-Z', 'Jämtlands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-F', 'Jönköpings län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-H', 'Kalmar län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-G', 'Kronobergs län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-BD', 'Norrbottens län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-M', 'Skåne län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-AB', 'Stockholms län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-D', 'Södermanlands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-C', 'Uppsala län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-S', 'Värmlands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-AC', 'Västerbottens län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-Y', 'Västernorrlands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-U', 'Västmanlands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-O', 'Västra Götalands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-T', 'Örebro län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('SE', 'SE-E', 'Östergötlands län', 'county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-AG', 'Kanton Aargau', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-AR', 'Kanton Appenzell Ausserrhoden', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-AI', 'Kanton Appenzell Innerrhoden', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-BL', 'Kanton Basel-Landschaft', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-BS', 'Kanton Basel-Stadt', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-BE', 'Bern', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-FR', 'Freiburg im Üechtland', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-GL', 'Glarus', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-GR', 'Kanton Graubünden', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-JU', 'Jura', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-NE', 'Neuenburg NE', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-NW', 'Kanton Nidwalden', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-OW', 'Kanton Obwalden', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-SG', 'St. Gallen', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-SH', 'Schaffhausen', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-SZ', 'Schwyz', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-SO', 'Solothurn', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-TG', 'Kanton Thurgau', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-TI', 'Kanton Tessin', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-UR', 'Uri', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-VS', 'Kanton Wallis', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-VD', 'Kanton Waadt', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-ZG', 'Zug', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-GE', 'Genf', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-LU', 'Luzern', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('CH', 'CH-ZH', 'Zürich', 'canton');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-71', 'Oblast Tscherkassy', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-74', 'Oblast Tschernihiw', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-77', 'Oblast Tscherniwzi', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-43', 'Krim', 'autonomous republic');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-12', 'Oblast Dnipropetrowsk', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-14', 'Oblast Donezk', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-26', 'Oblast Iwano-Frankiwsk', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-63', 'Oblast Charkiw', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-65', 'Oblast Cherson', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-68', 'Oblast Chmelnyzkyj', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-30', 'Kiew', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-32', 'Oblast Kiew', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-35', 'Oblast Kirowohrad', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-09', 'Oblast Luhansk', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-46', 'Oblast Lwiw', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-48', 'Oblast Mykolajiw', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-51', 'Oblast Odessa', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-53', 'Oblast Poltawa', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-56', 'Oblast Riwne', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-40', 'Sewastopol', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-59', 'Oblast Sumy', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-61', 'Oblast Ternopil', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-05', 'Oblast Winnyzja', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-07', 'Oblast Wolhynien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-21', 'Oblast Transkarpatien', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-23', 'Oblast Saporischschja', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('UA', 'UA-18', 'Oblast Schytomyr', 'region');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ARD', 'ARD', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ABE', 'Aberdeen', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ABD', 'Aberdeenshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ANS', 'Angus', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ANT', 'Antrim', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-AGB', 'Argyll and Bute', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ARM', 'Armagh', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BLA', 'Ballymena', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BLY', 'Ballymoney', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BNB', 'Banbridge', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BNS', 'Barnsley', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BAS', 'Bath and North East Somerset', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BDF', 'Bedfordshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BFS', 'Belfast', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BIR', 'Birmingham', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BBD', 'Blackburn with Darwen', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BPL', 'Blackpool', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BGW', 'Blaenau Gwent', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BOL', 'Bolton', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BMH', 'Bournemouth', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BRC', 'Bracknell Forest', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BRD', 'Bradford', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BEN', 'Brent', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BGE', 'Bridgend', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BNH', 'Brighton and Hove', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BST', 'Bristol', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BKM', 'Buckinghamshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BUR', 'Bury', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CAY', 'Caerphilly', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CLD', 'Calderdale', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CAM', 'Cambridgeshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CMD', 'Camden', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CRF', 'Cardiff', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CMN', 'Carmarthenshire', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CKF', 'Carrickfergus', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CGN', 'Ceredigion', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CHS', 'Cheshire', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CLK', 'Clackmannanshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CLR', 'Coleraine', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CWY', 'Conwy', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CKT', 'Cookstown', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CON', 'Cornwall', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-COV', 'Coventry', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CGV', 'Craigavon', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-BDG', 'London Borough of Barking and Dagenham', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CSR', 'Robert Stewart', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-FER', 'County Fermanagh', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-CMA', 'Cumbria', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DAL', 'Darlington', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DEN', 'Denbighshire', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DER', 'Derby', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DBY', 'Derbyshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DRY', 'Derry', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DEV', 'Devon', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DNC', 'Doncaster', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DOR', 'Dorset', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DOW', 'Down', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DUD', 'Dudley', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DGY', 'Dumfries and Galloway', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DND', 'Dundee', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DGN', 'Dungannon and South Tyrone', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-DUR', 'Durham', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-EAY', 'East Ayrshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-EDU', 'East Dunbartonshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ELN', 'East Lothian', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ERW', 'East Renfrewshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ERY', 'East Riding of Yorkshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ESX', 'East Sussex', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-EDH', 'Edinburgh', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ENF', 'Enfield', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ESS', 'Essex', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-FAL', 'Falkirk', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-FIF', 'Fife', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-FLN', 'Flintshire', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GAT', 'Gateshead', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GLG', 'Glasgow', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GLS', 'Gloucestershire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GRE', 'Greenwich', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-GWN', 'Gwynedd', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HCK', 'Hackney', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HAL', 'Halton', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HAM', 'Hampshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HPL', 'Hartlepool', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HEF', 'Herefordshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HRT', 'Hertfordshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HLD', 'Hochland', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-IVC', 'Inverclyde', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HMF', 'London Borough of Hammersmith and Fulham', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-HAV', 'London Borough of Havering', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ELS', 'Äußere Hebriden', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-AGY', 'Anglesey', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LND', 'City of London', 'city corporation');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-IOW', 'Isle of Wight', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-IOS', 'Scilly-Inseln', '');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ISL', 'Islington', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-KEN', 'Kent', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-KHL', 'Kingston upon Hull', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-KTT', 'Kingston upon Thames', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-KIR', 'Kirklees', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LAN', 'Lancashire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LRN', 'Larne', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LDS', 'Leeds', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LCE', 'Leicester', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LEC', 'Leicestershire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LEW', 'London Borough of Lewisham', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LMV', 'Limavady', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LIN', 'Lincolnshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LSB', 'Lisburn', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LIV', 'Liverpool', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NWM', 'London Borough of Newham', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-LUT', 'Luton', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MFT', 'Magherafelt', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MAN', 'Manchester', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MDW', 'Borough of Medway', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MTY', 'Merthyr Tydfil', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MRT', 'Merton', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MDB', 'Middlesbrough', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MLN', 'Midlothian', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MIK', 'Milton Keynes', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MON', 'Monmouthshire', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-MRY', 'Moray', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NTL', 'Neath Port Talbot', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NET', 'Newcastle upon Tyne', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NWP', 'Newport', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NYM', 'Newry and Mourne', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NTA', 'Newtownabbey', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NFK', 'Norfolk', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NAY', 'North Ayrshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NEL', 'North East Lincolnshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NLK', 'North Lanarkshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NLN', 'North Lincolnshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NSM', 'North Somerset', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NTY', 'North Tyneside', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NYK', 'North Yorkshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NTH', 'Northamptonshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NBL', 'Northumberland', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RIC', 'London Borough of Richmond upon Thames', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NGM', 'Nottingham', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-NTT', 'Nottinghamshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-OLD', 'Oldham', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-OMH', 'Omagh', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ORK', 'Orkney', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-OXF', 'Oxfordshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-PEM', 'Pembrokeshire', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-PKN', 'Perth and Kinross', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-PTE', 'Peterborough', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-PLY', 'Plymouth', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-POL', 'Poole', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-POR', 'Portsmouth', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-POW', 'Powys', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RDG', 'Reading', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RCC', 'Redcar and Cleveland', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RFW', 'Renfrewshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RCT', 'Rhondda', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RCH', 'Rochdale', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ROT', 'Rotherham', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-RUT', 'Rutland', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SLF', 'Salford', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SAW', 'Sandwell', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SCB', 'Scottish Borders', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SFT', 'Sefton', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SHF', 'Sheffield', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-ZET', 'Shetland', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SHR', 'Shropshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SLG', 'Slough', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SOL', 'Solihull', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SOM', 'Somerset', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SAY', 'South Ayrshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SGC', 'South Gloucestershire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SLK', 'South Lanarkshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STY', 'South Tyneside', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STH', 'Southampton', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SOS', 'Southend-on-Sea', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SHN', 'St. Helens', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STS', 'Staffordshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STG', 'Stirling', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SKP', 'Stockport', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STT', 'Stockton-on-Tees', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STE', 'Stoke-on-Trent', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STB', 'Strabane', 'district council area (northern ireland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SFK', 'Suffolk', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SND', 'Sunderland', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SRY', 'Surrey', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-STN', 'Sutton', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'ENG', 'England', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-TWH', 'London Borough of Tower Hamlets', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WFT', 'London Borough of Waltham Forest', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'NIR', 'Nordirland', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WNM', 'Windsor and Maidenhead', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'SCT', 'Schottland', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SWA', 'Swansea', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-SWD', 'Swindon', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-TAM', 'Tameside', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-TFW', 'Telford and Wrekin', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-THR', 'Thurrock', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-TOB', 'Torbay', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-TOF', 'Torfaen', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-TRF', 'Trafford', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-VGL', 'Vale of Glamorgan', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WKF', 'Wakefield', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'WLS', 'Wales', 'country');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WLL', 'Walsall', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WRT', 'Warrington', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WAR', 'Warwickshire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WBK', 'West Berkshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WDU', 'West Dunbartonshire', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WLN', 'West Lothian', 'council area (scotland)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WSX', 'West Sussex', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WSM', 'Westminster', 'borough');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WGN', 'Wigan', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WIL', 'Wiltshire', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WRL', 'Wirral', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WOK', 'Wokingham', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WLV', 'Wolverhampton', 'metropolitan district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WOR', 'Worcestershire', 'two-tier county');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-WRX', 'Wrexham', 'unitary authority (wales)');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('GB', 'GB-YOR', 'York', 'unitary authority');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AL', 'Alabama', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AK', 'Alaska', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AS', 'Amerikanisch-Samoa', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AZ', 'Arizona', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-AR', 'Arkansas', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-CA', 'Kalifornien', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-CO', 'Colorado', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-CT', 'Connecticut', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-DE', 'Delaware', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-FL', 'Florida', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-GA', 'Georgia', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-GU', 'Guam', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-HI', 'Hawaii', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-ID', 'Idaho', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-IL', 'Illinois', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-IN', 'Indiana', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-IA', 'Iowa', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-KS', 'Kansas', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-KY', 'Kentucky', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-LA', 'Louisiana', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-ME', 'Maine', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MD', 'Maryland', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MA', 'Massachusetts', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MI', 'Michigan', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MN', 'Minnesota', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MS', 'Mississippi', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MO', 'Missouri', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MT', 'Montana', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NE', 'Nebraska', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NV', 'Nevada', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NH', 'New Hampshire', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NJ', 'New Jersey', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NM', 'New Mexico', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NY', 'New York', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-NC', 'North Carolina', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-ND', 'North Dakota', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-MP', 'Nördliche Marianen', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-OH', 'Ohio', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-OK', 'Oklahoma', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-OR', 'Oregon', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-PA', 'Pennsylvania', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-PR', 'Puerto Rico', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-RI', 'Rhode Island', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-SC', 'South Carolina', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-SD', 'South Dakota', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-TN', 'Tennessee', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-TX', 'Texas', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-UM', 'United States Minor Outlying Islands', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-UT', 'Utah', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-DC', 'Washington, D.C.', 'district');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-VT', 'Vermont', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-VI', 'Jungferninseln', 'outlying area');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-VA', 'Virginia', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-WA', 'Washington', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-WV', 'West Virginia', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-WI', 'Wisconsin', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('US', 'US-WY', 'Wyoming', 'state');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-01', 'Attard', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-02', 'Balzan', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-03', 'Vittoriosa', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-04', 'Birkirkara', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-05', 'Birżebbuġa', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-06', 'Cospicua', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-07', 'Dingli', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-08', 'Fgura', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-09', 'Floriana', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-10', 'Fontana', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-11', 'Gudja', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-13', 'Għajnsielem', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-14', 'Għarb', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-15', 'Għargħur', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-16', 'Għasri', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-17', 'Għaxaq', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-12', 'Gżira', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-19', 'Iklin', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-35', 'Mtarfa', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-21', 'Kalkara', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-22', 'Kerċem', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-23', 'Kirkop', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-24', 'Lija', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-25', 'Luqa', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-27', 'Marsaskala', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-28', 'Marsaxlokk', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-29', 'Mdina', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-30', 'Mellieħa', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-32', 'Mosta', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-33', 'Mqabba', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-34', 'Msida', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-36', 'Munxar', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-31', 'Mġarr', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-37', 'Nadur', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-38', 'Naxxar', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-39', 'Paola', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-40', 'Pembroke', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-41', 'Pietà', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-43', 'Qormi', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-44', 'Qrendi', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-47', 'Safi', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-49', 'San Ġwann', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-20', 'Senglea', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-48', 'San Ġiljan', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-18', 'Ħamrun', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-46', 'Rabat', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-50', 'San Lawrenz', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-45', 'Victoria', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-52', 'Sannat', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-53', 'Santa Luċija', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-54', 'Santa Venera', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-55', 'Siġġiewi', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-56', 'Sliema', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-57', 'Swieqi', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-58', 'Ta’ Xbiex', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-59', 'Tarxien', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-60', 'Valletta', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-61', 'Xagħra', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-62', 'Xewkija', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-63', 'Xgħajra', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-64', 'Żabbar', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-67', 'Żejtun', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-68', 'Żurrieq', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-65', 'Żebbuġ', 'local council');
  INSERT INTO "subdivision" ("country", "id", "name", "level") VALUES ('MT', 'MT-66', 'Żebbuġ', 'local council');
  