subdivisions

Data source: ISO

12 rows where country_code = "KP"

✎ 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
KP,KP-01 KP KP-01 Phyeongyang   ko KPS 11080:2002  
KP,KP-02 KP KP-02 Phyeongannamto   ko KPS 11080:2002  
KP,KP-03 KP KP-03 Phyeonganpukto   ko KPS 11080:2002  
KP,KP-04 KP KP-04 Jakangto   ko KPS 11080:2002  
KP,KP-05 KP KP-05 Hwanghainamto   ko KPS 11080:2002  
KP,KP-06 KP KP-06 Hwanghaipukto   ko KPS 11080:2002  
KP,KP-07 KP KP-07 Kangwǒn-do   ko McCune-Reischauer 1939  
KP,KP-08 KP KP-08 Hamkyeongnamto   ko KPS 11080:2002  
KP,KP-09 KP KP-09 Hamkyeongpukto   ko KPS 11080:2002  
KP,KP-10 KP KP-10 Ryangkangto   ko KPS 11080:2002  
KP,KP-13 KP KP-13 Rasǒn Najin Sǒnbong ko McCune-Reischauer 1939  
KP,KP-14* KP KP-14* Namp’o   ko McCune-Reischauer 1939  

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