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/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?oc=5","as_of":"2026-04-08T21:48:34.417856+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/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dcfd3ec2a88c0c3f","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:14:05.934337+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?oc=5","source_event_id":"evt_585523aaade7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0193e47159577eb3","published_at":"2026-04-08T20:49:18+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Donald Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"NPR","relevance":"medium","symbol":"","type":"media"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"media"},{"asset_class":"","name":"Vox","relevance":"low","symbol":"","type":"media"},{"asset_class":"","name":"The Washington Post","relevance":"medium","symbol":"","type":"media"},{"asset_class":"","name":"The Atlantic","relevance":"low","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["No article body content is provided, so specific outcomes, policy actions, or details of the reported truce are not stated.","No dates for the truce or backlash are provided beyond the \u201c5 weeks of war\u201d framing.","No direct evidence is included here for what was accomplished; only headline-level claims are visible."],"key_facts":["NPR headline asks what the U.S. war with Iran has accomplished.","The New York Times headline states: \u201cWhat Trump Has Accomplished in Iran After 5 Weeks of War.\u201d","Vox headline references a \u201csoft TACO\u201d theory of Trump.","The Washington Post headline says Trump\u2019s Iran brinkmanship reaches truce and escalates backlash at home.","The Atlantic headline is \u201cAmerica Looks Like a Paper Tiger.\u201d"],"numeric_claims":[{"label":"timeframe","value":"5 weeks"}],"primary_claim":"The provided headlines indicate ongoing U.S.-Iran conflict developments and debate over their outcomes, including a reported truce alongside domestic backlash.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The signal references multiple news pieces assessing the U.S. posture toward Iran, including claims about what the conflict has achieved, Trump\u2019s actions after weeks of war, and whether brinkmanship is leading to a truce while triggering domestic backlash.","topics":["U.S.-Iran conflict","Trump foreign policy","brinkmanship","truce","domestic backlash","media analysis"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"What has the U.S. war with Iran accomplished? NPR What Trump Has Accomplished in Iran After 5 Weeks of War The New York Times A new theory of Trump: the \u201csoft TACO\u201d vox.com Trump\u2019s Iran brinkmanship reaches truce, escalates backlash at home The Washington Post America Looks Like a Paper Tiger The Atlantic","title":"What has the U.S. war with Iran accomplished? - NPR","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_5d5078132bea in signals