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-09T16:31:19.793710+00:00","dedupe_key":"signal_enriched:news_delta:f6be9d834dcedbcc","evidence_event_ids":["evt_068c6c98d42c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxOd2pHOXNEaEc2Y21xNFhKcHVWc0I5R1lGQVAzSVQ4VnJ3amJwcmZDMkxXa0ZfUXRfYXhvYVRNa1RZWVlDTjJTSC1lelVhUktUV3pKUmlOSXBsQVR1VDdkaF9PRGJoODRyTUtObHFYbThsX280ejU5a0dTd3BqSDlWTEJkZmFDc1JDWThVbDJVRWlsSXVqb01GbzRRUk1sSHRPNHRFc1RlaDc?oc=5","as_of":"2026-04-09T16:31:19.793710+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/CBMiqAFBVV95cUxOd2pHOXNEaEc2Y21xNFhKcHVWc0I5R1lGQVAzSVQ4VnJ3amJwcmZDMkxXa0ZfUXRfYXhvYVRNa1RZWVlDTjJTSC1lelVhUktUV3pKUmlOSXBsQVR1VDdkaF9PRGJoODRyTUtObHFYbThsX280ejU5a0dTd3BqSDlWTEJkZmFDc1JDWThVbDJVRWlsSXVqb01GbzRRUk1sSHRPNHRFc1RlaDc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7785e826637f16fa","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-10T00:01:13.718436+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxOd2pHOXNEaEc2Y21xNFhKcHVWc0I5R1lGQVAzSVQ4VnJ3amJwcmZDMkxXa0ZfUXRfYXhvYVRNa1RZWVlDTjJTSC1lelVhUktUV3pKUmlOSXBsQVR1VDdkaF9PRGJoODRyTUtObHFYbThsX280ejU5a0dTd3BqSDlWTEJkZmFDc1JDWThVbDJVRWlsSXVqb01GbzRRUk1sSHRPNHRFc1RlaDc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqAFBVV95cUxOd2pHOXNEaEc2Y21xNFhKcHVWc0I5R1lGQVAzSVQ4VnJ3amJwcmZDMkxXa0ZfUXRfYXhvYVRNa1RZWVlDTjJTSC1lelVhUktUV3pKUmlOSXBsQVR1VDdkaF9PRGJoODRyTUtObHFYbThsX280ejU5a0dTd3BqSDlWTEJkZmFDc1JDWThVbDJVRWlsSXVqb01GbzRRUk1sSHRPNHRFc1RlaDc?oc=5","source_event_id":"evt_068c6c98d42c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"dc849a98d307e3cf","published_at":"2026-04-09T12:46:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Israel","relevance":"directly implicated in the alleged assaults","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"target of the alleged Israeli assaults; ceasefire context","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"allegedly blocks oil tankers; maritime disruption claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"referenced as part of ceasefire dynamics and pressure to act (per provided source summary)","symbol":"","type":"country"},{"asset_class":"commodity_logistics","name":"Oil tankers","relevance":"maritime disruption mechanism cited in the headline","symbol":"","type":"asset/commodity logistics"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual Guardian article content; extraction is therefore based on the headline and the supplied multi-outlet source summary.","No specifics are provided on the ceasefire terms, which ceasefire (U.S.-Iran vs Israel-Lebanon), or the exact actions/locations/timing of the alleged assaults and tanker blocking.","No evidence details are included (e.g., which strait/route, which tankers, or what enforcement mechanism Iran uses).","Near-term catalyst timing is not specified beyond \u201clive updates\u201d framing in the source summary."],"key_facts":["The Guardian headline states that a ceasefire is \u201cin peril.\u201d","The headline attributes the ceasefire risk to Israel assaulting Lebanon.","The headline states that Iran is blocking oil tankers.","The provided source summary adds that Israeli strikes in Lebanon threaten a shaky U.S.-Iran ceasefire (NYT).","The provided source summary adds that Iran says the U.S. must choose between war and ceasefire (CBS/Fortune references)."],"numeric_claims":[],"primary_claim":"The ceasefire is in peril because Israel is assaulting Lebanon and Iran is blocking oil tankers.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"The Guardian headline claims the Israel\u2013Lebanon ceasefire is at risk due to ongoing Israeli assaults in Lebanon, while Iran is described as blocking oil tankers. The signal also references broader reporting that U.S.-Iran ceasefire efforts may be threatened by escalation and maritime disruption.","topics":["ceasefire risk","Israel-Lebanon conflict escalation","Iran maritime/oil tanker disruption","U.S.-Iran ceasefire negotiations","energy/maritime supply risk"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"First Thing: Ceasefire in peril as Israel assaults Lebanon and Iran blocks oil tankers The Guardian Iran War Live Updates: Israeli Strikes in Lebanon Threaten Shaky U.S.-Iran Cease-Fire The New York Times Netanyahu authorizes direct talks with Lebanon in potential boost to ceasefire efforts AP News Iran closes strait, challenges U.S. to rein in Israel: 'the world is watching whether it will act on its commitments' Fortune Israel's war in Lebanon becomes a flashpoint as Iran says U.S. must choose \"between war and ceasefire\" CBS News","title":"First Thing: Ceasefire in peril as Israel assaults Lebanon and Iran blocks oil tankers - The Guardian","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 10642 in events