SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T23:23:37.620606+00:00","dedupe_key":"signal_enriched:news_delta:b0fbc93c7c92a692","evidence_event_ids":["evt_3e425a9d5720"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 2185 in events