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/CBMioAFBVV95cUxNeXIxTklnblRfcWx0YUxoSzA4ajRhcURNYmVzdUQ1TTZMd2k1UjdFOXZ1TnA5MWhWTWZCbjkwbW1VSWZSVUxaZl9rUEtNWTNZeHBSdDZoMHFrcXZVQnRfdmUyUkp2a3U3T3lKS1FTdUR0b0JGVFc3elJaWkYtbFJuQ25KM2l2b3M0RjN1eXFUNnIxc052UHc0bk1LWEllM2hN?oc=5","as_of":"2026-04-08T00:26:38.365496+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxNeXIxTklnblRfcWx0YUxoSzA4ajRhcURNYmVzdUQ1TTZMd2k1UjdFOXZ1TnA5MWhWTWZCbjkwbW1VSWZSVUxaZl9rUEtNWTNZeHBSdDZoMHFrcXZVQnRfdmUyUkp2a3U3T3lKS1FTdUR0b0JGVFc3elJaWkYtbFJuQ25KM2l2b3M0RjN1eXFUNnIxc052UHc0bk1LWEllM2hN?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0fa784671d8e5653","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:42:51.036163+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxNeXIxTklnblRfcWx0YUxoSzA4ajRhcURNYmVzdUQ1TTZMd2k1UjdFOXZ1TnA5MWhWTWZCbjkwbW1VSWZSVUxaZl9rUEtNWTNZeHBSdDZoMHFrcXZVQnRfdmUyUkp2a3U3T3lKS1FTdUR0b0JGVFc3elJaWkYtbFJuQ25KM2l2b3M0RjN1eXFUNnIxc052UHc0bk1LWEllM2hN?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/CBMioAFBVV95cUxNeXIxTklnblRfcWx0YUxoSzA4ajRhcURNYmVzdUQ1TTZMd2k1UjdFOXZ1TnA5MWhWTWZCbjkwbW1VSWZSVUxaZl9rUEtNWTNZeHBSdDZoMHFrcXZVQnRfdmUyUkp2a3U3T3lKS1FTdUR0b0JGVFc3elJaWkYtbFJuQ25KM2l2b3M0RjN1eXFUNnIxc052UHc0bk1LWEllM2hN?oc=5","source_event_id":"evt_da0e660c2aaa","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"96a01d42783cc24d","published_at":"2026-04-07T20:14:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Pope Leo XIV","relevance":"primary speaker","symbol":"","type":"person"},{"asset_class":"","name":"Donald Trump","relevance":"target of Pope\u2019s criticism","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"subject of the threat","symbol":"","type":"country"},{"asset_class":"","name":"AP News","relevance":"source","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the substantive article content; therefore, details beyond the headline/source summary cannot be verified from the provided text.","The exact wording of Trump\u2019s threat (beyond the paraphrase \u201cdestroy Iranian civilization\u201d) and the date/context of Trump\u2019s statement are not included in the provided material.","No direct information is provided on any immediate policy actions, sanctions, or diplomatic steps resulting from the Pope\u2019s comment.","Near-term catalyst timing for markets/policy is not specified in the provided headline/summary."],"key_facts":["AP News reports that Pope Leo XIV said Trump\u2019s threat to destroy Iranian civilization is \u201ctruly unacceptable.\u201d","The statement is framed as a stiff rebuke of Trump\u2019s war-related threats toward Iran (per the provided source summary context)."],"numeric_claims":[],"primary_claim":"The Pope said Trump\u2019s threat to destroy Iranian civilization is \u201ctruly unacceptable.\u201d","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Pope Leo XIV publicly condemned Donald Trump\u2019s stated threat to \u201cdestroy Iranian civilization,\u201d calling it \u201ctruly unacceptable.\u201d The rebuke escalates high-profile religious and diplomatic criticism of Trump\u2019s rhetoric toward Iran.","topics":["Iran","U.S.-Iran relations","political rhetoric","Vatican statements","geopolitical risk","religious diplomacy"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Pope says Trump\u2019s threat to destroy Iranian civilization is \u2018truly unacceptable\u2019 AP News Opinion | Pope Leo XIV Goes to War WSJ Pope issues stiffest rebuke yet to Trump over war threats Axios Pope Leo condemns Trump\u2019s latest threats against Iran Politico Pope Leo denounces Trump\u2019s threat to destroy Iran\u2019s \u2018whole civilization\u2019 The Washington Post","title":"Pope says Trump\u2019s threat to destroy Iranian civilization is \u2018truly unacceptable\u2019 - AP News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_8332d4712049 in signals