Cataloged Exercises by Mechanic and Difficulty Level

PlainExercise shows the joint distribution of exercise mechanic (compound vs. isolation) and difficulty level (beginner / intermediate / expert) in the Free Exercise Database. Rendered server-side from the exercises table.

Research period: 2026-05-17

Compiled byPlainExercise Editorial, Exercise Science Editorial Team · May 17, 2026

Methodology

We queried the PlainExercise exercises table at server render time and pulled the columns level, mechanic, 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.

The ranked top 9

Every row below is rendered from a live SELECT against the 9-row result returned by the query in the frontmatter above. Refresh the page after an ETL run to see the latest values.

#	Difficulty level	Mechanic	Cataloged exercises
1	beginner	compound	241
2	beginner	isolation	232
3	intermediate	compound	204
4	intermediate	isolation	62
5	beginner	unspecified	50
6	expert	compound	44
7	intermediate	unspecified	27
8	expert	unspecified	10
9	expert	isolation	3

Source: Free Exercise DB — Free Exercise Database — level / mechanic / category 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 — level / mechanic / category 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 beginner, with a value of 241 on the Cataloged exercises column. The full top-9 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 (241) and the 9th-ranked record (3) 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-9 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-9 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 — level / mechanic / category 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

Difficulty-level assignment (beginner / intermediate / expert) in the catalogue uses the original dataset's classification, which mixes movement-complexity, coordination-demand, and load-tolerance considerations into a single tag. A reasonable coach might re-classify many entries — overhead press is here classified across multiple levels depending on variation, but coaches at different gyms disagree about whether a strict press is beginner-appropriate or intermediate-appropriate. The mechanic axis (compound vs. isolation) captures whether the movement coordinates multiple major joints or works one joint in isolation; this is a useful programming distinction but not a quality judgment — both mechanics have a place in a balanced program. Heavy concentration of cataloged exercises at the beginner-compound and beginner-isolation buckets reflects the catalogue's emphasis on the foundational movement vocabulary rather than the relative importance of beginner versus advanced training.

Cataloged Exercises by Mechanic and Difficulty Level

Research question

Methodology