Change feed

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

245 rows sorted by collection_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: collection_date, fetch_run_id, entity, created_at, collection_date (date), created_at (date), changed_fields_json (array)

Next page

CREATE TABLE change_event (
  change_event_id     INTEGER PRIMARY KEY,
  collection_date     TEXT NOT NULL,
  fetch_run_id        INTEGER NOT NULL REFERENCES fetch_run(fetch_run_id),
  entity              TEXT NOT NULL,          -- 'malaria' | 'yellowfever' | 'country'
  country_id          INTEGER REFERENCES country(country_id),
  country_name        TEXT,                   -- denormalized for a self-contained feed
  change_type         TEXT NOT NULL,          -- country_added|country_removed|became_endemic
                                              -- |became_non_endemic|field_changed
  changed_fields_json TEXT,
  old_value           TEXT,
  new_value           TEXT,
  created_at          TEXT NOT NULL
);
CREATE INDEX ix_change_date    ON change_event(collection_date);
CREATE INDEX ix_change_country ON change_event(country_id);