workouts: 026c0ad8400400f6569470736307c6c86ba5b01d
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 026c0ad8400400f6569470736307c6c86ba5b01d | HKWorkoutActivityTypeRunning | 12.92971926728884 | min | jerWatch | 7.5 | 2021-06-08 18:10:07 +0100 | 2021-06-08 17:57:10 +0100 | 2021-06-08 18:10:06 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2021-06-08 17:57:10 +0100", "duration": "5.56549756526947", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-06-08 17:57:10 +0100", "duration": "9.325021717945734", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeMotionPaused", "date": "2021-06-08 17:57:10 +0100"}, {"type": "HKWorkoutEventTypeMotionResumed", "date": "2021-06-08 17:57:14 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-06-08 18:02:44 +0100", "duration": "5.810153234004974", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-06-08 18:06:29 +0100", "duration": "3.54588623046875", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2021-06-08 17:57:10 +0100", "endDate": "2021-06-08 18:10:06 +0100", "sum": "170.392", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceWalkingRunning", "startDate": "2021-06-08 17:57:10 +0100", "endDate": "2021-06-08 18:10:06 +0100", "sum": "2.25224", "unit": "km"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2021-06-08 17:57:10 +0100", "endDate": "2021-06-08 18:10:06 +0100", "sum": "25.738", "unit": "kcal"}] | <<HKDevice: 0x28221d9a0>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:7.5> | 0 | 9.87154 kcal/hr·kg | 78.8 degF | 4000 % | Europe/Berlin |
Links from other tables
- 773 rows from workout_id in workout_points