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/CBMijwFBVV95cUxQeGZHNm94TlVKdDBhU0tqQ0pSdmUyeDlWZF92bFRvVTUwbjRXUVNjbDM4QVhuRjdEUnpyRW1mY1NFeVFVa21TT0phVkZCRUpHaXI1Y3lXc0R1TG1JVTZpUENjV1V3U2VlY2hLb0J4SEYyWUNnTVhsMFhSQ1l1WW40Qk5waTVpdzlEQm12cW90dw?oc=5","as_of":"2026-04-08T22:21:15.791673+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/CBMijwFBVV95cUxQeGZHNm94TlVKdDBhU0tqQ0pSdmUyeDlWZF92bFRvVTUwbjRXUVNjbDM4QVhuRjdEUnpyRW1mY1NFeVFVa21TT0phVkZCRUpHaXI1Y3lXc0R1TG1JVTZpUENjV1V3U2VlY2hLb0J4SEYyWUNnTVhsMFhSQ1l1WW40Qk5waTVpdzlEQm12cW90dw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e99dc3a6325deb00","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-09T22:16:49.316233+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxQeGZHNm94TlVKdDBhU0tqQ0pSdmUyeDlWZF92bFRvVTUwbjRXUVNjbDM4QVhuRjdEUnpyRW1mY1NFeVFVa21TT0phVkZCRUpHaXI1Y3lXc0R1TG1JVTZpUENjV1V3U2VlY2hLb0J4SEYyWUNnTVhsMFhSQ1l1WW40Qk5waTVpdzlEQm12cW90dw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"techcrunch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxQeGZHNm94TlVKdDBhU0tqQ0pSdmUyeDlWZF92bFRvVTUwbjRXUVNjbDM4QVhuRjdEUnpyRW1mY1NFeVFVa21TT0phVkZCRUpHaXI1Y3lXc0R1TG1JVTZpUENjV1V3U2VlY2hLb0J4SEYyWUNnTVhsMFhSQ1l1WW40Qk5waTVpdzlEQm12cW90dw?oc=5","source_event_id":"evt_adb6c01622ff","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"dfb6b5609a4b94b4","published_at":"2026-04-08T19:56:16+00:00","publisher_domain":"techcrunch.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Amazon","relevance":"primary actor","symbol":"","type":"company"},{"asset_class":"consumer_electronics","name":"Kindle","relevance":"affected device category","symbol":"","type":"product_line"},{"asset_class":"consumer_electronics","name":"Kindle Fire","relevance":"affected device category","symbol":"","type":"product_line"},{"asset_class":"media","name":"TechCrunch","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"media","name":"WIRED","relevance":"mentioned secondary coverage","symbol":"","type":"publisher"},{"asset_class":"media","name":"The Verge","relevance":"mentioned secondary coverage","symbol":"","type":"publisher"},{"asset_class":"media","name":"The Register","relevance":"mentioned secondary coverage","symbol":"","type":"publisher"},{"asset_class":"media","name":"9to5Mac","relevance":"mentioned secondary coverage","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided contains no substantive content about which specific Kindle models are affected or the exact timing/date when support ends.","The provided text does not specify whether the devices will be fully unusable (\u201cbricked\u201d) versus only unable to download new books.","No details are given on whether existing purchased books will remain accessible offline/locally.","The exact mechanism (e.g., software update cutoff, store access removal, DRM changes) is not described in the provided text."],"key_facts":["TechCrunch reports Amazon will end support for older Kindle devices.","The provided source summary states Amazon is ending support for older Kindles and Kindle Fires.","The provided source summary says Amazon will not be able to get new books soon for 13 Kindle devices (as stated in the summary).","The provided source summary indicates the devices will be affected by the support ending (described as \u201cbricking their kit\u201d in one referenced outlet)."],"numeric_claims":[{"label":"number_of_devices","value":"13"}],"primary_claim":"Amazon will end support for older Kindle devices, and some models will not be able to get new books soon.","relevance_score":0.55,"sentiment":"negative","source_quality":"high","summary":"Amazon is ending support for certain older Kindle and Kindle Fire devices, meaning they will no longer be able to receive new books soon. The change is framed as support being pulled for specific older models.","topics":["device support termination","Kindle e-readers","Kindle Fire tablets","digital content access","end-of-support"]},"source":"TechCrunch","source_domain":"techcrunch.com","source_url":"https://techcrunch.com","summary":"Amazon to end support for older Kindle devices TechCrunch Amazon Pulls Support for Perfectly Fine Older Kindles WIRED Amazon is ending support for older Kindles and Kindle Fires The Verge Amazon thanks loyal Kindle devotees by bricking their kit theregister.com Amazon says these 13 Kindle devices won\u2019t be able to get new books soon 9to5Mac","title":"Amazon to end support for older Kindle devices - TechCrunch","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_ac23f46859ae in signals