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-09T19:28:45.884426+00:00","dedupe_key":"signal_enriched:news_delta:de38771e67da379c","evidence_event_ids":["evt_b260a1c3ff15"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5","as_of":"2026-04-09T19:28:45.884426+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/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f7fbddb57a57bc6d","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-10T00:22:40.762426+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNdnBOU1ZPd2lzbDEtaFBjdzA0dXQ4LVlHSm05d09mbE9JMDd4dnliNjVXY2RaTVlRdmVQNFVSa1dLcGRKSTE4czBGUjE4R0MxMVFtVWNWUkNqYXB3OWFmdkNZQ2Vta0h2cnhFRnpVdm90a1BaYV91ZGZLZWROek5EZXVzMk13cG9QSjJaYzZ3?oc=5","source_event_id":"evt_b260a1c3ff15","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"289430414e3a3edf","published_at":"2026-04-09T18:07:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Alcoa","relevance":"high","symbol":"AA","type":"company"},{"asset_class":"equity_sector","name":"Aluminum stocks","relevance":"high","symbol":"","type":"sector"},{"asset_class":"geopolitical","name":"Iran war","relevance":"medium","symbol":"","type":"geopolitical event"}],"event_type":"geopolitical_risk","information_gaps":["No specific aluminum stock tickers are provided in the provided text.","No earnings date/time for Alcoa is provided.","No details are provided on why the Iran war is affecting aluminum stocks (e.g., supply, tariffs, risk premium).","No magnitude of breakout performance (percent move, timeframe) is provided."],"key_facts":["Headline states aluminum stocks are extending breakouts.","Headline links the breakout extension to the Iran war.","Headline states Alcoa earnings are due."],"numeric_claims":[],"primary_claim":"Aluminum stocks are extending breakouts amid the Iran war, and Alcoa earnings are due.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Investor's Business Daily reports that aluminum stocks are extending breakouts amid the Iran war, with Alcoa earnings due as a near-term catalyst.","topics":["aluminum stocks","breakouts","Iran war","Alcoa earnings","market catalyst"]},"source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Aluminum Stocks Extend Breakouts Amid Iran War. Alcoa Earnings Due. Investor's Business Daily","title":"Aluminum Stocks Extend Breakouts Amid Iran War. Alcoa Earnings Due. - Investor's Business Daily","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 11106 in events