# Apple podcast categories: feeds in the Podcast Index against shows on Apple's top-100 charts

Four files behind the report "True crime is 0.5% of active podcasts and 7% of
Apple's charts. Religion is 14% and 1.5%".

## category_shares.csv
One row per Apple top-level category, plus a "(none)" row for feeds with no
first category and an "(other)" row for feeds whose first category is a
subcategory rather than a top-level one. The first block measures the feed's
first category (category1); share_all_pct sums to 100% across all rows.
Columns: category, feeds_all, share_all_pct (of 4,711,475 feeds), feeds_active90,
share_active_pct (of 437,693 feeds active in the 90 days to 2026-08-16),
chart_shows (of 1,387 joined chart shows), chart_share_pct,
ratio_chart_over_active, then the same six measured over category1 to
category10 (any_*), where a feed counts once per top-level category it lists
and the shares are shares of all such assignments.

## chart_shows_by_category.csv
The 1,387 chart shows that joined to the dump, one row each.
Columns: itunesId, show, artistName (both as Apple's chart lists them),
category1 (from the dump), storefronts_count, storefronts, best_rank.

## true_crime_chart_shows.csv
Every chart slot whose show carries True Crime as its first category in the
dump. One row per slot, so a show charting in five storefronts has five rows.
Columns: cc, rank, show, artistName, host (the feed's hosting domain,
normalised as in tools/count.py).

## category_by_storefront.csv
Storefront by category. Columns: storefront, category, chart_shows,
share_of_storefront_joined_pct, storefront_joined_shows.

## Sources
- Podcast Index feed dump, 4,711,475 feeds, dated 2026-08-16.
- Apple Podcasts top-100 charts for 18 storefronts, 1,800 slots, fetched
  2026-09-06 from rss.applemarketingtools.com.

Cells under 5 print "<5" and their shares print "n/a".

Data: CC BY 4.0, Podcastquery, September 2026