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/CBMi7gFBVV95cUxNU0FHeU1oY3hwczBYVDRUNFgwMlM5TTNPcEVZcENzal90V3pldDBpSTN3ZnpkNW1ReHpKSEQ4c1NrQW1FcGd2bnNWY1NueWpFd3E5TUhfYnF3QjJHSG91MUZPSUplenl0VUY0NDFYeVBhVW9SSTRTeDJwTS1Lc0doem55UkhNTm1FODNXSTZzdWN3a0l4eEt4NzJEclVIa0NsU0dEUHd1S09SS0VOYlYyVUU0Z3EzOGk4d251Yy1NOVd3NzFySFNvd2N0a0ZxY0lKVUpSRHNmMkVoaHF0TjRHRG1uQzJzWDUwTGgyOF9R?oc=5","as_of":"2026-04-09T17:20:48.126847+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/CBMi7gFBVV95cUxNU0FHeU1oY3hwczBYVDRUNFgwMlM5TTNPcEVZcENzal90V3pldDBpSTN3ZnpkNW1ReHpKSEQ4c1NrQW1FcGd2bnNWY1NueWpFd3E5TUhfYnF3QjJHSG91MUZPSUplenl0VUY0NDFYeVBhVW9SSTRTeDJwTS1Lc0doem55UkhNTm1FODNXSTZzdWN3a0l4eEt4NzJEclVIa0NsU0dEUHd1S09SS0VOYlYyVUU0Z3EzOGk4d251Yy1NOVd3NzFySFNvd2N0a0ZxY0lKVUpSRHNmMkVoaHF0TjRHRG1uQzJzWDUwTGgyOF9R?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b2346a551924c8f3","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:08:14.567940+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi7gFBVV95cUxNU0FHeU1oY3hwczBYVDRUNFgwMlM5TTNPcEVZcENzal90V3pldDBpSTN3ZnpkNW1ReHpKSEQ4c1NrQW1FcGd2bnNWY1NueWpFd3E5TUhfYnF3QjJHSG91MUZPSUplenl0VUY0NDFYeVBhVW9SSTRTeDJwTS1Lc0doem55UkhNTm1FODNXSTZzdWN3a0l4eEt4NzJEclVIa0NsU0dEUHd1S09SS0VOYlYyVUU0Z3EzOGk4d251Yy1NOVd3NzFySFNvd2N0a0ZxY0lKVUpSRHNmMkVoaHF0TjRHRG1uQzJzWDUwTGgyOF9R?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi7gFBVV95cUxNU0FHeU1oY3hwczBYVDRUNFgwMlM5TTNPcEVZcENzal90V3pldDBpSTN3ZnpkNW1ReHpKSEQ4c1NrQW1FcGd2bnNWY1NueWpFd3E5TUhfYnF3QjJHSG91MUZPSUplenl0VUY0NDFYeVBhVW9SSTRTeDJwTS1Lc0doem55UkhNTm1FODNXSTZzdWN3a0l4eEt4NzJEclVIa0NsU0dEUHd1S09SS0VOYlYyVUU0Z3EzOGk4d251Yy1NOVd3NzFySFNvd2N0a0ZxY0lKVUpSRHNmMkVoaHF0TjRHRG1uQzJzWDUwTGgyOF9R?oc=5","source_event_id":"evt_a9c52e47596f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4f2cdcafc9330360","published_at":"2026-04-09T16:00:22+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["April 8, 2026"],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"driver of geopolitical risk sentiment affecting rates","symbol":"","type":"country"},{"asset_class":"household_credit","name":"U.S. mortgage borrowers (homebuyers and refinancers)","relevance":"directly affected by changes in mortgage/refinance rates","symbol":"","type":"market participants"},{"asset_class":"rates","name":"Mortgage and refinance interest rates","relevance":"the measured variable that moved","symbol":"","type":"interest rate benchmark"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not include the actual rate figures or the specific magnitude of the rate change.","The exact timing/announcement time of the Iran ceasefire relative to the rate move is not specified in the provided content.","No specific mortgage product types (e.g., 30-year fixed, 15-year fixed, ARM) or their exact rate changes are present in the provided text.","The snippet about \u201cvolatility could return quickly\u201d is mentioned in the overall source summary but not substantiated with details in the provided article text."],"key_facts":["Headline states mortgage and refinance interest rates fell on an Iran ceasefire.","The signal is framed as a \u201ctoday\u201d rates update (near-term timing).","Other provided source snippets (CNN/Washington Post/Mortgage News Daily/CBS) suggest war uncertainty can affect home-buying conditions and that volatility could return quickly, but these are not fully detailed in the provided article text."],"numeric_claims":[],"primary_claim":"Mortgage and refinance interest rates fell on the day of an Iran ceasefire, according to Yahoo Finance\u2019s rate update.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Yahoo Finance reports that mortgage and refinance interest rates declined following an Iran ceasefire. The headline implies a near-term easing in borrowing costs for U.S. homebuyers, though volatility may still be a factor.","topics":["mortgage rates","refinance rates","Iran ceasefire","geopolitical risk","U.S. housing finance"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"Mortgage rates fall on Iran ceasefire: Mortgage and refinance interest rates today Yahoo Finance The Iran war is making life more expensive for Americans CNN \u2018Snowcrete,\u2019 war uncertainty affect the D.C. area\u2019s home-buying season The Washington Post 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":"Mortgage rates fall on Iran ceasefire: Mortgage and refinance interest rates today - Yahoo Finance","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_578623a35ae2 in signals