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-10T13:38:20.364081+00:00","dedupe_key":"signal_enriched:news_delta:d3a916c95f737312","evidence_event_ids":["evt_3111ef47e171"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE9wWFpBaWNTRVZsUEhycng3WUlzOTJTTEJsTnVodTE4V1UyR01SSTFGRm9aMTNsVFFfRzVsbXZUWDlsNlYxZHRvUThjZXZ1cWt0a1dFbDBjR3lmVDc0akdPNGtaeG4wYjl5X0xTMmc5a0pGdU5BTzBYbUlB?oc=5","as_of":"2026-04-10T13:38:20.364081+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/CBMiekFVX3lxTE9wWFpBaWNTRVZsUEhycng3WUlzOTJTTEJsTnVodTE4V1UyR01SSTFGRm9aMTNsVFFfRzVsbXZUWDlsNlYxZHRvUThjZXZ1cWt0a1dFbDBjR3lmVDc0akdPNGtaeG4wYjl5X0xTMmc5a0pGdU5BTzBYbUlB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dfec263d4c28f275","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-10T13:39:11.377877+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE9wWFpBaWNTRVZsUEhycng3WUlzOTJTTEJsTnVodTE4V1UyR01SSTFGRm9aMTNsVFFfRzVsbXZUWDlsNlYxZHRvUThjZXZ1cWt0a1dFbDBjR3lmVDc0akdPNGtaeG4wYjl5X0xTMmc5a0pGdU5BTzBYbUlB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTE9wWFpBaWNTRVZsUEhycng3WUlzOTJTTEJsTnVodTE4V1UyR01SSTFGRm9aMTNsVFFfRzVsbXZUWDlsNlYxZHRvUThjZXZ1cWt0a1dFbDBjR3lmVDc0akdPNGtaeG4wYjl5X0xTMmc5a0pGdU5BTzBYbUlB?oc=5","source_event_id":"evt_3111ef47e171","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"28c8c076122037d8","published_at":"2026-04-10T11:07:34+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"geopolitical_route","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_location"},{"asset_class":"","name":"NPR","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no readable body content, so only the headline/summary-level claim is grounded.","The current operational status of the Strait of Hormuz (e.g., fully reopened vs partially reopened) is not verifiable from the provided text.","Whether Trump\u2019s comments included a specific deadline or concrete policy action is not present in the provided material.","The \u201ctolls/fees\u201d warning is mentioned in the multi-source context, but the NPR-specific wording and whether it is included in the NPR article cannot be confirmed from the provided content."],"key_facts":["NPR headline reports Trump said Iran is doing a \u201cvery poor job\u201d in reopening the Strait of Hormuz.","The broader provided context includes other headlines stating Trump warned Iran against charging oil tankers fees to go through the Strait of Hormuz (exact details not confirmed from the NPR text provided)."],"numeric_claims":[],"primary_claim":"Trump said Iran is doing a \u201cvery poor job\u201d reopening the Strait of Hormuz.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"NPR reports that Trump criticized Iran\u2019s handling of reopening the Strait of Hormuz, saying Iran is doing a \u201cvery poor job.\u201d The remarks imply heightened U.S. pressure on Iran regarding any toll/fee arrangements for tanker passage.","topics":["Iran","Strait of Hormuz","shipping/tanker passage","U.S.-Iran tensions","maritime chokepoint","reopening/closure status"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Trump says Iran \u2018doing a very poor job\u2019 in reopening the Strait of Hormuz NPR Iran War Live Updates: Trump Warns Iran Against Collecting Tolls in the Strait of Hormuz WSJ Iran ceasefire under pressure as strikes in Lebanon continue ahead of talks The Washington Post Live updates: Don't try to play the U.S. in peace talks, Vance warns Iran, as Strait of Hormuz remains closed NBC News Trump says Iran 'better stop now' if it's charging oil tankers fees to go through Strait of Hormuz CNBC","title":"Trump says Iran \u2018doing a very poor job\u2019 in reopening the Strait of Hormuz - NPR","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 16606 in events