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-09T12:01:21.191854+00:00","dedupe_key":"signal_enriched:news_delta:6839f00b2627800a","evidence_event_ids":["evt_326464cfb90c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5","as_of":"2026-04-09T12:01:21.191854+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/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_86286518e9724494","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:18:12.379229+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"timesofisrael.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5","source_event_id":"evt_326464cfb90c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bb2b3ae300ef9cc3","published_at":"2026-04-09T10:23:05+00:00","publisher_domain":"timesofisrael.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"European countries (unspecified)","relevance":"high","symbol":"","type":"group"},{"asset_class":"military","name":"IDF (Israel Defense Forces)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"military/political","name":"Hezbollah","relevance":"high","symbol":"","type":"organization"},{"asset_class":"political_agreement","name":"US-Iran truce","relevance":"medium","symbol":"","type":"agreement"},{"asset_class":"sovereign","name":"Britain (UK)","relevance":"medium","symbol":"","type":"country"},{"asset_class":"politician","name":"Yvette Cooper","relevance":"medium","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Lebanon","relevance":"medium","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"medium","symbol":"","type":"country"},{"asset_class":"maritime_route","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geography"}],"event_type":"conflict","information_gaps":["Which specific European countries made the condemnation is not stated in the provided text.","The exact nature (timing, location, scale) of the IDF strikes on Hezbollah is not provided.","The details of the US-Iran truce (start/end dates, enforcement mechanism) are not provided.","The specific UK/EU officials\u2019 statements timing (date/time) and whether they are scheduled for a particular session are not provided.","The \u201cbill\u201d Europe fears is not specified (cost type, who pays, magnitude)."],"key_facts":["The Times of Israel headline states that European countries \u201cslam\u201d/condemn IDF strikes on Hezbollah.","The condemnation is described as occurring \u201camid\u201d a US-Iran truce (timing linkage).","The provided source summary includes that Britain will call for the Strait of Hormuz to be toll-free.","The provided source summary includes that Lebanon must be included in the US-Iran ceasefire deal.","The provided source summary includes that Yvette Cooper will urge full and toll-free reopening of the Strait of Hormuz.","The provided source summary includes that Europe fears \u201cgetting stuck with the bill\u201d after Trump\u2019s Iran deal (as stated in the summary)."],"numeric_claims":[],"primary_claim":"European countries condemned IDF strikes on Hezbollah during the period of a US-Iran truce.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"European countries criticized IDF strikes on Hezbollah while a US-Iran truce is in place, with additional UK and EU-related calls tied to the Iran ceasefire and Strait of Hormuz reopening. The near-term catalyst implied is the political messaging around the ceasefire terms and maritime access demands.","topics":["IDF strikes","Hezbollah","European diplomatic response","US-Iran truce","Iran ceasefire terms","Strait of Hormuz toll-free reopening","Lebanon inclusion in ceasefire"]},"source":"The Times of Israel","source_domain":"timesofisrael.com","source_url":"https://www.timesofisrael.com","summary":"\u2018Unacceptable\u2019: European countries slam IDF strikes on Hezbollah amid US-Iran truce The Times of Israel Britain to call for toll-free Strait of Hormuz, says Lebanon must be part of Iran ceasefire CNBC Lebanon must be included in US-Iran ceasefire deal, Yvette Cooper to say The Guardian Cooper urges full and toll-free reopening of Strait of Hormuz BBC Europe fears getting stuck with the bill after Trump\u2019s Iran deal politico.eu","title":"\u2018Unacceptable\u2019: European countries slam IDF strikes on Hezbollah amid US-Iran truce - The Times of Israel","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 9854 in events