subdivisions

Data source: ISO

23 rows where country_code = "TD"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: language_code, romanization_system

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
TD,TD-BA TD TD-BA Batha   fr    
TD,TD-BG* TD TD-BG* Baḩr al Ghazāl   ar BGN/PCGN 1956  
TD,TD-BO* TD TD-BO* Būrkū   ar BGN/PCGN 1956  
TD,TD-CB TD TD-CB Shārī Bāqirmī   ar BGN/PCGN 1956  
TD,TD-EE* TD TD-EE* Inīdī ash Sharqī   ar BGN/PCGN 1956  
TD,TD-EO* TD TD-EO* Inīdī al Gharbī   ar BGN/PCGN 1956  
TD,TD-GR TD TD-GR Qīrā   ar BGN/PCGN 1956  
TD,TD-HL* TD TD-HL* Ḩajjar Lamīs   ar BGN/PCGN 1956  
TD,TD-KA TD TD-KA Kānim   ar BGN/PCGN 1956  
TD,TD-LC TD TD-LC Lac   fr    
TD,TD-LO TD TD-LO Lūghūn al Gharbī   ar BGN/PCGN 1956  
TD,TD-LR TD TD-LR Lūghūn ash Sharqī   ar BGN/PCGN 1956  
TD,TD-MA* TD TD-MA* Māndūl   ar BGN/PCGN 1956  
TD,TD-MC TD TD-MC Shārī al Awsaţ   ar BGN/PCGN 1956  
TD,TD-ME* TD TD-ME* Māyū Kībbī ash Sharqī   ar BGN/PCGN 1956  
TD,TD-MO* TD TD-MO* Māyū Kībbī al Gharbī   ar BGN/PCGN 1956  
TD,TD-ND* TD TD-ND* Ville de Ndjamena   fr    
TD,TD-OD TD TD-OD Waddāy   ar BGN/PCGN 1956  
TD,TD-SA TD TD-SA Salāmāt   ar BGN/PCGN 1956  
TD,TD-SI* TD TD-SI* Sīlā   ar BGN/PCGN 1956  
TD,TD-TA TD TD-TA Tānjīlī   ar BGN/PCGN 1956  
TD,TD-TI* TD TD-TI* Tibesti   fr    
TD,TD-WF* TD TD-WF* Wādī Fīrā’   ar BGN/PCGN 1956  

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