subdivisions

Data source: ISO

32 rows where country_code = "BS"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
BS,BS-AK* BS BS-AK* Acklins   en    
BS,BS-BI* BS BS-BI* Bimini   en    
BS,BS-BP* BS BS-BP* Black Point   en    
BS,BS-BY* BS BS-BY* Berry Islands   en    
BS,BS-CE* BS BS-CE* Central Eleuthera   en    
BS,BS-CI* BS BS-CI* Cat Island   en    
BS,BS-CK* BS BS-CK* Crooked Island and Long Cay   en    
BS,BS-CO* BS BS-CO* Central Abaco   en    
BS,BS-CS* BS BS-CS* Central Andros   en    
BS,BS-EG* BS BS-EG* East Grand Bahama   en    
BS,BS-EX* BS BS-EX* Exuma   en    
BS,BS-FP* BS BS-FP* City of Freeport   en    
BS,BS-GC* BS BS-GC* Grand Cay   en    
BS,BS-HI* BS BS-HI* Harbour Island   en    
BS,BS-HT* BS BS-HT* Hope Town   en    
BS,BS-IN* BS BS-IN* Inagua   en    
BS,BS-LI* BS BS-LI* Long Island   en    
BS,BS-MC* BS BS-MC* Mangrove Cay   en    
BS,BS-MG* BS BS-MG* Mayaguana   en    
BS,BS-MI* BS BS-MI* Moore's Island   en    
BS,BS-NE* BS BS-NE* North Eleuthera   en    
BS,BS-NO* BS BS-NO* North Abaco   en    
BS,BS-NP* BS BS-NP* New Providence   en    
BS,BS-NS* BS BS-NS* North Andros   en    
BS,BS-RC* BS BS-RC* Rum Cay   en    
BS,BS-RI* BS BS-RI* Ragged Island   en    
BS,BS-SA* BS BS-SA* South Andros   en    
BS,BS-SE* BS BS-SE* South Eleuthera   en    
BS,BS-SO* BS BS-SO* South Abaco   en    
BS,BS-SS* BS BS-SS* San Salvador   en    
BS,BS-SW* BS BS-SW* Spanish Wells   en    
BS,BS-WG* BS BS-WG* West Grand Bahama   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
);