22 rows where "date" is on date 2019-11-17 sorted by created_at

View and edit SQL

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

workout_id

date (date)

  • 2019-11-17 · 22
id created_at ▼ updated_at deleted_at workout_id type date duration duration_unit
575 2021-03-04 17:19:51.209528+03:00 2021-03-04 17:19:51.209528+03:00   110 110 HKWorkoutEventTypeSegment 2019-11-17 07:28:03+03:00 6.292756160100301 min
576 2021-03-04 17:19:51.209637+03:00 2021-03-04 17:19:51.209637+03:00   110 110 HKWorkoutEventTypeMotionPaused 2019-11-17 07:28:03+03:00 0.0  
577 2021-03-04 17:19:51.209696+03:00 2021-03-04 17:19:51.209696+03:00   110 110 HKWorkoutEventTypeMotionResumed 2019-11-17 07:28:05+03:00 0.0  
578 2021-03-04 17:19:51.209755+03:00 2021-03-04 17:19:51.209755+03:00   110 110 HKWorkoutEventTypeMotionPaused 2019-11-17 07:29:31+03:00 0.0  
579 2021-03-04 17:19:51.20981+03:00 2021-03-04 17:19:51.20981+03:00   110 110 HKWorkoutEventTypePause 2019-11-17 07:29:32+03:00 0.0  
580 2021-03-04 17:19:51.209869+03:00 2021-03-04 17:19:51.209869+03:00   110 110 HKWorkoutEventTypeResume 2019-11-17 07:29:40+03:00 0.0  
581 2021-03-04 17:19:51.209924+03:00 2021-03-04 17:19:51.209924+03:00   110 110 HKWorkoutEventTypeMotionPaused 2019-11-17 07:29:40+03:00 0.0  
582 2021-03-04 17:19:51.209978+03:00 2021-03-04 17:19:51.209978+03:00   110 110 HKWorkoutEventTypeMotionResumed 2019-11-17 07:29:42+03:00 0.0  
583 2021-03-04 17:19:51.210034+03:00 2021-03-04 17:19:51.210034+03:00   110 110 HKWorkoutEventTypeSegment 2019-11-17 07:34:21+03:00 6.023029577732086 min
584 2021-03-04 17:19:51.210089+03:00 2021-03-04 17:19:51.210089+03:00   110 110 HKWorkoutEventTypeSegment 2019-11-17 07:38:06+03:00 10.12410770853361 min
585 2021-03-04 17:19:51.210142+03:00 2021-03-04 17:19:51.210142+03:00   110 110 HKWorkoutEventTypeSegment 2019-11-17 07:40:22+03:00 6.535826418797175 min
586 2021-03-04 17:19:51.210196+03:00 2021-03-04 17:19:51.210196+03:00   110 110 HKWorkoutEventTypeSegment 2019-11-17 07:46:54+03:00 6.194478402535121 min
587 2021-03-04 17:19:51.210249+03:00 2021-03-04 17:19:51.210249+03:00   110 110 HKWorkoutEventTypeSegment 2019-11-17 07:48:14+03:00 8.287904200951258 min
588 2021-03-04 17:19:51.210304+03:00 2021-03-04 17:19:51.210304+03:00   110 110 HKWorkoutEventTypeSegment 2019-11-17 07:53:06+03:00 3.417738580703735 min
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`);