subdivisions

Data source: ISO

10 rows where country_code = "GY"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
GY,GY-BA* GY GY-BA* Barima-Waini   en    
GY,GY-CU* GY GY-CU* Cuyuni-Mazaruni   en    
GY,GY-DE* GY GY-DE* Demerara-Mahaica   en    
GY,GY-EB* GY GY-EB* East Berbice-Corentyne   en    
GY,GY-ES* GY GY-ES* Essequibo Islands-West Demerara   en    
GY,GY-MA* GY GY-MA* Mahaica-Berbice   en    
GY,GY-PM* GY GY-PM* Pomeroon-Supenaam   en    
GY,GY-PT* GY GY-PT* Potaro-Siparuni   en    
GY,GY-UD* GY GY-UD* Upper Demerara-Berbice   en    
GY,GY-UT* GY GY-UT* Upper Takutu-Upper Essequibo   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
);