Page (FQL)
From Facebook Developers Wiki
[edit] Description
The FQL page table. Query this table to return information about a Facebook Page.
To structure your query, use the table name (page in this case) in the FROM clause. The items in the Name column correspond to columns in the table that can be referenced in the SELECT and WHERE clauses.
In order to make your query indexable, the WHERE in your query should contain an = or IN clause for one of the columns marked with a * in the Indexable column of the table.
The See Also section lists API functions that work on similar data; their documentation pages contain additional information about the contents of the column and example FQL queries.
[edit] Columns
| Indexable | Name | Type | Description | |
| * | page_id | int | The ID of the Page being queried. | |
|---|---|---|---|---|
| * | name | string | The name of the Page being queried. | |
| pic_small | string | The URL to the small-sized picture for the Page being queried. The image can have a maximum width of 50px and a maximum height of 150px. This URL may be blank. | ||
| pic_big | string | The URL to the large-sized profile picture for the Page being queried. The image can have a maximum width of 200px and a maximum height of 600px. This URL may be blank. | ||
| pic_square | string | The URL to the square profile picture for the Page being queried. The image can have a maximum width and height of 50px. This URL may be blank. | ||
| pic | string | The URL to the medium-sized profile picture for the Page being queried. The image can have a maximum width of 100px and a maximum height of 300px. This URL may be blank. | ||
| pic_large | string | The URL to the largest-sized profile picture for the Page being queried. The image can have a maximum width of 396px and a maximum height of 1188px. This URL may be blank. | ||
| type | string | The type of Page being queried. | ||
| website | string | The URL to the Web site of of the Page being queried. | ||
| has_added_app | bool | Indicates whether a calling application has been added by the Page being queried. | ||
| founded | string | The date when the subject of the Page being queried was founded. This field may be blank. | ||
| company_overview | string | Summary of the subject of the Page being queried. This field may be blank. | ||
| mission | string | The mission statement of the organization that is the subject of the Page being queried. This field may be blank. | ||
| products | string | The products offered by the company on the Page being queried. This field may be blank. | ||
| location | string | The location of the Page being queried, including the street, city, state, country and zip (or post code). Some of the fields may be blank. | ||
| parking | string | The type of parking available at the location of the Page being queried. | ||
| public_transit | string | The type of public transportation available near the location of the Page being queried. This field may be blank. | ||
| hours | string | The hours of operation for the Page being queried. | ||
| attire | string | The type of attire recommended by the Page being queried. This field may be blank. | ||
| payment_options | string | The forms of payment accepted by the Page being queried. This field may be blank. | ||
| culinary_team | string | The team of people preparing the food at the restaurant at the Page being queried. This field may be blank. | ||
| general_manager | string | The general manager of the Page being queried. This field may be blank. | ||
| price_range | string | The price range for the products offered by the Page being queried. | ||
| restaurant_services | string | The services offered by the restaurant at the Page being queried. | ||
| restaurant_specialties | string | The house specials offered by the restaurant at the Page being queried. This field may be blank. | ||
| release_date | string | The date the film on the Page being queried was released. This field may be blank. | ||
| genre | string | The genre of music of the band at the Page being queried. This field may be blank. | ||
| starring | string | The actors starring in the film on the Page being queried. This field may be blank. | ||
| screenplay_by | string | The screenwriters for the film on the Page being queried. This field may be blank. | ||
| directed_by | string | The director of the film on the Page being queried. This field may be blank. | ||
| produced_by | string | The producers of the film on the Page being queried. This field may be blank. | ||
| studio | string | The studio releasing the film on the Page being queried. This field may be blank. | ||
| awards | string | The awards received by the film on the Page being queried. This field may be blank. | ||
| plot_outline | string | The plot of the film on the Page being queried. This field may be blank. | ||
| network | string | The network airing the TV show on the Page being queried. This field may be blank. | ||
| season | int | The season of the TV show on the Page being queried. This field may be blank. | ||
| schedule | string | The schedule of the TV show on the Page being queried. This field may be blank. | ||
| written_by | string | The writers of the TV show on the Page being queried. This field may be blank. | ||
| band_members | string | The members of the band on the Page being queried. This field may be blank. | ||
| hometown | string | The home town of the band on the Page being queried. This field may be blank. | ||
| current_location | string | The current location of the band on the Page being queried. This field may be blank. | ||
| record_label | string | The record label for the band on the Page being queried. This field may be blank. | ||
| booking_agent | string | The booking agent for the band on the Page being queried. This field may be blank. | ||
| artists_we_like | string | Other bands and artists that the band on the Page being queried likes. This field may be blank. | ||
| influences | string | The influences of the band on the Page being queried. This field may be blank. | ||
| band_interests | string | Other interests of the band on the Page being queried. This field may be blank. | ||
| bio | string | The artist biography of the band on the Page being queried. This field may be blank. | ||
| affiliation | string | The political affiliation of the person on the Page being queried. This field may be blank. | ||
| birthday | string | The birthday of the person featured on the Page being queried. This field may be blank. | ||
| personal_info | string | Personal information about the artist on the Page being queried. This field may be blank. | ||
| personal_interests | string | Other interests of the artist on the Page being queried. This field may be blank. | ||
| members | string | The members of the cast of the TV show on the Page being queried. This field may be blank. | ||
| built | string | The year the vehicle on the Page being queried was built. This field may be blank. | ||
| features | string | The features of the vehicle on the Page being queried. This field may be blank. | ||
| mpg | string | The fuel economy (in miles per gallon) of the car featured on the Page being queried. This field may be blank. | ||
| general_info | string | General information about the entity on the Page being queried. This field may be blank. |
