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-08T05:19:26.368885+00:00","dedupe_key":"signal_enriched:news_delta:256a3b87432ddd8c","evidence_event_ids":["evt_899ccc4bca8b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1QU3UySW1LYnlmZFhfQ3gwaldab3ZfSlhLMTN1OWlEcU83RE1sdEJadlB1TEw1a3J3MnlhQnkyMm56SnUwUkNpRFo2SlJnY210djJkbTBDcmUyZw?oc=5","as_of":"2026-04-08T05:19:26.368885+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/CBMiWkFVX3lxTE1QU3UySW1LYnlmZFhfQ3gwaldab3ZfSlhLMTN1OWlEcU83RE1sdEJadlB1TEw1a3J3MnlhQnkyMm56SnUwUkNpRFo2SlJnY210djJkbTBDcmUyZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fbb0ab753ac8a328","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-08T05:19:51.600263+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1QU3UySW1LYnlmZFhfQ3gwaldab3ZfSlhLMTN1OWlEcU83RE1sdEJadlB1TEw1a3J3MnlhQnkyMm56SnUwUkNpRFo2SlJnY210djJkbTBDcmUyZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1QU3UySW1LYnlmZFhfQ3gwaldab3ZfSlhLMTN1OWlEcU83RE1sdEJadlB1TEw1a3J3MnlhQnkyMm56SnUwUkNpRFo2SlJnY210djJkbTBDcmUyZw?oc=5","source_event_id":"evt_899ccc4bca8b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fca4d7a7744d1026","published_at":"2026-04-08T05:03:31+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Pakistan","relevance":"primary mediator/actor","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"ceasefire party","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"ceasefire party","symbol":"","type":"country"},{"asset_class":"geography","name":"Strait of Hormuz","relevance":"economic/military significance; referenced as being opened","symbol":"","type":"geographic chokepoint"}],"event_type":"geopolitical_risk","information_gaps":["The provided content does not include the specific mechanism of Pakistan\u2019s involvement (e.g., who met whom, what proposals were exchanged).","It is unclear whether the ceasefire has already been implemented or is pending confirmation at the time of reporting.","Details on what exactly \u201copening\u201d the Strait of Hormuz entails (scope, timeline, enforcement) are not present in the supplied text.","No explicit date of the ceasefire start/end is included in the provided excerpt."],"key_facts":["A BBC piece states Pakistan helped secure a fragile ceasefire between the US and Iran.","The ceasefire is described as lasting for two weeks (near-term timeframe).","The BBC summary indicates the ceasefire is associated with opening the Strait of Hormuz (as described in the provided text)."],"numeric_claims":[{"label":"ceasefire duration","value":"2 weeks"}],"primary_claim":"Pakistan helped secure a fragile US\u2013Iran ceasefire that is set for about two weeks and includes steps related to opening the Strait of Hormuz.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"BBC reports that Pakistan played a role in securing a fragile ceasefire between the US and Iran. The ceasefire is described as lasting about two weeks and is linked to steps involving the Strait of Hormuz.","topics":["US-Iran ceasefire","Pakistan mediation","Strait of Hormuz","regional security","oil shipping risk"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"How Pakistan helped secure a fragile ceasefire between the US and Iran BBC Amerika na Iran bemeranyije ku gahenge k'ibyumweru bibiri gafite ibisabwa hamwe no gufungura umuhora wa Hormuz BBC Opinion | The Iranian Advantage Is an Illusion The New York Times Markets cheer as Trump says he\u2019s in \u2018heated negotiations\u2019 over a new Pakistani two-week ceasefire plan Fortune Did Trump\u2014Or Another U.S. Partner\u2014Actually Write Pakistan PM Sharif\u2019s X Post? forbes.com","title":"How Pakistan helped secure a fragile ceasefire between the US and Iran - BBC","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 4712 in events