workouts: 0192982e434d81f61df54ddd26ae0d4e77b40fea
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0192982e434d81f61df54ddd26ae0d4e77b40fea | HKWorkoutActivityTypeWalking | 17.83606506586075 | min | jerWatch | 7.6 | 2021-07-31 15:41:48 +0100 | 2021-07-31 15:23:57 +0100 | 2021-07-31 15:41:47 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2021-07-31 15:23:57 +0100", "duration": "12.47735919356346", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-07-31 15:36:25 +0100", "duration": "4.656634654601415", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2021-07-31 15:23:57 +0100", "endDate": "2021-07-31 15:41:47 +0100", "sum": "83.3214", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceWalkingRunning", "startDate": "2021-07-31 15:23:57 +0100", "endDate": "2021-07-31 15:41:47 +0100", "sum": "1.11773", "unit": "km"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2021-07-31 15:23:57 +0100", "endDate": "2021-07-31 15:41:47 +0100", "sum": "35.3076", "unit": "kcal"}] | <<HKDevice: 0x282212490>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:7.6> | 0 | 4.28516 kcal/hr·kg | 75.2 degF | 3800 % | Europe/Berlin | 366 cm |
Links from other tables
- 939 rows from workout_id in workout_points