raw_payload

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

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_seen_at (date)

CREATE TABLE raw_payload (
  payload_sha256 TEXT PRIMARY KEY,            -- content address; identical days dedupe
  source_id      INTEGER NOT NULL REFERENCES source(source_id),
  first_seen_at  TEXT NOT NULL,
  byte_size      INTEGER NOT NULL,
  storage        TEXT NOT NULL DEFAULT 'file', -- 'file' | 'blob'
  file_path      TEXT,
  compression    TEXT NOT NULL DEFAULT 'zstd',
  body           BLOB
);