subdivisions
Data source: ISO
81 rows where country_code = "TR"
This data as json, CSV (advanced)
| Link | country_code | code_31662 | name | local_variant | language_code | romanization_system | parent_subdivision |
|---|---|---|---|---|---|---|---|
| TR,TR-01 | TR | TR-01 | Adana | tr | |||
| TR,TR-02 | TR | TR-02 | Adıyaman | tr | |||
| TR,TR-03 | TR | TR-03 | Afyonkarahisar | tr | |||
| TR,TR-04 | TR | TR-04 | Ağrı | tr | |||
| TR,TR-05 | TR | TR-05 | Amasya | tr | |||
| TR,TR-06 | TR | TR-06 | Ankara | tr | |||
| TR,TR-07 | TR | TR-07 | Antalya | tr | |||
| TR,TR-08 | TR | TR-08 | Artvin | tr | |||
| TR,TR-09 | TR | TR-09 | Aydın | tr | |||
| TR,TR-10 | TR | TR-10 | Balıkesir | tr | |||
| TR,TR-11 | TR | TR-11 | Bilecik | tr | |||
| TR,TR-12 | TR | TR-12 | Bingöl | tr | |||
| TR,TR-13 | TR | TR-13 | Bitlis | tr | |||
| TR,TR-14 | TR | TR-14 | Bolu | tr | |||
| TR,TR-15 | TR | TR-15 | Burdur | tr | |||
| TR,TR-16 | TR | TR-16 | Bursa | tr | |||
| TR,TR-17 | TR | TR-17 | Çanakkale | tr | |||
| TR,TR-18 | TR | TR-18 | Çankırı | tr | |||
| TR,TR-19 | TR | TR-19 | Çorum | tr | |||
| TR,TR-20 | TR | TR-20 | Denizli | tr | |||
| TR,TR-21 | TR | TR-21 | Diyarbakır | tr | |||
| TR,TR-22 | TR | TR-22 | Edirne | tr | |||
| TR,TR-23 | TR | TR-23 | Elazığ | tr | |||
| TR,TR-24 | TR | TR-24 | Erzincan | tr | |||
| TR,TR-25 | TR | TR-25 | Erzurum | tr | |||
| TR,TR-26 | TR | TR-26 | Eskişehir | tr | |||
| TR,TR-27 | TR | TR-27 | Gaziantep | tr | |||
| TR,TR-28 | TR | TR-28 | Giresun | tr | |||
| TR,TR-29 | TR | TR-29 | Gümüşhane | tr | |||
| TR,TR-30 | TR | TR-30 | Hakkâri | tr | |||
| TR,TR-31 | TR | TR-31 | Hatay | tr | |||
| TR,TR-32 | TR | TR-32 | Isparta | tr | |||
| TR,TR-33 | TR | TR-33 | Mersin | tr | |||
| TR,TR-34 | TR | TR-34 | İstanbul | tr | |||
| TR,TR-35 | TR | TR-35 | İzmir | tr | |||
| TR,TR-36 | TR | TR-36 | Kars | tr | |||
| TR,TR-37 | TR | TR-37 | Kastamonu | tr | |||
| TR,TR-38 | TR | TR-38 | Kayseri | tr | |||
| TR,TR-39 | TR | TR-39 | Kırklareli | tr | |||
| TR,TR-40 | TR | TR-40 | Kırşehir | tr | |||
| TR,TR-41 | TR | TR-41 | Kocaeli | tr | |||
| TR,TR-42 | TR | TR-42 | Konya | tr | |||
| TR,TR-43 | TR | TR-43 | Kütahya | tr | |||
| TR,TR-44 | TR | TR-44 | Malatya | tr | |||
| TR,TR-45 | TR | TR-45 | Manisa | tr | |||
| TR,TR-46 | TR | TR-46 | Kahramanmaraş | tr | |||
| TR,TR-47 | TR | TR-47 | Mardin | tr | |||
| TR,TR-48 | TR | TR-48 | Muğla | tr | |||
| TR,TR-49 | TR | TR-49 | Muş | tr | |||
| TR,TR-50 | TR | TR-50 | Nevşehir | tr | |||
| TR,TR-51 | TR | TR-51 | Niğde | tr | |||
| TR,TR-52 | TR | TR-52 | Ordu | tr | |||
| TR,TR-53 | TR | TR-53 | Rize | tr | |||
| TR,TR-54 | TR | TR-54 | Sakarya | tr | |||
| TR,TR-55 | TR | TR-55 | Samsun | tr | |||
| TR,TR-56 | TR | TR-56 | Siirt | tr | |||
| TR,TR-57 | TR | TR-57 | Sinop | tr | |||
| TR,TR-58 | TR | TR-58 | Sivas | tr | |||
| TR,TR-59 | TR | TR-59 | Tekirdağ | tr | |||
| TR,TR-60 | TR | TR-60 | Tokat | tr | |||
| TR,TR-61 | TR | TR-61 | Trabzon | tr | |||
| TR,TR-62 | TR | TR-62 | Tunceli | tr | |||
| TR,TR-63 | TR | TR-63 | Şanlıurfa | tr | |||
| TR,TR-64 | TR | TR-64 | Uşak | tr | |||
| TR,TR-65 | TR | TR-65 | Van | tr | |||
| TR,TR-66 | TR | TR-66 | Yozgat | tr | |||
| TR,TR-67 | TR | TR-67 | Zonguldak | tr | |||
| TR,TR-68 | TR | TR-68 | Aksaray | tr | |||
| TR,TR-69 | TR | TR-69 | Bayburt | tr | |||
| TR,TR-70 | TR | TR-70 | Karaman | tr | |||
| TR,TR-71 | TR | TR-71 | Kırıkkale | tr | |||
| TR,TR-72 | TR | TR-72 | Batman | tr | |||
| TR,TR-73 | TR | TR-73 | Şırnak | tr | |||
| TR,TR-74 | TR | TR-74 | Bartın | tr | |||
| TR,TR-75 | TR | TR-75 | Ardahan | tr | |||
| TR,TR-76 | TR | TR-76 | Iğdır | tr | |||
| TR,TR-77 | TR | TR-77 | Yalova | tr | |||
| TR,TR-78 | TR | TR-78 | Karabük | tr | |||
| TR,TR-79 | TR | TR-79 | Kilis | tr | |||
| TR,TR-80* | TR | TR-80* | Osmaniye | tr | |||
| TR,TR-81* | TR | TR-81* | Düzce | tr |
Advanced export
JSON shape: default, array, newline-delimited, object
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
);