workouts: 0eca5939b24b4ac153fd580c6ca278ff7f001271
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0eca5939b24b4ac153fd580c6ca278ff7f001271 | HKWorkoutActivityTypeCycling | 20.98148698210716 | min | jerWatch_old | 6.2.6 | 2020-07-03 17:28:41 +0100 | 2020-07-03 16:20:59 +0100 | 2020-07-03 17:28:34 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:20:59 +0100", "duration": "3.74151419599851", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:20:59 +0100", "duration": "6.074845806757609", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:24:44 +0100", "duration": "3.99999619325002", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:27:04 +0100", "duration": "5.46666053533554", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:28:44 +0100", "duration": "3.199991138776143", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:31:56 +0100", "duration": "3.250009590387344", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:32:32 +0100", "duration": "20.88333900968234", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:35:11 +0100", "duration": "18.85000792543093", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2020-07-03 16:38:27 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2020-07-03 16:53:11 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:53:25 +0100", "duration": "35.14999618728955", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-07-03 16:54:02 +0100", "duration": "34.53332249522209", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2020-07-03 16:56:42 +0100"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2020-07-03 16:20:59 +0100", "endDate": "2020-07-03 17:28:34 +0100", "sum": "146.856", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2020-07-03 16:20:59 +0100", "endDate": "2020-07-03 17:28:34 +0100", "sum": "42.3456", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2020-07-03 16:20:59 +0100", "endDate": "2020-07-03 17:28:34 +0100", "sum": "5.61534", "unit": "km"}] | <<HKDevice: 0x2822f6030>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch3,2, software:6.2.6> | 0 | 3.86195 kcal/hr·kg | 74 degF | 4200 % | Europe/Berlin | 4096 cm |
Links from other tables
- 1,258 rows from workout_id in workout_points