subdivisions

Data source: ISO

134 rows where language_code = "it"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country_code, local_variant, parent_subdivision

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
CH,CH-TI CH CH-TI Ticino   it    
IT,IT-21 IT IT-21 Piemonte   it    
IT,IT-23 IT IT-23 Valle d'Aosta   it    
IT,IT-25 IT IT-25 Lombardia   it    
IT,IT-34 IT IT-34 Veneto   it    
IT,IT-36 IT IT-36 Friuli Venezia Giulia   it    
IT,IT-42 IT IT-42 Liguria   it    
IT,IT-45 IT IT-45 Emilia-Romagna   it    
IT,IT-52 IT IT-52 Toscana   it    
IT,IT-55 IT IT-55 Umbria   it    
IT,IT-57 IT IT-57 Marche   it    
IT,IT-62 IT IT-62 Lazio   it    
IT,IT-65 IT IT-65 Abruzzo   it    
IT,IT-67 IT IT-67 Molise   it    
IT,IT-72 IT IT-72 Campania   it    
IT,IT-75 IT IT-75 Puglia   it    
IT,IT-77 IT IT-77 Basilicata   it    
IT,IT-78 IT IT-78 Calabria   it    
IT,IT-82 IT IT-82 Sicilia   it    
IT,IT-88 IT IT-88 Sardegna   it    
IT,IT-AG IT IT-AG Agrigento   it   IT-82
IT,IT-AL IT IT-AL Alessandria   it   IT-21
IT,IT-AN IT IT-AN Ancona   it   IT-57
IT,IT-AP IT IT-AP Ascoli Piceno   it   IT-57
IT,IT-AQ IT IT-AQ L'Aquila   it   IT-65
IT,IT-AR IT IT-AR Arezzo   it   IT-52
IT,IT-AT IT IT-AT Asti   it   IT-21
IT,IT-AV IT IT-AV Avellino   it   IT-72
IT,IT-BA IT IT-BA Bari   it   IT-75
IT,IT-BG IT IT-BG Bergamo   it   IT-25
IT,IT-BI IT IT-BI Biella   it   IT-21
IT,IT-BL IT IT-BL Belluno   it   IT-34
IT,IT-BN IT IT-BN Benevento   it   IT-72
IT,IT-BO IT IT-BO Bologna   it   IT-45
IT,IT-BR IT IT-BR Brindisi   it   IT-75
IT,IT-BS IT IT-BS Brescia   it   IT-25
IT,IT-BT IT IT-BT Barletta-Andria-Trani   it   IT-75
IT,IT-CA IT IT-CA Cagliari   it   IT-88
IT,IT-CB IT IT-CB Campobasso   it   IT-67
IT,IT-CE IT IT-CE Caserta   it   IT-72
IT,IT-CH IT IT-CH Chieti   it   IT-65
IT,IT-CL IT IT-CL Caltanissetta   it   IT-82
IT,IT-CN IT IT-CN Cuneo   it   IT-21
IT,IT-CO IT IT-CO Como   it   IT-25
IT,IT-CR IT IT-CR Cremona   it   IT-25
IT,IT-CS IT IT-CS Cosenza   it   IT-78
IT,IT-CT IT IT-CT Catania   it   IT-82
IT,IT-CZ IT IT-CZ Catanzaro   it   IT-78
IT,IT-EN IT IT-EN Enna   it   IT-82
IT,IT-FC* IT IT-FC* Forlì-Cesena   it   IT-45
IT,IT-FE IT IT-FE Ferrara   it   IT-45
IT,IT-FG IT IT-FG Foggia   it   IT-75
IT,IT-FI IT IT-FI Firenze   it   IT-52
IT,IT-FM IT IT-FM Fermo   it   IT-57
IT,IT-FR IT IT-FR Frosinone   it   IT-62
IT,IT-GE IT IT-GE Genova   it   IT-42
IT,IT-GO IT IT-GO Gorizia   it   IT-36
IT,IT-GR IT IT-GR Grosseto   it   IT-52
IT,IT-IM IT IT-IM Imperia   it   IT-42
IT,IT-IS IT IT-IS Isernia   it   IT-67
IT,IT-KR IT IT-KR Crotone   it   IT-78
IT,IT-LC IT IT-LC Lecco   it   IT-25
IT,IT-LE IT IT-LE Lecce   it   IT-75
IT,IT-LI IT IT-LI Livorno   it   IT-52
IT,IT-LO IT IT-LO Lodi   it   IT-25
IT,IT-LT IT IT-LT Latina   it   IT-62
IT,IT-LU IT IT-LU Lucca   it   IT-52
IT,IT-MB IT IT-MB Monza e Brianza   it   IT-25
IT,IT-MC IT IT-MC Macerata   it   IT-57
IT,IT-ME IT IT-ME Messina   it   IT-82
IT,IT-MI IT IT-MI Milano   it   IT-25
IT,IT-MN IT IT-MN Mantova   it   IT-25
IT,IT-MO IT IT-MO Modena   it   IT-45
IT,IT-MS IT IT-MS Massa-Carrara   it   IT-52
IT,IT-MT IT IT-MT Matera   it   IT-77
IT,IT-NA IT IT-NA Napoli   it   IT-72
IT,IT-NO IT IT-NO Novara   it   IT-21
IT,IT-NU IT IT-NU Nuoro   it   IT-88
IT,IT-OR IT IT-OR Oristano   it   IT-88
IT,IT-PA IT IT-PA Palermo   it   IT-82
IT,IT-PC IT IT-PC Piacenza   it   IT-45
IT,IT-PD IT IT-PD Padova   it   IT-34
IT,IT-PE IT IT-PE Pescara   it   IT-65
IT,IT-PG IT IT-PG Perugia   it   IT-55
IT,IT-PI IT IT-PI Pisa   it   IT-52
IT,IT-PN IT IT-PN Pordenone   it   IT-36
IT,IT-PO IT IT-PO Prato   it   IT-52
IT,IT-PR IT IT-PR Parma   it   IT-45
IT,IT-PT IT IT-PT Pistoia   it   IT-52
IT,IT-PU IT IT-PU Pesaro e Urbino   it   IT-57
IT,IT-PV IT IT-PV Pavia   it   IT-25
IT,IT-PZ IT IT-PZ Potenza   it   IT-77
IT,IT-RA IT IT-RA Ravenna   it   IT-45
IT,IT-RC IT IT-RC Reggio Calabria   it   IT-78
IT,IT-RE IT IT-RE Reggio Emilia   it   IT-45
IT,IT-RG IT IT-RG Ragusa   it   IT-82
IT,IT-RI IT IT-RI Rieti   it   IT-62
IT,IT-RM IT IT-RM Roma   it   IT-62
IT,IT-RN IT IT-RN Rimini   it   IT-45
IT,IT-RO IT IT-RO Rovigo   it   IT-34

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE subdivisions (
    country_code text NOT NULL
    , code_31662 text NOT NULL
    , name text
    , local_variant text
    , language_code text
    , romanization_system text
    , parent_subdivision text
    , PRIMARY KEY (country_code , code_31662)
    , FOREIGN KEY (country_code) REFERENCES countries (alpha_2_code) ON DELETE CASCADE
    , FOREIGN KEY (language_code) REFERENCES languages (alpha_2_code) ON DELETE CASCADE
);