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-08T00:26:38.269417+00:00","dedupe_key":"signal_enriched:news_delta:440828ab9e8f008c","evidence_event_ids":["evt_23765b49c718"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?oc=5","as_of":"2026-04-08T00:26:38.269417+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/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_15452357516bc256","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:42:37.181008+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNUzMzRkwySjhiSGJLd0lJUklDVUpEaTFLdjFIVVE2ekxYZ3hlU2ZRQnZGWGhiZHdtYjlfdktIMjRTTDktX2tZODRMVUdnbmFxRFBnRk9MUWxwQ09xVGx6RDBOWVpmd25abk1rRkhZNlUzV3NzczhFalVQT1ktMGtfUkwzNzdfRVBWOUUzNXhFTlNrdFZ0dlpybXloUnprQ2JaWE9lYVNDaHNhcTA?oc=5","source_event_id":"evt_23765b49c718","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9b4d6c8d2122f6f9","published_at":"2026-04-07T23:50:34+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Congressional Democrats","relevance":"primary","symbol":"","type":"political_group"},{"asset_class":"","name":"Donald Trump","relevance":"primary","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"primary","symbol":"","type":"country"},{"asset_class":"","name":"U.S. Congress","relevance":"secondary","symbol":"","type":"institution"},{"asset_class":"","name":"25th Amendment","relevance":"secondary","symbol":"","type":"legal_provision"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the substantive NPR content; extraction relies on the supplied headline and the \u201cSource Summary\u201d/other snippet text.","Specific details of what Trump said in the NPR piece (beyond the quoted warning mentioned in other snippets) are not fully verifiable from the provided cleaned text.","Near-term timing (exact date/time of any vote or procedural step) is not specified in the provided content; only general \u201cimmediate\u201d reaction is implied by other snippets.","Market/sector impacts are not stated; only political and geopolitical implications are suggested."],"key_facts":["NPR headline indicates Congressional Democrats raised alarm over Trump\u2019s comments on Iran.","Other provided source snippets indicate Hill Democrats discussed impeachment/removal and the 25th Amendment in response to Trump\u2019s Iran-related warning.","A cited Trump quote in the provided snippets is: \u201ca whole civilization will die tonight\u201d (context: warning about the Iran war)."],"numeric_claims":[],"primary_claim":"Congressional Democrats raised alarm over President Trump\u2019s comments about Iran.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"NPR reports that Congressional Democrats are alarmed by comments from President Trump about Iran, prompting calls on Capitol Hill for potential drastic action. The immediate political catalyst is the reaction to Trump\u2019s Iran remarks, with related coverage also discussing impeachment/removal and the 25th Amendment.","topics":["U.S. politics","Iran","Trump comments","Congressional reaction","impeachment/removal talk","25th Amendment"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Congressional Democrats raise alarm over Trump's comments on Iran NPR An eclectic, bipartisan group suddenly calls for removing Trump using the 25th Amendment CNN Northern California lawmakers denounce Trump's warning that \"a whole civilization will die tonight\" in Iran war CBS News 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":"Congressional Democrats raise alarm over Trump's comments on Iran - NPR","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 2472 in events