Collection provenance

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

23 rows sorted by collection_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: status, payload_sha256, versions_written, changes_emitted, collection_date (date), started_at (date), finished_at (date)

CREATE TABLE fetch_run (
  fetch_run_id      INTEGER PRIMARY KEY,
  source_id         INTEGER NOT NULL REFERENCES source(source_id),
  collection_date   TEXT NOT NULL,            -- logical day 'YYYY-MM-DD' (SCD2 valid_from anchor)
  started_at        TEXT NOT NULL,
  finished_at       TEXT,
  status            TEXT NOT NULL,            -- 'success'|'unchanged'|'http_error'|'parse_error'|'aborted'
  http_status       INTEGER,
  payload_sha256    TEXT,
  destination_count INTEGER,
  versions_written  INTEGER NOT NULL DEFAULT 0,
  changes_emitted   INTEGER NOT NULL DEFAULT 0,
  error_detail      TEXT,
  tool_version      TEXT NOT NULL,
  UNIQUE (source_id, collection_date)         -- one authoritative run per source per day
);
CREATE INDEX ix_fetch_run_source_date ON fetch_run(source_id, collection_date);