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/CBMibkFVX3lxTFBFWmtTQklJUFlpSE5hc3hZTXhTaTlNaDVwQU9rX092c1RMeTdTQjJISGFzWWhSbHZza3RYZTBrcFFwcE8xLU85VTN3SzZyVVJrLWhvalNoT0xiTThBVEhma3F0RHRZZE5aM2ZBMlNR?oc=5","as_of":"2026-04-09T11:22:55.044717+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/CBMibkFVX3lxTFBFWmtTQklJUFlpSE5hc3hZTXhTaTlNaDVwQU9rX092c1RMeTdTQjJISGFzWWhSbHZza3RYZTBrcFFwcE8xLU85VTN3SzZyVVJrLWhvalNoT0xiTThBVEhma3F0RHRZZE5aM2ZBMlNR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e61a853e16cff782","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-09T23:13:44.608567+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTFBFWmtTQklJUFlpSE5hc3hZTXhTaTlNaDVwQU9rX092c1RMeTdTQjJISGFzWWhSbHZza3RYZTBrcFFwcE8xLU85VTN3SzZyVVJrLWhvalNoT0xiTThBVEhma3F0RHRZZE5aM2ZBMlNR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTFBFWmtTQklJUFlpSE5hc3hZTXhTaTlNaDVwQU9rX092c1RMeTdTQjJISGFzWWhSbHZza3RYZTBrcFFwcE8xLU85VTN3SzZyVVJrLWhvalNoT0xiTThBVEhma3F0RHRZZE5aM2ZBMlNR?oc=5","source_event_id":"evt_56dcfc475c0a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e73a4f98740c8985","published_at":"2026-04-09T09:20:19+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"n/a","name":"United States (U.S.)","relevance":"high","symbol":"","type":"country"},{"asset_class":"n/a","name":"NPR","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual NPR article content; therefore, only the headline and the supplied source summary can be treated as grounded facts.","The specific \u201cpeace terms\u201d are not enumerated in the provided material.","Timing details for when strikes would resume (e.g., hours/days) are not specified in the provided headline/summary.","Whether any ceasefire deadline or negotiation window is explicitly tied to the Iran terms is not confirmed from the provided text."],"key_facts":["NPR headline indicates Trump warned that strikes will resume if Iran does not agree to his peace terms.","The dispute context is described as involving Israel\u2019s war in Lebanon casting doubt on a ceasefire (per provided source summary).","The provided source summary also includes additional Trump phrasing about readiness for \u201cnext conquest\u201d and keeping the military near Iran until a \u201creal agreement\u201d is honored (attribution: CNBC/CBS/WSJ/NYT references in the summary, not directly quoted from NPR text)."],"numeric_claims":[],"primary_claim":"Trump warned that U.S. strikes against Iran will resume if Iran does not agree to his peace terms.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"NPR reports that Donald Trump warned the U.S. would resume strikes against Iran unless Iran agrees to his stated \u201cpeace terms.\u201d The warning is framed as a conditional escalation tied to whether an agreement is honored.","topics":["U.S.-Iran tensions","military strikes","diplomatic conditions","threat of escalation","ceasefire uncertainty"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Trump warns strikes will resume if Iran doesn't agree to his peace terms NPR Trump says U.S. ready for 'next conquest,' warns military to remain near Iran until 'real agreement' is honored CNBC Live Updates: Trump threatens Iran as dispute over Israel's war in Lebanon casts doubt on ceasefire CBS News How the Journal Covered Trump\u2019s 12-Hour Iran \u2018Civilization\u2019 Countdown WSJ New Deadline Looms for U.S. and Iran as Truce Wavers The New York Times","title":"Trump warns strikes will resume if Iran doesn't agree to his peace terms - NPR","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

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