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-18T17:12:32.407194+00:00","dedupe_key":"signal_enriched:news_delta:36e333fcfe645d43","evidence_event_ids":["evt_e6e5bc795929"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOeDhhWE5McGtlNGFzb1lVenpTbXhwWlZ2elFFM2hTRGI1VGp0RzhIZDJTVGppdFNjR1J4VjBWanRvNnFPcXRiTl9SbmQ4LVB5QVM3NE9jR3hSRGVOUXZ4NzZPUEZOek1ZY2x6bnZxY3pabWRnWjFLZWVuTGVUdVBEX3hRMWxSM29PbTVYaDUyZkg?oc=5","as_of":"2026-04-18T17:12:32.407194+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/CBMikAFBVV95cUxOeDhhWE5McGtlNGFzb1lVenpTbXhwWlZ2elFFM2hTRGI1VGp0RzhIZDJTVGppdFNjR1J4VjBWanRvNnFPcXRiTl9SbmQ4LVB5QVM3NE9jR3hSRGVOUXZ4NzZPUEZOek1ZY2x6bnZxY3pabWRnWjFLZWVuTGVUdVBEX3hRMWxSM29PbTVYaDUyZkg?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0f52e707b6aa5370","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-18T17:13:23.105634+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOeDhhWE5McGtlNGFzb1lVenpTbXhwWlZ2elFFM2hTRGI1VGp0RzhIZDJTVGppdFNjR1J4VjBWanRvNnFPcXRiTl9SbmQ4LVB5QVM3NE9jR3hSRGVOUXZ4NzZPUEZOek1ZY2x6bnZxY3pabWRnWjFLZWVuTGVUdVBEX3hRMWxSM29PbTVYaDUyZkg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOeDhhWE5McGtlNGFzb1lVenpTbXhwWlZ2elFFM2hTRGI1VGp0RzhIZDJTVGppdFNjR1J4VjBWanRvNnFPcXRiTl9SbmQ4LVB5QVM3NE9jR3hSRGVOUXZ4NzZPUEZOek1ZY2x6bnZxY3pabWRnWjFLZWVuTGVUdVBEX3hRMWxSM29PbTVYaDUyZkg?oc=5","source_event_id":"evt_e6e5bc795929","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"99c6e557ccaf0d37","published_at":"2026-04-18T14:57:00+00:00","publisher_domain":"apnews.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: Pope hopes to bring a message of joy to long-suffering Angolans on the third leg of his Africa tour - AP News","Source summary: Pope hopes to bring a message of joy to long-suffering Angolans on the third leg of his Africa tour AP News In Angola, Pope Leo XIV Faces the Legacy of Colonialism The New York Times Pope Leo XIV's visit to an African church linked to slavery reflects on his own complex heritage AP News Pope\u2019s Mass for more than 100,000 in Cameroon highlights Catholicism\u2019s growth in Africa CNN Pope Leo heads to Angola in landmark Afr"],"numeric_claims":[],"primary_claim":"Pope hopes to bring a message of joy to long-suffering Angolans on the third leg of his Africa tour - AP News","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Pope hopes to bring a message of joy to long-suffering Angolans on the third leg of his Africa tour AP News In Angola, Pope Leo XIV Faces the Legacy of Colonialism The New York Times Pope Leo XIV's visit to an African church linked to slavery reflects on his own complex heritage AP News Pope\u2019s Mass for more than 100,000 in Cameroon highlights Catholicism\u2019s growth in Africa CNN Pope Leo heads to An","topics":["news headline"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Pope hopes to bring a message of joy to long-suffering Angolans on the third leg of his Africa tour AP News In Angola, Pope Leo XIV Faces the Legacy of Colonialism The New York Times Pope Leo XIV's visit to an African church linked to slavery reflects on his own complex heritage AP News Pope\u2019s Mass for more than 100,000 in Cameroon highlights Catholicism\u2019s growth in Africa CNN Pope Leo heads to Angola in landmark Africa visit amid Trump clash Al Jazeera","title":"Pope hopes to bring a message of joy to long-suffering Angolans on the third leg of his Africa tour - AP News","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 213387 in events