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-09T00:58:24.023778+00:00","dedupe_key":"signal_enriched:news_delta:4df638b018efd7ab","evidence_event_ids":["evt_f28e68dc0cc8"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxObEs4VjFBOEhoMVdMYW53bGllbURSbEJuMXhhMnd0ZUI5Sy1laUlJdUFtNVcwWjdYX01BWlVPSExpeElHRkJyS3hRakxwVkxIMDBsRlloZHFURFBLQmlXTVh5cUVzOVBRYVZ3V05iZmtYaVJvZEhiWERzVldMMjd2WG00RkU3aEswWlE4?oc=5","as_of":"2026-04-09T00:58:24.023778+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/CBMiiwFBVV95cUxObEs4VjFBOEhoMVdMYW53bGllbURSbEJuMXhhMnd0ZUI5Sy1laUlJdUFtNVcwWjdYX01BWlVPSExpeElHRkJyS3hRakxwVkxIMDBsRlloZHFURFBLQmlXTVh5cUVzOVBRYVZ3V05iZmtYaVJvZEhiWERzVldMMjd2WG00RkU3aEswWlE4?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_603933ee1892f62f","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:22:06.671791+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxObEs4VjFBOEhoMVdMYW53bGllbURSbEJuMXhhMnd0ZUI5Sy1laUlJdUFtNVcwWjdYX01BWlVPSExpeElHRkJyS3hRakxwVkxIMDBsRlloZHFURFBLQmlXTVh5cUVzOVBRYVZ3V05iZmtYaVJvZEhiWERzVldMMjd2WG00RkU3aEswWlE4?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxObEs4VjFBOEhoMVdMYW53bGllbURSbEJuMXhhMnd0ZUI5Sy1laUlJdUFtNVcwWjdYX01BWlVPSExpeElHRkJyS3hRakxwVkxIMDBsRlloZHFURFBLQmlXTVh5cUVzOVBRYVZ3V05iZmtYaVJvZEhiWERzVldMMjd2WG00RkU3aEswWlE4?oc=5","source_event_id":"evt_f28e68dc0cc8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"db25dc3667252c28","published_at":"2026-04-08T17:04:58+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"political_leader","name":"Donald Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"sovereign","name":"United States (Trump administration context)","relevance":"medium","symbol":"","type":"country/political context"},{"asset_class":"energy_infrastructure","name":"Hormuz (Strait of Hormuz)","relevance":"high","symbol":"","type":"geographic chokepoint"},{"asset_class":"media","name":"CNN","relevance":"high","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text appears to be mostly HTML/CSS and does not contain the actual article content; therefore, specific mechanisms (sanctions, shipping disruptions, negotiations terms) and any timelines are not verifiable from the provided material.","No concrete details are provided about what the \u201ctruce\u201d specifically entails (duration, parties, concessions, enforcement).","No measurable economic impact figures (e.g., oil price moves, shipping rates, GDP/inflation effects) are included in the provided headline/summary.","Near-term catalyst timing (e.g., specific negotiation dates or deadlines) is not present in the provided text."],"key_facts":["CNN headline frames Iran as holding the world economy hostage.","CNN headline claims Trump\u2019s truce demonstrates Iran\u2019s leverage.","The source summary references \u201cleverage over Hormuz,\u201d implying the Strait of Hormuz is central to the leverage argument."],"numeric_claims":[],"primary_claim":"Iran is using leverage to affect the world economy, and Trump\u2019s truce is presented as proof of that leverage (CNN).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"CNN argues that Iran has significant leverage over global economic activity (via the Hormuz/energy chokepoint framing) and that Trump\u2019s truce demonstrates Iran\u2019s bargaining power. The provided text does not include the article\u2019s substantive details, so the claims below are limited to what is stated in the headline and the accompanying source summary.","topics":["Iran","Trump truce","Strait of Hormuz","global economy leverage","geopolitical risk","energy chokepoint"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Iran is holding the world economy hostage. Trump\u2019s truce proves its leverage CNN Why Iran Thinks It Won the War Despite Huge Military Losses WSJ Opinion | The Iranian Advantage Is an Illusion The New York Times As Trump claims victory, Iran emerges bruised but powerful with leverage over Hormuz Reuters The Iran crisis is far from over \u2013 instead we are entering a new and uncertain phase | Sanam Vakil The Guardian","title":"Iran is holding the world economy hostage. Trump\u2019s truce proves its leverage - CNN","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 8660 in events