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-09T22:31:38.760600+00:00","dedupe_key":"signal_enriched:news_delta:f97cb4e7206345dd","evidence_event_ids":["evt_0dafa4d5b709"],"signal_type":"news_headline_delta","source":"news_rss","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

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 11494 in events