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-07T00:26:15.463753+00:00","dedupe_key":"signal_enriched:news_delta:b54c4ffa2d03df07","evidence_event_ids":["evt_f21d19a5f0e9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?oc=5","as_of":"2026-04-07T00:26:15.463753+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9c4853b0680da4ea","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T14:19:26.324947+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?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/CBMiWkFVX3lxTE1GdjZJMDN5NVBkQ1hkX2RUUHBRQURRT2RsRU5qZEl1eGt5OUZXeDdjWTlIdVFRMmZ4VnVQUnJvT0dJMTFDUXRYT1lZMGJNZ1h3M256cmxOdjRnUQ?oc=5","source_event_id":"evt_f21d19a5f0e9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f70eef618ba58037","published_at":"2026-04-06T23:34:11+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"shipping","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geopolitical location"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"IR","type":"country"}],"event_type":"supply_disruption","information_gaps":["Specific countries involved in the transits are not mentioned.","Details on the nature of the crisis affecting shipping are unclear."],"key_facts":["15 ships transited the Strait of Hormuz in 24 hours.","Traffic is at its highest in weeks."],"numeric_claims":[{"label":"Number of ships transiting","value":"15"},{"label":"Traffic increase duration","value":"highest in weeks"}],"primary_claim":"15 ships transited the Strait of Hormuz in 24 hours, marking the highest traffic in weeks according to Iranian media.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"The Strait of Hormuz is experiencing increased shipping traffic, with reports of 15 ships transiting in a 24-hour period, indicating a rise in maritime activity amid ongoing tensions.","topics":["shipping","geopolitics","Strait of Hormuz","Iran"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Which Asian countries are passing through the Strait of Hormuz? BBC 15 Ships Transit Strait of Hormuz in 24 Hours, Iranian Media Says WSJ Hormuz Traffic Rises to Highest in Weeks as More Transits Agreed Bloomberg.com Beyond oil: 9 commodities impacted by the Strait of Hormuz crisis The World Economic Forum Shipping Industry Uncertain As Hormuz Crisis Carries On news.usni.org","title":"Which Asian countries are passing through the Strait of Hormuz? - BBC","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 37978 in events