activity_laps

4 rows where activity_id = 18813922597

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: distance, calories, 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
18813922597,0 Copenhagen Running 18813922597 0 2025-04-13 09:27:03.000000 2025-04-13 09:33:42.000000 00:06:39.060000 00:05:29.411000 1.0 461.0 135 158     50 89 98 10.9296             55.70465602912009 12.556780194863677 55.69997121579945 12.56555562838912             00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000
18813922597,1 Copenhagen Running 18813922597 1 2025-04-13 09:33:43.000000 2025-04-13 09:39:47.000000 00:06:05.585000 00:06:05.585000 1.0 505.0 143 159     58 86 99 9.846             55.69995604455471 12.56555118598044 55.70131257176399 12.570435153320432             00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000
18813922597,2 Copenhagen Running 18813922597 2 2025-04-13 09:39:48.000000 2025-04-13 09:46:28.000000 00:06:40.952000 00:06:40.952000 1.0 542.0 136 157     58 83 97 8.9784             55.70132430642843 12.57042333483696 55.70242912508547 12.562650796025991             00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000 00:00:00.000000
18813922597,3 Copenhagen Running 18813922597 3 2025-04-13 09:46:29.000000 2025-04-13 09:46:31.000000 00:00:01.912000 00:00:01.912000 0.0037 2.0 106 106     0 61 61 6.966             55.70241680368781 12.562640905380249 55.70240657776594 12.562629086896777             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)
);