Data source: ISO

2 rows where country_code = "BN"

View and edit SQL

Link country_code language_code local_short_name
BN en Brunei Darussalam
BN ms Negara Brunei Darussalam

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