home / gym

sets

10 rows where exercise_id = 33

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, set_number, weight_kg, reps, notes

id ▼ session_id exercise_id set_number weight_kg reps assist_reps notes
55 3 3 Leg Press (Raptor) 33 1 50 10   2x25 plates per side
56 3 3 Leg Press (Raptor) 33 2 80 10   2x40 plates per side
57 3 3 Leg Press (Raptor) 33 3 100 10   2x50 plates per side
58 3 3 Leg Press (Raptor) 33 4 100 10   2x50 plates per side
119 6 6 Leg Press (Raptor) 33 1 100 11   Gauge set
120 6 6 Leg Press (Raptor) 33 2 120 10    
121 6 6 Leg Press (Raptor) 33 3 120 9    
122 6 6 Leg Press (Raptor) 33 4 120 9    
123 6 6 Leg Press (Raptor) 33 5 120 10    
124 6 6 Leg Press (Raptor) 33 6 120 10    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE sets (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    session_id INTEGER NOT NULL REFERENCES sessions(id),
    exercise_id INTEGER NOT NULL REFERENCES exercises(id),
    set_number INTEGER NOT NULL,
    weight_kg TEXT,
    reps INTEGER,
    assist_reps INTEGER,
    notes TEXT
);
Powered by Datasette · Queries took 38.936ms