SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_7dcd764fe1e1 in signals