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/CBMirAFBVV95cUxQenpjbkdSVy1kSTd5N1BlVURRUGZjcnFvS3RleGNHT3pQSnNtc1pJbm9xd0VjS0VFNlpaYUxYd1lCS016VjRDZ1BaUVpIRVFtQXVTa1NNUHZTSWtqYTUwTGFWUXlRTFlyVzVyVDd1SmJLQXRJSWNtcTI3VHJFSWQ1NkpKT3lhOGZyUUpiTWxDclBUX0tEMVBUZXE5NkJlbVVPZXRLOUI1YWtNNl9U0gGyAUFVX3lxTFAtMkdweWlUWDN2cnFkakZETmlSYzZPcEZPUTJZZnNXMkxDUHVxOThiaDE2QW5xam1aTkgtUUwzejhJNWlFVFNRcGlVTE43NnhlUDdaWl8zc0pRUWltVjRDTWFTWDJUMFljWU9rVk8xeVEzWFJiVzB1NFp5YThHR1NMT1RTWmpFRHFpWm0zVm1WMFlfUEl4NTRqbEJHNWdXNHdYdDR4ai1XU2pEMm9oUWY0Unc?oc=5","as_of":"2026-04-10T00:04:56.344455+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/CBMirAFBVV95cUxQenpjbkdSVy1kSTd5N1BlVURRUGZjcnFvS3RleGNHT3pQSnNtc1pJbm9xd0VjS0VFNlpaYUxYd1lCS016VjRDZ1BaUVpIRVFtQXVTa1NNUHZTSWtqYTUwTGFWUXlRTFlyVzVyVDd1SmJLQXRJSWNtcTI3VHJFSWQ1NkpKT3lhOGZyUUpiTWxDclBUX0tEMVBUZXE5NkJlbVVPZXRLOUI1YWtNNl9U0gGyAUFVX3lxTFAtMkdweWlUWDN2cnFkakZETmlSYzZPcEZPUTJZZnNXMkxDUHVxOThiaDE2QW5xam1aTkgtUUwzejhJNWlFVFNRcGlVTE43NnhlUDdaWl8zc0pRUWltVjRDTWFTWDJUMFljWU9rVk8xeVEzWFJiVzB1NFp5YThHR1NMT1RTWmpFRHFpWm0zVm1WMFlfUEl4NTRqbEJHNWdXNHdYdDR4ai1XU2pEMm9oUWY0Unc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_27eea1758955725e","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-10T00:56:27.427221+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQenpjbkdSVy1kSTd5N1BlVURRUGZjcnFvS3RleGNHT3pQSnNtc1pJbm9xd0VjS0VFNlpaYUxYd1lCS016VjRDZ1BaUVpIRVFtQXVTa1NNUHZTSWtqYTUwTGFWUXlRTFlyVzVyVDd1SmJLQXRJSWNtcTI3VHJFSWQ1NkpKT3lhOGZyUUpiTWxDclBUX0tEMVBUZXE5NkJlbVVPZXRLOUI1YWtNNl9U0gGyAUFVX3lxTFAtMkdweWlUWDN2cnFkakZETmlSYzZPcEZPUTJZZnNXMkxDUHVxOThiaDE2QW5xam1aTkgtUUwzejhJNWlFVFNRcGlVTE43NnhlUDdaWl8zc0pRUWltVjRDTWFTWDJUMFljWU9rVk8xeVEzWFJiVzB1NFp5YThHR1NMT1RTWmpFRHFpWm0zVm1WMFlfUEl4NTRqbEJHNWdXNHdYdDR4ai1XU2pEMm9oUWY0Unc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pbs.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQenpjbkdSVy1kSTd5N1BlVURRUGZjcnFvS3RleGNHT3pQSnNtc1pJbm9xd0VjS0VFNlpaYUxYd1lCS016VjRDZ1BaUVpIRVFtQXVTa1NNUHZTSWtqYTUwTGFWUXlRTFlyVzVyVDd1SmJLQXRJSWNtcTI3VHJFSWQ1NkpKT3lhOGZyUUpiTWxDclBUX0tEMVBUZXE5NkJlbVVPZXRLOUI1YWtNNl9U0gGyAUFVX3lxTFAtMkdweWlUWDN2cnFkakZETmlSYzZPcEZPUTJZZnNXMkxDUHVxOThiaDE2QW5xam1aTkgtUUwzejhJNWlFVFNRcGlVTE43NnhlUDdaWl8zc0pRUWltVjRDTWFTWDJUMFljWU9rVk8xeVEzWFJiVzB1NFp5YThHR1NMT1RTWmpFRHFpWm0zVm1WMFlfUEl4NTRqbEJHNWdXNHdYdDR4ai1XU2pEMm9oUWY0Unc?oc=5","source_event_id":"evt_4891f4fda111","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"13d8dd08ebd9c7f1","published_at":"2026-04-09T21:14:32+00:00","publisher_domain":"pbs.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"PBS","relevance":"high","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"political_figure"},{"asset_class":"other","name":"Pete Hegseth","relevance":"high","symbol":"","type":"political_figure"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The Washington Post","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The Economist","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The New Yorker","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not the actual article content (it appears to be page styling/CSS), so specific fact-check details (what evidence contradicts the \u201cvictory\u201d claim) are not available here.","No dates, locations, or specific events/operations in the \u201cIran war\u201d are stated in the provided text.","The signal does not specify whether the \u201cIran war\u201d refers to a particular historical conflict, a hypothetical scenario, or a specific recent campaign; this ambiguity limits precision.","Near-term catalyst timing (e.g., when the fact-check is published or when related political statements occur) is not included in the provided material."],"key_facts":["The PBS headline indicates it is fact-checking claims by Trump and Hegseth about U.S. \u201cvictory\u201d in an Iran war.","The provided source summary references multiple outlets discussing the war\u2019s outcome and costs, including claims that Iran\u2019s leaders are confident and that Trump is portrayed as a major loser by some publications.","The Washington Post summary snippet says that after Trump pauses the war, Iranians fly flags of victory rather than surrender (as characterized in the provided summary)."],"numeric_claims":[],"primary_claim":"PBS is fact-checking Trump and Hegseth\u2019s claims that the U.S. \u201cvictory\u201d in the Iran war occurred, implying the claims are not supported as stated.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"PBS reports that it is fact-checking claims by Donald Trump and Pete Hegseth that the U.S. achieved a \u201cvictory\u201d in the Iran war. The coverage frames the outcome as contested, emphasizing that Iran\u2019s leaders appear confident rather than defeated.","topics":["fact-checking","U.S.-Iran conflict","political claims","war outcome narratives","media analysis"]},"source":"PBS","source_domain":"pbs.org","source_url":"https://www.pbs.org","summary":"Fact-checking Trump and Hegseth's claims of U.S. 'victory' in the Iran war PBS Iran\u2019s Battered Leaders Emerge From War Confident \u2014 and With New Cards The New York Times The Costs of Trump\u2019s Iran-War Folly The New Yorker After Trump pauses war, Iranians fly flags of victory, not surrender The Washington Post Donald Trump is the war\u2019s biggest loser The Economist","title":"Fact-checking Trump and Hegseth's claims of U.S. 'victory' in the Iran war - PBS","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_226c346c9781 in signals