Books Chart Snapshots

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

One row per daily Apple Books chart position by snapshot date, storefront, feed type, and rank. The table covers top-free and top-paid book charts across 161 Apple storefront codes in the current published snapshot. Rows are chart appearances, not a complete books catalog; the same book can appear in multiple storefronts, feed types, and snapshots.

apple-books·17 columns·72.0 MB·Apple Services Performance Partners Search API legal terms·updated 1d 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	BIGINT
artist_url	VARCHAR
kind	VARCHAR
release_date	DATE
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-books\" 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.