subdivisions

Data source: ISO

36 rows where country_code = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: local_variant

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
IN,IN-AN IN IN-AN Andaman and Nicobar Islands   en Indian System of Transliteration  
IN,IN-AP IN IN-AP Andhra Pradesh   en Indian System of Transliteration  
IN,IN-AR IN IN-AR Arunāchal Pradesh   en Indian System of Transliteration  
IN,IN-AS IN IN-AS Assam   en Indian System of Transliteration  
IN,IN-BR IN IN-BR Bihār   en Indian System of Transliteration  
IN,IN-CH IN IN-CH Chandīgarh   en Indian System of Transliteration  
IN,IN-CT* IN IN-CT* Chhattīsgarh   en Indian System of Transliteration  
IN,IN-DH* IN IN-DH* Dādra and Nagar Haveli and Damān and Diu   en Indian System of Transliteration  
IN,IN-DL IN IN-DL Delhi   en Indian System of Transliteration  
IN,IN-GA IN IN-GA Goa   en Indian System of Transliteration  
IN,IN-GJ IN IN-GJ Gujarāt   en Indian System of Transliteration  
IN,IN-HP IN IN-HP Himāchal Pradesh   en Indian System of Transliteration  
IN,IN-HR IN IN-HR Haryāna   en Indian System of Transliteration  
IN,IN-JH* IN IN-JH* Jhārkhand   en Indian System of Transliteration  
IN,IN-JK IN IN-JK Jammu and Kashmīr   en Indian System of Transliteration  
IN,IN-KA IN IN-KA Karnātaka   en Indian System of Transliteration  
IN,IN-KL IN IN-KL Kerala   en Indian System of Transliteration  
IN,IN-LA IN IN-LA Ladākh   en Indian System of Transliteration  
IN,IN-LD IN IN-LD Lakshadweep   en Indian System of Transliteration  
IN,IN-MH IN IN-MH Mahārāshtra   en Indian System of Transliteration  
IN,IN-ML IN IN-ML Meghālaya   en Indian System of Transliteration  
IN,IN-MN IN IN-MN Manipur   en Indian System of Transliteration  
IN,IN-MP IN IN-MP Madhya Pradesh   en Indian System of Transliteration  
IN,IN-MZ IN IN-MZ Mizoram   en Indian System of Transliteration  
IN,IN-NL IN IN-NL Nāgāland   en Indian System of Transliteration  
IN,IN-OR IN IN-OR Odisha   en Indian System of Transliteration  
IN,IN-PB IN IN-PB Punjab   en Indian System of Transliteration  
IN,IN-PY IN IN-PY Puducherry Pondicherry en Indian System of Transliteration  
IN,IN-RJ IN IN-RJ Rājasthān   en Indian System of Transliteration  
IN,IN-SK IN IN-SK Sikkim   en Indian System of Transliteration  
IN,IN-TG* IN IN-TG* Telangāna   en Indian System of Transliteration  
IN,IN-TN IN IN-TN Tamil Nādu   en Indian System of Transliteration  
IN,IN-TR IN IN-TR Tripura   en Indian System of Transliteration  
IN,IN-UP IN IN-UP Uttar Pradesh   en Indian System of Transliteration  
IN,IN-UT* IN IN-UT* Uttarākhand   en Indian System of Transliteration  
IN,IN-WB IN IN-WB West Bengal   en Indian System of Transliteration  

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