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/CBMilAFBVV95cUxPb1B0UVJaWHJKdTA0YmI4SVdhQTQwZG5kUVVLbUJ0SGtiUnRFeXdBd2daN0t1QjA0QjRuaVh6ejJieVBWN2hPcng2U19JelF5WnRCRmw2a1lhLUJfVlRfYk5sWVU5VGpUSXdwSXZaV2RlUlM3SnYydDdBYjR0OWNsRU1wR0RMTTAwWmdQaTlfMlE3SnND?oc=5","as_of":"2026-04-09T14:22:29.116564+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/CBMilAFBVV95cUxPb1B0UVJaWHJKdTA0YmI4SVdhQTQwZG5kUVVLbUJ0SGtiUnRFeXdBd2daN0t1QjA0QjRuaVh6ejJieVBWN2hPcng2U19JelF5WnRCRmw2a1lhLUJfVlRfYk5sWVU5VGpUSXdwSXZaV2RlUlM3SnYydDdBYjR0OWNsRU1wR0RMTTAwWmdQaTlfMlE3SnND?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e325f94ac8860035","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-09T23:33:16.470590+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxPb1B0UVJaWHJKdTA0YmI4SVdhQTQwZG5kUVVLbUJ0SGtiUnRFeXdBd2daN0t1QjA0QjRuaVh6ejJieVBWN2hPcng2U19JelF5WnRCRmw2a1lhLUJfVlRfYk5sWVU5VGpUSXdwSXZaV2RlUlM3SnYydDdBYjR0OWNsRU1wR0RMTTAwWmdQaTlfMlE3SnND?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxPb1B0UVJaWHJKdTA0YmI4SVdhQTQwZG5kUVVLbUJ0SGtiUnRFeXdBd2daN0t1QjA0QjRuaVh6ejJieVBWN2hPcng2U19JelF5WnRCRmw2a1lhLUJfVlRfYk5sWVU5VGpUSXdwSXZaV2RlUlM3SnYydDdBYjR0OWNsRU1wR0RMTTAwWmdQaTlfMlE3SnND?oc=5","source_event_id":"evt_f24b5f146b5a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a15f70ea723ff795","published_at":"2026-04-09T13:42:30+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"source of the recommendation","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The three recommended stocks (company names and ticker symbols) are not included in the provided text.","The article\u2019s rationale (e.g., dividend yield, payout growth, valuation, risk factors) is not included in the provided text.","Whether the recommendation is based on current market conditions or specific catalysts is not stated in the provided text.","No near-term catalyst timing beyond the phrase \u201cStarting Immediately\u201d is provided."],"key_facts":["Headline states: \u201c3 Stocks to Buy Now for a Lifetime of Passive Income -- Starting Immediately - The Motley Fool.\u201d","No stock tickers or company names are present in the provided text.","No performance metrics, dividend details, or timing specifics beyond \u201cStarting Immediately\u201d are provided in the provided text."],"numeric_claims":[],"primary_claim":"Motley Fool\u2019s article lists \u201c3 Stocks to Buy Now for a Lifetime of Passive Income \u2014 Starting Immediately.\u201d","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool published an article recommending three stocks as long-term passive-income investments, with the implication that investors should start immediately.","topics":["passive income","stock recommendations","long-term investing"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"3 Stocks to Buy Now for a Lifetime of Passive Income -- Starting Immediately The Motley Fool","title":"3 Stocks to Buy Now for a Lifetime of Passive Income -- Starting Immediately - The Motley Fool","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_ca6f6bda0df8 in signals