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-06T16:28:37.132657+00:00","dedupe_key":"signal_enriched:news_delta:d7a6da656e4a0a05","evidence_event_ids":["evt_afaef7f9ffd9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi5wFBVV95cUxPalNHeEg1WlpHblpRdVpqLVNTWWRlYk40bWtzdkF5V29wTHllR3NVNE1TMzNwd0dscDcxVFVVb2E5QWpWbGgzajJERXU5TVVwWEpHWFZGdVZPYVJFT3pibTl4d19ZeGo3Tnhub085TGJYWVA2Qm9mek9CYXVGRURhb1M5OHFRQVRvMk5Ha0JPMFFZc2dRQ0ZqblFEQjAwYk9seTFaMFAyQldIUHZDY0p3RXVYbGNkYURsQldJVHcycmNPTElEZnh5bUcwaHVOM09Sa3JKOWxsRV9DcTFsOEsxdEw5blpiTHM?oc=5","as_of":"2026-04-06T16:28:37.132657+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/CBMi5wFBVV95cUxPalNHeEg1WlpHblpRdVpqLVNTWWRlYk40bWtzdkF5V29wTHllR3NVNE1TMzNwd0dscDcxVFVVb2E5QWpWbGgzajJERXU5TVVwWEpHWFZGdVZPYVJFT3pibTl4d19ZeGo3Tnhub085TGJYWVA2Qm9mek9CYXVGRURhb1M5OHFRQVRvMk5Ha0JPMFFZc2dRQ0ZqblFEQjAwYk9seTFaMFAyQldIUHZDY0p3RXVYbGNkYURsQldJVHcycmNPTElEZnh5bUcwaHVOM09Sa3JKOWxsRV9DcTFsOEsxdEw5blpiTHM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_91a0c9943856e0e5","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-06T17:08:48.773631+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi5wFBVV95cUxPalNHeEg1WlpHblpRdVpqLVNTWWRlYk40bWtzdkF5V29wTHllR3NVNE1TMzNwd0dscDcxVFVVb2E5QWpWbGgzajJERXU5TVVwWEpHWFZGdVZPYVJFT3pibTl4d19ZeGo3Tnhub085TGJYWVA2Qm9mek9CYXVGRURhb1M5OHFRQVRvMk5Ha0JPMFFZc2dRQ0ZqblFEQjAwYk9seTFaMFAyQldIUHZDY0p3RXVYbGNkYURsQldJVHcycmNPTElEZnh5bUcwaHVOM09Sa3JKOWxsRV9DcTFsOEsxdEw5blpiTHM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi5wFBVV95cUxPalNHeEg1WlpHblpRdVpqLVNTWWRlYk40bWtzdkF5V29wTHllR3NVNE1TMzNwd0dscDcxVFVVb2E5QWpWbGgzajJERXU5TVVwWEpHWFZGdVZPYVJFT3pibTl4d19ZeGo3Tnhub085TGJYWVA2Qm9mek9CYXVGRURhb1M5OHFRQVRvMk5Ha0JPMFFZc2dRQ0ZqblFEQjAwYk9seTFaMFAyQldIUHZDY0p3RXVYbGNkYURsQldJVHcycmNPTElEZnh5bUcwaHVOM09Sa3JKOWxsRV9DcTFsOEsxdEw5blpiTHM?oc=5","source_event_id":"evt_afaef7f9ffd9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7395a19e43ff7a61","published_at":"2026-04-06T12:33:45+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"U.S.","relevance":"high","symbol":"USA","type":"country"},{"asset_class":"political","name":"Iran","relevance":"high","symbol":"IRN","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Details on the specific terms of the proposed cease-fire are not provided.","The stance of Iran regarding the cease-fire is unclear."],"key_facts":["Cease-fire discussions are ongoing but not yet agreed upon by Iran or the U.S.","The push for a cease-fire is linked to a deadline regarding the Hormuz Strait."],"numeric_claims":[],"primary_claim":"U.S. and regional mediators are pushing for a 45-day cease-fire with Iran.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"U.S. and regional mediators are advocating for a 45-day cease-fire with Iran amid ongoing tensions, particularly as a deadline approaches related to the Hormuz Strait.","topics":["cease-fire","Iran","U.S. foreign policy","Middle East tensions"]},"source":"wsj.com","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"U.S., Regional Mediators Push for 45-Day Cease-Fire With Iran wsj.com Live updates: Iran war ceasefire for 45 days 'being discussed,' official says, ahead of Trump's Hormuz deadline NBC News U.S. and Iran haven't backed ceasefire idea as Trump's Hormuz Strait deadline nears CNBC Pakistan offers \u2018two-phased\u2019 truce deal to end US-Israel war on Iran Al Jazeera Iran War: New Trump Deadline Looms as Ceasefire Push Keeps Markets on Edge Bloomberg.com","title":"U.S., Regional Mediators Push for 45-Day Cease-Fire With Iran - wsj.com","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 32468 in events