workouts: 021fc20fbec220b573f9e8f1659278e054a77195
This data as json
| id | workoutActivityType | duration | durationUnit | sourceName | sourceVersion | creationDate | startDate | endDate | metadata_HKWasUserEntered | workout_events | workout_statistics | device | metadata_HKIndoorWorkout | metadata_HKAverageMETs | metadata_HKWeatherTemperature | metadata_HKWeatherHumidity | metadata_HKTimeZone | metadata_HKElevationAscended |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 021fc20fbec220b573f9e8f1659278e054a77195 | HKWorkoutActivityTypeCycling | 18.28443714976311 | min | jerWatch | 8.5.1 | 2022-04-20 21:02:27 +0100 | 2022-04-20 20:44:09 +0100 | 2022-04-20 21:02:26 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:44:09 +0100", "duration": "3.058823170264562", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:44:09 +0100", "duration": "5.684598104159037", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:47:13 +0100", "duration": "3.825192085901896", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeMotionPaused", "date": "2022-04-20 20:47:47 +0100"}, {"type": "HKWorkoutEventTypeMotionResumed", "date": "2022-04-20 20:48:23 +0100"}, {"type": "HKWorkoutEventTypeMotionPaused", "date": "2022-04-20 20:49:29 +0100"}, {"type": "HKWorkoutEventTypeMotionResumed", "date": "2022-04-20 20:49:35 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:49:50 +0100", "duration": "4.603486539920171", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeMotionPaused", "date": "2022-04-20 20:50:23 +0100"}, {"type": "HKWorkoutEventTypeMotionResumed", "date": "2022-04-20 20:50:28 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:51:02 +0100", "duration": "2.753767130772273", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:53:47 +0100", "duration": "3.000054599841436", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:54:27 +0100", "duration": "4.383256816864014", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeMotionPaused", "date": "2022-04-20 20:54:55 +0100"}, {"type": "HKWorkoutEventTypeMotionResumed", "date": "2022-04-20 20:55:00 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-04-20 20:56:47 +0100", "duration": "2.033504474163055", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeMotionPaused", "date": "2022-04-20 20:57:47 +0100"}, {"type": "HKWorkoutEventTypeMotionResumed", "date": "2022-04-20 20:58:17 +0100"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2022-04-20 20:44:09 +0100", "endDate": "2022-04-20 21:02:26 +0100", "sum": "149.097", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2022-04-20 20:44:09 +0100", "endDate": "2022-04-20 21:02:26 +0100", "sum": "36.2199", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2022-04-20 20:44:09 +0100", "endDate": "2022-04-20 21:02:26 +0100", "sum": "4.44507", "unit": "km"}] | <<HKDevice: 0x282228d70>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:8.5.1> | 0 | 6.80287 kcal/hr·kg | 51.8 degF | 5200 % | Europe/Berlin | 1459 cm |
Links from other tables
- 883 rows from workout_id in workout_points