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/CBMilwFBVV95cUxPeThsSUtydVVrY1VyTkFkbGs1cUlyUlJIa2dCU29WZ0VXSGR0NURIMmRhMWJ2VVdVTVpWWWRSeWVmajRteGlqaHRMM2pQY1ZmWk9xejhVTG10c2RvbkJNeXhoQ2RPa1VXNU9VR0NWek1HdVEzLXQxaVF5M2V5MVEyd2FLVm9OM1pVNmJGVjRRZFFLZ0prSTdF0gGfAUFVX3lxTE9jcndRQmJIX0dLSFRfbGhuMnVBb1BJZ2MxQjFFemo3aU81TDVMWjgwd0NBWmFGdEhVU0lOc0xaZGxvZFBCYnZNYV81Qnh4ZXBCLTNZb0padlBvbVlOaGEzbkw4d204TWI0Vjh5d1QzaGtHcDhiMHNiR28wdjR3bWlscGR3aUh0MWlzcWZVT0lQbW9GT05aVGRWUEwtbGZDbw?oc=5","as_of":"2026-04-09T03:06:53.832734+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/CBMilwFBVV95cUxPeThsSUtydVVrY1VyTkFkbGs1cUlyUlJIa2dCU29WZ0VXSGR0NURIMmRhMWJ2VVdVTVpWWWRSeWVmajRteGlqaHRMM2pQY1ZmWk9xejhVTG10c2RvbkJNeXhoQ2RPa1VXNU9VR0NWek1HdVEzLXQxaVF5M2V5MVEyd2FLVm9OM1pVNmJGVjRRZFFLZ0prSTdF0gGfAUFVX3lxTE9jcndRQmJIX0dLSFRfbGhuMnVBb1BJZ2MxQjFFemo3aU81TDVMWjgwd0NBWmFGdEhVU0lOc0xaZGxvZFBCYnZNYV81Qnh4ZXBCLTNZb0padlBvbVlOaGEzbkw4d204TWI0Vjh5d1QzaGtHcDhiMHNiR28wdjR3bWlscGR3aUh0MWlzcWZVT0lQbW9GT05aVGRWUEwtbGZDbw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_65dc4ea7fa6dc644","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:28:57.043036+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPeThsSUtydVVrY1VyTkFkbGs1cUlyUlJIa2dCU29WZ0VXSGR0NURIMmRhMWJ2VVdVTVpWWWRSeWVmajRteGlqaHRMM2pQY1ZmWk9xejhVTG10c2RvbkJNeXhoQ2RPa1VXNU9VR0NWek1HdVEzLXQxaVF5M2V5MVEyd2FLVm9OM1pVNmJGVjRRZFFLZ0prSTdF0gGfAUFVX3lxTE9jcndRQmJIX0dLSFRfbGhuMnVBb1BJZ2MxQjFFemo3aU81TDVMWjgwd0NBWmFGdEhVU0lOc0xaZGxvZFBCYnZNYV81Qnh4ZXBCLTNZb0padlBvbVlOaGEzbkw4d204TWI0Vjh5d1QzaGtHcDhiMHNiR28wdjR3bWlscGR3aUh0MWlzcWZVT0lQbW9GT05aVGRWUEwtbGZDbw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcbayarea.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPeThsSUtydVVrY1VyTkFkbGs1cUlyUlJIa2dCU29WZ0VXSGR0NURIMmRhMWJ2VVdVTVpWWWRSeWVmajRteGlqaHRMM2pQY1ZmWk9xejhVTG10c2RvbkJNeXhoQ2RPa1VXNU9VR0NWek1HdVEzLXQxaVF5M2V5MVEyd2FLVm9OM1pVNmJGVjRRZFFLZ0prSTdF0gGfAUFVX3lxTE9jcndRQmJIX0dLSFRfbGhuMnVBb1BJZ2MxQjFFemo3aU81TDVMWjgwd0NBWmFGdEhVU0lOc0xaZGxvZFBCYnZNYV81Qnh4ZXBCLTNZb0padlBvbVlOaGEzbkw4d204TWI0Vjh5d1QzaGtHcDhiMHNiR28wdjR3bWlscGR3aUh0MWlzcWZVT0lQbW9GT05aVGRWUEwtbGZDbw?oc=5","source_event_id":"evt_e3b3fed3e4d6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7cdc06c68b8b994f","published_at":"2026-04-08T23:36:37+00:00","publisher_domain":"nbcbayarea.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"geopolitical","name":"Iran","relevance":"causal driver mentioned in headline","symbol":"","type":"country"},{"asset_class":"equity_index","name":"Stock market (unspecified index)","relevance":"primary market-moving subject","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["No specific index(s) or tickers are named (e.g., S&P 500, Nasdaq, Dow).","No magnitude of the move (percent/points) is provided in the provided text.","No details on what the ceasefire news specifically was or when it occurred are included.","No information on whether the move is intraday, sustained, or reversed is provided."],"key_facts":["NBC Bay Area headline states that the stock market surged on Iran ceasefire news."],"numeric_claims":[],"primary_claim":"Stocks surged on Iran ceasefire news, according to NBC Bay Area.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"The headline reports that stock markets surged following news about an Iran ceasefire.","topics":["Iran ceasefire","stock market surge","geopolitical news impact"]},"source":"NBC Bay Area","source_domain":"nbcbayarea.com","source_url":"https://www.nbcbayarea.com","summary":"","tickers":[],"title":"Stock market surges on Iran ceasefire news - NBC Bay Area","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_6e34b3f093fc in signals