1 row where "created_at" is on date 2021-03-04, manufacturer = "Apple" and software = "12.1.2" sorted by software descending

View and edit SQL

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


  • Apple · 1
id created_at updated_at deleted_at name manufacturer model hardware software ▲
9 2021-03-04 17:17:50.131585+03:00 2021-03-04 17:17:50.131585+03:00   iPhone Apple iPhone iPhone10,6 12.1.2

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`);