# Apple top-100 chart slots by publisher and parent company

Four files behind the report "Goalhanger holds 44 Apple chart slots, more than
iHeartMedia and Spotify together".

## slots.csv
One row per chart slot, 1,800 rows: 100 ranks in each of
the 18 storefronts.
Columns: cc (Apple storefront), rank (1 to 100), itunesId, show, artistName
(Apple's publisher string, as the publisher wrote it), parent (the owning
company from the hand map, or the string itself where ownership was not
verified), co_production (1 when the string names more than one producer),
joined_to_dump (1 when the itunesId matches a Podcast Index row), host and
category1 (from the dump, blank where the row did not join).

## parents.csv
One row per parent company, 1,009 rows, summing to
1,800 slots.
Columns: parent, slots, shows (distinct itunesIds), storefronts, us_slots,
gb_slots.

## storefront_publishers.csv
One row per storefront.
Columns: storefront, slots, distinct_strings, distinct_parents, top_parent,
top_parent_slots, parents_for_half (how many parents it takes to cover 50 of
that storefront's 100 slots), joined_to_dump.

## goalhanger_shows.csv
Each Goalhanger show that holds at least one slot, with its rank in every
storefront it charts in.
Columns: itunesId, show, storefronts, storefront_list, best_rank, then
rank_<cc> for each of the 18 storefronts.

## The parent map
data/chart_publisher_parents.csv in the Podcastquery repository holds the hand
map: artistName, parent, evidence_url, co_production, slots. Every publisher
string with 2 or more slots is in it, plus every string naming one of the
companies the report discusses. 111 rows have an empty evidence_url, and 109 of
them keep themselves as their parent. The other two are co-production strings
whose slots went to the first producer named in the string. METHOD.md names
them.

## Sources
- Apple Podcasts top-100 charts for 18 storefronts, fetched 2026-09-06 from
  rss.applemarketingtools.com.
- Podcast Index feed dump dated 2026-08-16, used only for the host and
  category columns and the joined flag.
- Ownership evidence: the URL on each row of the parent map, read 2026-09-15.

In the report tables, a slot count between 1 and 4 prints "<5". Show counts and
storefront counts print exact. The CSVs carry every raw count.

Data: CC BY 4.0, Podcastquery, September 2026