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-08T19:34:44.218787+00:00","dedupe_key":"signal_enriched:market_headline_delta:1f2e5ac6ab699d8c","evidence_event_ids":["evt_e96936e100c2"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?oc=5","as_of":"2026-04-08T19:34:44.218787+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/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3112a2dfdce13c5b","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-09T20:03:34.707188+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?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/CBMilwFBVV95cUxPMzRZU2NZajV5dmdoTlpXLVBoUkt6Vy1DR0hLd0lTLUdsZ3J2MkRwNlBWc1RGVmp6Nnc4QW96SFdmeHV4WEg4V0JRVC1wcVo3RjVzTUpxODVURnJBWHdySjByaXRpSEFvbXdrUk1VTGxGUzR4dFV3TDEtaGhvenpMM25EQWZEWEZUM216ejcxaE1pZ3FmTm1R?oc=5","source_event_id":"evt_e96936e100c2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a03cf73080c9594c","published_at":"2026-04-08T05:06:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Colgate-Palmolive","relevance":"high","symbol":"CL","type":"company"}],"event_type":"other","information_gaps":["No article body text was provided, so the criteria for \u201clow volatility\u201d and \u201cblue chip\u201d and any supporting metrics (e.g., volatility measure, time horizon, valuation) are unknown.","No information is provided about whether this is a new inclusion, an update, or a reprint of an existing list.","No market impact details (e.g., price reaction, analyst rating changes) are included in the provided text."],"key_facts":["Headline: \u201cColgate-Palmolive (CL) \u2013 One of the 15 Best Low Volatility Blue Chip Stocks to Buy Now - Yahoo Finance.\u201d","The headline explicitly associates CL with a list of 15 low-volatility blue-chip stocks to buy now."],"numeric_claims":[{"label":"List size","value":"15"}],"primary_claim":"Colgate-Palmolive (CL) is one of the 15 best low-volatility blue-chip stocks to buy now, per Yahoo Finance.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"Yahoo Finance headline states that Colgate-Palmolive (CL) is included among the \u201c15 Best Low Volatility Blue Chip Stocks to Buy Now.\u201d The claim implies a positive buy recommendation framed around low volatility.","topics":["stock picking","low volatility","blue chip","buy recommendation"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"","tickers":[],"title":"Colgate-Palmolive (CL) \u2013 One of the 15 Best Low Volatility Blue Chip Stocks to Buy Now - 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 7487 in events