subdivisions

Data source: ISO

41 rows where country_code = "GN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: parent_subdivision

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
GN,GN-B* GN GN-B* Boké   fr    
GN,GN-BE* GN GN-BE* Beyla   fr   GN-N
GN,GN-BF* GN GN-BF* Boffa   fr   GN-B
GN,GN-BK* GN GN-BK* Boké   fr   GN-B
GN,GN-C* GN GN-C* Conakry   fr    
GN,GN-CO* GN GN-CO* Coyah   fr   GN-D
GN,GN-D* GN GN-D* Kindia   fr    
GN,GN-DB* GN GN-DB* Dabola   fr   GN-F
GN,GN-DI* GN GN-DI* Dinguiraye   fr   GN-F
GN,GN-DL* GN GN-DL* Dalaba   fr   GN-M
GN,GN-DU* GN GN-DU* Dubréka   fr   GN-D
GN,GN-F* GN GN-F* Faranah   fr    
GN,GN-FA* GN GN-FA* Faranah   fr   GN-F
GN,GN-FO* GN GN-FO* Forécariah   fr   GN-D
GN,GN-FR* GN GN-FR* Fria   fr   GN-B
GN,GN-GA* GN GN-GA* Gaoual   fr   GN-B
GN,GN-GU* GN GN-GU* Guékédou   fr   GN-N
GN,GN-K* GN GN-K* Kankan   fr    
GN,GN-KA* GN GN-KA* Kankan   fr   GN-K
GN,GN-KB* GN GN-KB* Koubia   fr   GN-L
GN,GN-KD* GN GN-KD* Kindia   fr   GN-D
GN,GN-KE* GN GN-KE* Kérouané   fr   GN-K
GN,GN-KN* GN GN-KN* Koundara   fr   GN-B
GN,GN-KO* GN GN-KO* Kouroussa   fr   GN-K
GN,GN-KS* GN GN-KS* Kissidougou   fr   GN-F
GN,GN-L* GN GN-L* Labé   fr    
GN,GN-LA* GN GN-LA* Labé   fr   GN-L
GN,GN-LE* GN GN-LE* Lélouma   fr   GN-L
GN,GN-LO* GN GN-LO* Lola   fr   GN-N
GN,GN-M* GN GN-M* Mamou   fr    
GN,GN-MC* GN GN-MC* Macenta   fr   GN-N
GN,GN-MD* GN GN-MD* Mandiana   fr   GN-K
GN,GN-ML* GN GN-ML* Mali   fr   GN-L
GN,GN-MM* GN GN-MM* Mamou   fr   GN-M
GN,GN-N* GN GN-N* Nzérékoré   fr    
GN,GN-NZ* GN GN-NZ* Nzérékoré   fr   GN-N
GN,GN-PI* GN GN-PI* Pita   fr   GN-M
GN,GN-SI* GN GN-SI* Siguiri   fr   GN-K
GN,GN-TE* GN GN-TE* Télimélé   fr   GN-D
GN,GN-TO* GN GN-TO* Tougué   fr   GN-L
GN,GN-YO* GN GN-YO* Yomou   fr   GN-N

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