subdivisions

Data source: ISO

14 rows where country_code = "SV"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
SV,SV-AH* SV SV-AH* Ahuachapán   es    
SV,SV-CA* SV SV-CA* Cabañas   es    
SV,SV-CH* SV SV-CH* Chalatenango   es    
SV,SV-CU* SV SV-CU* Cuscatlán   es    
SV,SV-LI* SV SV-LI* La Libertad   es    
SV,SV-MO* SV SV-MO* Morazán   es    
SV,SV-PA* SV SV-PA* La Paz   es    
SV,SV-SA* SV SV-SA* Santa Ana   es    
SV,SV-SM* SV SV-SM* San Miguel   es    
SV,SV-SO* SV SV-SO* Sonsonate   es    
SV,SV-SS* SV SV-SS* San Salvador   es    
SV,SV-SV* SV SV-SV* San Vicente   es    
SV,SV-UN* SV SV-UN* La Unión   es    
SV,SV-US* SV SV-US* Usulután   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
);