Magento2 Province Italiane (da archivio ufficiale ISTAT, aggiornamento 02/08/2015).

magento2-province-italiane.sql

INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Agrigento','AG');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Alessandria','AL');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Ancona','AN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Arezzo','AR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Ascoli Piceno','AP');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Asti','AT');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Avellino','AV');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Bari','BA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Barletta-Andria-Trani','BT');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Belluno','BL');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Benevento','BN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Bergamo','BG');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Biella','BI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Bologna','BO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Bolzano/Bozen','BZ');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Brescia','BS');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Brindisi','BR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Cagliari','CA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Caltanissetta','CL');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Campobasso','CB');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Carbonia-Iglesias','CI'); 
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Caserta','CE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Catania','CT');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Catanzaro','CZ');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Chieti','CH');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Como','CO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Cosenza','CS');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Cremona','CR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Crotone','KR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Cuneo','CN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Enna','EN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Fermo','FM');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Ferrara','FE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Firenze','FI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Foggia','FG');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Forlì-Cesena','FC');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Frosinone','FR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Genova','GE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Gorizia','GO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Grosseto','GR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Imperia','IM');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Isernia','IS');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','L\'Aquila','AQ');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','La Spezia','SP');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Latina','LT');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Lecce','LE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Lecco','LC');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Livorno','LI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Lodi','LO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Lucca','LU');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Macerata','MC');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Mantova','MN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Massa-Carrara','MS');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Matera','MT');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Medio Campidano','VS');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Messina','ME');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Milano','MI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Modena','MO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Monza e della Brianza','MB');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Napoli','NA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Novara','NO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Nuoro','NU');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Ogliastra','OG');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Olbia-Tempio','OT');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Oristano','OR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Padova','PD');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Palermo','PA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Parma','PR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Pavia','PV');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Perugia','PG');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Pesaro e Urbino','PU');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Pescara','PE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Piacenza','PC');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Pisa','PI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Pistoia','PT');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Pordenone','PN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Potenza','PZ');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Prato','PO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Ragusa','RG');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Ravenna','RA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Reggio di Calabria','RC');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Reggio nell\'Emilia','RE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Rieti','RI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Rimini','RN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Roma','RM');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Rovigo','RO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Salerno','SA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Sassari','SS');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Savona','SV');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Siena','SI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Siracusa','SR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Sondrio','SO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Taranto','TA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Teramo','TE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Terni','TR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Torino','TO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Trapani','TP');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Trento','TN');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Treviso','TV');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Trieste','TS');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Udine','UD');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Valle d\'Aosta/Vallée d\'Aoste','AO');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Varese','VA');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Venezia','VE');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Verbano-Cusio-Ossola','VB');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Vercelli','VC');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Verona','VR');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Vibo Valentia','VV');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Vicenza','VI');
INSERT INTO directory_country_region (country_id, default_name, code) VALUES ('IT','Viterbo','VT');