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/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?oc=5","as_of":"2026-04-08T00:26:38.269417+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/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_15452357516bc256","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-08T00:42:37.181008+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?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/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?oc=5","source_event_id":"evt_23765b49c718","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9b4d6c8d2122f6f9","published_at":"2026-04-07T23:50:34+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Congressional Democrats","relevance":"primary","symbol":"","type":"political_group"},{"asset_class":"","name":"Donald Trump","relevance":"primary","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"primary","symbol":"","type":"country"},{"asset_class":"","name":"U.S. Congress","relevance":"secondary","symbol":"","type":"institution"},{"asset_class":"","name":"25th Amendment","relevance":"secondary","symbol":"","type":"legal_provision"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the substantive NPR content; extraction relies on the supplied headline and the \u201cSource Summary\u201d/other snippet text.","Specific details of what Trump said in the NPR piece (beyond the quoted warning mentioned in other snippets) are not fully verifiable from the provided cleaned text.","Near-term timing (exact date/time of any vote or procedural step) is not specified in the provided content; only general \u201cimmediate\u201d reaction is implied by other snippets.","Market/sector impacts are not stated; only political and geopolitical implications are suggested."],"key_facts":["NPR headline indicates Congressional Democrats raised alarm over Trump\u2019s comments on Iran.","Other provided source snippets indicate Hill Democrats discussed impeachment/removal and the 25th Amendment in response to Trump\u2019s Iran-related warning.","A cited Trump quote in the provided snippets is: \u201ca whole civilization will die tonight\u201d (context: warning about the Iran war)."],"numeric_claims":[],"primary_claim":"Congressional Democrats raised alarm over President Trump\u2019s comments about Iran.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"NPR reports that Congressional Democrats are alarmed by comments from President Trump about Iran, prompting calls on Capitol Hill for potential drastic action. The immediate political catalyst is the reaction to Trump\u2019s Iran remarks, with related coverage also discussing impeachment/removal and the 25th Amendment.","topics":["U.S. politics","Iran","Trump comments","Congressional reaction","impeachment/removal talk","25th Amendment"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Congressional Democrats raise alarm over Trump's comments on Iran NPR An eclectic, bipartisan group suddenly calls for removing Trump using the 25th Amendment CNN Northern California lawmakers denounce Trump's warning that \"a whole civilization will die tonight\" in Iran war CBS News Trump's Iran post causes talk of his impeachment, removal to erupt among Hill Democrats Axios House Democrats Seek Immediate Vote to Avert \u2018World War III\u2019 WSJ","title":"Congressional Democrats raise alarm over Trump's comments on Iran - 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_91ab00e9a5d6 in signals