rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by workout_time descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time ▲ | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1757177 | 1757177 | 2016-08-29 12:47:22+00:00 | TDSPHC-AGL-EV-- | 3453560001.0 | 24985.00646 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 2587463 | 2587463 | 2017-06-03 22:14:17+00:00 | TDSPHC-AGL-EV-- | 3421180001.0 | 1766.84774 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 220464 | 220464 | 2018-02-15 13:16:54+00:00 | TDSPHC-AGL-EV-- | 3406810001.0 | 27032.9 | {4f653f36-e2da-47d2-b65c-04c935c72a54} | |
| 46824 | 46824 | 2017-08-31 16:57:34+00:00 | TDSPHC-AGL-EV-- | 3405060001.0 | 5.42759 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
| 2437099 | 2437099 | 2016-12-10 15:59:19+00:00 | Bike | TDSPHC-AGL-EV-- | 3404400001.0 | 6711.54 | {4b1ede08-6163-4bfa-bc74-c58ae4d2dc2b} |
| 1757176 | 1757176 | 2016-08-27 07:52:13+00:00 | TDSPHC-AGL-EV-- | 3403880001.0 | 87.8285 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 46827 | 46827 | 2017-09-23 07:30:17+00:00 | TDSPHC-AGL-EV-- | 3403630001.0 | 6838.66861 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
| 46823 | 46823 | 2017-08-26 11:05:32+00:00 | Bike | TDSPHC-AGL-EV-- | 3391300001.0 | 2673.9022 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} |
| 46826 | 46826 | 2017-09-17 16:48:51+00:00 | TDSPHC-AGL-EV-- | 3382160001.0 | 6065.38201 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
| 1757174 | 1757174 | 2016-08-22 05:50:38+00:00 | TDSPHC-AGL-EV-- | 3371580001.0 | 15028.00734 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 1060188 | 1060188 | 2018-05-19 07:51:32+00:00 | TDSPHC-AGL-EV-- | 3335220001.0 | 2209.22229 | {03ca9de9-5379-4bdf-9e7a-c9748c937452} | |
| 46825 | 46825 | 2017-09-02 16:13:31+00:00 | TDSPHC-AGL-EV-- | 3304070001.0 | 36920.60379 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
| 1282138 | 1282138 | 2016-10-17 09:57:51+00:00 | TDSPHC-AGL-EV-- | 3265290001.0 | 18645.1 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
| 1757173 | 1757173 | 2016-08-21 07:00:49+00:00 | TDSPHC-AGL-EV-- | 3200480001.0 | 19021.40719 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 1757175 | 1757175 | 2016-08-25 05:07:03+00:00 | TDSPHC-AGL-EV-- | 3164530001.0 | 1618.08752 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 1282092 | 1282092 | 2016-09-05 08:55:58+00:00 | TDSP-C-AGL-EV-- | 3134330001.0 | 8806.75 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
| 1949354 | 1949354 | 2016-04-17 12:42:45+00:00 | Bike | TDSP-C-AGL-EV-- | 3094120001.0 | 138.36831 | {183916d7-1d2a-4117-a9b2-31824ed66fbc} |
| 1202009 | 1202009 | 2020-01-19 19:56:36+00:00 | Bike | TDSPHC-AGL-EV-- | 3043170001.0 | 109.66995 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} |
| 2587433 | 2587433 | 2017-05-03 00:19:58+00:00 | TDSP-C-AGL-E--- | 3032090001.0 | 24408.20709 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 1201993 | 1201993 | 2019-12-30 17:50:17+00:00 | TDSPHC-AGL-EV-- | 2880780001.0 | 4865.74242 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} | |
| 1452835 | 1452835 | 2019-11-15 21:13:07+00:00 | Bike | TDSP-C-AGL-EV-- | 2737830001.0 | 203.342 | {3efb16ec-07f3-4996-8157-3b29a11e55f3} |
| 891764 | 891764 | 2014-07-23 06:40:29+00:00 | Bike | TDSPHC-AGL-E--- | 2465990001.0 | 9060.34137 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 892100 | 892100 | 2015-08-20 08:13:39+00:00 | Bike | TDSPHC-AGL-E--- | 2465990001.0 | 9060.34137 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 1188661 | 1188661 | 2020-05-23 05:06:23+00:00 | TDSPHC-AGL-EVO- | 2331140001.0 | 0.06057 | {11176adc-4b3d-4532-8544-d29fe0b88199} | |
| 2588214 | 2588214 | 2019-08-12 05:51:28+00:00 | TDSP-C-AGL-E--- | 2223140001.0 | 7780.02492 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 185551 | 185551 | 2000-07-30 17:37:18+00:00 | TDSPHC-AGL-EV-- | 2083830001.0 | 0.02483 | {a042f83c-2b84-4abc-8b0d-8c726a236239} | |
| 860600 | 860600 | 1989-12-31 11:24:48+00:00 | Bike | TDSPHC-AGL-E--- | 1634540001.0 | 44.1465 | {5c85dcdc-c315-44d2-8783-389a83921c4d} |
| 860602 | 860602 | 1989-12-31 15:14:38+00:00 | Bike | TDSPHC-AGL-E--- | 1146950001.0 | 57.9529 | {5c85dcdc-c315-44d2-8783-389a83921c4d} |
| 1746428 | 1746428 | 1990-07-13 04:37:19+00:00 | TDSPH--AGL-E--- | 1124070001.0 | {efedc7e0-6cfa-4f05-ac3a-6ea3eb27676b} | ||
| 2588193 | 2588193 | 2019-07-15 13:19:42+00:00 | TD-P-C-A-L-E--- | 989068001.0 | 4313.91 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 1910560 | 1910560 | 2016-08-22 06:17:48+00:00 | TDSPHC-AGL-E--- | 960215001.0 | 42949.00154 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
| 860601 | 860601 | 1989-12-31 14:36:19+00:00 | TDSPH--AGL-E--- | 904379001.0 | 23488.6 | {5c85dcdc-c315-44d2-8783-389a83921c4d} | |
| 1910580 | 1910580 | 2016-09-19 07:53:00+00:00 | TDSPHC-AGL-E--- | 802732001.0 | 34057.70222 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
| 550602 | 550602 | 2016-03-12 14:13:04+00:00 | TDSPHC-AGL----- | 767613001.0 | 39.1863 | {5353813e-daab-4089-98d2-f51864e09bd0} | |
| 550596 | 550596 | 2016-03-06 14:27:24+00:00 | TDSPHC-AGL----- | 767092001.0 | 15.0576 | {5353813e-daab-4089-98d2-f51864e09bd0} | |
| 2341635 | 2341635 | 2020-05-05 00:01:38+00:00 | Bike | TDSP-C-AGL-E--- | 653362001.0 | 103.33394 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
| 1679193 | 1679193 | 1999-08-22 00:00:18+00:00 | Bike | TDSP-C-A-L-E--- | 651772001.0 | 20.3411 | {5dc91693-ea82-4268-83a0-a5c44e0bd33a} |
| 1030534 | 1030534 | 2020-01-03 00:07:09+00:00 | Bike | TDSPHC-AGL-E--- | 642763001.0 | 26.12062 | {1db2d738-ee9d-4ff2-8ceb-18e90f281bde} |
| 1030524 | 1030524 | 2019-11-30 00:00:11+00:00 | Bike | TDSPHC-AGL-E--- | 639826001.0 | 73.6783 | {1db2d738-ee9d-4ff2-8ceb-18e90f281bde} |
| 2341592 | 2341592 | 1999-08-22 00:01:45+00:00 | Bike | TDSP-C-AGL-E--- | 635511001.0 | 24.38343 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
| 2341589 | 2341589 | 1999-08-22 00:00:38+00:00 | Bike | TDSP-C-AGL-E--- | 635375001.0 | 37.13633 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
| 2341590 | 2341590 | 1999-08-22 00:01:02+00:00 | Bike | TDSP-C-AGL-E--- | 629680001.0 | 44.0534 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
| 919950 | 919950 | 2017-06-06 20:41:41+00:00 | TDSPHC-AGL-EV-- | 627456001.0 | 11841.1 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} | |
| 1867614 | 1867614 | 2020-01-09 20:54:29+00:00 | Bike | TDSP-C-A-L----- | 619399001.0 | 0.23866 | {7efc5625-f856-4a15-9089-11b76f8979f2} |
| 1867518 | 1867518 | 2019-04-21 11:30:30+00:00 | Bike | TDSP-C-AGL----- | 619319001.0 | 0.00875 | {7efc5625-f856-4a15-9089-11b76f8979f2} |
| 1792478 | 1792478 | 2020-04-23 04:10:02+00:00 | Bike | TDSPHC-AGL----- | 619316001.0 | 7.4482 | {6637cc35-f314-4448-b32b-aae24d42905c} |
| 1282548 | 1282548 | 2017-12-24 08:08:48+00:00 | Bike | TDSPHC-AGL----- | 618724001.0 | 123.967 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} |
| 1858266 | 1858266 | 2018-03-14 18:06:33+00:00 | Bike | TDSPHC-AGL-E--- | 618715001.0 | 35.0028 | {1e518c35-d331-4d7f-8df7-195f7ca9faaa} |
| 2216388 | 2216388 | 2018-10-17 08:08:59+00:00 | Bike | TDSPHC-AGL-E--- | 618422001.0 | 1.20664 | {f302a094-a06f-4218-8735-5f1867fef0b3} |
| 1299489 | 1299489 | 2019-05-18 05:11:27+00:00 | Bike | TDSPHC-AGL-EV-- | 618188001.0 | 108.092 | {d2e9643e-3681-408f-afd5-48b646180891} |
| 1068058 | 1068058 | 2019-07-02 12:18:19+00:00 | Bike | TDSPHC-AGL-E--- | 618109001.0 | 21.21 | {204e4cf7-7992-439a-8252-fd0a74e6c749} |
| 1713652 | 1713652 | 2018-03-03 19:25:47+00:00 | Bike | TDSPHC-AGL-EV-- | 617830001.0 | 91.05639 | {95ed433d-ab1c-4a69-989c-f05028fac2f9} |
| 800483 | 800483 | 2017-08-23 06:15:56+00:00 | Bike | TDSPHC-AGL-E--- | 617515001.0 | 102.915 | {d8814b25-9784-4348-9569-40847a564782} |
| 476777 | 476777 | 2019-06-08 07:25:11+00:00 | Bike | TDSPHC-AGL-EV-- | 613954001.0 | 108.69733 | {95e8e781-7722-4311-9102-3ed1089cc60b} |
| 2561943 | 2561943 | 2019-07-30 08:49:32+00:00 | Bike | TDSPHC-AGL-E--- | 609438001.0 | 32.9399 | {87020647-5bd4-47c3-a37e-ac70042794ba} |
| 1948669 | 1948669 | 2018-10-24 00:00:53+00:00 | Bike | TDSP-C-AGL-E--- | 605096001.0 | 22.9453 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 1349896 | 1349896 | 1999-08-22 00:01:15+00:00 | Bike | TDSPHC-AGL-E--- | 603835001.0 | 27.8901 | {1dc7c187-3560-49eb-8f48-417a7bfa6fa9} |
| 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} |
| 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} |
| 561604 | 561604 | 2019-04-01 11:15:21+00:00 | Bike | TDSPHC-AGL----- | 580608001.0 | 1.32917 | {71758615-f396-4e58-8b55-50ea2b7a340b} |
| 2424948 | 2424948 | 1999-08-22 00:00:06+00:00 | Bike | TDSPHC-AGL-EV-- | 580097001.0 | 28.6948 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 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} |
| 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} |
| 891537 | 891537 | 2013-08-22 00:00:15+00:00 | Bike | TDSPHC-AGLWE--- | 524072001.0 | 34.9338 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 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} |
| 1043827 | 1043827 | 2018-02-18 22:25:38+00:00 | TDSP-CN-------- | 411568001.26 | 151.84884 | {00e5b674-79ae-486f-ad31-23eaf55bb820} | |
| 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} |
| 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} |
| 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} |
| 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} |
| 450383 | 450383 | 2018-05-13 18:17:44+00:00 | Bike | TDSP-C-AGL-EV-- | 263695001.0 | 2.5945 | {bfcfe8da-0615-4a17-932e-e1cc7f9b8588} |
| 2465911 | 2465911 | 2019-01-05 08:08:07+00:00 | Bike | TDSPHC-AGL-E--- | 251614001.0 | 139.19868 | {36413bd0-f129-4a03-9dad-25e804f20b50} |
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");