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-08T23:28:56.185999+00:00","dedupe_key":"signal_enriched:news_delta:04ac72a950f6df80","evidence_event_ids":["evt_d30163be3292"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5","as_of":"2026-04-08T23:28:56.185999+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/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1545c01472255812","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:17:40.995745+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5","source_event_id":"evt_d30163be3292","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c1a364ebe4a18cf8","published_at":"2026-04-08T22:56:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"political_actor","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_actor","name":"Mark Rutte","relevance":"high","symbol":"","type":"person"},{"asset_class":"security_alliance","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"geopolitical_conflict","name":"Iran war","relevance":"medium","symbol":"","type":"conflict"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no readable body content beyond page styling; therefore, only the headline and the provided source summary can be grounded.","No specific date/time of the meeting is included in the provided text.","No details are provided on what, if any, concrete policy steps (e.g., timeline, legal mechanism, or conditions) were discussed with Rutte.","The specific NATO countries referenced for potential punishment are not identified in the provided text."],"key_facts":["AP News: Trump met with NATO leader Mark Rutte.","AP News framing: the meeting occurred after Trump mused about pulling out of NATO.","Source summary (multi-outlet): Trump administration signals it is mulling NATO withdrawal.","Source summary (multi-outlet): Trump administration may consider punishing certain NATO countries over lack of Iran war support."],"numeric_claims":[],"primary_claim":"Trump met with NATO leader Mark Rutte after musing about pulling out of NATO.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"AP News reports that Trump met with NATO leader Mark Rutte after Trump publicly considered withdrawing from the NATO alliance. The meeting follows signals that the Trump administration may pursue punitive measures toward certain NATO countries over their support related to the Iran war.","topics":["NATO","U.S. foreign policy","alliance cohesion","withdrawal risk","Iran war support","Trump-Rutte meeting"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Trump met with NATO leader Rutte after musing about pulling out of the military alliance AP News Exclusive | Trump Weighs Punishing Certain NATO Countries Over Lack of Iran War Support WSJ Trump administration signals it is mulling NATO withdrawal after Iran war Al Jazeera Trump on the warpath is Rutte\u2019s toughest test yet Politico Trump to discuss leaving NATO in meeting with alliance\u2019s leader, White House says The Washington Post","title":"Trump met with NATO leader Rutte after musing about pulling out of the military alliance - AP News","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 8558 in events