workouts: 10220c6c53c0e3f57f074ec14414ce6079cd4d37
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10220c6c53c0e3f57f074ec14414ce6079cd4d37 | HKWorkoutActivityTypeCycling | 11.29966135025024 | min | jerWatch | 7.3.3 | 2021-04-23 12:03:17 +0100 | 2021-04-23 11:51:58 +0100 | 2021-04-23 12:03:16 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2021-04-23 11:51:58 +0100", "duration": "3.727013246218363", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-04-23 11:55:42 +0100", "duration": "3.299987951914469", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2021-04-23 11:51:58 +0100", "endDate": "2021-04-23 12:03:16 +0100", "sum": "69.426", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2021-04-23 11:51:58 +0100", "endDate": "2021-04-23 12:03:16 +0100", "sum": "21.0676", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2021-04-23 11:51:58 +0100", "endDate": "2021-04-23 12:03:16 +0100", "sum": "1.59781", "unit": "km"}] | <<HKDevice: 0x28221b200>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:7.3.3> | 0 | 5.4233 kcal/hr·kg | 55.4 degF | 4500 % | Europe/Berlin | 204 cm |
Links from other tables
- 426 rows from workout_id in workout_points