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-09T15:51:37.564125+00:00","dedupe_key":"signal_enriched:news_delta:a58b17402c0cb195","evidence_event_ids":["evt_b5e73a097cff"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxPSW9IZmRMNnhGZEJ3RjJzS2lIck9KNFV2aVJ1UUxwNEx3ZmJQMzhDYzg0MXBSamFmV3BwZDJNWWluVmVaRXJGUjhPM1JFcWJoUlVQaW9YMWZtR2RpVUQ1UXNnODNGMWNOM2pJS2dZYV80bGJFOWZhbmFkNGpLa3pFd01jV05JM3hqR1N6VUxYeE5Mb19wZkl3Wjd4dEo1YUZEZ2xkbHZHOWk?oc=5","as_of":"2026-04-09T15:51:37.564125+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/CBMiqAFBVV95cUxPSW9IZmRMNnhGZEJ3RjJzS2lIck9KNFV2aVJ1UUxwNEx3ZmJQMzhDYzg0MXBSamFmV3BwZDJNWWluVmVaRXJGUjhPM1JFcWJoUlVQaW9YMWZtR2RpVUQ1UXNnODNGMWNOM2pJS2dZYV80bGJFOWZhbmFkNGpLa3pFd01jV05JM3hqR1N6VUxYeE5Mb19wZkl3Wjd4dEo1YUZEZ2xkbHZHOWk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a3e54ec49b5bb2f7","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-09T23:44:09.219187+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxPSW9IZmRMNnhGZEJ3RjJzS2lIck9KNFV2aVJ1UUxwNEx3ZmJQMzhDYzg0MXBSamFmV3BwZDJNWWluVmVaRXJGUjhPM1JFcWJoUlVQaW9YMWZtR2RpVUQ1UXNnODNGMWNOM2pJS2dZYV80bGJFOWZhbmFkNGpLa3pFd01jV05JM3hqR1N6VUxYeE5Mb19wZkl3Wjd4dEo1YUZEZ2xkbHZHOWk?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/CBMiqAFBVV95cUxPSW9IZmRMNnhGZEJ3RjJzS2lIck9KNFV2aVJ1UUxwNEx3ZmJQMzhDYzg0MXBSamFmV3BwZDJNWWluVmVaRXJGUjhPM1JFcWJoUlVQaW9YMWZtR2RpVUQ1UXNnODNGMWNOM2pJS2dZYV80bGJFOWZhbmFkNGpLa3pFd01jV05JM3hqR1N6VUxYeE5Mb19wZkl3Wjd4dEo1YUZEZ2xkbHZHOWk?oc=5","source_event_id":"evt_b5e73a097cff","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3b8deab97a694da6","published_at":"2026-04-09T15:01:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"MarketWatch","relevance":"high","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["Which specific bank stocks are mentioned is not provided.","No valuation metrics (e.g., P/E, P/B, price-to-book) or \u201cbargain\u201d criteria are included in the provided text.","No earnings dates or which earnings reports are being referenced are provided.","No directional performance expectations (beat/miss, guidance changes) are included in the provided text."],"key_facts":["The headline states the article is about \u201cbargain bank stocks\u201d heading into earnings season.","No specific bank tickers or company names are included in the provided text.","No timing details (dates of earnings) are provided in the provided text."],"numeric_claims":[],"primary_claim":"MarketWatch published an article about bargain bank stocks heading into earnings season.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"MarketWatch highlights \u201cbargain bank stocks\u201d that investors may consider heading into the upcoming earnings season. The signal does not name specific banks or provide performance/valuation details.","topics":["bank stocks","earnings season","valuation/bargains"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"Here are some bargain bank stocks heading into earnings season MarketWatch","title":"Here are some bargain bank stocks heading into earnings season - 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 10391 in events