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-08T08:52:34.313625+00:00","dedupe_key":"signal_enriched:news_delta:df12556f252302b9","evidence_event_ids":["evt_e70a05e6a2bb"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNTWFncnpkMnZDZFVsZnNsLUlwb0Q0QUF0UjNQRHFuNUU0cHpLSFJrLVNuTFowUGdlVXZVUU9adlplX0t5cjFSSjZ1dTdEaWVoOWVaVV9icWZJSU4zbzBydUlVeExvckpldTZnOXNNQkt6YVg4c0tncVkyNTVEazQ5UEpmVQ?oc=5","as_of":"2026-04-08T08:52:34.313625+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/CBMigwFBVV95cUxNTWFncnpkMnZDZFVsZnNsLUlwb0Q0QUF0UjNQRHFuNUU0cHpLSFJrLVNuTFowUGdlVXZVUU9adlplX0t5cjFSSjZ1dTdEaWVoOWVaVV9icWZJSU4zbzBydUlVeExvckpldTZnOXNNQkt6YVg4c0tncVkyNTVEazQ5UEpmVQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4f566b2fa12db012","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-08T08:52:57.737702+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxNTWFncnpkMnZDZFVsZnNsLUlwb0Q0QUF0UjNQRHFuNUU0cHpLSFJrLVNuTFowUGdlVXZVUU9adlplX0t5cjFSSjZ1dTdEaWVoOWVaVV9icWZJSU4zbzBydUlVeExvckpldTZnOXNNQkt6YVg4c0tncVkyNTVEazQ5UEpmVQ?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/CBMigwFBVV95cUxNTWFncnpkMnZDZFVsZnNsLUlwb0Q0QUF0UjNQRHFuNUU0cHpLSFJrLVNuTFowUGdlVXZVUU9adlplX0t5cjFSSjZ1dTdEaWVoOWVaVV9icWZJSU4zbzBydUlVeExvckpldTZnOXNNQkt6YVg4c0tncVkyNTVEazQ5UEpmVQ?oc=5","source_event_id":"evt_e70a05e6a2bb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4a2a50624b037f58","published_at":"2026-04-08T06:24:24+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Jimmy Kimmel","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Rolling Stone","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"The Guardian","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"Variety","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"The Daily Beast","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual NYT article content; therefore, the specific details of what Trump said/posted are not verifiable from the supplied text.","The \u201ctwo-week\u201d timing and \u201cdelaying Iran strike\u201d claims are present only in the signal\u2019s source summary and are not substantiated by the NYT text in the provided material.","No concrete policy action (e.g., strike order, sanctions, troop movement) is described in the supplied content\u2014only perceived messaging and commentary are indicated."],"key_facts":["The New York Times headline states there are \u201cLate Night Puzzles\u201d over Trump\u2019s \u201cMixed Message\u201d on Iran.","The provided source summary includes commentary from Jimmy Kimmel about Trump not destroying Iran and about Trump \u201cteas[ing] a bombing.\u201d","The provided source summary includes the claim that Trump \u201cAlways Gives Two Weeks After Delaying Iran Strike\u201d (as attributed in the signal to Variety/Daily Beast-style coverage)."],"numeric_claims":[],"primary_claim":"The New York Times reports that Trump\u2019s Iran-related messaging is perceived as a \u201cmixed message,\u201d prompting late-night discussion.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The New York Times highlights confusion over President Trump\u2019s messaging on Iran, describing it as a \u201cmixed message.\u201d The broader set of entertainment/pundit coverage referenced in the signal frames Trump\u2019s Iran-related communications as teasing or delaying a potential strike.","topics":["Iran","U.S. foreign policy","Trump messaging","potential military action","media commentary","timing/delay"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Late Night Puzzles Over Trump\u2019s \u2018Mixed Message\u2019 on Iran The New York Times Jimmy Kimmel Celebrates Trump Not Destroying Iran: 'The Taco Tuesday of All Taco Tuesdays' Rolling Stone Jimmy Kimmel on Trump\u2019s posts: \u2018The only president who teases a bombing the same way ABC promotes episodes\u2019 The Guardian Jimmy Kimmel: Trump Always Gives Two Weeks After Delaying Iran Strike Variety Jimmy Kimmel Predicts How Trump\u2019s Two-Week Iran Deadline Will End The Daily Beast","title":"Late Night Puzzles Over Trump\u2019s \u2018Mixed Message\u2019 on Iran - The New York Times","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 5526 in events