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/CBMigwFBVV95cUxQbmF1V09pY2hDRUtVWWpFdFRjTmx6d0pGYmRDNGptWUtTYWE4T1YwOUJzLTNvU1VnR3ZsYmQ4YTktUEZ2SkdhbzBRalVtQWRDTjVKUUkzdEVaSC1NbE9aRmZCWEVJOUNyNkEyTmd2SU93WDd0d21yRHVFMnZYVl9EalJEdw?oc=5","as_of":"2026-04-10T18:45:21.202216+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/CBMigwFBVV95cUxQbmF1V09pY2hDRUtVWWpFdFRjTmx6d0pGYmRDNGptWUtTYWE4T1YwOUJzLTNvU1VnR3ZsYmQ4YTktUEZ2SkdhbzBRalVtQWRDTjVKUUkzdEVaSC1NbE9aRmZCWEVJOUNyNkEyTmd2SU93WDd0d21yRHVFMnZYVl9EalJEdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4d78a04e68299908","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-10T18:48:00.896363+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQbmF1V09pY2hDRUtVWWpFdFRjTmx6d0pGYmRDNGptWUtTYWE4T1YwOUJzLTNvU1VnR3ZsYmQ4YTktUEZ2SkdhbzBRalVtQWRDTjVKUUkzdEVaSC1NbE9aRmZCWEVJOUNyNkEyTmd2SU93WDd0d21yRHVFMnZYVl9EalJEdw?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/CBMigwFBVV95cUxQbmF1V09pY2hDRUtVWWpFdFRjTmx6d0pGYmRDNGptWUtTYWE4T1YwOUJzLTNvU1VnR3ZsYmQ4YTktUEZ2SkdhbzBRalVtQWRDTjVKUUkzdEVaSC1NbE9aRmZCWEVJOUNyNkEyTmd2SU93WDd0d21yRHVFMnZYVl9EalJEdw?oc=5","source_event_id":"evt_bbf6c97b817d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a39ec66c38b1617c","published_at":"2026-04-10T14:11:33+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"macro/consumer","name":"United States consumers","relevance":"directly affected by the sentiment decline","symbol":"","type":"group"},{"asset_class":"geopolitical","name":"Iran","relevance":"conflict source cited as driving inflation fears","symbol":"","type":"country"},{"asset_class":"media","name":"CNN","relevance":"source of the headline signal","symbol":"","type":"publisher"}],"event_type":"macro_policy","information_gaps":["The exact Michigan survey date and the specific index value are not included in the provided text.","The mechanism/quantification of how the Iran war is \u201cjacking up\u201d inflation is not detailed in the provided signal.","Whether the record low is for the overall index or a specific subcomponent is not specified.","No forward-looking timing (e.g., next CPI release) is provided beyond the implied immediacy of the survey reading."],"key_facts":["CNN headline states consumer sentiment has plummeted to a record low.","The headline attributes the sentiment decline to the Iran war increasing inflation.","Other referenced outlets (in the provided source summary) also cite a record-low consumer sentiment reading from a Michigan survey and rising inflation fears tied to the Iran war."],"numeric_claims":[{"label":"consumer sentiment level","value":"record low (exact index value not provided in the signal text)"}],"primary_claim":"Consumer sentiment in the U.S. has dropped to a record low as the Iran war increases inflation fears.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Multiple outlets report that U.S. consumer sentiment has fallen to a record low, with inflation fears rising in connection with the Iran war. The near-term catalyst implied is the latest Michigan consumer sentiment reading and the ongoing inflation narrative tied to the conflict.","topics":["consumer sentiment","inflation fears","Iran war","Michigan survey","macroeconomic outlook"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Consumer sentiment plummets to record low as Iran war jacks up inflation CNN Consumer sentiment hits record low, inflation fears rise amid Iran war CNBC Americans Feel Worse About the Economy Than Ever Before Business Insider Consumer Sentiment Hits Record Low, Michigan Survey Shows WSJ Iran War Hits US Economy With More Inflation, Record-Low Sentiment Bloomberg.com","title":"Consumer sentiment plummets to record low as Iran war jacks up inflation - 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_d4075173f7be in signals