# Coloring book trends aggregate tables, October 23, 2026 capture

Version 1.0, generated November 12, 2026. Published by ColorBliss with the report [Coloring book trends: October 2026 Amazon report](https://colorbliss.com/research/coloring-book-trends/2026-10-23) (published October 23, 2026).

These tables support ColorBliss's first coloring-book trends report: a single capture of 24 Amazon US lists on October 23, 2026. It is not a comparison edition.

## Files

| File | Contents | Rows |
| --- | --- | --- |
| [lists.csv](lists.csv) | One row per Amazon list (24 lists): positions, distinct listings, formats, displayed prices and the title rules used in the October 23 report. | 24 |
| [summary.csv](summary.csv) | Edition-level figures behind the October 23 report: Christmas matches, cozy wording by category, distinct-product price medians, the $9.99 price point and spiral-bound formats. | 39 |

Files are UTF-8 CSV with a header row. Blank cells mean not applicable or not available, never zero.

## Dates

- Capture date: October 23, 2026 (America/New_York).
- Comparison: none; this is a single capture.
- Report published: October 23, 2026. Cite the publication date; use capture dates when describing what the lists showed.

## What is counted

- A **chart position** (`chart_position`) is one rank on one list on one capture date. A listing on three lists counts as three positions.
- A **distinct listing** (`distinct_listing`) is one Amazon product ID (ASIN), counted once within the stated scope.
- A **distinct credit name** (`distinct_credit_name`) counts displayed author or creator names without disclosing them. These standalone totals have no denominator or share.
- Other counts in summary.csv have their denominator in the same counting unit. Shares are count / denominator.

## Sampling

- The capture holds the top 30 positions on 24 Amazon.com lists: Best Sellers and Hot New Releases for 12 categories, 720 positions in total, covering 546 distinct listings.
- Lists were captured on October 23, 2026 (America/New_York). captured_at_utc gives the exact time of each list.
- The list set and top-30 depth match the later weekly editions, but the October 23 report used different title rules and counting units (below). Do not compare its counts directly with the October 29 or November 6 tables.

## Methodology

- Christmas and Halloween/spooky counts use case-insensitive substring rules: a title matches when it contains "christmas", or "halloween" or "spooky", anywhere. The weekly editions use whole-word rules instead, so the October 29 dataset reports 41 Christmas Hot New Releases positions for this same capture where this one reports 42.
- Cozy counts use whole-word cozy, cosy or hygge. The adults-and-kids rule needs a whole word from each of {adult, adults, grown-up, grown-ups} and {kid, kids, teen, teens, children, girls, boys}.
- Many findings in this report count distinct listings, not positions. The price medians, the $9.99 count and the spiral-bound counts deduplicate ASINs within the stated scope and take one displayed price per listing. Cozy category counts deduplicate ASINs across a category's Best Sellers and Hot New Releases lists. The counting_unit column says which unit each row uses.
- median_displayed_price_usd in lists.csv is a position-level median for that one list, which differs from the distinct-listing medians in summary.csv where a listing repeats.

## Data dictionary

### lists.csv

| Field | Definition |
| --- | --- |
| `capture_date` | Capture date of this row (YYYY-MM-DD, America/New_York). |
| `source_id` | ColorBliss identifier for the Amazon US list: amazon-com-<category node ID>-<list type>. |
| `category` | Amazon category name shown on the list. |
| `list_type` | best-sellers (Amazon Best Sellers) or hot-new-releases (Amazon Hot New Releases). |
| `captured_at_utc` | When ColorBliss captured this list, as an ISO 8601 UTC timestamp. It can fall on the next UTC day after capture_date. |
| `positions_sampled` | Chart positions recorded on this list (the top 30). |
| `distinct_listings` | Distinct Amazon product listings (ASINs) among those positions. |
| `coloring_labelled_positions` | Positions whose listing ColorBliss labels a coloring book because its title contains "color" or "colour". A title rule, not a review of the interior. |
| `paperback_positions` | Positions whose displayed format is Paperback. |
| `spiral_bound_positions` | Positions whose displayed format is Spiral-bound. |
| `priced_positions` | Positions with a displayed price. |
| `unpriced_positions` | Positions with no displayed price. Missing prices are never imputed or treated as zero. |
| `median_displayed_price_usd` | Median displayed price across this list's priced positions, in US dollars. Capture-time displayed price, not a transaction price. |
| `christmas_positions` | Positions whose displayed title contains "christmas" anywhere (case-insensitive substring rule used by the October 23 report). |
| `halloween_or_spooky_positions` | Positions whose displayed title contains "halloween" or "spooky" anywhere (case-insensitive substring rule). |
| `cozy_cosy_hygge_positions` | Positions whose displayed title contains the whole word cozy, cosy or hygge (case-insensitive). |
| `adults_and_kids_positions` | Positions whose title has a whole word from {adult, adults, grown-up, grown-ups} and one from {kid, kids, teen, teens, children, girls, boys}. |

### summary.csv

| Field | Definition |
| --- | --- |
| `metric` | Machine-readable metric name. The README lists every metric. |
| `capture_date` | Capture date the value describes (YYYY-MM-DD, America/New_York). |
| `comparison_date` | Earlier capture date for change metrics such as same-list turnover. Blank otherwise. |
| `scope` | Which lists, or which subset of positions, the value covers. |
| `counting_unit` | chart_position counts every rank on every list, so a listing on three lists counts three times; distinct_listing counts each Amazon listing (ASIN) once within the scope; distinct_credit_name counts displayed credit names without disclosing them. |
| `group` | Title wording group, price band, list-count bucket, list type or other subgroup. Blank when the metric has no subgroup. |
| `rule` | Matching or inclusion rule for the group, when one applies. |
| `count` | Number of positions, listings or displayed credit names in the group. Blank for medians. |
| `denominator` | Base the count or median is drawn from, in the same counting unit. Blank for standalone credit-name totals. |
| `share_pct` | count / denominator × 100, rounded to one decimal place. Blank when there is no count or denominator. |
| `value` | Value for non-count metrics (medians), unrounded. Reports may round to the cent. |
| `value_unit` | Unit of value, for example usd. Blank when value is blank. |

### summary.csv metrics

| Metric | Meaning |
| --- | --- |
| `positions_sampled` | Chart positions recorded across the 24 lists. |
| `distinct_listings` | Distinct ASINs across the 24 lists. |
| `priced_positions` | Positions with a displayed price. |
| `christmas_title_matches` | Christmas substring matches by list type, as positions and as distinct listings. |
| `christmas_matches_by_category` | Split of Christmas-matching positions between Religious & Inspirational and the other 11 categories. |
| `cozy_title_matches` | Cozy wording matches overall and by category (distinct listings across both list types). |
| `credit_names_on_cozy_listings` | How many distinct displayed author or creator names appear on cozy-matching listings. The names are withheld. |
| `median_displayed_price` | Distinct-listing median of displayed prices, by list and format. |
| `listings_displaying_price` | Distinct priced listings displaying $9.99 in at least one observation. |
| `unpriced_listings` | Distinct listings with no displayed price anywhere. |
| `spiral_bound_listings` | Distinct listings displayed as Spiral-bound, by list type. |

## Where each report finding comes from

| Finding | Source in this dataset |
| --- | --- |
| Cozy wording by category (Children's 15 of 56 listings; Adult Fashion 24 of 56) | summary.csv, metric cozy_title_matches. Per-credit splits are withheld because they identify creators. |
| Christmas on 42 of 360 Hot New Releases positions and 16 of 360 Best Sellers positions; half of the new-release matches from Religious & Inspirational | summary.csv, metrics christmas_title_matches and christmas_matches_by_category; per-list counts in lists.csv christmas_positions. |
| Halloween or spooky on adult Best Sellers (6 of 30) and Hot New Releases (8 of 30) | lists.csv, halloween_or_spooky_positions. |
| Children's Best Sellers titles saying adults and kids | lists.csv, adults_and_kids_positions. |
| Median prices for children's, grown-ups' and Science & Anatomy Best Sellers | summary.csv, metric median_displayed_price (distinct listings). |
| $9.99 on 191 of 545 priced listings | summary.csv, metric listings_displaying_price. |
| Spiral-bound listings by list type | summary.csv, metric spiral_bound_listings. |
| Named example books, covers and names to watch | Withheld: these are row-level listings. |

## Limitations

- Amazon list positions are not sales, revenue, demand or market share. A position says a listing appeared at that rank on that list when the page was captured.
- The 12 categories were selected by ColorBliss and include adjacent activity books, sticker books and study guides, not only coloring books. They are not a random or complete sample of Amazon.
- Title wording rules describe the words in displayed titles, not the contents, covers or quality of a book. Wording groups overlap, so a title can count in several groups.
- Coloring-book labels come from a title rule (the title contains "color" or "colour"), not a manual review.
- Displayed prices are what the list page showed at capture time. They can differ by format or seller, and missing prices are excluded, never imputed.
- A listing is an Amazon product ID (ASIN). Different editions or formats of one book can have separate ASINs.
- This is one capture. It cannot show change over time.

## Withheld data

Row-level Amazon observations (ASINs, titles, author or creator credits, ratings, review counts, product URLs and images) are withheld because permission to redistribute that third-party data has not been verified. Only ColorBliss-derived counts, denominators, shares and medians are published. This is a conservative restriction, not proof of legal permission to redistribute the aggregates. The report itself names some example books; those names and links are not repeated here.

## Version

- 1.0 (2026-11-12): first public release of the aggregate tables. Regenerate with `npm run research:datasets` in `marketing/`. A change to any published value will get a new version number and a note here.

## Suggested citation

ColorBliss. (2026, October 23). Coloring book trends aggregate tables, October 23, 2026 capture (Version 1.0) [Data set]. From Coloring book trends: October 2026 Amazon report. https://colorbliss.com/research/coloring-book-trends/2026-10-23/data/README.md

## Reuse

ColorBliss requests attribution using the citation above when quoting or charting these tables. No third-party license or legal clearance is asserted: withholding row-level observations is a conservative publication restriction, not verification of redistribution permission for the aggregates. Any reuse remains subject to applicable rights and terms. Amazon, Best Sellers and Hot New Releases are Amazon's names; the underlying list pages are Amazon's content and are not licensed here. Positions and prices describe saved captures, not current Amazon pages.