yellowfever_record

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: recommendations_html, valid_from (date), created_at (date)

Next page

CREATE TABLE yellowfever_record (
  record_id      INTEGER PRIMARY KEY,
  country_id     INTEGER NOT NULL REFERENCES country(country_id),
  valid_from     TEXT NOT NULL,
  valid_to       TEXT,
  is_current     INTEGER NOT NULL DEFAULT 1,
  source_id      INTEGER NOT NULL REFERENCES source(source_id),
  fetch_run_id   INTEGER NOT NULL REFERENCES fetch_run(fetch_run_id),
  payload_sha256 TEXT NOT NULL REFERENCES raw_payload(payload_sha256),
  content_hash   TEXT NOT NULL,
  has_requirements    INTEGER,
  requirements_html   TEXT,
  has_recommendations INTEGER,
  recommendations_html TEXT,
  created_at     TEXT NOT NULL
);
CREATE INDEX ix_yf_asof ON yellowfever_record(country_id, valid_from, valid_to);
CREATE UNIQUE INDEX uq_yf_one_current ON yellowfever_record(country_id) WHERE is_current = 1;