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/CBMikgFBVV95cUxOb0N4dGxCbDZ0alNIbTVjS1F3cmdPY3ltU0R0bVhkVXdkT3g1WkNZdWlEc3ViaTVPaHNlNUVIZkdQQVZ2Qlh2Z3VaNjlwbHhIaVNHN0VDdThla2RoZ21WQ3dWTXdIUEcydmIxaFQ4YmNJbDM2d2VRbk96S0RLWkNYUHg3WXgwUkhRMG1JZHVhcW5wdw?oc=5","as_of":"2026-04-08T04:18:54.872231+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/CBMikgFBVV95cUxOb0N4dGxCbDZ0alNIbTVjS1F3cmdPY3ltU0R0bVhkVXdkT3g1WkNZdWlEc3ViaTVPaHNlNUVIZkdQQVZ2Qlh2Z3VaNjlwbHhIaVNHN0VDdThla2RoZ21WQ3dWTXdIUEcydmIxaFQ4YmNJbDM2d2VRbk96S0RLWkNYUHg3WXgwUkhRMG1JZHVhcW5wdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c12644baaec3fd8d","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:19:19.834108+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOb0N4dGxCbDZ0alNIbTVjS1F3cmdPY3ltU0R0bVhkVXdkT3g1WkNZdWlEc3ViaTVPaHNlNUVIZkdQQVZ2Qlh2Z3VaNjlwbHhIaVNHN0VDdThla2RoZ21WQ3dWTXdIUEcydmIxaFQ4YmNJbDM2d2VRbk96S0RLWkNYUHg3WXgwUkhRMG1JZHVhcW5wdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOb0N4dGxCbDZ0alNIbTVjS1F3cmdPY3ltU0R0bVhkVXdkT3g1WkNZdWlEc3ViaTVPaHNlNUVIZkdQQVZ2Qlh2Z3VaNjlwbHhIaVNHN0VDdThla2RoZ21WQ3dWTXdIUEcydmIxaFQ4YmNJbDM2d2VRbk96S0RLWkNYUHg3WXgwUkhRMG1JZHVhcW5wdw?oc=5","source_event_id":"evt_4ca3b5d3544f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6c2414ef00c63cc5","published_at":"2026-04-08T02:04:26+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","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":"The New York Times","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual article content, so details beyond the headline and the provided source summary cannot be verified here.","The specific date/time of the cease-fire news and the exact timing of the pope\u2019s rebuke are not included in the provided text.","No direct quote from the New York Times article is available in the provided material\u2014only paraphrased language from the source summary."],"key_facts":["The headline states the rebuke occurred \u201chours before news of cease-fire.\u201d","The rebuke is directed at Donald Trump.","The rebuke concerns Trump\u2019s \u201cwar threats\u201d toward Iran.","The reporting (as reflected in the provided source summary) characterizes Trump\u2019s threat as unacceptable, including language about destroying Iran\u2019s \u201cwhole civilization.\u201d"],"numeric_claims":[],"primary_claim":"Hours before cease-fire news, Pope Leo XIV issued a strong rebuke of Trump over his war threats toward Iran, including a condemnation of a threat to destroy Iran\u2019s \u201cwhole civilization.\u201d","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The New York Times reports that Pope Leo XIV issued a strong rebuke of Donald Trump shortly before news of a cease-fire, criticizing Trump\u2019s war-related threats toward Iran. The rebuke is described as unusually forceful and centered on the claim that Trump\u2019s threat to destroy Iran\u2019s \u201ccivilization\u201d is unacceptable.","topics":["Vatican/pope statements","U.S.-Iran tensions","cease-fire timing","political rhetoric","war threats"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"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 issues stiffest rebuke yet to Trump over war threats axios.com 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":"Hours Before News of Cease-Fire, Pope Leo XIV Issues Strong Rebuke of Trump - The New York Times","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_e649c892aa33 in signals