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-09T18:00:22.019871+00:00","dedupe_key":"signal_enriched:news_delta:c43ae838976d625d","evidence_event_ids":["evt_5a125d305437"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE5VVVJleFVJZXFSVm15bG5YaU80ZmlhSkU3RE1qeGdCMWtOZVJGNVZURnIyMm5lLWpQN1ppc21YdWk5T1B6aWxiaXRuUkFFdW1WMWNfNGV5MnMtWmp5bEdaSFZjdUMxRnJmMFZjUGhsdVM5MnRlMHMwMQ?oc=5","as_of":"2026-04-09T18:00:22.019871+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/CBMieEFVX3lxTE5VVVJleFVJZXFSVm15bG5YaU80ZmlhSkU3RE1qeGdCMWtOZVJGNVZURnIyMm5lLWpQN1ppc21YdWk5T1B6aWxiaXRuUkFFdW1WMWNfNGV5MnMtWmp5bEdaSFZjdUMxRnJmMFZjUGhsdVM5MnRlMHMwMQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ff883c80e917f0f3","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:12:06.925036+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE5VVVJleFVJZXFSVm15bG5YaU80ZmlhSkU3RE1qeGdCMWtOZVJGNVZURnIyMm5lLWpQN1ppc21YdWk5T1B6aWxiaXRuUkFFdW1WMWNfNGV5MnMtWmp5bEdaSFZjdUMxRnJmMFZjUGhsdVM5MnRlMHMwMQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE5VVVJleFVJZXFSVm15bG5YaU80ZmlhSkU3RE1qeGdCMWtOZVJGNVZURnIyMm5lLWpQN1ppc21YdWk5T1B6aWxiaXRuUkFFdW1WMWNfNGV5MnMtWmp5bEdaSFZjdUMxRnJmMFZjUGhsdVM5MnRlMHMwMQ?oc=5","source_event_id":"evt_5a125d305437","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"da4252ae896ae0bb","published_at":"2026-04-09T16:00:54+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"households","name":"United States (Americans)","relevance":"high","symbol":"","type":"population/market"},{"asset_class":"media","name":"CNN","relevance":"medium","symbol":"","type":"media outlet"}],"event_type":"geopolitical_risk","information_gaps":["Specific channels linking the Iran war to higher American costs are not provided (e.g., energy prices, shipping, sanctions, risk premia).","No quantitative magnitude (percent/$/month) or timeframe for the cost increase is included.","The excerpted article text appears to be largely HTML/CSS and does not contain the substantive CNN content needed to extract grounded details beyond the headline.","Near-term catalyst timing (when costs change) is not specified in the provided material."],"key_facts":["CNN headline states that the Iran war is making life more expensive for Americans.","No additional concrete details (e.g., specific price categories, dollar amounts, or causal channels) are present in the provided text."],"numeric_claims":[],"primary_claim":"The Iran war is making life more expensive for Americans, according to CNN.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"CNN reports that the Iran war is increasing the cost of living for Americans. The provided material does not include specific mechanisms or quantified impacts.","topics":["cost of living","inflation","geopolitical risk","Iran war","U.S. households"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"The Iran war is making life more expensive for Americans CNN Mortgage rates fall for first time in weeks after US-Iran ceasefire Fox Business Mortgage rates fall on Iran ceasefire: Mortgage and refinance interest rates today Yahoo Finance \u2018Snowcrete,\u2019 war uncertainty affect the D.C. area\u2019s home-buying season The Washington Post What are today's mortgage interest rates: April 8, 2026? CBS News","title":"The Iran war is making life more expensive for Americans - CNN","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 10946 in events