Instagram Public Data data warehouse table groups

  • Updated on Jan 8, 2026
  • Published on Aug 5, 2025
Prev Next

Table: PROFILES

biography
Display name Biography
Description Profile's biography
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
followers
Display name Profile followers
Description Total number of unique accounts following this profile
Field type metric
Data type int.number.value
follows
Display name Profile follows
Description Total number of accounts this profile is following
Field type metric
Data type int.number.value
ig_id
Display name Instagram ID
Description Profile's Instagram ID
Field type dimension
Data type string.text.value
name
Display name Name
Description Profile's name
Field type dimension
Data type string.text.value
profile_picture_url
Display name Profile picture URL
Description URL to profile picture
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
total_post_count
Display name Profile post count
Description Total number of posts for this profile
Field type metric
Data type int.number.value
username
Display name Username
Description Profile's username
Field type dimension
Data type string.text.value
website
Display name Website
Description Profile's website
Field type dimension
Data type string.text.url

Table: POSTS

comments_per_post
Display name Comments per post
Description Count of comments per post
Field type metric
Data type float.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
likes_per_post
Display name Likes per post
Description Count of likes per post
Field type metric
Data type float.number.value
post_caption
Display name Post caption
Description Caption of the post
Field type dimension
Data type string.text.value
post_comments
Display name Comments
Description Total number of comments on the post, including replies
Field type metric
Data type int.number.value
post_id
Display name Post ID
Description Graph ID of the post
Field type dimension
Data type string.text.value
post_likes
Display name Likes
Description Total number of likes on the post, including replies
Field type metric
Data type int.number.value
post_media_url
Display name Post media URL
Description URL to the post's media object
Field type dimension
Data type string.text.url
post_timestamp
Display name Post created
Description Date and time post was added
Field type dimension
Data type string.time.datetime
post_type
Display name Post type
Description Type of post. PHOTO, VIDEO, etc
Field type dimension
Data type string.text.value
posts
Display name Posts
Description Posts
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

Table: HASHTAGS

caption_length
Display name Caption length
Description The length of the post caption
Field type dimension
Data type int.number.value
caption_length_no_hashtags
Display name Caption length (not incl. hashtags)
Description The length of the post caption without the hashtags
Field type dimension
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
found_hashtags
Display name Hashtags
Description Hashtags included the post caption
Field type dimension
Data type string.text.value
hashtag_count
Display name Number of hashtags
Description The total number of hashtags found in the post caption
Field type dimension
Data type int.number.value
hashtag_name
Display name Matching hashtags
Description Hashtags from the post caption that match the hashtags supplied for the search
Field type dimension
Data type string.text.value
post_caption
Display name Post caption
Description Caption of the post
Field type dimension
Data type string.text.value
post_comments
Display name Comments
Description Total number of comments on the post, including replies
Field type metric
Data type int.number.value
post_id
Display name Post ID
Description Graph ID of the post
Field type dimension
Data type string.text.value
post_likes
Display name Likes
Description Total number of likes on the post, including replies
Field type metric
Data type int.number.value
post_media_url
Display name Post media URL
Description URL to the post's media object
Field type dimension
Data type string.text.url
post_timestamp
Display name Post created
Description Date and time post was added
Field type dimension
Data type string.time.datetime
post_type
Display name Post type
Description Type of post. PHOTO, VIDEO, etc
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