home / healthkit / workouts

Menu
  • ripgrep search
  • Dashboards

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
Powered by Datasette · Queries took 1.319ms