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-07T02:56:07.891616+00:00","dedupe_key":"signal_enriched:news_delta:50d4e63d898570f1","evidence_event_ids":["evt_8f9e47183369"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?oc=5","as_of":"2026-04-07T02:56:07.891616+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/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bbd57803864b45ef","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-07T15:51:45.362629+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?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/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?oc=5","source_event_id":"evt_8f9e47183369","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ede0dc22488c78c8","published_at":"2026-04-06T22:30:58+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"political","name":"Iran","relevance":"high","symbol":"N/A","type":"country"},{"asset_class":"geopolitical","name":"Strait of Hormuz","relevance":"high","symbol":"N/A","type":"location"}],"event_type":"geopolitical_risk","information_gaps":["Uncertainty about the immediate implications of Trump's statement on U.S.-Iran relations.","Lack of details on the context of the demand regarding the Strait of Hormuz."],"key_facts":["Trump's statement indicates a high level of military readiness and potential aggression towards Iran.","The Strait of Hormuz is a critical shipping route for oil, making its opening significant for global trade."],"numeric_claims":[],"primary_claim":"Trump asserts the U.S. could destroy Iran in one night and demands the opening of the Strait of Hormuz.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"Donald Trump has made a provocative statement regarding Iran, claiming the U.S. could destroy the country in one night, while also demanding the opening of the Strait of Hormuz amidst ongoing tensions.","topics":["U.S.-Iran relations","geopolitical tensions","military threats"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"Donald Trump says US could destroy Iran \u2018in one night\u2019 as he demands opening of Strait of Hormuz Financial Times Trump Says Iran Cease-Fire Proposal Is \u2018Not Good Enough\u2019 as Deadline Approaches The New York Times Trump says Iran ceasefire proposal 'significant' but 'not good enough' as Hormuz Strait deadline nears CNBC Trump warns Hormuz deadline \u2018final\u2019 as Iran pushes proposal to end war Al Jazeera Iran mediators make last-ditch push for 45-day ceasefire axios.com","title":"Donald Trump says US could destroy Iran \u2018in one night\u2019 as he demands opening of Strait of Hormuz - 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

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 38442 in events