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/CBMiggFBVV95cUxPQ2d4akxuNWFVSkhyeUJpOHlJdExpc2ZkVW44NjNiVGJjdExCV3Nnam1iUklTTndtQ0xQOFB4UFA2VEtnX2lmSElETWxIeFpBQXdyQlR0NXBRNHZiWDN4ZHhINnRLSjhHdWNHMnlubmR5VWxpOUFuM1NtVkFCVENOMUlR?oc=5","as_of":"2026-04-10T08:19:32.172294+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/CBMiggFBVV95cUxPQ2d4akxuNWFVSkhyeUJpOHlJdExpc2ZkVW44NjNiVGJjdExCV3Nnam1iUklTTndtQ0xQOFB4UFA2VEtnX2lmSElETWxIeFpBQXdyQlR0NXBRNHZiWDN4ZHhINnRLSjhHdWNHMnlubmR5VWxpOUFuM1NtVkFCVENOMUlR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_60df19340cff9ea2","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-10T08:20:21.170759+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxPQ2d4akxuNWFVSkhyeUJpOHlJdExpc2ZkVW44NjNiVGJjdExCV3Nnam1iUklTTndtQ0xQOFB4UFA2VEtnX2lmSElETWxIeFpBQXdyQlR0NXBRNHZiWDN4ZHhINnRLSjhHdWNHMnlubmR5VWxpOUFuM1NtVkFCVENOMUlR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxPQ2d4akxuNWFVSkhyeUJpOHlJdExpc2ZkVW44NjNiVGJjdExCV3Nnam1iUklTTndtQ0xQOFB4UFA2VEtnX2lmSElETWxIeFpBQXdyQlR0NXBRNHZiWDN4ZHhINnRLSjhHdWNHMnlubmR5VWxpOUFuM1NtVkFCVENOMUlR?oc=5","source_event_id":"evt_fecb04d744a9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b6819d41730fa0da","published_at":"2026-04-10T05:57:00+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"},{"asset_class":"commodity_transport","name":"oil tankers","relevance":"medium","symbol":"","type":"asset/commodity transport"},{"asset_class":"other","name":"Israel","relevance":"medium","symbol":"","type":"country"},{"asset_class":"other","name":"Hezbollah","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"WSJ (The Wall Street Journal)","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"BBC","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"Bloomberg","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"CNBC","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"NBC News","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML/CSS and does not include the actual news content; extraction is therefore based on the headline and the supplied source summary.","The specific agreement Trump refers to is not identified in the provided text.","No details are given on whether tolls/fees have already been implemented by Iran or are proposed.","No timing/date for the \u201creopening of Hormuz\u201d or the peace talks is included in the provided material.","No quantitative impact (e.g., fee size, affected volume of shipping) is provided."],"key_facts":["WSJ headline indicates Trump warned Iran against collecting tolls/fees in the Strait of Hormuz.","The provided source summary states Trump said Iran\u2019s handling of the Strait of Hormuz is \u201cnot the agreement we have.\u201d","The source summary also references warnings about reopening Hormuz before US-Iran peace talks (attributed to Bloomberg in the summary).","The source summary indicates the broader context includes Israel and Hezbollah trading attacks (attributed to NBC News in the summary)."],"numeric_claims":[],"primary_claim":"Trump warned Iran against collecting tolls/fees from oil tankers transiting the Strait of Hormuz, stating Iran\u2019s handling is not \u201cthe agreement we have.\u201d","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"WSJ reports that Trump warned Iran not to collect tolls/fees in the Strait of Hormuz, saying Iran\u2019s approach is not consistent with the relevant agreement. The warning is framed alongside concerns about reopening Hormuz before US-Iran peace talks and ongoing Israel\u2013Hezbollah exchanges.","topics":["Iran","Strait of Hormuz","shipping fees/tolls","oil tanker transit","US-Iran relations","geopolitical risk","Middle East conflict"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Iran War Live Updates: Trump Warns Iran Against Collecting Tolls in the Strait of Hormuz WSJ Trump says Iran's handling of Strait of Hormuz is 'not the agreement we have' BBC Trump Warns on Reopening of Hormuz Before US-Iran Peace Talks Bloomberg Trump says Iran 'better stop now' if it's charging oil tankers fees to go through Strait of Hormuz CNBC Live updates: Trump warns Iran over Strait of Hormuz; Israel and Hezbollah trade attacks NBC News","title":"Iran War Live Updates: Trump Warns Iran Against Collecting Tolls in the Strait of Hormuz - WSJ","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_a70ec74bf476 in signals