SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T02:29:41.414143+00:00","signal_type":"news_headline_delta","source":"news_rss","url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPdEpfSVFja183VjVHOHMwNm5kcWdRdTNTNk01ZDl2ZDRialptYXVIeU15QU9aOXFHM1h1MXQ5RlROOW1CdDM0Q2dfVDdteVd4LVdSNkJpLXgxY0VlRk00dnU5amxZRDRnRWtKQTJGdzhEWEp0M3FEZlZPY183TFpGSG1vV0N0Q1dmaVE?oc=5","value":{"fp":"ef77cc1112dd93d9","published_at":"2026-04-07T22:07:00+00:00","source":"politico.com","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump with no guard rails: \u2018Civilization will die\u2019 post shows his growing power over social media politico.com Revolution in the White House \u2013 Are social media replacing diplomacy? MILMAG","title":"Trump with no guard rails: \u2018Civilization will die\u2019 post shows his growing power over social media - politico.com","url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPdEpfSVFja183VjVHOHMwNm5kcWdRdTNTNk01ZDl2ZDRialptYXVIeU15QU9aOXFHM1h1MXQ5RlROOW1CdDM0Q2dfVDdteVd4LVdSNkJpLXgxY0VlRk00dnU5amxZRDRnRWtKQTJGdzhEWEp0M3FEZlZPY183TFpGSG1vV0N0Q1dmaVE?oc=5"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 3750 in events