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-08T10:54:38.574790+00:00","dedupe_key":"signal_enriched:news_delta:a3e8c718582e2f13","evidence_event_ids":["evt_859214f271e2"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxNUDV4NVpxc0UydnJFR3ZtY1VEQ3NBSW1SQWxIYTBrRjJkNm1MdXIzT01wdDZ2WG8xR2o0LVBOc0l3aXZhaG03TjJvMXNhdXM3UzkwT0N5eHNRWjRTbnp5RVRJNUNETDFEc2lldU1xYjNHLWE5NjJNaThMaHgzTy1zMUZVNGw3bC03MGR1aQ?oc=5","as_of":"2026-04-08T10:54:38.574790+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/CBMijAFBVV95cUxNUDV4NVpxc0UydnJFR3ZtY1VEQ3NBSW1SQWxIYTBrRjJkNm1MdXIzT01wdDZ2WG8xR2o0LVBOc0l3aXZhaG03TjJvMXNhdXM3UzkwT0N5eHNRWjRTbnp5RVRJNUNETDFEc2lldU1xYjNHLWE5NjJNaThMaHgzTy1zMUZVNGw3bC03MGR1aQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f4f9ba3e5592a4e5","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-08T10:55:30.415410+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxNUDV4NVpxc0UydnJFR3ZtY1VEQ3NBSW1SQWxIYTBrRjJkNm1MdXIzT01wdDZ2WG8xR2o0LVBOc0l3aXZhaG03TjJvMXNhdXM3UzkwT0N5eHNRWjRTbnp5RVRJNUNETDFEc2lldU1xYjNHLWE5NjJNaThMaHgzTy1zMUZVNGw3bC03MGR1aQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxNUDV4NVpxc0UydnJFR3ZtY1VEQ3NBSW1SQWxIYTBrRjJkNm1MdXIzT01wdDZ2WG8xR2o0LVBOc0l3aXZhaG03TjJvMXNhdXM3UzkwT0N5eHNRWjRTbnp5RVRJNUNETDFEc2lldU1xYjNHLWE5NjJNaThMaHgzTy1zMUZVNGw3bC03MGR1aQ?oc=5","source_event_id":"evt_859214f271e2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bbe4be748eba52ce","published_at":"2026-04-08T05:03:40+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"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":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Washington Post","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Times","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"AP News","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"Axios","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"Times of Israel","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not usable for extracting the actual quote or full context; extraction is based on the headline and the supplied source summaries.","Exact date/time of the Pope\u2019s statement and the cease-fire announcement are not specified in the provided text.","The specific wording of the Pope\u2019s statement beyond \u201ctruly unacceptable\u201d and \u201cwhole civilization\u201d is not fully verifiable from the provided content."],"key_facts":["The Washington Post headline reports Pope Leo denounced Trump\u2019s threat to destroy Iran\u2019s \u201cwhole civilization.\u201d","Other provided source summaries state Pope Leo called the threat \u201ctruly unacceptable\u201d and issued a \u201cstiffest rebuke yet\u201d to Trump over war threats.","Source summaries indicate the rebuke was issued \u201chours before\u201d news of a cease-fire in the Iran war (timing context)."],"numeric_claims":[],"primary_claim":"Pope Leo XIV denounced Donald Trump\u2019s threat to destroy Iran\u2019s \u201cwhole civilization\u201d as \u201ctruly unacceptable.\u201d","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"Pope Leo XIV publicly rebuked Donald Trump for threatening to destroy Iran\u2019s \u201cwhole civilization,\u201d calling the threat unacceptable. The rebuke is reported as occurring around the same time as news of a cease-fire in the Iran war.","topics":["Pope","Vatican","Iran war","U.S.-Iran tensions","political rhetoric","cease-fire context"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Pope Leo denounces Trump\u2019s threat to destroy Iran\u2019s \u2018whole civilization\u2019 The Washington Post Hours Before News of Cease-Fire, Pope Leo XIV Issues Strong Rebuke of Trump The New York Times Pope Leo praises Iran war ceasefire after criticizing Trump threat The Times of Israel Pope says Trump\u2019s threat to destroy Iranian civilization is \u2018truly unacceptable\u2019 AP News Pope issues stiffest rebuke yet to Trump over war threats Axios","title":"Pope Leo denounces Trump\u2019s threat to destroy Iran\u2019s \u2018whole civilization\u2019 - The Washington Post","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 6047 in events