steps_activities
1 row where activity_id = 19290888426
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19290888426 | 4140 | 00:05:17.965024 | 00:08:30.422919 | 00:06:32.427280 | 182 | 196 | 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) );