subdivisions

Data source: ISO

26 rows where country_code = "NP"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, local_variant, language_code, romanization_system, parent_subdivision

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
NP,NP-1 NP NP-1 Madhyamanchal   ne conventional names  
NP,NP-2 NP NP-2 Mid Western   en    
NP,NP-3 NP NP-3 Western   en    
NP,NP-4 NP NP-4 Purwanchal   ne conventional names  
NP,NP-5 NP NP-5 Sudur Pashchimanchal   ne conventional names  
NP,NP-BA NP NP-BA Bagmati   ne conventional names NP-1
NP,NP-BH NP NP-BH Bheri   ne conventional names NP-2
NP,NP-DH NP NP-DH Dhawalagiri   ne conventional names NP-3
NP,NP-GA NP NP-GA Gandaki   ne conventional names NP-3
NP,NP-JA NP NP-JA Janakpur   ne conventional names NP-1
NP,NP-KA NP NP-KA Karnali   ne conventional names NP-2
NP,NP-KO NP NP-KO Kosi Koshi ne conventional names NP-4
NP,NP-LU NP NP-LU Lumbini   ne conventional names NP-3
NP,NP-MA NP NP-MA Mahakali   ne conventional names NP-5
NP,NP-ME NP NP-ME Mechi   ne conventional names NP-4
NP,NP-NA NP NP-NA Narayani   ne conventional names NP-1
NP,NP-P1* NP NP-P1* Province 1   en    
NP,NP-P2* NP NP-P2* Province 2   en    
NP,NP-P3* NP NP-P3* Bāgmatī Pradesh 3 ne conventional names  
NP,NP-P4* NP NP-P4* Gandaki Pradesh 4 ne conventional names  
NP,NP-P5* NP NP-P5* Province 5   en    
NP,NP-P6* NP NP-P6* Karnali Pradesh 6 ne conventional names  
NP,NP-P7* NP NP-P7* Sudūr Pashchim Sudūrpashchim; Pradesh 7 ne conventional names  
NP,NP-RA NP NP-RA Rapti   ne conventional names NP-2
NP,NP-SA NP NP-SA Sagarmatha   ne conventional names NP-4
NP,NP-SE NP NP-SE Seti   ne conventional names NP-5

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
);