workouts: 093ecb6246eb903897e5037fbfe79ff637debd3f
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 093ecb6246eb903897e5037fbfe79ff637debd3f | HKWorkoutActivityTypeCycling | 97.15399203300476 | min | jerWatch | 7.4.1 | 2021-05-09 14:05:01 +0100 | 2021-05-09 12:13:05 +0100 | 2021-05-09 14:05:00 +0100 | [{"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:13:05 +0100", "duration": "5.927298279603322", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:13:05 +0100", "duration": "7.577299024661382", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:19:01 +0100", "duration": "3.299990405639013", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:20:40 +0100", "duration": "5.783320109049479", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:22:19 +0100", "duration": "3.483333279689153", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:25:48 +0100", "duration": "3.883338131507238", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:26:27 +0100", "duration": "6.600007577737173", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:29:41 +0100", "duration": "4.116673002640407", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:33:03 +0100", "duration": "5.699994258085886", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:33:48 +0100", "duration": "3.449988301595052", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:37:15 +0100", "duration": "3.699995964765549", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:38:45 +0100", "duration": "10.11666240493457", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:40:57 +0100", "duration": "7.81668486793836", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:48:46 +0100", "duration": "3.216653261582057", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:48:52 +0100", "duration": "5.233344509204229", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:51:59 +0100", "duration": "3.666659883658091", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:54:06 +0100", "duration": "5.549990206956863", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:55:39 +0100", "duration": "3.150017146269481", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:58:48 +0100", "duration": "3.483330734570821", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 12:59:39 +0100", "duration": "5.883355770508448", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:02:17 +0100", "duration": "3.733322429656982", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:05:32 +0100", "duration": "8.399991057316463", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:06:01 +0100", "duration": "6.116666928927104", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:12:08 +0100", "duration": "3.933348594109217", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:13:56 +0100", "duration": "6.383336188395818", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:16:04 +0100", "duration": "3.983330597480138", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:20:03 +0100", "duration": "7.483323736985525", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:20:19 +0100", "duration": "10.74998276631037", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:27:32 +0100", "duration": "4.83333967924118", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:31:04 +0100", "duration": "5.900016729036967", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:32:22 +0100", "duration": "3.383327068885167", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:35:45 +0100", "duration": "7.100006997585297", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:36:58 +0100", "duration": "9.816658218701681", "durationUnit": "min"}, {"type": "HKWorkoutEventTypeSegment", "date": "2021-05-09 13:46:47 +0100", "duration": "18.18333212534587", "durationUnit": "min"}, {"type": "HKWorkoutEventTypePause", "date": "2021-05-09 13:50:14 +0100"}] | [{"type": "HKQuantityTypeIdentifierActiveEnergyBurned", "startDate": "2021-05-09 12:13:05 +0100", "endDate": "2021-05-09 14:05:00 +0100", "sum": "413.249", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierBasalEnergyBurned", "startDate": "2021-05-09 12:13:05 +0100", "endDate": "2021-05-09 14:05:00 +0100", "sum": "183.979", "unit": "kcal"}, {"type": "HKQuantityTypeIdentifierDistanceCycling", "startDate": "2021-05-09 12:13:05 +0100", "endDate": "2021-05-09 14:05:00 +0100", "sum": "21.0761", "unit": "km"}] | <<HKDevice: 0x28221c410>, name:Apple Watch, manufacturer:Apple Inc., model:Watch, hardware:Watch6,4, software:7.4.1> | 0 | 4.23369 kcal/hr·kg | 77 degF | 3400 % | Europe/Berlin | 4387 cm |
Links from other tables
- 5,828 rows from workout_id in workout_points