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-20T10:45:39.407556+00:00","dedupe_key":"signal_enriched:news_delta:d87795399e7d1656","evidence_event_ids":["evt_63b3e70f8393"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMicEFVX3lxTE1vTHBHU2dOLThKb3RNRjF0STNmNERNRzd4ZHlubTRGNE1SXzJxQnpjOU9MdUhrRDBBZTJXdmJIOWwyamZwYjhkeEpWVnVxVndEanhHd0hFQWdjTkpteDRMZ1RBVXB0alpPdUMxbjNVN0g?oc=5","as_of":"2026-04-20T10:45:39.407556+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/CBMicEFVX3lxTE1vTHBHU2dOLThKb3RNRjF0STNmNERNRzd4ZHlubTRGNE1SXzJxQnpjOU9MdUhrRDBBZTJXdmJIOWwyamZwYjhkeEpWVnVxVndEanhHd0hFQWdjTkpteDRMZ1RBVXB0alpPdUMxbjNVN0g?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_410b9c0b1af4cd9f","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-20T10:46:30.799275+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMicEFVX3lxTE1vTHBHU2dOLThKb3RNRjF0STNmNERNRzd4ZHlubTRGNE1SXzJxQnpjOU9MdUhrRDBBZTJXdmJIOWwyamZwYjhkeEpWVnVxVndEanhHd0hFQWdjTkpteDRMZ1RBVXB0alpPdUMxbjNVN0g?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMicEFVX3lxTE1vTHBHU2dOLThKb3RNRjF0STNmNERNRzd4ZHlubTRGNE1SXzJxQnpjOU9MdUhrRDBBZTJXdmJIOWwyamZwYjhkeEpWVnVxVndEanhHd0hFQWdjTkpteDRMZ1RBVXB0alpPdUMxbjNVN0g?oc=5","source_event_id":"evt_63b3e70f8393","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"b5ce0555cfeaac2e","published_at":"2026-04-20T02:15:09+00:00","publisher_domain":"nytimes.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: From Pulpits to Pews, Trump and the Pope Are on the Minds of Catholics - The New York Times","Source summary: From Pulpits to Pews, Trump and the Pope Are on the Minds of Catholics The New York Times The pope's English fuels a Trump feud Axios Even Catholic Trump supporters feel conflicted over the president\u2019s tiff with the pope CNN Trump's clash with Pope Leo XIV divides Catholics USA Today Chicago faith community stands up for Pope Leo XIV amid back-and-forth with President Trump CBS News"],"numeric_claims":[],"primary_claim":"From Pulpits to Pews, Trump and the Pope Are on the Minds of Catholics - The New York Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"From Pulpits to Pews, Trump and the Pope Are on the Minds of Catholics The New York Times The pope's English fuels a Trump feud Axios Even Catholic Trump supporters feel conflicted over the president\u2019s tiff with the pope CNN Trump's clash with Pope Leo XIV divides Catholics USA Today Chicago faith community stands up for Pope Leo XIV amid back-and-forth with President Trump CBS News","topics":["news headline"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"From Pulpits to Pews, Trump and the Pope Are on the Minds of Catholics The New York Times The pope's English fuels a Trump feud Axios Even Catholic Trump supporters feel conflicted over the president\u2019s tiff with the pope CNN Trump's clash with Pope Leo XIV divides Catholics USA Today Chicago faith community stands up for Pope Leo XIV amid back-and-forth with President Trump CBS News","title":"From Pulpits to Pews, Trump and the Pope Are on the Minds of Catholics - The New York Times","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 423329 in events