Moonboard Exploration

A Look at Different Moonboard Versions

The data provided offers an insight into the different versions of Moonboard. The six versions listed vary in terms of grade range, number of routes, setters, benchmarks, and the hold sets they utilize.

The grade ranges across the different versions show notable variation. For instance, the MoonBoard Masters 2017 25° version has the widest range, spanning from 5+ to 8B+, catering to climbers of all levels. In contrast, the Mini MoonBoard 2020 40° has a narrower range, from 6A+ to 8A+, indicating a more specialized use, possibly appealing to intermediate to advanced climbers.

When it comes to the number of routes and total climbs, the MoonBoard 2016 40° version stands out as the most popular, with an impressive 59,506 routes and over 3 million total climbs. This high level of engagement reflects its widespread use and the active community surrounding this version.

On the other hand, the MoonBoard Masters 2019 25° has the fewest routes and climbs, which may suggest it is either newer or less favored compared to its counterparts. The Mini MoonBoard 2020 40° also shows a lower number of routes and climbs, likely due to its more niche appeal and focus on specific challenges.

The number of setters and benchmarks further illustrates the popularity and usage patterns of these Moonboard versions. The MoonBoard 2016 40° has the most setters and benchmarks, reinforcing its position as the most widely used version. Meanwhile, the Moonboard Masters 2019 25° has fewer setters and benchmarks, aligning with its lower number of routes and climbs. Interestingly, the Mini MoonBoard 2020 40° has a relatively high number of benchmarks compared to its total routes, suggesting a focus on quality and challenging routes rather than quantity.

The 40° versions, in general, seem to be preferred over the 25° versions, as reflected in the higher number of routes, setters, and total climbs.

Overall, the Moonboard 2016 40° emerges as the most popular and versatile version, widely used by the climbing community.

By Version (Year)

Monthly Routes Created

DuckDB Queries

    SELECT
        moonboard_version,
        count(DISTINCT grade) AS grades,
        min(grade) AS min_grade,
        max(grade) AS max_grade,
        count(problem_id) AS routes,
        count(DISTINCT setter_id) AS setters,
        count(problem_id) FILTER (WHERE is_benchmark) AS benchmarks,
        count(DISTINCT setter_id) FILTER (WHERE is_benchmark) AS benchmark_setters,
        sum(repeats) AS total_climbs,
        list_sort(list_distinct(flatten(list(hold_sets)))) AS hold_sets,
    FROM moonboard
    GROUP BY 1
    ORDER BY benchmarks DESC

    SELECT
        moonboard_version[:-5] AS moonboard_version,
        count(DISTINCT grade) AS grades,
        min(grade) AS min_grade,
        max(grade) AS max_grade,
        count(problem_id) AS routes,
        count(DISTINCT setter_id) AS setters,
        count(problem_id) FILTER (WHERE is_benchmark) AS benchmarks,
        count(DISTINCT setter_id) FILTER (WHERE is_benchmark) AS benchmark_setters,
        sum(repeats) AS total_climbs,
        list_sort(list_distinct(flatten(list(hold_sets)))) AS hold_sets,
    FROM moonboard
    GROUP BY 1
    ORDER BY benchmarks DESC

    SELECT
        moonboard_version,
        date_trunc('month', date_inserted::date)::timestamp AS month,
        count(problem_id) AS routes
    FROM moonboard
    GROUP BY 1,2
    ORDER BY 1,2;

    SELECT
        moonboard_version[:-5] AS moonboard_version,
        date_trunc('month', date_inserted::date)::timestamp AS month,
        count(problem_id) AS routes
    FROM moonboard
    GROUP BY 1,2
    ORDER BY 1,2;