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/CBMigAFBVV95cUxPMEVFMUtBU0M0VXBGM25pbWk4b0hFNUxweGVNSFJDYTJlMUZjSnFuMXZicXNZNU9SZnhleEFaRVRQN1VUb0NJQ3RIYm9Fb0dLcjVKd3RuNVV3eXRCSm1yTzlURmdUWlN4NUZFQXBnZ29pR2Nxa0Y0YjlxRmNJc0Y5eQ?oc=5","as_of":"2026-04-10T19:36:11.901484+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/CBMigAFBVV95cUxPMEVFMUtBU0M0VXBGM25pbWk4b0hFNUxweGVNSFJDYTJlMUZjSnFuMXZicXNZNU9SZnhleEFaRVRQN1VUb0NJQ3RIYm9Fb0dLcjVKd3RuNVV3eXRCSm1yTzlURmdUWlN4NUZFQXBnZ29pR2Nxa0Y0YjlxRmNJc0Y5eQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_361bce96e0088125","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-10T20:15:12.618496+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxPMEVFMUtBU0M0VXBGM25pbWk4b0hFNUxweGVNSFJDYTJlMUZjSnFuMXZicXNZNU9SZnhleEFaRVRQN1VUb0NJQ3RIYm9Fb0dLcjVKd3RuNVV3eXRCSm1yTzlURmdUWlN4NUZFQXBnZ29pR2Nxa0Y0YjlxRmNJc0Y5eQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxPMEVFMUtBU0M0VXBGM25pbWk4b0hFNUxweGVNSFJDYTJlMUZjSnFuMXZicXNZNU9SZnhleEFaRVRQN1VUb0NJQ3RIYm9Fb0dLcjVKd3RuNVV3eXRCSm1yTzlURmdUWlN4NUZFQXBnZ29pR2Nxa0Y0YjlxRmNJc0Y5eQ?oc=5","source_event_id":"evt_e15c8c50d3f6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0f1821600334ab4e","published_at":"2026-04-10T17:15:54+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Vance","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Lebanon","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Pakistan","relevance":"medium","symbol":"","type":"country"},{"asset_class":"","name":"Islamabad","relevance":"medium","symbol":"","type":"city"},{"asset_class":"","name":"The New York Times","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"BBC","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"Reuters","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"USA Today","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"AP News","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not actually the article content (it appears to be page styling/HTML), so only the headline and the supplied source summary can be used.","The identity of \u201cVance\u201d is not fully specified in the provided text (e.g., full name/title).","The \u201cfive sticking points\u201d are not enumerated in the provided text.","No specific timing (date/time) for the talks is included beyond \u201cheads to\u201d / \u201cahead of negotiations.\u201d","No concrete terms of the proposed \u201cpermanent deal\u201d are included in the provided text.","The nature and actors of the \u201cLebanon impasse\u201d are not specified in the provided text."],"key_facts":["The New York Times headline states that Vance is heading to peace talks.","The headline states that a Lebanon impasse threatens a cease-fire.","The provided source summary references U.S.-Iran talks and \u201cfive sticking points\u201d for negotiations involving Islamabad (details not included in the provided text).","The provided source summary references Iran demands related to Lebanon ceasefire and \u201cunfreezing of assets\u201d before peace talks (details not included in the provided text).","The provided source summary states that Iran casts doubt over talks as Vance heads to Pakistan (details not included in the provided text).","The provided source summary indicates Vance is heading to Pakistan ahead of negotiations for a permanent deal with Iran (timing described as \u201cahead of negotiations,\u201d but exact date/time not provided)."],"numeric_claims":[],"primary_claim":"Vance is traveling to peace talks while a Lebanon impasse threatens a cease-fire, complicating efforts toward a broader Iran-related negotiation process.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The New York Times reports that U.S. Vice President candidate/official James Vance is heading to peace talks as a Lebanon cease-fire faces threats from an impasse. The coverage also references U.S.-Iran and related negotiation sticking points and notes Iran skepticism about talks.","topics":["Iran war live updates","peace talks","Lebanon cease-fire","U.S.-Iran negotiations","asset unfreezing","negotiation sticking points","Pakistan/Islamabad talks"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Iran War Live Updates: Vance Heads to Peace Talks as Lebanon Impasse Threatens Cease-Fire The New York Times US-Iran talks: The five sticking points for Islamabad negotiations BBC Iran demands Lebanon ceasefire, unfreezing of assets before peace talks Reuters Iran casts doubt over talks as Vance heads to Pakistan. Live updates. USA Today Live updates: Vance heads to Pakistan ahead of negotiations for permanent deal with Iran AP News","title":"Iran War Live Updates: Vance Heads to Peace Talks as Lebanon Impasse Threatens Cease-Fire - The New York Times","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_b918dd7df45c in signals