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-09T23:49:34.998423+00:00","dedupe_key":"signal_enriched:news_delta:a8cd072386932559","evidence_event_ids":["evt_4e37785baffd"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE5DaVF2QzJJVE9XQnRDY1NyQl9paGlKZFFGYTNjem04S3dtUFlwcEJMSVpMR0c0NzFnQllLVm1KM0EyUEtHRzZKVlRkaV92Rk5IdmE1NGR3R2NSclh4ZkxmWEdLZ2YwbFZNZGJ0UGc5UE4ydzR0cS0wWmNSWQ?oc=5","as_of":"2026-04-09T23:49:34.998423+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/CBMie0FVX3lxTE5DaVF2QzJJVE9XQnRDY1NyQl9paGlKZFFGYTNjem04S3dtUFlwcEJMSVpMR0c0NzFnQllLVm1KM0EyUEtHRzZKVlRkaV92Rk5IdmE1NGR3R2NSclh4ZkxmWEdLZ2YwbFZNZGJ0UGc5UE4ydzR0cS0wWmNSWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_95b48c4de2f5d296","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-10T00:54:57.729358+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE5DaVF2QzJJVE9XQnRDY1NyQl9paGlKZFFGYTNjem04S3dtUFlwcEJMSVpMR0c0NzFnQllLVm1KM0EyUEtHRzZKVlRkaV92Rk5IdmE1NGR3R2NSclh4ZkxmWEdLZ2YwbFZNZGJ0UGc5UE4ydzR0cS0wWmNSWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE5DaVF2QzJJVE9XQnRDY1NyQl9paGlKZFFGYTNjem04S3dtUFlwcEJMSVpMR0c0NzFnQllLVm1KM0EyUEtHRzZKVlRkaV92Rk5IdmE1NGR3R2NSclh4ZkxmWEdLZ2YwbFZNZGJ0UGc5UE4ydzR0cS0wWmNSWQ?oc=5","source_event_id":"evt_4e37785baffd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1a54b8e9ce74990f","published_at":"2026-04-09T18:00:21+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"government","name":"White House","relevance":"medium","symbol":"","type":"government_body"},{"asset_class":"media","name":"CNN","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Washington Post","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"Al Jazeera","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The New York Times","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"WSJ (The Wall Street Journal)","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The provided CNN article text is not actually present (only CSS/HTML), so specific details of the ceasefire terms are not extractable from the supplied content.","The signal does not specify the exact counterpart to Iran (e.g., which state/coalition) in the ceasefire dispute.","No timing/catalyst window (e.g., days/weeks) is included in the provided text beyond \u201cnear-term\u201d implication from ongoing confusion.","No concrete list of the ceasefire terms or which specific demands the U.S. would accept is included in the supplied excerpt."],"key_facts":["CNN headline states the two sides cannot agree on what is in the Iran war ceasefire.","The Washington Post summary indicates White House efforts to support a truce are marked by confusion and contradictions.","The New York Times summary references Iran\u2019s \u201c10-point proposal\u201d and compares it to U.S. demands.","WSJ summary indicates a closer look at Iran\u2019s \u201c10 demands\u201d and which the U.S. might accept."],"numeric_claims":[{"label":"proposal_points","value":"10"}],"primary_claim":"Iran and the other side in the Iran war cannot even agree on what is included in a ceasefire, leading to confusion over the truce terms.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Multiple outlets report confusion and disagreement over the contents and terms of an Iran war ceasefire, including competing proposals and U.S. demands. The lack of alignment between the parties is presented as a near-term risk to sustaining any truce.","topics":["Iran ceasefire","ceasefire terms","U.S. demands","Iran proposal","diplomatic negotiations","truce implementation uncertainty"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"What\u2019s in the Iran war ceasefire? The two sides can\u2019t seem to even agree on that. CNN White House struggles to prop up truce marked by confusion, contradictions The Washington Post This is America Al Jazeera What Is In Iran\u2019s 10-Point Proposal, and How Does It Compare to U.S. Demands? The New York Times A Closer Look at Iran\u2019s 10 Demands\u2014and Which the U.S. Might Accept WSJ","title":"What\u2019s in the Iran war ceasefire? The two sides can\u2019t seem to even agree on that. - 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 11646 in events