steps_activities
1 row where activity_id = 18875585916
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18875585916 | 4082 | 00:06:29.863548 | 00:10:25.770864 | 00:04:29.978402 | 140 | 186 | 1026.4 | 8.84 | 89.80000000000001 | 00:00:00.299400 |
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) );