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/CBMiqAFBVV95cUxQOEFPekIxTkpaWHVTOGtPMG1MSUUtMkhaMER0aTdQVjBHVHAtX2E4eHhrVHJlU0xKam9NTU84UGc1dDNia1BGTmdyWjdqMW12SUtEQUhvazVRSm5wTXZ3OEtpYnJBUW9KZXd2RzA3b2RmaFFDQTI0Z3BmZHNLb2JzaVd1aDU2T1dnZndRZUlnUTFkMHdCa3N5TWUzbWZKNWdLdXlhVHZXTUg?oc=5","as_of":"2026-04-08T07:06:36.601179+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/CBMiqAFBVV95cUxQOEFPekIxTkpaWHVTOGtPMG1MSUUtMkhaMER0aTdQVjBHVHAtX2E4eHhrVHJlU0xKam9NTU84UGc1dDNia1BGTmdyWjdqMW12SUtEQUhvazVRSm5wTXZ3OEtpYnJBUW9KZXd2RzA3b2RmaFFDQTI0Z3BmZHNLb2JzaVd1aDU2T1dnZndRZUlnUTFkMHdCa3N5TWUzbWZKNWdLdXlhVHZXTUg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_005971492babcfcd","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-08T07:07:31.889416+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxQOEFPekIxTkpaWHVTOGtPMG1MSUUtMkhaMER0aTdQVjBHVHAtX2E4eHhrVHJlU0xKam9NTU84UGc1dDNia1BGTmdyWjdqMW12SUtEQUhvazVRSm5wTXZ3OEtpYnJBUW9KZXd2RzA3b2RmaFFDQTI0Z3BmZHNLb2JzaVd1aDU2T1dnZndRZUlnUTFkMHdCa3N5TWUzbWZKNWdLdXlhVHZXTUg?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/CBMiqAFBVV95cUxQOEFPekIxTkpaWHVTOGtPMG1MSUUtMkhaMER0aTdQVjBHVHAtX2E4eHhrVHJlU0xKam9NTU84UGc1dDNia1BGTmdyWjdqMW12SUtEQUhvazVRSm5wTXZ3OEtpYnJBUW9KZXd2RzA3b2RmaFFDQTI0Z3BmZHNLb2JzaVd1aDU2T1dnZndRZUlnUTFkMHdCa3N5TWUzbWZKNWdLdXlhVHZXTUg?oc=5","source_event_id":"evt_8bf33fc89ae2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"441b3dcc22be45d6","published_at":"2026-04-08T06:21:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"UnitedHealth Group","relevance":"high","symbol":"UNH","type":"company"}],"event_type":"earnings","information_gaps":["The article text content is not provided beyond the headline/summary, so the specific analyst firm, rating change (e.g., from Hold to Buy), target price, and timing/catalyst date are unknown.","No details are given on the magnitude of the earnings estimate upside or which future period(s) are referenced.","No confirmation is provided about whether the upgrade is based on fundamentals, valuation, or specific business drivers beyond the general phrase 'potential upside to earnings estimates.'"],"key_facts":["Source is Yahoo Finance (finance.yahoo.com).","Headline states UNH was upgraded over potential upside to earnings estimates."],"numeric_claims":[],"primary_claim":"UnitedHealth Group (UNH) received an upgrade over potential upside to earnings estimates.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Yahoo Finance reports that UnitedHealth Group (UNH) was upgraded based on potential upside to earnings estimates.","topics":["analyst upgrade","earnings estimates","potential upside"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"UnitedHealth Group (UNH) Upgraded Over Potential Upside to Earnings Estimates Yahoo Finance","title":"UnitedHealth Group (UNH) Upgraded Over Potential Upside to Earnings Estimates - 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_77454ef52427 in signals