COUNTRIES

Country reference data.

Data Freshness

Updated periodically.

Columns

Column	Type	Description
CCA2	TEXT	ISO 3166-1 alpha-2 country code.
CCA3	TEXT	ISO 3166-1 alpha-3 country code.
COUNTRY	TEXT	Country name.
LAT	FLOAT	Country centroid latitude.
LON	FLOAT	Country centroid longitude.

Common Queries

Find countries by code or name:

SELECT
  CCA2,
  CCA3,
  COUNTRY,
  LAT,
  LON
FROM COUNTRIES
WHERE CCA2 = 'JP'
   OR CCA3 = 'JPN'
   OR COUNTRY ILIKE '%Japan%';