4 rows where manufacturer = "Apple Inc." and software = "" sorted by name descending

View and edit SQL

Suggested facets: created_at (date), updated_at (date)

software

manufacturer

  • Apple Inc. · 4
id created_at updated_at deleted_at name ▲ manufacturer model hardware software
29 2021-03-04 17:19:44.344148+03:00 2021-03-04 17:19:44.344148+03:00   EarPods Apple Inc.      
30 2021-03-04 17:19:46.291598+03:00 2021-03-04 17:19:46.291598+03:00   Beats Flex Apple Inc. 0x2010    
28 2021-03-04 17:19:43.78136+03:00 2021-03-04 17:19:43.78136+03:00   AirPods Pro Apple Inc. 0x200e    
27 2021-03-04 17:19:43.096061+03:00 2021-03-04 17:19:43.096061+03:00   AirPods Apple Inc. 0x200f    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE `health_devices` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`name` text,`manufacturer` text,`model` text,`hardware` text,`software` text,PRIMARY KEY (`id`));
CREATE INDEX `idx_health_devices_deleted_at` ON `health_devices`(`deleted_at`);