subdivisions

Data source: ISO

25 rows where country_code = "KH"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: local_variant, romanization_system

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
KH,KH-1 KH KH-1 Bântéay Méanchey   km BGN/PCGN 1972  
KH,KH-10 KH KH-10 Krâchéh   km BGN/PCGN 1972  
KH,KH-11 KH KH-11 Môndól Kiri   km BGN/PCGN 1972  
KH,KH-12 KH KH-12 Phnum Pénh   km BGN/PCGN 1972  
KH,KH-13 KH KH-13 Preăh Vihéar   km BGN/PCGN 1972  
KH,KH-14 KH KH-14 Prey Vêng Prey Veng km BGN/PCGN 1972  
KH,KH-15 KH KH-15 Poŭthĭsăt   km BGN/PCGN 1972  
KH,KH-16 KH KH-16 Rôtânôkiri   km BGN/PCGN 1972  
KH,KH-17 KH KH-17 Siĕmréab   km BGN/PCGN 1972  
KH,KH-18 KH KH-18 Preăh Seihânŭ   km BGN/PCGN 1972  
KH,KH-19 KH KH-19 Stueng Traeng Stung Treng km National draft 1997  
KH,KH-2 KH KH-2 Bătdâmbâng   km BGN/PCGN 1972  
KH,KH-20 KH KH-20 Svay Riĕng   km BGN/PCGN 1972  
KH,KH-21 KH KH-21 Takêv   km BGN/PCGN 1972  
KH,KH-22 KH KH-22 Ŏtdâr Méan Choăy   km BGN/PCGN 1972  
KH,KH-23 KH KH-23 Kêb   km BGN/PCGN 1972  
KH,KH-24* KH KH-24* Pailĭn   km BGN/PCGN 1972  
KH,KH-25* KH KH-25* Tbong Khmŭm   km BGN/PCGN 1972  
KH,KH-3 KH KH-3 Kâmpóng Cham   km BGN/PCGN 1972  
KH,KH-4 KH KH-4 Kâmpóng Chhnăng   km BGN/PCGN 1972  
KH,KH-5 KH KH-5 Kâmpóng Spœ   km BGN/PCGN 1972  
KH,KH-6 KH KH-6 Kâmpóng Thum   km BGN/PCGN 1972  
KH,KH-7 KH KH-7 Kâmpôt   km BGN/PCGN 1972  
KH,KH-8 KH KH-8 Kândal   km BGN/PCGN 1972  
KH,KH-9 KH KH-9 Kaôh Kŏng   km BGN/PCGN 1972  

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