subdivisions

Data source: ISO

31 rows where country_code = "IR"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
IR,IR-00 IR IR-00 Markazī   fa BGN/PCGN 1958  
IR,IR-01 IR IR-01 Gīlān   fa BGN/PCGN 1958  
IR,IR-02 IR IR-02 Māzandarān   fa BGN/PCGN 1958  
IR,IR-03 IR IR-03 Āz̄ārbāyjān-e Shārqī   fa BGN/PCGN 1958  
IR,IR-04 IR IR-04 Āz̄ārbāyjān-e Ghārbī   fa BGN/PCGN 1958  
IR,IR-05 IR IR-05 Kermānshāh   fa BGN/PCGN 1958  
IR,IR-06 IR IR-06 Khūzestān   fa BGN/PCGN 1958  
IR,IR-07 IR IR-07 Fārs   fa BGN/PCGN 1958  
IR,IR-08 IR IR-08 Kermān   fa BGN/PCGN 1958  
IR,IR-09 IR IR-09 Khorāsān-e Raẕavī   fa BGN/PCGN 1958  
IR,IR-10 IR IR-10 Eşfahān   fa BGN/PCGN 1958  
IR,IR-11 IR IR-11 Sīstān va Balūchestān   fa BGN/PCGN 1958  
IR,IR-12 IR IR-12 Kordestān   fa BGN/PCGN 1958  
IR,IR-13 IR IR-13 Hamadān   fa BGN/PCGN 1958  
IR,IR-14 IR IR-14 Chahār Maḩāl va Bakhtīārī   fa BGN/PCGN 1958  
IR,IR-15 IR IR-15 Lorestān   fa BGN/PCGN 1958  
IR,IR-16 IR IR-16 Īlām   fa BGN/PCGN 1958  
IR,IR-17 IR IR-17 Kohgīlūyeh va Bowyer Aḩmad   fa BGN/PCGN 1958  
IR,IR-18 IR IR-18 Būshehr   fa BGN/PCGN 1958  
IR,IR-19 IR IR-19 Zanjān   fa BGN/PCGN 1958  
IR,IR-20 IR IR-20 Semnān   fa BGN/PCGN 1958  
IR,IR-21 IR IR-21 Yazd   fa BGN/PCGN 1958  
IR,IR-22 IR IR-22 Hormozgān   fa BGN/PCGN 1958  
IR,IR-23 IR IR-23 Tehrān   fa BGN/PCGN 1958  
IR,IR-24 IR IR-24 Ardabīl   fa BGN/PCGN 1958  
IR,IR-25 IR IR-25 Qom   fa BGN/PCGN 1958  
IR,IR-26 IR IR-26 Qazvīn   fa BGN/PCGN 1958  
IR,IR-27 IR IR-27 Golestān   fa BGN/PCGN 1958  
IR,IR-28 IR IR-28 Khorāsān-e Shomālī   fa BGN/PCGN 1958  
IR,IR-29 IR IR-29 Khorāsān-e Jonūbī   fa BGN/PCGN 1958  
IR,IR-30 IR IR-30 Alborz   fa BGN/PCGN 1958  

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