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/CBMimAFBVV95cUxQVUxlc1dyRU54dWVOV2E4QnozbndyenFjNDhqVlk1cklOdF8tX1hmT2NxclJZX05XdHhyMURCd2c1RTh4QmVReS1aYS1MdFpWd0d1QkdnajZQTnZkZDhuTGVNR3lMUnlxN3dGTkcyVF9YQWlrdzVUdDlsOEs5U1BrNnI1OE1NWHpNYWRMLXJuSVZSNjhUWHdiMA?oc=5","as_of":"2026-04-08T19:34:52.192128+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/CBMimAFBVV95cUxQVUxlc1dyRU54dWVOV2E4QnozbndyenFjNDhqVlk1cklOdF8tX1hmT2NxclJZX05XdHhyMURCd2c1RTh4QmVReS1aYS1MdFpWd0d1QkdnajZQTnZkZDhuTGVNR3lMUnlxN3dGTkcyVF9YQWlrdzVUdDlsOEs5U1BrNnI1OE1NWHpNYWRMLXJuSVZSNjhUWHdiMA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_101abfa1841037a9","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-09T22:03:30.608296+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQVUxlc1dyRU54dWVOV2E4QnozbndyenFjNDhqVlk1cklOdF8tX1hmT2NxclJZX05XdHhyMURCd2c1RTh4QmVReS1aYS1MdFpWd0d1QkdnajZQTnZkZDhuTGVNR3lMUnlxN3dGTkcyVF9YQWlrdzVUdDlsOEs5U1BrNnI1OE1NWHpNYWRMLXJuSVZSNjhUWHdiMA?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/CBMimAFBVV95cUxQVUxlc1dyRU54dWVOV2E4QnozbndyenFjNDhqVlk1cklOdF8tX1hmT2NxclJZX05XdHhyMURCd2c1RTh4QmVReS1aYS1MdFpWd0d1QkdnajZQTnZkZDhuTGVNR3lMUnlxN3dGTkcyVF9YQWlrdzVUdDlsOEs5U1BrNnI1OE1NWHpNYWRMLXJuSVZSNjhUWHdiMA?oc=5","source_event_id":"evt_9435d76661c1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2c9d19edabf17488","published_at":"2026-04-08T17:49:22+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["5 years ago","today"],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"source of the claim","symbol":"","type":"publisher"},{"asset_class":"equities","name":"3 growth stocks","relevance":"the subject of the performance claim","symbol":"","type":"asset_group"}],"event_type":"other","information_gaps":["The specific three growth stocks are not named in the provided text.","No tickers, purchase dates, or whether returns include dividends are provided.","No evidence or calculations are shown beyond the headline assertion.","No near-term catalyst timing is described; this is a retrospective performance framing."],"key_facts":["Headline states: investing $10,000 in each of three growth stocks five years ago would have created a portfolio worth more than $260,000 today.","No stock tickers/names are included in the provided text.","No methodology (e.g., exact purchase dates, dividends, fees) is included in the provided text."],"numeric_claims":[{"label":"Initial investment per stock","value":"$10,000"},{"label":"Number of stocks","value":"3"},{"label":"Time horizon","value":"5 years"},{"label":"Implied current portfolio value","value":"more than $260,000"}],"primary_claim":"A $10,000 investment in each of three growth stocks made five years ago would be worth more than $260,000 today.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article claims that investing $10,000 in each of three growth stocks five years ago would have produced a portfolio value exceeding $260,000 today. The provided text does not name the specific stocks or provide supporting performance details beyond the headline claim.","topics":["growth stocks","5-year performance","portfolio value","hypothetical investment"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"Investing $10,000 In Each of These 3 Growth Stocks 5 Years Ago Would Have Created a Portfolio Worth More Than $260,000 Today The Motley Fool","title":"Investing $10,000 In Each of These 3 Growth Stocks 5 Years Ago Would Have Created a Portfolio Worth More Than $260,000 Today - 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_929a586dbfb6 in signals