country_languages
Data source: ISO
3 rows where country_code = "SC"
This data as json, CSV (advanced)
| Link | country_code | language_code | local_short_name |
|---|---|---|---|
| SC,- | SC | - | Sesel |
| SC,en | SC | en | Seychelles |
| SC,fr | SC | fr | Seychelles (les) |
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
);