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/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

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_46317c66d74d in signals