subdivisions

Data source: ISO

18 rows where country_code = "LA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, local_variant

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
LA,LA-AT LA LA-AT Attapu Attapeu lo LAO CNT 1965  
LA,LA-BK* LA LA-BK* Bokèo   lo LAO CNT 1965  
LA,LA-BL* LA LA-BL* Bolikhamxai Borikhamxay lo LAO CNT 1965  
LA,LA-CH* LA LA-CH* Champasak Champasack lo LAO CNT 1965  
LA,LA-HO* LA LA-HO* Houaphan Huaphanh lo LAO CNT 1965  
LA,LA-KH* LA LA-KH* Khammouan Khammuane lo LAO CNT 1965  
LA,LA-LM* LA LA-LM* Louang Namtha Luangnamtha lo LAO CNT 1965  
LA,LA-LP* LA LA-LP* Louangphabang Luangprabang lo LAO CNT 1965  
LA,LA-OU* LA LA-OU* Oudômxai Oudomxay lo LAO CNT 1965  
LA,LA-PH* LA LA-PH* Phôngsali Phongsaly lo LAO CNT 1965  
LA,LA-SL* LA LA-SL* Salavan Saravane lo LAO CNT 1965  
LA,LA-SV* LA LA-SV* Savannakhét Savannakhet lo LAO CNT 1965  
LA,LA-VI* LA LA-VI* Viangchan Vientiane lo LAO CNT 1965  
LA,LA-VT* LA LA-VT* Viangchan Vientiane lo LAO CNT 1965  
LA,LA-XA* LA LA-XA* Xaignabouli Xayabury lo LAO CNT 1965  
LA,LA-XE* LA LA-XE* Xékong Sekong lo LAO CNT 1965  
LA,LA-XI* LA LA-XI* Xiangkhouang Xiengkhuang lo LAO CNT 1965  
LA,LA-XS* LA LA-XS* Xaisômboun Xaysomboon lo LAO CNT 1965  

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