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/CBMitgFBVV95cUxNYS1WT3BNbmtGY1VvMnpsUXhXMzVkWDR3VE1lMWxXVm9fOFhNdDI1NDQ1ZFB6V09Ia1BpaEZ5SnNmWjRRRmxOVUp5ZmRtQ3dfajhXMDhSclZJVDJDRFhCYW5mRVAybHhhSkZGYjNFRXBrcWNvR1JjZ1dDTmQ1TkhCYklMQVZkQzA4NjZKLVVNeFpWUWNRLURSR0xwY2FEVmhmUWNwMi03YktsNFNpR0lKdVQtV01YUQ?oc=5","as_of":"2026-04-08T06:36:01.585201+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/CBMitgFBVV95cUxNYS1WT3BNbmtGY1VvMnpsUXhXMzVkWDR3VE1lMWxXVm9fOFhNdDI1NDQ1ZFB6V09Ia1BpaEZ5SnNmWjRRRmxOVUp5ZmRtQ3dfajhXMDhSclZJVDJDRFhCYW5mRVAybHhhSkZGYjNFRXBrcWNvR1JjZ1dDTmQ1TkhCYklMQVZkQzA4NjZKLVVNeFpWUWNRLURSR0xwY2FEVmhmUWNwMi03YktsNFNpR0lKdVQtV01YUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_657c006cf773e8e9","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-08T06:36:42.269656+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxNYS1WT3BNbmtGY1VvMnpsUXhXMzVkWDR3VE1lMWxXVm9fOFhNdDI1NDQ1ZFB6V09Ia1BpaEZ5SnNmWjRRRmxOVUp5ZmRtQ3dfajhXMDhSclZJVDJDRFhCYW5mRVAybHhhSkZGYjNFRXBrcWNvR1JjZ1dDTmQ1TkhCYklMQVZkQzA4NjZKLVVNeFpWUWNRLURSR0xwY2FEVmhmUWNwMi03YktsNFNpR0lKdVQtV01YUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theconversation.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitgFBVV95cUxNYS1WT3BNbmtGY1VvMnpsUXhXMzVkWDR3VE1lMWxXVm9fOFhNdDI1NDQ1ZFB6V09Ia1BpaEZ5SnNmWjRRRmxOVUp5ZmRtQ3dfajhXMDhSclZJVDJDRFhCYW5mRVAybHhhSkZGYjNFRXBrcWNvR1JjZ1dDTmQ1TkhCYklMQVZkQzA4NjZKLVVNeFpWUWNRLURSR0xwY2FEVmhmUWNwMi03YktsNFNpR0lKdVQtV01YUQ?oc=5","source_event_id":"evt_5914de6a2de2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6bed8d54e1576f94","published_at":"2026-04-07T22:18:45+00:00","publisher_domain":"theconversation.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"The Conversation","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"equity_index_or_political_actor","name":"Donald Trump","relevance":"high","symbol":"TRUMP","type":"person"},{"asset_class":"political_group","name":"Hill Democrats (U.S. congressional Democrats)","relevance":"high","symbol":"","type":"political_group"},{"asset_class":"political_actor","name":"Gov. J.B. Pritzker","relevance":"medium","symbol":"","type":"person"},{"asset_class":"media","name":"Axios","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"NBC News","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"NPR","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"WBEZ Chicago","relevance":"low","symbol":"","type":"publisher"}],"event_type":"regulation","information_gaps":["The cleaned article text is not actually present (only CSS/HTML boilerplate), so the specific constitutional provisions/mechanisms discussed in The Conversation article cannot be verified from the provided content.","The exact date/time of the Iran post and the timing of any formal congressional actions are not provided.","The specific constitutional process(s) referenced (e.g., impeachment, removal, disability provisions) are not explicitly extractable from the provided text; only the headline-level claim is available.","No direct quotes or detailed descriptions of the Iran threats/comments are included in the provided material."],"key_facts":["The Conversation published an article titled along the lines of: \u201cWhen a president is unfit for office, here\u2019s what the Constitution says can happen.\u201d","The provided source summary states that \u201cTrump\u2019s Iran post\u201d triggered discussion among Hill Democrats about impeachment/removal.","The source summary states that dozens of Democrats called for Trump\u2019s removal after his Iran threats (as reported by NBC News).","The source summary states that Gov. J.B. Pritzker called for Trump\u2019s removal from office (as reported by WBEZ Chicago).","The source summary states that Congressional Democrats raised alarm over Trump\u2019s comments on Iran (as reported by NPR)."],"numeric_claims":[{"label":"Dozens of Democrats","value":"dozens"}],"primary_claim":"The Conversation argues that the U.S. Constitution provides processes for what can happen if a president is unfit for office.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Conversation article discusses constitutional mechanisms for dealing with a president deemed unfit for office, amid renewed political calls for President Trump\u2019s removal following Iran-related posts. Multiple outlets report Hill Democrats are raising impeachment/removal concerns in the near term.","topics":["U.S. Constitution","presidential removal","impeachment","political controversy","Iran-related comments/posts","Congressional Democrats","J.B. Pritzker"]},"source":"The Conversation","source_domain":"theconversation.com","source_url":"https://theconversation.com","summary":"When a president is unfit for office, here\u2019s what the Constitution says can happen The Conversation Trump's Iran post causes talk of his impeachment, removal to erupt among Hill Democrats Axios Dozens of Democrats call for Trump's removal after his Iran threats NBC News The Rundown: Gov. Pritzker calls for Trump\u2019s removal from office WBEZ Chicago Congressional Democrats raise alarm over Trump's comments on Iran NPR","title":"When a president is unfit for office, here\u2019s what the Constitution says can happen - The Conversation","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_2634f16d1c56 in signals