country_languages

Data source: ISO

21 rows where language_code = "es"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code language_code local_short_name
AR,es AR es Argentina (la)
BO,es BO es Bolivia, Estado Plurinacional de
CL,es CL es Chile
CO,es CO es Colombia
CR,es CR es Costa Rica
CU,es CU es Cuba
DO,es DO es República Dominicana (la)
EC,es EC es Ecuador (el)
ES,es ES es España
GQ,es GQ es Guinea Ecuatorial
GT,es GT es Guatemala
HN,es HN es Honduras
MX,es MX es México
NI,es NI es Nicaragua
PA,es PA es Panamá
PE,es PE es Perú (el)
PR,es PR es Puerto Rico
PY,es PY es Paraguay (el)
SV,es SV es El Salvador
UY,es UY es Uruguay (el)
VE,es VE es Venezuela, República Bolivariana de

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