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-09T13:30:32.934071+00:00","dedupe_key":"signal_enriched:news_delta:e47012ec1784bf31","evidence_event_ids":["evt_898a585bc347"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxOOGhfclpyNUNVVkRzeUcxaElZcS12d01LMjFVVm45MVZ3c3RRa3VFMUZxcVFER2YwQU9TTmZMVXU4QnhoLWQxa3o1bjloREpVT1FRbkFIT2Z4YkZLNl8yVXdsMTlXRXhXU19MWGg2bWdqNzBMWkZva0ozbDN0WUJRMnNUeDA5MG9yQUZOVjZ6Qm9WV2hzRWNueHhxVkM2MGFaaHptaEpOeGZ3bXFp?oc=5","as_of":"2026-04-09T13:30:32.934071+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/CBMirAFBVV95cUxOOGhfclpyNUNVVkRzeUcxaElZcS12d01LMjFVVm45MVZ3c3RRa3VFMUZxcVFER2YwQU9TTmZMVXU4QnhoLWQxa3o1bjloREpVT1FRbkFIT2Z4YkZLNl8yVXdsMTlXRXhXU19MWGg2bWdqNzBMWkZva0ozbDN0WUJRMnNUeDA5MG9yQUZOVjZ6Qm9WV2hzRWNueHhxVkM2MGFaaHptaEpOeGZ3bXFp?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6a28bedca198ac04","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:29:47.728123+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxOOGhfclpyNUNVVkRzeUcxaElZcS12d01LMjFVVm45MVZ3c3RRa3VFMUZxcVFER2YwQU9TTmZMVXU4QnhoLWQxa3o1bjloREpVT1FRbkFIT2Z4YkZLNl8yVXdsMTlXRXhXU19MWGg2bWdqNzBMWkZva0ozbDN0WUJRMnNUeDA5MG9yQUZOVjZ6Qm9WV2hzRWNueHhxVkM2MGFaaHptaEpOeGZ3bXFp?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"zacks.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxOOGhfclpyNUNVVkRzeUcxaElZcS12d01LMjFVVm45MVZ3c3RRa3VFMUZxcVFER2YwQU9TTmZMVXU4QnhoLWQxa3o1bjloREpVT1FRbkFIT2Z4YkZLNl8yVXdsMTlXRXhXU19MWGg2bWdqNzBMWkZva0ozbDN0WUJRMnNUeDA5MG9yQUZOVjZ6Qm9WV2hzRWNueHhxVkM2MGFaaHptaEpOeGZ3bXFp?oc=5","source_event_id":"evt_898a585bc347","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a3a97b7457ed9db0","published_at":"2026-04-09T11:31:11+00:00","publisher_domain":"zacks.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["Q1 (year not specified)"],"entities":[{"asset_class":"equity","name":"JPMorgan Chase & Co.","relevance":"primary subject of the headline","symbol":"JPM","type":"company"},{"asset_class":"unknown","name":"Zacks Investment Research","relevance":"source of the headline","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["No Q1 earnings date/year is provided.","No specific recommendation conclusion (e.g., rating/target price) is included in the provided text.","No details are provided on what aspects of the geopolitical backdrop are relevant.","No supporting metrics (guidance, estimates, valuation, risks) are included in the provided text."],"key_facts":["Headline asks: \u201cIs JPM a Buy Before Q1 Earnings in a Volatile Geopolitical Backdrop?\u201d","Source summary repeats the same question/title."],"numeric_claims":[],"primary_claim":"Zacks Investment Research asks whether JPM is a buy before Q1 earnings amid a volatile geopolitical backdrop.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"Zacks Investment Research frames JPM as a potential \u201cbuy\u201d decision to consider ahead of Q1 earnings, citing a volatile geopolitical backdrop. The provided text contains only the headline and source summary, with no additional details on JPM\u2019s fundamentals or timing specifics.","topics":["earnings","investment recommendation","geopolitical risk","market volatility"]},"source":"Zacks Investment Research","source_domain":"zacks.com","source_url":"https://www.zacks.com","summary":"Is JPM a Buy Before Q1 Earnings in a Volatile Geopolitical Backdrop? Zacks Investment Research","title":"Is JPM a Buy Before Q1 Earnings in a Volatile Geopolitical Backdrop? - Zacks Investment Research","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 10091 in events