SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T14:43:45.992610+00:00","dedupe_key":"signal_enriched:news_delta:48b7860e14cd5e15","evidence_event_ids":["evt_d88c24fa3e71"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQX1lhaG5lOU9VVUp1V083M2xUeVlJaW1Ba3diRHc3dGtjbUlNMGdGYlh4MWMzNW1vRGZfSWIzYzRRVTVQNEl5MC1EdWhwb2ZxQjNmZzJrbFFBcnF0bmVlaXFVRXd5WTlCVVNGTlpGN3d5Z19tSl9FdWFmUFZQc01IVTd2Qkp0QTFhMzlIMlpGcUJ4a1Z4MXFieA?oc=5","as_of":"2026-04-08T14:43:45.992610+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-08T17:19:30.656168+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_d88c24fa3e71","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5c71d8d080503da8","published_at":"2026-04-08T14:26:53+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":"source of the recommendation","symbol":"","type":"publisher"},{"asset_class":"media","name":"3 Absurdly Cheap Dividend Stocks to Buy in April 2026","relevance":"the specific content referenced by the signal","symbol":"","type":"article"}],"event_type":"other","information_gaps":["The provided text does not include the names or ticker symbols of the three dividend stocks.","No valuation metrics, dividend yields, or financial rationale are included in the provided content.","No timing details beyond \u201cin April 2026\u201d are provided (e.g., catalysts, earnings dates, or ex-dividend dates)."],"key_facts":["Headline states: \u201c3 Absurdly Cheap Dividend Stocks to Buy in April 2026\u201d (The Motley Fool).","No stock tickers or company names are present in the provided text beyond the headline and source summary."],"numeric_claims":[],"primary_claim":"The article lists three \u201cabsurdly cheap dividend stocks\u201d as buy candidates for April 2026.","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 recommendations","April 2026","valuation","equities"]},"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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 7378 in events