country_languages
Data source: ISO
3 rows where language_code = "da"
This data as json, CSV (advanced)
Link | country_code | language_code | local_short_name |
---|---|---|---|
DK,da | DK | da | Danmark |
FO,da | FO | da | Færøerne |
GL,da | GL | da | Grønland |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE country_languages ( country_code text NOT NULL , language_code text NOT NULL , local_short_name text , PRIMARY KEY (country_code , language_code) , FOREIGN KEY (country_code) REFERENCES countries (alpha_2_code) ON DELETE CASCADE , FOREIGN KEY (language_code) REFERENCES languages (alpha_2_code) ON DELETE CASCADE );