SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T20:43:08.121744+00:00","dedupe_key":"signal_enriched:news_delta:6339a0bc20c2ea32","evidence_event_ids":["evt_0ee7845157ab"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 8361 in events