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-08T15:16:35.296834+00:00","dedupe_key":"signal_enriched:news_delta:449d083b6b3344ef","evidence_event_ids":["evt_f7c70c112e9f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxNTXN1Q3ZqM2RJWXFYbG5vMTJ2dnpGb3B6dGZ3LUx0SmlDd2FQaThhb2hvaC1xSjdJci1acG4tMUhrSXZrZnhNbFJUdElVVW5rWnFVdzNkajV3QVJGNkRoczdPS1ZDejc1RDlhYXhIaXFmOXJnOGIwM2pSNXM2S0dRaHpaVFB4ei1jWkU4TTNsdXBpdWw2NzViaEN3?oc=5","as_of":"2026-04-08T15:16:35.296834+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/CBMimgFBVV95cUxNTXN1Q3ZqM2RJWXFYbG5vMTJ2dnpGb3B6dGZ3LUx0SmlDd2FQaThhb2hvaC1xSjdJci1acG4tMUhrSXZrZnhNbFJUdElVVW5rWnFVdzNkajV3QVJGNkRoczdPS1ZDejc1RDlhYXhIaXFmOXJnOGIwM2pSNXM2S0dRaHpaVFB4ei1jWkU4TTNsdXBpdWw2NzViaEN3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9a19a304011040f6","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-08T17:23:22.875126+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxNTXN1Q3ZqM2RJWXFYbG5vMTJ2dnpGb3B6dGZ3LUx0SmlDd2FQaThhb2hvaC1xSjdJci1acG4tMUhrSXZrZnhNbFJUdElVVW5rWnFVdzNkajV3QVJGNkRoczdPS1ZDejc1RDlhYXhIaXFmOXJnOGIwM2pSNXM2S0dRaHpaVFB4ei1jWkU4TTNsdXBpdWw2NzViaEN3?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/CBMimgFBVV95cUxNTXN1Q3ZqM2RJWXFYbG5vMTJ2dnpGb3B6dGZ3LUx0SmlDd2FQaThhb2hvaC1xSjdJci1acG4tMUhrSXZrZnhNbFJUdElVVW5rWnFVdzNkajV3QVJGNkRoczdPS1ZDejc1RDlhYXhIaXFmOXJnOGIwM2pSNXM2S0dRaHpaVFB4ei1jWkU4TTNsdXBpdWw2NzViaEN3?oc=5","source_event_id":"evt_f7c70c112e9f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a308f638d0cca735","published_at":"2026-04-08T13:38:31+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"equity_index","name":"Wall Street (US equities)","relevance":"high","symbol":"","type":"market"},{"asset_class":"commodity","name":"Oil prices","relevance":"high","symbol":"WTI/Brent (unspecified)","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["Which specific US equity index(es) opened higher (e.g., S&P 500, Dow, Nasdaq) is not specified.","Which oil benchmark is referenced (WTI vs Brent) is not specified.","The exact timing/date of the ceasefire agreement and the market open is not specified.","No details are provided on the terms/duration/verification mechanism of the ceasefire beyond the existence of an agreement."],"key_facts":["Reuters headline states Wall Street opened higher after a US-Iran ceasefire.","Source summary indicates oil prices plunged and stocks rose after the US and Iran agreed on a ceasefire.","Source summary cites a stocks surge of about 2.7% (index/ticker not specified).","Source summary references oil prices plunging toward ~$90 per barrel (benchmark not specified)."],"numeric_claims":[{"label":"Stocks move","value":"~+2.7% (surge; index not specified)"},{"label":"Oil price level","value":"~$90 per barrel (toward; benchmark not specified)"}],"primary_claim":"Wall Street opened higher after the US and Iran agreed on a ceasefire, while oil prices plunged and stocks surged.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"Wall Street opened higher following a US-Iran ceasefire agreement, with oil prices falling sharply as stocks rose. The ceasefire is the near-term catalyst driving risk-on sentiment and lower energy prices.","topics":["US-Iran ceasefire","equities open higher","oil price drop","risk sentiment","geopolitical de-escalation"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Wall Street opens higher after US-Iran ceasefire Reuters Oil prices plunge and stocks soar after U.S. and Iran agree on ceasefire NPR How soon will gas prices go down? Iran deal sends oil lower Asbury Park Press Oil prices plunge toward $90 a barrel and US stocks surge 2.7% after US and Iran reach cease-fire. Follow live updates. The Boston Globe Stock Market Today: Dow Futures Soar, Oil Plunges After U.S., Iran Walk Back From the Brink \u2014 Live Updates WSJ","title":"Wall Street opens higher after US-Iran ceasefire - 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

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 7477 in events