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-10T18:06:51.959211+00:00","dedupe_key":"signal_enriched:news_delta:2fb490b5ce1ce289","evidence_event_ids":["evt_ac1e2bb7da65"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?oc=5","as_of":"2026-04-10T18:06:51.959211+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/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_55afc6e3bdd1821a","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-10T18:45:51.605904+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?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/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?oc=5","source_event_id":"evt_ac1e2bb7da65","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"055f990baee6cb51","published_at":"2026-04-10T16:32:02+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign_government","name":"Keir Starmer","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"sovereign_government","name":"Donald Trump","relevance":"source of frustration","symbol":"","type":"person"},{"asset_class":"sovereign_government","name":"United Kingdom","relevance":"affected jurisdiction","symbol":"","type":"country"},{"asset_class":"region","name":"Europe","relevance":"described as splintering","symbol":"","type":"region"},{"asset_class":"sovereign_government","name":"Iran","relevance":"center of the conflict referenced","symbol":"","type":"country"},{"asset_class":"media","name":"The New York Times","relevance":"source of headline","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML/CSS and does not include the actual article content, so details beyond the headline and the provided source summary cannot be verified.","It is unclear whether \u201cPutin affecting UK energy costs\u201d is part of the NYT article or only from other included snippets in the user\u2019s source summary.","No specific policy actions, dates, or named \u201cother allies\u201d are stated in the provided headline/summaries beyond general alliance language."],"key_facts":["The New York Times headline states: \u201cI\u2019m Fed Up.\u201d Frustrated With Trump, Starmer Embraces Other Allies.","The headline framing indicates Europe is \u201csplinter[ing] from U.S.\u201d over the Iran war.","The provided source summary includes the quote attribution that Starmer says he is \u201cfed up\u201d with Trump and Putin affecting UK energy costs (unclear if included in the NYT article or only in the broader provided summaries)."],"numeric_claims":[],"primary_claim":"Keir Starmer said he is \u201cfed up\u201d with Trump and is embracing other allies as Europe splinters from the U.S. over the Iran war.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"UK Prime Minister Keir Starmer is portrayed as \u201cfed up\u201d with President Trump and is seeking closer alignment with other allies as Europe fractures over the Iran war. The near-term catalyst is the ongoing Iran conflict and its spillover into UK/European policy and costs.","topics":["UK politics","U.S.-UK relations","Europe-U.S. alignment","Iran war","diplomacy/alliance strategy","energy costs (implied)"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"\u2018I\u2019m Fed Up.\u2019 Frustrated With Trump, Starmer Embraces Other Allies. The New York Times Starmer Says He's 'Fed Up' With Trump as Europe Splinters From U.S. Over Iran War Time Magazine Iran conflict will define us for a generation, says PM BBC The Iran war is a warning: Britain must build resilience \u2013 at home and with our allies in Europe | Keir Starmer The Guardian Keir Starmer: 'I'm fed up' with Trump and Putin affecting UK energy costs CNBC","title":"\u2018I\u2019m Fed Up.\u2019 Frustrated With Trump, Starmer Embraces Other Allies. - 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

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