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-08T03:15:56.643489+00:00","dedupe_key":"signal_enriched:news_delta:c516dd159693e099","evidence_event_ids":["evt_d3d8ac120c50"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxNcllYOEthNEVMQW9TZmtvd2pYNzVxRVl5NkJHMTVSZUxIOVBsZVpQbkphLWpwcFhvanJXVXBjMExCZ25senFBX1lqQXVnRmxvd3BxbjhRT1IzSm5nbGwzUXBQRkhNQmVFU3dKU0E5V19XclFxVURvWEpWTzlOcnNXdEVFNTVYSDJjblZzTUppQU1MWFVkRS1xdS00ZlZDTm5HdFhwcWxYc1RDanktOEFXZjh3?oc=5","as_of":"2026-04-08T03:15:56.643489+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/CBMisgFBVV95cUxNcllYOEthNEVMQW9TZmtvd2pYNzVxRVl5NkJHMTVSZUxIOVBsZVpQbkphLWpwcFhvanJXVXBjMExCZ25senFBX1lqQXVnRmxvd3BxbjhRT1IzSm5nbGwzUXBQRkhNQmVFU3dKU0E5V19XclFxVURvWEpWTzlOcnNXdEVFNTVYSDJjblZzTUppQU1MWFVkRS1xdS00ZlZDTm5HdFhwcWxYc1RDanktOEFXZjh3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_255eb7c1d03d9c67","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-08T03:48:21.236389+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxNcllYOEthNEVMQW9TZmtvd2pYNzVxRVl5NkJHMTVSZUxIOVBsZVpQbkphLWpwcFhvanJXVXBjMExCZ25senFBX1lqQXVnRmxvd3BxbjhRT1IzSm5nbGwzUXBQRkhNQmVFU3dKU0E5V19XclFxVURvWEpWTzlOcnNXdEVFNTVYSDJjblZzTUppQU1MWFVkRS1xdS00ZlZDTm5HdFhwcWxYc1RDanktOEFXZjh3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxNcllYOEthNEVMQW9TZmtvd2pYNzVxRVl5NkJHMTVSZUxIOVBsZVpQbkphLWpwcFhvanJXVXBjMExCZ25senFBX1lqQXVnRmxvd3BxbjhRT1IzSm5nbGwzUXBQRkhNQmVFU3dKU0E5V19XclFxVURvWEpWTzlOcnNXdEVFNTVYSDJjblZzTUppQU1MWFVkRS1xdS00ZlZDTm5HdFhwcWxYc1RDanktOEFXZjh3?oc=5","source_event_id":"evt_d3d8ac120c50","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f8dd92bf999b8518","published_at":"2026-04-07T22:20:22+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Pakistan","relevance":"primary actor seeking ceasefire/extension","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States (Trump)","relevance":"deadline referenced in the request","symbol":"","type":"government/leader"},{"asset_class":"sovereign","name":"Iran","relevance":"subject of the U.S. deadline and ceasefire context","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The exact date/time of Trump\u2019s deadline is not provided in the provided text.","The specific terms/conditions of the ceasefire are not included in the provided Reuters headline/summaries.","Whether the U.S. has agreed to the extension (or is considering it) is not stated in the provided text.","The Reuters article\u2019s details on which parties are included in the ceasefire are not provided here."],"key_facts":["Reuters reports Pakistan is seeking a two-week ceasefire.","Reuters reports Pakistan is seeking an extension to Trump\u2019s deadline on Iran."],"numeric_claims":[{"label":"ceasefire duration","value":"two-week"}],"primary_claim":"Pakistan is seeking a two-week ceasefire and an extension to Trump\u2019s deadline on Iran.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Pakistan is seeking a two-week ceasefire and an extension to a U.S. deadline related to Iran, according to Reuters. The near-term catalyst is the timing around the U.S. deadline and the proposed two-week pause in hostilities.","topics":["ceasefire talks","Iran-U.S. deadline","Pakistan foreign policy","Middle East conflict risk","diplomatic negotiations"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Pakistan seeks two-week ceasefire, extension to Trump's deadline on Iran Reuters Did Trump\u2014Or Another U.S. Partner\u2014Actually Write Pakistan PM Sharif\u2019s X Post? Forbes Middle East crisis live: Pakistan says Iran war ceasefire includes Lebanon; Tehran will allow \u2018conditional passage\u2019 through strait of Hormuz The Guardian 'A whole civilization will die tonight': Oil falls as Trump's deadline looms, Pakistan calls for peace Yahoo Finance Markets cheer as Trump says he\u2019s in \u2018heated negotiations\u2019 over a new Pakistani two-week ceasefire plan fortune.com","title":"Pakistan seeks two-week ceasefire, extension to Trump's deadline on Iran - Reuters","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 4291 in events