subdivisions

Data source: ISO

11 rows where language_code = "sm"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
WS,WS-AA* WS WS-AA* A'ana   sm    
WS,WS-AL* WS WS-AL* Aiga-i-le-Tai   sm    
WS,WS-AT* WS WS-AT* Atua   sm    
WS,WS-FA* WS WS-FA* Fa'asaleleaga   sm    
WS,WS-GE* WS WS-GE* Gaga'emauga   sm    
WS,WS-GI* WS WS-GI* Gagaifomauga   sm    
WS,WS-PA* WS WS-PA* Palauli   sm    
WS,WS-SA* WS WS-SA* Satupa'itea   sm    
WS,WS-TU* WS WS-TU* Tuamasaga   sm    
WS,WS-VF* WS WS-VF* Va'a-o-Fonoti   sm    
WS,WS-VS* WS WS-VS* Vaisigano   sm    

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