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/CBMiWkFVX3lxTE16TnVSZTZ5OTZOMUFJOHItWVhkelJwYkJ2cmhRTVJybm4wVGs2NUxPSlFCa19idURQYzBYZXVtQ1VYdTdhLVp6S3BYbHIwN0dJNFB2eHlzNFRoZw?oc=5","as_of":"2026-04-18T01:25:09.870041+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE16TnVSZTZ5OTZOMUFJOHItWVhkelJwYkJ2cmhRTVJybm4wVGs2NUxPSlFCa19idURQYzBYZXVtQ1VYdTdhLVp6S3BYbHIwN0dJNFB2eHlzNFRoZw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_910b0899d5d79895","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T01:25:23.172611+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE16TnVSZTZ5OTZOMUFJOHItWVhkelJwYkJ2cmhRTVJybm4wVGs2NUxPSlFCa19idURQYzBYZXVtQ1VYdTdhLVp6S3BYbHIwN0dJNFB2eHlzNFRoZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE16TnVSZTZ5OTZOMUFJOHItWVhkelJwYkJ2cmhRTVJybm4wVGs2NUxPSlFCa19idURQYzBYZXVtQ1VYdTdhLVp6S3BYbHIwN0dJNFB2eHlzNFRoZw?oc=5","source_event_id":"evt_404cf91490b9","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"dc68eafbb6c39f37","published_at":"2026-04-17T21:05:55+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: UK and France to lead defensive mission in Strait of Hormuz - BBC","Source summary: UK and France to lead defensive mission in Strait of Hormuz BBC Over a dozen countries offer to play role in Hormuz mission, Starmer says Reuters European Leaders Offer Military Help to Secure Strait of Hormuz Bloomberg.com Europe tests \u2018third way\u2019 on Hormuz without the US, Israel and Iran. Will it work? South China Morning Post Macron and Starmer welcome news of Strait of Hormuz opening but say it must be permanent "],"numeric_claims":[],"primary_claim":"UK and France to lead defensive mission in Strait of Hormuz - BBC","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"UK and France to lead defensive mission in Strait of Hormuz BBC Over a dozen countries offer to play role in Hormuz mission, Starmer says Reuters European Leaders Offer Military Help to Secure Strait of Hormuz Bloomberg.com Europe tests \u2018third way\u2019 on Hormuz without the US, Israel and Iran. Will it work? South China Morning Post Macron and Starmer welcome news of Strait of Hormuz opening but say i","topics":["news headline"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"UK and France to lead defensive mission in Strait of Hormuz BBC Over a dozen countries offer to play role in Hormuz mission, Starmer says Reuters European Leaders Offer Military Help to Secure Strait of Hormuz Bloomberg.com Europe tests \u2018third way\u2019 on Hormuz without the US, Israel and Iran. Will it work? South China Morning Post Macron and Starmer welcome news of Strait of Hormuz opening but say it must be permanent PBS","title":"UK and France to lead defensive mission in Strait of Hormuz - BBC","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_17330c100f4d in signals