health_workout_events
19 rows where workout_id = 102 sorted by type
This data as json, CSV (advanced)
Suggested facets: type, date, duration, duration_unit, updated_at (date), date (date)
created_at (date) ✖
- 2021-03-04 19
id | created_at | updated_at | deleted_at | workout_id | type ▼ | date | duration | duration_unit |
---|---|---|---|---|---|---|---|---|
505 | 2021-03-04 17:19:51.197405+03:00 | 2021-03-04 17:19:51.197405+03:00 | 102 102 | HKWorkoutEventTypeMotionPaused | 2019-08-27 08:30:03+03:00 | 0.0 | ||
506 | 2021-03-04 17:19:51.197493+03:00 | 2021-03-04 17:19:51.197493+03:00 | 102 102 | HKWorkoutEventTypeMotionResumed | 2019-08-27 08:30:04+03:00 | 0.0 | ||
504 | 2021-03-04 17:19:51.197255+03:00 | 2021-03-04 17:19:51.197255+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 08:30:03+03:00 | 6.148566855986913 | min | |
507 | 2021-03-04 17:19:51.197548+03:00 | 2021-03-04 17:19:51.197548+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 08:36:12+03:00 | 6.280966111024221 | min | |
508 | 2021-03-04 17:19:51.197602+03:00 | 2021-03-04 17:19:51.197602+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 08:40:00+03:00 | 9.955482403437296 | min | |
509 | 2021-03-04 17:19:51.197655+03:00 | 2021-03-04 17:19:51.197655+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 08:42:28+03:00 | 6.195413672924042 | min | |
510 | 2021-03-04 17:19:51.19771+03:00 | 2021-03-04 17:19:51.19771+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 08:48:40+03:00 | 6.366488782564799 | min | |
511 | 2021-03-04 17:19:51.197761+03:00 | 2021-03-04 17:19:51.197761+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 08:49:57+03:00 | 11.36544363300006 | min | |
512 | 2021-03-04 17:19:51.197814+03:00 | 2021-03-04 17:19:51.197814+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 08:55:02+03:00 | 7.43450097044309 | min | |
513 | 2021-03-04 17:19:51.197867+03:00 | 2021-03-04 17:19:51.197867+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:01:19+03:00 | 10.38302700718244 | min | |
514 | 2021-03-04 17:19:51.197922+03:00 | 2021-03-04 17:19:51.197922+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:02:28+03:00 | 6.45199211637179 | min | |
515 | 2021-03-04 17:19:51.197973+03:00 | 2021-03-04 17:19:51.197973+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:08:55+03:00 | 6.452008712291717 | min | |
516 | 2021-03-04 17:19:51.198025+03:00 | 2021-03-04 17:19:51.198025+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:11:42+03:00 | 10.29771444201469 | min | |
517 | 2021-03-04 17:19:51.198078+03:00 | 2021-03-04 17:19:51.198078+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:15:22+03:00 | 6.366676547129949 | min | |
518 | 2021-03-04 17:19:51.198168+03:00 | 2021-03-04 17:19:51.198168+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:21:44+03:00 | 6.281153144439061 | min | |
519 | 2021-03-04 17:19:51.19822+03:00 | 2021-03-04 17:19:51.19822+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:22:00+03:00 | 10.08395265738169 | min | |
520 | 2021-03-04 17:19:51.198278+03:00 | 2021-03-04 17:19:51.198278+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:28:01+03:00 | 6.622855856021245 | min | |
521 | 2021-03-04 17:19:51.198333+03:00 | 2021-03-04 17:19:51.198333+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:32:05+03:00 | 2.606439558664958 | min | |
522 | 2021-03-04 17:19:51.198386+03:00 | 2021-03-04 17:19:51.198386+03:00 | 102 102 | HKWorkoutEventTypeSegment | 2019-08-27 09:34:39+03:00 | 0.04273412426312764 | min |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);