activity_laps

3 rows where activity_id = 18668133608

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: distance, start_time (date), stop_time (date)

Link activity_id lap start_time stop_time elapsed_time moving_time distance cycles avg_hr max_hr avg_rr max_rr calories avg_cadence max_cadence avg_speed max_speed ascent descent max_temperature min_temperature avg_temperature start_lat start_long stop_lat stop_long hr_zones_method hrz_1_hr hrz_2_hr hrz_3_hr hrz_4_hr hrz_5_hr hrz_1_time hrz_2_time hrz_3_time hrz_4_time hrz_5_time
18668133608,0 Copenhagen Running 18668133608 0 2025-03-29 09:15:29.000000 2025-03-29 09:21:25.000000 00:05:56.013000 00:05:18.220000 1.0 482.0 142 177     52 95 97 11.3112             55.704470202326775 12.55698161199689 55.698916018009186 12.566340928897262             00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000
18668133608,1 Copenhagen Running 18668133608 1 2025-03-29 09:21:26.000000 2025-03-29 09:29:01.000000 00:07:36.003000 00:07:36.003000 1.0 575.0 119 148     56 76 96 7.8948             55.698898332193494 12.566385520622134 55.70223986171186 12.569415997713804             00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000
18668133608,2 Copenhagen Running 18668133608 2 2025-03-29 09:29:02.000000 2025-03-29 09:30:21.000000 00:01:13.447000 00:01:13.447000 0.22134 118.0 130 138     10 96 98 10.8504             55.702250842005014 12.569370567798615 55.703677609562874 12.567209713160992             00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000

Advanced export

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

CSV options: 

CREATE TABLE activity_laps (
	activity_id VARCHAR NOT NULL, 
	lap INTEGER NOT NULL, 
	start_time DATETIME, 
	stop_time DATETIME, 
	elapsed_time TIME NOT NULL, 
	moving_time TIME NOT NULL, 
	distance FLOAT, 
	cycles FLOAT, 
	avg_hr INTEGER, 
	max_hr INTEGER, 
	avg_rr FLOAT, 
	max_rr FLOAT, 
	calories INTEGER, 
	avg_cadence INTEGER, 
	max_cadence INTEGER, 
	avg_speed FLOAT, 
	max_speed FLOAT, 
	ascent FLOAT, 
	descent FLOAT, 
	max_temperature FLOAT, 
	min_temperature FLOAT, 
	avg_temperature FLOAT, 
	start_lat FLOAT, 
	start_long FLOAT, 
	stop_lat FLOAT, 
	stop_long FLOAT, 
	hr_zones_method VARCHAR(18), 
	hrz_1_hr INTEGER, 
	hrz_2_hr INTEGER, 
	hrz_3_hr INTEGER, 
	hrz_4_hr INTEGER, 
	hrz_5_hr INTEGER, 
	hrz_1_time TIME NOT NULL, 
	hrz_2_time TIME NOT NULL, 
	hrz_3_time TIME NOT NULL, 
	hrz_4_time TIME NOT NULL, 
	hrz_5_time TIME NOT NULL, 
	PRIMARY KEY (activity_id, lap), 
	FOREIGN KEY(activity_id) REFERENCES activities (activity_id)
);