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-09T22:47:28.535774+00:00","dedupe_key":"signal_enriched:news_delta:23770b97cbff8c0c","evidence_event_ids":["evt_8ab92a5e2b6e"],"signal_type":"news_headline_delta","source":"news_rss","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

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 11522 in events