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/CBMiigFBVV95cUxOT0JPd2RIUThmQi1pOEQ4N1hBUHl5Q0hnOHRfQldBWnVpOU10V0lGS295TlVOa3RkOXBRdWQzS1NRb2xHUnctRkhxc2szVWZUcWhWakZNUXNDQnpZTUtnaFFIOXhmVUFLV2JyaVh3d3RQQzJJMUE1cThuYXJ6ZWliOUxGSnFvUEl4YlE?oc=5","as_of":"2026-04-08T10:23:24.696570+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/CBMiigFBVV95cUxOT0JPd2RIUThmQi1pOEQ4N1hBUHl5Q0hnOHRfQldBWnVpOU10V0lGS295TlVOa3RkOXBRdWQzS1NRb2xHUnctRkhxc2szVWZUcWhWakZNUXNDQnpZTUtnaFFIOXhmVUFLV2JyaVh3d3RQQzJJMUE1cThuYXJ6ZWliOUxGSnFvUEl4YlE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bf5c6cf0b38819d6","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-08T10:23:56.010060+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxOT0JPd2RIUThmQi1pOEQ4N1hBUHl5Q0hnOHRfQldBWnVpOU10V0lGS295TlVOa3RkOXBRdWQzS1NRb2xHUnctRkhxc2szVWZUcWhWakZNUXNDQnpZTUtnaFFIOXhmVUFLV2JyaVh3d3RQQzJJMUE1cThuYXJ6ZWliOUxGSnFvUEl4YlE?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/CBMiigFBVV95cUxOT0JPd2RIUThmQi1pOEQ4N1hBUHl5Q0hnOHRfQldBWnVpOU10V0lGS295TlVOa3RkOXBRdWQzS1NRb2xHUnctRkhxc2szVWZUcWhWakZNUXNDQnpZTUtnaFFIOXhmVUFLV2JyaVh3d3RQQzJJMUE1cThuYXJ6ZWliOUxGSnFvUEl4YlE?oc=5","source_event_id":"evt_e44409c1b4f2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"99581b64e65d54b6","published_at":"2026-04-08T00:02:40+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"central","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"central","symbol":"","type":"country"},{"asset_class":"","name":"Iranian athletes","relevance":"supporting","symbol":"","type":"group"},{"asset_class":"","name":"The New York Times","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"","name":"Truth Social","relevance":"supporting","symbol":"","type":"platform"},{"asset_class":"","name":"Fox News","relevance":"supporting","symbol":"","type":"publisher"},{"asset_class":"","name":"Slate Magazine","relevance":"supporting","symbol":"","type":"publisher"},{"asset_class":"","name":"The Daily Beast","relevance":"supporting","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text contains only CSS/HTML styling, not the article\u2019s substantive content; therefore, the specific arguments/evidence used by the NYT are not verifiable from the provided text.","No date/time of the quoted statement or context (e.g., when/where Trump said it) is included in the provided material.","No direct confirmation of any concrete government action toward Iran is present\u2014only rhetoric and reactions are indicated."],"key_facts":["The New York Times headline states that Trump\u2019s rhetoric about Iran \u201cgoes beyond bluster.\u201d","The headline references a warning phrase: \u201ca whole civilization will die tonight.\u201d","The provided source summary indicates Iranian athletes responded to Trump\u2019s warning.","The signal is presented as a headline delta (headline change/variation) rather than a new policy action; the article text provided is not actually available (only CSS/HTML styling was included), so detailed substantiation is not accessible here."],"numeric_claims":[],"primary_claim":"The New York Times claims Trump\u2019s rhetoric about Iran includes an \u201ca whole civilization will die tonight\u201d warning that is beyond bluster and framed as threatening to wipe out Iran\u2019s civilization.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The New York Times headline alleges that Donald Trump\u2019s rhetoric about Iran\u2014specifically a claim that \u201ca whole civilization will die tonight\u201d\u2014goes beyond mere bluster and is framed as an existential threat. The signal also notes Iranian athletes responding to the warning.","topics":["Iran","Trump rhetoric","existential threat language","international relations","media reaction","Truth Social","sports response"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"With Threat to Wipe Out Iran\u2019s Civilization, Trump\u2019s Rhetoric Goes Beyond Bluster The New York Times Iranian athletes respond to Trump's warning that 'a whole civilization will die tonight' Fox News Trump Has Posted a Lot of Psychopathic Things Online. His Latest Truth Social Update Might Be His Worst. Slate Magazine How Trump Just Proved He Is the Worst of the Worst The Daily Beast \u201cA Whole Civilization Will Die\u201d American Reformer","title":"With Threat to Wipe Out Iran\u2019s Civilization, Trump\u2019s Rhetoric Goes Beyond Bluster - 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_a2b88931142f in signals