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/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5","as_of":"2026-04-09T04:35:26.085945+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/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f908b4356d684e98","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:37:13.072941+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5","source_event_id":"evt_64896905f007","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aa8ac7e1cffc9f24","published_at":"2026-04-09T04:01:00+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary source of the ceasefire-violation claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"counterparty in the ceasefire referenced by the headline","symbol":"","type":"country"},{"asset_class":"equity_index_futures","name":"US stock index futures","relevance":"directly referenced as wavering","symbol":"","type":"market instrument"},{"asset_class":"commodity","name":"Oil","relevance":"described as plunging in the provided source summary","symbol":"WTI/Brent (unspecified)","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["No details on who/what allegedly violated the ceasefire (location, incident, timing) are provided in the supplied text.","No specific oil price levels, percentage moves, or which benchmark (WTI vs Brent) are referenced.","No details on which specific US futures contracts or which equity/FX sectors moved are included in the supplied text.","Near-term catalyst timing (e.g., next scheduled talks, reports, or policy actions) is not specified in the provided content."],"key_facts":["Bloomberg headline indicates US futures are wavering amid Iran\u2019s statement that a ceasefire was violated.","Provided source summary states oil is plunging (exact magnitude not provided).","Provided source summary characterizes the US-Iran cease-fire as fragile (no specific terms/dates provided)."],"numeric_claims":[],"primary_claim":"US futures are wavering because Iran says the ceasefire was violated, contributing to market volatility.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Bloomberg reports US stock index futures are choppy as Iran claims a US-Iran ceasefire has been violated. The wrap also highlights sharp oil moves and broader market caution tied to a fragile US-Iran cease-fire.","topics":["US-Iran ceasefire","ceasefire violation claim","market volatility","oil price decline","energy market risk"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"US Futures Waver as Iran Says Ceasefire Violated: Markets Wrap Bloomberg.com Oil is plunging, but don\u2019t expect $3 gas anytime soon. Here\u2019s why CNN The third Gulf war will scar energy markets for a long time yet The Economist Oil Rebounds, Asian Equities Fall Amid Fragile U.S.-Iran Cease-Fire WSJ Transcript: The oil market navigates a shaky ceasefire Financial Times","title":"US Futures Waver as Iran Says Ceasefire Violated: Markets Wrap - Bloomberg.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_72c1f4f395a9 in signals