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-09T03:57:12.008447+00:00","dedupe_key":"signal_enriched:news_delta:99f6efd204509fc0","evidence_event_ids":["evt_2996d789043b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiXEFVX3lxTFBOTnVDb0RwMUl3aUtYX2tjTTJETm1uTTJQc24xM0V4dmZrLVh3ZkpsUTFCWDY2Q0V0WFdLenhDeVRLRFg1M29ETlBDaHhtX2w2TEU1ckRIaml5YWNN?oc=5","as_of":"2026-04-09T03:57:12.008447+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/CBMiXEFVX3lxTFBOTnVDb0RwMUl3aUtYX2tjTTJETm1uTTJQc24xM0V4dmZrLVh3ZkpsUTFCWDY2Q0V0WFdLenhDeVRLRFg1M29ETlBDaHhtX2w2TEU1ckRIaml5YWNN?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6321dbdba186c5c3","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:35:48.681561+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiXEFVX3lxTFBOTnVDb0RwMUl3aUtYX2tjTTJETm1uTTJQc24xM0V4dmZrLVh3ZkpsUTFCWDY2Q0V0WFdLenhDeVRLRFg1M29ETlBDaHhtX2w2TEU1ckRIaml5YWNN?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"unherd.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiXEFVX3lxTFBOTnVDb0RwMUl3aUtYX2tjTTJETm1uTTJQc24xM0V4dmZrLVh3ZkpsUTFCWDY2Q0V0WFdLenhDeVRLRFg1M29ETlBDaHhtX2w2TEU1ckRIaml5YWNN?oc=5","source_event_id":"evt_2996d789043b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aa228cbf8f896573","published_at":"2026-04-08T23:02:25+00:00","publisher_domain":"unherd.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity/FX (policy impact)","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign risk (geopolitical)","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"energy shipping chokepoint","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_feature"},{"asset_class":"government","name":"White House","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"news","name":"CNBC","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"news","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"news","name":"Politico","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"news","name":"Yahoo Finance","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"news","name":"UnHerd","relevance":"high","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The provided text does not include the full UnHerd article content\u2014only the headline and a bundled source-summary snippet\u2014so the exact wording, timing, and context of Trump\u2019s proposal are not fully verifiable here.","No specific date for the ceasefire or for the proposed reopening/toll mechanism is included in the provided material.","The snippet does not specify which \u201ctraffic increases\u201d metric/time window Yahoo Finance refers to.","The \u201c4 ways\u201d and their details are not included, only that they exist and are described as difficult to implement."],"key_facts":["UnHerd headline: \u201cAgainst the Mad King Trump makes technocracy look good.\u201d","A referenced report says Trump wants the Strait of Hormuz open \u201cwithout limitation, including tolls\u201d during an Iran ceasefire (attributed to the White House; referenced by CNBC).","A referenced NYT item discusses how tolls in the Strait of Hormuz could undercut international law.","A referenced Yahoo Finance item says Trump issued more threats at Iran even as traffic in the Strait of Hormuz increases.","A referenced Politico item lists \u201c4 ways\u201d Trump has suggested the Strait of Hormuz could be reopened and notes why they are a tough lift."],"numeric_claims":[],"primary_claim":"Trump wants the Strait of Hormuz open \u201cwithout limitation, including tolls\u201d during an Iran ceasefire, according to the White House (as referenced by CNBC).","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The UnHerd headline frames President Trump\u2019s approach to Iran and the Strait of Hormuz as favoring \u201ctechnocracy\u201d over chaos, amid reports that he wants the Strait reopened during an Iran ceasefire with tolls. Other cited coverage highlights that Trump has issued further threats at Iran even as traffic in the Strait increases, and that reopening options may be difficult.","topics":["Iran ceasefire","Strait of Hormuz reopening","shipping tolls","international law","US threats toward Iran","maritime traffic increases"]},"source":"UnHerd","source_domain":"unherd.com","source_url":"https://unherd.com","summary":"Against the Mad King Trump makes technocracy look good UnHerd Trump wants Strait of Hormuz open 'without limitation, including tolls' during Iran ceasefire: White House CNBC How Tolls in the Strait of Hormuz Would Undercut International Law The New York Times Trump hurls more threats at Iran even as traffic in Strait of Hormuz increases Yahoo Finance 4 ways Trump has suggested the Strait of Hormuz could be reopened \u2014 and why they're a tough lift Politico","title":"Against the Mad King Trump makes technocracy look good - UnHerd","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 8862 in events