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:40.848709+00:00","dedupe_key":"signal_enriched:news_delta:2714904815778484","evidence_event_ids":["evt_0000ed433614"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBhWFZGR0E3MXR4Wml3RTZSQkhMQTMzbnkxNjhkSGpoOWFEODRUN3BoT3IxY1lLanZ2dHhsMkVoNl9Xek9PWWNZQWFvdDduMkc2bkVad2dUMjhvbVNSQ3gzZE9RQmRYR094c09GMW9hMjRsWkU1RmpIZjRKcw?oc=5","as_of":"2026-04-08T02:29:40.848709+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/CBMie0FVX3lxTFBhWFZGR0E3MXR4Wml3RTZSQkhMQTMzbnkxNjhkSGpoOWFEODRUN3BoT3IxY1lLanZ2dHhsMkVoNl9Xek9PWWNZQWFvdDduMkc2bkVad2dUMjhvbVNSQ3gzZE9RQmRYR094c09GMW9hMjRsWkU1RmpIZjRKcw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_12e390d4256c8355","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-08T03:50:46.668350+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBhWFZGR0E3MXR4Wml3RTZSQkhMQTMzbnkxNjhkSGpoOWFEODRUN3BoT3IxY1lLanZ2dHhsMkVoNl9Xek9PWWNZQWFvdDduMkc2bkVad2dUMjhvbVNSQ3gzZE9RQmRYR094c09GMW9hMjRsWkU1RmpIZjRKcw?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/CBMie0FVX3lxTFBhWFZGR0E3MXR4Wml3RTZSQkhMQTMzbnkxNjhkSGpoOWFEODRUN3BoT3IxY1lLanZ2dHhsMkVoNl9Xek9PWWNZQWFvdDduMkc2bkVad2dUMjhvbVNSQ3gzZE9RQmRYR094c09GMW9hMjRsWkU1RmpIZjRKcw?oc=5","source_event_id":"evt_0000ed433614","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"48a9f0ea71bee628","published_at":"2026-04-08T02:18:00+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"primary decision-maker","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"counterparty to ceasefire","symbol":"","type":"country"},{"asset_class":"","name":"United States","relevance":"party benefiting from ceasefire (per White House claim)","symbol":"","type":"country"},{"asset_class":"","name":"Strait of Hormuz","relevance":"safe passage during ceasefire cited as affecting oil prices","symbol":"","type":"geographic chokepoint"},{"asset_class":"","name":"CNN","relevance":"source of headline update","symbol":"","type":"media outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided appears to be mostly HTML/CSS and does not contain the substantive content; extraction relies on the provided headline and source summary snippets.","Exact start/end dates of the two-week ceasefire are not specified in the provided text.","Details of the ceasefire terms (scope, enforcement, parties involved) are not included in the provided material.","The magnitude/direction of market impact beyond \u2018oil prices plunge below $100\u2019 is not quantified.","Whether safe passage is an explicit condition of the ceasefire or a related agreement is not fully specified."],"key_facts":["Headline states Trump agrees to a two-week ceasefire with Iran (cnn.com live updates).","White House claims the ceasefire is \u2018a victory for the United States\u2019 (as summarized in provided source summary).","Iran\u2019s 10-point proposal is described as demanding an end to attacks and sanctions (as summarized in provided source summary).","Oil prices are reported to have plunged below $100 after Iran agrees to safe passage through the Strait of Hormuz during the ceasefire (as summarized in provided source summary).","Multiple outlets are referenced as covering the ceasefire announcement (Times of Israel, New York Times, CNBC, Business Insider) (as summarized in provided source summary)."],"numeric_claims":[{"label":"ceasefire duration","value":"two-week"},{"label":"oil price level","value":"below $100"}],"primary_claim":"Trump agreed to a two-week ceasefire with Iran.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"CNN reports that Trump has agreed to a two-week ceasefire with Iran. The ceasefire is associated with claims of U.S. success and near-term easing of oil-market risk tied to Strait of Hormuz safe passage.","topics":["ceasefire","Iran","U.S.-Iran tensions","oil prices","Strait of Hormuz","sanctions/attacks (referenced via Iran proposal)"]},"source":"cnn.com","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Live updates: Trump agrees to two-week ceasefire with Iran cnn.com White House claims two-week ceasefire with Iran as \u2018a victory for the United States\u2019 The Times of Israel Iran\u2019s 10-Point Proposal Demands an End to Attacks and Sanctions The New York Times Oil prices plunge below $100 after Iran agrees to safe passage through Strait of Hormuz during ceasefire CNBC Trump Announces Two-Week Ceasefire in Iran Business Insider","title":"Live updates: Trump agrees to two-week ceasefire with Iran - cnn.com","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 4341 in events