home / gym

sets

15 rows where exercise_id = 2

✎ 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
7 1 1 Barbell Row 2 1 30 6    
8 1 1 Barbell Row 2 2 30 7    
9 1 1 Barbell Row 2 3 35 7    
185 10 10 Barbell Row 2 1 30 9    
186 10 10 Barbell Row 2 2 40 6    
187 10 10 Barbell Row 2 3 45 9    
188 10 10 Barbell Row 2 4 50 5   Top set
189 10 10 Barbell Row 2 5 45 6    
190 10 10 Barbell Row 2 6 40 9   Back-off set
333 17 17 Barbell Row 2 1 40 6    
334 17 17 Barbell Row 2 2 40 8    
335 17 17 Barbell Row 2 3 40 8    
336 17 17 Barbell Row 2 4 40 7    
337 17 17 Barbell Row 2 5 40 7    
338 17 17 Barbell Row 2 6 30 9   Back-off set

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 29.419ms