Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 18503 in events
seq
Primary key.
INTEGER
id
evt_0792a9de6b0e
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-10T17:18:02.323141+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-10T17:15:05.985675+00:00","dedupe_key":"signal_enriched:news_delta:136d13ac2a0da8a0","evidence_event_ids":["evt_73a2ee31b6e7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOekdPWWdQY19VM2pLZEJrMk9GUmV5Z3JDT1VYVkdZS0owTGlEcXptZ3E2T0hpblJnWkJBUzIyYVNZS0tQeExCc0E3T2VGU0QycENPbm1iQURDdzV0ZlRFMXRIZjN2b0I1UnpMbkxwbmUzRjhYTEZSWEU1NjZ3OTJWTGdlZnpIaDdCY0FsWWhuMWdDd9IBlwFBVV95cUxQNHVrbkQ1UHdGencwblY3UXNjaTE4MjBTWWxoOVdibTFxbDIxYkFJWXJzVWtGcGI1LXZJNjFySUNmbHNaTEE5MGZiSnRPVzM4M09NWEVSZUhQdWo0SXVxejdQcHBPclNUTWRzTFctSGZoa0plY0FxS002MUxwVG5manpycWlDR1pmakVHOWs4MXlNODBRUGtj?oc=5","as_of":"2026-04-10T17:15:05.985675+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/CBMikgFBVV95cUxOekdPWWdQY19VM2pLZEJrMk9GUmV5Z3JDT1VYVkdZS0owTGlEcXptZ3E2T0hpblJnWkJBUzIyYVNZS0tQeExCc0E3T2VGU0QycENPbm1iQURDdzV0ZlRFMXRIZjN2b0I1UnpMbkxwbmUzRjhYTEZSWEU1NjZ3OTJWTGdlZnpIaDdCY0FsWWhuMWdDd9IBlwFBVV95cUxQNHVrbkQ1UHdGencwblY3UXNjaTE4MjBTWWxoOVdibTFxbDIxYkFJWXJzVWtGcGI1LXZJNjFySUNmbHNaTEE5MGZiSnRPVzM4M09NWEVSZUhQdWo0SXVxejdQcHBPclNUTWRzTFctSGZoa0plY0FxS002MUxwVG5manpycWlDR1pmakVHOWs4MXlNODBRUGtj?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0a53fdc790b5bc4e","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-10T17:18:02.323106+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOekdPWWdQY19VM2pLZEJrMk9GUmV5Z3JDT1VYVkdZS0owTGlEcXptZ3E2T0hpblJnWkJBUzIyYVNZS0tQeExCc0E3T2VGU0QycENPbm1iQURDdzV0ZlRFMXRIZjN2b0I1UnpMbkxwbmUzRjhYTEZSWEU1NjZ3OTJWTGdlZnpIaDdCY0FsWWhuMWdDd9IBlwFBVV95cUxQNHVrbkQ1UHdGencwblY3UXNjaTE4MjBTWWxoOVdibTFxbDIxYkFJWXJzVWtGcGI1LXZJNjFySUNmbHNaTEE5MGZiSnRPVzM4M09NWEVSZUhQdWo0SXVxejdQcHBPclNUTWRzTFctSGZoa0plY0FxS002MUxwVG5manpycWlDR1pmakVHOWs4MXlNODBRUGtj?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOekdPWWdQY19VM2pLZEJrMk9GUmV5Z3JDT1VYVkdZS0owTGlEcXptZ3E2T0hpblJnWkJBUzIyYVNZS0tQeExCc0E3T2VGU0QycENPbm1iQURDdzV0ZlRFMXRIZjN2b0I1UnpMbkxwbmUzRjhYTEZSWEU1NjZ3OTJWTGdlZnpIaDdCY0FsWWhuMWdDd9IBlwFBVV95cUxQNHVrbkQ1UHdGencwblY3UXNjaTE4MjBTWWxoOVdibTFxbDIxYkFJWXJzVWtGcGI1LXZJNjFySUNmbHNaTEE5MGZiSnRPVzM4M09NWEVSZUhQdWo0SXVxejdQcHBPclNUTWRzTFctSGZoa0plY0FxS002MUxwVG5manpycWlDR1pmakVHOWs4MXlNODBRUGtj?oc=5","source_event_id":"evt_73a2ee31b6e7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"01ff9ce3609ff10b","published_at":"2026-04-10T14:20:13+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"JD Vance","relevance":"primary spokesperson/actor","symbol":"","type":"person"},{"asset_class":"sovereign","name":"United States","relevance":"negotiating party","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"negotiating party","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Pakistan","relevance":"travel destination ahead of negotiations","symbol":"","type":"country"},{"asset_class":"","name":"CNBC","relevance":"reported source","symbol":"","type":"media_source"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not usable for extracting details beyond the headline/source summary; specific quotes, timing, and negotiation agenda are not present.","No specific date/time for the negotiations is included in the provided material.","The claim that the Strait of Hormuz is closed is only mentioned in the multi-outlet source summary; it is unclear whether CNBC explicitly reported that detail in the same item.","No concrete policy actions, deal terms, or expected outcomes are specified\u2014only Vance\u2019s expectation and a warning to Iran are indicated."],"key_facts":["CNBC headline states JD Vance expects U.S. negotiations with Iran on the war to be \u2018positive\u2019.","CNBC framing indicates Vance made the comment as he departs for Pakistan.","Additional provided source summary snippets (from other outlets) indicate Vance warned Iran not to \u2018try to play\u2019 the U.S. in peace talks.","The provided summary mentions the Strait of Hormuz remains closed (context for heightened regional risk), but the specific linkage to the CNBC item is not fully detailed in the cleaned text."],"numeric_claims":[],"primary_claim":"JD Vance expects U.S.-Iran negotiations on the war to be \u2018positive\u2019 as he heads to Pakistan.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"CNBC reports that U.S. Vice President JD Vance expects U.S. negotiations with Iran over the war to be \u2018positive\u2019 as he departs for Pakistan. The signal also references Vance warning Iran not to \u2018try to play\u2019 the U.S. in peace talks amid ongoing regional tensions.","topics":["U.S.-Iran negotiations","JD Vance travel","peace talks","war de-escalation expectations","regional security"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"Vance expects U.S. negotiations with Iran on war will be \u2018positive' CNBC Iran War News Live Updates\u2014JD Vance Warns Iran: Don\u2019t \u2018Try to Play Us\u2019 WSJ Live updates: Don't try to play the U.S. in peace talks, Vance warns Iran, as Strait of Hormuz remains closed NBC News Live updates: Vance heads to Pakistan ahead of negotiations for permanent deal with Iran AP News JD Vance expects \u2018positive\u2019 US-Iran war talks as he departs for Pakistan Al Jazeera","title":"Vance expects U.S. negotiations with Iran on war will be \u2018positive' - CNBC","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
candidate:sc_0a53fdc790b5bc4e
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:news_delta:136d13ac2a0da8a0
TEXT
episode_id
NULL
TEXT
created_at
2026-04-10T17:18:02.323200+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel