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/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5","as_of":"2026-04-08T03:31:26.545347+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/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_33301699d5bf0c22","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-08T03:49:35.026442+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?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/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5","source_event_id":"evt_35c4c332fbbe","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"03b58ff3547466e7","published_at":"2026-04-08T02:01:58+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"affected party (ceasefire counterpart)","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"affected party (ceasefire counterpart)","symbol":"","type":"country"},{"asset_class":"commodity_infrastructure","name":"Strait of Hormuz","relevance":"mechanism linking ceasefire to oil supply risk","symbol":"","type":"geographic chokepoint"},{"asset_class":"commodity","name":"Oil","relevance":"primary market moved (plunged)","symbol":"WTI/Brent (unspecified)","type":"commodity"},{"asset_class":"equities","name":"US stocks","relevance":"secondary market reaction (stocks rally mentioned in source summary)","symbol":"Dow/S&P 500/Nasdaq (unspecified)","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["The exact ceasefire duration (e.g., \u201ctwo-week\u201d) is mentioned only in the provided multi-source summary, not in the BBC headline text itself; duration details are therefore uncertain here.","The specific oil benchmark (WTI vs Brent) and the magnitude of the plunge (percent/absolute) are not provided in the extracted text.","The mechanism is described as \u201creopen Strait of Hormuz,\u201d but the operational details (what reopening means, when it occurs) are not included in the provided content.","Stock index levels and timing (intraday vs close) are not specified in the provided BBC headline text."],"key_facts":["A US-Iran ceasefire deal was announced (timing: near-term, per headline).","The deal is described as aimed at reopening the Strait of Hormuz.","Oil prices dropped sharply (\u201cplunges\u201d / \u201cbelow $100\u201d mentioned in the provided source summary).","Stocks reportedly rallied after the ceasefire announcement (per provided source summary)."],"numeric_claims":[{"label":"Oil price level","value":"below $100 (currency/benchmark unspecified)"}],"primary_claim":"Oil plunged following a US-Iran ceasefire deal intended to reopen the Strait of Hormuz.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Oil prices fell sharply after a US-Iran ceasefire deal was announced, with the expectation that it would reopen the Strait of Hormuz. The headline also implies a near-term risk-on reaction in broader markets (stocks rally) alongside the oil drop.","topics":["US-Iran ceasefire","Strait of Hormuz reopening","oil price move","market reaction (stocks)"]},"source":"bbc.com","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Oil plunges after US-Iran ceasefire deal to reopen Strait of Hormuz bbc.com Oil prices drop and stocks rally after Trump\u2019s ceasefire announcement CNN U.S.-Iran ceasefire relief rally lifts global assets as oil plunges below $100 CNBC Stock Market Today: Oil Jumps, Dow Dips After U.S. Raises the Temperature on Iran \u2014 Live Updates WSJ Stock market today: Dow, S&P 500, Nasdaq futures surge on news of a two-week ceasefire Yahoo Finance","title":"Oil plunges after US-Iran ceasefire deal to reopen Strait of Hormuz - bbc.com","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_5351a0933c86 in signals