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

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