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-09T04:35:26.085945+00:00","dedupe_key":"signal_enriched:news_delta:c2af1e6784d51304","evidence_event_ids":["evt_64896905f007"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5","as_of":"2026-04-09T04:35:26.085945+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/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f908b4356d684e98","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-09T22:37:13.072941+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxQSVJHUFZWMU9xUGhyNVlHWnd3eTB1OVJWTFFPUDJIOVdOTXN4QWRfc3IyZFV6T0lKQTFJNkVkVFlwQ3pISGlrY3N1MGNWajdsbWNtSEVSdjBLVGw0MlhVV0xoT1h0R05neTdLekNYb1pMY2xLSVBBM1FncnNvUzAzdno2OVFuT3ZQQVV1SFNSQ1lKZ0dk?oc=5","source_event_id":"evt_64896905f007","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aa8ac7e1cffc9f24","published_at":"2026-04-09T04:01:00+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary source of the ceasefire-violation claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"counterparty in the ceasefire referenced by the headline","symbol":"","type":"country"},{"asset_class":"equity_index_futures","name":"US stock index futures","relevance":"directly referenced as wavering","symbol":"","type":"market instrument"},{"asset_class":"commodity","name":"Oil","relevance":"described as plunging in the provided source summary","symbol":"WTI/Brent (unspecified)","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["No details on who/what allegedly violated the ceasefire (location, incident, timing) are provided in the supplied text.","No specific oil price levels, percentage moves, or which benchmark (WTI vs Brent) are referenced.","No details on which specific US futures contracts or which equity/FX sectors moved are included in the supplied text.","Near-term catalyst timing (e.g., next scheduled talks, reports, or policy actions) is not specified in the provided content."],"key_facts":["Bloomberg headline indicates US futures are wavering amid Iran\u2019s statement that a ceasefire was violated.","Provided source summary states oil is plunging (exact magnitude not provided).","Provided source summary characterizes the US-Iran cease-fire as fragile (no specific terms/dates provided)."],"numeric_claims":[],"primary_claim":"US futures are wavering because Iran says the ceasefire was violated, contributing to market volatility.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Bloomberg reports US stock index futures are choppy as Iran claims a US-Iran ceasefire has been violated. The wrap also highlights sharp oil moves and broader market caution tied to a fragile US-Iran cease-fire.","topics":["US-Iran ceasefire","ceasefire violation claim","market volatility","oil price decline","energy market risk"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"US Futures Waver as Iran Says Ceasefire Violated: Markets Wrap Bloomberg.com Oil is plunging, but don\u2019t expect $3 gas anytime soon. Here\u2019s why CNN The third Gulf war will scar energy markets for a long time yet The Economist Oil Rebounds, Asian Equities Fall Amid Fragile U.S.-Iran Cease-Fire WSJ Transcript: The oil market navigates a shaky ceasefire Financial Times","title":"US Futures Waver as Iran Says Ceasefire Violated: Markets Wrap - Bloomberg.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 8911 in events