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-09T20:18:41.060995+00:00","dedupe_key":"signal_enriched:news_delta:e8af852d4b93727c","evidence_event_ids":["evt_5827ad2e5e2c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxQR0ttWWNEX1YxdDUxRG5BQ2VXS3hTUjM4eVlmdTlZM2RGNlEwVHFiNzg0a2VBWnNMXzJvQXdyNG5vcXA1c19TM0pOOXV3bUU0ZXB2Y3l6U09faVYzd1FLT2JUT3hmQXJydXhCR3U0NVpkWWQzQ003QUN5OWRrRzRHTkgtSlB2MzNfaVM4Q0lUVDZzRXB4NXBUVHROalkyWlRGT3c?oc=5","as_of":"2026-04-09T20:18:41.060995+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/CBMiogFBVV95cUxQR0ttWWNEX1YxdDUxRG5BQ2VXS3hTUjM4eVlmdTlZM2RGNlEwVHFiNzg0a2VBWnNMXzJvQXdyNG5vcXA1c19TM0pOOXV3bUU0ZXB2Y3l6U09faVYzd1FLT2JUT3hmQXJydXhCR3U0NVpkWWQzQ003QUN5OWRrRzRHTkgtSlB2MzNfaVM4Q0lUVDZzRXB4NXBUVHROalkyWlRGT3c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_884fe873b67ae3de","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-10T00:28:06.515520+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxQR0ttWWNEX1YxdDUxRG5BQ2VXS3hTUjM4eVlmdTlZM2RGNlEwVHFiNzg0a2VBWnNMXzJvQXdyNG5vcXA1c19TM0pOOXV3bUU0ZXB2Y3l6U09faVYzd1FLT2JUT3hmQXJydXhCR3U0NVpkWWQzQ003QUN5OWRrRzRHTkgtSlB2MzNfaVM4Q0lUVDZzRXB4NXBUVHROalkyWlRGT3c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxQR0ttWWNEX1YxdDUxRG5BQ2VXS3hTUjM4eVlmdTlZM2RGNlEwVHFiNzg0a2VBWnNMXzJvQXdyNG5vcXA1c19TM0pOOXV3bUU0ZXB2Y3l6U09faVYzd1FLT2JUT3hmQXJydXhCR3U0NVpkWWQzQ003QUN5OWRrRzRHTkgtSlB2MzNfaVM4Q0lUVDZzRXB4NXBUVHROalkyWlRGT3c?oc=5","source_event_id":"evt_5827ad2e5e2c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"118dd790553cfc4d","published_at":"2026-04-09T17:19:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Democrats (House Democratic leaders)","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"political","name":"Trump (presidency)","relevance":"high","symbol":"","type":"office"},{"asset_class":"legal","name":"25th Amendment","relevance":"high","symbol":"","type":"legal_mechanism"},{"asset_class":"geopolitical","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"regulation","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual AP article content, so details beyond the headline and the included source summary cannot be verified.","No specific quotes, names of particular House leaders, or timing (e.g., when votes/hearings might occur) are present in the provided material.","The exact nature of the \u201cIran threats\u201d (date, wording, and whether they are confirmed) is not specified in the provided text.","Whether the discussion is limited to rhetoric or includes concrete procedural steps (committee actions, votes, or formal proposals) is not stated in the provided material."],"key_facts":["AP News headline indicates Democrats are \u201cgrowing bolder\u201d about removing Trump from office.","The stated rationale in the headline is Trump\u2019s Iran threats.","The provided source summary (not AP text) says House Dem leaders are opening the door to the 25th Amendment after rank-and-file push for removal.","The provided source summary (not AP text) characterizes 25th Amendment removal as a longshot and explains how it works (Axios)."],"numeric_claims":[],"primary_claim":"Democrats are increasingly open to discussing removing Trump from office, with the push linked to his Iran threats.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"AP reports that House Democratic leaders are increasingly discussing removing President Trump from office, citing his Iran-related threats as the catalyst. The discussion centers on the 25th Amendment as a potential (but longshot) mechanism.","topics":["U.S. politics","25th Amendment","impeachment/removal","Iran threats","Democratic Party strategy"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Democrats grow bolder on talk about removing Trump from office after his Iran threats AP News House Dem leaders open door to 25th Amendment after rank-and-file push for Trump's removal Fox News How presidential removal under the 25th Amendment works and why it's a longshot Axios Deluzio, Lee say Trump\u2019s rhetoric on Iran makes him unfit for the presidency Pittsburgh Post-Gazette Analysis | Democrats are using the I-word again The Washington Post","title":"Democrats grow bolder on talk about removing Trump from office after his Iran threats - AP News","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 11216 in events