home / gym

sets

6 rows where exercise_id = 14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: weight_kg, reps, notes

id ▼ session_id exercise_id set_number weight_kg reps assist_reps notes
43 3 3 DB Romanian Deadlift 14 1 20 13    
44 3 3 DB Romanian Deadlift 14 2 25 10    
45 3 3 DB Romanian Deadlift 14 3 30 10    
46 3 3 DB Romanian Deadlift 14 4 35 10   Straps used
47 3 3 DB Romanian Deadlift 14 5 35 8   Straps used
48 3 3 DB Romanian Deadlift 14 6 35 10   Straps used

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