Podcasts Chart Snapshots

Name: Podcasts Chart Snapshots
Creator: Apple
License: Apple Services Performance Partners Search API legal terms

One row per daily Apple Podcasts chart position by snapshot date, storefront, feed type, and rank. The table covers top podcast charts across 184 Apple storefront codes in the current published snapshot. Rows are chart appearances, not a complete podcast catalog; the same show can appear in multiple storefronts and snapshots.

apple-podcasts·17 columns·57.1 MB·Apple Services Performance Partners Search API legal terms·updated 18h ago

Source: Apple · connector code

Schema

snapshot_date	DATE
feed_updated	VARCHAR
storefront	VARCHAR
media	VARCHAR
feed_type	VARCHAR
rank	BIGINT
entity_id	BIGINT
name	VARCHAR
artist_name	VARCHAR
artist_id	JSON
artist_url	JSON
kind	VARCHAR
release_date	JSON
content_advisory_rating	VARCHAR
genre_names	VARCHAR[]
artwork_url	VARCHAR
url	VARCHAR

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"apple-podcasts\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.