steps_activities
1 row where activity_id = 19042568339
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19042568339 | 4408 | 00:10:07.164542 | 00:15:49.826133 | 00:04:14.582485 | 112 | 188 | 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) );