9 rows where "created_at" is on date 2021-03-04, manufacturer = "Apple" and "updated_at" is on date 2021-03-04 sorted by software descending

View and edit SQL

Suggested facets: name, model, hardware

software

updated_at (date)

  • 2021-03-04 · 9

manufacturer

  • Apple · 9

created_at (date)

  • 2021-03-04 · 9
id created_at updated_at deleted_at name manufacturer model hardware software ▲
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
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
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
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
11 2021-03-04 17:17:52.649945+03:00 2021-03-04 17:17:52.649945+03:00   iPhone Apple iPhone iPhone10,6 12.2
10 2021-03-04 17:17:51.54965+03:00 2021-03-04 17:17:51.54965+03:00   iPhone Apple iPhone iPhone10,6 12.1.4
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
8 2021-03-04 17:17:49.91032+03:00 2021-03-04 17:17:49.91032+03:00   iPhone Apple iPhone iPhone10,6 12.0
7 2021-03-04 17:17:47.700443+03:00 2021-03-04 17:17:47.700443+03:00   iPhone Apple iPhone iPhone10,6 11.2.1

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