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-09T07:33:13.652024+00:00","dedupe_key":"signal_enriched:news_delta:4853666de6f32a6b","evidence_event_ids":["evt_44adf38f693a"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxPNFlYNU1RRTJjVE4zZTRkY0k2QTdiOER3YlV1NmF4T0JKMWgwM3BQcFBacE1ZZEpNX202eDZ6azhiM2h3dlY0aHFhUXFhSEFMdFlSanE5SFVraE5GUUFUMzI2R2NmcV9CUFE2R3FJT3JTMVJDbVh1LTRpTkJ4eUoyd213U0RKekR4RWZ5Q1VlZk1wZWtVTnZSWUZxd3lCUQ?oc=5","as_of":"2026-04-09T07:33:13.652024+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/CBMingFBVV95cUxPNFlYNU1RRTJjVE4zZTRkY0k2QTdiOER3YlV1NmF4T0JKMWgwM3BQcFBacE1ZZEpNX202eDZ6azhiM2h3dlY0aHFhUXFhSEFMdFlSanE5SFVraE5GUUFUMzI2R2NmcV9CUFE2R3FJT3JTMVJDbVh1LTRpTkJ4eUoyd213U0RKekR4RWZ5Q1VlZk1wZWtVTnZSWUZxd3lCUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e53c144b68b9f0de","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-09T22:51:33.888943+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxPNFlYNU1RRTJjVE4zZTRkY0k2QTdiOER3YlV1NmF4T0JKMWgwM3BQcFBacE1ZZEpNX202eDZ6azhiM2h3dlY0aHFhUXFhSEFMdFlSanE5SFVraE5GUUFUMzI2R2NmcV9CUFE2R3FJT3JTMVJDbVh1LTRpTkJ4eUoyd213U0RKekR4RWZ5Q1VlZk1wZWtVTnZSWUZxd3lCUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxPNFlYNU1RRTJjVE4zZTRkY0k2QTdiOER3YlV1NmF4T0JKMWgwM3BQcFBacE1ZZEpNX202eDZ6azhiM2h3dlY0aHFhUXFhSEFMdFlSanE5SFVraE5GUUFUMzI2R2NmcV9CUFE2R3FJT3JTMVJDbVh1LTRpTkJ4eUoyd213U0RKekR4RWZ5Q1VlZk1wZWtVTnZSWUZxd3lCUQ?oc=5","source_event_id":"evt_44adf38f693a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ffe1aa859f076503","published_at":"2026-04-08T23:12:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"Reuters","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the Reuters article\u2019s substantive content.","No specific details are provided about what the \u201cabrupt Iran reversal\u201d consisted of (e.g., policy action, date, or decision).","No concrete outcomes, timelines, or affected agreements are stated in the provided text beyond the general claim about leverage limits.","The provided additional headline snippets from other outlets are not fully attributable to Reuters and are not detailed enough to extract specific facts."],"key_facts":["The Reuters headline states that Trump\u2019s abrupt Iran reversal exposes limits of his leverage.","The Reuters framing indicates that the U.S. has not won in Iran (as reflected by the provided additional headline snippets)."],"numeric_claims":[],"primary_claim":"Trump\u2019s abrupt Iran reversal demonstrates the limits of his leverage, suggesting the U.S. has not achieved its aims in Iran.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports that Trump\u2019s abrupt reversal on Iran highlights constraints on his ability to achieve desired outcomes, implying limited leverage. The headline frames the development as a setback in terms of what the U.S. has been able to secure in Iran.","topics":["Iran","U.S.-Iran relations","diplomacy","leverage","policy reversal","geopolitics"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Trump's abrupt Iran reversal exposes limits of his leverage Reuters \u2018Seems like losing\u2019: What the US hasn\u2019t won in Iran Politico Has Trump Met His War Goals in Iran? The New York Times Did America lose yet another war? Al Jazeera A U.S.-Iran Ceasefire Is Here, but Trump\u2019s Stone Age Mentality Endures The New Yorker","title":"Trump's abrupt Iran reversal exposes limits of his leverage - Reuters","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 9308 in events