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/CBMilwFBVV95cUxOSmJud0JoYkRXWUk1eGJDUU9rRndhQ1EtakgwQUViakNYZzFzZWhKUHhvTWJyQ0pvZUlzdUFUSXJ0eEFQR2t6RlEzMUIzWUNtNC11cDZLQ2RtcVEzc2lJR0hDaWdUOWtod1FaMDJBcUQzN1FhTmRLdUlDM3RITTVmS2FueUFRV0lPQW52Zk1sQVcyd2dwbnVz?oc=5","as_of":"2026-04-14T21:04:44.870679+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOSmJud0JoYkRXWUk1eGJDUU9rRndhQ1EtakgwQUViakNYZzFzZWhKUHhvTWJyQ0pvZUlzdUFUSXJ0eEFQR2t6RlEzMUIzWUNtNC11cDZLQ2RtcVEzc2lJR0hDaWdUOWtod1FaMDJBcUQzN1FhTmRLdUlDM3RITTVmS2FueUFRV0lPQW52Zk1sQVcyd2dwbnVz?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ccad7efcd30baf6d","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T21:45:22.748090+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOSmJud0JoYkRXWUk1eGJDUU9rRndhQ1EtakgwQUViakNYZzFzZWhKUHhvTWJyQ0pvZUlzdUFUSXJ0eEFQR2t6RlEzMUIzWUNtNC11cDZLQ2RtcVEzc2lJR0hDaWdUOWtod1FaMDJBcUQzN1FhTmRLdUlDM3RITTVmS2FueUFRV0lPQW52Zk1sQVcyd2dwbnVz?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/CBMilwFBVV95cUxOSmJud0JoYkRXWUk1eGJDUU9rRndhQ1EtakgwQUViakNYZzFzZWhKUHhvTWJyQ0pvZUlzdUFUSXJ0eEFQR2t6RlEzMUIzWUNtNC11cDZLQ2RtcVEzc2lJR0hDaWdUOWtod1FaMDJBcUQzN1FhTmRLdUlDM3RITTVmS2FueUFRV0lPQW52Zk1sQVcyd2dwbnVz?oc=5","source_event_id":"evt_35b90c9af63b","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"24f63f36c674e0b1","published_at":"2026-04-14T20:33:26+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"high","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The three recommended stocks (company names and ticker symbols) are not provided.","No performance metrics, valuations, or business catalysts are included.","No timing details beyond \u201cbuy now and hold for the long term\u201d are provided.","No evidence from the article body is available to validate the recommendations."],"key_facts":["Headline states: \u201c3 Brilliant Growth Stocks to Buy Now and Hold for the Long Term.\u201d","No company names or stock symbols are included in the provided text."],"numeric_claims":[],"primary_claim":"The Motley Fool published an article recommending three growth stocks to buy now and hold long term.","relevance_score":0.25,"sentiment":"positive","source_quality":"unknown","summary":"The Motley Fool headline promotes three \u201cbrilliant growth stocks\u201d as long-term buy-and-hold opportunities. No specific stock tickers, company details, or catalysts are provided in the available text.","topics":["growth stocks","long-term investing","stock recommendations"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"3 Brilliant Growth Stocks to Buy Now and Hold for the Long Term The Motley Fool","title":"3 Brilliant Growth Stocks to Buy Now and Hold for the Long Term - The Motley Fool","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_05fe2e300534 in signals