country_languages

Data source: ISO

10 rows where language_code = "pt"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code language_code local_short_name
AO,pt AO pt Angola
BR,pt BR pt Brasil (o)
CV,pt CV pt Cabo Verde
GQ,pt GQ pt Guiné Equatorial (a)
GW,pt GW pt Guiné-Bissau (a)
MO,pt MO pt Macau
MZ,pt MZ pt Moçambique
PT,pt PT pt Portugal
ST,pt ST pt São Tomé e Príncipe
TL,pt TL pt Timor-Leste

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