Data source: ISO

22 rows where country_code = "MN"

View and edit SQL

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
MN MN-035 Orhon   mn BGN/PCGN 1964  
MN MN-037 Darhan uul   mn BGN/PCGN 1964  
MN MN-039 Hentiy   mn BGN/PCGN 1964  
MN MN-041 Hövsgöl   mn BGN/PCGN 1964  
MN MN-043 Hovd   mn BGN/PCGN 1964  
MN MN-046 Uvs   mn BGN/PCGN 1964  
MN MN-047 Töv   mn BGN/PCGN 1964  
MN MN-049 Selenge   mn BGN/PCGN 1964  
MN MN-051 Sühbaatar   mn BGN/PCGN 1964  
MN MN-053 Ömnögovĭ   mn BGN/PCGN 1964  
MN MN-055 Övörhangay   mn BGN/PCGN 1964  
MN MN-057 Dzavhan   mn BGN/PCGN 1964  
MN MN-059 Dundgovĭ   mn BGN/PCGN 1964  
MN MN-061 Dornod   mn BGN/PCGN 1964  
MN MN-063 Dornogovĭ   mn BGN/PCGN 1964  
MN MN-064 Govĭ-Sümber   mn BGN/PCGN 1964  
MN MN-065 Govĭ-Altay   mn BGN/PCGN 1964  
MN MN-067 Bulgan   mn BGN/PCGN 1964  
MN MN-069 Bayanhongor   mn BGN/PCGN 1964  
MN MN-071 Bayan-Ölgiy   mn BGN/PCGN 1964  
MN MN-073 Arhangay   mn BGN/PCGN 1964  
MN MN-1 Ulaanbaatar   mn BGN/PCGN 1964  

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