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-08T00:26:38.290405+00:00","dedupe_key":"signal_enriched:news_delta:b521dc01028a820a","evidence_event_ids":["evt_b0346917a399"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxOQWdMR2RQZEpSSnE3R1BPd1dPVVNvX21tYjhCbFZjcVJRMkozZVFxc3NKUFZid19fMTBZR2Zia3lhbmtLbDlXV21fSERfY3JNYkhEMktlNHZKVXdzaEk4UGlkcDBienpZWjl2OHpwQW9pRnBBaUh2aU5sQlBsVlNkM1FLLVowRXB4WFhWc2g3dmQxYjZzelJzNWhXRlROZjFmN2psUkJWbS1NcHF0?oc=5","as_of":"2026-04-08T00:26:38.290405+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxOQWdMR2RQZEpSSnE3R1BPd1dPVVNvX21tYjhCbFZjcVJRMkozZVFxc3NKUFZid19fMTBZR2Zia3lhbmtLbDlXV21fSERfY3JNYkhEMktlNHZKVXdzaEk4UGlkcDBienpZWjl2OHpwQW9pRnBBaUh2aU5sQlBsVlNkM1FLLVowRXB4WFhWc2g3dmQxYjZzelJzNWhXRlROZjFmN2psUkJWbS1NcHF0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5075ff5f804f7ca6","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:42:44.208490+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxOQWdMR2RQZEpSSnE3R1BPd1dPVVNvX21tYjhCbFZjcVJRMkozZVFxc3NKUFZid19fMTBZR2Zia3lhbmtLbDlXV21fSERfY3JNYkhEMktlNHZKVXdzaEk4UGlkcDBienpZWjl2OHpwQW9pRnBBaUh2aU5sQlBsVlNkM1FLLVowRXB4WFhWc2g3dmQxYjZzelJzNWhXRlROZjFmN2psUkJWbS1NcHF0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxOQWdMR2RQZEpSSnE3R1BPd1dPVVNvX21tYjhCbFZjcVJRMkozZVFxc3NKUFZid19fMTBZR2Zia3lhbmtLbDlXV21fSERfY3JNYkhEMktlNHZKVXdzaEk4UGlkcDBienpZWjl2OHpwQW9pRnBBaUh2aU5sQlBsVlNkM1FLLVowRXB4WFhWc2g3dmQxYjZzelJzNWhXRlROZjFmN2psUkJWbS1NcHF0?oc=5","source_event_id":"evt_b0346917a399","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2414a75c7dc730fb","published_at":"2026-04-07T23:17:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_location"},{"asset_class":"","name":"CBS News","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"AP News","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Reuters","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"CNBC","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Fox News","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["Exact start date/time of the two-week ceasefire is not provided in the supplied text.","Details of what constitutes \u201creopening\u201d the Strait of Hormuz are not specified.","The specific terms of the \u201c10-point peace deal\u201d are not included in the provided excerpt.","Whether the ceasefire is fully agreed by both sides or conditional in practice beyond the stated contingency is not fully detailed here.","No market/sector impacts are explicitly stated in the provided content."],"key_facts":["Trump announced a two-week ceasefire in the Iran war.","The ceasefire is contingent on Iran reopening the Strait of Hormuz.","US and Iran are reported to have agreed to a two-week ceasefire (per AP News live updates).","Reuters reports Iran says talks to begin in connection with the ceasefire.","CNBC and Fox News report the US is suspending Iran strikes for two weeks to negotiate a peace deal (Fox mentions a 10-point peace deal)."],"numeric_claims":[{"label":"ceasefire_duration_weeks","value":"2"},{"label":"peace_deal_points","value":"10"}],"primary_claim":"Trump announced a two-week ceasefire in the Iran war contingent on Iran reopening the Strait of Hormuz.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Trump announced a two-week ceasefire in the Iran war, but it is contingent on Iran reopening the Strait of Hormuz. Multiple outlets report the pause is intended to enable negotiations toward a broader peace arrangement.","topics":["Iran war","ceasefire","Strait of Hormuz","US-Iran negotiations","maritime chokepoint risk"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Live Updates: Trump announces 2-week ceasefire in Iran war, contingent on Iran reopening Strait of Hormuz CBS News Live updates: US, Iran say they have agreed to a two-week ceasefire AP News Trump suspends Iran attack for two weeks, subject to Hormuz Strait opening cnbc.com Iran war live: Trump announces two-week ceasefire as Iran says talks to begin Reuters Trump pauses Iran strikes for two weeks to negotiate 10-point peace deal Fox News","title":"Live Updates: Trump announces 2-week ceasefire in Iran war, contingent on Iran reopening Strait of Hormuz - CBS News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 2476 in events