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/CBMizwFBVV95cUxOY1pWZmNvY1BtUVZ4TnBhWXU4cXBYWjE5bGppRFREdDcweGp3ZUVPRVZWWDNRUU1wM0ZFaS1WY0hzQUZhZE1wVTlWR2J3YU9MemE3dVRNeEZFdURQQlhIZlBOZFo1dEtGS0QxaFdUYU1xWDZacTJVMy11NzNOTEFveFhPUUZjdUJqa1RpVnotZnhrbm02MF9CeUdrcUhwVThGVDZsdl81bjBlVGtYNmJjTEx3bklVYU5Md2J6R1pjdlVuZjNoaFpBSWMxQXlKWTA?oc=5","as_of":"2026-04-09T05:26:02.317964+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/CBMizwFBVV95cUxOY1pWZmNvY1BtUVZ4TnBhWXU4cXBYWjE5bGppRFREdDcweGp3ZUVPRVZWWDNRUU1wM0ZFaS1WY0hzQUZhZE1wVTlWR2J3YU9MemE3dVRNeEZFdURQQlhIZlBOZFo1dEtGS0QxaFdUYU1xWDZacTJVMy11NzNOTEFveFhPUUZjdUJqa1RpVnotZnhrbm02MF9CeUdrcUhwVThGVDZsdl81bjBlVGtYNmJjTEx3bklVYU5Md2J6R1pjdlVuZjNoaFpBSWMxQXlKWTA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_03701a07cf88df62","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:41:12.797218+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizwFBVV95cUxOY1pWZmNvY1BtUVZ4TnBhWXU4cXBYWjE5bGppRFREdDcweGp3ZUVPRVZWWDNRUU1wM0ZFaS1WY0hzQUZhZE1wVTlWR2J3YU9MemE3dVRNeEZFdURQQlhIZlBOZFo1dEtGS0QxaFdUYU1xWDZacTJVMy11NzNOTEFveFhPUUZjdUJqa1RpVnotZnhrbm02MF9CeUdrcUhwVThGVDZsdl81bjBlVGtYNmJjTEx3bklVYU5Md2J6R1pjdlVuZjNoaFpBSWMxQXlKWTA?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/CBMizwFBVV95cUxOY1pWZmNvY1BtUVZ4TnBhWXU4cXBYWjE5bGppRFREdDcweGp3ZUVPRVZWWDNRUU1wM0ZFaS1WY0hzQUZhZE1wVTlWR2J3YU9MemE3dVRNeEZFdURQQlhIZlBOZFo1dEtGS0QxaFdUYU1xWDZacTJVMy11NzNOTEFveFhPUUZjdUJqa1RpVnotZnhrbm02MF9CeUdrcUhwVThGVDZsdl81bjBlVGtYNmJjTEx3bklVYU5Md2J6R1pjdlVuZjNoaFpBSWMxQXlKWTA?oc=5","source_event_id":"evt_149b0ba88eb1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3bacf40f809071bb","published_at":"2026-04-09T03:58:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"United States military","relevance":"high","symbol":"","type":"organization"},{"asset_class":"n/a","name":"Iran (Tehran)","relevance":"high","symbol":"","type":"country/government"},{"asset_class":"n/a","name":"Tehran","relevance":"high","symbol":"","type":"country/government"},{"asset_class":"n/a","name":"Reuters","relevance":"medium","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["The specific deal terms are not provided in the supplied text (only referenced as a \u201cdeal\u201d / \u201creal\u201d ceasefire deal).","No details are given on what \u201cstay around Iran\u201d means operationally (troop levels, ship/air deployments, or geographic scope).","No timing (date/timeframe) for when the statement takes effect or when compliance would be assessed is included in the provided content.","The nature/threshold of the \u201caction\u201d Trump threatened is not specified in the provided text."],"key_facts":["Reuters headline states Trump said U.S. military will stay around Iran until Tehran complies with a deal.","Trump threatened action if Iran fails to comply with what he described as a \u201creal\u201d ceasefire deal (as reflected in the provided source summary).","The stated condition for any change in U.S. military posture is \u201cTehran complies with the deal.\u201d"],"numeric_claims":[],"primary_claim":"Trump stated the U.S. military will stay around Iran until Tehran complies with the deal, with threats of action if Iran does not comply.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports that Trump said the U.S. military will remain near Iran until Tehran complies with a deal, and he threatened action if Iran fails to meet the terms of what he called a \u201creal\u201d ceasefire agreement.","topics":["Iran","U.S.-Iran relations","military posture","ceasefire deal","compliance","threat of action"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Trump says US military to stay around Iran until Tehran complies with deal Reuters Trump threatens action if Iran fails to comply with \u2018real\u2019 ceasefire deal Al Jazeera Trump says U.S. military to stay around Iran; threatens action if Tehran fails to comply with deal The Detroit News How the Journal Covered Trump\u2019s 12-Hour Iran \u2018Civilization\u2019 Countdown WSJ Trump warns U.S. military will stay near Iran until 'real agreement' is honored CNBC","title":"Trump says US military to stay around Iran until Tehran complies with deal - 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_5b91bcb6ee17 in signals