workouts: 07eec59902d7a24b95b9950eed2b079b6c29ce65
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 07eec59902d7a24b95b9950eed2b079b6c29ce65 | HKWorkoutActivityTypeCycling | 5.180890132983525 | min | jerWatch | 8.3 | 2022-01-08 13:52:08 +0100 | 2022-01-08 13:46:57 +0100 | 2022-01-08 13:52:08 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2022-01-08 13:46:57 +0100", "duration": "4.494475003083547", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-01-08 13:51:27 +0100", "duration": "0.6606117248535156", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2022-01-08 13:46:57 +0100", "endDate": "2022-01-08 13:52:08 +0100", "sum": "30.0778", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2022-01-08 13:46:57 +0100", "endDate": "2022-01-08 13:52:08 +0100", "sum": "7.58263", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2022-01-08 13:46:57 +0100", "endDate": "2022-01-08 13:52:08 +0100", "sum": "1.14176", "unit": "km"}] | <<HKDevice: 0x282225d60>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:8.3> | 0 | 3.15406 kcal/hr·kg | 35.6 degF | 8100 % | Europe/Berlin |
Links from other tables
- 3 rows from workout_id in workout_points