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-09T15:51:38.289148+00:00","dedupe_key":"signal_enriched:news_delta:165877bbc924b465","evidence_event_ids":["evt_156d9a048591"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNTjk2U09FcGs2RlA4enJlUU15cGFGZUw2MzA4VnoyZFUtZlN1NzF3TlVlMl9BMEh6bTMxYnFlQTQtVTRIQ2pjaEtGdGtRMTVpVHhHeGlibHVKTzk3aDM1UVBfUlVaTGJJdkdOVzJ5X2hraENhMWNIR0NVcXBQN3Q3TGRvTk5oUGVnQVE?oc=5","as_of":"2026-04-09T15:51:38.289148+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/CBMiigFBVV95cUxNTjk2U09FcGs2RlA4enJlUU15cGFGZUw2MzA4VnoyZFUtZlN1NzF3TlVlMl9BMEh6bTMxYnFlQTQtVTRIQ2pjaEtGdGtRMTVpVHhHeGlibHVKTzk3aDM1UVBfUlVaTGJJdkdOVzJ5X2hraENhMWNIR0NVcXBQN3Q3TGRvTk5oUGVnQVE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f7f50aba85453629","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-09T23:47:47.286881+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNTjk2U09FcGs2RlA4enJlUU15cGFGZUw2MzA4VnoyZFUtZlN1NzF3TlVlMl9BMEh6bTMxYnFlQTQtVTRIQ2pjaEtGdGtRMTVpVHhHeGlibHVKTzk3aDM1UVBfUlVaTGJJdkdOVzJ5X2hraENhMWNIR0NVcXBQN3Q3TGRvTk5oUGVnQVE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNTjk2U09FcGs2RlA4enJlUU15cGFGZUw2MzA4VnoyZFUtZlN1NzF3TlVlMl9BMEh6bTMxYnFlQTQtVTRIQ2pjaEtGdGtRMTVpVHhHeGlibHVKTzk3aDM1UVBfUlVaTGJJdkdOVzJ5X2hraENhMWNIR0NVcXBQN3Q3TGRvTk5oUGVnQVE?oc=5","source_event_id":"evt_156d9a048591","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c2ff784d8a5070e4","published_at":"2026-04-09T09:21:17+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"political_actor","name":"Donald Trump","relevance":"directly involved in the criticism and policy exploration","symbol":"","type":"person"},{"asset_class":"security_alliance","name":"NATO","relevance":"target of Trump\u2019s criticism; central to the rift","symbol":"","type":"organization"},{"asset_class":"sovereign_states","name":"NATO member countries (unspecified)","relevance":"described as not supporting the Iran war; potential targets of punishment","symbol":"","type":"group"},{"asset_class":"sovereign_state","name":"Iran","relevance":"the conflict context driving the NATO dispute","symbol":"","type":"country"},{"asset_class":"media","name":"The New York Times","relevance":"source of the headline and exclusive framing","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The specific form of \u201cpunishment\u201d (e.g., funding cuts, troop changes, sanctions) is not stated in the provided text.","Which NATO countries are implicated is not specified.","Timing/catalyst window for when any punishment would be implemented is not provided.","The exact content/wording of Trump\u2019s latest NATO criticism is not included beyond the headline framing.","Whether the Reuters/Bloomberg/WSJ/CNBC items are direct quotes from the NYT article or separate related coverage is not determinable from the provided excerpt."],"key_facts":["The New York Times headline states Trump again hits out at NATO over the Iran war.","The source summary indicates Trump\u2019s team is exploring punishment for NATO countries that did not support the Iran war.","The source summary includes commentary that NATO\u2019s chief said some European allies were tested and failed in the Iran war (attributed to Reuters in the provided summary).","The source summary frames the situation as deepening a NATO rift as the Iran war continues."],"numeric_claims":[],"primary_claim":"Trump again criticized NATO over NATO countries\u2019 support (or lack of support) regarding the Iran war, and his team is exploring punishment for countries that did not support the war.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"The New York Times reports that Trump is again criticizing NATO in connection with the Iran war, and his team is exploring ways to punish NATO countries that did not support the U.S. position. The development signals renewed strain in NATO relations as the Iran conflict continues.","topics":["NATO","Iran war","U.S. foreign policy","transatlantic relations","alliance cohesion","potential sanctions/punishment"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Trump Again Hits Out at NATO Over Iran War The New York Times Exclusive | Trump Team Explores Punishment for NATO Countries That Didn\u2019t Support Iran War WSJ 'Poorly run, piece of ice': Trump targets Greenland again as Iran war deepens NATO rift CNBC NATO chief says some European allies were tested and failed in Iran war Reuters Can Trump Really Pull the US Out of NATO? Bloomberg.com","title":"Trump Again Hits Out at NATO Over Iran War - The New York Times","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 10442 in events