home / gym

sets

8 rows where exercise_id = 41

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_id, set_number, reps

id ▼ session_id exercise_id set_number weight_kg reps assist_reps notes
10 1 1 Pull-ups (BW) 41 1 BW 8    
11 1 1 Pull-ups (BW) 41 2 BW 6    
12 1 1 Pull-ups (BW) 41 3 BW 5    
13 1 1 Pull-ups (BW) 41 4 BW 4    
191 10 10 Pull-ups (BW) 41 1 BW 10    
192 10 10 Pull-ups (BW) 41 2 BW 8    
193 10 10 Pull-ups (BW) 41 3 BW 5    
194 10 10 Pull-ups (BW) 41 4 BW 5    

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