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/CBMikgFBVV95cUxOS2VLdEhRTjUzTWFwYXhMbmdkTzFiekpBeDQtSHNZREVBMkxEYmZFa2RaTWZZdnFNaHV2ZF9xbjd3ejVXRElvSG5pZ1QtbUhNTGMzTW1LNWtSbm5EZkV2VW1mRi12OEtNWnQyZDJjVTZlb01kUUVobXZ5aS1LZDY5TFFCdXd3SEpKWWRrQXVteVFiZw?oc=5","as_of":"2026-04-07T23:23:38.622349+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/CBMikgFBVV95cUxOS2VLdEhRTjUzTWFwYXhMbmdkTzFiekpBeDQtSHNZREVBMkxEYmZFa2RaTWZZdnFNaHV2ZF9xbjd3ejVXRElvSG5pZ1QtbUhNTGMzTW1LNWtSbm5EZkV2VW1mRi12OEtNWnQyZDJjVTZlb01kUUVobXZ5aS1LZDY5TFFCdXd3SEpKWWRrQXVteVFiZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4c8c8b89b408d5e3","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:34:31.755469+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOS2VLdEhRTjUzTWFwYXhMbmdkTzFiekpBeDQtSHNZREVBMkxEYmZFa2RaTWZZdnFNaHV2ZF9xbjd3ejVXRElvSG5pZ1QtbUhNTGMzTW1LNWtSbm5EZkV2VW1mRi12OEtNWnQyZDJjVTZlb01kUUVobXZ5aS1LZDY5TFFCdXd3SEpKWWRrQXVteVFiZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOS2VLdEhRTjUzTWFwYXhMbmdkTzFiekpBeDQtSHNZREVBMkxEYmZFa2RaTWZZdnFNaHV2ZF9xbjd3ejVXRElvSG5pZ1QtbUhNTGMzTW1LNWtSbm5EZkV2VW1mRi12OEtNWnQyZDJjVTZlb01kUUVobXZ5aS1LZDY5TFFCdXd3SEpKWWRrQXVteVFiZw?oc=5","source_event_id":"evt_fb5fc7193868","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"98d21138451da6c7","published_at":"2026-04-07T19:08:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Williams","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Henry Schein","relevance":"high","symbol":"","type":"company"},{"asset_class":"unknown","name":"Veteran value fund manager","relevance":"medium","symbol":"","type":"person_or_role"},{"asset_class":"media","name":"Barron's","relevance":"high","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The article text provided contains only page styling/HTML and does not include the actual content of the Barron\u2019s article beyond the headline/source summary.","No stock symbols (tickers) are provided in the provided text.","The identities of the \u201c3 Other\u201d stocks are not specified in the provided text.","The veteran value fund manager\u2019s name and the specific rationale/metrics for \u201cbargain\u201d are not provided in the provided text.","No timing catalyst (e.g., earnings date, rebalancing date) is mentioned in the provided text."],"key_facts":["Barron\u2019s headline states that Williams and Henry Schein are included in a list of \u201cbargain stocks.\u201d","The headline also states that there are three other bargain stocks included in the list.","The list is attributed to a veteran value fund manager."],"numeric_claims":[],"primary_claim":"The Barron\u2019s piece names Williams and Henry Schein plus three other stocks as bargain opportunities from a veteran value fund manager.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"Barron\u2019s highlights Williams and Henry Schein, along with three other stocks, as \u201cbargain\u201d picks from a veteran value fund manager.","topics":["value investing","bargain stocks","stock picking","equities"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"Williams, Henry Schein, and 3 Other Bargain Stocks From a Veteran Value Fund Manager Barron's","title":"Williams, Henry Schein, and 3 Other Bargain Stocks From a Veteran Value Fund Manager - Barron's","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_38c7258e40d2 in signals