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-12T07:19:58.159491+00:00","dedupe_key":"signal_enriched:news_delta:c0bb02daa9a7d8db","evidence_event_ids":["evt_8b39ab397847"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTFBGV2VaRkx1Q2lId1ZBVzBrQjE3VDRwZU5jWGVLUlJQNDlWbmdvaFFaN0ZRdkJEZXhIRXVWUmtxdmZsZWZ5em9GdDg3V0xwS2FUbXlmYkYxOGlSTGdJX3hvNXZfdTViM0ZYTlJzUHR5dU8xYUFHMVpydlF2WlFTQQ?oc=5","as_of":"2026-04-12T07:19:58.159491+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/CBMifkFVX3lxTFBGV2VaRkx1Q2lId1ZBVzBrQjE3VDRwZU5jWGVLUlJQNDlWbmdvaFFaN0ZRdkJEZXhIRXVWUmtxdmZsZWZ5em9GdDg3V0xwS2FUbXlmYkYxOGlSTGdJX3hvNXZfdTViM0ZYTlJzUHR5dU8xYUFHMVpydlF2WlFTQQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4bbcf464010e650f","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-12T07:20:38.783559+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTFBGV2VaRkx1Q2lId1ZBVzBrQjE3VDRwZU5jWGVLUlJQNDlWbmdvaFFaN0ZRdkJEZXhIRXVWUmtxdmZsZWZ5em9GdDg3V0xwS2FUbXlmYkYxOGlSTGdJX3hvNXZfdTViM0ZYTlJzUHR5dU8xYUFHMVpydlF2WlFTQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"uk.finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTFBGV2VaRkx1Q2lId1ZBVzBrQjE3VDRwZU5jWGVLUlJQNDlWbmdvaFFaN0ZRdkJEZXhIRXVWUmtxdmZsZWZ5em9GdDg3V0xwS2FUbXlmYkYxOGlSTGdJX3hvNXZfdTViM0ZYTlJzUHR5dU8xYUFHMVpydlF2WlFTQQ?oc=5","source_event_id":"evt_8b39ab397847","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"2f82d10f3427ac67","published_at":"2026-04-12T06:42:00+00:00","publisher_domain":"uk.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Yahoo Finance UK","relevance":"high","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The two recommended FTSE 100 stocks are not named in the provided text.","No ticker symbols are provided.","No details on the experts, their rationale, or the criteria used are included.","No near-term catalyst timing (e.g., dates/events) is provided beyond the phrase \u201cbefore the next bull market.\u201d","No article body text is available to verify or expand on the headline claim."],"key_facts":["Headline states there are \u201c2 superb FTSE 100 stocks to buy before the next bull market, according to experts!\u201d","No specific stock names or ticker symbols are included in the provided text."],"numeric_claims":[],"primary_claim":"Yahoo Finance UK reports that experts recommend two FTSE 100 stocks to buy before the next bull market.","relevance_score":0.35,"sentiment":"positive","source_quality":"unknown","summary":"The Yahoo Finance UK headline claims that experts have identified two FTSE 100 stocks to buy before the next bull market. No stock names, tickers, or timing details are provided in the supplied text.","topics":["FTSE 100","stock picking","bull market","expert recommendations"]},"source":"Yahoo Finance UK","source_domain":"uk.finance.yahoo.com","source_url":"https://uk.finance.yahoo.com","summary":"2 superb FTSE 100 stocks to buy before the next bull market, according to experts! Yahoo Finance UK","title":"2 superb FTSE 100 stocks to buy before the next bull market, according to experts! - Yahoo Finance UK","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 28065 in events