steps_activities
1 row where activity_id = 18835713848
This data as json, CSV (advanced)
| activity_id ▼ | steps | avg_pace | avg_moving_pace | max_pace | avg_steps_per_min | max_steps_per_min | avg_step_length | avg_vertical_ratio | avg_vertical_oscillation | avg_gct_balance | avg_ground_contact_time | avg_stance_time_percent | vo2_max |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18835713848 | 1020 | 00:05:20.000000 | 00:08:20.816706 | 00:04:21.767123 | 190 | 198 | 00:00:00.000000 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE steps_activities ( steps INTEGER, avg_pace TIME NOT NULL, avg_moving_pace TIME NOT NULL, max_pace TIME NOT NULL, avg_steps_per_min INTEGER, max_steps_per_min INTEGER, avg_step_length FLOAT, avg_vertical_ratio FLOAT, avg_vertical_oscillation FLOAT, avg_gct_balance FLOAT, avg_ground_contact_time TIME NOT NULL, avg_stance_time_percent FLOAT, vo2_max FLOAT, activity_id VARCHAR NOT NULL, PRIMARY KEY (activity_id), FOREIGN KEY(activity_id) REFERENCES activities (activity_id) );