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-08T00:10:40.896232+00:00","dedupe_key":"signal_enriched:news_delta:09fcb1c2e8bb3da2","evidence_event_ids":["evt_8db13545caa4"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxOY012VGhFTEViRGlURVlTYlJ4NnhpRTFsNV9Ia1lmdTBxM1BhNktQUjhtekdDeTNqekZmYzA5eGxabF9mR3l1V0R2THNsOXpnZFlxOEtjN3VIdHBFQ1ltallBWWE4Mnd6OTQ5bFJpS0xVQjk0ZXJhZHdHTUdEdW11aEZualEtYnlXSWRRd21IRWhMRjNQT3AzRFVpT3l0djA3WnBDd1J0Yw?oc=5","as_of":"2026-04-08T00:10:40.896232+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/CBMipwFBVV95cUxOY012VGhFTEViRGlURVlTYlJ4NnhpRTFsNV9Ia1lmdTBxM1BhNktQUjhtekdDeTNqekZmYzA5eGxabF9mR3l1V0R2THNsOXpnZFlxOEtjN3VIdHBFQ1ltallBWWE4Mnd6OTQ5bFJpS0xVQjk0ZXJhZHdHTUdEdW11aEZualEtYnlXSWRRd21IRWhMRjNQT3AzRFVpT3l0djA3WnBDd1J0Yw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_45f10435ac6b3109","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-08T00:42:16.599379+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxOY012VGhFTEViRGlURVlTYlJ4NnhpRTFsNV9Ia1lmdTBxM1BhNktQUjhtekdDeTNqekZmYzA5eGxabF9mR3l1V0R2THNsOXpnZFlxOEtjN3VIdHBFQ1ltallBWWE4Mnd6OTQ5bFJpS0xVQjk0ZXJhZHdHTUdEdW11aEZualEtYnlXSWRRd21IRWhMRjNQT3AzRFVpT3l0djA3WnBDd1J0Yw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketwatch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxOY012VGhFTEViRGlURVlTYlJ4NnhpRTFsNV9Ia1lmdTBxM1BhNktQUjhtekdDeTNqekZmYzA5eGxabF9mR3l1V0R2THNsOXpnZFlxOEtjN3VIdHBFQ1ltallBWWE4Mnd6OTQ5bFJpS0xVQjk0ZXJhZHdHTUdEdW11aEZualEtYnlXSWRRd21IRWhMRjNQT3AzRFVpT3l0djA3WnBDd1J0Yw?oc=5","source_event_id":"evt_8db13545caa4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"655d90b7acc5090f","published_at":"2026-04-07T18:54:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"MarketWatch","relevance":"source of the signal","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The specific 15 stocks (names/tickers) are not present in the provided text.","No details are provided on the criteria for selection, valuation metrics, sectors, or risk factors.","No timing specifics for \u201cwhen the market recovers\u201d are included in the provided text.","No performance expectations or price targets are included in the provided text."],"key_facts":["The headline states: \u201c15 stocks to put on your list to buy when the market recovers.\u201d","The source is MarketWatch (marketwatch.com).","The article is framed as a list of 15 stocks intended for buying when the market recovers."],"numeric_claims":[{"label":"number_of_stocks","value":"15"}],"primary_claim":"MarketWatch\u2019s article titled \u201c15 stocks to put on your list to buy when the market recovers\u201d presents 15 stock picks for a future market-recovery buying opportunity.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"MarketWatch published a list article recommending 15 stocks to buy when the market recovers.","topics":["stock-picking","market recovery","investment recommendations"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"15 stocks to put on your list to buy when the market recovers MarketWatch","title":"15 stocks to put on your list to buy when the market recovers - MarketWatch","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 2460 in events