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/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

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_f41e9074211a in signals