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/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

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_906afae9dd7b in signals