subdivisions
Data source: ISO
27 rows where country_code = "EG"
This data as json, CSV (advanced)
Suggested facets: local_variant
Link | country_code | code_31662 | name | local_variant | language_code | romanization_system | parent_subdivision |
---|---|---|---|---|---|---|---|
EG,EG-ALX | EG | EG-ALX | Al Iskandarīyah | Alexandria | ar | BGN/PCGN 1956 | |
EG,EG-ASN | EG | EG-ASN | Aswān | ar | BGN/PCGN 1956 | ||
EG,EG-AST | EG | EG-AST | Asyūţ | ar | BGN/PCGN 1956 | ||
EG,EG-BA* | EG | EG-BA* | Al Baḩr al Aḩmar | Red Sea | ar | BGN/PCGN 1956 | |
EG,EG-BH | EG | EG-BH | Al Buḩayrah | ar | BGN/PCGN 1956 | ||
EG,EG-BNS | EG | EG-BNS | Banī Suwayf | ar | BGN/PCGN 1956 | ||
EG,EG-C | EG | EG-C | Al Qāhirah | Cairo | ar | BGN/PCGN 1956 | |
EG,EG-DK | EG | EG-DK | Ad Daqahlīyah | ar | BGN/PCGN 1956 | ||
EG,EG-DT | EG | EG-DT | Dumyāţ | Damietta | ar | BGN/PCGN 1956 | |
EG,EG-FYM | EG | EG-FYM | Al Fayyūm | ar | BGN/PCGN 1956 | ||
EG,EG-GH | EG | EG-GH | Al Gharbīyah | ar | BGN/PCGN 1956 | ||
EG,EG-GZ | EG | EG-GZ | Al Jīzah | Giza | ar | BGN/PCGN 1956 | |
EG,EG-IS | EG | EG-IS | Al Ismā'īlīyah | ar | BGN/PCGN 1956 | ||
EG,EG-JS* | EG | EG-JS* | Janūb Sīnā' | South Sinai | ar | BGN/PCGN 1956 | |
EG,EG-KB | EG | EG-KB | Al Qalyūbīyah | ar | BGN/PCGN 1956 | ||
EG,EG-KFS | EG | EG-KFS | Kafr ash Shaykh | ar | BGN/PCGN 1956 | ||
EG,EG-KN | EG | EG-KN | Qinā | ar | BGN/PCGN 1956 | ||
EG,EG-LX* | EG | EG-LX* | Al Uqşur | Luxor | ar | BGN/PCGN 1956 | |
EG,EG-MN | EG | EG-MN | Al Minyā | ar | BGN/PCGN 1956 | ||
EG,EG-MNF | EG | EG-MNF | Al Minūfīyah | ar | BGN/PCGN 1956 | ||
EG,EG-MT | EG | EG-MT | Maţrūḩ | ar | BGN/PCGN 1956 | ||
EG,EG-PTS | EG | EG-PTS | Būr Sa‘īd | Port Said | ar | BGN/PCGN 1956 | |
EG,EG-SHG | EG | EG-SHG | Sūhāj | Sohag | ar | BGN/PCGN 1956 | |
EG,EG-SHR | EG | EG-SHR | Ash Sharqīyah | ar | BGN/PCGN 1956 | ||
EG,EG-SIN | EG | EG-SIN | Shamāl Sīnā' | North Sinai | ar | BGN/PCGN 1956 | |
EG,EG-SUZ | EG | EG-SUZ | As Suways | Suez | ar | BGN/PCGN 1956 | |
EG,EG-WAD | EG | EG-WAD | Al Wādī al Jadīd | New Valley | ar | BGN/PCGN 1956 |
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 );