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-10T19:36:11.808933+00:00","dedupe_key":"signal_enriched:news_delta:f584ed5dbb2dc8a3","evidence_event_ids":["evt_7d81a18547e6"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxPRzkydjdxU2Y3SzV5M2JIX05ieWtBeXJ0X0wycmVvRHlOSVJHUVlJZWVkWGE0ZUZWc3p0dENJYlE3b0xhekRfVXJnTVByR1NHNXF2cm9fb0VuT3VqdDR0Y2Vmb3ZGMEdqUUppaUhCZTlrdDJHSXBDNlV4SURpWWYtcncwbnFtQQ?oc=5","as_of":"2026-04-10T19:36:11.808933+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/CBMihgFBVV95cUxPRzkydjdxU2Y3SzV5M2JIX05ieWtBeXJ0X0wycmVvRHlOSVJHUVlJZWVkWGE0ZUZWc3p0dENJYlE3b0xhekRfVXJnTVByR1NHNXF2cm9fb0VuT3VqdDR0Y2Vmb3ZGMEdqUUppaUhCZTlrdDJHSXBDNlV4SURpWWYtcncwbnFtQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3089360d96a1a5ba","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-10T20:00:05.781101+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxPRzkydjdxU2Y3SzV5M2JIX05ieWtBeXJ0X0wycmVvRHlOSVJHUVlJZWVkWGE0ZUZWc3p0dENJYlE3b0xhekRfVXJnTVByR1NHNXF2cm9fb0VuT3VqdDR0Y2Vmb3ZGMEdqUUppaUhCZTlrdDJHSXBDNlV4SURpWWYtcncwbnFtQQ?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/CBMihgFBVV95cUxPRzkydjdxU2Y3SzV5M2JIX05ieWtBeXJ0X0wycmVvRHlOSVJHUVlJZWVkWGE0ZUZWc3p0dENJYlE3b0xhekRfVXJnTVByR1NHNXF2cm9fb0VuT3VqdDR0Y2Vmb3ZGMEdqUUppaUhCZTlrdDJHSXBDNlV4SURpWWYtcncwbnFtQQ?oc=5","source_event_id":"evt_7d81a18547e6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bce2cb8aa6b508f6","published_at":"2026-04-10T18:46:44+00:00","publisher_domain":"uk.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["This Week"],"entities":[{"asset_class":"","name":"Yahoo Finance UK","relevance":"source of the headline/article","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The three specific stocks (company names and tickers) are not present in the provided text.","The article\u2019s rationale (valuation, earnings, guidance, technicals, catalysts) is not present.","No timing details beyond \u201cThis Week\u201d are provided.","No market/sector context or risk factors are provided."],"key_facts":["Headline states: \u201c3 Market-Beating Stocks to Target This Week - Yahoo Finance UK.\u201d","Source summary repeats the same headline text.","No company names, tickers, or performance/catalyst details are included in the provided text."],"numeric_claims":[],"primary_claim":"Yahoo Finance UK published an article titled \u201c3 Market-Beating Stocks to Target This Week.\u201d","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The Yahoo Finance UK headline promotes an article listing three stocks described as \u201cmarket-beating\u201d to target during the current week. No specific stock tickers or catalysts are provided in the provided text.","topics":["stock picking","equities","market-beating stocks","weekly trading idea"]},"source":"Yahoo Finance UK","source_domain":"uk.finance.yahoo.com","source_url":"https://uk.finance.yahoo.com","summary":"3 Market-Beating Stocks to Target This Week Yahoo Finance UK","title":"3 Market-Beating Stocks to Target This Week - 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 19242 in events