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/CBMigwFBVV95cUxNRHJ4VHZ5Nl9MSklSME54YWg4MmJpNmxWTWVEX2M4ZDRfUmc0M0FSeWVXZElKd1lpT3pFMVdDc3dTRU12R2JIYWdlUlBzSW13TktvQnozR0tmWkc3dzYwN1hTRmdMcFAxdTUtU2FabkN5N3F5WEVXZ1Y4UG9jUTRIWkoyaw?oc=5","as_of":"2026-04-08T21:48:34.496490+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/CBMigwFBVV95cUxNRHJ4VHZ5Nl9MSklSME54YWg4MmJpNmxWTWVEX2M4ZDRfUmc0M0FSeWVXZElKd1lpT3pFMVdDc3dTRU12R2JIYWdlUlBzSW13TktvQnozR0tmWkc3dzYwN1hTRmdMcFAxdTUtU2FabkN5N3F5WEVXZ1Y4UG9jUTRIWkoyaw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_aab2c8647f40af6e","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:14:41.561626+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNRHJ4VHZ5Nl9MSklSME54YWg4MmJpNmxWTWVEX2M4ZDRfUmc0M0FSeWVXZElKd1lpT3pFMVdDc3dTRU12R2JIYWdlUlBzSW13TktvQnozR0tmWkc3dzYwN1hTRmdMcFAxdTUtU2FabkN5N3F5WEVXZ1Y4UG9jUTRIWkoyaw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNRHJ4VHZ5Nl9MSklSME54YWg4MmJpNmxWTWVEX2M4ZDRfUmc0M0FSeWVXZElKd1lpT3pFMVdDc3dTRU12R2JIYWdlUlBzSW13TktvQnozR0tmWkc3dzYwN1hTRmdMcFAxdTUtU2FabkN5N3F5WEVXZ1Y4UG9jUTRIWkoyaw?oc=5","source_event_id":"evt_bb87fa4ca1c3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9d091eeec7064890","published_at":"2026-04-08T19:58:01+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Oil industry (unspecified representatives)","relevance":"direct","symbol":"","type":"industry_group"},{"asset_class":"other","name":"White House","relevance":"direct","symbol":"","type":"government_body"},{"asset_class":"other","name":"Iran","relevance":"direct","symbol":"","type":"country"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"direct","symbol":"","type":"geographic_chokepoint"},{"asset_class":"other","name":"Shipping / vessels passing Hormuz","relevance":"direct","symbol":"","type":"market_participant"}],"event_type":"geopolitical_risk","information_gaps":["The Politico article\u2019s specific details (who exactly in the oil industry, what exact request/ask, and what White House response is) are not present in the provided text.","Timing is not specified in the provided content (no explicit dates for when the White House meeting/plea occurred or when the crypto/toll demands would take effect).","The signal summary references multiple outlets (BBC/Reuters/FT/The Hill) but the exact wording and scope (e.g., which ceasefire, which vessels, enforcement mechanism) are not included here.","No direct confirmation is provided in the excerpt that Iran\u2019s demands will be implemented; only that Iran demands them (and that they would add uncertainty)."],"key_facts":["Politico reports the oil industry is pleading its case with the White House regarding the Strait of Hormuz (per headline).","The signal summary indicates Iran-related actions/warnings are adding to shipping uncertainty around the Strait of Hormuz.","Reuters (per provided source summary) states Iran demands crypto fees for ships passing Hormuz during a ceasefire.","Financial Times (per provided source summary) states Iran demands $1 per barrel of oil passing through the Strait of Hormuz, paid in crypto (during a ceasefire context).","The Hill (per provided source summary) also references Iran demanding crypto fees for ships passing Hormuz during a ceasefire.","BBC (per provided source summary) includes a Greek PM statement that tolls for ships to cross Hormuz would be unacceptable and a risk to freedom of navigation."],"numeric_claims":[{"label":"Fee per barrel","value":"$1 per barrel (paid in crypto)"}],"primary_claim":"The oil industry is pleading its case to the White House regarding the Strait of Hormuz, as Iran-related demands and warnings add to shipping uncertainty.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Oil industry representatives are urging the White House to address concerns related to the Strait of Hormuz, amid warnings that Iran\u2019s actions could increase shipping uncertainty. The signal points to near-term risk of higher shipping/energy friction if Iran\u2019s demands (including crypto-related fees) are implemented.","topics":["Strait of Hormuz","Iran shipping demands","crypto fees","freedom of navigation","shipping uncertainty","energy market risk"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Oil industry pleads its Hormuz case with White House Politico Iran Strait of Hormuz warning adds to shipping uncertainty BBC Greek PM says tolls for ships to cross Hormuz would be unacceptable, a risk to freedom of navigation Reuters 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":"Oil industry pleads its Hormuz case with White House - Politico","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_663dae47275e in signals