In an iPhone backup, the file 1a0e7afc19d307da602ccdcece51af33afe92c53 is History.db. Safari's browsing history: every page visited, its title, and the time of each visit.
| Real name | History.db |
| Domain | HomeDomain |
| Path | Library/Safari/History.db |
| In the backup folder | 1a/1a0e7afc19d307da602ccdcece51af33afe92c53 |
| Its name is the SHA-1 of | HomeDomain-Library/Safari/History.db |
| App | Safari |
| Seen in | iOS 13.3.1, 13.4.1, 15.3.1, 16.0, 16.1.2 and 17.3. |
| Needs an encrypted backup | Yes. Apple lists website history among the things only an encrypted backup includes, so an unencrypted backup has no Safari history to read. |
| OpenExtract reads it | Yes, on the Web history screen. Guide: Export Safari history from an iPhone backup |
History.db is Safari's history. history_items has one row per web address, with how many times it was visited. history_visits has one row per visit, with its time and the page's title.
history_items.url: The web address.history_items.visit_count: How many times it was visited.history_visits.history_item: Which address was visited: its id in history_items.history_visits.visit_time: When, in seconds since 1 January 2001 (UTC).history_visits.title: The page's title at that visit.The same 9 tables in every backup we opened (iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3):
history_client_versions, history_event_listeners, history_events, history_items, history_items_to_tags, history_tags, history_tombstones, history_visits, metadata
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.
Free, in OpenExtract. Open the backup in OpenExtract and choose Web history. Timeline uses it too. OpenExtract lists every visit, newest first, with Firefox history alongside, and saves the list as CSV. Step by step: Export Safari history from an iPhone backup.
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. OpenExtract does that when you open the backup and type its password.
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