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/CBMihAFBVV95cUxOcXBaVV81aXNINXFaMWMwZVh5RGlxQmdBZE9va2M0cEZpODRBTWpPTC1SdFNBTWg0cFgzZTlXaU5JelpTa3hNZ3BZU0hzdG4yNGVYT3pzSDFpNGoyZDdxMkk5MHMwclJkUzV1a2t4YWdnNW9QMUQ4alZaT2pnblNqbmthX1M?oc=5","as_of":"2026-04-08T19:34:52.567059+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/CBMihAFBVV95cUxOcXBaVV81aXNINXFaMWMwZVh5RGlxQmdBZE9va2M0cEZpODRBTWpPTC1SdFNBTWg0cFgzZTlXaU5JelpTa3hNZ3BZU0hzdG4yNGVYT3pzSDFpNGoyZDdxMkk5MHMwclJkUzV1a2t4YWdnNW9QMUQ4alZaT2pnblNqbmthX1M?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_95563cbaf09a3c4d","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:09:14.302476+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxOcXBaVV81aXNINXFaMWMwZVh5RGlxQmdBZE9va2M0cEZpODRBTWpPTC1SdFNBTWg0cFgzZTlXaU5JelpTa3hNZ3BZU0hzdG4yNGVYT3pzSDFpNGoyZDdxMkk5MHMwclJkUzV1a2t4YWdnNW9QMUQ4alZaT2pnblNqbmthX1M?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/CBMihAFBVV95cUxOcXBaVV81aXNINXFaMWMwZVh5RGlxQmdBZE9va2M0cEZpODRBTWpPTC1SdFNBTWg0cFgzZTlXaU5JelpTa3hNZ3BZU0hzdG4yNGVYT3pzSDFpNGoyZDdxMkk5MHMwclJkUzV1a2t4YWdnNW9QMUQ4alZaT2pnblNqbmthX1M?oc=5","source_event_id":"evt_8101d6f89fa9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"774f16bac042b0ab","published_at":"2026-04-08T11:34:18+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary actor demanding fees","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":"sovereign","name":"United States","relevance":"referenced as part of upcoming meeting context","symbol":"","type":"country"},{"asset_class":"infrastructure","name":"Strait of Hormuz","relevance":"location of the demanded crypto toll/fee","symbol":"","type":"geographic_chokepoint"},{"asset_class":"transport","name":"Ships transiting Hormuz","relevance":"directly affected by the fee/permission requirement","symbol":"","type":"shipping_operators"},{"asset_class":"digital_asset","name":"Crypto","relevance":"payment mechanism demanded by Iran","symbol":"","type":"payment_method"}],"event_type":"geopolitical_risk","information_gaps":["The provided content is largely a cleaned HTML artifact and does not include the full Financial Times article text; only the headline and the supplied source summary snippets are available.","Exact ceasefire dates/timeline and the exact mechanism (how fees are calculated per ship, how payment is verified, enforcement details) are not present in the supplied text.","Whether the fee demand is officially implemented, voluntary, or backed by enforcement actions is not fully verifiable from the provided material.","The specific date of the referenced US meeting (Reuters) is not included in the supplied text."],"key_facts":["Financial Times reports Iran demands crypto fees for ships passing through Hormuz during a ceasefire.","Other referenced reporting indicates Iran\u2019s demand is framed as about $1 per barrel of oil passing through the Strait of Hormuz, paid in crypto (The Hill).","Iranian Navy is reported to have told ships they still need permission to transit Hormuz (WSJ reference in provided source summary).","Reuters reference in the provided source summary says an Iranian senior official indicated Iran could open the Strait of Hormuz in a controlled way ahead of a meeting with the US (timing context mentioned, but exact date not provided in the supplied text)."],"numeric_claims":[{"label":"Fee level (reported)","value":"$1 per barrel of oil"}],"primary_claim":"Iran demands that ships passing through the Strait of Hormuz during a ceasefire pay crypto fees (reported as about $1 per barrel of oil) to obtain/maintain transit permission.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Iran is reportedly demanding a crypto-based fee from ships transiting the Strait of Hormuz during a ceasefire period, framing it as a condition for permission to transit. The move could create near-term operational and compliance friction for shipping and energy flows through the chokepoint.","topics":["Strait of Hormuz","Iran shipping fees","crypto payments","maritime transit permission","ceasefire","energy chokepoint risk","US-Iran talks"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"Iran demands crypto fees for ships passing Hormuz during ceasefire Financial Times Iranian Navy Tells Ships They Still Need Permission to Transit Hormuz WSJ Iran demands $1 per barrel of oil passing through Strait of Hormuz, paid in crypto The Hill Iran could open Strait of Hormuz in a controlled way ahead of meeting with US, senior Iranian official says Reuters The Iran War Will End With a Hormuz Toll Booth Foreign Policy","title":"Iran demands crypto fees for ships passing Hormuz during ceasefire - 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

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_15ae6736a63a in signals