subdivisions

Data source: ISO

13 rows where country_code = "BE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: language_code, parent_subdivision

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
BE,BE-BRU BE BE-BRU Bruxelles-Capitale, Région de   fr    
BE,BE-VAN BE BE-VAN Antwerpen   nl   BE-VLG
BE,BE-VBR BE BE-VBR Vlaams-Brabant   nl   BE-VLG
BE,BE-VLG BE BE-VLG Vlaams Gewest   nl    
BE,BE-VLI BE BE-VLI Limburg   nl   BE-VLG
BE,BE-VOV BE BE-VOV Oost-Vlaanderen   nl   BE-VLG
BE,BE-VWV BE BE-VWV West-Vlaanderen   nl   BE-VLG
BE,BE-WAL BE BE-WAL wallonne, Région   fr    
BE,BE-WBR BE BE-WBR Brabant wallon   fr   BE-WAL
BE,BE-WHT BE BE-WHT Hainaut   fr   BE-WAL
BE,BE-WLG BE BE-WLG Liège   fr   BE-WAL
BE,BE-WLX BE BE-WLX Luxembourg   fr   BE-WAL
BE,BE-WNA BE BE-WNA Namur   fr   BE-WAL

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