subdivisions

Data source: ISO

17 rows where country_code = "KR"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
KR,KR-11 KR KR-11 Seoul-teukbyeolsi Seoul ko National 2000  
KR,KR-26 KR KR-26 Busan-gwangyeoksi Busan ko National 2000  
KR,KR-27 KR KR-27 Daegu-gwangyeoksi Daegu ko National 2000  
KR,KR-28 KR KR-28 Incheon-gwangyeoksi Incheon ko National 2000  
KR,KR-29 KR KR-29 Gwangju-gwangyeoksi Gwangju ko National 2000  
KR,KR-30 KR KR-30 Daejeon-gwangyeoksi Daejeon ko National 2000  
KR,KR-31 KR KR-31 Ulsan-gwangyeoksi Ulsan ko National 2000  
KR,KR-41 KR KR-41 Gyeonggi-do Gyeonggi ko National 2000  
KR,KR-42 KR KR-42 Gangwon-do Gangwon ko National 2000  
KR,KR-43 KR KR-43 Chungcheongbuk-do Chungbuk ko National 2000  
KR,KR-44 KR KR-44 Chungcheongnam-do Chungnam ko National 2000  
KR,KR-45 KR KR-45 Jeollabuk-do Jeonbuk ko National 2000  
KR,KR-46 KR KR-46 Jeollanam-do Jeonnam ko National 2000  
KR,KR-47 KR KR-47 Gyeongsangbuk-do Gyeongbuk ko National 2000  
KR,KR-48 KR KR-48 Gyeongsangnam-do Gyeongnam ko National 2000  
KR,KR-49 KR KR-49 Jeju-teukbyeoljachido Jeju ko National 2000  
KR,KR-50 KR KR-50 Sejong   ko National 2000  

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