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-08T20:43:09.024596+00:00","dedupe_key":"signal_enriched:news_delta:3aa8eeea00ddabb9","evidence_event_ids":["evt_e5965f291161"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTFBNZEhFT29uaWtYVlJ6bTFaWGNMX25jUFA3R3FybkdESVdFdVE2NGRtTkZsMmRiYVFNeXpRTUZONEdxOGVwRjRzOTU0dENVdWFsQkxWcS03c3ZRUQ?oc=5","as_of":"2026-04-08T20:43:09.024596+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/CBMiWkFVX3lxTFBNZEhFT29uaWtYVlJ6bTFaWGNMX25jUFA3R3FybkdESVdFdVE2NGRtTkZsMmRiYVFNeXpRTUZONEdxOGVwRjRzOTU0dENVdWFsQkxWcS03c3ZRUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_518152814acd62e8","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-09T22:11:54.007069+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTFBNZEhFT29uaWtYVlJ6bTFaWGNMX25jUFA3R3FybkdESVdFdVE2NGRtTkZsMmRiYVFNeXpRTUZONEdxOGVwRjRzOTU0dENVdWFsQkxWcS03c3ZRUQ?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/CBMiWkFVX3lxTFBNZEhFT29uaWtYVlJ6bTFaWGNMX25jUFA3R3FybkdESVdFdVE2NGRtTkZsMmRiYVFNeXpRTUZONEdxOGVwRjRzOTU0dENVdWFsQkxWcS03c3ZRUQ?oc=5","source_event_id":"evt_e5965f291161","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3cf3b55d19dda11e","published_at":"2026-04-08T17:21:31+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary actor issuing warnings/demands","symbol":"","type":"country"},{"asset_class":"military","name":"Iranian Navy","relevance":"reported to tell ships they still need permission to transit Hormuz","symbol":"","type":"military branch"},{"asset_class":"geography","name":"Strait of Hormuz","relevance":"location of the warnings/fee demands affecting shipping","symbol":"","type":"maritime chokepoint"},{"asset_class":"industry","name":"Ships/Shipping industry","relevance":"directly affected by uncertainty and potential permission/fee requirements","symbol":"","type":"sector"}],"event_type":"geopolitical_risk","information_gaps":["The provided BBC article text is not actually present (only page styling/HTML), so the extracted facts rely on the supplied source summary and headline delta context.","Timing details (when the warning/fee/permission requirements take effect) are not specified in the provided text.","Whether the proposals are officially implemented, enforced, or merely proposed is not fully verifiable from the provided content.","No quantitative estimate of shipping delays, rerouting, or cost impact is included in the provided material."],"key_facts":["BBC reports that an Iran Strait of Hormuz warning is adding to shipping uncertainty.","Iran\u2019s proposal to collect tolls in the Strait of Hormuz is described as violating trade norms (Boston Herald).","Iranian Navy reportedly told ships they still need permission to transit Hormuz (WSJ).","Iran reportedly demands crypto fees for ships passing Hormuz during a ceasefire (Financial Times).","Iran reportedly demands $1 per barrel of oil passing through the Strait of Hormuz, paid in crypto (The Hill)."],"numeric_claims":[{"label":"fee per barrel","value":"$1 per barrel"},{"label":"crypto payment","value":"paid in crypto (amount not specified beyond $1/barrel)"}],"primary_claim":"Iran has issued warnings and proposals concerning transit through the Strait of Hormuz (including toll/fee collection and permission/crypto-fee demands), which are adding to shipping uncertainty.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Multiple reports highlight Iran\u2019s warnings and demands related to transit through the Strait of Hormuz, increasing uncertainty for shipping. The proposals include toll/fee collection and permission requirements, potentially affecting near-term shipping operations and costs.","topics":["shipping uncertainty","Strait of Hormuz","Iran transit rules","tolls/fees","crypto payments","maritime permission requirements","oil transit"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Iran Strait of Hormuz warning adds to shipping uncertainty BBC Iran\u2019s proposal to collect tolls in the Strait of Hormuz violates trade norms Boston Herald Iranian Navy Tells Ships They Still Need Permission to Transit Hormuz WSJ Iran demands crypto fees for ships passing Hormuz during ceasefire Financial Times Iran demands $1 per barrel of oil passing through Strait of Hormuz, paid in crypto The Hill","title":"Iran Strait of Hormuz warning adds to shipping uncertainty - BBC","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 8389 in events