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/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?oc=5","as_of":"2026-04-07T23:23:37.620606+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/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_82318ffeae4c039b","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-08T00:31:25.935487+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?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/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?oc=5","source_event_id":"evt_3e425a9d5720","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5fa58bfcb4c1d34b","published_at":"2026-04-07T22:39:44+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"The Washington Post","relevance":"medium","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/CSS and does not include the actual article body, so details beyond the headline and the supplied source summary cannot be verified from the text here.","No specific deadline dates, deal terms, or the exact mechanism of the \u201cfreeze\u201d are included in the provided content.","No direct market/asset impact is stated in the provided text; only geopolitical risk framing is implied."],"key_facts":["The Washington Post headline states Trump said \u201ca whole civilization will die\u201d as Iran freezes talks.","The provided source summary indicates Trump\u2019s threat is described as shocking global leaders and unnerving some Republicans (attributed to Reuters in the summary).","The provided source summary indicates Trump is widening threats to Iran\u2019s power plants and bridges as a deadline for a deal approaches (attributed to AP in the summary).","The provided source summary indicates there is a timeline of Trump\u2019s escalating deadlines on Iran and the Strait of Hormuz (attributed to Fox News in the summary).","The provided source summary indicates CNN raises a question of whether Trump\u2019s threats are legal (as phrased in the summary)."],"numeric_claims":[],"primary_claim":"Trump said that if Iran freezes talks, \u201ca whole civilization will die,\u201d and he is escalating threats as deadlines for an Iran deal approach.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that Trump said Iran\u2019s freeze of talks could lead to catastrophic consequences, warning that \u201ca whole civilization will die.\u201d The reporting frames this as part of Trump\u2019s escalating deadlines and threats tied to a potential deal and to Iran\u2019s infrastructure.","topics":["Iran nuclear talks","diplomatic negotiations","escalating threats","deadline-driven diplomacy","Strait of Hormuz","Iran power plants and bridges"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Trump says \u2018a whole civilization will die\u2019 as Iran freezes talks The Washington Post Trump's threat to Iran shocks global leaders, unnerves some Republicans Reuters A timeline of Trump\u2019s escalating deadlines on Iran and the Strait of Hormuz Fox News Trump widens threat to all of Iran's power plants and bridges as his deadline for a deal approaches AP News Is that legal? Trump threatens bridges, power plants and a \u2018whole civilization\u2019 CNN","title":"Trump says \u2018a whole civilization will die\u2019 as Iran freezes talks - 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_96a9d01962a0 in signals