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-09T06:55:02.633556+00:00","dedupe_key":"signal_enriched:news_delta:e19cdd487406544d","evidence_event_ids":["evt_9bcfb9f695f5"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5","as_of":"2026-04-09T06:55:02.633556+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/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2d75c6681184fce3","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:49:25.179385+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5","source_event_id":"evt_9bcfb9f695f5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a002ce5db1d54cb5","published_at":"2026-04-09T02:09:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"NATO chief","relevance":"high","symbol":"","type":"organization_role"},{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"US allies (unspecified)","relevance":"high","symbol":"","type":"group"},{"asset_class":"other","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"The Guardian","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The specific NATO chief\u2019s name is not provided in the provided text.","Which US allies refused to join the Iran war is not specified.","Whether the remarks are about a current active conflict or a proposed/conditional scenario is not specified.","The timeline/catalyst timing (exact date of remarks, when policy decisions may follow) is not provided in the provided text.","No direct quote beyond \u201cclearly disappointed\u201d is included in the provided content."],"key_facts":["The Guardian headline reports that the NATO chief said Trump is \u201cclearly disappointed\u201d by US allies\u2019 refusal to join an Iran war.","The refusal by allies is framed as contributing to a NATO rift over Iran policy (as indicated by the provided source summary context)."],"numeric_claims":[],"primary_claim":"The NATO chief said Trump is \u201cclearly disappointed\u201d by US allies\u2019 refusal to join a US-led Iran war.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"NATO\u2019s chief said Donald Trump is \u201cclearly disappointed\u201d that some US allies refused to join the US in an Iran war, highlighting strain within NATO over Iran policy. The near-term catalyst is the ongoing diplomatic fallout from these remarks and related NATO-US disagreements.","topics":["NATO","US allies","Iran war","transatlantic relations","diplomatic tensions"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Nato chief says Trump \u2018clearly disappointed\u2019 by US allies\u2019 refusal to join Iran war The Guardian 'Poorly run, piece of ice': Trump targets Greenland again as Iran war deepens NATO rift CNBC Exclusive | Trump Team Explores Punishment for NATO Countries That Didn\u2019t Support Iran War WSJ Trump slams NATO over Iran after meeting Rutte, renews Greenland threat Al Jazeera NATO chief says some European allies were tested and failed in Iran war Reuters","title":"Nato chief says Trump \u2018clearly disappointed\u2019 by US allies\u2019 refusal to join Iran war - The Guardian","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 9277 in events