Backup files · Health

516d7e19a4a0c9475c0015fae195626377b1b810is healthdb_secure.sqlite

In an iPhone backup, the file 516d7e19a4a0c9475c0015fae195626377b1b810 is healthdb_secure.sqlite. Apple Health's records: steps, heart rate, workouts, sleep and every other sample the Health app keeps.

Real namehealthdb_secure.sqlite
DomainHealthDomain
PathHealth/healthdb_secure.sqlite
In the backup folder51/516d7e19a4a0c9475c0015fae195626377b1b810
Its name is the SHA-1 ofHealthDomain-Health/healthdb_secure.sqlite
AppHealth
Seen iniOS 13.3.1, 13.4.1, 15.3.1, 16.0, 16.1.2 and 17.3.
Needs an encrypted backupYes. Apple lists Health data among the things only an encrypted backup includes.
OpenExtract reads itNot yet.

What it holds

healthdb_secure.sqlite holds the Health app's records. Each sample is a row in samples, with its type and its start and end times. The value of a measurement, such as a step count or a heart rate, is in quantity_samples, matched by data_id.

Health/healthdb.sqlite (fa2e5ac3b7a62c8b7cb21e440c79eedd218550ea): The Health database's other file. It doesn't hold the samples; its tables list the apps and devices the data came from (sources, source_devices) and which apps may use Health data (authorization). We saw it next to healthdb_secure.sqlite in iOS 13.3.1, 13.4.1, 15.3.1, 16.0, 16.1.2 and 17.3.

Key columns

Tables by iOS version

iOS 13.3.1 has 51 tables:

ACHAchievementsPlugin_earned_instances, ACHAchievementsPlugin_templates, account_owner_samples, activity_caches, activitysharing_competition_lists, activitysharing_competitions, allergy_record_samples, binary_samples, category_samples, cda_documents, clinical_accounts, clinical_authorization_sessions, clinical_credentials, clinical_deleted_accounts, clinical_gateways, clinical_record_samples, concept_index, condition_record_samples, correlations, data_provenances, data_series, devices, diagnostic_test_report_samples, diagnostic_test_result_samples, external_sync_ids, fitness_friend_achievements, fitness_friend_activity_snapshots, fitness_friend_workouts, key_value_secure, medical_records, medication_dispense_record_samples, medication_order_samples, medication_record_samples, metadata_keys, metadata_values, object_authorizations, objects, original_fhir_resources, original_fhir_resources_last_seen, pending_associations, procedure_record_samples, quantity_sample_series, quantity_sample_statistics, quantity_samples, samples, schema_user_versions, unit_strings, unknown_record_samples, vaccination_record_samples, workout_events, workouts

Then, version by version:

The iOS 16.0 backup is encrypted with a password that isn't public, so only its list of files was checked, not its tables.

How to open it

OpenExtract doesn't read it yet. OpenExtract doesn't have a Health screen yet.

Always encrypted on disk. This file is only in encrypted backups, so the copy in the backup folder is encrypted with a key of its own, which only the backup password unlocks. Nothing can open it until it's decrypted. Tools such as iphone_backup_decrypt, the open-source library OpenExtract uses, can decrypt a single file; then open the decrypted copy with any SQLite browser, such as DB Browser for SQLite.

Checked against public test backups from iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3, and the file list of an iOS 16.0 backup, reading only file, table and column names. How we checked · All backup files

Read the backup, not the hashes.
OpenExtract opens iPhone backups for you. Free, open source, nothing uploaded. Mac · Windows · Linux.
Download OpenExtract →