text: CREATE TABLE subdivision_IT (id VARCHAR(6) NOT NULL, name VARCHAR(255) NOT NULL, level VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
  
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-65', 'Abruzzo', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AG', 'Agrigento', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AL', 'Alessandria', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AN', 'Ancona', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AO', 'Aosta', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AR', 'Arezzo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AP', 'Ascoli Piceno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AT', 'Asti', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BA', 'Bari', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-77', 'Basilicata', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BL', 'Belluno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BN', 'Benevento', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BG', 'Bergamo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BO', 'Bologna', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BZ', 'Bolzano', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BS', 'Brescia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BR', 'Brindisi', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CA', 'Cagliari', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-78', 'Calabria', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-72', 'Campania', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CT', 'Catania', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CH', 'Chieti', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CO', 'Como', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CS', 'Cosenza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CR', 'Cremona', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-KR', 'Crotone', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CN', 'Cuneo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-45', 'Emilia-Romagna', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FM', 'Fermo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FE', 'Ferrara', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FI', 'Firenze', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FG', 'Foggia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FO', 'Forlì', '');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-36', 'Friuli-Venezia Giulia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FR', 'Frosinone', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-GE', 'Genova', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-GO', 'Gorizia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-GR', 'Grosseto', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-IM', 'Imperia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BT', 'Provinsen Barletta-Andria-Trani', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CI', 'Provinsen Carbonia-Iglesias', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FC', 'Provinsen Forlì-Cesena', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-75', 'Puglia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SP', 'La Spezia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-62', 'Latium', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LE', 'Lecce', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LC', 'Lecco', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-42', 'Liguria', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LI', 'Livorno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-25', 'Lombardia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LU', 'Lucca', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MC', 'Macerata', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MN', 'Mantova', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-57', 'Marche', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-ME', 'Messina', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MI', 'Milano', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MO', 'Modena', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-67', 'Molise', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-NA', 'Napoli', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-NO', 'Novara', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-NU', 'Nuoro', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PD', 'Padova', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PA', 'Palermo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PR', 'Parma', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PV', 'Pavia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PG', 'Perugia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PE', 'Pescara', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PC', 'Piacenza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-21', 'Piemonte', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PI', 'Pisa', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PT', 'Pistoia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PZ', 'Potenza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PO', 'Prato', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MS', 'Massa-Carrara', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MA', 'Provinsen Medio Campidano', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MB', 'Provinsen Monza og Brianza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-OG', 'Provinsen Ogliastra', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-OL', 'Provinsen Olbia-Tempio', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PU', 'Provinsen Pesaro og Urbino', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RG', 'Ragusa', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RA', 'Ravenna', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RC', 'Reggio di Calabria', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RE', 'Reggio Emilia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-23', 'Aostadalen', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VB', 'Provinsen Verbano Cusio Ossola', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RN', 'Rimini', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RM', 'Roma', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SA', 'Salerno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-88', 'Sardinia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SS', 'Sassari', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SV', 'Savona', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-82', 'Sicilia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SI', 'Siena', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SO', 'Sondrio', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TA', 'Taranto', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TE', 'Teramo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TR', 'Terni', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TP', 'Trapani', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-32', 'Trentino-Alto Adige', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TN', 'Trento', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TV', 'Treviso', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TS', 'Trieste', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TO', 'Torino', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-52', 'Toscana', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-UD', 'Udine', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-55', 'Umbria', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VA', 'Varese', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-34', 'Veneto', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VE', 'Venezia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VC', 'Vercelli', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VR', 'Verona', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VI', 'Vicenza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VT', 'Viterbo', 'province');
  