subdivisions

Data source: ISO

21 rows where country_code = "MV"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: local_variant, language_code, romanization_system

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
MV,MV-00* MV MV-00* South Ari Atoll   en    
MV,MV-01 MV MV-01 Addu City   en    
MV,MV-02 MV MV-02 North Ari Atoll   en    
MV,MV-03 MV MV-03 Faadhippolhu   en    
MV,MV-04 MV MV-04 Felidhu Atoll   en    
MV,MV-05 MV MV-05 Hahdhunmathi   en    
MV,MV-07 MV MV-07 Thiladhunmathee Uthuruburi Haa Alifu dv BGN/PCGN 1988  
MV,MV-08 MV MV-08 Kolhumadulu   en    
MV,MV-12 MV MV-12 Mulaku Atoll   en    
MV,MV-13 MV MV-13 North Maalhosmadulu   en    
MV,MV-14 MV MV-14 North Nilandhe Atoll   en    
MV,MV-17 MV MV-17 South Nilandhe Atoll   en    
MV,MV-20 MV MV-20 South Maalhosmadulu   en    
MV,MV-23 MV MV-23 Thiladhunmathee Dhekunuburi Haa Dhaalu dv BGN/PCGN 1988  
MV,MV-24 MV MV-24 North Miladhunmadulu   en    
MV,MV-25 MV MV-25 South Miladhunmadulu   en    
MV,MV-26 MV MV-26 Male Atoll   en    
MV,MV-27 MV MV-27 North Huvadhu Atoll   en    
MV,MV-28 MV MV-28 South Huvadhu Atoll   en    
MV,MV-29 MV MV-29 Fuvammulah   en    
MV,MV-MLE MV MV-MLE Male   en    

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