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-09T15:01:34.169699+00:00","dedupe_key":"signal_enriched:news_delta:c281ceac6e30de54","evidence_event_ids":["evt_c738ed98b2de"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNUGR1VEVsM1lZZkhpdndoTlB3M0ZNWEJ4bkZBWkJoR0hybU1sbGljd19DUjJwWXkyXy05cDF6ZTBHMi1raERVeUN5MkJmV0NrM0lYZ0hjdzlYOHM1elZPY1lPM2E5Qkw3NUJHSExaOEpyak10aTE4Z1dlQm9xSFp6TWFfVTRLaDZnVnBvajduOW5feFd2cG85TExEejBDQ1pYWk93Slo5Tlg1bURoVERQWm1UcG8zY3Bj?oc=5","as_of":"2026-04-09T15:01:34.169699+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/CBMiuAFBVV95cUxNUGR1VEVsM1lZZkhpdndoTlB3M0ZNWEJ4bkZBWkJoR0hybU1sbGljd19DUjJwWXkyXy05cDF6ZTBHMi1raERVeUN5MkJmV0NrM0lYZ0hjdzlYOHM1elZPY1lPM2E5Qkw3NUJHSExaOEpyak10aTE4Z1dlQm9xSFp6TWFfVTRLaDZnVnBvajduOW5feFd2cG85TExEejBDQ1pYWk93Slo5Tlg1bURoVERQWm1UcG8zY3Bj?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_50cd8a25745e09e5","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-09T23:40:14.807449+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNUGR1VEVsM1lZZkhpdndoTlB3M0ZNWEJ4bkZBWkJoR0hybU1sbGljd19DUjJwWXkyXy05cDF6ZTBHMi1raERVeUN5MkJmV0NrM0lYZ0hjdzlYOHM1elZPY1lPM2E5Qkw3NUJHSExaOEpyak10aTE4Z1dlQm9xSFp6TWFfVTRLaDZnVnBvajduOW5feFd2cG85TExEejBDQ1pYWk93Slo5Tlg1bURoVERQWm1UcG8zY3Bj?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/CBMiuAFBVV95cUxNUGR1VEVsM1lZZkhpdndoTlB3M0ZNWEJ4bkZBWkJoR0hybU1sbGljd19DUjJwWXkyXy05cDF6ZTBHMi1raERVeUN5MkJmV0NrM0lYZ0hjdzlYOHM1elZPY1lPM2E5Qkw3NUJHSExaOEpyak10aTE4Z1dlQm9xSFp6TWFfVTRLaDZnVnBvajduOW5feFd2cG85TExEejBDQ1pYWk93Slo5Tlg1bURoVERQWm1UcG8zY3Bj?oc=5","source_event_id":"evt_c738ed98b2de","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f73d1d8c23247677","published_at":"2026-04-09T06:18:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United Kingdom foreign minister","relevance":"high","symbol":"","type":"government_official"},{"asset_class":"sovereign","name":"Israel","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"UK government","relevance":"medium","symbol":"","type":"government"}],"event_type":"geopolitical_risk","information_gaps":["The article text provided is not the Reuters content (it appears to be page styling/HTML), so only the headline and provided source summary can be grounded.","The specific name of the UK foreign minister and the exact date/time of the statement are not included in the provided text.","No details are provided here on the scale/timing of Israel\u2019s strikes beyond the characterization \u201cpounding.\u201d","No direct linkage is provided in the Reuters headline to the Strait of Hormuz or Iran ceasefire items mentioned in the broader source summary; those are not confirmed within the Reuters excerpt."],"key_facts":["Reuters headline states Israel\u2019s pounding of Lebanon is \u201cdeeply damaging,\u201d as said by the UK foreign minister."],"numeric_claims":[],"primary_claim":"The UK foreign minister said Israel\u2019s pounding of Lebanon is \u201cdeeply damaging.\u201d","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Reuters reports that the UK foreign minister said Israel\u2019s strikes on Lebanon are \u201cdeeply damaging.\u201d The statement is part of broader UK messaging around regional ceasefire and maritime issues involving Iran.","topics":["Israel-Lebanon conflict","UK foreign policy","diplomatic condemnation","regional security"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Israel's pounding of Lebanon is 'deeply damaging', UK foreign minister says Reuters Britain to call for toll-free Strait of Hormuz, says Lebanon must be part of Iran ceasefire CNBC UK rejects tolls on Strait of Hormuz politico.eu Lebanon must be included in US-Iran ceasefire deal, UK ministers tell Trump The Guardian Cooper urges full and toll-free reopening of Strait of Hormuz BBC","title":"Israel's pounding of Lebanon is 'deeply damaging', UK foreign minister says - 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 10320 in events