standard_user_info

Description

An FQL table which returns basic information about a user. For use only for analytic information.

Columns

affiliations

array

The networks to which the user being queried belongs. The status field within this field will only return results in English

allowed_restrictions

string

A comma-delimited list of demographic restriction types a user is allowed to access. Currently, alcohol is the only type that can get returned

birthday

string

The user's birthday. The format of this date varies based on the user's locale

credit_currency

struct

User's credits currency

user_currency string	the ISO-4217-3 code for the user's preferred currency (defaulting to USD if the user hasn't set one)
currency_exchange float	the number of Facebook Credits that equate in value to one unit of user_currency
currency_exchange_inverse float	the number of units of user_currency that equate in value to one Credit
usd_exchange float	USD value of one unit of user_currency
usd_exchange_inverse float	value in USD that is equal to one unit in user_currency
currency_offset unsigned int32	the number by which a price should be divided for display in user_currency units

credit_deals

array

User's credit deals

current_location

struct

The user's current location

street string	Street of the location
city string	City of the location
state string	State of the location
country string	Country of the location
zip string	Zip code of the location
latitude float	Latitude of the location
longitude float	Longitude of the location
id id	ID of the location
name string	Name of the location
located_in id	ID of the parent location of this location

string

A string containing the user's primary Facebook email address or the user's proxied email address, whichever address the user granted your application. Facebook recommends you query this field to get the email address shared with your application

first_name

string

The user's first name

last_name

string

The user's last name

locale

string

The two-letter language code and the two-letter country code representing the user's locale. Country codes are taken from the ISO 3166 alpha 2 code

name

string

The user's full name

payment_pricepoints

array

The user's payment price points

profile_url

string

The URL to a user's profile

proxied_email

string

The proxied wrapper for a user's email address. If the user shared a proxied email address instead of his or her primary email address with you, this address also appears in the email field (see above). Facebook recommends you query the email field to get the email address shared with your application

sex

string

The user's gender

sort_first_name

string

The user's first name, if the user has a Japanese name

sort_last_name

string

The user's last name, if the user has a Japanese name

third_party_id

string

A string containing an anonymous, but unique identifier for the user. You can use this identifier with third-parties

timezone

number

The user's timezone offset from UTC

uid

number

The user ID

username

string

The user's username

Examples

SELECT ... FROM standard_user_info WHERE uid = A
SELECT ... FROM standard_user_info WHERE username = A
SELECT ... FROM standard_user_info WHERE third_party_id = A

Note: Additional filters on other columns can be specified but they may make the query less efficient.

Permissions

To read the standard_user_info table you need

an app access_token to get information about any authorized app users

Tables

standard_user_info

Description

Columns

Examples

Permissions