subdivisions

Data source: ISO

14 rows where country_code = "GR"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
GR,GR-69 GR GR-69 Ágion Óros   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-A* GR GR-A* Anatolikí Makedonía kai Thráki   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-B* GR GR-B* Kentrikí Makedonía   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-C* GR GR-C* Dytikí Makedonía   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-D* GR GR-D* Ípeiros   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-E* GR GR-E* Thessalía   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-F* GR GR-F* Ionía Nísia   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-G* GR GR-G* Dytikí Elláda   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-H* GR GR-H* Stereá Elláda   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-I* GR GR-I* Attikí   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-J* GR GR-J* Pelopónnisos   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-K* GR GR-K* Vóreio Aigaío   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-L* GR GR-L* Nótio Aigaío   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  
GR,GR-M* GR GR-M* Kríti   el ELOT 743:1982 = ISO 843:1997 = UN V/19 1987  

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