Call History Database

call_history.db is an SQLite 3 database file which contains the call history from MobilePhone.app on iOS.

Serialization

In the folder /var/wireless/Library/CallHistory the file call_history.db is located. The iTunes Backup filename of call_history.db is 2b2b0084a1bc3a5ac8c27afdf14afb42c61a19ca.

Database file

The call_history.db SQLite 3 database has the following tables:

• _SqliteDatabaseProperties
• call

Tables

All date fields is shown as number of seconds since Jan 1st, 2001.

_SqliteDatabaseProperties

This is general-purpose table to store some configuration values.

field name	type
key	TEXT
value	TEXT
UNIQUE(key)

These values are stored in the table:

key	value	description
call_history_limit	100	Sets the limit on the number of entries in the call history, increasing this value has no effect however.
timer_lifetime	431337	A call time counter which counts the number of seconds for all phone calls ever made (both incoming and outgoing)
data_up_last	0	?
data_down_last	0	?
data_up_all	1337.72234523	A data counter which counts the number of megabytes sent via Cellular Network Data (i.e. not WiFi), since last statistics reset.
data_down_all	31337.56235627	A data counter which counts the number of megabytes received via Cellular Network Data (i.e. not WiFi), since last statistics reset.
data_up_lifetime	1337.72234523	A lifetime data counter which counts the number of megabytes sent via Cellular Network Data (i.e. not WiFi), doesn't get reset on a statistics reset.
data_down_lifetime	31337.56235627	A lifetime data counter which counts the number of megabytes received via Cellular Network Data (i.e. not WiFi), doesn't get reset on a statistics reset.
_UniqueIdentifier	CAFEBABE-F00D-DEAD-BEEF-31337ABFDEDA	An unique identifier for this phone
_ClientVersion	11	The version of this database version 12 is used in iOS 7 version 11 is used in iOS 6 version 9 is used in iOS 5 version 5 is used in iOS 3 version 3 is used in iOS 2
timer_last	1337	The length of the last phone call (in seconds)
timer_outgoing	31337	The total length of all outgoing phone calls, since last statistics reset
timer_ingoing	41337	The total length of all incoming phone calls, since last statistics reset
timer_all	72674	The total length of all incoming/outgoing phone calls, since last statistics reset
timer_last_reset	232345655.1842	The date the call timer statics was last reset, usally (almost) the same as data_last_reset.
data_last_reset	232345655.1942444	The date the data statics was last reset, usally (almost) the same as timer_last_reset.
__CPRecordSequenceNumber	39461	?

call

This is the main table where the call history is stored:

field name	type	value / description
ROWID	INTEGER PRIMARY KEY AUTOINCREMENT	primary key
address	TEXT	Phone number or FaceTime ID of contact that has been called/has received call from.
date	INTEGER	the date of the phone call
duration	INTEGER	number of seconds the phone call lasted
flags	INTEGER	flag is 4 for incoming calls, 5 for outgoing calls, 8 for blocked calls
id	INTEGER	Contacts or Address Book ID of the contact being called. This column would be -1 if the contact is unknown (e.g. not in address book). This column is always -1 on incoming calls.
name	TEXT	always empty
country_code	TEXT	The mobile country code (MCC) of the country the phone was in when the call was placed. Example: 234 for United Kingdom. (list of MCC/MNC)
network_code	TEXT	The mobile network code (MNC) of the network the phone was on when the call was placed. Example: 30 for T-Mobile (UK) (list of MCC/MNC)
read	INTEGER DEFAULT '1'	read=0 if the call is an missed call, which hasn't been "read". Example there is a (number) on the Phone icon, showing number of missed calls. read=1 if the missed calls has been checked.
assisted	INTEGER DEFAULT '0'	?
face_time_data	BLOB	?
originalAddress	TEXT DEFAULT ''	?

Note: name, country_code, network_code where added in iOS 5, while read, assisted, face_time_data, originalAddress where added in iOS 6.

References

• iPhone Call History Database
• Call History Database