subdivisions

Data source: ISO

24 rows where country_code = "EC"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
EC,EC-A EC EC-A Azuay   es    
EC,EC-B EC EC-B Bolívar   es    
EC,EC-C EC EC-C Carchi   es    
EC,EC-D* EC EC-D* Orellana   es    
EC,EC-E EC EC-E Esmeraldas   es    
EC,EC-F EC EC-F Cañar   es    
EC,EC-G EC EC-G Guayas   es    
EC,EC-H EC EC-H Chimborazo   es    
EC,EC-I EC EC-I Imbabura   es    
EC,EC-L EC EC-L Loja   es    
EC,EC-M EC EC-M Manabí   es    
EC,EC-N EC EC-N Napo   es    
EC,EC-O EC EC-O El Oro   es    
EC,EC-P EC EC-P Pichincha   es    
EC,EC-R EC EC-R Los Ríos   es    
EC,EC-S EC EC-S Morona Santiago   es    
EC,EC-SD* EC EC-SD* Santo Domingo de los Tsáchilas   es    
EC,EC-SE* EC EC-SE* Santa Elena   es    
EC,EC-T EC EC-T Tungurahua   es    
EC,EC-U EC EC-U Sucumbíos   es    
EC,EC-W EC EC-W Galápagos   es    
EC,EC-X EC EC-X Cotopaxi   es    
EC,EC-Y EC EC-Y Pastaza   es    
EC,EC-Z EC EC-Z Zamora Chinchipe   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
);