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-09T18:00:22.091245+00:00","dedupe_key":"signal_enriched:news_delta:38d98e2fa21e42c6","evidence_event_ids":["evt_b72ca61abc13"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxPWmFsX2dncnNoaEpQRDkzRjF4Z0RZT3FvMWpkMFVtUlFnbmdQZXIwOHhISWdrbFI4eFIyd3JBaHVhMV9BX0NYOEJRMUlkZjM4bnJyaEltYnc3dUNUczMxVkhqWmo1RGdZMllnaHdHZ0QtWmJWbWZHc1dnbFdQdXkyOWZ3?oc=5","as_of":"2026-04-09T18:00:22.091245+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/CBMiggFBVV95cUxPWmFsX2dncnNoaEpQRDkzRjF4Z0RZT3FvMWpkMFVtUlFnbmdQZXIwOHhISWdrbFI4eFIyd3JBaHVhMV9BX0NYOEJRMUlkZjM4bnJyaEltYnc3dUNUczMxVkhqWmo1RGdZMllnaHdHZ0QtWmJWbWZHc1dnbFdQdXkyOWZ3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3ca89458ea5166ca","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:12:57.525119+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxPWmFsX2dncnNoaEpQRDkzRjF4Z0RZT3FvMWpkMFVtUlFnbmdQZXIwOHhISWdrbFI4eFIyd3JBaHVhMV9BX0NYOEJRMUlkZjM4bnJyaEltYnc3dUNUczMxVkhqWmo1RGdZMllnaHdHZ0QtWmJWbWZHc1dnbFdQdXkyOWZ3?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/CBMiggFBVV95cUxPWmFsX2dncnNoaEpQRDkzRjF4Z0RZT3FvMWpkMFVtUlFnbmdQZXIwOHhISWdrbFI4eFIyd3JBaHVhMV9BX0NYOEJRMUlkZjM4bnJyaEltYnc3dUNUczMxVkhqWmo1RGdZMllnaHdHZ0QtWmJWbWZHc1dnbFdQdXkyOWZ3?oc=5","source_event_id":"evt_b72ca61abc13","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ad1ad165415d8872","published_at":"2026-04-09T15:21:57+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"NPR","relevance":"high","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Trump era","relevance":"high","symbol":"","type":"time_period/political_context"},{"asset_class":"","name":"\u201csoft power\u201d","relevance":"high","symbol":"","type":"concept"}],"event_type":"other","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the article\u2019s substantive content, so no grounded details about specific policies, agencies, budgets, or outcomes can be extracted.","The \u201cSource Summary\u201d includes multiple unrelated items (e.g., USAID, humanitarian reset, dark money) but the actual NPR article content is not present in the provided text; it is unclear whether those items are part of the NPR piece or are artifacts of the broader feed.","No near-term catalyst timing, affected organizations, or measurable impacts are stated in the provided headline/summary."],"key_facts":["Headline from NPR: \u201cIn the Trump era, everybody's talking about 'soft power.' But ... what is it exactly?\u201d","The signal is a headline_delta/news_headline_delta type, implying the change or focus is on the framing/explanation of \u201csoft power.\u201d"],"numeric_claims":[],"primary_claim":"The NPR headline indicates a discussion in the Trump era about \u201csoft power,\u201d and the article is framed around explaining what \u201csoft power\u201d exactly is.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"NPR examines the concept of \u201csoft power\u201d in the context of the Trump era, questioning what it means and how it is being discussed. The provided material does not include specific policy actions or measurable outcomes, so any market or operational impact cannot be grounded from this signal alone.","topics":["soft power","public diplomacy","U.S. foreign policy","Trump era","NPR analysis"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"In the Trump era, everybody's talking about 'soft power.' But ... what is it exactly? NPR Strategic Impatience and the Undoing of American Soft Power USC Center on Public Diplomacy | Mellen Duffy Tanamly & Arthur Greenberg: Closing USAID and its deadly consequences UnionLeader.com Devex Pro Insider: A humanitarian reset under fire Devex Dark Money for Soft Power Puck","title":"In the Trump era, everybody's talking about 'soft power.' But ... what is it exactly? - 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 10962 in events