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/CBMiiAFBVV95cUxQSXU4TkdEN3c1TnM1LWlNY0hXOU1EcENaVzVEdnQ2YVZKYmlpZ1l3ZS1oRDB4T21tMkxSaXBydGVCNmg4VzlZa09XYXNMVDRCRmZEZWlFRG1IaUtuMFdsdFBONDVzbjhIclZDMWFxU2w1VlhVYmpYM0tuYjI1UGZVeHpDbk8weHhp?oc=5","as_of":"2026-04-07T23:39:52.278824+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/CBMiiAFBVV95cUxQSXU4TkdEN3c1TnM1LWlNY0hXOU1EcENaVzVEdnQ2YVZKYmlpZ1l3ZS1oRDB4T21tMkxSaXBydGVCNmg4VzlZa09XYXNMVDRCRmZEZWlFRG1IaUtuMFdsdFBONDVzbjhIclZDMWFxU2w1VlhVYmpYM0tuYjI1UGZVeHpDbk8weHhp?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_16da25e66b0a1caa","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-08T00:38:49.705308+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxQSXU4TkdEN3c1TnM1LWlNY0hXOU1EcENaVzVEdnQ2YVZKYmlpZ1l3ZS1oRDB4T21tMkxSaXBydGVCNmg4VzlZa09XYXNMVDRCRmZEZWlFRG1IaUtuMFdsdFBONDVzbjhIclZDMWFxU2w1VlhVYmpYM0tuYjI1UGZVeHpDbk8weHhp?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/CBMiiAFBVV95cUxQSXU4TkdEN3c1TnM1LWlNY0hXOU1EcENaVzVEdnQ2YVZKYmlpZ1l3ZS1oRDB4T21tMkxSaXBydGVCNmg4VzlZa09XYXNMVDRCRmZEZWlFRG1IaUtuMFdsdFBONDVzbjhIclZDMWFxU2w1VlhVYmpYM0tuYjI1UGZVeHpDbk8weHhp?oc=5","source_event_id":"evt_6c5675c66c14","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0eb756359ccf1003","published_at":"2026-04-07T20:50:11+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"political_actor","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_group","name":"Hill Democrats","relevance":"high","symbol":"","type":"political_group"},{"asset_class":"political_group","name":"House Democrats","relevance":"medium","symbol":"","type":"political_group"},{"asset_class":"media","name":"Axios","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the Axios article\u2019s substantive content; extraction is therefore based on the headline and the provided source summary snippets.","No specific date/time of the Iran post or the timing of any vote/impeachment steps is included in the provided text.","No details are provided on which Democrats (names) or which procedural steps (e.g., committee actions, resolution text) are being considered.","The scope of \u201cremoval\u201d (impeachment conviction vs. 25th Amendment invocation) is not fully specified beyond the general discussion mentioned in the summary."],"key_facts":["Axios headline indicates Trump\u2019s Iran-related post is driving talk among Hill Democrats about impeachment and removal.","The provided source summary states an \u201ceclectic, bipartisan group\u201d is calling for removing Trump using the 25th Amendment (as described in the summary text).","The provided source summary also states House Democrats seek an immediate vote to avert \u201cWorld War III\u201d (as described in the summary text)."],"numeric_claims":[],"primary_claim":"Axios says Trump\u2019s Iran post has led to talk among Hill Democrats about impeachment and removal, including use of the 25th Amendment.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Axios reports that a post by President Trump about Iran has prompted discussion among Hill Democrats about pursuing impeachment and potentially removal via the 25th Amendment. The near-term catalyst implied is political escalation following the Iran-related post.","topics":["impeachment","25th Amendment","Iran","U.S. Congress","Democrats","political escalation"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"Trump's Iran post causes talk of his impeachment, removal to erupt among Hill Democrats Axios An eclectic, bipartisan group suddenly calls for removing Trump using the 25th Amendment CNN US Jewish groups denounce Trump\u2019s threat that a \u2018whole civilization will die\u2019 in Iran timesofisrael.com House Democrats Seek Immediate Vote to Avert \u2018World War III\u2019 WSJ Over 50 Democrats push 25th Amendment as Trump threatens to kill \u2018a whole civilization\u2019 MS NOW","title":"Trump's Iran post causes talk of his impeachment, removal to erupt among Hill Democrats - Axios","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_556d3c712eac in signals