country_alias

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

732 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: native_kind

Next page

CREATE TABLE country_alias (
  alias_id      INTEGER PRIMARY KEY,
  country_id    INTEGER NOT NULL REFERENCES country(country_id),
  source_id     INTEGER NOT NULL REFERENCES source(source_id),
  native_kind   TEXT NOT NULL,                -- 'cdc_destination_id'|'cdc_slug'|'cdc_name'|'iso3'
  native_key    TEXT NOT NULL,
  native_label  TEXT,
  first_seen_fetch_run_id INTEGER REFERENCES fetch_run(fetch_run_id),
  last_seen_fetch_run_id  INTEGER REFERENCES fetch_run(fetch_run_id),
  UNIQUE (source_id, native_kind, native_key)
);
CREATE INDEX ix_alias_country ON country_alias(country_id);