INSERT INTO StateProvince VALUES
(45,'Agrigento','AG',1,1),
(45,'Alessandria','AL',1,2),
(45,'Ancona','AN',1,3),
(45,'Aosta','AO',1,4),
(45,'Arezzo','AR',1,5),
(45,'Ascoli Piceno','AP',1,6),
(45,'Asti','AT',1,7),
(45,'Avellino','AV',1,8),
(45,'Bari','BA',1,9),
(45,'Barletta-Andria-Trani','BT',1,10),
(45,'Belluno','BL',1,11),
(45,'Benevento','BN',1,12),
(45,'Bergamo','BG',1,13),
(45,'Biella','BI',1,14),
(45,'Bologna','BO',1,15),
(45,'Bolzano','BZ',1,16),
(45,'Brescia','BS',1,17),
(45,'Brindisi','BR',1,18),
(45,'Cagliari','CA',1,19),
(45,'Caltanissetta','CL',1,20),
(45,'Campobasso','CB',1,21),
(45,'Carbonia-Iglesias','CI',1,22),
(45,'Caserta','CE',1,23),
(45,'Catania','CT',1,24),
(45,'Catanzaro','CZ',1,25),
(45,'Chieti','	CH',1,26),
(45,'Como','CO',1,27),
(45,'Cosenza','CS',1,28),
(45,'Cremona','CR',1,29),
(45,'Crotone','KR',1,30),
(45,'Cuneo','CN',1,31),
(45,'Enna','EN',1,32),
(45,'Fermo','FM',1,33),
(45,'Ferrara','FE',1,34),
(45,'Firenze','FI',1,35),
(45,'Foggia','FG',1,36),
(45,'Forl-Cesena','FC',1,37),
(45,'Frosinone','FR',1,38),
(45,'Genova','GE',1,39),
(45,'Gorizia','GO',1,40),
(45,'Grosseto','GR',1,41),
(45,'Imperia','IM',1,42),
(45,'Isernia','IS',1,43),
(45,'La Spezia','SP',1,44),
(45,'Aquila','AQ',1,45),
(45,'Latina','LT',1,46),
(45,'Lecce','LE',1,47),
(45,'Lecco','LC',1,48),
(45,'Livorno','LI',1,49),
(45,'Lodi','LO',1,50),
(45,'Lucca','LU',1,51),
(45,'Macerata','MC',1,52),
(45,'Mantova','MN',1,	53),
(45,'Massa-Carrara','MS',1,54),
(45,'Matera','MT',1,55),
(45,'Messina','ME',1,56),
(45,'Milano','MI',1,57),
(45,'Modena','MO',1,58),
(45,'Monza Brianza','MB',1,59),
(45,'Napoli','NA',1,60),
(45,'Novara','NO',1,61),
(45,'Nuoro','NU',1,62),
(45,'Olbia-Tempio','OT',1,63),
(45,'Oristano','OR',1,64),
(45,'Padova','PD',1,65),
(45,'Palermo','PA',1,66),
(45,'Parma','PR',1,67),
(45,'Pavia','PV',1,68),
(45,'Perugia','PG',1,69),
(45,'Pesaro Urbino','PU',1,70),
(45,'Pescara','PE',1,71),
(45,'Piacenza','PC',1,72),
(45,'Pisa','PI',1,73),
(45,'Pistoia','PT',1,74),
(45,'Pordenone','PN',1,75),
(45,'Potenza','PZ',1,76),
(45,'Prato','PO',1,77),
(45,'Ragusa','RG',1,78),
(45,'Ravenna','RA',1,79),
(45,'Reggio Calabria','RC',1,80),
(45,'Reggio Emilia','RE',1,81),
(45,'Rieti','RI',1,82),
(45,'Rimini','RN',1,83),
(45,'Roma','RM',1,84),
(45,'Rovigo','RO',1,85),
(45,'Salerno','SA',1,86),
(45,'Medio Campidano','VS',1,87),
(45,'Sassari','SS',1,88),
(45,'Savona','SV',1,89),
(45,'Siena','SI',1,90),
(45,'Siracusa','SR',1,91),
(45,'Sondrio','SO',1,92),
(45,'Taranto','TA',1,93),
(45,'Teramo','TE',1,94),
(45,'Terni','TR',1,95),
(45,'Torino','TO',1,96),
(45,'Ogliastra','OG',1,97),
(45,'Trapani','TP',1,98),
(45,'Trento','TN',1,99),
(45,'Treviso','TV',1,100),
(45,'Trieste','TS',1,101),
(45,'Udine','UD',1,102),
(45,'Varese','VA',1,103),
(45,'Venezia','VE',1,104),
(45,'Verbano-Cusio-Ossola','VB',1,105),
(45,'Vercelli','VC',1,106),
(45,'Verona','VR',1,107),
(45,'Vibo Valentia','VV',1,108),
(45,'Vicenza','VI',1,109),
(45,'Viterbo','VT',1,110)

