workouts: 0773e2a41f9232be5a7d6bf53e9dfbb5e21484eb
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0773e2a41f9232be5a7d6bf53e9dfbb5e21484eb | HKWorkoutActivityTypeWalking | 16.08309354980787 | min | jerWatch | 8.1 | 2021-12-08 12:30:40 +0100 | 2021-12-08 12:14:35 +0100 | 2021-12-08 12:30:40 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2021-12-08 12:14:35 +0100", "duration": "13.86668914159139", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-12-08 12:28:27 +0100", "duration": "2.001416782538096", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2021-12-08 12:14:35 +0100", "endDate": "2021-12-08 12:30:40 +0100", "sum": "73.8934", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceWalkingRunning", "startDate": "2021-12-08 12:14:35 +0100", "endDate": "2021-12-08 12:30:40 +0100", "sum": "1.17437", "unit": "km"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2021-12-08 12:14:35 +0100", "endDate": "2021-12-08 12:30:40 +0100", "sum": "32.4832", "unit": "kcal"}] | <<HKDevice: 0x282233570>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:8.1> | 0 | 4.22899 kcal/hr·kg | 33.8 degF | 7700 % | Europe/Berlin | 205 cm |
Links from other tables
- 955 rows from workout_id in workout_points