subdivisions
Data source: ISO
16 rows where language_code = "el"
This data as json, CSV (advanced)
Suggested facets: country_code
Link | country_code | code_31662 | name | local_variant | language_code | romanization_system | parent_subdivision |
---|---|---|---|---|---|---|---|
CY,CY-05 | CY | CY-05 | Pafos | el | ELOT 743:1982 = ISO 843:1997 = UN V/19 1987 | ||
CY,CY-06 | CY | CY-06 | Keryneia | el | ELOT 743:1982 = ISO 843:1997 = UN V/19 1987 | ||
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
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 );