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-08T01:12:25.625416+00:00","dedupe_key":"signal_enriched:news_delta:6205d7ce22125955","evidence_event_ids":["evt_453875791a11"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNTGZQMUhBc01DTEhTLW5nWkdQM0pOcFJ2Q0NTX3B5SmV4VDk1MWZOTHFIVF9VYlUtUEVKbEZZX0pLVHl3YkpQYUNBel9ranpLVGpZLTRvRzJYMWhxaWMxaFpMZF9GeEFLQ1ZTWUl4OWEwYUxEWTNydWFINzREUl9sYjNiLWU?oc=5","as_of":"2026-04-08T01:12:25.625416+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNTGZQMUhBc01DTEhTLW5nWkdQM0pOcFJ2Q0NTX3B5SmV4VDk1MWZOTHFIVF9VYlUtUEVKbEZZX0pLVHl3YkpQYUNBel9ranpLVGpZLTRvRzJYMWhxaWMxaFpMZF9GeEFLQ1ZTWUl4OWEwYUxEWTNydWFINzREUl9sYjNiLWU?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_28b3322107385faa","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:14:34.931562+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNTGZQMUhBc01DTEhTLW5nWkdQM0pOcFJ2Q0NTX3B5SmV4VDk1MWZOTHFIVF9VYlUtUEVKbEZZX0pLVHl3YkpQYUNBel9ranpLVGpZLTRvRzJYMWhxaWMxaFpMZF9GeEFLQ1ZTWUl4OWEwYUxEWTNydWFINzREUl9sYjNiLWU?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"edition.cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNTGZQMUhBc01DTEhTLW5nWkdQM0pOcFJ2Q0NTX3B5SmV4VDk1MWZOTHFIVF9VYlUtUEVKbEZZX0pLVHl3YkpQYUNBel9ranpLVGpZLTRvRzJYMWhxaWMxaFpMZF9GeEFLQ1ZTWUl4OWEwYUxEWTNydWFINzREUl9sYjNiLWU?oc=5","source_event_id":"evt_453875791a11","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"86f6a81d26ee675c","published_at":"2026-04-07T23:55:32+00:00","publisher_domain":"edition.cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity/FX (context)","name":"Donald Trump","relevance":"trigger for the market move","symbol":"","type":"person"},{"asset_class":"commodity","name":"Oil prices","relevance":"moved lower after the announcement","symbol":"WTI/Brent (not specified)","type":"commodity"},{"asset_class":"equity","name":"Stocks","relevance":"rallied after the announcement","symbol":"(not specified)","type":"asset class"},{"asset_class":"media","name":"CNN","relevance":"source of the headline claim","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["No specific ceasefire details (which conflict/region, terms, timing) are provided in the provided text.","No specific stock index(s) or tickers are named.","No specific oil benchmark (WTI vs Brent) or magnitude of the move is provided.","No timestamp for when the market reaction occurred is provided beyond the implied immediate reaction in the headline."],"key_facts":["CNN headline states oil prices dropped after Trump\u2019s ceasefire announcement.","CNN headline states stocks rallied after Trump\u2019s ceasefire announcement."],"numeric_claims":[],"primary_claim":"Oil prices dropped and stocks rallied after Trump\u2019s ceasefire announcement (CNN).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"CNN reports that oil prices fell and stocks rose following Trump\u2019s ceasefire announcement.","topics":["ceasefire announcement","oil prices","equity market rally","market reaction"]},"source":"CNN","source_domain":"edition.cnn.com","source_url":"https://edition.cnn.com","summary":"Oil prices drop and stocks rally after Trump\u2019s ceasefire announcement CNN","title":"Oil prices drop and stocks rally after Trump\u2019s ceasefire announcement - CNN","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}}

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 3088 in events