workouts: 0ca7b416efe978968a66c1dd29ae728dbc2f4183
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0ca7b416efe978968a66c1dd29ae728dbc2f4183 | HKWorkoutActivityTypeHiking | 173.3233946839968 | min | jerWatch | 8.5 | 2022-03-28 13:23:06 +0100 | 2022-03-28 10:23:12 +0100 | 2022-03-28 13:23:04 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 10:23:12 +0100", "duration": "12.02623901168505", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 10:23:12 +0100", "duration": "19.77017421325048", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 10:35:13 +0100", "duration": "12.43067996104558", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 10:42:58 +0100", "duration": "21.47401735385259", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 10:47:39 +0100", "duration": "14.17401986122131", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 11:01:50 +0100", "duration": "12.67244062622388", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 11:04:26 +0100", "duration": "30.86330681244532", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 11:14:30 +0100", "duration": "26.28371807932854", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 11:35:18 +0100", "duration": "53.71920244495074", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 11:40:47 +0100", "duration": "33.41618889172872", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2022-03-28 11:52:01 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-03-28 11:57:15 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 12:14:12 +0100", "duration": "34.73648231228193", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2022-03-28 12:22:47 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-03-28 12:23:50 +0100"}, {"type": "HKWorkoutEventTypePause", "date": "2022-03-28 12:24:00 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-03-28 12:24:16 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 12:29:01 +0100", "duration": "42.76363618175188", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 12:48:56 +0100", "duration": "22.23057612776756", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 13:11:10 +0100", "duration": "11.72952649195989", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 13:11:47 +0100", "duration": "11.23663323918978", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-03-28 13:22:54 +0100", "duration": "0.1270988821983337", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2022-03-28 10:23:12 +0100", "endDate": "2022-03-28 13:23:04 +0100", "sum": "1123.38", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceWalkingRunning", "startDate": "2022-03-28 10:23:12 +0100", "endDate": "2022-03-28 13:23:04 +0100", "sum": "9.01037", "unit": "km"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2022-03-28 10:23:12 +0100", "endDate": "2022-03-28 13:23:04 +0100", "sum": "353.114", "unit": "kcal"}] | <<HKDevice: 0x28222a2b0>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:8.5> | 0 | 5.21074 kcal/hr·kg | 41 degF | 6600 % | Europe/Berlin | 60600 cm |
Links from other tables
- 10,400 rows from workout_id in workout_points