country

Data license: Public Domain (CDC) · Data source: CDC Travelers' Health (Yellow Fever & Malaria, by country)

244 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date)

Next page

CREATE TABLE country (
  country_id          INTEGER PRIMARY KEY,
  iso3                TEXT,                    -- ISO-3166 alpha-3, nullable until mapped
  iso2                TEXT,                    -- ISO-3166 alpha-2 (GeoNames join key)
  display_name        TEXT NOT NULL,
  is_subnational_only INTEGER NOT NULL DEFAULT 0,
  created_at          TEXT NOT NULL
);
CREATE INDEX ix_country_iso3 ON country(iso3);
CREATE INDEX ix_country_iso2 ON country(iso2);