home / gym

sets

9 rows where exercise_id = 18

✎ 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
14 1 1 Face Pulls 18 1 10 10    
15 1 1 Face Pulls 18 2 10 8    
16 1 1 Face Pulls 18 3 10 10    
76 4 4 Face Pulls 18 1 10 12    
77 4 4 Face Pulls 18 2 15 12    
78 4 4 Face Pulls 18 3 20 9   Machine geometry different
102 5 5 Face Pulls 18 1 20 12    
103 5 5 Face Pulls 18 2 25 6    
104 5 5 Face Pulls 18 3 22.5 7   Favouring right side

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