19 rows where "date" is on date 2019-08-27 sorted by date

View and edit SQL

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

date (date)

  • 2019-08-27 · 19

created_at (date)

id created_at updated_at deleted_at workout_id type date ▼ duration duration_unit
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
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  
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

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