country_languages

Data source: ISO

11 rows where country_code = "ZA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: local_short_name

Link country_code language_code local_short_name
ZA,- ZA - Afrika-Borwa
ZA,af ZA af Suid-Afrika
ZA,en ZA en South Africa
ZA,nr ZA nr Sewula Afrika
ZA,ss ZA ss Ningizimu Afrika
ZA,st ZA st Afrika-Borwa
ZA,tn ZA tn Afrika-Borwa
ZA,ts ZA ts Afrika-Dzonga
ZA,ve ZA ve Afrika Tshipembe
ZA,xh ZA xh Mzantsi Afrika
ZA,zu ZA zu Ningizimu Afrika

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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