Italy - Formatting standards & code snippets

Here is a complete list of standards and formats used in Italy. It includes a full list of ISO codes, number, date, currency, telephone and address formats. You will also get code examples on how to perform the most common formatting operations in Java, C#, JavaScript and PHP. Multiple resource files are made available, mainly the complete list of states, in different formats such as CSV, XML, JSON, HTML and SQL.

What are the ISO-3166-1 codes for Italy?

  • Alpha-2: IT
  • Alpha-3: ITA
  • Numeric: 380
  • Java Locale Code: it_IT
  • .Net CultureInfo Code: it-IT
  • PHP Locale Code: it_IT

What is the official language in Italy?

  • Italian

What is the date format in Italy?

The date format in Italy is little-endian:

  • Format: dd/mm/yyyy
    Ex: 03/12/2014 for December 3rd 2014
Formatting a date in Java:
Locale locale = new Locale("it", "IT");
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy", locale);
sdf.format(new Date());
Formatting a date in C#:
CultureInfo ci = CultureInfo.GetCultureInfo("it-IT");
DateTime.Now.ToString("dd/MM/yyyy", ci);
Formatting a date in JavaScript:
let date = new Date();
date.toLocaleDateString('it-IT');
Formatting a date in PHP:
date("d/m/Y");

What is the time format in Italy?

The time format in Italy is 24-hour notation in most cases.

  • Format: HH:mm[:ss]
    Ex: 09:00 for 09:00AM, and 21:00 for 09:00PM
Formatting time in Java:
Locale locale = new Locale("it", "IT");
SimpleDateFormat sdf = new SimpleDateFormat("HH:mm:ss", locale);
sdf.format(new Date());
Formatting time in C#:
CultureInfo ci = CultureInfo.GetCultureInfo("it-IT");
DateTime.Now.ToString("HH:mm:ss", ci);
Formatting time in JavaScript:
let time = new Date();
date.toLocaleTimeString('it-IT', {hour12: false});
Formatting time in PHP:
date("H:i:s");

What is the numeric format in Italy?

  • Format: 999.999.999,99
    • Group Size: 3
    • Grouping Character: . (dot)
    • Decimal Character: , (comma)
Formatting numbers in Java:
Locale locale = new Locale("it", "IT");
NumberFormat numberFormat = NumberFormat.getNumberInstance(locale);
numberFormat.format(999999999.99d);
Formatting numbers in C#:
double d = 999999999.99d;
d.ToString("n", CultureInfo.GetCultureInfo("it-IT")));
Formatting numbers in JavaScript:
let number = 999999999.99;
number.toLocaleString('it-IT');
Formatting numbers in PHP:
$fmt = new NumberFormatter($locale = 'it_IT', NumberFormatter::DECIMAL);
$fmt->format(999999999.99);

What is the currency format in Italy?

  • Format: 999.999.999,99 €
    • Group Size: 3
    • Grouping Character: . (dot)
    • Decimal Character: , (comma)
    • Currency Symbol: €
    • Currency Symbol Position: After number
    • Currency Name: Euro (EUR)
Formatting currency in Java:
Locale locale = new Locale("it", "IT");
NumberFormat numberFormat = NumberFormat.getCurrencyInstance(locale);
numberFormat.format(999999999.99d);
Formatting currency in C#:
double d = 999999999.99d;
d.ToString("c", CultureInfo.GetCultureInfo("it-IT")));
Formatting currency in JavaScript:
let number = 999999999.99;
number.toLocaleString('it-IT', {currency: 'EUR', style: 'currency'});
Formatting currency in PHP:
$fmt = new NumberFormatter($locale = 'it_IT', NumberFormatter::CURRENCY);
$fmt->format(999999999.99);

Download list of provinces for Italy in CSV, JSON, HTML, SQL and XML


List of provinces: HTML - Select Control

----------------------------------
 ISO_3166-2 code + name - Italian
----------------------------------
<select>
	<option value="IT-AG">Agrigento</option>
	<option value="IT-AL">Alessandria</option>
	<option value="IT-AN">Ancona</option>
	<option value="IT-AO">Valle d'Aosta</option>
	<option value="IT-AR">Arezzo</option>
	<option value="IT-AP">Ascoli Piceno</option>
	<option value="IT-AT">Asti</option>
	<option value="IT-AV">Avellino</option>
	<option value="IT-BT">Barletta-Andria-Trani</option>
	<option value="IT-BL">Belluno</option>
	<option value="IT-BN">Benevento</option>
	<option value="IT-BG">Bergamo</option>
	<option value="IT-BI">Biella</option>
	<option value="IT-BZ">Bolzano</option>
	<option value="IT-BS">Brescia</option>
	<option value="IT-BR">Brindisi</option>
	<option value="IT-CL">Caltanissetta</option>
	<option value="IT-CB">Campobasso</option>
	<option value="IT-CE">Caserta</option>
	<option value="IT-CZ">Catanzaro</option>
	<option value="IT-CH">Chieti</option>
	<option value="IT-CO">Como</option>
	<option value="IT-CS">Cosenza</option>
	<option value="IT-CR">Cremona</option>
	<option value="IT-KR">Crotone</option>
	<option value="IT-CN">Cuneo</option>
	<option value="IT-EN">Enna</option>
	<option value="IT-FM">Fermo</option>
	<option value="IT-FE">Ferrara</option>
	<option value="IT-FG">Foggia</option>
	<option value="IT-FC">Forlì-Cesena</option>
	<option value="IT-FR">Frosinone</option>
	<option value="IT-GO">Gorizia</option>
	<option value="IT-GR">Grosseto</option>
	<option value="IT-IM">Imperia</option>
	<option value="IT-IS">Isernia</option>
	<option value="IT-SP">La Spezia</option>
	<option value="IT-AQ">L'Aquila</option>
	<option value="IT-LT">Latina</option>
	<option value="IT-LE">Lecce</option>
	<option value="IT-LC">Lecco</option>
	<option value="IT-LI">Livorno</option>
	<option value="IT-LO">Lodi</option>
	<option value="IT-LU">Lucca</option>
	<option value="IT-MC">Macerata</option>
	<option value="IT-MN">Mantova</option>
	<option value="IT-MS">Massa-Carrara</option>
	<option value="IT-MT">Matera</option>
	<option value="IT-ME">Messina</option>
	<option value="IT-MB">Monza e Brianza</option>
	<option value="IT-MO">Modena</option>
	<option value="IT-NO">Novara</option>
	<option value="IT-NU">Nuoro</option>
	<option value="IT-OR">Oristano</option>
	<option value="IT-PD">Padova</option>
	<option value="IT-PR">Parma</option>
	<option value="IT-PV">Pavia</option>
	<option value="IT-PG">Perugia</option>
	<option value="IT-PU">Pesaro e Urbino</option>
	<option value="IT-PE">Pescara</option>
	<option value="IT-PC">Piacenza</option>
	<option value="IT-PI">Pisa</option>
	<option value="IT-PT">Pistoia</option>
	<option value="IT-PN">Pordenone</option>
	<option value="IT-PZ">Potenza</option>
	<option value="IT-PO">Prato</option>
	<option value="IT-RG">Ragusa</option>
	<option value="IT-RA">Ravenna</option>
	<option value="IT-RE">Reggio Emilia</option>
	<option value="IT-RI">Rieti</option>
	<option value="IT-RN">Rimini</option>
	<option value="IT-RO">Rovigo</option>
	<option value="IT-SA">Salerno</option>
	<option value="IT-SS">Sassari</option>
	<option value="IT-SV">Savona</option>
	<option value="IT-SI">Siena</option>
	<option value="IT-SR">Siracusa</option>
	<option value="IT-SO">Sondrio</option>
	<option value="IT-TA">Taranto</option>
	<option value="IT-TE">Teramo</option>
	<option value="IT-TR">Terni</option>
	<option value="IT-TP">Trapani</option>
	<option value="IT-TN">Trento</option>
	<option value="IT-TV">Treviso</option>
	<option value="IT-TS">Trieste</option>
	<option value="IT-UD">Udine</option>
	<option value="IT-VA">Varese</option>
	<option value="IT-VB">Verbano-Cusio-Ossola</option>
	<option value="IT-VC">Vercelli</option>
	<option value="IT-VR">Verona</option>
	<option value="IT-VV">Vibo Valentia</option>
	<option value="IT-VI">Vicenza</option>
	<option value="IT-VT">Viterbo</option>
</select>

List of provinces: CSV

code,name
IT-AG,"Agrigento"
IT-AL,"Alessandria"
IT-AN,"Ancona"
IT-AO,"Valle d'Aosta"
IT-AR,"Arezzo"
IT-AP,"Ascoli Piceno"
IT-AT,"Asti"
IT-AV,"Avellino"
IT-BT,"Barletta-Andria-Trani"
IT-BL,"Belluno"
IT-BN,"Benevento"
IT-BG,"Bergamo"
IT-BI,"Biella"
IT-BZ,"Bolzano"
IT-BS,"Brescia"
IT-BR,"Brindisi"
IT-CL,"Caltanissetta"
IT-CB,"Campobasso"
IT-CE,"Caserta"
IT-CZ,"Catanzaro"
IT-CH,"Chieti"
IT-CO,"Como"
IT-CS,"Cosenza"
IT-CR,"Cremona"
IT-KR,"Crotone"
IT-CN,"Cuneo"
IT-EN,"Enna"
IT-FM,"Fermo"
IT-FE,"Ferrara"
IT-FG,"Foggia"
IT-FC,"Forlì-Cesena"
IT-FR,"Frosinone"
IT-GO,"Gorizia"
IT-GR,"Grosseto"
IT-IM,"Imperia"
IT-IS,"Isernia"
IT-SP,"La Spezia"
IT-AQ,"L'Aquila"
IT-LT,"Latina"
IT-LE,"Lecce"
IT-LC,"Lecco"
IT-LI,"Livorno"
IT-LO,"Lodi"
IT-LU,"Lucca"
IT-MC,"Macerata"
IT-MN,"Mantova"
IT-MS,"Massa-Carrara"
IT-MT,"Matera"
IT-ME,"Messina"
IT-MB,"Monza e Brianza"
IT-MO,"Modena"
IT-NO,"Novara"
IT-NU,"Nuoro"
IT-OR,"Oristano"
IT-PD,"Padova"
IT-PR,"Parma"
IT-PV,"Pavia"
IT-PG,"Perugia"
IT-PU,"Pesaro e Urbino"
IT-PE,"Pescara"
IT-PC,"Piacenza"
IT-PI,"Pisa"
IT-PT,"Pistoia"
IT-PN,"Pordenone"
IT-PZ,"Potenza"
IT-PO,"Prato"
IT-RG,"Ragusa"
IT-RA,"Ravenna"
IT-RE,"Reggio Emilia"
IT-RI,"Rieti"
IT-RN,"Rimini"
IT-RO,"Rovigo"
IT-SA,"Salerno"
IT-SS,"Sassari"
IT-SV,"Savona"
IT-SI,"Siena"
IT-SR,"Siracusa"
IT-SO,"Sondrio"
IT-TA,"Taranto"
IT-TE,"Teramo"
IT-TR,"Terni"
IT-TP,"Trapani"
IT-TN,"Trento"
IT-TV,"Treviso"
IT-TS,"Trieste"
IT-UD,"Udine"
IT-VA,"Varese"
IT-VB,"Verbano-Cusio-Ossola"
IT-VC,"Vercelli"
IT-VR,"Verona"
IT-VV,"Vibo Valentia"
IT-VI,"Vicenza"
IT-VT,"Viterbo"

List of provinces: JSON

--------------------------------
 ISO-3166-2 code + Name - Italian
--------------------------------
[
	{code: "IT-AG", name: "Agrigento"},
	{code: "IT-AL", name: "Alessandria"},
	{code: "IT-AN", name: "Ancona"},
	{code: "IT-AO", name: "Valle d'Aosta"},
	{code: "IT-AR", name: "Arezzo"},
	{code: "IT-AP", name: "Ascoli Piceno"},
	{code: "IT-AT", name: "Asti"},
	{code: "IT-AV", name: "Avellino"},
	{code: "IT-BT", name: "Barletta-Andria-Trani"},
	{code: "IT-BL", name: "Belluno"},
	{code: "IT-BN", name: "Benevento"},
	{code: "IT-BG", name: "Bergamo"},
	{code: "IT-BI", name: "Biella"},
	{code: "IT-BZ", name: "Bolzano"},
	{code: "IT-BS", name: "Brescia"},
	{code: "IT-BR", name: "Brindisi"},
	{code: "IT-CL", name: "Caltanissetta"},
	{code: "IT-CB", name: "Campobasso"},
	{code: "IT-CE", name: "Caserta"},
	{code: "IT-CZ", name: "Catanzaro"},
	{code: "IT-CH", name: "Chieti"},
	{code: "IT-CO", name: "Como"},
	{code: "IT-CS", name: "Cosenza"},
	{code: "IT-CR", name: "Cremona"},
	{code: "IT-KR", name: "Crotone"},
	{code: "IT-CN", name: "Cuneo"},
	{code: "IT-EN", name: "Enna"},
	{code: "IT-FM", name: "Fermo"},
	{code: "IT-FE", name: "Ferrara"},
	{code: "IT-FG", name: "Foggia"},
	{code: "IT-FC", name: "Forlì-Cesena"},
	{code: "IT-FR", name: "Frosinone"},
	{code: "IT-GO", name: "Gorizia"},
	{code: "IT-GR", name: "Grosseto"},
	{code: "IT-IM", name: "Imperia"},
	{code: "IT-IS", name: "Isernia"},
	{code: "IT-SP", name: "La Spezia"},
	{code: "IT-AQ", name: "L'Aquila"},
	{code: "IT-LT", name: "Latina"},
	{code: "IT-LE", name: "Lecce"},
	{code: "IT-LC", name: "Lecco"},
	{code: "IT-LI", name: "Livorno"},
	{code: "IT-LO", name: "Lodi"},
	{code: "IT-LU", name: "Lucca"},
	{code: "IT-MC", name: "Macerata"},
	{code: "IT-MN", name: "Mantova"},
	{code: "IT-MS", name: "Massa-Carrara"},
	{code: "IT-MT", name: "Matera"},
	{code: "IT-ME", name: "Messina"},
	{code: "IT-MB", name: "Monza e Brianza"},
	{code: "IT-MO", name: "Modena"},
	{code: "IT-NO", name: "Novara"},
	{code: "IT-NU", name: "Nuoro"},
	{code: "IT-OR", name: "Oristano"},
	{code: "IT-PD", name: "Padova"},
	{code: "IT-PR", name: "Parma"},
	{code: "IT-PV", name: "Pavia"},
	{code: "IT-PG", name: "Perugia"},
	{code: "IT-PU", name: "Pesaro e Urbino"},
	{code: "IT-PE", name: "Pescara"},
	{code: "IT-PC", name: "Piacenza"},
	{code: "IT-PI", name: "Pisa"},
	{code: "IT-PT", name: "Pistoia"},
	{code: "IT-PN", name: "Pordenone"},
	{code: "IT-PZ", name: "Potenza"},
	{code: "IT-PO", name: "Prato"},
	{code: "IT-RG", name: "Ragusa"},
	{code: "IT-RA", name: "Ravenna"},
	{code: "IT-RE", name: "Reggio Emilia"},
	{code: "IT-RI", name: "Rieti"},
	{code: "IT-RN", name: "Rimini"},
	{code: "IT-RO", name: "Rovigo"},
	{code: "IT-SA", name: "Salerno"},
	{code: "IT-SS", name: "Sassari"},
	{code: "IT-SV", name: "Savona"},
	{code: "IT-SI", name: "Siena"},
	{code: "IT-SR", name: "Siracusa"},
	{code: "IT-SO", name: "Sondrio"},
	{code: "IT-TA", name: "Taranto"},
	{code: "IT-TE", name: "Teramo"},
	{code: "IT-TR", name: "Terni"},
	{code: "IT-TP", name: "Trapani"},
	{code: "IT-TN", name: "Trento"},
	{code: "IT-TV", name: "Treviso"},
	{code: "IT-TS", name: "Trieste"},
	{code: "IT-UD", name: "Udine"},
	{code: "IT-VA", name: "Varese"},
	{code: "IT-VB", name: "Verbano-Cusio-Ossola"},
	{code: "IT-VC", name: "Vercelli"},
	{code: "IT-VR", name: "Verona"},
	{code: "IT-VV", name: "Vibo Valentia"},
	{code: "IT-VI", name: "Vicenza"},
	{code: "IT-VT", name: "Viterbo"}
]

List of provinces: SQL

-- -----------------------------------------------------
-- Table `province`
-- -----------------------------------------------------
DROP TABLE IF EXISTS province;

CREATE TABLE IF NOT EXISTS province (
  id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  code VARCHAR(6) NOT NULL,
  name VARCHAR(50) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE INDEX id_UNIQUE (id ASC),
  UNIQUE INDEX code_UNIQUE (code ASC)
) ENGINE = InnoDB;

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

List of provinces: XML

<!-- ISO 3166-2 code + name - Italian -->
<?xml version="1.0" encoding="UTF-8"?>
<provinces>
	<province>
		<code>IT-AG</code>
		<name>Agrigento</name>
	</province>
	<province>
		<code>IT-AL</code>
		<name>Alessandria</name>
	</province>
	<province>
		<code>IT-AN</code>
		<name>Ancona</name>
	</province>
	<province>
		<code>IT-AO</code>
		<name>Valle d'Aosta</name>
	</province>
	<province>
		<code>IT-AR</code>
		<name>Arezzo</name>
	</province>
	<province>
		<code>IT-AP</code>
		<name>Ascoli Piceno</name>
	</province>
	<province>
		<code>IT-AT</code>
		<name>Asti</name>
	</province>
	<province>
		<code>IT-AV</code>
		<name>Avellino</name>
	</province>
	<province>
		<code>IT-BT</code>
		<name>Barletta-Andria-Trani</name>
	</province>
	<province>
		<code>IT-BL</code>
		<name>Belluno</name>
	</province>
	<province>
		<code>IT-BN</code>
		<name>Benevento</name>
	</province>
	<province>
		<code>IT-BG</code>
		<name>Bergamo</name>
	</province>
	<province>
		<code>IT-BI</code>
		<name>Biella</name>
	</province>
	<province>
		<code>IT-BZ</code>
		<name>Bolzano</name>
	</province>
	<province>
		<code>IT-BS</code>
		<name>Brescia</name>
	</province>
	<province>
		<code>IT-BR</code>
		<name>Brindisi</name>
	</province>
	<province>
		<code>IT-CL</code>
		<name>Caltanissetta</name>
	</province>
	<province>
		<code>IT-CB</code>
		<name>Campobasso</name>
	</province>
	<province>
		<code>IT-CE</code>
		<name>Caserta</name>
	</province>
	<province>
		<code>IT-CZ</code>
		<name>Catanzaro</name>
	</province>
	<province>
		<code>IT-CH</code>
		<name>Chieti</name>
	</province>
	<province>
		<code>IT-CO</code>
		<name>Como</name>
	</province>
	<province>
		<code>IT-CS</code>
		<name>Cosenza</name>
	</province>
	<province>
		<code>IT-CR</code>
		<name>Cremona</name>
	</province>
	<province>
		<code>IT-KR</code>
		<name>Crotone</name>
	</province>
	<province>
		<code>IT-CN</code>
		<name>Cuneo</name>
	</province>
	<province>
		<code>IT-EN</code>
		<name>Enna</name>
	</province>
	<province>
		<code>IT-FM</code>
		<name>Fermo</name>
	</province>
	<province>
		<code>IT-FE</code>
		<name>Ferrara</name>
	</province>
	<province>
		<code>IT-FG</code>
		<name>Foggia</name>
	</province>
	<province>
		<code>IT-FC</code>
		<name>Forlì-Cesena</name>
	</province>
	<province>
		<code>IT-FR</code>
		<name>Frosinone</name>
	</province>
	<province>
		<code>IT-GO</code>
		<name>Gorizia</name>
	</province>
	<province>
		<code>IT-GR</code>
		<name>Grosseto</name>
	</province>
	<province>
		<code>IT-IM</code>
		<name>Imperia</name>
	</province>
	<province>
		<code>IT-IS</code>
		<name>Isernia</name>
	</province>
	<province>
		<code>IT-SP</code>
		<name>La Spezia</name>
	</province>
	<province>
		<code>IT-AQ</code>
		<name>L'Aquila</name>
	</province>
	<province>
		<code>IT-LT</code>
		<name>Latina</name>
	</province>
	<province>
		<code>IT-LE</code>
		<name>Lecce</name>
	</province>
	<province>
		<code>IT-LC</code>
		<name>Lecco</name>
	</province>
	<province>
		<code>IT-LI</code>
		<name>Livorno</name>
	</province>
	<province>
		<code>IT-LO</code>
		<name>Lodi</name>
	</province>
	<province>
		<code>IT-LU</code>
		<name>Lucca</name>
	</province>
	<province>
		<code>IT-MC</code>
		<name>Macerata</name>
	</province>
	<province>
		<code>IT-MN</code>
		<name>Mantova</name>
	</province>
	<province>
		<code>IT-MS</code>
		<name>Massa-Carrara</name>
	</province>
	<province>
		<code>IT-MT</code>
		<name>Matera</name>
	</province>
	<province>
		<code>IT-ME</code>
		<name>Messina</name>
	</province>
	<province>
		<code>IT-MB</code>
		<name>Monza e Brianza</name>
	</province>
	<province>
		<code>IT-MO</code>
		<name>Modena</name>
	</province>
	<province>
		<code>IT-NO</code>
		<name>Novara</name>
	</province>
	<province>
		<code>IT-NU</code>
		<name>Nuoro</name>
	</province>
	<province>
		<code>IT-OR</code>
		<name>Oristano</name>
	</province>
	<province>
		<code>IT-PD</code>
		<name>Padova</name>
	</province>
	<province>
		<code>IT-PR</code>
		<name>Parma</name>
	</province>
	<province>
		<code>IT-PV</code>
		<name>Pavia</name>
	</province>
	<province>
		<code>IT-PG</code>
		<name>Perugia</name>
	</province>
	<province>
		<code>IT-PU</code>
		<name>Pesaro e Urbino</name>
	</province>
	<province>
		<code>IT-PE</code>
		<name>Pescara</name>
	</province>
	<province>
		<code>IT-PC</code>
		<name>Piacenza</name>
	</province>
	<province>
		<code>IT-PI</code>
		<name>Pisa</name>
	</province>
	<province>
		<code>IT-PT</code>
		<name>Pistoia</name>
	</province>
	<province>
		<code>IT-PN</code>
		<name>Pordenone</name>
	</province>
	<province>
		<code>IT-PZ</code>
		<name>Potenza</name>
	</province>
	<province>
		<code>IT-PO</code>
		<name>Prato</name>
	</province>
	<province>
		<code>IT-RG</code>
		<name>Ragusa</name>
	</province>
	<province>
		<code>IT-RA</code>
		<name>Ravenna</name>
	</province>
	<province>
		<code>IT-RE</code>
		<name>Reggio Emilia</name>
	</province>
	<province>
		<code>IT-RI</code>
		<name>Rieti</name>
	</province>
	<province>
		<code>IT-RN</code>
		<name>Rimini</name>
	</province>
	<province>
		<code>IT-RO</code>
		<name>Rovigo</name>
	</province>
	<province>
		<code>IT-SA</code>
		<name>Salerno</name>
	</province>
	<province>
		<code>IT-SS</code>
		<name>Sassari</name>
	</province>
	<province>
		<code>IT-SV</code>
		<name>Savona</name>
	</province>
	<province>
		<code>IT-SI</code>
		<name>Siena</name>
	</province>
	<province>
		<code>IT-SR</code>
		<name>Siracusa</name>
	</province>
	<province>
		<code>IT-SO</code>
		<name>Sondrio</name>
	</province>
	<province>
		<code>IT-TA</code>
		<name>Taranto</name>
	</province>
	<province>
		<code>IT-TE</code>
		<name>Teramo</name>
	</province>
	<province>
		<code>IT-TR</code>
		<name>Terni</name>
	</province>
	<province>
		<code>IT-TP</code>
		<name>Trapani</name>
	</province>
	<province>
		<code>IT-TN</code>
		<name>Trento</name>
	</province>
	<province>
		<code>IT-TV</code>
		<name>Treviso</name>
	</province>
	<province>
		<code>IT-TS</code>
		<name>Trieste</name>
	</province>
	<province>
		<code>IT-UD</code>
		<name>Udine</name>
	</province>
	<province>
		<code>IT-VA</code>
		<name>Varese</name>
	</province>
	<province>
		<code>IT-VB</code>
		<name>Verbano-Cusio-Ossola</name>
	</province>
	<province>
		<code>IT-VC</code>
		<name>Vercelli</name>
	</province>
	<province>
		<code>IT-VR</code>
		<name>Verona</name>
	</province>
	<province>
		<code>IT-VV</code>
		<name>Vibo Valentia</name>
	</province>
	<province>
		<code>IT-VI</code>
		<name>Vicenza</name>
	</province>
	<province>
		<code>IT-VT</code>
		<name>Viterbo</name>
	</province>
</provinces>