subdivisions

Data source: ISO

18 rows where country_code = "AO"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: local_variant

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
AO,AO-BGO* AO AO-BGO* Bengo   pt    
AO,AO-BGU* AO AO-BGU* Benguela   pt    
AO,AO-BIE* AO AO-BIE* Bié   pt    
AO,AO-CAB* AO AO-CAB* Cabinda   pt    
AO,AO-CCU* AO AO-CCU* Cuando Cubango Kuando Kubango pt    
AO,AO-CNN* AO AO-CNN* Cunene   pt    
AO,AO-CNO* AO AO-CNO* Cuanza-Norte Kwanza Norte pt    
AO,AO-CUS* AO AO-CUS* Cuanza-Sul Kwanza Sul pt    
AO,AO-HUA* AO AO-HUA* Huambo   pt    
AO,AO-HUI* AO AO-HUI* Huíla   pt    
AO,AO-LNO* AO AO-LNO* Lunda-Norte   pt    
AO,AO-LSU* AO AO-LSU* Lunda-Sul   pt    
AO,AO-LUA* AO AO-LUA* Luanda   pt    
AO,AO-MAL* AO AO-MAL* Malange   pt    
AO,AO-MOX* AO AO-MOX* Moxico   pt    
AO,AO-NAM* AO AO-NAM* Namibe   pt    
AO,AO-UIG* AO AO-UIG* Uíge   pt    
AO,AO-ZAI* AO AO-ZAI* Zaire   pt    

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