rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by total_distance
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance ▼ | athlete |
|---|---|---|---|---|---|---|---|
| 3180 | 3180 | 2020-05-01 10:47:03+00:00 | Bike | T---HC-----E--- | 6400.0 | {463cf735-47a9-47bf-89a2-58ccedf7fce7} | |
| 3181 | 3181 | 2016-12-23 15:06:14+00:00 | Bike | T--PHC-A---E--- | 176.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3184 | 3184 | 2017-01-04 16:09:29+00:00 | Bike | T---HC-A---E--- | 1375.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3185 | 3185 | 2017-01-05 15:41:12+00:00 | Bike | T---HC-A---E--- | 2449.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3186 | 3186 | 2017-01-07 15:50:33+00:00 | Bike | T---HC-A---E--- | 3024.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3187 | 3187 | 2017-01-08 14:03:31+00:00 | Bike | T---HC-A---E--- | 189.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3188 | 3188 | 2017-01-10 15:43:31+00:00 | Bike | T---HC-A---E--- | 2357.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3189 | 3189 | 2017-01-12 15:39:00+00:00 | Bike | T---HC-A---E--- | 2384.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3190 | 3190 | 2017-01-13 15:58:29+00:00 | Bike | T--PHC-A---E--- | 80.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3191 | 3191 | 2017-01-13 16:06:09+00:00 | Bike | T---HC-A---E--- | 1265.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3192 | 3192 | 2017-01-15 14:16:59+00:00 | Bike | T---HC-A---E--- | 2841.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3193 | 3193 | 2017-01-17 16:24:53+00:00 | Bike | T---HC-A---E--- | 2795.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3194 | 3194 | 2017-01-19 16:19:41+00:00 | Bike | T---HC-A---E--- | 2404.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3195 | 3195 | 2017-01-21 16:03:10+00:00 | Bike | T---HC-A---E--- | 3043.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3196 | 3196 | 2017-01-22 13:46:17+00:00 | Bike | T---HC-A---E--- | 2709.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3197 | 3197 | 2017-01-24 15:49:58+00:00 | Bike | T---HC-A---E--- | 3089.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3198 | 3198 | 2017-01-26 15:57:58+00:00 | Bike | T---HC-A---E--- | 3039.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3199 | 3199 | 2017-01-29 13:41:45+00:00 | Bike | T---HC-A---E--- | 3117.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3200 | 3200 | 2017-01-31 15:38:23+00:00 | Bike | T---HC-A---E--- | 3037.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3201 | 3201 | 2017-02-07 15:36:29+00:00 | Bike | T---HC-A---E--- | 3037.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3202 | 3202 | 2017-02-09 16:37:16+00:00 | Bike | T---HC-A---E--- | 3047.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3203 | 3203 | 2017-02-11 14:45:45+00:00 | Bike | T---HC-A---E--- | 3044.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3204 | 3204 | 2017-02-12 13:25:02+00:00 | Bike | T---HC-A---E--- | 3161.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3205 | 3205 | 2017-02-14 16:14:48+00:00 | Bike | T---HC-A---E--- | 3008.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3206 | 3206 | 2017-02-16 16:21:33+00:00 | Bike | T--PHC-A---E--- | 41.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3207 | 3207 | 2017-02-16 16:23:10+00:00 | Bike | T--PHC-A---E--- | 3206.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3208 | 3208 | 2017-02-19 13:13:59+00:00 | Bike | T---HC-A---E--- | 3335.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3209 | 3209 | 2017-02-21 15:58:36+00:00 | Bike | T---HC-A---E--- | 3431.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3211 | 3211 | 2017-02-25 16:08:20+00:00 | Bike | T---HC-A---E--- | 3050.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3220 | 3220 | 2017-03-16 16:20:43+00:00 | Bike | T---HC-A---E--- | 3816.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3222 | 3222 | 2017-03-19 13:35:12+00:00 | Bike | T---HC-A---E--- | 3786.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3231 | 3231 | 2017-04-03 20:09:28+00:00 | Bike | T------A---E--- | 59.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3234 | 3234 | 2017-04-08 17:27:32+00:00 | Bike | T---H--A---E--- | 511.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3235 | 3235 | 2017-04-08 20:31:44+00:00 | Bike | T------A---E--- | 43.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3238 | 3238 | 2017-04-12 14:59:48+00:00 | Bike | T--PHC-A---E--- | 3241.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3239 | 3239 | 2017-04-14 15:10:38+00:00 | Bike | T--PHC-A---E--- | 2709.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3242 | 3242 | 2017-04-22 15:17:38+00:00 | Bike | T--PHC-A---E--- | 3002.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3243 | 3243 | 2017-04-23 12:32:46+00:00 | Bike | T--PHC-A---E--- | 3334.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3244 | 3244 | 2017-04-25 15:21:10+00:00 | Bike | T--PHC-A---E--- | 3190.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3245 | 3245 | 2017-04-27 15:21:07+00:00 | Bike | T--PHC-A---E--- | 3244.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3249 | 3249 | 2017-05-03 13:42:26+00:00 | Bike | T--PHC-A---E--- | 2226.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3372 | 3372 | 2018-03-04 15:02:34+00:00 | Bike | T---H--A---E--- | 690.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3374 | 3374 | 2018-03-09 21:17:00+00:00 | Bike | T---H--A---E--- | 742.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3378 | 3378 | 2018-03-17 14:23:56+00:00 | Bike | T--PHC-A---E--- | 2803.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3440 | 3440 | 2018-07-02 16:11:49+00:00 | Bike | T--PHC-A---E--- | 3080.0 | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |
| 3563 | 3563 | 2019-02-14 16:52:53+00:00 | --------------- | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |||
| 3564 | 3564 | 2019-02-16 15:59:46+00:00 | --------------- | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |||
| 3565 | 3565 | 2019-02-17 09:46:50+00:00 | --------------- | {4f0c636a-4f97-42fd-9a94-313324a9206e} | |||
| 3704 | 3704 | 2018-04-21 10:18:10+00:00 | --------------- | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |||
| 3735 | 3735 | 2018-08-11 00:54:19+00:00 | Bike | T--PHC-A---EV-- | 4735.0 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 4008 | 4008 | 2018-02-21 16:23:16+00:00 | Bike | T--PHC-A------- | 3305.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4013 | 4013 | 2018-02-23 15:32:43+00:00 | Bike | T--PHC-A------- | 2791.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4016 | 4016 | 2018-02-26 14:55:09+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4021 | 4021 | 2018-02-28 15:34:13+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4026 | 4026 | 2018-03-03 14:30:25+00:00 | Bike | T--PHC--------- | 5401.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4029 | 4029 | 2018-03-05 15:24:36+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4032 | 4032 | 2018-03-12 16:06:18+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4033 | 4033 | 2018-03-13 13:52:37+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4040 | 4040 | 2018-03-16 15:00:32+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4044 | 4044 | 2018-03-19 15:38:31+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4049 | 4049 | 2018-03-22 15:47:26+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4057 | 4057 | 2018-03-28 14:32:30+00:00 | Bike | T--PHC--------- | 3601.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4078 | 4078 | 2018-04-20 15:47:43+00:00 | Bike | T--PHC--------- | 2714.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4184 | 4184 | 2018-07-02 15:06:18+00:00 | Bike | T--PHC-A---E--- | 3506.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4240 | 4240 | 2018-08-20 14:45:05+00:00 | Bike | T--PHC-A---E--- | 2088.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4261 | 4261 | 2018-09-16 14:32:25+00:00 | Bike | T--PHC-A---E--- | 9383.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4264 | 4264 | 2018-09-20 13:54:42+00:00 | Bike | T--PHC-A---E--- | 4027.0 | {cf5f4469-b705-4541-b43e-0d8772e154c9} | |
| 4367 | 4367 | 2019-06-21 09:21:01+00:00 | Bike | T------AG--E--- | 40.0 | {8f5805e1-35f5-4a0b-af4e-304e478c43ba} | |
| 4368 | 4368 | 2019-06-22 02:29:21+00:00 | Bike | T-S-H--AG--E--- | 621.0 | {8f5805e1-35f5-4a0b-af4e-304e478c43ba} | |
| 4558 | 4558 | 2017-10-09 13:04:55+00:00 | -------AG--E--- | 1.0 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | ||
| 5551 | 5551 | 2018-12-14 09:38:14+00:00 | Bike | T-SP-C-AG--E--- | 2.0 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 5677 | 5677 | 2019-02-09 20:07:16+00:00 | Bike | T-SPHC-AG--E--- | 3841.0 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 5833 | 5833 | 2019-04-13 22:25:34+00:00 | Bike | T--PHC-AG--E--- | 1900.0 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 6792 | 6792 | 2017-09-11 10:55:47+00:00 | Run | T---H---------- | 4676.0 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6793 | 6793 | 2017-09-27 11:06:21+00:00 | T---H---------- | 2678.0 | {dedad338-12be-45f6-8316-5258e560a5fe} | ||
| 6794 | 6794 | 2017-10-06 11:18:06+00:00 | Run | T---H---------- | 4855.0 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6795 | 6795 | 2017-10-13 10:52:32+00:00 | Run | T---H---------- | 4883.0 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6796 | 6796 | 2017-11-11 12:52:24+00:00 | Run | T---H---------- | 4887.0 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6798 | 6798 | 2017-12-08 12:11:48+00:00 | Run | T---H---------- | 3921.0 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 7006 | 7006 | 2016-11-11 16:53:53+00:00 | Bike | T--PHC-A------- | 3616.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7008 | 7008 | 2016-11-14 20:45:53+00:00 | Bike | T--PHC-A------- | 3178.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7010 | 7010 | 2016-11-17 15:38:58+00:00 | Bike | T--PHC-A------- | 1271.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7011 | 7011 | 2016-11-19 21:55:44+00:00 | Bike | T--P-C-A------- | 149.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7012 | 7012 | 2016-11-19 22:01:42+00:00 | Bike | T--P-C-A------- | 252.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7134 | 7134 | 2017-05-01 15:03:07+00:00 | --------------- | 3600.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | ||
| 7393 | 7393 | 2018-03-29 13:36:08+00:00 | Bike | T--P-C-AG--E--- | 1907.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7439 | 7439 | 2018-05-17 16:21:35+00:00 | Bike | T--P-C-A---E--- | 3954.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7625 | 7625 | 2018-12-08 17:39:09+00:00 | Bike | T--PHC-A---E--- | 2213.0 | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |
| 7661 | 7661 | 2019-02-14 12:34:24+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7662 | 7662 | 2019-02-15 11:56:41+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7663 | 7663 | 2019-02-16 09:19:35+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7664 | 7664 | 2019-02-17 08:42:34+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7665 | 7665 | 2019-02-18 11:47:04+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7666 | 7666 | 2019-02-21 11:13:07+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7667 | 7667 | 2019-02-23 09:26:28+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7668 | 7668 | 2019-02-24 09:11:05+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7669 | 7669 | 2019-02-25 11:58:12+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7670 | 7670 | 2019-02-25 14:20:00+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7671 | 7671 | 2019-02-26 11:30:45+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} | |||
| 7672 | 7672 | 2019-02-27 09:32:28+00:00 | --------------- | {9b7b4e95-1ffb-4bc8-9a53-59c5c98904c2} |
Advanced export
JSON shape: default, array, newline-delimited
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");