rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by total_distance descending
This data as json, CSV (advanced)
These facets timed out: date
Link | rowid | date | sport | data | workout_time | total_distance ▲ | athlete |
---|---|---|---|---|---|---|---|
1937056 | 1937056 | 2015-01-01 20:08:46+00:00 | Bike | TDSPHCNA-L-E--- | 35228.0 | 974062.001 | {ac398fa9-97d1-4273-9998-29c2f715d2fd} |
386504 | 386504 | 2013-07-14 05:34:03+00:00 | TDSPHCN----E--- | 20121.4 | 171020.905 | {79c247de-f880-4c1e-a2d0-afefbd9762c4} | |
90838 | 90838 | 2019-08-11 07:59:45+00:00 | TDSPHC-AGL-E--- | 12605.0 | 143942.0 | {eb78184c-32d6-4b60-93a9-ffed00a8d898} | |
1292269 | 1292269 | 2018-07-31 06:24:19+00:00 | Bike | TDSPH--AGL----- | 10001.0 | 129934.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
647251 | 647251 | 2018-04-29 05:55:41+00:00 | Bike | TDSPH---------- | 8748.0 | 92705.00608 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647119 | 647119 | 2017-09-11 06:40:31+00:00 | Bike | TD-PH---------- | 9038.0 | 91915.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647062 | 647062 | 2017-04-16 09:34:59+00:00 | Bike | TD-PH---------- | 9077.0 | 91870.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
380716 | 380716 | 2018-05-13 07:20:18+00:00 | Bike | TDSPH--AGL----- | 20001.0 | 90748.4 | {fc2e40c8-d412-4775-a4af-b5519e29a30d} |
1294172 | 1294172 | 2017-09-16 11:34:49+00:00 | Biking | TD-P---AGL----- | 20209.0 | 86257.6 | {fde35fe9-5c6c-4c46-a3af-bfcff42eef13} |
55395 | 55395 | 2019-07-21 21:13:55+00:00 | Bike | TDS-HC-AGL-E--- | 7639.0 | 85848.4 | {682707bf-7518-4412-a1c2-81908ce639a3} |
647021 | 647021 | 2016-07-27 05:16:49+00:00 | Bike | TD-PH---------- | 6358.0 | 85164.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
380717 | 380717 | 2018-05-14 10:17:51+00:00 | Bike | TDSPH--AGL----- | 10001.0 | 74077.6 | {fc2e40c8-d412-4775-a4af-b5519e29a30d} |
647042 | 647042 | 2017-01-21 07:12:29+00:00 | Bike | TD-PH---------- | 6766.0 | 71719.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647078 | 647078 | 2017-06-03 07:51:50+00:00 | Bike | TD-PH---------- | 6766.0 | 70506.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
1285789 | 1285789 | 2019-10-14 16:34:45+00:00 | TDSP-C--------- | 4661.0 | 63824.3 | {d1989ed1-e1e9-47bd-9b68-e94c579d043e} | |
647054 | 647054 | 2017-03-18 08:59:02+00:00 | Bike | TD-PH---------- | 6707.0 | 60908.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647107 | 647107 | 2017-08-09 05:22:32+00:00 | Bike | TD-PH---------- | 5498.0 | 59064.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647012 | 647012 | 2016-06-08 05:07:52+00:00 | Bike | TD-PH---------- | 5093.0 | 57773.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647020 | 647020 | 2016-07-26 05:34:46+00:00 | Bike | TD-PH---------- | 4210.0 | 56849.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647086 | 647086 | 2017-06-10 06:10:09+00:00 | Bike | TD-PH---------- | 6232.0 | 53968.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
1294173 | 1294173 | 2017-09-17 11:32:29+00:00 | Biking | TD-P---AGL----- | 14715.0 | 51214.7 | {fde35fe9-5c6c-4c46-a3af-bfcff42eef13} |
647076 | 647076 | 2017-05-29 07:10:52+00:00 | Bike | TD-PH---------- | 4638.0 | 49310.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647099 | 647099 | 2017-07-07 04:58:11+00:00 | Bike | TD-PH---------- | 4576.0 | 49028.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647084 | 647084 | 2017-06-07 05:02:58+00:00 | Bike | TD-PH---------- | 4320.0 | 47965.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647089 | 647089 | 2017-06-14 05:18:10+00:00 | Bike | TD-PH---------- | 3877.0 | 46289.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
854221 | 854221 | 2017-08-29 02:42:13+00:00 | Bike | TDS-H--AGL----- | 4026.0 | 45476.60487 | {d9ed8357-6ef0-4cfa-a820-b31a020e2bb4} |
647108 | 647108 | 2017-08-11 05:09:38+00:00 | Bike | TD-PH---------- | 3877.0 | 44545.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647097 | 647097 | 2017-07-01 05:10:02+00:00 | Bike | TD-PH---------- | 3776.0 | 43608.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
1639743 | 1639743 | 2014-05-01 12:30:09+00:00 | RedBull | --------------- | 43343.0 | {18979252-0458-4ea3-a750-dc3ff28f8cda} | |
647151 | 647151 | 2017-12-15 06:16:01+00:00 | Bike | TD-PH---------- | 3698.0 | 43328.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
2490695 | 2490695 | 2017-12-15 06:16:01+00:00 | Bike | TD-PH---------- | 3698.0 | 43328.3 | {7e63dd42-48f0-4d2b-896e-62f5e22c8e88} |
647022 | 647022 | 2016-07-28 05:28:07+00:00 | Bike | TD-PH---------- | 3300.0 | 43288.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647063 | 647063 | 2017-04-18 05:58:56+00:00 | Bike | TD-PH---------- | 3693.0 | 43144.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
1849017 | 1849017 | 2015-04-11 23:06:39+00:00 | Bike | TDS-HC--------- | 3199.0 | 42949.16667 | {6a367d72-dce2-45f1-8193-0bbb0430845f} |
1910560 | 1910560 | 2016-08-22 06:17:48+00:00 | TDSPHC-AGL-E--- | 960215001.0 | 42949.00154 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
656141 | 656141 | 2018-05-12 05:10:45+00:00 | Bike | TD-PHC-A-L-E--- | 2705.0 | 42949.0 | {18cece44-5338-4e6e-9e8d-0da4f6004e35} |
1684400 | 1684400 | 2018-02-28 10:46:00+00:00 | Bike | TD-PHC-AGL-EV-- | 6901.0 | 42949.0 | {abf4bf77-5b84-4dd9-a3e8-7bac69f88718} |
55392 | 55392 | 2019-07-20 04:50:15+00:00 | Bike | TDS-H--AGL-E--- | 3313.0 | 42940.3 | {682707bf-7518-4412-a1c2-81908ce639a3} |
595685 | 595685 | 2014-06-04 13:14:17+00:00 | Run | TDS-H--AGL----- | 1036.0 | 42935.8 | {bf187e62-5915-41f3-bcfc-80b06a434b85} |
595588 | 595588 | 2013-06-11 20:14:08+00:00 | Run | TDS-H--AGL----- | 284.0 | 42924.39333 | {bf187e62-5915-41f3-bcfc-80b06a434b85} |
1917144 | 1917144 | 2016-07-31 13:08:51+00:00 | TDS----AGL----- | 17594.0 | 42599.4 | {d8002754-78b3-4190-9623-4dee0e44aeac} | |
647037 | 647037 | 2016-12-29 06:26:20+00:00 | Bike | TD-PH---------- | 3665.0 | 42181.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647058 | 647058 | 2017-03-30 05:41:35+00:00 | Bike | TD-PH---------- | 3547.0 | 41871.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647116 | 647116 | 2017-08-27 07:54:30+00:00 | Bike | TD-PH---------- | 3699.0 | 40679.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
1294203 | 1294203 | 2018-01-13 12:06:10+00:00 | Bike | TD-PH--AGL----- | 12730.0 | 40605.9 | {fde35fe9-5c6c-4c46-a3af-bfcff42eef13} |
647010 | 647010 | 2016-06-03 06:58:59+00:00 | Bike | TD-PH---------- | 3590.0 | 40594.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647299 | 647299 | 2018-09-11 07:53:48+00:00 | Bike | TDSPH---G------ | 6135.0 | 40569.50767 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647006 | 647006 | 2016-04-07 05:23:06+00:00 | Bike | TD-PH---------- | 3415.0 | 40111.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647115 | 647115 | 2017-08-23 05:19:51+00:00 | Bike | TD-PH---------- | 3547.0 | 39748.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647059 | 647059 | 2017-04-01 05:19:09+00:00 | Bike | TD-PH---------- | 3660.0 | 39684.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
552250 | 552250 | 2014-04-20 06:36:51+00:00 | Bike | TDS-HC-AGL----- | 30562.0 | 39620.4 | {0bbd1f9b-27c0-4c86-bf8c-67d11120d5e1} |
647014 | 647014 | 2016-06-10 05:18:56+00:00 | Bike | TD-PH---------- | 3502.0 | 39614.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647118 | 647118 | 2017-09-06 05:21:36+00:00 | Bike | TD-PH---------- | 3479.0 | 38864.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647317 | 647317 | 2018-11-04 07:41:38+00:00 | Bike | TDSPH---------- | 4769.0 | 38689.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
1294202 | 1294202 | 2018-01-09 16:10:06+00:00 | Bike | TD-PH--AGL----- | 10957.0 | 38005.3 | {fde35fe9-5c6c-4c46-a3af-bfcff42eef13} |
647008 | 647008 | 2016-05-25 05:19:46+00:00 | Bike | TD-PH---------- | 3547.0 | 37909.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647015 | 647015 | 2016-06-17 05:15:54+00:00 | Bike | TD-PH---------- | 3360.0 | 37478.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647007 | 647007 | 2016-04-27 05:34:04+00:00 | Bike | TD-PH---------- | 3051.0 | 37094.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
46825 | 46825 | 2017-09-02 16:13:31+00:00 | TDSPHC-AGL-EV-- | 3304070001.0 | 36920.60379 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
647117 | 647117 | 2017-09-05 05:15:52+00:00 | Bike | TD-PH---------- | 3415.0 | 36372.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647124 | 647124 | 2017-09-21 05:13:36+00:00 | Bike | TD-PH---------- | 3406.0 | 35860.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647065 | 647065 | 2017-04-26 05:15:10+00:00 | Bike | TD-PH---------- | 3350.0 | 35791.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647057 | 647057 | 2017-03-28 05:21:03+00:00 | Bike | TD-PH---------- | 3051.0 | 35462.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647123 | 647123 | 2017-09-19 05:23:30+00:00 | Bike | TD-PH---------- | 3659.0 | 35334.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647130 | 647130 | 2017-09-29 05:14:34+00:00 | Bike | TD-PH---------- | 3349.0 | 35302.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647127 | 647127 | 2017-09-26 05:17:28+00:00 | Bike | TD-PH---------- | 3659.0 | 34885.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647005 | 647005 | 2016-04-01 05:34:28+00:00 | Bike | TD-PH---------- | 2969.0 | 34680.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647053 | 647053 | 2017-03-14 06:19:08+00:00 | Bike | TD-PH---------- | 3659.0 | 34445.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
646999 | 646999 | 2016-03-15 06:24:42+00:00 | Bike | TD-PH---------- | 3415.0 | 34381.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
646997 | 646997 | 2016-03-10 06:30:57+00:00 | Bike | TD-PH---------- | 3415.0 | 34377.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
1910580 | 1910580 | 2016-09-19 07:53:00+00:00 | TDSPHC-AGL-E--- | 802732001.0 | 34057.70222 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
2223358 | 2223358 | 2019-01-23 07:18:17+00:00 | Bike | -DSP---A-L----- | 1.0 | 33010.6 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
647095 | 647095 | 2017-06-27 05:23:46+00:00 | Bike | TD-PH---------- | 2959.0 | 32885.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647018 | 647018 | 2016-06-28 05:28:40+00:00 | Bike | TD-PH---------- | 2825.0 | 32629.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647082 | 647082 | 2017-06-06 05:36:41+00:00 | Bike | TD-PH---------- | 2794.0 | 32409.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647214 | 647214 | 2018-03-13 06:20:03+00:00 | Bike | TD-PH---------- | 3045.0 | 32361.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
2490758 | 2490758 | 2018-03-13 06:20:03+00:00 | Bike | TD-PH---------- | 3045.0 | 32361.5 | {7e63dd42-48f0-4d2b-896e-62f5e22c8e88} |
2234966 | 2234966 | 2017-08-21 10:20:30+00:00 | TDS-HC-AGL-E--- | 29865.0 | 31738.2 | {86647806-2695-4a7c-9e64-0c30ac259bd2} | |
647096 | 647096 | 2017-06-29 06:04:22+00:00 | Bike | TD-PH---------- | 2969.0 | 31403.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
551156 | 551156 | 2019-02-07 13:10:58+00:00 | Bike | TD-PH---------- | 10001.0 | 31274.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
551184 | 551184 | 2019-03-21 13:09:56+00:00 | Bike | -D-PH---------- | 1.0 | 31264.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
647066 | 647066 | 2017-04-27 05:31:04+00:00 | Bike | TD-PH---------- | 2836.0 | 31080.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647125 | 647125 | 2017-09-22 05:18:40+00:00 | Bike | TD-PH---------- | 2633.0 | 30172.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647129 | 647129 | 2017-09-28 05:32:56+00:00 | Bike | TD-PH---------- | 2867.0 | 29702.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
551185 | 551185 | 2019-03-25 11:06:26+00:00 | Bike | -D-PH---------- | 1.0 | 29547.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
647111 | 647111 | 2017-08-15 05:39:19+00:00 | Bike | TD-PH---------- | 2347.0 | 29389.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
551082 | 551082 | 2018-10-02 11:14:25+00:00 | Bike | -DSP----------- | 1.0 | 29141.00817 | {5353813e-daab-4089-98d2-f51864e09bd0} |
647040 | 647040 | 2017-01-14 08:48:43+00:00 | Bike | TD-PH---------- | 3699.0 | 29140.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
550999 | 550999 | 2018-04-25 17:37:33+00:00 | Bike | -DSP----------- | 1.0 | 28645.00214 | {5353813e-daab-4089-98d2-f51864e09bd0} |
550995 | 550995 | 2018-04-20 10:27:30+00:00 | Bike | -DSP----------- | 1.0 | 28465.00228 | {5353813e-daab-4089-98d2-f51864e09bd0} |
264955 | 264955 | 2018-11-06 17:56:48+00:00 | TDS-HC--------- | 3265360001.0 | 28101.8 | {0aa89ce6-0350-45a5-b6f5-0b584ffe2462} | |
647128 | 647128 | 2017-09-27 05:19:52+00:00 | Bike | TD-PH---------- | 2998.0 | 27303.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647001 | 647001 | 2016-03-17 06:28:23+00:00 | Bike | TD-PH---------- | 2312.0 | 27203.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
220464 | 220464 | 2018-02-15 13:16:54+00:00 | TDSPHC-AGL-EV-- | 3406810001.0 | 27032.9 | {4f653f36-e2da-47d2-b65c-04c935c72a54} | |
1522197 | 1522197 | 2019-01-15 18:21:48+00:00 | TDSPHC-AGL-EV-R | 2544.0 | 26992.30063 | {4b213def-3979-4380-b5d2-617a9e269652} | |
647049 | 647049 | 2017-02-15 07:09:23+00:00 | Bike | TD-PH---------- | 3698.0 | 26499.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
2588065 | 2588065 | 2019-02-08 00:39:23+00:00 | TDSP-C-AGL-E--- | 17079.0 | 26441.20163 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
647041 | 647041 | 2017-01-20 06:14:03+00:00 | Bike | TD-PH---------- | 3699.0 | 26019.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
647045 | 647045 | 2017-01-25 06:21:16+00:00 | Bike | TD-PH---------- | 2313.0 | 25968.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
646966 | 646966 | 2016-01-09 09:28:55+00:00 | Bike | TD-PH---G------ | 4004.0 | 25533.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
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");