SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_9794fd1adb4e in signals