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/CBMiiwFBVV95cUxNc3F6UDRFV1V1bGhqdmc3bnJBVWc1ZkxsaXdzWV92Q2xmRFpSOHhDbXBKTFFicjl3NHU2c09YVXQ1NzJ3em5uWnNSMlJ5MlUySG4wdW44dndTYmx4MEprbXV2TlNFQnJzNjRySC1xM2lHNExQWFV0NmNGSXBFWkxtbzF1NGxOalc5MW5J?oc=5","as_of":"2026-04-07T23:23:38.800754+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/CBMiiwFBVV95cUxNc3F6UDRFV1V1bGhqdmc3bnJBVWc1ZkxsaXdzWV92Q2xmRFpSOHhDbXBKTFFicjl3NHU2c09YVXQ1NzJ3em5uWnNSMlJ5MlUySG4wdW44dndTYmx4MEprbXV2TlNFQnJzNjRySC1xM2lHNExQWFV0NmNGSXBFWkxtbzF1NGxOalc5MW5J?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cb9edfdf876ea865","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:35:15.542184+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNc3F6UDRFV1V1bGhqdmc3bnJBVWc1ZkxsaXdzWV92Q2xmRFpSOHhDbXBKTFFicjl3NHU2c09YVXQ1NzJ3em5uWnNSMlJ5MlUySG4wdW44dndTYmx4MEprbXV2TlNFQnJzNjRySC1xM2lHNExQWFV0NmNGSXBFWkxtbzF1NGxOalc5MW5J?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNc3F6UDRFV1V1bGhqdmc3bnJBVWc1ZkxsaXdzWV92Q2xmRFpSOHhDbXBKTFFicjl3NHU2c09YVXQ1NzJ3em5uWnNSMlJ5MlUySG4wdW44dndTYmx4MEprbXV2TlNFQnJzNjRySC1xM2lHNExQWFV0NmNGSXBFWkxtbzF1NGxOalc5MW5J?oc=5","source_event_id":"evt_516ed6aa99eb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"69aeae0b389e9b70","published_at":"2026-04-07T18:17:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"political_office","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"government","name":"US cabinet","relevance":"high","symbol":"","type":"government_body"},{"asset_class":"political_group","name":"House Democrats","relevance":"high","symbol":"","type":"political_group"},{"asset_class":"political_group","name":"Republicans","relevance":"medium","symbol":"","type":"political_group"},{"asset_class":"government","name":"US Congress (Hill Democrats)","relevance":"medium","symbol":"","type":"government_body"},{"asset_class":"interest_group","name":"US Jewish groups","relevance":"medium","symbol":"","type":"interest_group"},{"asset_class":"geopolitical_actor","name":"Iran","relevance":"high","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not actually the Guardian article content (it appears to be page styling/CSS), so only the headline and the multi-outlet source summary can be treated as grounded facts.","No specific date, vote timing, or named cabinet members are included in the provided text.","The exact wording and context of Trump\u2019s \u201cwhole civilization will die\u201d statement are not included beyond the quoted phrase.","The mechanism and legal basis for \u201cousting\u201d via the 25th Amendment are not detailed in the provided material.","No direct market/asset impact is stated; any near-term directional impact on markets would be speculative beyond the geopolitical risk framing."],"key_facts":["The Guardian headline states Republicans are silent as Democrats call on the US cabinet to oust Trump over Iran.","The provided source summary says an \u201ceclectic, bipartisan group\u201d called for removing Trump using the 25th Amendment.","The provided source summary says CNN coverage notes the 25th Amendment removal discussion.","The provided source summary says US Jewish groups denounced Trump\u2019s reported threat that a \u201cwhole civilization will die\u201d in Iran (Times of Israel).","The provided source summary says Trump\u2019s Iran post caused talk of impeachment/removal among Hill Democrats (Axios/other referenced outlets).","The provided source summary says House Democrats sought an immediate vote to avert \u201cWorld War III\u201d (WSJ)."],"numeric_claims":[],"primary_claim":"Democrats are calling on the US cabinet to oust Trump over Iran, with some discussion of removing him via the 25th Amendment, while Republicans are described as silent.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The Guardian reports that Democrats are calling on the US cabinet to oust President Trump over Iran, including discussion of using the 25th Amendment, while Republicans are described as silent. The signal also references related reactions in other outlets about impeachment/removal talk and efforts by House Democrats to avert escalation.","topics":["25th Amendment","cabinet action","impeachment/removal","Iran escalation","US political response","World War III rhetoric"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Republicans silent as Democrats call on US cabinet to oust Trump over Iran The Guardian 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 The Times of Israel 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":"Republicans silent as Democrats call on US cabinet to oust Trump over Iran - The Guardian","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_c5540a51eeed in signals