rides

Metadata for each ride in GoldenCheetah OpenData.

Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData

2,589,036 rows sorted by total_distance

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid date sport data workout_time total_distance ▼ athlete
244 244 2015-10-08 22:55:42+00:00 Bike T---H--AG--E--- 363.0   {96836b71-7497-4393-b0ef-810ee3041daa}
515 515 2018-07-02 00:03:59+00:00 Bike -------AG--E--- 1.0   {96836b71-7497-4393-b0ef-810ee3041daa}
970 970 2016-06-28 19:11:10+00:00 Jet Fluid T--PHC-----E--- 2774.0   {35266436-ec7a-4e34-b67d-eb2b6dcf9347}
1089 1089 2016-11-15 18:07:46+00:00 Jet Fluid T--PHC--------- 2676.0   {35266436-ec7a-4e34-b67d-eb2b6dcf9347}
1090 1090 2016-11-16 17:30:32+00:00 Jet Fluid T--PHC--------- 3051.0   {35266436-ec7a-4e34-b67d-eb2b6dcf9347}
1091 1091 2016-11-17 18:20:56+00:00 Jet Fluid T--PHC--------- 2960.0   {35266436-ec7a-4e34-b67d-eb2b6dcf9347}
1092 1092 2016-11-19 19:44:28+00:00 Jet Fluid T--PHC--------- 2836.0   {35266436-ec7a-4e34-b67d-eb2b6dcf9347}
1480 1480 2018-03-21 18:13:33+00:00 Jet Fluid T--PHCNA---EV-- 3604.0   {35266436-ec7a-4e34-b67d-eb2b6dcf9347}
1560 1560 2012-02-19 03:09:39+00:00 Bike T---H---G------ 4532.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
1647 1647 2012-12-18 18:13:03+00:00 Run T---H---------- 2168.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
1852 1852 2014-03-21 16:08:17+00:00 Run T---H---------- 3308.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2155 2155 2015-09-10 16:03:19+00:00   T---H---------- 3181.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2168 2168 2015-10-09 12:59:59+00:00   T---H---------- 3602.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2172 2172 2015-10-18 14:07:26+00:00 Bike T---H---------- 5084.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2187 2187 2015-11-24 00:08:10+00:00   T---H---------- 3336.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2188 2188 2015-11-26 17:02:09+00:00   T---H---------- 3302.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2199 2199 2015-12-30 01:11:59+00:00 Gym T---H--A---E--- 4982.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2338 2338 2016-09-03 18:56:15+00:00 GYM T---H---------- 2871.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2343 2343 2016-09-06 20:34:14+00:00 Roller T---H---------- 962.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2345 2345 2016-09-08 16:15:29+00:00   T---H---------- 2711.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2349 2349 2016-09-13 15:54:00+00:00   T---H---------- 4774.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2350 2350 2016-09-15 00:02:50+00:00   T---H---------- 3328.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2352 2352 2016-09-15 16:16:16+00:00   T---H---------- 2684.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2353 2353 2016-09-17 02:56:22+00:00   T---H---------- 1805.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2356 2356 2016-09-20 16:14:06+00:00   T---H---------- 2725.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2363 2363 2016-10-04 16:18:47+00:00   T---H---------- 2542.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2365 2365 2016-10-06 16:15:58+00:00   T---H---------- 2753.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2367 2367 2016-10-11 16:17:11+00:00   T---H---------- 2679.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2372 2372 2016-10-18 16:22:02+00:00   T---H---------- 2349.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2374 2374 2016-10-18 17:47:00+00:00   T---H---------- 2686.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2378 2378 2016-10-28 01:00:15+00:00 Cross-Training T---H---------- 2811.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2381 2381 2016-11-06 15:50:33+00:00 Cross-Training T---H---------- 5755.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2383 2383 2016-11-10 17:15:35+00:00 Cross-Training T---H---------- 2809.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2388 2388 2016-11-25 01:29:33+00:00 Cross-Training T---H---------- 2896.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2397 2397 2017-01-10 17:18:33+00:00 Cross-Training T---H---------- 2496.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2398 2398 2017-01-12 17:13:36+00:00 Cross-Training T---H---------- 2704.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2404 2404 2017-01-24 20:28:20+00:00 Cross-Training T---H---------- 2549.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2406 2406 2017-01-31 17:13:50+00:00 Cross-Training T---H---------- 2838.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2407 2407 2017-02-02 15:39:57+00:00 Cross-Training T---H---------- 8381.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2409 2409 2017-02-05 19:33:39+00:00 Cross-Training T---H---------- 3601.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2433 2433 2017-05-02 16:16:10+00:00 Cross-Training T---H---------- 2710.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2434 2434 2017-05-04 16:14:15+00:00 Cross-Training T---H---------- 2877.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2436 2436 2017-05-06 14:28:45+00:00 Cross-Training T---H---------- 3633.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2439 2439 2017-05-11 16:18:11+00:00 Cross-Training T---H---------- 2536.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2441 2441 2017-05-16 14:11:16+00:00 Cross-Training T---H---------- 901.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2442 2442 2017-05-16 16:20:58+00:00 Cross-Training T---H---------- 2277.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2444 2444 2017-05-20 01:40:02+00:00 Cross-Training T---H---------- 1235.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2447 2447 2017-05-24 20:37:39+00:00 Cross-Training T---H---------- 3023.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2453 2453 2017-06-06 23:53:14+00:00 Cross-Training T---H---------- 5632.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2455 2455 2017-06-08 16:14:01+00:00 Cross-Training T---H---------- 3595.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2460 2460 2017-06-21 00:02:54+00:00 Cross-Training T---H---------- 6257.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2466 2466 2017-06-29 15:59:00+00:00 Cross-Training T---H---------- 4700.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2481 2481 2017-08-03 15:54:21+00:00 Cross-Training T---H---------- 4218.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2483 2483 2017-08-06 20:11:26+00:00 Cross-Training T---H---------- 1848.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2486 2486 2017-08-08 16:00:31+00:00 Cross-Training T---H---------- 4672.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2488 2488 2017-08-10 15:52:59+00:00 Cross-Training T---H---------- 5306.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2501 2501 2017-09-05 15:54:00+00:00 Cross-Training T---H---------- 5406.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2521 2521 2017-10-30 13:01:22+00:00 Cross-Training T---H---------- 3890.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2526 2526 2017-11-07 17:16:21+00:00 Cross-Training T---H---------- 2738.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2528 2528 2017-11-09 17:15:00+00:00 Cross-Training --------------- 2700.0   {c951a4f7-b06e-4743-8ad0-24271b8f7cd6}
2578 2578 2018-01-13 15:51:07+00:00 Bike --------------- 4500.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2642 2642 2018-06-14 21:17:40+00:00 Bike --------------- 3600.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2691 2691 2018-08-10 21:17:05+00:00 WeightTraining --------------- 1200.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2695 2695 2018-08-16 00:45:01+00:00 WeightTraining --------------- 1200.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2705 2705 2018-08-23 23:46:53+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2723 2723 2018-09-06 01:15:05+00:00 Bike --------------- 1200.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2734 2734 2018-09-18 21:32:14+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2739 2739 2018-09-25 00:10:00+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2745 2745 2018-10-02 00:53:46+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2756 2756 2018-10-10 23:34:46+00:00 Bike --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2764 2764 2018-10-19 04:32:08+00:00 Bike --------------- 3600.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2804 2804 2018-11-20 21:13:05+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2810 2810 2018-11-27 01:33:45+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2826 2826 2019-01-08 18:33:36+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2835 2835 2019-01-15 01:14:29+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2838 2838 2019-01-18 02:20:59+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2844 2844 2019-01-20 22:31:32+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2850 2850 2019-01-25 00:13:16+00:00 Bike T---H------E--- 3510.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2852 2852 2019-01-25 01:26:48+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2855 2855 2019-01-29 01:26:29+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2858 2858 2019-01-31 23:56:03+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2865 2865 2019-02-06 00:56:44+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2867 2867 2019-02-09 17:03:36+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2873 2873 2019-02-13 11:50:47+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2876 2876 2019-02-17 16:31:00+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2885 2885 2019-02-21 00:18:31+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2888 2888 2019-02-24 15:00:16+00:00   ---------------     {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2889 2889 2019-02-25 01:12:24+00:00   --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2894 2894 2019-02-28 12:23:04+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2896 2896 2019-03-01 00:37:35+00:00 Bike T--PHC-AG--E--- 2721.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2897 2897 2019-03-01 13:12:50+00:00   T-------G--E--- 15.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2901 2901 2019-03-03 18:52:51+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2906 2906 2019-03-07 00:25:08+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2909 2909 2019-03-13 20:03:20+00:00 WeightTraining --------------- 900.0   {a261fff9-a6c6-46a6-ba88-969773bc80dd}
2913 2913 2017-04-12 10:00:00+00:00   ---------------     {0e118a96-d384-4ac2-8021-c3508781a03b}
2940 2940 2018-07-17 07:22:35+00:00 Training T---H------E--- 365.0   {0e118a96-d384-4ac2-8021-c3508781a03b}
3117 3117 2020-03-29 16:15:48+00:00 Bike T------A---E--- 8.0   {0e118a96-d384-4ac2-8021-c3508781a03b}
3118 3118 2020-03-29 16:15:49+00:00 Bike T------A---E--- 8.0   {0e118a96-d384-4ac2-8021-c3508781a03b}
3169 3169 2020-04-21 18:31:47+00:00 Bike T---HC-----E--- 2314.0   {463cf735-47a9-47bf-89a2-58ccedf7fce7}
3178 3178 2020-04-29 14:08:28+00:00 Bike T---HC-----E--- 3008.0   {463cf735-47a9-47bf-89a2-58ccedf7fce7}

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "rides" (
"date" TIMESTAMP,
  "sport" TEXT,
  "data" TEXT,
  "workout_time" REAL,
  "total_distance" REAL,
  "athlete" TEXT
);
CREATE INDEX "ix_rides_date"ON "rides" ("date");