Facebook Public Data data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: PAGE

about
Display name About
Description Information about the page
Field type dimension
Data type string.text.value
awards
Display name Awards
Description The awards information of the film. Applicable to films pages
Field type dimension
Data type string.text.value
can_post
Display name Users can post
Description Whether the current session user can post on the page
Field type dimension
Data type bool
category
Display name Category
Description The page's category. e.g. Product/Service, Computers/Technology
Field type dimension
Data type string.text.value
checkins
Display name Checkins
Description Number of checkins at a place represented by a page. Please note that this field will be removed on 2024-09-16
Field type metric
Data type int.number.value
company_overview
Display name Company overview
Description The company overview. Applicable to company pages
Field type dimension
Data type string.text.value
cover_source
Display name Cover link
Description Direct URL for the page's cover photo image
Field type dimension
Data type string.text.url
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
description
Display name Description
Description The description of the page
Field type dimension
Data type string.text.value
fan_count
Display name Likes
Description Number of users who like the page. For global pages this is the count for all pages across the brand
Field type metric
Data type int.number.value
founded
Display name Year founded
Description When the company was founded. Applicable to pages in the company category
Field type dimension
Data type string.time.year
general_info
Display name General info
Description General information provided by the page
Field type dimension
Data type string.text.value
has_added_app
Display name Has added app
Description Indicates whether the page has added the app making the query in a page tab
Field type dimension
Data type bool
is_community_page
Display name Is community page
Description Indicates whether the page is a community page
Field type dimension
Data type bool
is_published
Display name Is the page published
Description Indicates whether the page is published and visible to non-admins
Field type dimension
Data type bool
is_verified
Display name Is the page verified
Description Indicates whether the page is verified
Field type dimension
Data type bool
link
Display name Link to page
Description The page's Facebook URL
Field type dimension
Data type string.text.url
location_city
Display name City
Description City
Field type dimension
Data type string.geo.city
location_city_id
Display name City ID
Description City ID
Field type dimension
Data type int.number.value
location_country
Display name Country
Description Country
Field type dimension
Data type string.geo.country
location_country_code
Display name Country code
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
location_latitude
Display name Latitude
Description Latitude
Field type dimension
Data type string.geo.latitude
location_located_in
Display name Located in (ID)
Description The parent location if the location is located within another location
Field type dimension
Data type int.number.value
location_longitude
Display name Longitude
Description Longitude
Field type dimension
Data type string.geo.longitude
location_name
Display name Location
Description Location name
Field type dimension
Data type string.text.value
location_region
Display name Region
Description Region
Field type dimension
Data type string.geo.region
location_region_id
Display name Region ID
Description Region ID. Specifies a geographic region, such as California
Field type dimension
Data type int.number.value
location_state
Display name State
Description State
Field type dimension
Data type string.geo.metro
location_street
Display name Street address
Description Street address
Field type dimension
Data type string.text.value
location_zip
Display name Zip code
Description Zip code
Field type dimension
Data type string.geo.zip
mission
Display name Mission
Description Page mission
Field type dimension
Data type string.text.value
name
Display name Name (Profile)
Description Name of the page
Field type dimension
Data type string.text.value
name_with_location_descriptor
Display name Name with location descriptor
Description The name of the page with its location and/or global brand descriptor. Only visible to a page admin
Field type dimension
Data type string.text.value
page_id
Display name Page ID
Description Page ID
Field type dimension
Data type int.number.value
phone
Display name Phone
Description Phone number
Field type dimension
Data type string.text.value
products
Display name Products
Description Product list of the company. Applicable to company pages
Field type dimension
Data type string.text.value
talking_about_count
Display name Talking about
Description Number of people talking about the page
Field type metric
Data type int.number.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
username
Display name Username
Description The alias of the page. e.g. for www.facebook.com/platform the username is 'platform'
Field type dimension
Data type string.text.value
website
Display name Website
Description The URL of the page's website
Field type dimension
Data type string.text.value

Table: POST

application_category
Display name Application category
Description Category of the app the post was published by
Field type dimension
Data type string.text.value
application_link
Display name Application link
Description Link to the app the post was published by
Field type dimension
Data type string.text.url
application_name
Display name Application used to post
Description The app name the post was published by
Field type dimension
Data type string.text.value
caption
Display name Caption
Description Link caption in post that appears below name
Field type dimension
Data type string.text.value
comments_count
Display name Comments
Description Total count of comments on the post
Field type metric
Data type int.number.value
created_date
Display name Created date
Description The date the post was initially published
Field type dimension
Data type string.time.date
created_time
Display name Created time
Description The time the post was initially published. For a post about a life event, it will be the date & time of the life event
Field type dimension
Data type string.time.datetime
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
description
Display name Description
Description The description of the page
Field type dimension
Data type string.text.value
from_id
Display name From user ID
Description The ID of the user account for the post
Field type dimension
Data type int.number.value
from_name
Display name From user
Description The full name of the user account for the post
Field type dimension
Data type string.text.value
likes_count
Display name Likes
Description Total count post likes
Field type metric
Data type int.number.value
link
Display name Link to page
Description The page's Facebook URL
Field type dimension
Data type string.text.url
message
Display name Message
Description The status message in the post
Field type dimension
Data type string.text.value
name
Display name Name (Profile)
Description Name of the page
Field type dimension
Data type string.text.value
permalink_url
Display name Link to post
Description URL to the permalink page of the post
Field type dimension
Data type string.text.url
picture
Display name Picture URL
Description The picture scraped from any link included with the post
Field type dimension
Data type string.text.url
place
Display name Place
Description Any location information attached to the post
Field type dimension
Data type string.text.value
post_id
Display name Post ID
Description Post ID
Field type dimension
Data type string.text.value
posts
Display name Posts
Description Posts
Field type metric
Data type int.number.value
reactions_count
Display name Reactions
Description Total count of reactions to the post
Field type metric
Data type int.number.value
shares_count
Display name Post shares
Description Count of post shares
Field type metric
Data type int.number.value
source
Display name Content source
Description URL to any Flash movie or video file attached to the post
Field type dimension
Data type string.text.value
status_type
Display name Post type
Description Post type
Field type dimension
Data type string.text.value
story
Display name Story
Description Text from stories not intentionally generated by users, e.g. when someone else posts on the person's wall
Field type dimension
Data type string.text.value
story_tags
Display name Story tags
Description List of profiles tagged in the message/story text
Field type dimension
Data type string.text.value
type
Display name Content type
Description Indicates the object type of the post
Field type dimension
Data type string.text.value
updated_date
Display name Updated date
Description Date when the post was created, edited, or commented upon
Field type dimension
Data type string.time.date
updated_time
Display name Updated time
Description Time when the post was created, edited, or commented upon
Field type dimension
Data type string.time.datetime

Table: URL_SHARES

comment_count
Display name Comments
Description URL comment counts
Field type metric
Data type int.number.value
comment_plugin_count
Display name Comment plugins
Description URL comment plugins counts
Field type metric
Data type int.number.value
og_object_description
Display name Description
Description URL description
Field type dimension
Data type string.text.value
og_object_id
Display name URL ID
Description URL ID
Field type dimension
Data type int.number.value
og_object_title
Display name Title
Description URL title
Field type dimension
Data type string.text.value
og_object_type
Display name Type
Description URL type
Field type dimension
Data type string.text.value
og_object_updated_time
Display name Updated time
Description URL updated time
Field type dimension
Data type string.time.datetime
reaction_count
Display name Reactions
Description URL reaction counts
Field type metric
Data type int.number.value
share_count
Display name Shares
Description URL share counts
Field type metric
Data type int.number.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
url
Display name URL
Description URL
Field type dimension
Data type string.text.url