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/CBMirAFBVV95cUxQVW9DTkR5WEtndkN0Vkhnb3pBbTZFandNa3BOaWptUTJoblBXcGFtSXRfYVNNbFVsSUo0NE1XWGoxVjRWbU85X0RYc0V5TE1DMGVfQWFPZGNIWGV0NlBfYmZUYlVBaTNaTjV6OGkyd1B5YnBua0FmUjU3V05hOXhsOERTSWttT1RvSm16MXlQSE0tN29sRzFWZmtNZTYyeUR0SzVwQzFzWDgzZ0Rq?oc=5","as_of":"2026-04-09T16:31:19.554433+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/CBMirAFBVV95cUxQVW9DTkR5WEtndkN0Vkhnb3pBbTZFandNa3BOaWptUTJoblBXcGFtSXRfYVNNbFVsSUo0NE1XWGoxVjRWbU85X0RYc0V5TE1DMGVfQWFPZGNIWGV0NlBfYmZUYlVBaTNaTjV6OGkyd1B5YnBua0FmUjU3V05hOXhsOERTSWttT1RvSm16MXlQSE0tN29sRzFWZmtNZTYyeUR0SzVwQzFzWDgzZ0Rq?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fa1c27170dc5eecc","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:57:04.312541+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQVW9DTkR5WEtndkN0Vkhnb3pBbTZFandNa3BOaWptUTJoblBXcGFtSXRfYVNNbFVsSUo0NE1XWGoxVjRWbU85X0RYc0V5TE1DMGVfQWFPZGNIWGV0NlBfYmZUYlVBaTNaTjV6OGkyd1B5YnBua0FmUjU3V05hOXhsOERTSWttT1RvSm16MXlQSE0tN29sRzFWZmtNZTYyeUR0SzVwQzFzWDgzZ0Rq?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQVW9DTkR5WEtndkN0Vkhnb3pBbTZFandNa3BOaWptUTJoblBXcGFtSXRfYVNNbFVsSUo0NE1XWGoxVjRWbU85X0RYc0V5TE1DMGVfQWFPZGNIWGV0NlBfYmZUYlVBaTNaTjV6OGkyd1B5YnBua0FmUjU3V05hOXhsOERTSWttT1RvSm16MXlQSE0tN29sRzFWZmtNZTYyeUR0SzVwQzFzWDgzZ0Rq?oc=5","source_event_id":"evt_d6dc308e5e4e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"04c73bc717f4fb0d","published_at":"2026-04-09T16:02:12+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["April 8, 2026"],"entities":[{"asset_class":"other","name":"The Washington Post","relevance":"high","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"D.C. area (Washington, D.C. metropolitan area)","relevance":"high","symbol":"","type":"geography"},{"asset_class":"other","name":"Snowcrete","relevance":"medium","symbol":"","type":"company_or_product"},{"asset_class":"other","name":"Iran war","relevance":"medium","symbol":"","type":"geopolitical_event"},{"asset_class":"other","name":"Americans (homebuyers)","relevance":"medium","symbol":"","type":"population"}],"event_type":"macro_policy","information_gaps":["The cleaned article text provided is not the actual article content (it appears to be page styling/HTML), so specific details (e.g., what \u201cSnowcrete\u201d is, the mechanism, and magnitude of impact) are not verifiable from the supplied text.","The prompt\u2019s \u201cSource Summary\u201d includes additional references (CNN/Yahoo/CBS) but does not provide their full claims; only the headline-level linkage to war uncertainty is directly grounded.","No specific mortgage-rate figures, home-price changes, or transaction-volume data are included in the provided text."],"key_facts":["The Washington Post headline states that \u201cSnowcrete\u201d and war uncertainty affect the D.C. area\u2019s home-buying season.","The provided source summary links Iran-war-related uncertainty to higher costs for Americans and mortgage-rate volatility (context from other cited items in the prompt)."],"numeric_claims":[],"primary_claim":"War uncertainty is affecting the D.C. area\u2019s home-buying season, alongside \u201cSnowcrete.\u201d","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that \u201cSnowcrete\u201d and broader war-related uncertainty are weighing on the D.C. area\u2019s home-buying season. The near-term effect is likely reduced buyer activity as costs and financing conditions become less predictable.","topics":["housing market","home-buying season","mortgage rates","geopolitical risk","Iran war","consumer affordability"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"\u2018Snowcrete,\u2019 war uncertainty affect the D.C. area\u2019s home-buying season The Washington Post The Iran war is making life more expensive for Americans CNN Mortgage rates fall on Iran ceasefire: Mortgage and refinance interest rates today Yahoo Finance Mortgage Rates Little-Changed But Volatility Could Return Quickly Mortgage News Daily What are today's mortgage interest rates: April 8, 2026? CBS News","title":"\u2018Snowcrete,\u2019 war uncertainty affect the D.C. area\u2019s home-buying season - The Washington Post","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_df1ea516ac8f in signals