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/CBMihgFBVV95cUxONnIwdnNrSHlNVDc5MzYwNnRPMDVqX29EWVRKaXdtRHVNNmtpR2tuaUV0ejN4dTJKM1I1V0haN3RQLWpQQW5sYXpfRmdabGdHQjV4OVQ1R1dGZGpMMHVIVXZXVWd2a3ZZWnFvdldTcldxRkpYVzFlV3FWbWRaMkRPRTdMOWEtZw?oc=5","as_of":"2026-04-09T22:47:28.535774+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/CBMihgFBVV95cUxONnIwdnNrSHlNVDc5MzYwNnRPMDVqX29EWVRKaXdtRHVNNmtpR2tuaUV0ejN4dTJKM1I1V0haN3RQLWpQQW5sYXpfRmdabGdHQjV4OVQ1R1dGZGpMMHVIVXZXVWd2a3ZZWnFvdldTcldxRkpYVzFlV3FWbWRaMkRPRTdMOWEtZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_066d4e30f90627ce","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-10T00:46:35.206604+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxONnIwdnNrSHlNVDc5MzYwNnRPMDVqX29EWVRKaXdtRHVNNmtpR2tuaUV0ejN4dTJKM1I1V0haN3RQLWpQQW5sYXpfRmdabGdHQjV4OVQ1R1dGZGpMMHVIVXZXVWd2a3ZZWnFvdldTcldxRkpYVzFlV3FWbWRaMkRPRTdMOWEtZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxONnIwdnNrSHlNVDc5MzYwNnRPMDVqX29EWVRKaXdtRHVNNmtpR2tuaUV0ejN4dTJKM1I1V0haN3RQLWpQQW5sYXpfRmdabGdHQjV4OVQ1R1dGZGpMMHVIVXZXVWd2a3ZZWnFvdldTcldxRkpYVzFlV3FWbWRaMkRPRTdMOWEtZw?oc=5","source_event_id":"evt_8ab92a5e2b6e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b872bd4d132192e6","published_at":"2026-04-09T21:46:47+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign/political","name":"Donald Trump","relevance":"primary actor","symbol":"","type":"person"},{"asset_class":"sovereign/political","name":"Mark Rutte","relevance":"counterparty in dispute","symbol":"","type":"person"},{"asset_class":"geopolitical alliance","name":"NATO","relevance":"core subject of dispute/criticism","symbol":"","type":"organization"},{"asset_class":"media","name":"Reuters","relevance":"source of related NATO/Iran war framing","symbol":"","type":"publisher"},{"asset_class":"media","name":"The New York Times","relevance":"source of related NATO/Iran war framing","symbol":"","type":"publisher"},{"asset_class":"media","name":"CBC","relevance":"source of related NATO/Iran war framing","symbol":"","type":"publisher"},{"asset_class":"media","name":"Military Times","relevance":"source of related NATO/Iran war framing","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual Politico article content, so the specific details of \u201cwhat it was really about\u201d are not verifiable from the supplied text.","No specific date, location, or direct quotes from Politico are included in the provided material.","The signal includes multiple other headlines (CBC/Reuters/NYT/Military Times), but their full text is not provided, limiting confirmation of exact wording and causality."],"key_facts":["Politico headline indicates Trump\u2019s dispute with Rutte was about what the article characterizes as the real underlying issue (NATO-related).","The Politico framing suggests NATO \u201cendures\u201d and is \u201charder to kill than it looks.\u201d","Additional provided headlines state Trump again chides NATO for failing to back U.S. operations in Iran.","A Reuters-related headline says NATO\u2019s chief stated some European allies were tested and failed in the Iran war.","A New York Times-related headline says NATO\u2019s chief said some European allies were tested and failed in the Iran war."],"numeric_claims":[],"primary_claim":"Politico says Trump\u2019s blowup with Rutte was really about NATO-related issues, and that NATO is harder to kill than it looks.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Politico reports that Trump\u2019s dispute with Dutch Prime Minister Mark Rutte was driven by NATO-related disagreements, but the alliance is portrayed as resilient. The broader set of headlines also indicates Trump is again criticizing NATO\u2019s support for U.S. operations in the context of the Iran war.","topics":["NATO","U.S.-Europe relations","Iran war","transatlantic burden sharing","diplomatic dispute"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"What Trump\u2019s blowup with Rutte was really about Politico Trump rages, NATO endures: Why the alliance is harder to kill than it looks CBC Trump Again Hits Out at NATO Over Iran War The New York Times NATO chief says some European allies were tested and failed in Iran war Reuters Trump again chides NATO for failing to back US operations in Iran Military Times","title":"What Trump\u2019s blowup with Rutte was really about - Politico","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_917e6bfa690e in signals