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/CBMiggFBVV95cUxQMm42N2dKSGVZbnVJbG9ncy15N3FGelN6VDVPRkVRUERRWFJ1Vmw2WHFSQkxfWG5oUWpwUGxYemVmbk1vUGExMkJuZUV5dmpCWHpYSmFTM0lxeHducW90VlNKYXlQVE9ENndSdERHWHU4Q2Z4UWkwUDd4aDBMbzV1Q3FB?oc=5","as_of":"2026-04-09T14:22:29.253499+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/CBMiggFBVV95cUxQMm42N2dKSGVZbnVJbG9ncy15N3FGelN6VDVPRkVRUERRWFJ1Vmw2WHFSQkxfWG5oUWpwUGxYemVmbk1vUGExMkJuZUV5dmpCWHpYSmFTM0lxeHducW90VlNKYXlQVE9ENndSdERHWHU4Q2Z4UWkwUDd4aDBMbzV1Q3FB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_47864a42bfb8035f","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:34:12.942266+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQMm42N2dKSGVZbnVJbG9ncy15N3FGelN6VDVPRkVRUERRWFJ1Vmw2WHFSQkxfWG5oUWpwUGxYemVmbk1vUGExMkJuZUV5dmpCWHpYSmFTM0lxeHducW90VlNKYXlQVE9ENndSdERHWHU4Q2Z4UWkwUDd4aDBMbzV1Q3FB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.eu","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQMm42N2dKSGVZbnVJbG9ncy15N3FGelN6VDVPRkVRUERRWFJ1Vmw2WHFSQkxfWG5oUWpwUGxYemVmbk1vUGExMkJuZUV5dmpCWHpYSmFTM0lxeHducW90VlNKYXlQVE9ENndSdERHWHU4Q2Z4UWkwUDd4aDBMbzV1Q3FB?oc=5","source_event_id":"evt_92707b2cd87c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"eead218aa817fb22","published_at":"2026-04-09T09:00:00+00:00","publisher_domain":"politico.eu","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity/other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"equity/other","name":"Mark Rutte","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"European allies","relevance":"medium","symbol":"","type":"group"},{"asset_class":"other","name":"Iran war","relevance":"medium","symbol":"","type":"conflict"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only page styling/boilerplate, not the actual article content; extraction relies on the provided headline and source summary.","Specific details of what Trump said (quotes, policy demands, or actions) are not present in the provided text.","Timing (exact date/time of the meeting and when the lash-out occurred) is not included.","The identity of the \u201csome European allies\u201d is not specified.","Whether any formal NATO decision, suspension, or treaty-related action followed is not stated."],"key_facts":["Politico.eu headline states Trump \u201clashes NATO\u201d after a \u201cfrank and open\u201d meeting with Mark Rutte.","NATO chief is described as saying some European allies were \u201ctested and failed\u201d in the Iran war (as referenced in the provided source summary).","The overall framing indicates an ongoing NATO rift tied to the Iran war and public criticism of allies."],"numeric_claims":[],"primary_claim":"Trump publicly lashed out at NATO following a \u201cfrank and open\u201d meeting with NATO chief Mark Rutte, worsening NATO-EU/European ally relations amid the Iran war.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Politico.eu reports that Donald Trump criticized NATO after a \u201cfrank and open\u201d meeting with NATO leader Mark Rutte, escalating public tensions within the alliance. The reporting also indicates NATO\u2019s chief said some European allies were \u201ctested and failed\u201d during the Iran war, contributing to the rift.","topics":["NATO","US-Europe relations","Trump rhetoric","Mark Rutte meeting","Iran war","alliance cohesion"]},"source":"politico.eu","source_domain":"politico.eu","source_url":"https://www.politico.eu","summary":"Trump lashes NATO after \u2018frank and open\u2019 Rutte meeting politico.eu NATO chief says some European allies were tested and failed in Iran war Reuters Trump Renews Attacks on NATO Allies WSJ 'Poorly run, piece of ice': Trump targets Greenland again as Iran war deepens NATO rift CNBC Trump vents at NATO but avoids rupture after meeting with alliance\u2019s leader The Washington Post","title":"Trump lashes NATO after \u2018frank and open\u2019 Rutte meeting - politico.eu","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_628be4a43d30 in signals