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-06T21:50:13.371217+00:00","dedupe_key":"signal_enriched:news_delta:16dfda964274f6ca","evidence_event_ids":["evt_1c7a180c5dd7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE8tejNqTzI4OV9wN0hqdk92dEpmQzhFQW5OTzdnbWFkOEJQeEtwRHE2dFZndW5iS0NITHpvaG15Z2hsdmxGZGx1RU1aYldaUWJaaV9LVDVERjR6TEdhT1k5V2RVNVN3XzYzMm9nZlJR?oc=5","as_of":"2026-04-06T21:50:13.371217+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/CBMibkFVX3lxTE8tejNqTzI4OV9wN0hqdk92dEpmQzhFQW5OTzdnbWFkOEJQeEtwRHE2dFZndW5iS0NITHpvaG15Z2hsdmxGZGx1RU1aYldaUWJaaV9LVDVERjR6TEdhT1k5V2RVNVN3XzYzMm9nZlJR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dac588c6f94b2c41","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-07T11:21:22.877177+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE8tejNqTzI4OV9wN0hqdk92dEpmQzhFQW5OTzdnbWFkOEJQeEtwRHE2dFZndW5iS0NITHpvaG15Z2hsdmxGZGx1RU1aYldaUWJaaV9LVDVERjR6TEdhT1k5V2RVNVN3XzYzMm9nZlJR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE8tejNqTzI4OV9wN0hqdk92dEpmQzhFQW5OTzdnbWFkOEJQeEtwRHE2dFZndW5iS0NITHpvaG15Z2hsdmxGZGx1RU1aYldaUWJaaV9LVDVERjR6TEdhT1k5V2RVNVN3XzYzMm9nZlJR?oc=5","source_event_id":"evt_1c7a180c5dd7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"540be85adbf6f1e3","published_at":"2026-04-06T19:10:02+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"N/A","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Specific details on the nature of the threats made by Trump are not provided.","The potential responses from Iran or international bodies are not discussed."],"key_facts":["Trump has repeatedly threatened military action against Iran.","Concerns have been raised about the legality of targeting civilian infrastructure in Iran."],"numeric_claims":[],"primary_claim":"Trump's threats to bomb Iran's infrastructure could constitute war crimes.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"Trump's escalating threats regarding potential military action against Iran have raised concerns about possible war crimes, particularly in relation to targeting civilian infrastructure.","topics":["war crimes","Iran","Trump","geopolitical tensions"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Trump\u2019s many threats of possible war crimes reach a crescendo in Iran CNN Live updates: Trump brushes off war crime concerns as he repeats threat to Iran's infrastructure AP News Why Trump\u2019s Iran Threats Are Raising War Crimes Concerns Bloomberg.com Trump shrugs off concerns that threat to bomb Iran\u2019s infrastructure could amount to war crimes \u2013 US politics live The Guardian In maps and photos: Five Iranian civilian bridges at risk of US strikes Al Jazeera","title":"Trump\u2019s many threats of possible war crimes reach a crescendo in Iran - CNN","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

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 37117 in events