Apple Public Data data warehouse table groups

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

Table: STORE_SEARCH

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
is_ipad_supported
Display name Supports iPad
Description Does the app support iPad
Field type dimension
Data type bool
is_iphone_supported
Display name Supports iPhone
Description Does the app support iPhone
Field type dimension
Data type bool
is_mac_supported
Display name Supports Mac
Description Does the app support Mac computers
Field type dimension
Data type bool
is_watch_supported
Display name Supports Apple Watch
Description Does the app support Apple Watch
Field type dimension
Data type bool
item_advisories
Display name Advisories
Description App advisories
Field type dimension
Data type string.text.value
item_artwork_512_url
Display name Item logo 512px URL
Description URL of the 512 pixel logo of the app
Field type dimension
Data type string.text.url
item_artwork_60_url
Display name Item logo 60px URL
Description URL of the 60 pixel logo of the app
Field type dimension
Data type string.text.url
item_average_rating
Display name Average user rating
Description Average rating given by users for the item
Field type metric
Data type float.number.value
item_average_rating_current_version
Display name Average user rating (current version)
Description Average rating given by users for the current version of the app
Field type metric
Data type float.number.value
item_categories
Display name Categories
Description All categories or genres the item belongs to
Field type dimension
Data type string.text.value
item_collection
Display name Collection
Description Collection the item belongs to (eg. a music album)
Field type dimension
Data type string.text.value
item_collection_price
Display name Collection price
Description Price of the collection that the item belongs to (eg. a music album)
Field type dimension
Data type float.currency.value
item_collection_url
Display name Collection URL
Description URL to view the collection
Field type dimension
Data type string.text.url
item_content_advisory_rating
Display name Age rating
Field type dimension
Data type string.text.value
item_copyright
Display name Copyright
Description Item copyright owner
Field type dimension
Data type string.text.value
item_creator_id
Display name Creator ID
Description ID of the creator of the item
Field type dimension
Data type string.text.value
item_creator_name
Display name Creator name
Description Name of the creator of the item
Field type dimension
Data type string.text.value
item_creator_type
Display name Creator type
Description Type of the creator of the item
Field type dimension
Data type string.text.value
item_currency
Display name Currency
Description Currency of the price
Field type dimension
Data type string.currency.code
item_current_version_release_date
Display name Current version release date
Description Release date of the latest version of the app
Field type dimension
Data type string.time.date
item_description
Display name Description
Description Description of the item
Field type dimension
Data type string.text.value
item_feed_url
Display name Feed URL
Description URL of the RSS feed of the item, if available
Field type dimension
Data type string.text.url
item_file_size_mb
Display name File size (mb)
Description App file size in megabytes
Field type dimension
Data type float.number.value
item_id
Display name Item ID
Description ID of the item
Field type dimension
Data type string.text.value
item_is_game_center_enabled
Display name Is Game Center enabled
Field type dimension
Data type bool
item_language_codes
Display name Language codes
Description Languages supported by the app
Field type dimension
Data type string.text.value
item_minimum_os_version
Display name Minimum OS version
Description Minimum operating system version required by the app
Field type dimension
Data type string.text.value
item_name
Display name Item name
Description Name of the item
Field type dimension
Data type string.text.value
item_preview_url
Display name Preview URL
Description Link to a preview of the item, if available
Field type dimension
Data type string.text.url
item_price
Display name Price
Description Price of the item
Field type dimension
Data type string.text.value
item_primary_category
Display name Primary category
Description Primary category of the item
Field type dimension
Data type string.text.value
item_rating_count
Display name User rating count
Description Number of ratings given by users for the item
Field type metric
Data type int.number.value
item_rating_count_current_version
Display name User rating count (current version)
Description Number of ratings given by users for the current version the app
Field type metric
Data type int.number.value
item_release_date
Display name Release date
Description Item release date
Field type dimension
Data type string.time.date
item_release_notes
Display name Release notes
Description Release notes of the latest version of the app
Field type dimension
Data type string.text.value
item_screenshot_1_url
Display name Screenshot #1 URL
Description URL of the 1st screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_2_url
Display name Screenshot #2 URL
Description URL of the 2nd screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_3_url
Display name Screenshot #3 URL
Description URL of the 3rd screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_4_url
Display name Screenshot #4 URL
Description URL of the 4th screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_supported_devices
Display name Supported devices
Description List of devices that app supports
Field type dimension
Data type string.text.value
item_type
Display name Item type
Description Type of the item
Field type dimension
Data type string.text.value
item_version
Display name Current version
Description Current version of the app
Field type dimension
Data type string.text.value
store_country
Display name Store country
Field type dimension
Data type string.geo.country
store_country_code
Display name Store country code
Field type dimension
Data type string.geo.country.twolettercode
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: APP_REVIEW

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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
item_advisories
Display name Advisories
Description App advisories
Field type dimension
Data type string.text.value
item_artwork_512_url
Display name Item logo 512px URL
Description URL of the 512 pixel logo of the app
Field type dimension
Data type string.text.url
item_artwork_60_url
Display name Item logo 60px URL
Description URL of the 60 pixel logo of the app
Field type dimension
Data type string.text.url
item_categories
Display name Categories
Description All categories or genres the item belongs to
Field type dimension
Data type string.text.value
item_collection
Display name Collection
Description Collection the item belongs to (eg. a music album)
Field type dimension
Data type string.text.value
item_collection_price
Display name Collection price
Description Price of the collection that the item belongs to (eg. a music album)
Field type dimension
Data type float.currency.value
item_collection_url
Display name Collection URL
Description URL to view the collection
Field type dimension
Data type string.text.url
item_content_advisory_rating
Display name Age rating
Field type dimension
Data type string.text.value
item_copyright
Display name Copyright
Description Item copyright owner
Field type dimension
Data type string.text.value
item_creator_id
Display name Creator ID
Description ID of the creator of the item
Field type dimension
Data type string.text.value
item_creator_name
Display name Creator name
Description Name of the creator of the item
Field type dimension
Data type string.text.value
item_creator_type
Display name Creator type
Description Type of the creator of the item
Field type dimension
Data type string.text.value
item_currency
Display name Currency
Description Currency of the price
Field type dimension
Data type string.currency.code
item_description
Display name Description
Description Description of the item
Field type dimension
Data type string.text.value
item_feed_url
Display name Feed URL
Description URL of the RSS feed of the item, if available
Field type dimension
Data type string.text.url
item_id
Display name Item ID
Description ID of the item
Field type dimension
Data type string.text.value
item_language_codes
Display name Language codes
Description Languages supported by the app
Field type dimension
Data type string.text.value
item_name
Display name Item name
Description Name of the item
Field type dimension
Data type string.text.value
item_preview_url
Display name Preview URL
Description Link to a preview of the item, if available
Field type dimension
Data type string.text.url
item_price
Display name Price
Description Price of the item
Field type dimension
Data type string.text.value
item_primary_category
Display name Primary category
Description Primary category of the item
Field type dimension
Data type string.text.value
item_release_date
Display name Release date
Description Item release date
Field type dimension
Data type string.time.date
item_screenshot_1_url
Display name Screenshot #1 URL
Description URL of the 1st screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_2_url
Display name Screenshot #2 URL
Description URL of the 2nd screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_3_url
Display name Screenshot #3 URL
Description URL of the 3rd screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_screenshot_4_url
Display name Screenshot #4 URL
Description URL of the 4th screenshot image of the app in the App Store
Field type dimension
Data type string.text.url
item_type
Display name Item type
Description Type of the item
Field type dimension
Data type string.text.value
review_author_lnik
Display name Review author link
Description Link to the author
Field type dimension
Data type string.text.url
review_author_name
Display name Review author
Description Username of the author
Field type dimension
Data type string.text.value
review_content
Display name Review content
Description Text content of the review
Field type dimension
Data type string.text.value
review_item_version
Display name Reviewed version
Description Version of the item that the review concerns
Field type dimension
Data type string.text.value
review_rating
Display name Rating
Description Star rating given by the user (1-5)
Field type dimension
Data type int.number.value
review_rating_1_star
Display name 1-star ratings
Description Number of 1-star ratings given
Field type metric
Data type float.number.value
review_rating_2_star
Display name 2-star ratings
Description Number of 2-star ratings given
Field type metric
Data type float.number.value
review_rating_3_star
Display name 3-star ratings
Description Number of 3-star ratings given
Field type metric
Data type float.number.value
review_rating_4_star
Display name 4-star ratings
Description Number of 4-star ratings given
Field type metric
Data type float.number.value
review_rating_5_star
Display name 5-star ratings
Description Number of 5-star ratings given
Field type metric
Data type float.number.value
review_rating_count
Display name Ratings
Description Number of ratings given
Field type metric
Data type int.number.value
review_title
Display name Review title
Description Title of the review
Field type dimension
Data type string.text.value
store_country
Display name Store country
Field type dimension
Data type string.geo.country
store_country_code
Display name Store country code
Field type dimension
Data type string.geo.country.twolettercode