home / gym

sets

21 rows where exercise_id = 15

✎ 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
1 1 1 Deadlift (conventional) 15 1 40 8    
2 1 1 Deadlift (conventional) 15 2 50 7    
3 1 1 Deadlift (conventional) 15 3 60 8    
4 1 1 Deadlift (conventional) 15 4 70 7    
5 1 1 Deadlift (conventional) 15 5 75 8    
6 1 1 Deadlift (conventional) 15 6 80 10   Straps used
108 6 6 Deadlift (conventional) 15 1 50 8   Warm-up
109 6 6 Deadlift (conventional) 15 2 90 8   PR — prev top 80x10
110 6 6 Deadlift (conventional) 15 3 90 6    
111 6 6 Deadlift (conventional) 15 4 90 6    
112 6 6 Deadlift (conventional) 15 5 80 8   Back-off set
141 8 8 Deadlift (conventional) 15 1 40 8   Warm-up
142 8 8 Deadlift (conventional) 15 2 70 10    
143 8 8 Deadlift (conventional) 15 3 100 8   PR — prev 90x8
144 8 8 Deadlift (conventional) 15 4 100 6    
145 8 8 Deadlift (conventional) 15 5 90 7    
146 8 8 Deadlift (conventional) 15 6 90 6    
236 12 12 Deadlift (conventional) 15 1 40 10   Warm-up
237 12 12 Deadlift (conventional) 15 2 70 10    
238 12 12 Deadlift (conventional) 15 3 70 8    
239 12 12 Deadlift (conventional) 15 4 70 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 10.971ms