8 rows where workout_id = 109 sorted by date

View and edit SQL

Suggested facets: type, date, duration, duration_unit, created_at (date), updated_at (date), date (date)

id created_at updated_at deleted_at workout_id type date ▼ duration duration_unit
568 2021-03-04 17:19:51.208262+03:00 2021-03-04 17:19:51.208262+03:00   109 109 HKWorkoutEventTypeMotionPaused 2019-11-14 07:26:50+03:00 0.0  
567 2021-03-04 17:19:51.208157+03:00 2021-03-04 17:19:51.208157+03:00   109 109 HKWorkoutEventTypeSegment 2019-11-14 07:26:50+03:00 5.855214166641235 min
569 2021-03-04 17:19:51.208317+03:00 2021-03-04 17:19:51.208317+03:00   109 109 HKWorkoutEventTypeMotionResumed 2019-11-14 07:26:52+03:00 0.0  
570 2021-03-04 17:19:51.208372+03:00 2021-03-04 17:19:51.208372+03:00   109 109 HKWorkoutEventTypeMotionPaused 2019-11-14 07:27:38+03:00 0.0  
571 2021-03-04 17:19:51.208424+03:00 2021-03-04 17:19:51.208424+03:00   109 109 HKWorkoutEventTypeMotionResumed 2019-11-14 07:27:41+03:00 0.0  
572 2021-03-04 17:19:51.208477+03:00 2021-03-04 17:19:51.208477+03:00   109 109 HKWorkoutEventTypeSegment 2019-11-14 07:32:41+03:00 5.980581492185593 min
573 2021-03-04 17:19:51.208534+03:00 2021-03-04 17:19:51.208534+03:00   109 109 HKWorkoutEventTypeSegment 2019-11-14 07:36:06+03:00 10.20967327555021 min
574 2021-03-04 17:19:51.208586+03:00 2021-03-04 17:19:51.208586+03:00   109 109 HKWorkoutEventTypeSegment 2019-11-14 07:38:40+03:00 6.151421103874842 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`);