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-10T13:23:11.045624+00:00","dedupe_key":"signal_enriched:news_delta:b3abb760f9f04596","evidence_event_ids":["evt_0bb8f7cfb7bf"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?oc=5","as_of":"2026-04-10T13:23:11.045624+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/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3f1ee0fca5b2fb38","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-10T13:23:57.930981+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?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/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?oc=5","source_event_id":"evt_0bb8f7cfb7bf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"36f37442f3a02860","published_at":"2026-04-10T09:03:38+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"political_official","name":"JD Vance","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign_state","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign_state","name":"United States (Vance administration context)","relevance":"medium","symbol":"","type":"country_or_government"},{"asset_class":"chokepoint","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geographic_location"},{"asset_class":"political_official","name":"Trump (referenced in source summary)","relevance":"medium","symbol":"","type":"person"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not usable for extracting the NYT article\u2019s specific details (it appears to be page styling/boilerplate rather than article content).","No specific date/time, location, or agenda items for the Iran talks are included in the provided headline and summaries.","No concrete terms of any ceasefire or negotiation outcomes are stated in the provided material.","Directional market/operational impact (e.g., oil price moves) is not explicitly stated in the provided text; only geopolitical risk framing is implied."],"key_facts":["The headline states that JD Vance faces a high-profile test of his negotiating skills with Iran talks (The New York Times).","The provided source summary includes that Trump casts doubt on an Iran war ceasefire due to continued closure of the Strait of Hormuz (The Guardian).","The provided source summary includes that Trump sends his team to Pakistan for high-stakes Iran talks (WSJ).","The provided source summary includes that Vance warns Iran not to \"play us\" as he leaves for talks (Reuters)."],"numeric_claims":[],"primary_claim":"JD Vance is facing a high-profile test of his negotiating skills with Iran talks, according to The New York Times.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The New York Times reports that JD Vance is heading into a high-stakes negotiation test involving Iran talks, framed as a test of his negotiating skills. The broader provided source set also indicates contemporaneous uncertainty around an Iran-related ceasefire and heightened attention to the Strait of Hormuz.","topics":["Iran talks","US-Iran negotiations","JD Vance","Strait of Hormuz","ceasefire uncertainty","Middle East crisis"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Vance Faces a High-Profile Test of His Negotiating Skills With Iran Talks The New York Times Middle East crisis live: Trump casts doubt on Iran war ceasefire over continued closure of strait of Hormuz The Guardian \u2018Afraid of being on the outs\u2019: Inside JD Vance\u2019s tightrope walk on Iran MS NOW Trump Sends His Team to Pakistan for High-Stakes Iran Talks WSJ Vance warns Iran not to \"play us\" as he leaves for talks Reuters","title":"Vance Faces a High-Profile Test of His Negotiating Skills With Iran Talks - 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 16559 in events