SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_629c3d2dfe5f in signals