workouts: 0ab8e4cda660dc1c39d7a191edab95add1c876d6
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0ab8e4cda660dc1c39d7a191edab95add1c876d6 | HKWorkoutActivityTypeCycling | 14.77257973353068 | min | jerWatch | 7.5 | 2021-06-22 10:18:56 +0100 | 2021-06-22 10:04:09 +0100 | 2021-06-22 10:18:55 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2021-06-22 10:04:09 +0100", "duration": "3.345967849095663", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-06-22 10:04:09 +0100", "duration": "5.379306737581889", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-06-22 10:07:30 +0100", "duration": "3.616673511266709", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-06-22 10:09:32 +0100", "duration": "9.116657855113347", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2021-06-22 10:04:09 +0100", "endDate": "2021-06-22 10:18:55 +0100", "sum": "62.8395", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2021-06-22 10:04:09 +0100", "endDate": "2021-06-22 10:18:55 +0100", "sum": "27.0705", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2021-06-22 10:04:09 +0100", "endDate": "2021-06-22 10:18:55 +0100", "sum": "2.30009", "unit": "km"}] | <<HKDevice: 0x2822104b0>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:7.5> | 0 | 4.68521 kcal/hr·kg | 64.4 degF | 7800 % | Europe/Berlin | 2815 cm |
Links from other tables
- 678 rows from workout_id in workout_points