subdivisions

Data source: ISO

26 rows where country_code = "CH"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: language_code

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
CH,CH-AG CH CH-AG Aargau   de    
CH,CH-AI CH CH-AI Appenzell Innerrhoden   de    
CH,CH-AR CH CH-AR Appenzell Ausserrhoden   de    
CH,CH-BE CH CH-BE Berne   fr    
CH,CH-BL CH CH-BL Basel-Landschaft   de    
CH,CH-BS CH CH-BS Basel-Stadt   de    
CH,CH-FR CH CH-FR Fribourg   fr    
CH,CH-GE CH CH-GE Genève   fr    
CH,CH-GL CH CH-GL Glarus   de    
CH,CH-GR CH CH-GR Grischun   rm    
CH,CH-JU CH CH-JU Jura   fr    
CH,CH-LU CH CH-LU Luzern   de    
CH,CH-NE CH CH-NE Neuchâtel   fr    
CH,CH-NW CH CH-NW Nidwalden   de    
CH,CH-OW CH CH-OW Obwalden   de    
CH,CH-SG CH CH-SG Sankt Gallen   de    
CH,CH-SH CH CH-SH Schaffhausen   de    
CH,CH-SO CH CH-SO Solothurn   de    
CH,CH-SZ CH CH-SZ Schwyz   de    
CH,CH-TG CH CH-TG Thurgau   de    
CH,CH-TI CH CH-TI Ticino   it    
CH,CH-UR CH CH-UR Uri   de    
CH,CH-VD CH CH-VD Vaud   fr    
CH,CH-VS CH CH-VS Wallis   de    
CH,CH-ZG CH CH-ZG Zug   de    
CH,CH-ZH CH CH-ZH Zürich   de    

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