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-10T03:30:53.161018+00:00","dedupe_key":"signal_enriched:news_delta:48b9ca39e9f2f613","evidence_event_ids":["evt_9aa73827b237"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5","as_of":"2026-04-10T03:30:53.161018+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/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_37a1c1ebb9f4678a","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-10T03:39:16.568034+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5","source_event_id":"evt_9aa73827b237","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"388f9b9818e75600","published_at":"2026-04-10T01:12:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"medium","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"medium","symbol":"","type":"country"},{"asset_class":"energy_infrastructure","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"chokepoint"},{"asset_class":"commodity_flow","name":"Oil flows","relevance":"high","symbol":"","type":"market_flow"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the substantive Reuters content; extraction relies on the headline and the user-provided source summary/snippets.","No specific dates/timing for the \u201ctalks\u201d are included in the provided material.","The mechanism by which oil flows are \u201csqueezed\u201d (sanctions, shipping disruptions, production cuts, or routing) is not specified.","The exact terms/conditions of the ceasefire deal and what constitutes \u201cstrain\u201d are not detailed in the provided text.","The relationship between Israel\u2019s Lebanon attacks and the US-Iran ceasefire is asserted in snippets but not evidenced with specifics here."],"key_facts":["Reuters headline indicates the US-Iran ceasefire deal is showing strain ahead of talks.","Reuters headline indicates oil flows are being squeezed (near-term supply/flow risk).","Iran is described (via provided live-update snippets) as warning of strong responses (uncertainty: exact trigger not fully specified in provided text).","Provided snippets indicate Trump cautioned Iran against collecting tolls through the Strait of Hormuz (uncertainty: whether this is part of the same Reuters story or separate coverage).","Provided snippets indicate Israel\u2019s attacks on Lebanon are testing/affecting the ceasefire (uncertainty: causal linkage strength not specified).","Provided snippets indicate stocks are shaky as the situation tests Iran\u2019s ceasefire (uncertainty: which market/indices and timing not specified)."],"numeric_claims":[],"primary_claim":"The US-Iran ceasefire deal is showing strain ahead of talks, with oil flows squeezed and Iran warning of strong responses amid regional escalation.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports that a US-Iran ceasefire deal is under strain, with oil flows potentially squeezed ahead of upcoming talks. Iran warns of strong responses as Israel\u2019s attacks on Lebanon and US comments about Strait of Hormuz tolls add pressure.","topics":["US-Iran ceasefire","oil market risk","Strait of Hormuz tolls","Israel-Lebanon attacks","ceasefire stability","upcoming talks"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"US-Iran ceasefire deal shows strain ahead of talks with oil flows squeezed Reuters Live updates: Iran warns of 'strong responses' as Israel's attacks on Lebanon threaten ceasefire NBC News Iran live updates: Trump says Iran 'better not' collect Strait of Hormuz toll ABC News Live Updates: Trump cautions Iran against charging tolls through Strait of Hormuz as fragile ceasefire holds CBS News Stocks shaky as Israeli attacks on Lebanon tests Iran ceasefire Reuters","title":"US-Iran ceasefire deal shows strain ahead of talks with oil flows squeezed - Reuters","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 13952 in events