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-20T20:05:38.931558+00:00","dedupe_key":"signal_enriched:news_delta:0d343f0b972e0a24","evidence_event_ids":["evt_f1b0c0486d50"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE5GVXBreWhSM3hHQ01wZkdzOHpfeWlHNGF5NV9WdGFIT1Y0SHVPOHYwd3FWbHVWaDgtNnJqQUJnOWxoUEdPRjAzU0E4OEdGUmQ3X3BQY210T2phdjA4ZVNQWTFveFNjeTI2TFBqVVl6dVBWQ1dfaW4wbXJR?oc=5","as_of":"2026-04-20T20:05:38.931558+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE5GVXBreWhSM3hHQ01wZkdzOHpfeWlHNGF5NV9WdGFIT1Y0SHVPOHYwd3FWbHVWaDgtNnJqQUJnOWxoUEdPRjAzU0E4OEdGUmQ3X3BQY210T2phdjA4ZVNQWTFveFNjeTI2TFBqVVl6dVBWQ1dfaW4wbXJR?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_db7a8343431ea6d1","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T00:05:11.236558+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE5GVXBreWhSM3hHQ01wZkdzOHpfeWlHNGF5NV9WdGFIT1Y0SHVPOHYwd3FWbHVWaDgtNnJqQUJnOWxoUEdPRjAzU0E4OEdGUmQ3X3BQY210T2phdjA4ZVNQWTFveFNjeTI2TFBqVVl6dVBWQ1dfaW4wbXJR?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/CBMiekFVX3lxTE5GVXBreWhSM3hHQ01wZkdzOHpfeWlHNGF5NV9WdGFIT1Y0SHVPOHYwd3FWbHVWaDgtNnJqQUJnOWxoUEdPRjAzU0E4OEdGUmQ3X3BQY210T2phdjA4ZVNQWTFveFNjeTI2TFBqVVl6dVBWQ1dfaW4wbXJR?oc=5","source_event_id":"evt_f1b0c0486d50","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"d757a81a50a7b973","published_at":"2026-04-20T19:45:55+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Iran War Live Updates: Trump Officials and Iran Plan New Talks Despite Mixed Messages - The New York Times","Source summary: Iran War Live Updates: Trump Officials and Iran Plan New Talks Despite Mixed Messages The New York Times JD Vance to lead US delegation in Pakistan if Iran agrees to talks The Guardian US delegation led by JD Vance heads to Pakistan for Iran ceasefire talks The Jerusalem Post Trump muses about Vance vs. Rubio as Iran peace talks heat up CNN Iran war live updates: Vance expected to travel to Pakistan on Tuesday - ABC7"],"numeric_claims":[],"primary_claim":"Iran War Live Updates: Trump Officials and Iran Plan New Talks Despite Mixed Messages - The New York Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Iran War Live Updates: Trump Officials and Iran Plan New Talks Despite Mixed Messages The New York Times JD Vance to lead US delegation in Pakistan if Iran agrees to talks The Guardian US delegation led by JD Vance heads to Pakistan for Iran ceasefire talks The Jerusalem Post Trump muses about Vance vs. Rubio as Iran peace talks heat up CNN Iran war live updates: Vance expected to travel to Pakist","topics":["news headline"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Iran War Live Updates: Trump Officials and Iran Plan New Talks Despite Mixed Messages The New York Times JD Vance to lead US delegation in Pakistan if Iran agrees to talks The Guardian US delegation led by JD Vance heads to Pakistan for Iran ceasefire talks The Jerusalem Post Trump muses about Vance vs. Rubio as Iran peace talks heat up CNN Iran war live updates: Vance expected to travel to Pakistan on Tuesday - ABC7 New York ABC7 New York","title":"Iran War Live Updates: Trump Officials and Iran Plan New Talks Despite Mixed Messages - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAgCAA2YBAwpA/d=1/ed=1/rs=ALs0n2OvQgcBFbGEQHisaePTgNFsUePnGA/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 467299 in events