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-08T21:48:34.475360+00:00","dedupe_key":"signal_enriched:news_delta:832cecb83fbaaeed","evidence_event_ids":["evt_7a6dc262b20d"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5pUlQ5V2huWm9sUVk4cGFJQU5NTFBpYlpCaHotZTJuOUp4THFVNHRGMU1ldWI3eGFxRVVkTUNzWktyUlpBUlczZTVtSzBSWXBDbUplWjhFU0Y2Zw?oc=5","as_of":"2026-04-08T21:48:34.475360+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-09T22:14:31.520093+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_7a6dc262b20d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"03b58ff3547466e7","published_at":"2026-04-08T20:15:35+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":"driving party in the ceasefire plan","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"counterparty in the ceasefire plan","symbol":"","type":"country"},{"asset_class":"media","name":"BBC","relevance":"source of the headline","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["No specific oil price level, percentage move, or time window is provided in the supplied text.","No specific stock index or sector is named for the \u201cshares jump.\u201d","The ceasefire plan\u2019s terms, timing, and whether it is confirmed vs. proposed are not detailed in the provided excerpt.","The excerpt includes additional commentary from other outlets (e.g., \u201cdon\u2019t expect $3 gas anytime soon\u201d) but does not provide the underlying evidence or timeframe."],"key_facts":["BBC headline states oil prices plunged following a US-Iran ceasefire plan.","BBC headline states shares jumped following the same US-Iran ceasefire plan.","The provided source summary frames the move as a relief rally tied to ceasefire-related expectations."],"numeric_claims":[],"primary_claim":"Oil prices plunged and shares jumped after a US-Iran ceasefire plan was reported.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"BBC reports that oil prices fell sharply while US shares rose following a US-Iran ceasefire plan, described as sparking a relief rally. The headline also implies near-term market optimism tied to the ceasefire, though it cautions that consumer fuel-price relief may not be immediate.","topics":["US-Iran ceasefire","oil prices","equity market rally","risk sentiment","Middle East tensions"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Oil prices plunge and shares jump on US-Iran ceasefire plan BBC Oil is plunging, but don\u2019t expect $3 gas anytime soon. Here\u2019s why CNN Trump teases 'Golden Age for the Middle East' under tense ceasefire as oil prices dip KOMO Stock market today: Dow, S&P 500, Nasdaq surge, oil plunges after US-Iran ceasefire sparks relief rally finance.yahoo.com Will consumers feel immediate relief if US, Iran ceasefire holds? ABC7 New York","title":"Oil prices plunge and shares jump on US-Iran ceasefire plan - BBC","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 8455 in events