workouts: 04fb2594c6b16a78a30bf9351607ae5ade394b1f
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 04fb2594c6b16a78a30bf9351607ae5ade394b1f | HKWorkoutActivityTypeWalking | 23.1902491291364 | min | jerWatch_old | 6.1 | 2019-11-13 13:16:57 +0100 | 2019-11-13 12:51:42 +0100 | 2019-11-13 13:14:54 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2019-11-13 12:51:42 +0100", "duration": "16.97142408092817", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2019-11-13 13:08:41 +0100", "duration": "3.537522180875142", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2019-11-13 12:51:42 +0100", "endDate": "2019-11-13 13:14:54 +0100", "sum": "113.759", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceWalkingRunning", "startDate": "2019-11-13 12:51:42 +0100", "endDate": "2019-11-13 13:14:54 +0100", "sum": "1.58345", "unit": "km"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2019-11-13 12:51:42 +0100", "endDate": "2019-11-13 13:14:54 +0100", "sum": "50.8235", "unit": "kcal"}] | <<HKDevice: 0x28220aad0>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch3,2, software:6.1> | 0 | 3.22804 kcal/hr·kg | 55 degF | 7400 % | Europe/Berlin |
Links from other tables
- 356 rows from workout_id in workout_points