SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T06:36:01.585201+00:00","dedupe_key":"signal_enriched:news_delta:d5f661e687e28daa","evidence_event_ids":["evt_5914de6a2de2"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 5064 in events