subdivisions

Data source: ISO

26 rows where country_code = "CD"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
CD,CD-BC* CD CD-BC* Kongo Central   fr    
CD,CD-BU* CD CD-BU* Bas-Uélé   fr    
CD,CD-EQ CD CD-EQ Équateur   fr    
CD,CD-HK* CD CD-HK* Haut-Katanga   fr    
CD,CD-HL* CD CD-HL* Haut-Lomami   fr    
CD,CD-HU* CD CD-HU* Haut-Uélé   fr    
CD,CD-IT* CD CD-IT* Ituri   fr    
CD,CD-KC* CD CD-KC* Kasaï Central   fr    
CD,CD-KE CD CD-KE Kasaï Oriental   fr    
CD,CD-KG* CD CD-KG* Kwango   fr    
CD,CD-KL* CD CD-KL* Kwilu   fr    
CD,CD-KN CD CD-KN Kinshasa   fr    
CD,CD-KS* CD CD-KS* Kasaï   fr    
CD,CD-LO* CD CD-LO* Lomami   fr    
CD,CD-LU* CD CD-LU* Lualaba   fr    
CD,CD-MA* CD CD-MA* Maniema   fr    
CD,CD-MN* CD CD-MN* Mai-Ndombe   fr    
CD,CD-MO* CD CD-MO* Mongala   fr    
CD,CD-NK* CD CD-NK* Nord-Kivu   fr    
CD,CD-NU* CD CD-NU* Nord-Ubangi   fr    
CD,CD-SA* CD CD-SA* Sankuru   fr    
CD,CD-SK* CD CD-SK* Sud-Kivu   fr    
CD,CD-SU* CD CD-SU* Sud-Ubangi   fr    
CD,CD-TA* CD CD-TA* Tanganyika   fr    
CD,CD-TO* CD CD-TO* Tshopo   fr    
CD,CD-TU* CD CD-TU* Tshuapa   fr    

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