SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_df2c1b316b13 in signals