subdivisions

Data source: ISO

11 rows where country_code = "MZ"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
MZ,MZ-A* MZ MZ-A* Niassa   pt    
MZ,MZ-B MZ MZ-B Manica   pt    
MZ,MZ-G MZ MZ-G Gaza   pt    
MZ,MZ-I MZ MZ-I Inhambane   pt    
MZ,MZ-L MZ MZ-L Maputo   pt    
MZ,MZ-MPM MZ MZ-MPM Maputo   pt    
MZ,MZ-N MZ MZ-N Nampula   pt    
MZ,MZ-P MZ MZ-P Cabo Delgado   pt    
MZ,MZ-Q MZ MZ-Q Zambézia   pt    
MZ,MZ-S* MZ MZ-S* Sofala   pt    
MZ,MZ-T MZ MZ-T Tete   pt    

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