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/CBMipgFBVV95cUxNU0t1UFdqQjVIN0ROQlBXZHJiMDM2bTFNbzAzNzUwcTlQcm5fb0ZsT21iekJMd3ZDQy1rLWszRWl6X0o1V2p3NlVkQUlyMnZ1cUJ5dXpxQzh3SDAxTU5aV1VOSE83ellmMjVWQjZoZGppZ1V5NDJRN3c1MER3QzhqdFgtUEpwZVJReFZvUy0yTFFDUDdUdk4yUnlnSkpyaXVrX0sxU0pn0gGrAUFVX3lxTFBSNFdndl9ySDRFQlVBLVNXSVpOVTExUnl3MlRNQUNXbXoxWWNLam10NVhOTTBBSEE4QlNSSDBxVVJCUTI0Wmp5am5ZWkZfQ0tYdUd6OUpTODVfanBfeWNRVHEtZnV3YkE3TmxCdDN1QmRpZXJPcEdsQWRnMkNSX0tVdlU3TDVYVWJ3UnhlaWpXRW40MmNQcWwzZEN6TjlKZ3NFWUJ3Ni0zLUo5Zw?oc=5","as_of":"2026-04-09T09:02:14.685677+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/CBMipgFBVV95cUxNU0t1UFdqQjVIN0ROQlBXZHJiMDM2bTFNbzAzNzUwcTlQcm5fb0ZsT21iekJMd3ZDQy1rLWszRWl6X0o1V2p3NlVkQUlyMnZ1cUJ5dXpxQzh3SDAxTU5aV1VOSE83ellmMjVWQjZoZGppZ1V5NDJRN3c1MER3QzhqdFgtUEpwZVJReFZvUy0yTFFDUDdUdk4yUnlnSkpyaXVrX0sxU0pn0gGrAUFVX3lxTFBSNFdndl9ySDRFQlVBLVNXSVpOVTExUnl3MlRNQUNXbXoxWWNLam10NVhOTTBBSEE4QlNSSDBxVVJCUTI0Wmp5am5ZWkZfQ0tYdUd6OUpTODVfanBfeWNRVHEtZnV3YkE3TmxCdDN1QmRpZXJPcEdsQWRnMkNSX0tVdlU3TDVYVWJ3UnhlaWpXRW40MmNQcWwzZEN6TjlKZ3NFWUJ3Ni0zLUo5Zw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b3cd7e407aa47ba5","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-09T22:57:10.957607+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxNU0t1UFdqQjVIN0ROQlBXZHJiMDM2bTFNbzAzNzUwcTlQcm5fb0ZsT21iekJMd3ZDQy1rLWszRWl6X0o1V2p3NlVkQUlyMnZ1cUJ5dXpxQzh3SDAxTU5aV1VOSE83ellmMjVWQjZoZGppZ1V5NDJRN3c1MER3QzhqdFgtUEpwZVJReFZvUy0yTFFDUDdUdk4yUnlnSkpyaXVrX0sxU0pn0gGrAUFVX3lxTFBSNFdndl9ySDRFQlVBLVNXSVpOVTExUnl3MlRNQUNXbXoxWWNLam10NVhOTTBBSEE4QlNSSDBxVVJCUTI0Wmp5am5ZWkZfQ0tYdUd6OUpTODVfanBfeWNRVHEtZnV3YkE3TmxCdDN1QmRpZXJPcEdsQWRnMkNSX0tVdlU3TDVYVWJ3UnhlaWpXRW40MmNQcWwzZEN6TjlKZ3NFWUJ3Ni0zLUo5Zw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxNU0t1UFdqQjVIN0ROQlBXZHJiMDM2bTFNbzAzNzUwcTlQcm5fb0ZsT21iekJMd3ZDQy1rLWszRWl6X0o1V2p3NlVkQUlyMnZ1cUJ5dXpxQzh3SDAxTU5aV1VOSE83ellmMjVWQjZoZGppZ1V5NDJRN3c1MER3QzhqdFgtUEpwZVJReFZvUy0yTFFDUDdUdk4yUnlnSkpyaXVrX0sxU0pn0gGrAUFVX3lxTFBSNFdndl9ySDRFQlVBLVNXSVpOVTExUnl3MlRNQUNXbXoxWWNLam10NVhOTTBBSEE4QlNSSDBxVVJCUTI0Wmp5am5ZWkZfQ0tYdUd6OUpTODVfanBfeWNRVHEtZnV3YkE3TmxCdDN1QmRpZXJPcEdsQWRnMkNSX0tVdlU3TDVYVWJ3UnhlaWpXRW40MmNQcWwzZEN6TjlKZ3NFWUJ3Ni0zLUo5Zw?oc=5","source_event_id":"evt_80da5fe68363","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9fc85b659d07c6c2","published_at":"2026-04-09T07:27:42+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United Kingdom (Britain)","relevance":"high","symbol":"","type":"country"},{"asset_class":"geopolitical_infrastructure","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_chokepoint"},{"asset_class":"sovereign","name":"Lebanon","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"politician","name":"Yvette Cooper","relevance":"medium","symbol":"","type":"person"},{"asset_class":"politician","name":"UK Foreign Minister (unnamed in provided text)","relevance":"medium","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Israel","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual CNBC article body; extraction relies on the provided headline and source summary snippets.","The specific mechanism/timing for when Britain will \u201ccall for\u201d toll-free access (e.g., in which forum or when) is not stated in the provided text.","Whether the \u201cLebanon must be part of an Iran ceasefire\u201d refers to a formal ceasefire agreement, a negotiation condition, or a broader diplomatic package is not specified.","No details are provided on what \u201ctoll-free\u201d entails (e.g., enforcement, verification, duration).","The identity of the UK foreign minister is not included in the provided text (only that a UK foreign minister made the \u201cdeeply damaging\u201d remark)."],"key_facts":["CNBC reports Britain will call for the Strait of Hormuz to be toll-free.","CNBC reports a UK position that Lebanon must be part of an Iran ceasefire.","CNBC/Reuters-related summary text indicates UK officials argue Iran cannot \u201chijack\u201d the Strait of Hormuz by imposing shipping tolls.","Reuters-related summary text indicates the UK foreign minister says Israel\u2019s actions in Lebanon are \u201cdeeply damaging.\u201d"],"numeric_claims":[],"primary_claim":"Britain will call for toll-free access through the Strait of Hormuz and says Lebanon must be part of an Iran ceasefire, per CNBC citing UK officials.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The UK plans to push for a toll-free reopening of the Strait of Hormuz and says Lebanon must be included in any Iran ceasefire framework. The proposal is tied to UK concerns about Iran\u2019s ability to impose shipping tolls and the broader Middle East conflict involving Lebanon and Israel.","topics":["Middle East ceasefire","Strait of Hormuz shipping tolls","maritime security","UK foreign policy","Israel-Lebanon conflict","Iran-Israel tensions"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"Britain to call for toll-free Strait of Hormuz, says Lebanon must be part of Iran ceasefire CNBC Israel's pounding of Lebanon is 'deeply damaging', UK foreign minister says Reuters Iran cannot \u2018hijack\u2019 strait of Hormuz with shipping tolls, says Yvette Cooper \u2013 UK politics live The Guardian Cooper urges full and toll-free reopening of Strait of Hormuz BBC Live Updates: Latest from Israel, Iran, and the Middle East The Jerusalem Post","title":"Britain to call for toll-free Strait of Hormuz, says Lebanon must be part of Iran ceasefire - CNBC","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

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_9262d5b16486 in signals