SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_96ab44f0e2b2 in signals