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-19T00:02:36.067844+00:00","dedupe_key":"signal_enriched:news_delta:4a7d55c18dbb05f5","evidence_event_ids":["evt_0a4589c4349b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNaFVuczNiTnFoMGdjSlVMVi0wdFVPRGFrRzZsXzhlZDBkT3Z2aGlfbWNKWUgwSkc1cDdMOW1KWWQwdDkzVzRUbkE1MzFKZ1YtQnBKWnp4RE9UZDZWMGxiT2YteWFIeC1vSFp3ZW5vVXFKMFpsTE1seG9wMUY1ZVB0Q2NpRVEtMVRYaE1WTXkwVlU1R2tycnVENGFhanhxUmhWejlsdWYxdmo1aVRoM0k4?oc=5","as_of":"2026-04-19T00:02:36.067844+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNaFVuczNiTnFoMGdjSlVMVi0wdFVPRGFrRzZsXzhlZDBkT3Z2aGlfbWNKWUgwSkc1cDdMOW1KWWQwdDkzVzRUbkE1MzFKZ1YtQnBKWnp4RE9UZDZWMGxiT2YteWFIeC1vSFp3ZW5vVXFKMFpsTE1seG9wMUY1ZVB0Q2NpRVEtMVRYaE1WTXkwVlU1R2tycnVENGFhanhxUmhWejlsdWYxdmo1aVRoM0k4?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_bb67edbbcdb8c7bd","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T00:25:58.216082+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNaFVuczNiTnFoMGdjSlVMVi0wdFVPRGFrRzZsXzhlZDBkT3Z2aGlfbWNKWUgwSkc1cDdMOW1KWWQwdDkzVzRUbkE1MzFKZ1YtQnBKWnp4RE9UZDZWMGxiT2YteWFIeC1vSFp3ZW5vVXFKMFpsTE1seG9wMUY1ZVB0Q2NpRVEtMVRYaE1WTXkwVlU1R2tycnVENGFhanhxUmhWejlsdWYxdmo1aVRoM0k4?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/CBMirwFBVV95cUxNaFVuczNiTnFoMGdjSlVMVi0wdFVPRGFrRzZsXzhlZDBkT3Z2aGlfbWNKWUgwSkc1cDdMOW1KWWQwdDkzVzRUbkE1MzFKZ1YtQnBKWnp4RE9UZDZWMGxiT2YteWFIeC1vSFp3ZW5vVXFKMFpsTE1seG9wMUY1ZVB0Q2NpRVEtMVRYaE1WTXkwVlU1R2tycnVENGFhanhxUmhWejlsdWYxdmo1aVRoM0k4?oc=5","source_event_id":"evt_0a4589c4349b","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"e52cc4bd1a100df9","published_at":"2026-04-18T21:57:28+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: French soldier killed in attack on UN mission in southern Lebanon, officials say - Reuters","Source summary: French soldier killed in attack on UN mission in southern Lebanon, officials say Reuters French peacekeeper killed in southern Lebanon BBC Macron, UNIFIL blame Hezbollah for killing of French peacekeeper in Lebanon The Times of Israel French soldier killed in attack on U.N. peacekeepers in Lebanon PBS UN chief strongly condemns killing of another peacekeeper in southern Lebanon UN News"],"numeric_claims":[],"primary_claim":"French soldier killed in attack on UN mission in southern Lebanon, officials say - Reuters","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"French soldier killed in attack on UN mission in southern Lebanon, officials say Reuters French peacekeeper killed in southern Lebanon BBC Macron, UNIFIL blame Hezbollah for killing of French peacekeeper in Lebanon The Times of Israel French soldier killed in attack on U.N. peacekeepers in Lebanon PBS UN chief strongly condemns killing of another peacekeeper in southern Lebanon UN News","topics":["news headline"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"French soldier killed in attack on UN mission in southern Lebanon, officials say Reuters French peacekeeper killed in southern Lebanon BBC Macron, UNIFIL blame Hezbollah for killing of French peacekeeper in Lebanon The Times of Israel French soldier killed in attack on U.N. peacekeepers in Lebanon PBS UN chief strongly condemns killing of another peacekeeper in southern Lebanon UN News","title":"French soldier killed in attack on UN mission in southern Lebanon, officials say - Reuters","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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 252126 in events