text: CREATE TABLE subdivision_IT (id VARCHAR(6) NOT NULL, name VARCHAR(255), level VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-65', E'Abruzzo', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AG', E'Agrixento - Agrigento', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AL', E'Alessandria', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AN', E'Ancona', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AO', E'Aosta', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AR', E'Arezzo', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AP', E'Ascoli Piceno', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AT', E'Asti', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-AV', E'Avellino', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BA', E'Bari', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-77', E'Basilicata', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BN', E'Benevento', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BG', E'Bérgamo - Bergamo', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BI', E'Biella', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BO', E'Boloña - Bologna', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BZ', E'Bolzán', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BS', E'Brescia', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BR', E'Brindisi', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CA', E'Cagliari', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-78', E'Calabria', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-72', E'Campania', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CB', E'Campobasso', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CE', E'Caserta', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CZ', E'Catanzaro', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CH', E'Chieti', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CO', E'Como', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CR', E'Cremona', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-KR', E'Crotone', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-45', E'Emilia Romaña - Emilia-Romagna', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-EN', E'Enna', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-FM', E'Fermo', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-FE', E'Ferrara', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-FI', E'Florencia - Firenze', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-FG', E'Foggia', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-FO', E'Forlì', E'');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-36', E'Friuli-Venezia Giulia', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-GE', E'Xénova - Genova', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-GO', E'Gorizia', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-BT', E'Provincia de Barletta-Andria-Trani', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-CI', E'Provincia de Carbonia-Iglesias', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-FC', E'Provincia de Forlì-Cesena', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-75', E'Puglia', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-SP', E'La Spezia', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-62', E'Lazio', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-LE', E'Lecce', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-LC', E'Lecco', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-42', E'Liguria', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-LI', E'Livorno', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-25', E'Lombardía - Lombardia', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-LU', E'Lucca', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MC', E'Macerata', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MN', E'Mantua - Mantova', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-57', E'Marche', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MT', E'Matera', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-ME', E'Messina', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MI', E'Milán - Milano', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MO', E'Módena - Modena', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-67', E'Molise', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-NA', E'Nápoles - Napoli', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-NO', E'Novara', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-NU', E'Nuoro', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PD', E'Padua - Padova', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PA', E'Palermo', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PR', E'Parma', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PV', E'Pavía', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PG', E'Perugia', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PE', E'Pescara', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-21', E'Piemonte', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PI', E'Pisa', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PN', E'Pordenone', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PZ', E'Potenza', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PO', E'Prato', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MS', E'Provincia de Massa-Carrara', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MA', E'Provincia do Medio Campidano', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-MB', E'Provincia de Monza e Brianza', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-OG', E'Provincia de Ogliastra', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-OL', E'Provincia de Olbia-Tempio', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-PU', E'Provincia de Pesaro e Urbino', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-RA', E'Ravenna', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-RE', E'Reggio Emilia', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-23', E'Val de Aosta', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-VB', E'Provincia de Verbano-Cusio-Ossola', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-RI', E'Rieti', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-RN', E'Rimini', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-88', E'Sardeña - Sardigna', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-SV', E'Savona', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-82', E'Sicilia', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-SI', E'Siena', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-SO', E'Sondrio', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-TA', E'Taranto', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-TE', E'Téramo - Teramo', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-TR', E'Terni', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-32', E'Trentino-Tirol do Sur', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-TN', E'Trento', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-TV', E'Treviso', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-TS', E'Trieste', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-TO', E'Turín - Torino', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-52', E'Toscana', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-UD', E'Udine', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-55', E'Umbría - Umbria', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-VA', E'Varese', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-34', E'Véneto - Veneto', E'region');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-VE', E'Venecia - Venezia', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-VC', E'Vercelli', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-VR', E'Verona', E'province');
  INSERT INTO "subdivision_IT" ("id", "name", "level") VALUES (E'IT-VT', E'Viterbo', E'province');
  