4 rows where hardware = "Watch4,1" and manufacturer = "Apple" sorted by deleted_at

View and edit SQL

Suggested facets: created_at (date)

updated_at (date)

manufacturer

  • Apple · 4

hardware

  • Watch4,1 · 4
id created_at updated_at deleted_at ▼ name manufacturer model hardware software
1 2021-03-04 17:17:30.01663+03:00 2021-03-04 17:17:30.01663+03:00   Apple Watch Apple Watch Watch4,1 5.0.1
2 2021-03-04 17:17:30.290817+03:00 2021-03-04 17:17:30.290817+03:00   Apple Watch Apple Watch Watch4,1 5.1.2
3 2021-03-04 17:17:32.279968+03:00 2021-03-04 17:17:32.279968+03:00   Apple Watch Apple Watch Watch4,1 5.1.3
4 2021-03-04 17:17:35.604781+03:00 2021-03-04 17:17:35.604781+03:00   Apple Watch Apple Watch Watch4,1 5.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`);