subdivisions

Data source: ISO

68 rows where country_code = "MT"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
MT,MT-01* MT MT-01* Attard   mt    
MT,MT-02* MT MT-02* Balzan   mt    
MT,MT-03* MT MT-03* Birgu   mt    
MT,MT-04* MT MT-04* Birkirkara   mt    
MT,MT-05* MT MT-05* Birżebbuġa   mt    
MT,MT-06* MT MT-06* Bormla   mt    
MT,MT-07* MT MT-07* Dingli   mt    
MT,MT-08* MT MT-08* Fgura   mt    
MT,MT-09* MT MT-09* Floriana   mt    
MT,MT-10* MT MT-10* Fontana   mt    
MT,MT-11* MT MT-11* Gudja   mt    
MT,MT-12* MT MT-12* Gżira   mt    
MT,MT-13* MT MT-13* Għajnsielem   mt    
MT,MT-14* MT MT-14* Għarb   mt    
MT,MT-15* MT MT-15* Għargħur   mt    
MT,MT-16* MT MT-16* Għasri   mt    
MT,MT-17* MT MT-17* Għaxaq   mt    
MT,MT-18* MT MT-18* Ħamrun   mt    
MT,MT-19* MT MT-19* Iklin   mt    
MT,MT-20* MT MT-20* Isla   mt    
MT,MT-21* MT MT-21* Kalkara   mt    
MT,MT-22* MT MT-22* Kerċem   mt    
MT,MT-23* MT MT-23* Kirkop   mt    
MT,MT-24* MT MT-24* Lija   mt    
MT,MT-25* MT MT-25* Luqa   mt    
MT,MT-26* MT MT-26* Marsa   mt    
MT,MT-27* MT MT-27* Marsaskala   mt    
MT,MT-28* MT MT-28* Marsaxlokk   mt    
MT,MT-29* MT MT-29* Mdina   mt    
MT,MT-30* MT MT-30* Mellieħa   mt    
MT,MT-31* MT MT-31* Mġarr   mt    
MT,MT-32* MT MT-32* Mosta   mt    
MT,MT-33* MT MT-33* Mqabba   mt    
MT,MT-34* MT MT-34* Msida   mt    
MT,MT-35* MT MT-35* Mtarfa   mt    
MT,MT-36* MT MT-36* Munxar   mt    
MT,MT-37* MT MT-37* Nadur   mt    
MT,MT-38* MT MT-38* Naxxar   mt    
MT,MT-39* MT MT-39* Paola   mt    
MT,MT-40* MT MT-40* Pembroke   mt    
MT,MT-41* MT MT-41* Pietà   mt    
MT,MT-42* MT MT-42* Qala   mt    
MT,MT-43* MT MT-43* Qormi   mt    
MT,MT-44* MT MT-44* Qrendi   mt    
MT,MT-45* MT MT-45* Rabat Għawdex   mt    
MT,MT-46* MT MT-46* Rabat Malta   mt    
MT,MT-47* MT MT-47* Safi   mt    
MT,MT-48* MT MT-48* San Ġiljan   mt    
MT,MT-49* MT MT-49* San Ġwann   mt    
MT,MT-50* MT MT-50* San Lawrenz   mt    
MT,MT-51* MT MT-51* San Pawl il-Baħar   mt    
MT,MT-52* MT MT-52* Sannat   mt    
MT,MT-53* MT MT-53* Santa Luċija   mt    
MT,MT-54* MT MT-54* Santa Venera   mt    
MT,MT-55* MT MT-55* Siġġiewi   mt    
MT,MT-56* MT MT-56* Sliema   mt    
MT,MT-57* MT MT-57* Swieqi   mt    
MT,MT-58* MT MT-58* Ta' Xbiex   mt    
MT,MT-59* MT MT-59* Tarxien   mt    
MT,MT-60* MT MT-60* Valletta   mt    
MT,MT-61* MT MT-61* Xagħra   mt    
MT,MT-62* MT MT-62* Xewkija   mt    
MT,MT-63* MT MT-63* Xgħajra   mt    
MT,MT-64* MT MT-64* Żabbar   mt    
MT,MT-65* MT MT-65* Żebbuġ Għawdex   mt    
MT,MT-66* MT MT-66* Żebbuġ Malta   mt    
MT,MT-67* MT MT-67* Żejtun   mt    
MT,MT-68* MT MT-68* Żurrieq   mt    

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
);