subdivisions

Data source: ISO

18 rows where country_code = "HN"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
HN,HN-AT* HN HN-AT* Atlántida   es    
HN,HN-CH* HN HN-CH* Choluteca   es    
HN,HN-CL* HN HN-CL* Colón   es    
HN,HN-CM* HN HN-CM* Comayagua   es    
HN,HN-CP* HN HN-CP* Copán   es    
HN,HN-CR* HN HN-CR* Cortés   es    
HN,HN-EP* HN HN-EP* El Paraíso   es    
HN,HN-FM* HN HN-FM* Francisco Morazán   es    
HN,HN-GD* HN HN-GD* Gracias a Dios   es    
HN,HN-IB* HN HN-IB* Islas de la Bahía   es    
HN,HN-IN* HN HN-IN* Intibucá   es    
HN,HN-LE* HN HN-LE* Lempira   es    
HN,HN-LP* HN HN-LP* La Paz   es    
HN,HN-OC* HN HN-OC* Ocotepeque   es    
HN,HN-OL* HN HN-OL* Olancho   es    
HN,HN-SB* HN HN-SB* Santa Bárbara   es    
HN,HN-VA* HN HN-VA* Valle   es    
HN,HN-YO* HN HN-YO* Yoro   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
);