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/CBMif0FVX3lxTE85dWJVUkk0RXlTTWIybkNIMTRHamRRSlV0cTY0eHRNVnlOSTJDRkdRZnlrN2VlVW5EZ2x2NFY2VGNCcTVnaWx2S05OLU1fS1YyOVpqTVozdkF4WHVoZXNMcjJEVmJGVV93VVdDN29JckRyZ0ZwTG5OOV9zaG1vb0U?oc=5","as_of":"2026-04-09T15:51:37.751447+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/CBMif0FVX3lxTE85dWJVUkk0RXlTTWIybkNIMTRHamRRSlV0cTY0eHRNVnlOSTJDRkdRZnlrN2VlVW5EZ2x2NFY2VGNCcTVnaWx2S05OLU1fS1YyOVpqTVozdkF4WHVoZXNMcjJEVmJGVV93VVdDN29JckRyZ0ZwTG5OOV9zaG1vb0U?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3149653d571cf5a1","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-09T23:44:51.443736+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE85dWJVUkk0RXlTTWIybkNIMTRHamRRSlV0cTY0eHRNVnlOSTJDRkdRZnlrN2VlVW5EZ2x2NFY2VGNCcTVnaWx2S05OLU1fS1YyOVpqTVozdkF4WHVoZXNMcjJEVmJGVV93VVdDN29JckRyZ0ZwTG5OOV9zaG1vb0U?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE85dWJVUkk0RXlTTWIybkNIMTRHamRRSlV0cTY0eHRNVnlOSTJDRkdRZnlrN2VlVW5EZ2x2NFY2VGNCcTVnaWx2S05OLU1fS1YyOVpqTVozdkF4WHVoZXNMcjJEVmJGVV93VVdDN29JckRyZ0ZwTG5OOV9zaG1vb0U?oc=5","source_event_id":"evt_958c0cafcfad","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e9f41f742a862458","published_at":"2026-04-09T14:31:34+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","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":"sovereign","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"","name":"CNN","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["No specific ceasefire start date/time, duration, or named agreement terms are provided in the supplied text.","No concrete details on which locations/actors are driving the \u201cchaos on the ground\u201d are included in the provided excerpt.","The excerpt does not specify what Iran\u2019s \u201c10-point proposal\u201d contains or how it compares to U.S. demands (only that such comparison is discussed in other referenced headlines).","No verification details (e.g., ceasefire monitoring, casualty figures, or ceasefire violation counts) are present in the provided content."],"key_facts":["CNN headline questions whether Trump\u2019s Iran ceasefire is a real deal or a mirage.","The headline states that the ceasefire \u201ccollides with chaos on the ground.\u201d","The headline indicates both Trump and Iran claim ceasefire victory.","The headline implies the ceasefire may not be helping as claimed (who it really helps is questioned)."],"numeric_claims":[],"primary_claim":"Trump\u2019s Iran ceasefire is contradicted by ongoing chaos on the ground, suggesting the ceasefire may not exist or may not be real.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"CNN reports that Trump\u2019s claimed Iran ceasefire is not holding on the ground, with fighting/chaos undermining the announced agreement. The headline frames the ceasefire as potentially illusory despite both sides claiming victory.","topics":["Iran ceasefire","U.S.-Iran tensions","claims of ceasefire victory","ceasefire credibility","on-the-ground conflict"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"A deal or a mirage? Trump\u2019s Iran ceasefire collides with chaos on the ground CNN The War Is Bad. The Cease-Fire Doesn\u2019t Exist. The Future Is Awful. The American Prospect What Is In Iran\u2019s 10-Point Proposal, and How Does It Compare to U.S. Demands? The New York Times Trump and Iran both claim ceasefire victory. Who does it really help? USA Today Trump's journey from 'annihilation' to 'PEACE' in one day rested on realization of a long-term battle to control Strait of Hormuz Fortune","title":"A deal or a mirage? Trump\u2019s Iran ceasefire collides with chaos on the ground - CNN","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_a10f75b49d08 in signals