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-09T00:58:18.473403+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_b55e4a9cd195f198","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:20:57.245628+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_20f2c01f85aa","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aa8ac7e1cffc9f24","published_at":"2026-04-08T23:30:47+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary driver of the headline claim","symbol":"","type":"country"},{"asset_class":"futures","name":"US stock index futures","relevance":"describes the market reaction","symbol":"","type":"market instrument"}],"event_type":"geopolitical_risk","information_gaps":["No article body content was provided beyond page-cleaning CSS, so details such as which ceasefire, timing, and specific market instruments/percent moves are not available.","No specific tickers or contract symbols for the \u201cUS futures\u201d are provided in the provided text.","No confirmation is provided on whether the ceasefire violation claim is disputed or corroborated within the provided text."],"key_facts":["The headline states US futures wavered.","The headline states Iran said a ceasefire was violated.","The headline is labeled as a \u201cMarkets Wrap.\u201d"],"numeric_claims":[],"primary_claim":"US futures were wavering after Iran said a ceasefire was violated.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Bloomberg reports that US stock index futures were choppy as Iran stated a ceasefire was violated. The headline frames the move as a markets wrap driven by Iran-related ceasefire claims.","topics":["US futures","Iran","ceasefire violation","geopolitical risk","market wrap"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"","tickers":[],"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_3a18233a459c in signals