workouts: 097700879e8f619e09eecc06355592d34003f92f
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 097700879e8f619e09eecc06355592d34003f92f | HKWorkoutActivityTypeHiking | 296.3361289978027 | min | jerWatch | 9.0 | 2022-10-04 04:16:04 +0100 | 2022-10-03 23:02:23 +0100 | 2022-10-04 04:15:32 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2022-10-03 23:02:23 +0100", "duration": "19.22860780755679", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-03 23:02:23 +0100", "duration": "34.25870749155681", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-03 23:21:37 +0100", "duration": "21.08162720004718", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-03 23:36:39 +0100", "duration": "33.93869498372078", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-03 23:42:42 +0100", "duration": "22.79183015028635", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 00:05:30 +0100", "duration": "27.34897960821787", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 00:10:35 +0100", "duration": "44.15863241553306", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2022-10-04 00:29:23 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-10-04 00:31:14 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 00:32:50 +0100", "duration": "25.82289700905482", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2022-10-04 00:41:30 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-10-04 00:42:04 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 00:54:45 +0100", "duration": "33.36733610828718", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 00:58:40 +0100", "duration": "21.05826382637024", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 01:19:43 +0100", "duration": "23.69961195985476", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 01:28:07 +0100", "duration": "54.78061765034993", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 01:43:25 +0100", "duration": "38.71254372199376", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2022-10-04 01:49:09 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-10-04 02:00:25 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 02:22:08 +0100", "duration": "20.92918596665065", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 02:22:54 +0100", "duration": "30.2002478102843", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 02:43:04 +0100", "duration": "15.26222569942474", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 02:53:06 +0100", "duration": "29.88371468583743", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 02:58:20 +0100", "duration": "19.31730360587438", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 03:17:39 +0100", "duration": "18.7626395424207", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 03:22:59 +0100", "duration": "27.20944133003553", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 03:36:24 +0100", "duration": "15.96755092938741", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 03:50:11 +0100", "duration": "24.44268427292506", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 03:52:22 +0100", "duration": "19.54037225246429", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2022-10-04 04:04:38 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-10-04 04:05:50 +0100"}, {"type": "HKWorkoutEventTypePause", "date": "2022-10-04 04:07:05 +0100"}, {"type": "HKWorkoutEventTypeResume", "date": "2022-10-04 04:09:01 +0100"}, {"type": "HKWorkoutEventTypeSegment", "date": "2022-10-04 04:11:55 +0100", "duration": "2.716437468926112", "durationUnit": "min"}] | [{"type": "HKQuantityTypeIdentifierDistanceWalkingRunning", "startDate": "2022-10-03 23:02:23 +0100", "endDate": "2022-10-04 04:15:32 +0100", "sum": "14.2157", "unit": "km"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2022-10-03 23:02:23 +0100", "endDate": "2022-10-04 04:15:32 +0100", "sum": "610.205", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierHeartRate", "startDate": "2022-10-03 23:02:23 +0100", "endDate": "2022-10-04 04:15:32 +0100", "average": "135.101", "minimum": "92", "maximum": "181", "unit": "count/min"}, {"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2022-10-03 23:02:23 +0100", "endDate": "2022-10-04 04:15:32 +0100", "sum": "1681.01", "unit": "kcal"}] | <<HKDevice: 0x282240780>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:9.0> | 0 | 4.75488 kcal/hr·kg | Pacific/Honolulu | 57079 cm |
Links from other tables
- 17,774 rows from workout_id in workout_points