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-08T03:31:26.545347+00:00","dedupe_key":"signal_enriched:news_delta:832cecb83fbaaeed","evidence_event_ids":["evt_35c4c332fbbe"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5","as_of":"2026-04-08T03:31:26.545347+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/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_33301699d5bf0c22","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-08T03:49:35.026442+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5","source_event_id":"evt_35c4c332fbbe","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"03b58ff3547466e7","published_at":"2026-04-08T02:01:58+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"affected party (ceasefire counterpart)","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"affected party (ceasefire counterpart)","symbol":"","type":"country"},{"asset_class":"commodity_infrastructure","name":"Strait of Hormuz","relevance":"mechanism linking ceasefire to oil supply risk","symbol":"","type":"geographic chokepoint"},{"asset_class":"commodity","name":"Oil","relevance":"primary market moved (plunged)","symbol":"WTI/Brent (unspecified)","type":"commodity"},{"asset_class":"equities","name":"US stocks","relevance":"secondary market reaction (stocks rally mentioned in source summary)","symbol":"Dow/S&P 500/Nasdaq (unspecified)","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["The exact ceasefire duration (e.g., \u201ctwo-week\u201d) is mentioned only in the provided multi-source summary, not in the BBC headline text itself; duration details are therefore uncertain here.","The specific oil benchmark (WTI vs Brent) and the magnitude of the plunge (percent/absolute) are not provided in the extracted text.","The mechanism is described as \u201creopen Strait of Hormuz,\u201d but the operational details (what reopening means, when it occurs) are not included in the provided content.","Stock index levels and timing (intraday vs close) are not specified in the provided BBC headline text."],"key_facts":["A US-Iran ceasefire deal was announced (timing: near-term, per headline).","The deal is described as aimed at reopening the Strait of Hormuz.","Oil prices dropped sharply (\u201cplunges\u201d / \u201cbelow $100\u201d mentioned in the provided source summary).","Stocks reportedly rallied after the ceasefire announcement (per provided source summary)."],"numeric_claims":[{"label":"Oil price level","value":"below $100 (currency/benchmark unspecified)"}],"primary_claim":"Oil plunged following a US-Iran ceasefire deal intended to reopen the Strait of Hormuz.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Oil prices fell sharply after a US-Iran ceasefire deal was announced, with the expectation that it would reopen the Strait of Hormuz. The headline also implies a near-term risk-on reaction in broader markets (stocks rally) alongside the oil drop.","topics":["US-Iran ceasefire","Strait of Hormuz reopening","oil price move","market reaction (stocks)"]},"source":"bbc.com","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Oil plunges after US-Iran ceasefire deal to reopen Strait of Hormuz bbc.com Oil prices drop and stocks rally after Trump\u2019s ceasefire announcement CNN U.S.-Iran ceasefire relief rally lifts global assets as oil plunges below $100 CNBC Stock Market Today: Oil Jumps, Dow Dips After U.S. Raises the Temperature on Iran \u2014 Live Updates WSJ Stock market today: Dow, S&P 500, Nasdaq futures surge on news of a two-week ceasefire Yahoo Finance","title":"Oil plunges after US-Iran ceasefire deal to reopen Strait of Hormuz - bbc.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 4312 in events