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/CBMitAFBVV95cUxQel9aX3VsMjYtMDdnOUZnY0NpVVJkbUYzX1BsZlRNRzFpY2VwaUkzVVhYcTc2LVhHdnVCQ2N4UURpVUZIX2F5dnRWbFBmUTRhRkNuYzBEWExSTGJxZDRhUnVwRURiVE1iVVEwZG9BWGFBR0JmbmNqei1KdGpRWF9ZWXhVMkxRX2ZGZTN5NjhnT2NDbXVIdDNXUDR4RGJuUHN4Z2ZyVkthb3VJRXNoZXJ5R25oOUE?oc=5","as_of":"2026-04-09T22:31:38.760600+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/CBMitAFBVV95cUxQel9aX3VsMjYtMDdnOUZnY0NpVVJkbUYzX1BsZlRNRzFpY2VwaUkzVVhYcTc2LVhHdnVCQ2N4UURpVUZIX2F5dnRWbFBmUTRhRkNuYzBEWExSTGJxZDRhUnVwRURiVE1iVVEwZG9BWGFBR0JmbmNqei1KdGpRWF9ZWXhVMkxRX2ZGZTN5NjhnT2NDbXVIdDNXUDR4RGJuUHN4Z2ZyVkthb3VJRXNoZXJ5R25oOUE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dc07719e13a7331e","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-10T00:44:03.131487+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQel9aX3VsMjYtMDdnOUZnY0NpVVJkbUYzX1BsZlRNRzFpY2VwaUkzVVhYcTc2LVhHdnVCQ2N4UURpVUZIX2F5dnRWbFBmUTRhRkNuYzBEWExSTGJxZDRhUnVwRURiVE1iVVEwZG9BWGFBR0JmbmNqei1KdGpRWF9ZWXhVMkxRX2ZGZTN5NjhnT2NDbXVIdDNXUDR4RGJuUHN4Z2ZyVkthb3VJRXNoZXJ5R25oOUE?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/CBMitAFBVV95cUxQel9aX3VsMjYtMDdnOUZnY0NpVVJkbUYzX1BsZlRNRzFpY2VwaUkzVVhYcTc2LVhHdnVCQ2N4UURpVUZIX2F5dnRWbFBmUTRhRkNuYzBEWExSTGJxZDRhUnVwRURiVE1iVVEwZG9BWGFBR0JmbmNqei1KdGpRWF9ZWXhVMkxRX2ZGZTN5NjhnT2NDbXVIdDNXUDR4RGJuUHN4Z2ZyVkthb3VJRXNoZXJ5R25oOUE?oc=5","source_event_id":"evt_0dafa4d5b709","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"50e65fa8fa0a1e22","published_at":"2026-04-09T14:22:46+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary actor attempting to formalize control","symbol":"","type":"country"},{"asset_class":"infrastructure","name":"Strait of Hormuz","relevance":"location where traffic is blocked","symbol":"","type":"maritime chokepoint"},{"asset_class":"media","name":"Bloomberg","relevance":"source of headline","symbol":"","type":"news outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/boilerplate, not the substantive Bloomberg content; only the headline and the provided source summary are usable.","No specific mechanism is quoted (e.g., naval actions, inspections, permits, or legal instruments) for how Iran is \u201cformalizing control.\u201d","No quantitative measure is included in the provided text (e.g., exact % decline in tanker traffic).","No timing details (exact date/time of formalization steps) are present in the provided material."],"key_facts":["Bloomberg headline states Hormuz traffic is still blocked while Iran tries to formalize control.","Source summary indicates Strait of Hormuz shipping traffic is effectively at a standstill despite an Iran ceasefire (NBC/WSJ/CNBC references in provided summary).","The signal implies the disruption is ongoing rather than resolved."],"numeric_claims":[],"primary_claim":"Strait of Hormuz shipping traffic is still effectively at a standstill because Iran is trying to formalize control.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Shipping traffic through the Strait of Hormuz remains effectively blocked even as Iran seeks to formalize control, according to Bloomberg. The near-term catalyst is the ongoing attempt to codify control, which is keeping oil tanker movement constrained.","topics":["Strait of Hormuz","Iran","maritime shipping disruption","oil tanker traffic","ceasefire/hostilities","control/formalization of chokepoint"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Hormuz Traffic Still Blocked as Iran Tries to Formalize Control Bloomberg.com Strait of Hormuz shipping traffic is effectively at a standstill despite Iran ceasefire NBC News See Which Ships Are Slipping Through the Strait of Hormuz WSJ Hormuz Strait oil traffic way down after ceasefire; Hassett says even one tanker is big deal CNBC The Hormuz War Will End The Atlantic","title":"Hormuz Traffic Still Blocked as Iran Tries to Formalize Control - 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_1420b5bc14fc in signals