SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_668828d277e5 in signals