subdivisions

Data source: ISO

14 rows where country_code = "CI"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
CI,CI-AB* CI CI-AB* Abidjan   fr    
CI,CI-BS* CI CI-BS* Bas-Sassandra   fr    
CI,CI-CM* CI CI-CM* Comoé   fr    
CI,CI-DN* CI CI-DN* Denguélé   fr    
CI,CI-GD* CI CI-GD* Gôh-Djiboua   fr    
CI,CI-LC* CI CI-LC* Lacs   fr    
CI,CI-LG* CI CI-LG* Lagunes   fr    
CI,CI-MG* CI CI-MG* Montagnes   fr    
CI,CI-SM* CI CI-SM* Sassandra-Marahoué   fr    
CI,CI-SV* CI CI-SV* Savanes   fr    
CI,CI-VB* CI CI-VB* Vallée du Bandama   fr    
CI,CI-WR* CI CI-WR* Woroba   fr    
CI,CI-YM* CI CI-YM* Yamoussoukro   fr    
CI,CI-ZZ* CI CI-ZZ* Zanzan   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
);