workouts: 9fb0733535a46fcaf84712acd2b92613f01e8c51
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9fb0733535a46fcaf84712acd2b92613f01e8c51 | HKWorkoutActivityTypeWalking | 17.73050568501155 | min | jerWatch_old | 6.0.1 | 2019-10-13 14:15:52 +0100 | 2019-10-13 13:58:06 +0100 | 2019-10-13 14:15:49 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2019-10-13 13:58:06 +0100", "duration": "11.65423051714897", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2019-10-13 14:09:45 +0100", "duration": "4.855602302153906", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2019-10-13 13:58:06 +0100", "endDate": "2019-10-13 14:15:49 +0100", "sum": "87.2464", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceWalkingRunning", "startDate": "2019-10-13 13:58:06 +0100", "endDate": "2019-10-13 14:15:49 +0100", "sum": "1.1122", "unit": "km"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2019-10-13 13:58:06 +0100", "endDate": "2019-10-13 14:15:49 +0100", "sum": "38.4966", "unit": "kcal"}] | <<HKDevice: 0x28220bb10>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch3,2, software:6.0.1> | 0 | 2.98719 kcal/hr·kg | 75 degF | 5900 % | Europe/Berlin |
Links from other tables
- 416 rows from workout_id in workout_points