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-11T15:52:30.158065+00:00","dedupe_key":"signal_enriched:news_delta:ba39f91f09568054","evidence_event_ids":["evt_96489e5ba00d"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOT0x6M2gxVnU4Z1c3QWlmN3NGUkRseW4yX0NEQnlJeC11V3VaYWtXV0tyTER0YTZuT1FIWEFmWkdlWG81dUJMS2Z4X3hIaGhuZndfR0lQZVNjb3RpUVVPbFdNbHM2T3VWZGlfSHkyaHF5M1VucHJ2WGtESHFRbEpwUzVCVXA4NkZFYUhndVlsemY?oc=5","as_of":"2026-04-11T15:52:30.158065+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/CBMikAFBVV95cUxOT0x6M2gxVnU4Z1c3QWlmN3NGUkRseW4yX0NEQnlJeC11V3VaYWtXV0tyTER0YTZuT1FIWEFmWkdlWG81dUJMS2Z4X3hIaGhuZndfR0lQZVNjb3RpUVVPbFdNbHM2T3VWZGlfSHkyaHF5M1VucHJ2WGtESHFRbEpwUzVCVXA4NkZFYUhndVlsemY?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_9ed65e8273962f1d","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-11T22:11:30.001057+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOT0x6M2gxVnU4Z1c3QWlmN3NGUkRseW4yX0NEQnlJeC11V3VaYWtXV0tyTER0YTZuT1FIWEFmWkdlWG81dUJMS2Z4X3hIaGhuZndfR0lQZVNjb3RpUVVPbFdNbHM2T3VWZGlfSHkyaHF5M1VucHJ2WGtESHFRbEpwUzVCVXA4NkZFYUhndVlsemY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOT0x6M2gxVnU4Z1c3QWlmN3NGUkRseW4yX0NEQnlJeC11V3VaYWtXV0tyTER0YTZuT1FIWEFmWkdlWG81dUJMS2Z4X3hIaGhuZndfR0lQZVNjb3RpUVVPbFdNbHM2T3VWZGlfSHkyaHF5M1VucHJ2WGtESHFRbEpwUzVCVXA4NkZFYUhndVlsemY?oc=5","source_event_id":"evt_96489e5ba00d","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"291e9b77d3859c93","published_at":"2026-04-11T15:15:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Two EV stocks (unspecified)","relevance":"high","symbol":"","type":"company"}],"event_type":"price_action","information_gaps":["The two EV stock names are not provided.","No ticker symbols are provided.","No performance metrics (price change, volume, valuation) are provided.","No timeframe or specific catalyst timing is provided.","No evidence from the article body is available beyond the headline/summary text."],"key_facts":["Yahoo Finance headline states that \u201cThese 2 EV Stocks Are Getting No Love Right Now.\u201d","The headline frames the situation as a \u201cBuying Opportunity.\u201d","No company names or ticker symbols are provided in the provided text."],"numeric_claims":[],"primary_claim":"Two EV stocks are \u201cgetting no love right now,\u201d and the headline suggests this could be a buying opportunity.","relevance_score":0.35,"sentiment":"mixed","source_quality":"unknown","summary":"The Yahoo Finance headline claims that two EV stocks are currently underperforming or unpopular with investors, framing it as a potential buying opportunity.","topics":["electric vehicles","stock sentiment","buying opportunity"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"These 2 EV Stocks Are Getting No Love Right Now, and That's a Buying Opportunity Yahoo Finance","title":"These 2 EV Stocks Are Getting No Love Right Now, and That's a Buying Opportunity - Yahoo Finance","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 25185 in events