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/CBMiuAFBVV95cUxQbnlQNVhzaGdNNW45N2xwWVZBZG9LYUNoTjFvOG1xTFU2cC1Xdl9VV3Btakxoa0stV3djejNJaU1KeVpaMkxqT1BiX25FOWZ3dk1XVW9tQ3lId1gzWkJXV0d3WTh6ZEQxVEVxeDdDekdnZ0Z5NXIyOEk1cWd2NnZ6T0VhRkltdWwyOTIwLVBTRlpGYU5FeE96Z2RhWHkxN28xejZsM1BKRzJ5UmNFZ09Td3ZjZjl4WEZq?oc=5","as_of":"2026-04-08T20:43:08.121744+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/CBMiuAFBVV95cUxQbnlQNVhzaGdNNW45N2xwWVZBZG9LYUNoTjFvOG1xTFU2cC1Xdl9VV3Btakxoa0stV3djejNJaU1KeVpaMkxqT1BiX25FOWZ3dk1XVW9tQ3lId1gzWkJXV0d3WTh6ZEQxVEVxeDdDekdnZ0Z5NXIyOEk1cWd2NnZ6T0VhRkltdWwyOTIwLVBTRlpGYU5FeE96Z2RhWHkxN28xejZsM1BKRzJ5UmNFZ09Td3ZjZjl4WEZq?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7c476bdd25b337d3","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:10:49.928569+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxQbnlQNVhzaGdNNW45N2xwWVZBZG9LYUNoTjFvOG1xTFU2cC1Xdl9VV3Btakxoa0stV3djejNJaU1KeVpaMkxqT1BiX25FOWZ3dk1XVW9tQ3lId1gzWkJXV0d3WTh6ZEQxVEVxeDdDekdnZ0Z5NXIyOEk1cWd2NnZ6T0VhRkltdWwyOTIwLVBTRlpGYU5FeE96Z2RhWHkxN28xejZsM1BKRzJ5UmNFZ09Td3ZjZjl4WEZq?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxQbnlQNVhzaGdNNW45N2xwWVZBZG9LYUNoTjFvOG1xTFU2cC1Xdl9VV3Btakxoa0stV3djejNJaU1KeVpaMkxqT1BiX25FOWZ3dk1XVW9tQ3lId1gzWkJXV0d3WTh6ZEQxVEVxeDdDekdnZ0Z5NXIyOEk1cWd2NnZ6T0VhRkltdWwyOTIwLVBTRlpGYU5FeE96Z2RhWHkxN28xejZsM1BKRzJ5UmNFZ09Td3ZjZjl4WEZq?oc=5","source_event_id":"evt_0ee7845157ab","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c6e269b4f0184427","published_at":"2026-04-08T20:05:00+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign/politician","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"geopolitical alliance","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"sovereign/politician","name":"Mark Rutte","relevance":"high","symbol":"","type":"person"},{"asset_class":"news_source","name":"WSJ (The Wall Street Journal)","relevance":"medium","symbol":"","type":"media"},{"asset_class":"sovereign/country_group","name":"Certain NATO countries (unspecified)","relevance":"medium","symbol":"","type":"group"},{"asset_class":"sovereign","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Which specific NATO countries are targeted is not stated in the provided headline/summary.","Whether the \u201cpunishment\u201d would be partial, conditional, or immediate (and what criteria would be used) is not specified.","The timing of the meeting and any decision timeline for troop changes is not provided in the extracted text.","The provided content includes extensive unrelated HTML/CSS, and the actual article body text is not available here; details beyond the headline/summary cannot be verified."],"key_facts":["WSJ (exclusive) says Trump is weighing punishing certain NATO countries over their lack of support for a war against Iran.","The reported punishment is framed as potentially pulling U.S. troops from those NATO countries (exact mechanism/extent not specified in the provided text).","Trump is expected to meet with NATO leader Mark Rutte as he considers this stance.","Other referenced outlets (per the provided source summary) also indicate Trump will discuss NATO withdrawal at the meeting with Rutte."],"numeric_claims":[],"primary_claim":"Trump is weighing punishing certain NATO countries\u2014potentially by pulling troops\u2014because they have not supported a war against Iran, according to WSJ.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"WSJ reports that Trump is considering punishing certain NATO countries by potentially pulling U.S. troops from them, tied to their lack of support for a U.S.-led Iran war. The issue is expected to be discussed in the near term during Trump\u2019s meeting with NATO leader Mark Rutte.","topics":["NATO","U.S. troop deployments","Iran war support","Trump foreign policy","alliance cohesion","political negotiations"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Exclusive | Trump Weighs Punishing Certain NATO Countries Over Lack of Iran War Support WSJ Trump weighs pulling troops from NATO countries over lack of Iran war support \u2014 WSJ The Times of Israel Trump will meet with NATO leader Rutte as he muses about pulling out of the military alliance AP News Trump on the warpath is Rutte\u2019s toughest test yet Politico Trump to discuss Nato withdrawal at meeting with Rutte The Telegraph","title":"Exclusive | Trump Weighs Punishing Certain NATO Countries Over Lack of Iran War Support - WSJ","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_693a9872aee9 in signals