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-08T23:28:56.638728+00:00","dedupe_key":"signal_enriched:news_delta:87dfb179291b8b87","evidence_event_ids":["evt_66eb6889a3a7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxOVGFKcUdSc3hXaGRDYkRUVTkyU05vb0JqSklXMlF0Z3pOdDBieTlXRzd1Sjh4dG5ZSER5QkpfQTlLekVZc2FaYjNBNmpCVG91UXU4WDU5eF9RSFRiRkt0Zld5cXVHX0RtQndSdDBfb2hPMnEtX1pDTEJtakp2dXo0WGxxaW9nODlpNGkwSV9fVVM3anRMa1hTNEdKQzZkVjk4QUx3SVVRc3JhMlhxLXhlcjZTR3FiQQ?oc=5","as_of":"2026-04-08T23:28:56.638728+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/CBMitgFBVV95cUxOVGFKcUdSc3hXaGRDYkRUVTkyU05vb0JqSklXMlF0Z3pOdDBieTlXRzd1Sjh4dG5ZSER5QkpfQTlLekVZc2FaYjNBNmpCVG91UXU4WDU5eF9RSFRiRkt0Zld5cXVHX0RtQndSdDBfb2hPMnEtX1pDTEJtakp2dXo0WGxxaW9nODlpNGkwSV9fVVM3anRMa1hTNEdKQzZkVjk4QUx3SVVRc3JhMlhxLXhlcjZTR3FiQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a65716071d27da56","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:19:10.307972+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxOVGFKcUdSc3hXaGRDYkRUVTkyU05vb0JqSklXMlF0Z3pOdDBieTlXRzd1Sjh4dG5ZSER5QkpfQTlLekVZc2FaYjNBNmpCVG91UXU4WDU5eF9RSFRiRkt0Zld5cXVHX0RtQndSdDBfb2hPMnEtX1pDTEJtakp2dXo0WGxxaW9nODlpNGkwSV9fVVM3anRMa1hTNEdKQzZkVjk4QUx3SVVRc3JhMlhxLXhlcjZTR3FiQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxOVGFKcUdSc3hXaGRDYkRUVTkyU05vb0JqSklXMlF0Z3pOdDBieTlXRzd1Sjh4dG5ZSER5QkpfQTlLekVZc2FaYjNBNmpCVG91UXU4WDU5eF9RSFRiRkt0Zld5cXVHX0RtQndSdDBfb2hPMnEtX1pDTEJtakp2dXo0WGxxaW9nODlpNGkwSV9fVVM3anRMa1hTNEdKQzZkVjk4QUx3SVVRc3JhMlhxLXhlcjZTR3FiQQ?oc=5","source_event_id":"evt_66eb6889a3a7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e49c357a89423077","published_at":"2026-04-08T15:08:26+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Saturday"],"entities":[{"asset_class":"sovereign","name":"Pakistan","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"individual","name":"JD Vance","relevance":"high","symbol":"","type":"person"},{"asset_class":"location","name":"Islamabad","relevance":"high","symbol":"","type":"city"},{"asset_class":"sovereign","name":"Lebanon","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual Bloomberg article content; extraction is therefore based on the provided headline and source summary rather than the full article body.","The specific date (calendar day/month) for \u201cSaturday\u201d is not provided in the supplied text.","No details are provided on the agenda, format, or expected outcomes of the talks.","The source summary references Israel strikes and ceasefire risk, but the specific ceasefire and its status are not defined in the supplied text."],"key_facts":["Pakistan said Iran confirmed it will attend talks with the US in Islamabad.","The US delegation is led by JD Vance.","Multiple outlets describe the talks as occurring in Islamabad on Saturday.","The reporting context notes Israel strikes on Lebanon that imperil a ceasefire (per the provided source summary)."],"numeric_claims":[],"primary_claim":"Pakistan stated that Iran confirmed it will attend talks with the United States in Islamabad, with JD Vance leading the US delegation.","relevance_score":0.78,"sentiment":"neutral","source_quality":"high","summary":"Pakistan says Iran has confirmed it will attend US-Iran talks in Islamabad. The US delegation is led by JD Vance, with the talks scheduled for Saturday amid heightened Middle East ceasefire risk.","topics":["US-Iran talks","diplomacy","ceasefire risk","Middle East conflict","delegation leadership","Islamabad meeting"]},"source":"Bloomberg","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Pakistan Says Iran Confirms to Attend Talks With US in Islamabad Bloomberg Vance to lead US in talks with Iran as Israel strikes on Lebanon imperil ceasefire - as it happened Reuters Vance to lead U.S. delegation at peace talks with Iran in Pakistan on Saturday Axios US-Iran ceasefire tested. JD Vance to travel to Pakistan. Live updates. USA Today Middle East war live: JD Vance to lead US delegation in Islamabad talks Financial Times","title":"Pakistan Says Iran Confirms to Attend Talks With US in Islamabad - Bloomberg","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 8588 in events