home / james_garmin_activities

steps_activities

1 row where activity_id = 19004058967

✎ View and edit SQL

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
19004058967 5636 00:03:53.100233 00:06:14.616547 00:03:17.745699 176 194 1428.8000000000002 6.93 98.9   00:00:00.216100   71.0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);
Powered by Datasette · Queries took 13.06ms