workouts: 0dff1403fb9406684a1eaeae6146ecfd4b9cce31
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0dff1403fb9406684a1eaeae6146ecfd4b9cce31 | HKWorkoutActivityTypeCycling | 12.4463353673617 | min | jerWatch_old | 6.2.8 | 2020-09-05 09:07:41 +0100 | 2020-09-05 08:55:12 +0100 | 2020-09-05 09:07:39 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2020-09-05 08:55:12 +0100", "duration": "3.305601702133814", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-09-05 08:55:12 +0100", "duration": "5.822268640995025", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-09-05 08:58:31 +0100", "duration": "3.716660483678182", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2020-09-05 09:01:02 +0100", "duration": "5.266658886273702", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2020-09-05 08:55:12 +0100", "endDate": "2020-09-05 09:07:39 +0100", "sum": "74.79", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2020-09-05 08:55:12 +0100", "endDate": "2020-09-05 09:07:39 +0100", "sum": "23.5275", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2020-09-05 08:55:12 +0100", "endDate": "2020-09-05 09:07:39 +0100", "sum": "2.71712", "unit": "km"}] | <<HKDevice: 0x2822c9130>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch3,2, software:6.2.8> | 0 | 5.70354 kcal/hr·kg | 62 degF | 8700 % | Europe/Berlin | 293 cm |
Links from other tables
- 696 rows from workout_id in workout_points