steps_activities
1 row where activity_id = 18971654111
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18971654111 | 3656 | 00:15:04.159132 | 00:19:31.279517 | 00:07:30.247636 | 82 | 222 | 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) );