ContactsContract.DataColumnsWithJoins

The count of rows in a directory.

The unique ID for a row.

Carrier presence information.

Indicates that the entry is Video Telephony (VT) capable on the current carrier.

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific.

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

Generic data column, the meaning is MIMETYPE specific

The version of this data record.

Whether this is the primary entry of its kind for the raw contact it belongs to.

The "read-only" flag: "0" by default, "1" if the row cannot be modified or deleted except by a sync adapter.

Whether this is the primary entry of its kind for the aggregate contact it belongs to.

The MIME type of the item represented by this row.

A reference to the _ID that this data belongs to.

The package name to use when creating Resources objects for this data row.

Generic column for use by sync adapters.

Generic column for use by sync adapters.

Generic column for use by sync adapters.

Generic column for use by sync adapters.

An allowed value of PRESENCE.

An allowed value of PRESENCE.

An allowed flag of CHAT_CAPABILITY.

An allowed flag of CHAT_CAPABILITY.

An allowed flag of CHAT_CAPABILITY.

Contact's audio/video chat capability level.

An allowed value of PRESENCE.

An allowed value of PRESENCE.

An allowed value of PRESENCE.

An allowed value of PRESENCE.

Contact's latest presence level.

This constant was deprecated in API level 8. use STATUS

This constant was deprecated in API level 8. use PRESENCE

Contact latest status update.

The resource ID of the icon for the source of the status update.

The resource ID of the label describing the source of the status update, e.g.

The package containing resources for this status: label and icon.

The absolute time in milliseconds when the latest status was inserted/updated.

A concatenation of the account type and data set (delimited by a forward slash) - if the data set is empty, this will be the same as the account type.

The aggregation mode for this contact.

Persistent unique id for each raw_contact within its account.

A reference to the _ID that this data belongs to.

The data set within the account that this row belongs to.

The "deleted" flag: "0" by default, "1" if the row has been marked for deletion.

Flag indicating that a raw contact's metadata has changed, and its metadata needs to be synchronized by the server.

The "read-only" flag: "0" by default, "1" if the row cannot be modified or deleted except by a sync adapter.

Flag that reflects whether this raw contact belongs to the user's personal profile entry.

Timestamp (milliseconds since epoch) of when this contact was last updated.

The display name for the contact.

An indicator of whether this contact has at least one phone number.

Flag that reflects whether the contact exists inside the default directory.

Flag that reflects the GROUP_VISIBLE state of any ContactsContract.CommonDataKinds.GroupMembership for this contact.

Flag that reflects whether this contact represents the user's personal profile entry.

An opaque value that contains hints on how to find the contact if its row id changed as a result of a sync or aggregation.

Reference to the row in the RawContacts table holding the contact name.

Photo file ID of the full-size photo.

Reference to the row in the data table holding the photo.

A URI that can be used to retrieve a thumbnail of the contact's photo.

A URI that can be used to retrieve the contact's full-size photo.

An alternative representation of the display name, such as "family name first" instead of "given name first" for Western names.

The standard text shown as the contact's display name, based on the best available information for the contact (for example, it might be the email address if the name is not available).

The kind of data that is used as the display name for the contact, such as structured name or email address.

Pronunciation of the full name in the phonetic alphabet specified by PHONETIC_NAME_STYLE.

The phonetic alphabet used to represent the PHONETIC_NAME.

Sort key based on the alternative representation of the full name, DISPLAY_NAME_ALTERNATIVE.

Sort key that takes into account locale-based traditions for sorting names in address books.

URI for a custom ringtone associated with the contact.

The last time a contact was contacted.

The position at which the contact is pinned.

Whether the contact should always be sent to voicemail.

Is the contact starred?

Type: INTEGER (boolean)

The number of times a contact has been contacted

Type: INTEGER

Contact Chat Capabilities.

Contact presence status.

Contact's latest status update.

The resource ID of the icon for the source of contact status.

The resource ID of the label describing the source of contact status, e.g.

The package containing resources for this status: label and icon.

The absolute time in milliseconds when the latest status was inserted/updated.

The last time (in milliseconds) this ContactsContract.Contacts.Data was used.

The number of times the referenced ContactsContract.Contacts.Data has been used.