subdivisions

Data source: ISO

16 rows where country_code = "GH"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
GH,GH-AA GH GH-AA Greater Accra   en    
GH,GH-AF* GH GH-AF* Ahafo   en    
GH,GH-AH GH GH-AH Ashanti   en    
GH,GH-BE* GH GH-BE* Bono East   en    
GH,GH-BO* GH GH-BO* Bono   en    
GH,GH-CP GH GH-CP Central   en    
GH,GH-EP GH GH-EP Eastern   en    
GH,GH-NE* GH GH-NE* North East   en    
GH,GH-NP GH GH-NP Northern   en    
GH,GH-OT* GH GH-OT* Oti   en    
GH,GH-SV* GH GH-SV* Savannah   en    
GH,GH-TV GH GH-TV Volta   en    
GH,GH-UE* GH GH-UE* Upper East   en    
GH,GH-UW* GH GH-UW* Upper West   en    
GH,GH-WN* GH GH-WN* Western North   en    
GH,GH-WP GH GH-WP Western   en    

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