country_languages

Data source: ISO

7 rows where language_code = "nl"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code language_code local_short_name
AW,nl AW nl Aruba
BE,nl BE nl België
BQ,nl BQ nl Bonaire, Sint Eustatius en Saba
CW,nl CW nl Curaçao
NL,nl NL nl Nederland
SR,nl SR nl Suriname
SX,nl SX nl Sint Maarten

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