SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-10T00:04:56.344455+00:00","dedupe_key":"signal_enriched:news_delta:e3c6f72e300a0579","evidence_event_ids":["evt_4891f4fda111"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 11666 in events