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/CBMifEFVX3lxTE9sWUd0WUxzdHUxMzNSMnNOU3ZjQndNRGlQVVk1SXJua04zUHhEdzJIdTV0VFIwaFdfTnlpSVNBNzU2SkI4YjRPV1BmNGFCT2lHTlBkdVpVNGpBQ0RtTk9RYW1idEljVm1oU1VPa1F4UU5VekFoSmtJUVBuNk7SAYIBQVVfeXFMT0Y0TVhsc2JjeHRPODMyTEs2Q2p1U0tzWjVwaGhJaXBmLXJWM3U1MTdWVXkxdXFybURma3JGdjJnbldldW83TXhKZWRJc2NLR01pUFp2d0EtMjZJN1NLbGgyVWg1YmI5OTdDa2VfVU5salR4Q1FzWXloNld0MF9uN3oxQQ?oc=5","as_of":"2026-04-08T04:03:42.200945+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/CBMifEFVX3lxTE9sWUd0WUxzdHUxMzNSMnNOU3ZjQndNRGlQVVk1SXJua04zUHhEdzJIdTV0VFIwaFdfTnlpSVNBNzU2SkI4YjRPV1BmNGFCT2lHTlBkdVpVNGpBQ0RtTk9RYW1idEljVm1oU1VPa1F4UU5VekFoSmtJUVBuNk7SAYIBQVVfeXFMT0Y0TVhsc2JjeHRPODMyTEs2Q2p1U0tzWjVwaGhJaXBmLXJWM3U1MTdWVXkxdXFybURma3JGdjJnbldldW83TXhKZWRJc2NLR01pUFp2d0EtMjZJN1NLbGgyVWg1YmI5OTdDa2VfVU5salR4Q1FzWXloNld0MF9uN3oxQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e552e84d6cfc722d","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-08T04:04:08.926672+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifEFVX3lxTE9sWUd0WUxzdHUxMzNSMnNOU3ZjQndNRGlQVVk1SXJua04zUHhEdzJIdTV0VFIwaFdfTnlpSVNBNzU2SkI4YjRPV1BmNGFCT2lHTlBkdVpVNGpBQ0RtTk9RYW1idEljVm1oU1VPa1F4UU5VekFoSmtJUVBuNk7SAYIBQVVfeXFMT0Y0TVhsc2JjeHRPODMyTEs2Q2p1U0tzWjVwaGhJaXBmLXJWM3U1MTdWVXkxdXFybURma3JGdjJnbldldW83TXhKZWRJc2NLR01pUFp2d0EtMjZJN1NLbGgyVWg1YmI5OTdDa2VfVU5salR4Q1FzWXloNld0MF9uN3oxQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifEFVX3lxTE9sWUd0WUxzdHUxMzNSMnNOU3ZjQndNRGlQVVk1SXJua04zUHhEdzJIdTV0VFIwaFdfTnlpSVNBNzU2SkI4YjRPV1BmNGFCT2lHTlBkdVpVNGpBQ0RtTk9RYW1idEljVm1oU1VPa1F4UU5VekFoSmtJUVBuNk7SAYIBQVVfeXFMT0Y0TVhsc2JjeHRPODMyTEs2Q2p1U0tzWjVwaGhJaXBmLXJWM3U1MTdWVXkxdXFybURma3JGdjJnbldldW83TXhKZWRJc2NLR01pUFp2d0EtMjZJN1NLbGgyVWg1YmI5OTdDa2VfVU5salR4Q1FzWXloNld0MF9uN3oxQQ?oc=5","source_event_id":"evt_e75e4eb3591c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"558d9a116dc05b86","published_at":"2026-04-07T23:33:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Republicans","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"other","name":"Democrats","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"CBS News","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the substantive CBS News content; therefore, details about the specific Iran threat, which GOP figures spoke, and the exact basis for Democrats\u2019 removal call are not verifiable from the provided text.","No timing (date of the threat, when condemnation/removal calls occurred) is present in the provided material.","No direct market/operational impacts are stated in the provided headline/summary; only political and geopolitical risk implications can be inferred. (Inference marked as uncertain.)","The signal references other outlets (WSJ, USA Today, NYT, Politico) but their specific claims are not included in the provided text."],"key_facts":["CBS News headline states that few Republicans condemned Trump\u2019s Iran threat.","CBS News headline states that Democrats called for Trump\u2019s removal.","The Iran threat is framed as a trigger for political backlash within the U.S. (partisan disagreement)."],"numeric_claims":[],"primary_claim":"Few Republicans condemned Trump\u2019s Iran threat, while Democrats called for his removal, according to CBS News.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"CBS News reports that few Republicans have condemned President Trump\u2019s Iran-related threat, while Democrats are calling for his removal. The dispute centers on whether Trump\u2019s rhetoric implies escalation risk toward Iran.","topics":["U.S. politics","Iran threat","partisan condemnation","calls for removal","foreign policy escalation risk"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Few Republicans condemn Trump's Iran threat as Democrats call for his removal CBS News Trump Warns Iran \u2018Whole Civilization Will Die\u2019 WSJ Republican rebuke? See what some GOP figures said about Iran war USA Today How Tolls in the Strait of Hormuz Would Undercut International Law The New York Times 4 ways Trump has suggested the Strait of Hormuz could be reopened \u2014 and why they're a tough lift Politico","title":"Few Republicans condemn Trump's Iran threat as Democrats call for his removal - CBS News","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_b33531dd43a7 in signals