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:49:36.319409+00:00","dedupe_key":"signal_enriched:news_delta:8a6384fdaef1ae9c","evidence_event_ids":["evt_2a6c2b11c82f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxQTUlsUThwZnA0OVhVZ2dBS1hQT1ZVSV8yanFoNlNYaldOdGM1QV9XLTRfZ1RYMjF5b21sbndXSGZ1ME5oVV81b3R2b3VINi02X1ktWUgyMjJsMVpZd1o3YXZMaGFxb1NmME82aFFtendKMVowOWh3NXJqZ3QtQ0ViT28yUmhZZVFuTVVwT1Z0eUF0WWZOTzB5VC1ONFVsanlLbmpBcm5qV0xEYmF4anJR?oc=5","as_of":"2026-04-09T18:49:36.319409+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/CBMirwFBVV95cUxQTUlsUThwZnA0OVhVZ2dBS1hQT1ZVSV8yanFoNlNYaldOdGM1QV9XLTRfZ1RYMjF5b21sbndXSGZ1ME5oVV81b3R2b3VINi02X1ktWUgyMjJsMVpZd1o3YXZMaGFxb1NmME82aFFtendKMVowOWh3NXJqZ3QtQ0ViT28yUmhZZVFuTVVwT1Z0eUF0WWZOTzB5VC1ONFVsanlLbmpBcm5qV0xEYmF4anJR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2a55cbfdca275c40","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:16:16.935986+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxQTUlsUThwZnA0OVhVZ2dBS1hQT1ZVSV8yanFoNlNYaldOdGM1QV9XLTRfZ1RYMjF5b21sbndXSGZ1ME5oVV81b3R2b3VINi02X1ktWUgyMjJsMVpZd1o3YXZMaGFxb1NmME82aFFtendKMVowOWh3NXJqZ3QtQ0ViT28yUmhZZVFuTVVwT1Z0eUF0WWZOTzB5VC1ONFVsanlLbmpBcm5qV0xEYmF4anJR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxQTUlsUThwZnA0OVhVZ2dBS1hQT1ZVSV8yanFoNlNYaldOdGM1QV9XLTRfZ1RYMjF5b21sbndXSGZ1ME5oVV81b3R2b3VINi02X1ktWUgyMjJsMVpZd1o3YXZMaGFxb1NmME82aFFtendKMVowOWh3NXJqZ3QtQ0ViT28yUmhZZVFuTVVwT1Z0eUF0WWZOTzB5VC1ONFVsanlLbmpBcm5qV0xEYmF4anJR?oc=5","source_event_id":"evt_2a6c2b11c82f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7e49697f6085392f","published_at":"2026-04-09T17:30:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Amazon","relevance":"primary actor","symbol":"","type":"company"},{"asset_class":"consumer_electronics","name":"Kindle","relevance":"affected product family","symbol":"","type":"product_line"},{"asset_class":"consumer_electronics","name":"Kindle Fire","relevance":"affected product family","symbol":"","type":"product_line"},{"asset_class":"media","name":"The Guardian","relevance":"source of headline","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"BBC","relevance":"additional coverage referenced","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"ZDNET","relevance":"additional coverage referenced","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Verge","relevance":"additional coverage referenced","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"Business Insider","relevance":"additional coverage referenced","symbol":"","type":"media_outlet"}],"event_type":"other","information_gaps":["Exact model names of the \u201cold Kindle devices\u201d are not specified in the provided text.","The effective date/cutoff timeline for when support ends is not provided.","What \u201csupport\u201d entails (e.g., app updates, store access, Wi\u2011Fi connectivity, security patches, DRM/content access) is not specified.","Whether users can continue reading via workarounds (e.g., jailbreak) is only implied by referenced commentary; details are not included.","Geographic scope (global vs. specific regions) is not stated."],"key_facts":["The Guardian headline states Amazon is ending support for old Kindle devices.","The provided source summary indicates Amazon is ending support for older Kindles and Kindle Fires.","Multiple outlets referenced (BBC, ZDNET, The Verge, Business Insider) discuss the support ending and user reaction.","User outcry is mentioned in the source summary."],"numeric_claims":[],"primary_claim":"Amazon will end support for older Kindle devices (including older Kindles and Kindle Fires), prompting user outcry.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Amazon is ending support for older Kindle and Kindle Fire e-readers, which is triggering user backlash. The change is expected to affect owners of older devices in the near term, though the exact cutoff timing is not provided in the supplied text.","topics":["consumer electronics","e-readers","software support lifecycle","Amazon Kindle","Kindle Fire","digital content access"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Amazon upsets ebook lovers by ending support for old Kindle devices The Guardian Amazon to end support for older Kindles, prompting user outcry BBC Your Kindle's not obsolete, it just needs a jailbreak - and I'll show you how it's done ZDNET Amazon is ending support for older Kindles and Kindle Fires The Verge RIP to the original Kindle Paperwhite. Amazon is ending support for older ereaders. Business Insider","title":"Amazon upsets ebook lovers by ending support for old Kindle devices - The Guardian","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 11008 in events