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-09T10:33:00.472876+00:00","dedupe_key":"signal_enriched:news_delta:269b4550e632ae75","evidence_event_ids":["evt_3032c48e78f8"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxNRjJRM2tSUFdFUF9IdElwQ1UzdWJsOUNPV1BOMmRhQnRKa2xsZnpYNXVpZkQ4U3o1RDdrUzhGOUFPUTluR0RJbGk3QjNuVjFpQ3RaeU9lLXhvWDFMRTRWRl94NGdoblpvMUJwMXpDS2RyZXF2OXFwdUNqUDI2Y0tCby10b1NXWU5qbXVsRE5NMnpwSGZ1blhrbU9wOXBuUkk?oc=5","as_of":"2026-04-09T10:33:00.472876+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/CBMinwFBVV95cUxNRjJRM2tSUFdFUF9IdElwQ1UzdWJsOUNPV1BOMmRhQnRKa2xsZnpYNXVpZkQ4U3o1RDdrUzhGOUFPUTluR0RJbGk3QjNuVjFpQ3RaeU9lLXhvWDFMRTRWRl94NGdoblpvMUJwMXpDS2RyZXF2OXFwdUNqUDI2Y0tCby10b1NXWU5qbXVsRE5NMnpwSGZ1blhrbU9wOXBuUkk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cf5338735f686468","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-09T23:08:49.904569+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxNRjJRM2tSUFdFUF9IdElwQ1UzdWJsOUNPV1BOMmRhQnRKa2xsZnpYNXVpZkQ4U3o1RDdrUzhGOUFPUTluR0RJbGk3QjNuVjFpQ3RaeU9lLXhvWDFMRTRWRl94NGdoblpvMUJwMXpDS2RyZXF2OXFwdUNqUDI2Y0tCby10b1NXWU5qbXVsRE5NMnpwSGZ1blhrbU9wOXBuUkk?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/CBMinwFBVV95cUxNRjJRM2tSUFdFUF9IdElwQ1UzdWJsOUNPV1BOMmRhQnRKa2xsZnpYNXVpZkQ4U3o1RDdrUzhGOUFPUTluR0RJbGk3QjNuVjFpQ3RaeU9lLXhvWDFMRTRWRl94NGdoblpvMUJwMXpDS2RyZXF2OXFwdUNqUDI2Y0tCby10b1NXWU5qbXVsRE5NMnpwSGZ1blhrbU9wOXBuUkk?oc=5","source_event_id":"evt_3032c48e78f8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0d524bb31fc32e73","published_at":"2026-04-09T09:54:09+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"commodity","name":"Oil","relevance":"primary asset affected by the headline move","symbol":"WTI/Brent (not specified)","type":"commodity"},{"asset_class":"geopolitical/geography","name":"Strait of Hormuz","relevance":"stated driver of supply disruption risk","symbol":"","type":"geographic chokepoint"},{"asset_class":"geopolitical","name":"U.S.-Iran ceasefire","relevance":"described as under strain, affecting market expectations","symbol":"","type":"diplomatic agreement"},{"asset_class":"media","name":"Bloomberg","relevance":"source of the headline","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["Exact oil benchmark(s) (WTI vs Brent) and the magnitude/percentage of the rebound are not provided in the supplied text.","The timing of when Hormuz became blocked or whether it is expected to reopen is not specified.","The specific timing of the ceasefire (date/time) is not included in the provided excerpt.","The nature of the $950 million bet (instrument type, strike/expiry, direction confirmation) is not fully detailed in the excerpt.","Because the provided 'Article Text' appears to be largely unrelated page markup, only the headline and the provided source summary were used for grounded extraction."],"key_facts":["Oil is reported to be rising after its biggest drop since 2020.","The rebound is linked to Hormuz staying blocked (continued disruption risk).","The broader context includes expectations that $3 gas is not imminent (implying prices may remain elevated/volatile).","A U.S.-Iran ceasefire is described as coming under strain, which may affect near-term market direction.","Traders are reported to have placed a large options/futures bet on oil price falling ahead of the ceasefire (amount cited as $950 million)."],"numeric_claims":[{"label":"options/futures bet size","value":"$950 million"},{"label":"gas price reference","value":"$3 (stated as not expected soon)"}],"primary_claim":"Oil rises after its biggest drop since 2020 as Hormuz remains blocked.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Oil prices rebound after a sharp selloff, with the move attributed to continued blockage in the Strait of Hormuz. The signal also points to uncertainty around a U.S.-Iran ceasefire, which is described as under strain and a near-term catalyst for trading.","topics":["oil price","Hormuz blockade","energy market risk","U.S.-Iran ceasefire strain","short-term trading positioning"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Oil Rises After Biggest Drop Since 2020 as Hormuz Stays Blocked 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 Europe stocks rebound stalls as U.S-Iran ceasefire comes under strain CNBC Traders place large $950 million bet on oil price falling hours ahead of ceasefire Reuters","title":"Oil Rises After Biggest Drop Since 2020 as Hormuz Stays Blocked - 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 9712 in events