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/CBMimAFBVV95cUxQX1lhaG5lOU9VVUp1V083M2xUeVlJaW1Ba3diRHc3dGtjbUlNMGdGYlh4MWMzNW1vRGZfSWIzYzRRVTVQNEl5MC1EdWhwb2ZxQjNmZzJrbFFBcnF0bmVlaXFVRXd5WTlCVVNGTlpGN3d5Z19tSl9FdWFmUFZQc01IVTd2Qkp0QTFhMzlIMlpGcUJ4a1Z4MXFieA?oc=5","as_of":"2026-04-08T19:34:52.428855+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/CBMimAFBVV95cUxQX1lhaG5lOU9VVUp1V083M2xUeVlJaW1Ba3diRHc3dGtjbUlNMGdGYlh4MWMzNW1vRGZfSWIzYzRRVTVQNEl5MC1EdWhwb2ZxQjNmZzJrbFFBcnF0bmVlaXFVRXd5WTlCVVNGTlpGN3d5Z19tSl9FdWFmUFZQc01IVTd2Qkp0QTFhMzlIMlpGcUJ4a1Z4MXFieA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9b24e66cf67132ac","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:06:40.746627+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQX1lhaG5lOU9VVUp1V083M2xUeVlJaW1Ba3diRHc3dGtjbUlNMGdGYlh4MWMzNW1vRGZfSWIzYzRRVTVQNEl5MC1EdWhwb2ZxQjNmZzJrbFFBcnF0bmVlaXFVRXd5WTlCVVNGTlpGN3d5Z19tSl9FdWFmUFZQc01IVTd2Qkp0QTFhMzlIMlpGcUJ4a1Z4MXFieA?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/CBMimAFBVV95cUxQX1lhaG5lOU9VVUp1V083M2xUeVlJaW1Ba3diRHc3dGtjbUlNMGdGYlh4MWMzNW1vRGZfSWIzYzRRVTVQNEl5MC1EdWhwb2ZxQjNmZzJrbFFBcnF0bmVlaXFVRXd5WTlCVVNGTlpGN3d5Z19tSl9FdWFmUFZQc01IVTd2Qkp0QTFhMzlIMlpGcUJ4a1Z4MXFieA?oc=5","source_event_id":"evt_c4fe2e18d000","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5c71d8d080503da8","published_at":"2026-04-08T15:00:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["April 2026"],"entities":[{"asset_class":"media","name":"The Motley Fool","relevance":"primary source","symbol":"","type":"publisher"},{"asset_class":"equities","name":"Dividend stocks (unspecified)","relevance":"subject of recommendation","symbol":"","type":"asset_category"}],"event_type":"listing","information_gaps":["The three specific dividend stocks (company names) are not present in the provided text.","No ticker symbols are provided.","No valuation metrics, dividend yields, or financial rationale are included in the provided text.","No timing/catalyst details beyond the month/year (\u201cApril 2026\u201d) are included."],"key_facts":["Headline: \u201c3 Absurdly Cheap Dividend Stocks to Buy in April 2026 - The Motley Fool.\u201d","The provided source summary repeats the same headline text.","No specific company names or ticker symbols are included in the provided text."],"numeric_claims":[],"primary_claim":"The article title states there are \u201c3 Absurdly Cheap Dividend Stocks to Buy in April 2026.\u201d","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool published an article recommending three dividend stocks described as \u201cabsurdly cheap\u201d to buy in April 2026.","topics":["dividend stocks","stock picking","April 2026","valuation"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"3 Absurdly Cheap Dividend Stocks to Buy in April 2026 The Motley Fool","title":"3 Absurdly Cheap Dividend Stocks to Buy in April 2026 - 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_cea29597b734 in signals