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.136305+00:00","dedupe_key":"signal_enriched:news_delta:3b687ff95683b868","evidence_event_ids":["evt_d9e076dd7408"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNQmZGX2ZSRGJjcWV1MGxyTlprSldHdHFDcVJHYlpwVFVQWXFBdmxfSmdlcnBrYnVXZFZNRmp3czJWZS0xYjdnRDBNcVlMUmU4NFBNR2lDQTM5cVZZX2ZzM0g0czE0aUl5ZGMtX1RkZGJXdTlTMHA5Z2pZdDlyZjNoanJDZnNxMXUzR2dNX1dNNXNQanc0cHpyU0pmZE9YaDNubC1EYkt1ME5WQmYtenVXR20wN1ZlRzhRb0ZZSVppVllPcEEwV2k1UTU3ZXQ?oc=5","as_of":"2026-04-09T03:57:12.136305+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/CBMizAFBVV95cUxNQmZGX2ZSRGJjcWV1MGxyTlprSldHdHFDcVJHYlpwVFVQWXFBdmxfSmdlcnBrYnVXZFZNRmp3czJWZS0xYjdnRDBNcVlMUmU4NFBNR2lDQTM5cVZZX2ZzM0g0czE0aUl5ZGMtX1RkZGJXdTlTMHA5Z2pZdDlyZjNoanJDZnNxMXUzR2dNX1dNNXNQanc0cHpyU0pmZE9YaDNubC1EYkt1ME5WQmYtenVXR20wN1ZlRzhRb0ZZSVppVllPcEEwV2k1UTU3ZXQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ee079a34cae2a386","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:36:38.719844+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNQmZGX2ZSRGJjcWV1MGxyTlprSldHdHFDcVJHYlpwVFVQWXFBdmxfSmdlcnBrYnVXZFZNRmp3czJWZS0xYjdnRDBNcVlMUmU4NFBNR2lDQTM5cVZZX2ZzM0g0czE0aUl5ZGMtX1RkZGJXdTlTMHA5Z2pZdDlyZjNoanJDZnNxMXUzR2dNX1dNNXNQanc0cHpyU0pmZE9YaDNubC1EYkt1ME5WQmYtenVXR20wN1ZlRzhRb0ZZSVppVllPcEEwV2k1UTU3ZXQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"militarytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNQmZGX2ZSRGJjcWV1MGxyTlprSldHdHFDcVJHYlpwVFVQWXFBdmxfSmdlcnBrYnVXZFZNRmp3czJWZS0xYjdnRDBNcVlMUmU4NFBNR2lDQTM5cVZZX2ZzM0g0czE0aUl5ZGMtX1RkZGJXdTlTMHA5Z2pZdDlyZjNoanJDZnNxMXUzR2dNX1dNNXNQanc0cHpyU0pmZE9YaDNubC1EYkt1ME5WQmYtenVXR20wN1ZlRzhRb0ZZSVppVllPcEEwV2k1UTU3ZXQ?oc=5","source_event_id":"evt_d9e076dd7408","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"594932044a15f154","published_at":"2026-04-08T19:05:05+00:00","publisher_domain":"militarytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"geopolitical_chokepoint","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic chokepoint"},{"asset_class":"media","name":"Military Times","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text appears to be mostly HTML/CSS and does not contain the substantive article content; only the headline and the provided source summary are usable here.","No specific details are provided about what \u201cleverage\u201d concretely means (e.g., threats, operational capability, legal/financial mechanisms).","No timing is specified for when the leverage would translate into market/operational effects.","No confirmation is provided of the exact nature of \u201cTrump\u2019s truce\u201d or what conditions define \u201cUS claims victory.\u201d","No quantitative impact (shipping disruption probability, oil price sensitivity, or duration) is included in the provided material."],"key_facts":["The headline states that the US claims victory while Iran is \u201cbruised\u201d but has leverage over Hormuz.","The provided source summary includes the claim that Iran can affect global economic activity via leverage over Hormuz (wording: \u201cholding the world economy hostage\u201d).","The source summary references \u201cTrump\u2019s truce\u201d as the context for Iran\u2019s leverage (exact terms/timeline not provided in the cleaned text)."],"numeric_claims":[],"primary_claim":"After the US claims victory, Iran is portrayed as bruised but still holding leverage over Hormuz.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Military Times frames a post-truce/post-conflict moment in which the US claims victory while Iran is described as \u201cbruised\u201d yet retaining leverage over the Strait of Hormuz. The implied near-term catalyst is the durability of that leverage following the claimed US win.","topics":["Iran-US relations","Hormuz Strait leverage","maritime chokepoint risk","truce/victory framing","energy supply risk"]},"source":"Military Times","source_domain":"militarytimes.com","source_url":"https://www.militarytimes.com","summary":"As US claims victory, Iran emerges bruised but with leverage over Hormuz Military Times Iran is holding the world economy hostage. Trump\u2019s truce proves its leverage CNN 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 Civilization Hasn\u2019t Ended But It Sure Has Changed Bloomberg.com","title":"As US claims victory, Iran emerges bruised but with leverage over Hormuz - Military 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 8903 in events