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/CBMihAFBVV95cUxNSnNXY1BvbmIxQXNBSmxIUWdQUXZhY1N2SU9rM1hvTE8yWHZmcUEyOGZOZVg1eEZSZThNU0dNeFYxN1RneXBPTUZUMEhXTVdIS25DZEs2R3RPemdiTjU0NmV1ZkxST1lMV2E0bFZvbGVyWkk2TXBMWW92SUVTRDduQ2xaYjk?oc=5","as_of":"2026-04-13T10:19:16.700098+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/CBMihAFBVV95cUxNSnNXY1BvbmIxQXNBSmxIUWdQUXZhY1N2SU9rM1hvTE8yWHZmcUEyOGZOZVg1eEZSZThNU0dNeFYxN1RneXBPTUZUMEhXTVdIS25DZEs2R3RPemdiTjU0NmV1ZkxST1lMV2E0bFZvbGVyWkk2TXBMWW92SUVTRDduQ2xaYjk?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_982bb6f7066fccf4","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-13T10:24:44.692079+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNSnNXY1BvbmIxQXNBSmxIUWdQUXZhY1N2SU9rM1hvTE8yWHZmcUEyOGZOZVg1eEZSZThNU0dNeFYxN1RneXBPTUZUMEhXTVdIS25DZEs2R3RPemdiTjU0NmV1ZkxST1lMV2E0bFZvbGVyWkk2TXBMWW92SUVTRDduQ2xaYjk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sg.finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxNSnNXY1BvbmIxQXNBSmxIUWdQUXZhY1N2SU9rM1hvTE8yWHZmcUEyOGZOZVg1eEZSZThNU0dNeFYxN1RneXBPTUZUMEhXTVdIS25DZEs2R3RPemdiTjU0NmV1ZkxST1lMV2E0bFZvbGVyWkk2TXBMWW92SUVTRDduQ2xaYjk?oc=5","source_event_id":"evt_40c64d4eed6e","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"efec52691ee2b1d3","published_at":"2026-04-13T06:30:00+00:00","publisher_domain":"sg.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"National Grid","relevance":"mentioned in headline","symbol":"","type":"company"},{"asset_class":"equity","name":"MTI Wireless Edge","relevance":"mentioned in headline","symbol":"","type":"company"},{"asset_class":"equity","name":"Mothercare","relevance":"mentioned in headline","symbol":"","type":"company"}],"event_type":"other","information_gaps":["No article text or source summary was provided, so there are no details on price moves, earnings, guidance, transactions, regulatory actions, or catalysts.","No ticker symbols or standardized asset identifiers are provided in the text.","No indication is given whether the implied market impact is continuation or reversal."],"key_facts":["Headline lists National Grid, MTI Wireless Edge, and Mothercare as topics of UK stock market news coverage."],"numeric_claims":[],"primary_claim":"The headline references UK stock market news for National Grid, MTI Wireless Edge, and Mothercare.","relevance_score":0.35,"sentiment":"neutral","source_quality":"unknown","summary":"The provided headline indicates UK stock market news coverage involving National Grid, MTI Wireless Edge, and Mothercare, but no specific market-moving details are included in the text provided.","topics":["UK stock market news","company-specific coverage"]},"source":"Yahoo Finance Singapore","source_domain":"sg.finance.yahoo.com","source_url":"https://sg.finance.yahoo.com","summary":"","tickers":[],"title":"UK Stock Market News: National Grid, MTI Wireless Edge, Mothercare - Yahoo Finance Singapore","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_e6e156856f33 in signals