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-08T04:03:42.183918+00:00","dedupe_key":"signal_enriched:news_delta:85afb5a4e0d69ad9","evidence_event_ids":["evt_1c112d1e75ff"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxNUkZ2azMwVFhZSVdpQ0tjZnA2T05OX0ZTWGVZS0J2ZF96N1hZbUFSTHhmQ0VjaThpLVJXMDNISzVCUVNVUW9yZ3JiOXp6LVhTVmVjZnlVN1RraTVpMU9KVjR1UmJMZTY2NlkxUmJ2NC1JNkJNaFhLMjVHcFQ5cmF2ZXVB?oc=5","as_of":"2026-04-08T04:03:42.183918+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/CBMiggFBVV95cUxNUkZ2azMwVFhZSVdpQ0tjZnA2T05OX0ZTWGVZS0J2ZF96N1hZbUFSTHhmQ0VjaThpLVJXMDNISzVCUVNVUW9yZ3JiOXp6LVhTVmVjZnlVN1RraTVpMU9KVjR1UmJMZTY2NlkxUmJ2NC1JNkJNaFhLMjVHcFQ5cmF2ZXVB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_551d250f0d56bb66","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-08T04:04:05.499714+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxNUkZ2azMwVFhZSVdpQ0tjZnA2T05OX0ZTWGVZS0J2ZF96N1hZbUFSTHhmQ0VjaThpLVJXMDNISzVCUVNVUW9yZ3JiOXp6LVhTVmVjZnlVN1RraTVpMU9KVjR1UmJMZTY2NlkxUmJ2NC1JNkJNaFhLMjVHcFQ5cmF2ZXVB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxNUkZ2azMwVFhZSVdpQ0tjZnA2T05OX0ZTWGVZS0J2ZF96N1hZbUFSTHhmQ0VjaThpLVJXMDNISzVCUVNVUW9yZ3JiOXp6LVhTVmVjZnlVN1RraTVpMU9KVjR1UmJMZTY2NlkxUmJ2NC1JNkJNaFhLMjVHcFQ5cmF2ZXVB?oc=5","source_event_id":"evt_1c112d1e75ff","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"77a892f3d32e09d1","published_at":"2026-04-08T00:36:12+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Pope Leo XIV","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Axios","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no readable body content (only HTML/CSS), so the extraction relies on the headline and the provided source summary rather than the full article text.","The specific date/time of the rebuke and the cease-fire news are not included in the provided text.","The exact quote and context (e.g., speech/statement location and audience) are not fully verifiable from the provided content.","Whether the cease-fire is directly related to the Pope\u2019s comments is not stated\u2014only that it occurred hours later."],"key_facts":["Axios headline states the Pope issued his stiffest rebuke yet to Trump over war threats.","The rebuke is described as being in response to Trump\u2019s war threats involving Iran.","Source summary indicates the Pope\u2019s rebuke occurred hours before news of a cease-fire.","Multiple other outlets are referenced in the provided source summary as also covering the Pope\u2019s condemnation of Trump\u2019s threat to destroy Iran\u2019s \u2018whole civilization\u2019 (exact wording attributed in the summary)."],"numeric_claims":[],"primary_claim":"Axios reports that Pope Leo XIV issued his stiffest rebuke yet to Donald Trump over war threats, hours before news of a cease-fire.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Pope Leo XIV issued what Axios describes as his stiffest rebuke yet to Donald Trump regarding Trump\u2019s war threats, including threats tied to Iran. The rebuke reportedly came hours before news of a cease-fire.","topics":["Vatican","Papal statements","U.S. politics","Iran war threats","cease-fire timing","geopolitical risk"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"Pope issues stiffest rebuke yet to Trump over war threats Axios Hours Before News of Cease-Fire, Pope Leo XIV Issues Strong Rebuke of Trump The New York Times Opinion | Pope Leo XIV Goes to War WSJ Pope says Trump\u2019s threat to destroy Iranian civilization is \u2018truly unacceptable\u2019 AP News Pope Leo denounces Trump\u2019s threat to destroy Iran\u2019s \u2018whole civilization\u2019 The Washington Post","title":"Pope issues stiffest rebuke yet to Trump over war threats - Axios","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 4475 in events