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-09T00:07:15.913908+00:00","dedupe_key":"signal_enriched:news_delta:0af4205cda94bc7c","evidence_event_ids":["evt_60269602ef41"],"signal_type":"news_headline_delta","source":"news_rss","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

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 8626 in events