workouts: 0dbb72708b4da34e8605eeaff9b29146eff5f0a8
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0dbb72708b4da34e8605eeaff9b29146eff5f0a8 | HKWorkoutActivityTypeCycling | 6.07146653731664 | min | jerWatch | 9.0 | 2022-09-17 10:35:06 +0100 | 2022-09-17 10:29:01 +0100 | 2022-09-17 10:35:06 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2022-09-17 10:29:01 +0100", "duration": "3.818578594923019", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-09-17 10:32:50 +0100", "duration": "2.234647578001022", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierHeartRate", "startDate": "2022-09-17 10:29:01 +0100", "endDate": "2022-09-17 10:35:06 +0100", "average": "122.332", "minimum": "97", "maximum": "150", "unit": "count/min"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2022-09-17 10:29:01 +0100", "endDate": "2022-09-17 10:35:06 +0100", "sum": "8.548", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2022-09-17 10:29:01 +0100", "endDate": "2022-09-17 10:35:06 +0100", "sum": "1.19209", "unit": "km"}, {"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2022-09-17 10:29:01 +0100", "endDate": "2022-09-17 10:35:06 +0100", "sum": "34.62", "unit": "kcal"}] | <<HKDevice: 0x282240780>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 0 | 3.86428 kcal/hr·kg | Europe/Berlin |
Links from other tables
- 1 row from workout_id in workout_points