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-09T23:03:22.998100+00:00","dedupe_key":"signal_enriched:news_delta:000de0c832a6055f","evidence_event_ids":["evt_617f69599b48"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE9SY0VwaHZoUWJRX2ZXZjNZaXUxVG1lclhqQkVZeVF2MW9EX3RhOVNGRlhEOW1EclA3YnhOSjRZWE1FLXE4ZWxkaWlrYXNieEpkWExsVldYeUZLN3lCUUJzZ0FWLUlHaXk2alkwZkVMNHl5bGRoREFvcA?oc=5","as_of":"2026-04-09T23:03:22.998100+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/CBMieEFVX3lxTE9SY0VwaHZoUWJRX2ZXZjNZaXUxVG1lclhqQkVZeVF2MW9EX3RhOVNGRlhEOW1EclA3YnhOSjRZWE1FLXE4ZWxkaWlrYXNieEpkWExsVldYeUZLN3lCUUJzZ0FWLUlHaXk2alkwZkVMNHl5bGRoREFvcA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e93355d0dbe58f7d","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-10T00:49:38.971967+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE9SY0VwaHZoUWJRX2ZXZjNZaXUxVG1lclhqQkVZeVF2MW9EX3RhOVNGRlhEOW1EclA3YnhOSjRZWE1FLXE4ZWxkaWlrYXNieEpkWExsVldYeUZLN3lCUUJzZ0FWLUlHaXk2alkwZkVMNHl5bGRoREFvcA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE9SY0VwaHZoUWJRX2ZXZjNZaXUxVG1lclhqQkVZeVF2MW9EX3RhOVNGRlhEOW1EclA3YnhOSjRZWE1FLXE4ZWxkaWlrYXNieEpkWExsVldYeUZLN3lCUUJzZ0FWLUlHaXk2alkwZkVMNHl5bGRoREFvcA?oc=5","source_event_id":"evt_617f69599b48","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"95bca56a767132da","published_at":"2026-04-09T17:15:21+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"NATO chief Mark Rutte","relevance":"primary spokesperson","symbol":"","type":"person"},{"asset_class":"other","name":"NATO","relevance":"institution coordinating/urging allied support","symbol":"","type":"organization"},{"asset_class":"other","name":"Europe","relevance":"geographic bloc being urged/acting","symbol":"","type":"region"},{"asset_class":"","name":"Donald Trump","relevance":"US president referenced as driving/triggering timeline","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"conflict party referenced","symbol":"","type":"country"},{"asset_class":"other","name":"Hormuz","relevance":"pledges/timeline referenced","symbol":"","type":"location/strategic chokepoint"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not actually the Politico article content (it appears to be page styling/boilerplate), so only the headline and the included multi-source summary can be grounded.","\u201cLatest Trump attacks\u201d is not specified (type, date, targets) in the provided text.","Whether the \u201cscrambling\u201d refers to specific NATO measures (naval deployments, intelligence sharing, logistics, funding) is not stated in the provided material.","The exact deadline for \u201cwithin days\u201d is not given in the provided text.","No direct quotes beyond the headline phrase are available from the provided content."],"key_facts":["Politico headline states NATO chief Mark Rutte insisted Europe is \u201cscrambling\u201d to help with the Iran war after the latest Trump attacks.","The provided source summary set includes a Reuters item stating Rutte told allies Trump wants Hormuz pledges within days (timing catalyst)."],"numeric_claims":[],"primary_claim":"NATO chief Mark Rutte said Europe is \u201cscrambling\u201d to help with the Iran war after the latest Trump attacks.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Politico reports NATO\u2019s secretary general, Mark Rutte, says Europe is \u201cscrambling\u201d to support efforts related to the Iran war after recent actions attributed to President Trump. The near-term catalyst described is Trump\u2019s reported push for allies to provide Hormuz-related pledges within days.","topics":["NATO","Iran conflict","Hormuz pledges","Europe-US burden sharing","allied coordination","Middle East security"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"NATO chief insists Europe is \u2018scrambling\u2019 to help with Iran war after latest Trump attacks Politico NATO Labors to Avoid Becoming Another Casualty of the Iran War The New York Times NATO's Rutte tells allies Trump wants Hormuz pledges within days, diplomats say Reuters NATO chief: US, Iran conflict could lead to \u2018North Korea moment\u2019 The Hill NATO Chief Says Group Moving on From Unhealthy Dependence on US Bloomberg.com","title":"NATO chief insists Europe is \u2018scrambling\u2019 to help with Iran war after latest Trump attacks - Politico","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 11566 in events