subdivisions

Data source: ISO

25 rows where country_code = "VE"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
VE,VE-A VE VE-A Distrito Capital   es    
VE,VE-B VE VE-B Anzoátegui   es    
VE,VE-C VE VE-C Apure   es    
VE,VE-D VE VE-D Aragua   es    
VE,VE-E VE VE-E Barinas   es    
VE,VE-F VE VE-F Bolívar   es    
VE,VE-G VE VE-G Carabobo   es    
VE,VE-H VE VE-H Cojedes   es    
VE,VE-I VE VE-I Falcón   es    
VE,VE-J VE VE-J Guárico   es    
VE,VE-K VE VE-K Lara   es    
VE,VE-L VE VE-L Mérida   es    
VE,VE-M VE VE-M Miranda   es    
VE,VE-N VE VE-N Monagas   es    
VE,VE-O VE VE-O Nueva Esparta   es    
VE,VE-P VE VE-P Portuguesa   es    
VE,VE-R VE VE-R Sucre   es    
VE,VE-S VE VE-S Táchira   es    
VE,VE-T VE VE-T Trujillo   es    
VE,VE-U VE VE-U Yaracuy   es    
VE,VE-V VE VE-V Zulia   es    
VE,VE-W* VE VE-W* Dependencias Federales   es    
VE,VE-X* VE VE-X* La Guaira   es    
VE,VE-Y VE VE-Y Delta Amacuro   es    
VE,VE-Z VE VE-Z Amazonas   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
);