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/CBMigwFBVV95cUxPTTlrSFpfUV9KMmVZLUNocDZ5ZnFxWXYzcy1RRW5JeEF5a0NBa3ozcWJWcVVJdnBoNm5OT3dKRkVUNi01c0FiaUpnZDZGTGViYkxNWFhncGxxalRTajJ1VUJMOE1YUnBjWUxRMU1mWTdaRmlqNmxJQnFkal9yNVlqM3dnUQ?oc=5","as_of":"2026-04-08T22:21:15.707760+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/CBMigwFBVV95cUxPTTlrSFpfUV9KMmVZLUNocDZ5ZnFxWXYzcy1RRW5JeEF5a0NBa3ozcWJWcVVJdnBoNm5OT3dKRkVUNi01c0FiaUpnZDZGTGViYkxNWFhncGxxalRTajJ1VUJMOE1YUnBjWUxRMU1mWTdaRmlqNmxJQnFkal9yNVlqM3dnUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cd35d923ef3245f1","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-09T22:16:38.247341+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxPTTlrSFpfUV9KMmVZLUNocDZ5ZnFxWXYzcy1RRW5JeEF5a0NBa3ozcWJWcVVJdnBoNm5OT3dKRkVUNi01c0FiaUpnZDZGTGViYkxNWFhncGxxalRTajJ1VUJMOE1YUnBjWUxRMU1mWTdaRmlqNmxJQnFkal9yNVlqM3dnUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxPTTlrSFpfUV9KMmVZLUNocDZ5ZnFxWXYzcy1RRW5JeEF5a0NBa3ozcWJWcVVJdnBoNm5OT3dKRkVUNi01c0FiaUpnZDZGTGViYkxNWFhncGxxalRTajJ1VUJMOE1YUnBjWUxRMU1mWTdaRmlqNmxJQnFkal9yNVlqM3dnUQ?oc=5","source_event_id":"evt_f2dae83dcbdd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0d1ad9fc5555f1b7","published_at":"2026-04-08T20:43:21+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"House Democratic leadership","relevance":"high","symbol":"","type":"political_body"},{"asset_class":"legal","name":"25th Amendment","relevance":"high","symbol":"","type":"legal_provision"},{"asset_class":"political","name":"President Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"political","name":"House Democrats","relevance":"medium","symbol":"","type":"political_group"},{"asset_class":"political","name":"Trump impeachment effort","relevance":"medium","symbol":"","type":"political_process"},{"asset_class":"geopolitical","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"conflict","information_gaps":["The cleaned article text provided appears to be mostly HTML/CSS and does not include the substantive Axios reporting; therefore, details of what \u201csudden openness\u201d specifically entails (e.g., who said it, when, and in what forum) are not verifiable from the supplied text.","No specific quotes, dates, or procedural steps (e.g., whether a formal push, letter, or vote is planned) are included in the provided content.","The exact nature of the \u201cIran war comments\u201d and the \u201canti-voting crusade\u201d allegations are not detailed in the supplied text."],"key_facts":["Axios headline indicates House Democratic leadership is signaling sudden openness to a 25th Amendment push.","The provided source summary states Democrats are calling for Trump\u2019s impeachment amid Iran war comments.","The source summary also states lawmakers cite Trump\u2019s \u201canti-voting crusade\u201d in support of removal under the 25th Amendment.","The source summary references multiple outlets describing calls for Trump\u2019s removal after Iran-related threats/comments."],"numeric_claims":[],"primary_claim":"House Democratic leadership has signaled sudden openness to a push to use the 25th Amendment to remove President Trump.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Axios reports that House Democratic leadership is signaling sudden openness to efforts to invoke the 25th Amendment. The push is tied to calls for removing President Trump following his Iran-related comments and related political criticisms.","topics":["U.S. politics","25th Amendment","impeachment/removal","Democratic Party","Iran rhetoric","executive branch","constitutional law"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"House Democratic leadership signals sudden openness to 25th Amendment push Axios Democrats call for Trump impeachment amid Iran war comments SFGATE Lawmaker cites Trump\u2019s anti-voting crusade in push for removal under 25th Amendment Democracy Docket What is the 25th amendment? Why some lawmakers want to see it used amid Trump's Iran rhetoric WMUR Dozens of Democrats call for Trump's removal after his Iran threats NBC News","title":"House Democratic leadership signals sudden openness to 25th Amendment push - Axios","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_ecb103fc9229 in signals