8 rows where "updated_at" is on date 2021-03-04 and workout_id = 111 sorted by deleted_at

View and edit SQL

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

workout_id

updated_at (date)

  • 2021-03-04 · 8
id created_at updated_at deleted_at ▼ workout_id type date duration duration_unit
589 2021-03-04 17:19:51.21131+03:00 2021-03-04 17:19:51.21131+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 16:36:59+03:00 16.98198399146398 min
590 2021-03-04 17:19:51.211421+03:00 2021-03-04 17:19:51.211421+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 16:53:58+03:00 12.13590537905693 min
591 2021-03-04 17:19:51.21148+03:00 2021-03-04 17:19:51.21148+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 16:54:54+03:00 18.7790517171224 min
592 2021-03-04 17:19:51.211538+03:00 2021-03-04 17:19:51.211538+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 17:06:06+03:00 11.32718676328659 min
593 2021-03-04 17:19:51.211596+03:00 2021-03-04 17:19:51.211596+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 17:13:41+03:00 99.43483224312465 min
594 2021-03-04 17:19:51.211669+03:00 2021-03-04 17:19:51.211669+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 17:17:25+03:00 92.52565386692683 min
595 2021-03-04 17:19:51.211724+03:00 2021-03-04 17:19:51.211724+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 18:49:57+03:00 14.86950523257256 min
596 2021-03-04 17:19:51.211779+03:00 2021-03-04 17:19:51.211779+03:00   111 111 HKWorkoutEventTypeSegment 2019-11-17 18:53:07+03:00 11.70757027467092 min

Advanced export

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

CSV options:

CREATE TABLE `health_workout_events` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`workout_id` integer,`type` text,`date` datetime,`duration` real,`duration_unit` text,PRIMARY KEY (`id`),CONSTRAINT `fk_health_workouts_events` FOREIGN KEY (`workout_id`) REFERENCES `health_workouts`(`id`));
CREATE UNIQUE INDEX `health_workout_events_key` ON `health_workout_events`(`workout_id`,`type`,`date`);
CREATE INDEX `idx_health_workout_events_deleted_at` ON `health_workout_events`(`deleted_at`);