subdivisions

Data source: ISO

16 rows where country_code = "CL"

✎ 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
CL,CL-AI* CL CL-AI* Aisén del General Carlos Ibañez del Campo Aysén, Aisén es    
CL,CL-AN* CL CL-AN* Antofagasta   es    
CL,CL-AP* CL CL-AP* Arica y Parinacota   es    
CL,CL-AR* CL CL-AR* La Araucanía   es    
CL,CL-AT* CL CL-AT* Atacama   es    
CL,CL-BI* CL CL-BI* Biobío   es    
CL,CL-CO* CL CL-CO* Coquimbo   es    
CL,CL-LI* CL CL-LI* Libertador General Bernardo O'Higgins O'Higgins es    
CL,CL-LL* CL CL-LL* Los Lagos   es    
CL,CL-LR* CL CL-LR* Los Ríos   es    
CL,CL-MA* CL CL-MA* Magallanes   es    
CL,CL-ML* CL CL-ML* Maule   es    
CL,CL-NB* CL CL-NB* Ñuble   es    
CL,CL-RM* CL CL-RM* Región Metropolitana de Santiago   es    
CL,CL-TA* CL CL-TA* Tarapacá   es    
CL,CL-VS* CL CL-VS* Valparaíso   es    

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