Cataloged Exercises by Equipment Category
PlainExercise shows the distribution of cataloged exercises across equipment categories. Rendered server-side from the exercises table grouped by equipment.
Research period:
Research question
How are cataloged exercises distributed across equipment categories in the Free Exercise Database, and how concentrated is the catalogue in the most common implements (barbell, dumbbell, bodyweight)?
Methodology
We queried the PlainExercise exercises table at server render time and pulled the columns equipment, exercise_count. The query ranks records by exercise_count DESC and returns the top 10. Every numeric value rendered on this page derives from a live SELECT against the production exercises table — no figure is hardcoded, and the table refreshes whenever the underlying open datasets (Free Exercise DB and wger.de) are re-ingested.
See the methodology page for the complete ETL pipeline, source vintage, and column lineage.
Cataloged Exercises by Equipment Category
Live data — rendered from a SELECT against the portal database at request time
The ranked top 10
Every row below is rendered from a live SELECT against the 10-row result returned by the query in the frontmatter above. Refresh the page after an ETL run to see the latest values.
| # | Equipment category | Cataloged exercises |
|---|---|---|
| 1 | barbell | 170 |
| 2 | dumbbell | 123 |
| 3 | other | 122 |
| 4 | body only | 111 |
| 5 | cable | 81 |
| 6 | machine | 67 |
| 7 | kettlebells | 53 |
| 8 | bands | 20 |
| 9 | medicine ball | 17 |
| 10 | exercise ball | 12 |
Source: Free Exercise DB — Free Exercise Database — equipment field documentation. Values are queried live from the PlainExercise SQLite snapshot at request time; the snapshot is refreshed by the portal ETL pipeline. Free Exercise DB — Free Exercise Database — equipment field documentation. Values are queried live from the PlainExercise SQLite snapshot at request time; the snapshot is refreshed by the portal ETL pipeline.
Findings
Top entity in the ranking
The top-ranked record in this dataset is barbell, with a value of 170 on the Cataloged exercises column. The full top-10 set is rendered in the table above. Every value derives from the underlying exercises table; no number is hardcoded into this page. When the Free Exercise DB publishes a revision and our ETL pipeline reingests, the ranking and the prose around it update on the next page load.
Distribution shape
The gap between the top-ranked record (170) and the 10th-ranked record (12) characterizes how concentrated the top of the distribution is. Where the top value is many multiples of the median value of the visible set, the population is highly concentrated — a small number of entities accumulate the bulk of the measured quantity. Where the top and bottom of the visible set are close together, the distribution is relatively flat across the top end. The full distribution beyond this top-10 cut is summarized in the aggregate context section below and explored in the linked entity profiles.
Aggregate context
Across the full exercises population, the aggregate query returns the following summary statistics. These anchors situate the top-10 ranking against the underlying population: how many records exist in total, what the sum of the ranking column is across all qualifying rows, and what the mean per-record value looks like. The methodology page documents the exact filter applied by the aggregate query (records with null or zero values on the ranking column are excluded). The aggregate row is computed by the same database engine that renders the ranking above, against the same snapshot.
Source provenance
The records in this ranking originate from Free Exercise DB, specifically the Free Exercise Database — equipment field documentation. PlainExercise ingests the source vintage published by the agency, transforms it into a normalized SQLite schema, and serves it from a read-only snapshot. Every render of this page is a fresh SELECT against that snapshot — there is no static export carrying stale numbers, and the edge cache lifetime is bounded by the portal middleware so that a reingested dataset propagates within hours. The methodology page documents the source URL, the vintage date, and the transformation steps applied during ETL.
Why this ranking matters
Rankings like this one let a reader scan a population quickly and identify outliers, concentrations, and patterns that warrant deeper investigation. The detail pages linked from each entity in the table above give the full per-entity context: time-series history where available, related metrics from adjacent tables, and links onward to the underlying source records. The methodology page explains how an entity earns inclusion in the dataset and how the ranking column is computed at the source.
What this analysis cannot tell us
Equipment counts reflect the Free Exercise Database catalogue, which emphasizes commercial-gym implements and bodyweight movements. Specialty equipment (sandbags, atlas stones, fat-grip implements, Olympic-style rings beyond basic ring variations, suspension trainers other than TRX) is under-represented or absent. The 'body only' (bodyweight) category and the 'other' bucket capture a mix of movements that resist tidy equipment classification. Equipment counts in a catalogue do not reflect the relative training value of each implement — bodyweight movements are versatile and effective even though they appear in lower count than barbell variations, because barbell training generates many one-arm and stance variations that the catalogue enumerates separately.
Secondary cut from the same source
Strength-category cataloged exercises by equipment
Sources
- Free Exercise Database (Yuhonas / GitHub) — https://github.com/yuhonas/free-exercise-db
- Original dataset metadata — https://github.com/yuhonas/free-exercise-db/blob/main/README.md