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-08T22:21:15.870728+00:00","dedupe_key":"signal_enriched:news_delta:9632f3f19428c998","evidence_event_ids":["evt_d6eaa0687674"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxOSm9SeE96QmZsR1RKQ0hoSzdSSjkyd0ZhZmFxOEpMU3Nxd1RVMzl4dWlVdzI1ZklzYWhxVWV5LVlUTU93Ym5RVVhqVWFFWEJUWUUwdU8xX3ZycWVBYkpLeHV1cGxIYzFQa21Tem1NRkZtMXk5ajljdXVNTTBvbVMyaDlPbHVJS1NYYjlnY2w4c1J3MjVkaUxudXlCcXVBczVCNDVWUi0tVmhfdVVYRThvSFhUakZ1cWxyYi1RUVZhWUlhd3Z5WmNDTnF4NA?oc=5","as_of":"2026-04-08T22:21:15.870728+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/CBMiywFBVV95cUxOSm9SeE96QmZsR1RKQ0hoSzdSSjkyd0ZhZmFxOEpMU3Nxd1RVMzl4dWlVdzI1ZklzYWhxVWV5LVlUTU93Ym5RVVhqVWFFWEJUWUUwdU8xX3ZycWVBYkpLeHV1cGxIYzFQa21Tem1NRkZtMXk5ajljdXVNTTBvbVMyaDlPbHVJS1NYYjlnY2w4c1J3MjVkaUxudXlCcXVBczVCNDVWUi0tVmhfdVVYRThvSFhUakZ1cWxyYi1RUVZhWUlhd3Z5WmNDTnF4NA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a5254b709687d1ad","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:16:59.094531+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxOSm9SeE96QmZsR1RKQ0hoSzdSSjkyd0ZhZmFxOEpMU3Nxd1RVMzl4dWlVdzI1ZklzYWhxVWV5LVlUTU93Ym5RVVhqVWFFWEJUWUUwdU8xX3ZycWVBYkpLeHV1cGxIYzFQa21Tem1NRkZtMXk5ajljdXVNTTBvbVMyaDlPbHVJS1NYYjlnY2w4c1J3MjVkaUxudXlCcXVBczVCNDVWUi0tVmhfdVVYRThvSFhUakZ1cWxyYi1RUVZhWUlhd3Z5WmNDTnF4NA?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/CBMiywFBVV95cUxOSm9SeE96QmZsR1RKQ0hoSzdSSjkyd0ZhZmFxOEpMU3Nxd1RVMzl4dWlVdzI1ZklzYWhxVWV5LVlUTU93Ym5RVVhqVWFFWEJUWUUwdU8xX3ZycWVBYkpLeHV1cGxIYzFQa21Tem1NRkZtMXk5ajljdXVNTTBvbVMyaDlPbHVJS1NYYjlnY2w4c1J3MjVkaUxudXlCcXVBczVCNDVWUi0tVmhfdVVYRThvSFhUakZ1cWxyYi1RUVZhWUlhd3Z5WmNDTnF4NA?oc=5","source_event_id":"evt_d6eaa0687674","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ecb8772f637e82c8","published_at":"2026-04-08T18:00:35+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Saturday","April 8"],"entities":[{"asset_class":"person","name":"JD Vance","relevance":"lead US delegation","symbol":"","type":"person"},{"asset_class":"person","name":"Richard Witkoff","relevance":"US delegation member","symbol":"","type":"person"},{"asset_class":"person","name":"Jared Kushner","relevance":"US delegation member","symbol":"","type":"person"},{"asset_class":"person","name":"Donald Trump","relevance":"initiator of delegation","symbol":"","type":"person"},{"asset_class":"country","name":"Pakistan","relevance":"host location for talks (Islamabad)","symbol":"","type":"location"},{"asset_class":"country","name":"Iran","relevance":"counterparty in ceasefire talks","symbol":"","type":"country"},{"asset_class":"group","name":"US delegation","relevance":"collective entity traveling to talks","symbol":"","type":"group"}],"event_type":"geopolitical_risk","information_gaps":["The specific ceasefire terms or agenda are not provided in the supplied text.","The exact date/time of departure/arrival and meeting schedule in Pakistan is not specified.","Whether the talks are confirmed by Iran or Pakistan is not stated in the provided excerpt.","The excerpt does not confirm outcomes or probability of agreement\u2014only that talks are planned."],"key_facts":["Politico.com reports Trump is sending JD Vance, Richard Witkoff, and Jared Kushner to Pakistan for ceasefire talks with Iran.","The reporting indicates JD Vance will lead the US delegation.","The talks are described as taking place on Saturday (near-term timing)."],"numeric_claims":[],"primary_claim":"JD Vance, Richard Witkoff, and Jared Kushner are being sent to Pakistan to participate in ceasefire talks with Iran, with Vance leading the US delegation on Saturday.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"Politico reports that Trump is sending JD Vance, Richard Witkoff, and Jared Kushner to Pakistan to hold ceasefire talks with Iran, with Vance leading the US delegation. The talks are described as starting on Saturday, creating a near-term catalyst for US-Iran de-escalation expectations.","topics":["US-Iran ceasefire talks","diplomacy","Middle East conflict de-escalation","delegation leadership","Islamabad talks"]},"source":"politico.com","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump sending Vance, Witkoff and Kushner to Pakistan for ceasefire talks with Iran politico.com Vance to lead US delegation to Iran talks on Saturday Reuters Vance to Take the Lead on Iran Talks, Stocks Jump and Oil Plummets on Cease-fire News | What\u2019s News for April 8 WSJ Middle East war live: JD Vance to lead US delegation in Islamabad talks Financial Times US-Iran Ceasefire Claims Diverge as Hormuz Stays Blocked Bloomberg.com","title":"Trump sending Vance, Witkoff and Kushner to Pakistan for ceasefire talks with Iran - politico.com","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 8542 in events