healthkit
Queries
Tables
activity_summary
dateComponents, activeEnergyBurned, activeEnergyBurnedGoal, activeEnergyBurnedUnit, appleMoveTime, appleMoveTimeGoal, appleExerciseTime, appleExerciseTimeGoal, appleStandHours, appleStandHoursGoal
1,163 rows
rActiveEnergyBurned
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, device, metadata_HKMetadataKeySyncVersion, metadata_HKMetadataKeySyncIdentifier
Many rows
rAppleExerciseTime
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
39,769 rows
rAppleStandHour
startDate, endDate, value, sourceName, sourceVersion, device, creationDate
12,762 rows
rAppleStandTime
startDate, endDate, value, unit, sourceName, creationDate, sourceVersion
33,976 rows
rAppleWalkingSteadiness
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
67 rows
rAudioExposureEvent
startDate, endDate, value, sourceName, sourceVersion, device, creationDate, metadata_HKMetadataKeyAudioExposureLevel
29 rows
rBasalEnergyBurned
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, device, metadata_HKMetadataKeySyncVersion, metadata_HKMetadataKeySyncIdentifier
Many rows
rBodyFatPercentage
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, metadata_HKWasUserEntered
126 rows
rBodyMass
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, metadata_HKWasUserEntered
282 rows
rDistanceCycling
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, device, metadata_HKMetadataKeySyncVersion, metadata_HKMetadataKeySyncIdentifier
Many rows
rDistanceWalkingRunning
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate, metadata_HKMetadataKeySyncVersion, metadata_HKMetadataKeySyncIdentifier
Many rows
rEnvironmentalAudioExposure
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
17,806 rows
rEnvironmentalSoundReduction
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
82 rows
rFlightsClimbed
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
19,714 rows
rHKDataTypeSleepDurationGoal
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate
1 row
rHeadphoneAudioExposure
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
3,197 rows
rHeartRate
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, device, metadata_HKMetadataKeyHeartRateMotionContext, metadata_HKMetadataKeySyncVersion, metadata_HKMetadataKeySyncIdentifier
Many rows
rHeartRateRecoveryOneMinute
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, metadata_HKAlgorithmVersion, metadata_HKMetadataKeySessionEstimate, metadata_HKMetadataKeyHeartRateRecoveryActivityDuration, metadata_HKMetadataKeyHeartRateRecoveryTestType, metadata_HKMetadataKeyHeartRateRecoveryMaxObservedRecoveryHeartRate, metadata_HKMetadataKeyUserMotionContext, metadata_HKMetadataKeyHeartRateRecoveryActivityType
26 rows
rHeartRateVariabilitySDNN
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate, metadata_HKAlgorithmVersion
3,188 rows
rHeight
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, metadata_HKWasUserEntered
1 row
rOxygenSaturation
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate, metadata_HKMetadataKeyBarometricPressure
4,887 rows
rRespiratoryRate
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
12,001 rows
rRunningGroundContactTime
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
2,554 rows
rRunningPower
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
5,322 rows
rRunningSpeed
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
5,405 rows
rRunningStrideLength
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
2,651 rows
rRunningVerticalOscillation
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
2,567 rows
rSixMinuteWalkTestDistance
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate, metadata_HKMetadataKeyAppleDeviceCalibrated, metadata_HKDateOfEarliestDataUsedForEstimate
67 rows
rSleepAnalysis
startDate, endDate, value, sourceName, sourceVersion, creationDate, metadata_HKTimeZone
5,388 rows
rStairAscentSpeed
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate
3,155 rows
rStairDescentSpeed
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate
2,377 rows
rStepCount
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate, metadata_HKMetadataKeySyncVersion, metadata_HKMetadataKeySyncIdentifier
Many rows
rVO2Max
startDate, endDate, value, unit, sourceName, creationDate, metadata_HKVO2MaxTestType, sourceVersion, metadata_HKMetadataKeySyncVersion, metadata_HKMetadataKeySyncIdentifier
519 rows
rWalkingAsymmetryPercentage
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate, metadata_HKMetadataKeyDevicePlacementSide
7,014 rows
rWalkingDoubleSupportPercentage
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
11,570 rows
rWalkingHeartRateAverage
startDate, endDate, value, unit, sourceName, sourceVersion, creationDate
948 rows
rWalkingSpeed
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
14,982 rows
rWalkingStepLength
startDate, endDate, value, unit, sourceName, sourceVersion, device, creationDate
14,980 rows
workout_points
date, latitude, longitude, altitude, horizontalAccuracy, verticalAccuracy, course, speed, workout_id
Many rows
workouts
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
1,180 rows