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/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5","as_of":"2026-04-08T23:28:56.185999+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/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1545c01472255812","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:17:40.995745+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxOMlZ0cTNKYmcybnNwZmV0Y0plc3hLU2k1ZXJ5cFhnamZHWnpaOERPbHFpQVN5VkJkUlEtR0ZRY1MwTVRISHJ3UDhtRXl3cDlsTThVWUhySU5KM29KXzA3bmFtM3QtMm5rVWkyNWdGQzVYYU5mSFVzaGVLOGttTE1aM09uS1B1aDF6RWdlTTVB?oc=5","source_event_id":"evt_d30163be3292","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c1a364ebe4a18cf8","published_at":"2026-04-08T22:56:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"political_actor","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_actor","name":"Mark Rutte","relevance":"high","symbol":"","type":"person"},{"asset_class":"security_alliance","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"geopolitical_conflict","name":"Iran war","relevance":"medium","symbol":"","type":"conflict"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no readable body content beyond page styling; therefore, only the headline and the provided source summary can be grounded.","No specific date/time of the meeting is included in the provided text.","No details are provided on what, if any, concrete policy steps (e.g., timeline, legal mechanism, or conditions) were discussed with Rutte.","The specific NATO countries referenced for potential punishment are not identified in the provided text."],"key_facts":["AP News: Trump met with NATO leader Mark Rutte.","AP News framing: the meeting occurred after Trump mused about pulling out of NATO.","Source summary (multi-outlet): Trump administration signals it is mulling NATO withdrawal.","Source summary (multi-outlet): Trump administration may consider punishing certain NATO countries over lack of Iran war support."],"numeric_claims":[],"primary_claim":"Trump met with NATO leader Mark Rutte after musing about pulling out of NATO.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"AP News reports that Trump met with NATO leader Mark Rutte after Trump publicly considered withdrawing from the NATO alliance. The meeting follows signals that the Trump administration may pursue punitive measures toward certain NATO countries over their support related to the Iran war.","topics":["NATO","U.S. foreign policy","alliance cohesion","withdrawal risk","Iran war support","Trump-Rutte meeting"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Trump met with NATO leader Rutte after musing about pulling out of the military alliance AP News Exclusive | Trump Weighs Punishing Certain NATO Countries Over Lack of Iran War Support WSJ Trump administration signals it is mulling NATO withdrawal after Iran war Al Jazeera Trump on the warpath is Rutte\u2019s toughest test yet Politico Trump to discuss leaving NATO in meeting with alliance\u2019s leader, White House says The Washington Post","title":"Trump met with NATO leader Rutte after musing about pulling out of the military alliance - AP News","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_3c171f3dea99 in signals