subdivisions

Data source: ISO

15 rows where country_code = "LR"

✎ 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
LR,LR-BG* LR LR-BG* Bong   en    
LR,LR-BM* LR LR-BM* Bomi   en    
LR,LR-CM* LR LR-CM* Grand Cape Mount   en    
LR,LR-GB* LR LR-GB* Grand Bassa   en    
LR,LR-GG* LR LR-GG* Grand Gedeh   en    
LR,LR-GK* LR LR-GK* Grand Kru   en    
LR,LR-GP* LR LR-GP* Gbarpolu   en    
LR,LR-LO* LR LR-LO* Lofa   en    
LR,LR-MG* LR LR-MG* Margibi   en    
LR,LR-MO* LR LR-MO* Montserrado   en    
LR,LR-MY* LR LR-MY* Maryland   en    
LR,LR-NI* LR LR-NI* Nimba   en    
LR,LR-RG* LR LR-RG* River Gee   en    
LR,LR-RI* LR LR-RI* River Cess Rivercess en    
LR,LR-SI* LR LR-SI* Sinoe   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
);