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/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

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_38c23e36eb55 in signals