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/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?oc=5","as_of":"2026-04-07T00:26:15.463753+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/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9c4853b0680da4ea","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-07T14:19:26.324947+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?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/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?oc=5","source_event_id":"evt_f21d19a5f0e9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f70eef618ba58037","published_at":"2026-04-06T23:34:11+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"shipping","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geopolitical location"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"IR","type":"country"}],"event_type":"supply_disruption","information_gaps":["Specific countries involved in the transits are not mentioned.","Details on the nature of the crisis affecting shipping are unclear."],"key_facts":["15 ships transited the Strait of Hormuz in 24 hours.","Traffic is at its highest in weeks."],"numeric_claims":[{"label":"Number of ships transiting","value":"15"},{"label":"Traffic increase duration","value":"highest in weeks"}],"primary_claim":"15 ships transited the Strait of Hormuz in 24 hours, marking the highest traffic in weeks according to Iranian media.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"The Strait of Hormuz is experiencing increased shipping traffic, with reports of 15 ships transiting in a 24-hour period, indicating a rise in maritime activity amid ongoing tensions.","topics":["shipping","geopolitics","Strait of Hormuz","Iran"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Which Asian countries are passing through the Strait of Hormuz? BBC 15 Ships Transit Strait of Hormuz in 24 Hours, Iranian Media Says WSJ Hormuz Traffic Rises to Highest in Weeks as More Transits Agreed Bloomberg.com Beyond oil: 9 commodities impacted by the Strait of Hormuz crisis The World Economic Forum Shipping Industry Uncertain As Hormuz Crisis Carries On news.usni.org","title":"Which Asian countries are passing through the Strait of Hormuz? - BBC","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_8c8ec3f57c97 in signals