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/CBMi0wFBVV95cUxQa1dBM3ZMSXY4dmxEN0g1bUNPX21oUXlpMEdINXNuRWtBdnFVOTdsRC1mTThPdEpMQUdIWlFlbl9QSDRvTW1RTUlYNS12NFBMRGdRTUJhcEdIRFNiUUFkcnpwU0hrbmFiWTVKZnVZNy1lajQySXdxRFJIX3QzUEswb3ZXWmJ4ZDR6XzRlcTVncnNYclRiVWVTUkdxTnFMVDkwYVhMejhTa2Y0SmsyLVFWQTlZTHY5RUxoRk0xRkJpTXdOZ0F1cms3Nm5STks1ZVJwR0lR?oc=5","as_of":"2026-04-07T23:23:39.344374+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/CBMi0wFBVV95cUxQa1dBM3ZMSXY4dmxEN0g1bUNPX21oUXlpMEdINXNuRWtBdnFVOTdsRC1mTThPdEpMQUdIWlFlbl9QSDRvTW1RTUlYNS12NFBMRGdRTUJhcEdIRFNiUUFkcnpwU0hrbmFiWTVKZnVZNy1lajQySXdxRFJIX3QzUEswb3ZXWmJ4ZDR6XzRlcTVncnNYclRiVWVTUkdxTnFMVDkwYVhMejhTa2Y0SmsyLVFWQTlZTHY5RUxoRk0xRkJpTXdOZ0F1cms3Nm5STks1ZVJwR0lR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5044fc4ea9a59494","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-08T00:36:46.402088+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi0wFBVV95cUxQa1dBM3ZMSXY4dmxEN0g1bUNPX21oUXlpMEdINXNuRWtBdnFVOTdsRC1mTThPdEpMQUdIWlFlbl9QSDRvTW1RTUlYNS12NFBMRGdRTUJhcEdIRFNiUUFkcnpwU0hrbmFiWTVKZnVZNy1lajQySXdxRFJIX3QzUEswb3ZXWmJ4ZDR6XzRlcTVncnNYclRiVWVTUkdxTnFMVDkwYVhMejhTa2Y0SmsyLVFWQTlZTHY5RUxoRk0xRkJpTXdOZ0F1cms3Nm5STks1ZVJwR0lR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi0wFBVV95cUxQa1dBM3ZMSXY4dmxEN0g1bUNPX21oUXlpMEdINXNuRWtBdnFVOTdsRC1mTThPdEpMQUdIWlFlbl9QSDRvTW1RTUlYNS12NFBMRGdRTUJhcEdIRFNiUUFkcnpwU0hrbmFiWTVKZnVZNy1lajQySXdxRFJIX3QzUEswb3ZXWmJ4ZDR6XzRlcTVncnNYclRiVWVTUkdxTnFMVDkwYVhMejhTa2Y0SmsyLVFWQTlZTHY5RUxoRk0xRkJpTXdOZ0F1cms3Nm5STks1ZVJwR0lR?oc=5","source_event_id":"evt_a7ce7ec0fd18","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"85642a4157de4731","published_at":"2026-04-07T15:15:43+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["next year"],"entities":[{"asset_class":"equity","name":"UnitedHealth","relevance":"high","symbol":"UNH","type":"company"},{"asset_class":"equity","name":"other insurer stocks","relevance":"medium","symbol":"","type":"sector_group"},{"asset_class":"policy","name":"Medicare","relevance":"high","symbol":"","type":"government_program"}],"event_type":"regulation","information_gaps":["The specific amount or percentage of the Medicare payment increase is not provided.","The exact timing/date of the agreement and when the market reaction occurred are not provided.","Which specific \u201cother insurer\u201d companies are included is not listed.","Whether the stock move is measured intraday vs. over multiple sessions is not provided.","No details are given on the mechanism (e.g., reimbursement rates, risk adjustment, MA vs. traditional Medicare)."],"key_facts":["Yahoo Finance headline states that UnitedHealth and other insurer stocks jumped.","The jump is attributed to Medicare agreeing to lift payments next year."],"numeric_claims":[],"primary_claim":"Medicare agreed to lift payments next year, and this led to a jump in UnitedHealth and other insurer stocks.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"UnitedHealth and other insurer stocks rose after Medicare agreed to lift payments next year, according to Yahoo Finance.","topics":["Medicare payment policy","health insurance stocks","UnitedHealth","market reaction"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"UnitedHealth and other insurer stocks jump after Medicare agrees to lift payments next year Yahoo Finance","title":"UnitedHealth and other insurer stocks jump after Medicare agrees to lift payments next year - Yahoo Finance","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_519d22f49b7f in signals