YouTube Public Data data warehouse table groups

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

Table: CHANNEL

channels__banner_image_location
Display name Banner image location
Description This property specifies the location of the banner image that YouTube uses to generate the various banner image sizes for a channel
Field type dimension
Data type string.text.url
channels__channel_id
Display name Channel ID
Description The ID of the channel
Field type dimension
Data type string.text.value
channels__channel_name
Display name Channel name
Description The name of the channel
Field type dimension
Data type string.text.value
channels__content_owner_id
Display name Content owner ID
Description The ID of the content owner linked to the channel
Field type dimension
Data type string.text.value
channels__content_owner_link_date
Display name Content owner link date
Description The date of when the channel was linked to the content owner
Field type dimension
Data type string.time.date
channels__content_owner_link_datetime
Display name Content owner link datetime
Description The date and time of when the channel was linked to the content owner
Field type dimension
Data type string.time.datetime
channels__country
Display name Country
Description The country with which the channel is associated
Field type dimension
Data type string.geo.country.twolettercode
channels__custom_url
Display name Custom URL
Description The custom URL of the channel
Field type dimension
Data type string.text.url
channels__default_language
Display name Default language
Description The language of the text in the channel's title & description
Field type dimension
Data type string.text.value
channels__description
Display name Description
Description The description of the channel
Field type dimension
Data type string.text.value
channels__hidden_subscribers
Display name Hidden subscribers
Description Indicates whether the channel's subscriber count is publicly visible
Field type dimension
Data type bool
channels__is_linked
Display name Is linked
Description Indicates whether the channel data identifies a user that is already linked to either a YouTube username or a Google+ account
Field type dimension
Data type bool
channels__keywords
Display name Keywords
Description The keywords associated with your channel
Field type dimension
Data type string.text.value
channels__localized_description
Display name Localized description
Description The localized description of the channel
Field type dimension
Data type string.text.value
channels__localized_title
Display name Localized title
Description The localized title of the channel
Field type dimension
Data type string.text.value
channels__made_for_kids
Display name Made for kids
Description This value indicates whether the channel is designated as child-directed, and it contains the current "made for kids" status of the channel
Field type dimension
Data type string.text.value
channels__moderate_comments
Display name Moderate comments
Description This setting determines whether user-submitted comments left on the channel page need to be approved by the channel owner to be publicly visible
Field type dimension
Data type bool
channels__privacy_status
Display name Privacy status
Description The privacy status of the channel
Field type dimension
Data type string.text.value
channels__publish_date
Display name Publish date
Description The date that the channel was created
Field type dimension
Data type string.time.date
channels__publish_datetime
Display name Publish datetime
Description The date and time that the channel was created
Field type dimension
Data type string.time.datetime
channels__subscribers
Display name Subscribers
Description The number of subscribers that the channel has. This value is rounded down to three significant figures
Field type metric
Data type int.number.value
channels__thumbnail_url
Display name Thumbnail URL (default)
Description Link to a default thumbnail image of the video
Field type dimension
Data type string.text.url
channels__thumbnail_url_high
Display name Thumbnail URL (high)
Description Link to a high resolution version of the video's image
Field type dimension
Data type string.text.url
channels__thumbnail_url_medium
Display name Thumbnail URL (medium)
Description Link to a higher resolution version of the video's image
Field type dimension
Data type string.text.url
channels__topic_categories
Display name Topic categories
Description A list of Wikipedia URLs that describe the channel's content
Field type dimension
Data type string.text.value
channels__upload_playlist
Display name Upload playlist ID
Description The ID of the playlist that contains the channel's uploaded videos
Field type dimension
Data type string.text.value
channels__video_count
Display name Video count
Description The number of public videos uploaded to the channel. Note that the value reflects the count of the channel's public videos only, even to owners. This behavior is consistent with counts shown on the YouTube website
Field type metric
Data type int.number.value
channels__views
Display name Views
Description The number of times the channel has been viewed
Field type metric
Data type int.number.value
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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: CHANNEL_VIDEO

channel__channel_description
Display name Channel description
Description The description of the YouTube channel
Field type dimension
Data type string.text.value
channel__channel_id
Display name Channel ID
Description The ID of the YouTube channel
Field type dimension
Data type string.text.value
channel__channel_name
Display name Channel name
Description The name of the YouTube channel
Field type dimension
Data type string.text.value
channel__videos__details__caption
Display name Caption
Description Indicates whether captions are available for the video
Field type dimension
Data type bool
channel__videos__details__category_id
Display name Category ID
Description The video category associated with the video
Field type dimension
Data type string.text.value
channel__videos__details__cbfc_rating
Display name CBFC rating
Description The video's Central Board of Film Certification (CBFC - India) rating
Field type dimension
Data type string.text.value
channel__videos__details__comments
Display name Comments
Description The number of comments for the video
Field type metric
Data type int.number.value
channel__videos__details__default_language
Display name Default language
Description The language of the text in the video's resources
Field type dimension
Data type string.text.value
channel__videos__details__definition
Display name Definition
Description Indicates whether the video is available in HD or in standard definition
Field type dimension
Data type string.text.value
channel__videos__details__description
Display name Description
Description The description of the video
Field type dimension
Data type string.text.value
channel__videos__details__dimension
Display name Dimension
Description Indicates whether the video is available in 3D or in 2D
Field type dimension
Data type string.text.value
channel__videos__details__duration
Display name Duration
Description The length of the video represented in an ISO 8601 format; PT#H#M#S
Field type dimension
Data type string.text.value
channel__videos__details__licensed_content
Display name Licensed content
Description Indicates whether the video represents licensed content, which means that the content was uploaded to a channel linked to a YouTube content partner and then claimed by that partner
Field type dimension
Data type bool
channel__videos__details__likes
Display name Likes
Description The number of users who have indicated that they liked the video
Field type metric
Data type int.number.value
channel__videos__details__live_broadcast_content
Display name Live broadcast content
Description Indicates if the video is an upcoming or active live broadcast or neither
Field type dimension
Data type string.text.value
channel__videos__details__livestreaming_end_date
Display name Livestreaming end date
Description The date that the broadcast actually ended
Field type dimension
Data type string.time.date
channel__videos__details__livestreaming_end_datetime
Display name Livestreaming end datetime
Description The date & time that the broadcast actually ended
Field type dimension
Data type string.time.datetime
channel__videos__details__livestreaming_start_date
Display name Livestreaming start date
Description The date that the broadcast actually started
Field type dimension
Data type string.time.date
channel__videos__details__livestreaming_start_datetime
Display name Livestreaming start datetime
Description The date & time that the broadcast actually started
Field type dimension
Data type string.time.datetime
channel__videos__details__localized_description
Display name Localized description
Description The localized description of the video
Field type dimension
Data type string.text.value
channel__videos__details__localized_title
Display name Localized title
Description The localized title of the video
Field type dimension
Data type string.text.value
channel__videos__details__made_for_kids
Display name Made for kids
Description This value indicates whether the video is designated as child-directed, and it contains the current "made for kids" status of the video
Field type dimension
Data type bool
channel__videos__details__projection
Display name Projection
Description Specifies the projection format of the video
Field type dimension
Data type string.text.value
channel__videos__details__region_restriction_allowed
Display name Region restriction allowed
Description A list of region codes that identify countries where the video is viewable
Field type dimension
Data type string.text.value
channel__videos__details__region_restriction_blocked
Display name Region restriction blocked
Description A list of region codes that identify countries where the video is blocked
Field type dimension
Data type string.text.value
channel__videos__details__self_declared_made_for_kids
Display name Self declared made for kids
Description This value indicates whether the video is designated as child-directed, and it contains the current "made for kids" status of the video
Field type dimension
Data type bool
channel__videos__details__tag_suggestions
Display name Tag suggestions
Description A list of keyword tags that could be added to the video's metadata to increase the likelihood that users will locate your video when searching or browsing on YouTube
Field type dimension
Data type string.text.value
channel__videos__details__tags
Display name Tags
Description A list of keyword tags associated with the video
Field type dimension
Data type string.text.value
channel__videos__details__thumbnail_url
Display name Thumbnail URL (default)
Description Link to a default thumbnail image of the video
Field type dimension
Data type string.text.url
channel__videos__details__thumbnail_url_high
Display name Thumbnail URL (high)
Description Link to a high resolution version of the video's image
Field type dimension
Data type string.text.url
channel__videos__details__thumbnail_url_medium
Display name Thumbnail URL (medium)
Description Link to a higher resolution version of the video's image
Field type dimension
Data type string.text.url
channel__videos__details__topic_categories
Display name Topic categories
Description A list of Wikipedia URLs that provide a high-level description of the video's content
Field type dimension
Data type string.text.value
channel__videos__details__video_title
Display name Video title
Description The title of the video
Field type dimension
Data type string.text.value
channel__videos__details__views
Display name Views
Description The number of times the video has been viewed
Field type metric
Data type int.number.value
channel__videos__details__yt_rating
Display name YT rating
Description A rating that YouTube uses to identify age-restricted content
Field type dimension
Data type string.text.value
channel__videos__publish_date
Display name Publish date
Description The date that the video was published
Field type dimension
Data type string.time.date
channel__videos__publish_datetime
Display name Publish datetime
Description The date and time that the video was published
Field type dimension
Data type string.time.datetime
channel__videos__video_id
Display name Video ID
Description The ID of the video
Field type dimension
Data type string.text.value
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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: VIDEO

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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
video__caption
Display name Caption
Description Indicates whether captions are available for the video
Field type dimension
Data type bool
video__category_id
Display name Category ID
Description The video category associated with the video
Field type dimension
Data type string.text.value
video__cbfc_rating
Display name CBFC rating
Description The video's Central Board of Film Certification (CBFC - India) rating
Field type dimension
Data type string.text.value
video__comments
Display name Comments
Description The number of comments for the video
Field type metric
Data type int.number.value
video__default_language
Display name Default language
Description The language of the text in the video's resources
Field type dimension
Data type string.text.value
video__definition
Display name Definition
Description Indicates whether the video is available in HD or in standard definition
Field type dimension
Data type string.text.value
video__description
Display name Description
Description The description of the video
Field type dimension
Data type string.text.value
video__dimension
Display name Dimension
Description Indicates whether the video is available in 3D or in 2D
Field type dimension
Data type string.text.value
video__duration
Display name Duration
Description The length of the video represented in an ISO 8601 format; PT#H#M#S
Field type dimension
Data type string.text.value
video__licensed_content
Display name Licensed content
Description Indicates whether the video represents licensed content, which means that the content was uploaded to a channel linked to a YouTube content partner and then claimed by that partner
Field type dimension
Data type bool
video__likes
Display name Likes
Description The number of users who have indicated that they liked the video
Field type metric
Data type int.number.value
video__live_broadcast_content
Display name Live broadcast content
Description Indicates if the video is an upcoming or active live broadcast or neither
Field type dimension
Data type string.text.value
video__livestreaming_end_date
Display name Livestreaming end date
Description The date that the broadcast actually ended
Field type dimension
Data type string.time.date
video__livestreaming_end_datetime
Display name Livestreaming end datetime
Description The date & time that the broadcast actually ended
Field type dimension
Data type string.time.datetime
video__livestreaming_start_date
Display name Livestreaming start date
Description The date that the broadcast actually started
Field type dimension
Data type string.time.date
video__livestreaming_start_datetime
Display name Livestreaming start datetime
Description The date & time that the broadcast actually started
Field type dimension
Data type string.time.datetime
video__localized_description
Display name Localized description
Description The localized description of the video
Field type dimension
Data type string.text.value
video__localized_title
Display name Localized title
Description The localized title of the video
Field type dimension
Data type string.text.value
video__made_for_kids
Display name Made for kids
Description This value indicates whether the video is designated as child-directed, and it contains the current "made for kids" status of the video
Field type dimension
Data type bool
video__projection
Display name Projection
Description Specifies the projection format of the video
Field type dimension
Data type string.text.value
video__publish_date
Display name Publish date
Description The date that the video was published
Field type dimension
Data type string.time.date
video__publish_datetime
Display name Publish datetime
Description The date and time that the video was published
Field type dimension
Data type string.time.datetime
video__region_restriction_allowed
Display name Region restriction allowed
Description A list of region codes that identify countries where the video is viewable
Field type dimension
Data type string.text.value
video__region_restriction_blocked
Display name Region restriction blocked
Description A list of region codes that identify countries where the video is blocked
Field type dimension
Data type string.text.value
video__self_declared_made_for_kids
Display name Self declared made for kids
Description This value indicates whether the video is designated as child-directed, and it contains the current "made for kids" status of the video
Field type dimension
Data type bool
video__tag_suggestions
Display name Tag suggestions
Description A list of keyword tags that could be added to the video's metadata to increase the likelihood that users will locate your video when searching or browsing on YouTube
Field type dimension
Data type string.text.value
video__tags
Display name Tags
Description A list of keyword tags associated with the video
Field type dimension
Data type string.text.value
video__thumbnail_url
Display name Thumbnail URL (default)
Description Link to a default thumbnail image of the video
Field type dimension
Data type string.text.url
video__thumbnail_url_high
Display name Thumbnail URL (high)
Description Link to a high resolution version of the video's image
Field type dimension
Data type string.text.url
video__thumbnail_url_medium
Display name Thumbnail URL (medium)
Description Link to a higher resolution version of the video's image
Field type dimension
Data type string.text.url
video__topic_categories
Display name Topic categories
Description A list of Wikipedia URLs that provide a high-level description of the video's content
Field type dimension
Data type string.text.value
video__video_id
Display name Video ID
Description The ID of the video
Field type dimension
Data type string.text.value
video__video_title
Display name Video title
Description The title of the video
Field type dimension
Data type string.text.value
video__views
Display name Views
Description The number of times the video has been viewed
Field type metric
Data type int.number.value
video__yt_rating
Display name YT rating
Description A rating that YouTube uses to identify age-restricted content
Field type dimension
Data type string.text.value