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/CBMiiwFBVV95cUxQWFJuVXFDOG9pREhlWDVfVzZyVVFLYV93Rk44cWItdU9hajBfZXFXS2RmZUx5dVVadHlKVlZnTnZEZExXbXZfbWozRXBseWNPLWdQQ0FaZGVsVUdGR21XRUE3SUlnSUFsRzQ2RndEZ2stNXFXY0podHM0cE1qYTE0Y1pMb2N0aXQwX09r?oc=5","as_of":"2026-04-09T00:07:15.913908+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/CBMiiwFBVV95cUxQWFJuVXFDOG9pREhlWDVfVzZyVVFLYV93Rk44cWItdU9hajBfZXFXS2RmZUx5dVVadHlKVlZnTnZEZExXbXZfbWozRXBseWNPLWdQQ0FaZGVsVUdGR21XRUE3SUlnSUFsRzQ2RndEZ2stNXFXY0podHM0cE1qYTE0Y1pMb2N0aXQwX09r?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f6750227d737737a","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:20:39.253044+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQWFJuVXFDOG9pREhlWDVfVzZyVVFLYV93Rk44cWItdU9hajBfZXFXS2RmZUx5dVVadHlKVlZnTnZEZExXbXZfbWozRXBseWNPLWdQQ0FaZGVsVUdGR21XRUE3SUlnSUFsRzQ2RndEZ2stNXFXY0podHM0cE1qYTE0Y1pMb2N0aXQwX09r?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"9to5google.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQWFJuVXFDOG9pREhlWDVfVzZyVVFLYV93Rk44cWItdU9hajBfZXFXS2RmZUx5dVVadHlKVlZnTnZEZExXbXZfbWozRXBseWNPLWdQQ0FaZGVsVUdGR21XRUE3SUlnSUFsRzQ2RndEZ2stNXFXY0podHM0cE1qYTE0Y1pMb2N0aXQwX09r?oc=5","source_event_id":"evt_60269602ef41","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fcd45259a25e7b0a","published_at":"2026-04-08T16:45:00+00:00","publisher_domain":"9to5google.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"consumer_electronics","name":"Google Pixel","relevance":"high","symbol":"","type":"product_line"},{"asset_class":"consumer_electronics","name":"iPhone","relevance":"high","symbol":"","type":"product_line"},{"asset_class":"consumer_electronics_manufacturer","name":"Samsung","relevance":"medium","symbol":"","type":"company"},{"asset_class":"consumer_electronics_manufacturer","name":"Apple","relevance":"high","symbol":"","type":"company"},{"asset_class":"consumer_electronics","name":"MacBook","relevance":"medium","symbol":"","type":"product_line"}],"event_type":"other","information_gaps":["The specific organization(s) behind the \u201cname-and-shame\u201d report are not stated in the provided text.","The scoring methodology (e.g., parts availability, tool requirements, documentation, repair time/cost) is not included.","The exact ranking positions for Pixel, Samsung, and Apple products (beyond iPhone D\u2013 and Apple bottom ranking) are not provided.","The \u201cone exception\u201d to Apple\u2019s bottom ranking is not identified.","No near-term catalyst (e.g., policy change, product recall, or regulatory action) is described in the provided text."],"key_facts":["9to5Google reports that a repairability \u201cname-and-shame\u201d report ranks Google Pixel above iPhone and Samsung on repairability.","The report assigns iPhone a grade of D\u2013 for repairability (as described in the headline/source summary).","The source summary indicates Apple receives bottom ranking for repairability of iPhones and MacBooks, with one exception (details not provided in the provided text).","The source summary references additional coverage from WIRED and Ars Technica, but the specific methodology and the full ranking table are not included in the provided content."],"numeric_claims":[{"label":"iPhone repairability grade","value":"D\u2013"}],"primary_claim":"In a repairability name-and-shame report, Google Pixel is ranked as more repairable than iPhone and Samsung devices, with iPhones receiving a D\u2013 for repairability.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"A repairability \u201cname-and-shame\u201d report ranks Google Pixel devices as more repairable than iPhones and Samsung phones, while Apple\u2019s iPhones and MacBooks receive poor scores. The coverage highlights negative repairability grading for Apple products and comparatively better outcomes for Pixel.","topics":["repairability","right to repair","device maintenance","consumer electronics rankings","iPhone repairability score","Pixel vs iPhone vs Samsung comparison"]},"source":"9to5Google","source_domain":"9to5google.com","source_url":"https://9to5google.com","summary":"Google Pixel bests iPhone and Samsung in repairability name-and-shame report 9to5Google The iPhone Gets a D\u2013 for Repairability WIRED Failing the Fix (2026) PIRG Apple and Lenovo have the least repairable laptops, analysis finds Ars Technica Apple gets bottom ranking for repairability of iPhones and MacBooks \u2013 with one exception 9to5Mac","title":"Google Pixel bests iPhone and Samsung in repairability name-and-shame report - 9to5Google","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_5b1c1272a89e in signals