rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by workout_time descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time ▲ | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 476777 | 476777 | 2019-06-08 07:25:11+00:00 | Bike | TDSPHC-AGL-EV-- | 613954001.0 | 108.69733 | {95e8e781-7722-4311-9102-3ed1089cc60b} |
| 906383 | 906383 | 2019-06-15 06:46:46+00:00 | Bike | TDS-H--AGL-E--- | 613887001.0 | 60.98728 | {069b28a9-6a90-4a3a-a264-df9848f0e5c2} |
| 2561943 | 2561943 | 2019-07-30 08:49:32+00:00 | Bike | TDSPHC-AGL-E--- | 609438001.0 | 32.9399 | {87020647-5bd4-47c3-a37e-ac70042794ba} |
| 2317403 | 2317403 | 2019-08-20 15:30:08+00:00 | Bike | TDS-H--AGL-E--- | 607603001.0 | 23.6306 | {98754f14-566a-444f-82d0-6ec1348f73de} |
| 906420 | 906420 | 2019-08-29 16:06:19+00:00 | Bike | TDS-H--AGL-E--- | 607225001.0 | 58.95184 | {069b28a9-6a90-4a3a-a264-df9848f0e5c2} |
| 2259108 | 2259108 | 2019-09-15 11:13:48+00:00 | Bike | TDS----AGL-E--- | 605367001.0 | 8.97495 | {647b413b-7683-4061-97bd-c318ac5cb439} |
| 1948669 | 1948669 | 2018-10-24 00:00:53+00:00 | Bike | TDSP-C-AGL-E--- | 605096001.0 | 22.9453 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 906436 | 906436 | 2019-09-23 07:44:59+00:00 | Bike | TDS-H--AGL-E--- | 604802001.0 | 94.34113 | {069b28a9-6a90-4a3a-a264-df9848f0e5c2} |
| 1349896 | 1349896 | 1999-08-22 00:01:15+00:00 | Bike | TDSPHC-AGL-E--- | 603835001.0 | 27.8901 | {1dc7c187-3560-49eb-8f48-417a7bfa6fa9} |
| 2486585 | 2486585 | 1999-08-22 00:00:06+00:00 | Bike | TDS-HC-AGL-E--- | 603606001.0 | 75.7985 | {178bdfb5-5c23-46af-b609-fc020ade43c0} |
| 1350027 | 1350027 | 2018-09-25 18:06:05+00:00 | Bike | TDSP-C-AGL-E--- | 602625001.0 | 32.3697 | {1dc7c187-3560-49eb-8f48-417a7bfa6fa9} |
| 280248 | 280248 | 2019-12-14 08:07:49+00:00 | Bike | TDSPHC-AGL-E--- | 597611001.0 | 81.7145 | {8b1597ea-3301-4f9e-b80a-d65f3a9161cf} |
| 292945 | 292945 | 2019-12-22 11:59:29+00:00 | Bike | TDSP-C-AGL-E--- | 596894001.0 | 23.41444 | {98fafa66-c9de-4f97-afec-fd1a2c9ce43c} |
| 2426137 | 2426137 | 2018-06-03 23:11:13+00:00 | Bike | TDSPHC-AGL-EV-- | 592784001.0 | 13.751 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 2426135 | 2426135 | 2018-06-02 03:00:00+00:00 | Bike | TDSPHC-AGL-EV-- | 592633001.0 | 19.9069 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 1539859 | 1539859 | 2018-09-08 09:59:29+00:00 | Bike | TDS-H--AGL-E--- | 592494001.0 | 80.997 | {b2d60fc8-55c0-42d1-8e83-a134f3276e71} |
| 871575 | 871575 | 1999-08-22 00:14:48+00:00 | Bike | TDSP-C-AGL-EV-- | 588849001.0 | 13.4604 | {e3085401-90f8-4ea3-9465-c38d1ca866aa} |
| 1948493 | 1948493 | 2018-02-10 00:01:19+00:00 | Bike | TDSP-C-AGL-E--- | 582944001.0 | 22.6738 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 1948491 | 1948491 | 2018-02-03 00:00:21+00:00 | Bike | TDSP-C-AGL-E--- | 582345001.0 | 22.5929 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 1948489 | 1948489 | 2018-01-14 00:00:32+00:00 | Bike | TDS----AGL-E--- | 580617001.0 | 40.8972 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 561604 | 561604 | 2019-04-01 11:15:21+00:00 | Bike | TDSPHC-AGL----- | 580608001.0 | 1.32917 | {71758615-f396-4e58-8b55-50ea2b7a340b} |
| 476273 | 476273 | 1999-08-22 01:00:08+00:00 | Bike | TDS-H--AGL-E--- | 580603001.0 | 8.80122 | {4eeb2167-3f39-441c-9bf3-d55d411d50b2} |
| 2424948 | 2424948 | 1999-08-22 00:00:06+00:00 | Bike | TDSPHC-AGL-EV-- | 580097001.0 | 28.6948 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 1580937 | 1580937 | 2017-06-07 21:40:01+00:00 | Bike | TDS-HC-AGL-E--- | 580009001.0 | 30.1237 | {c231317d-303d-45fa-9d80-f6a1b5d2b034} |
| 2424949 | 2424949 | 1999-08-22 00:02:54+00:00 | Bike | TDSPHC-AGL-EV-- | 579737001.0 | 8.14101 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 1948482 | 1948482 | 2017-12-29 00:03:13+00:00 | Bike | TDSP-C-AGL-E--- | 579242001.0 | 22.716 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 2453566 | 2453566 | 2017-12-21 23:01:01+00:00 | Bike | TDSPHC-AGL----- | 578703001.0 | 83.66476 | {24130e1a-fb17-4451-a1b0-cd6cb18506ed} |
| 243943 | 243943 | 2017-12-22 01:08:11+00:00 | Bike | TDSP-C-AGL-E--- | 578668001.0 | 31.4746 | {520ab984-0756-4b49-8330-9d0c53585e8b} |
| 2055466 | 2055466 | 1999-08-22 01:31:31+00:00 | Bike | TDS-HC-AGL-E--- | 573989001.0 | 76.73194 | {c9a75194-79de-4ead-8cac-abfcefde3c57} |
| 1622352 | 1622352 | 2000-01-06 00:04:15+00:00 | Bike | TDS-HC-AGL-E--- | 565794001.0 | 17.915 | {8092c75f-62aa-4924-b036-838884869997} |
| 2394443 | 2394443 | 2017-07-02 04:30:23+00:00 | Bike | TDSPHC-AGL----- | 561281001.0 | 136.66065 | {d1d0a4ca-2083-48a6-a31d-87e6dfa46ae4} |
| 1281453 | 1281453 | 2014-10-08 10:09:18+00:00 | Bike | TDSP-C-AGL-EV-- | 543719001.0 | 28.0774 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} |
| 1030748 | 1030748 | 1999-08-22 00:00:52+00:00 | Bike | TD-----AGL-E--- | 538853001.0 | 0.00011 | {144beb91-ca43-4f6d-8629-6d00ea70beca} |
| 808012 | 808012 | 2009-02-14 20:07:24+00:00 | Bike | TDS-H--AGL----- | 530597001.0 | 509.928 | {f035c04c-be77-4ab9-b3c0-4ff6235a57bc} |
| 891537 | 891537 | 2013-08-22 00:00:15+00:00 | Bike | TDSPHC-AGLWE--- | 524072001.0 | 34.9338 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 1316677 | 1316677 | 1999-08-22 00:05:25+00:00 | Bike | TDS-H--AGL-E--- | 520450001.0 | 70.4669 | {5615235f-69b7-49c8-91d6-652256aa71dd} |
| 2287603 | 2287603 | 1999-08-22 00:00:46+00:00 | Bike | TDS-H--AGL-E--- | 509031001.0 | 9.5714 | {1ff7eaf8-367a-4355-b69f-31572cc31612} |
| 2456648 | 2456648 | 1999-08-22 00:00:27+00:00 | Bike | TDS-HC-AGL-E--- | 490564001.0 | 24.6485 | {45b8103a-5f83-42d3-8054-24f77ea39213} |
| 1124302 | 1124302 | 1999-08-22 00:00:02+00:00 | Bike | TDS-HC-AGL-E--- | 452772001.0 | 17.6575 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1019701 | 1019701 | 2019-02-28 16:14:13+00:00 | Bike | TDSPHC-AGL-EV-- | 448768001.0 | 38.11998 | {a3a67e0c-1c41-492b-a214-a0a2b2a09610} |
| 244130 | 244130 | 1999-08-22 00:00:32+00:00 | Bike | TDSPHC-AGL-E--- | 440630001.0 | 15.26438 | {86327876-a4f1-4614-8e5d-1d23d30c8e02} |
| 751007 | 751007 | 2017-04-28 02:48:59+00:00 | Bike | TDSPHC-AGL-E--- | 431835001.0 | 36.0849 | {1dbba82e-8924-4b10-b1da-151e8062680a} |
| 654489 | 654489 | 2013-09-18 16:41:42+00:00 | Bike | TDS----AGL-E--- | 430625001.0 | 62.37216 | {d59e8284-a466-4373-84b2-0854103393c3} |
| 1043827 | 1043827 | 2018-02-18 22:25:38+00:00 | TDSP-CN-------- | 411568001.26 | 151.84884 | {00e5b674-79ae-486f-ad31-23eaf55bb820} | |
| 647477 | 647477 | 2018-12-25 07:49:22+00:00 | Bike | TDS-HC-AGL-E--- | 397364001.0 | 68.09143 | {f05dab4d-13a9-452e-b08f-d9aca02813d5} |
| 1204018 | 1204018 | 2018-12-25 07:49:22+00:00 | Bike | TDS-HC-AGL-E--- | 397364001.0 | 68.09143 | {a99a99bd-4e17-4b49-9b7d-810a1cf18400} |
| 214205 | 214205 | 2017-02-18 15:07:10+00:00 | Bike | TDSP-C-AGL-E--- | 387077001.0 | 34.0379 | {45771b3d-0bf8-4bd6-adbf-0fd7ae1a17c0} |
| 448307 | 448307 | 2017-02-18 15:07:10+00:00 | Bike | TDSP-C-AGL-E--- | 387077001.0 | 34.0379 | {d096c44f-a7b7-4549-9931-038d42d62973} |
| 2106451 | 2106451 | 2017-02-18 15:07:10+00:00 | Bike | TDSP-C-AGL-E--- | 387077001.0 | 34.0379 | {f8f34c9a-2649-497f-8e81-653e4c9712dd} |
| 2130453 | 2130453 | 2017-02-18 15:07:10+00:00 | Bike | TDSP-C-AGL-E--- | 387077001.0 | 34.0379 | {37c6b861-8dac-4d3a-9f36-94ba297da8ec} |
| 2081071 | 2081071 | 2014-09-12 00:30:43+00:00 | Bike | TDSPHC-AGL-E--- | 374373001.0 | 16.5868 | {a9edc025-0e5d-4c18-935c-a77e1f29ec95} |
| 787144 | 787144 | 2019-09-13 09:06:22+00:00 | Bike | TDSPHC-AGL-EV-- | 366858001.0 | 15.8957 | {8f4ea470-24bb-4a2a-99f2-bdf4522b6daf} |
| 1023641 | 1023641 | 2018-07-26 13:36:06+00:00 | Bike | TDSPHC-AGL-E--- | 365916001.0 | 89.1847 | {e79e279d-d990-4e4f-a391-f535ae60f0bd} |
| 2449878 | 2449878 | 2018-07-26 14:36:06+00:00 | Bike | TDSPHC-AGL-E--- | 365916001.0 | 89.1847 | {da5ed8b3-41b4-40e5-b0e4-5f8c9c3e4409} |
| 1582314 | 1582314 | 2016-06-21 15:49:14+00:00 | Bike | TDSP-C-AGL-E--- | 353203001.0 | 0.57131 | {e32b8a33-c40d-4b96-bc43-5f2d3180b47c} |
| 142707 | 142707 | 2014-11-26 00:48:46+00:00 | Bike | TDSPHC-AGL-E--- | 341117001.0 | 30.35058 | {bb13fc88-6570-497c-bd13-7521bf30439e} |
| 822907 | 822907 | 2014-11-26 00:48:46+00:00 | Bike | TDSPHC-AGL-E--- | 341117001.0 | 30.35058 | {029abbce-69c2-42fc-ad44-a85541cd98b4} |
| 808013 | 808013 | 2009-02-14 20:53:19+00:00 | Bike | TDS-H--AGL----- | 339730001.0 | 367.201 | {f035c04c-be77-4ab9-b3c0-4ff6235a57bc} |
| 1862427 | 1862427 | 1978-11-02 09:55:23+00:00 | T-SPHC-AG--E--- | 321615001.0 | {f4d64878-666c-484b-a271-fb36494ef432} | ||
| 2467703 | 2467703 | 2016-03-22 17:37:50+00:00 | Bike | TDSPHC-AGL-EV-- | 309664001.0 | 30.81636 | {f5b8bfcf-b234-42aa-8f6b-ba9a339b6088} |
| 2561144 | 2561144 | 2017-09-25 10:47:15+00:00 | Bike | TDS-HC-AGL-E--- | 309664001.0 | 50.6908 | {87020647-5bd4-47c3-a37e-ac70042794ba} |
| 2532715 | 2532715 | 2018-05-03 14:19:39+00:00 | Bike | TDSPHC-AGL-E--- | 309661001.0 | 18.3277 | {bdaa2e96-c1de-4716-a43d-a3730d14de88} |
| 958322 | 958322 | 2019-02-26 03:44:36+00:00 | Bike | TDSPHC-AGL-EV-- | 307249001.0 | 39.6763 | {b3638238-c2d6-4621-923d-f504546ed3f9} |
| 958323 | 958323 | 2019-02-26 03:44:37+00:00 | Bike | TDSPHC-AGL-EV-- | 307249001.0 | 39.6763 | {b3638238-c2d6-4621-923d-f504546ed3f9} |
| 2425061 | 2425061 | 2014-06-30 20:15:14+00:00 | Bike | TDSP-C-AGL-E--- | 300590001.0 | 25.68948 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 984766 | 984766 | 2007-04-01 00:00:09+00:00 | TDS----AGL----- | 296046001.0 | 29.1346 | {03542747-6d9b-4663-9d97-11e402ab8c54} | |
| 692754 | 692754 | 2016-07-03 08:54:07+00:00 | TDS--C-AGL----- | 293900001.0 | 62.1226 | {0a874fe8-b4c3-4cc2-9b62-381f80e30005} | |
| 810877 | 810877 | 2007-04-01 02:49:41+00:00 | TDS----AGL----- | 293130001.0 | 7.0046 | {ee639b1f-5693-4c9c-bbbe-282f8717844f} | |
| 1086002 | 1086002 | 2017-09-03 22:50:24+00:00 | Bike | TDSPHC-AGL-E--- | 292156001.0 | 23.70871 | {3190bec0-d5bd-4914-97ac-1a5d94b53019} |
| 1879127 | 1879127 | 2018-05-23 12:52:02+00:00 | Bike | TDSPHC-AGL-EV-- | 287896001.0 | 70.45555 | {29f05dee-e8a6-41c4-9ae2-cf6b653d6214} |
| 2081108 | 2081108 | 2014-10-30 00:21:04+00:00 | Bike | TDSP-C-AGL-E--- | 275791001.0 | 16.63435 | {a9edc025-0e5d-4c18-935c-a77e1f29ec95} |
| 2287776 | 2287776 | 2015-06-20 08:00:19+00:00 | Bike | TDS-H--AGL-E--- | 269142001.0 | 18.8762 | {1ff7eaf8-367a-4355-b69f-31572cc31612} |
| 450383 | 450383 | 2018-05-13 18:17:44+00:00 | Bike | TDSP-C-AGL-EV-- | 263695001.0 | 2.5945 | {bfcfe8da-0615-4a17-932e-e1cc7f9b8588} |
| 621536 | 621536 | 2009-12-13 00:14:34+00:00 | Run | TDS-H--AGL----- | 254143001.0 | 4.02444 | {0d5cb1a6-bcea-4df7-8e14-c07fa95a2e74} |
| 2465911 | 2465911 | 2019-01-05 08:08:07+00:00 | Bike | TDSPHC-AGL-E--- | 251614001.0 | 139.19868 | {36413bd0-f129-4a03-9dad-25e804f20b50} |
| 984767 | 984767 | 2007-04-01 00:06:56+00:00 | TDS-H--AGL----- | 244485001.0 | 13.7081 | {03542747-6d9b-4663-9d97-11e402ab8c54} | |
| 1216007 | 1216007 | 2014-09-28 00:00:39+00:00 | Run | TDS----AGL----- | 236505001.0 | 5.71276 | {3b4457fb-7c69-48c9-8cc9-5762fc08563d} |
| 1855450 | 1855450 | 2019-11-27 21:52:20+00:00 | Bike | TDSPHC-AGL-E--- | 229824001.0 | 0.41585 | {37bef97a-2b4c-4b02-9c1e-61b04bf49ad2} |
| 385990 | 385990 | 2007-04-01 14:11:44+00:00 | Run | TDS-H--AGL----- | 228012001.0 | 6.94297 | {79c247de-f880-4c1e-a2d0-afefbd9762c4} |
| 2243785 | 2243785 | 2009-12-13 00:00:27+00:00 | Run | TDS----AGL----- | 197103001.0 | 6.41651 | {6a0003a3-7be5-469b-93dd-7d5daf0ead9a} |
| 385991 | 385991 | 2007-04-01 16:57:53+00:00 | Run | TDS-H--AGL----- | 189304001.0 | 5.31858 | {79c247de-f880-4c1e-a2d0-afefbd9762c4} |
| 1645409 | 1645409 | 2019-03-18 02:58:16+00:00 | Bike | TDS--C-AGL-E--- | 159064001.0 | 8.691 | {dfe0af3c-4060-4fe2-bf8b-d7c19d0a044b} |
| 1904822 | 1904822 | 2019-08-08 15:00:25+00:00 | SLC | TDSPHC-AGL-E--- | 154834001.0 | 40.97393 | {5c849db5-a881-44e5-b0ce-eee9c92cd971} |
| 1307284 | 1307284 | 2015-01-06 20:04:17+00:00 | Bike | TDSP-C-AGL----- | 153622001.0 | 5.30058 | {981e9153-4990-4507-86d7-ac8aff897fcb} |
| 1830400 | 1830400 | 2018-12-09 09:20:27+00:00 | Bike | TDS----AGL----- | 153291001.0 | 123.571 | {0477ed5c-9cd8-4610-9036-763ce8d6c19a} |
| 264950 | 264950 | 2018-10-30 17:52:22+00:00 | TD--HC--------- | 152389001.0 | 10619.6 | {0aa89ce6-0350-45a5-b6f5-0b584ffe2462} | |
| 801403 | 801403 | 2016-05-03 04:12:10+00:00 | Bike | TDS-HC-AGL-E--- | 145765001.0 | 57.2719 | {1614eb21-5dce-4a12-afdf-017248d5e64d} |
| 801404 | 801404 | 2016-05-03 04:12:11+00:00 | Bike | TDS-HC-AGL-E--- | 145765001.0 | 57.2719 | {1614eb21-5dce-4a12-afdf-017248d5e64d} |
| 550336 | 550336 | 2014-08-31 17:50:28+00:00 | Bike | TDSPHC-AGL----- | 145091001.0 | 29.5302 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 1187581 | 1187581 | 2016-12-20 18:44:31+00:00 | Bike | TDSP-C-AGL-EV-- | 143948001.0 | 36.31405 | {46228d0d-8bb8-427b-be6b-721074425c28} |
| 2432506 | 2432506 | 2011-11-23 16:01:15+00:00 | Bike | TD-----AGL----- | 138796001.0 | 18.6091 | {31687531-a279-4c55-9a20-b552ffbd5d69} |
| 1948219 | 1948219 | 2016-05-31 22:44:13+00:00 | Bike | TDSP-C-AGL-E--- | 138502001.0 | 11.91803 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 2305391 | 2305391 | 2019-01-12 10:08:29+00:00 | Bike | TDS-H--AGL-E--- | 136708001.0 | 10.19031 | {61cd5d84-a180-49a4-a4a1-b54bfded4565} |
| 1548660 | 1548660 | 2015-01-01 01:21:54+00:00 | Run | TDS-HC-AGL----R | 136288001.0 | 4.68921 | {3f4bbcec-2eb8-4b4f-9f58-d6581381b284} |
| 2090857 | 2090857 | 2014-10-26 15:11:52+00:00 | Bike | TDS----AGL-E--- | 123577001.0 | 10.8545 | {567cd049-8b1f-41f1-92c6-cd53e30edf60} |
| 715795 | 715795 | 2017-05-10 15:35:16+00:00 | Bike | TDS-HC-AGL-E--- | 120360001.0 | 32.21021 | {1d7145e3-2efb-4bca-98b8-0e7c0e71147f} |
| 775203 | 775203 | 2017-05-10 15:35:16+00:00 | Bike | TDS-HC-AGL-E--- | 120360001.0 | 32.21021 | {319d9aba-66f2-4b6c-bcfb-1d1140fbc460} |
| 1948040 | 1948040 | 2015-07-27 20:29:21+00:00 | Bike | TDSP-C-AGL-E--- | 119150001.0 | 28.4871 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 1610651 | 1610651 | 2019-02-27 14:28:22+00:00 | Bike | TDSPHC-AGL----- | 117339001.0 | 49.6544 | {bf112bad-2d34-4ff4-be9c-b7b2129f5a39} |
| 1388816 | 1388816 | 2016-11-29 09:36:44+00:00 | Bike | TDS-H--AGL-E--- | 115532001.0 | 103.85398 | {2ca5f6b7-65e3-4bf0-aea4-5b433bbb927a} |
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");