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-09T08:24:00.977535+00:00","dedupe_key":"signal_enriched:news_delta:aa64bb6218702610","evidence_event_ids":["evt_e5dac150367e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPQlU0TkJhVWVRckNQWXFrMkJuR01KQkgzeFdYOWhSQmoxNGpvM3Z5c3RseUtycXFJMHl1clhwUG1iTXFWajYzMEliOE14ZklKMTEyZXpQaVZsM1NiMUNNX3AwMmo3T3p1NmRvUFRRaDRWS3dOeXFrMVl3dElpM2VVTVBQaVQ?oc=5","as_of":"2026-04-09T08:24:00.977535+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/CBMihAFBVV95cUxPQlU0TkJhVWVRckNQWXFrMkJuR01KQkgzeFdYOWhSQmoxNGpvM3Z5c3RseUtycXFJMHl1clhwUG1iTXFWajYzMEliOE14ZklKMTEyZXpQaVZsM1NiMUNNX3AwMmo3T3p1NmRvUFRRaDRWS3dOeXFrMVl3dElpM2VVTVBQaVQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8d6564d519aafd1b","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:53:38.094002+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPQlU0TkJhVWVRckNQWXFrMkJuR01KQkgzeFdYOWhSQmoxNGpvM3Z5c3RseUtycXFJMHl1clhwUG1iTXFWajYzMEliOE14ZklKMTEyZXpQaVZsM1NiMUNNX3AwMmo3T3p1NmRvUFRRaDRWS3dOeXFrMVl3dElpM2VVTVBQaVQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ft.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPQlU0TkJhVWVRckNQWXFrMkJuR01KQkgzeFdYOWhSQmoxNGpvM3Z5c3RseUtycXFJMHl1clhwUG1iTXFWajYzMEliOE14ZklKMTEyZXpQaVZsM1NiMUNNX3AwMmo3T3p1NmRvUFRRaDRWS3dOeXFrMVl3dElpM2VVTVBQaVQ?oc=5","source_event_id":"evt_e5dac150367e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5a12f58869c37d1e","published_at":"2026-04-09T04:03:08+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"directly responsible for the terms/fees","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Tehran","relevance":"synonym for Iran\u2019s authorities imposing terms","symbol":"","type":"government/capital reference"},{"asset_class":"media","name":"Financial Times","relevance":"source of the headline and framing","symbol":"","type":"publisher"},{"asset_class":"geography","name":"Hormuz (Strait of Hormuz)","relevance":"location where shipping is stalled and fees are demanded","symbol":"","type":"geographic chokepoint"},{"asset_class":"government","name":"White House","relevance":"referenced as a party receiving an industry plea (context from provided summary)","symbol":"","type":"government institution"}],"event_type":"supply_disruption","information_gaps":["The cleaned article text provided contains only page styling/HTML/CSS and does not include the actual article content; extraction is therefore based on the provided headline and the provided source summary text only.","Specific details of the \u201cterms\u201d (e.g., exact fee amounts, enforcement mechanism, which ships are targeted) are not present in the provided text.","Timing is described only as \u201cduring the ceasefire\u201d without specific dates in the provided text.","No direct mention of which shipping routes/commodities are most affected beyond general Hormuz passage."],"key_facts":["Financial Times headline states that shipping stalls as Tehran dictates terms in Hormuz.","Provided source summary states Iran tightens its grip on Hormuz despite a cease-fire.","Provided source summary states Iran demands crypto fees for ships passing Hormuz during the ceasefire.","Provided source summary states an \u201cIran\u2019s Hormuz \u2018toll booth\u2019\u201d is set to hardwire higher energy prices (as characterized in the provided text)."],"numeric_claims":[],"primary_claim":"Shipping through Hormuz is stalling as Tehran dictates terms for passage.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"The Financial Times reports that shipping through the Strait of Hormuz is being disrupted because Iran is imposing its own terms, effectively tightening control over passage. The near-term catalyst is the ongoing ceasefire period during which Iran is demanding fees from ships.","topics":["shipping disruption","Hormuz passage terms","Iran ceasefire-related demands","energy price risk","maritime fees/crypto fees"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"Shipping stalls as Tehran dictates terms in Hormuz Financial Times Iran Tightens Its Grip on Hormuz Despite Cease-Fire WSJ Oil industry pleads its Hormuz case with White House Politico Iran demands crypto fees for ships passing Hormuz during ceasefire Financial Times Iran's Hormuz 'toll booth' set to hardwire higher energy prices Reuters","title":"Shipping stalls as Tehran dictates terms in Hormuz - Financial Times","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 9354 in events