subdivisions

Data source: ISO

33 rows where country_code = "CO"

✎ 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
CO,CO-AMA* CO CO-AMA* Amazonas   es    
CO,CO-ANT* CO CO-ANT* Antioquia   es    
CO,CO-ARA* CO CO-ARA* Arauca   es    
CO,CO-ATL* CO CO-ATL* Atlántico   es    
CO,CO-BOL* CO CO-BOL* Bolívar   es    
CO,CO-BOY* CO CO-BOY* Boyacá   es    
CO,CO-CAL* CO CO-CAL* Caldas   es    
CO,CO-CAQ* CO CO-CAQ* Caquetá   es    
CO,CO-CAS* CO CO-CAS* Casanare   es    
CO,CO-CAU* CO CO-CAU* Cauca   es    
CO,CO-CES* CO CO-CES* Cesar   es    
CO,CO-CHO* CO CO-CHO* Chocó   es    
CO,CO-COR* CO CO-COR* Córdoba   es    
CO,CO-CUN* CO CO-CUN* Cundinamarca   es    
CO,CO-DC* CO CO-DC* Distrito Capital de Bogotá Distrito Capital es    
CO,CO-GUA* CO CO-GUA* Guainía   es    
CO,CO-GUV* CO CO-GUV* Guaviare   es    
CO,CO-HUI* CO CO-HUI* Huila   es    
CO,CO-LAG* CO CO-LAG* La Guajira   es    
CO,CO-MAG* CO CO-MAG* Magdalena   es    
CO,CO-MET* CO CO-MET* Meta   es    
CO,CO-NAR* CO CO-NAR* Nariño   es    
CO,CO-NSA* CO CO-NSA* Norte de Santander   es    
CO,CO-PUT* CO CO-PUT* Putumayo   es    
CO,CO-QUI* CO CO-QUI* Quindío   es    
CO,CO-RIS* CO CO-RIS* Risaralda   es    
CO,CO-SAN* CO CO-SAN* Santander   es    
CO,CO-SAP* CO CO-SAP* San Andrés, Providencia y Santa Catalina San Andrés es    
CO,CO-SUC* CO CO-SUC* Sucre   es    
CO,CO-TOL* CO CO-TOL* Tolima   es    
CO,CO-VAC* CO CO-VAC* Valle del Cauca Valle es    
CO,CO-VAU* CO CO-VAU* Vaupés   es    
CO,CO-VID* CO CO-VID* Vichada   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
);