Data source: ISO

27 rows where country_code = "EG"

View and edit SQL

Suggested facets: local_variant

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