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-06T08:43:10.544285+00:00","dedupe_key":"signal_enriched:news_delta:22fbb3daa9eaebea","evidence_event_ids":["evt_f38486cf11c9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxQbWM4VWRzdUFZSUhxbEJ6dy1DRkVuWkpiOXNuV2E0bjc0T0tybnQ4dE5LaEtXR2R5b19SNWtvWklOaTJ5Sm10SGpiR01VaEs4RTRmNy1MakRpdUVBWHYwczgtNUdUVVo1YmFiZUJxTHZYOUNNMXg2RDZZX19XT0trZm96WjVRTWF6dzRqblRXWGR5SzQ?oc=5","as_of":"2026-04-06T08:43:10.544285+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxQbWM4VWRzdUFZSUhxbEJ6dy1DRkVuWkpiOXNuV2E0bjc0T0tybnQ4dE5LaEtXR2R5b19SNWtvWklOaTJ5Sm10SGpiR01VaEs4RTRmNy1MakRpdUVBWHYwczgtNUdUVVo1YmFiZUJxTHZYOUNNMXg2RDZZX19XT0trZm96WjVRTWF6dzRqblRXWGR5SzQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3a7964fc73681bef","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T08:43:56.930693+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxQbWM4VWRzdUFZSUhxbEJ6dy1DRkVuWkpiOXNuV2E0bjc0T0tybnQ4dE5LaEtXR2R5b19SNWtvWklOaTJ5Sm10SGpiR01VaEs4RTRmNy1MakRpdUVBWHYwczgtNUdUVVo1YmFiZUJxTHZYOUNNMXg2RDZZX19XT0trZm96WjVRTWF6dzRqblRXWGR5SzQ?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/CBMikwFBVV95cUxQbWM4VWRzdUFZSUhxbEJ6dy1DRkVuWkpiOXNuV2E0bjc0T0tybnQ4dE5LaEtXR2R5b19SNWtvWklOaTJ5Sm10SGpiR01VaEs4RTRmNy1MakRpdUVBWHYwczgtNUdUVVo1YmFiZUJxTHZYOUNNMXg2RDZZX19XT0trZm96WjVRTWF6dzRqblRXWGR5SzQ?oc=5","source_event_id":"evt_f38486cf11c9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b4c23856daed9758","published_at":"2026-04-06T01:46:00+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"political","name":"Iran","relevance":"high","symbol":"N/A","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Specific details of the new deadline are not provided.","The exact implications for markets and geopolitical relations remain unclear."],"key_facts":["The conflict in Iran has now lasted six weeks.","Trump's new deadline could influence market stability."],"numeric_claims":[],"primary_claim":"Trump threatens Iran with a new deadline as the war enters its sixth week.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Trump has issued a new deadline regarding Iran amidst ongoing conflict, which could impact market stability and geopolitical relations.","topics":["Iran","Donald Trump","geopolitical tensions","market impact"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Trump threatens Iran with a new deadline: What we know about the war, now in its 6th week CNN Trump can\u2019t make his mind up about the Strait of Hormuz. It\u2019s more important than he lets on CNN Stock Futures Waver as Trump Threatens Iran Power Plants Barron's Trump\u2019s Lesson From Risky Rescue: Threaten to Go Harder at Iran The New York Times Iran War: New Trump Deadline Looms as Ceasefire Push Keeps Markets on Edge Bloomberg.com","title":"Trump threatens Iran with a new deadline: What we know about the war, now in its 6th week - CNN","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/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 28831 in events