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 |
|---|---|---|---|---|---|---|---|
| 1855450 | 1855450 | 2019-11-27 21:52:20+00:00 | Bike | TDSPHC-AGL-E--- | 229824001.0 | 0.41585 | {37bef97a-2b4c-4b02-9c1e-61b04bf49ad2} |
| 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} |
| 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} |
| 1948219 | 1948219 | 2016-05-31 22:44:13+00:00 | Bike | TDSP-C-AGL-E--- | 138502001.0 | 11.91803 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 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} |
| 1093936 | 1093936 | 2019-09-17 16:56:57+00:00 | Bike | TDSPHC-AGL-E--- | 114309001.0 | 9.53824 | {779ec98d-2fee-4e4f-a631-a22a05dde2b1} |
| 1085950 | 1085950 | 2017-07-05 22:45:47+00:00 | Bike | TDSPHC-AGL-E--- | 106450001.0 | 24.45208 | {3190bec0-d5bd-4914-97ac-1a5d94b53019} |
| 1784935 | 1784935 | 2016-02-26 22:04:10+00:00 | Bike | TDSPHC-AGL-E--- | 98082901.0 | 69.92074 | {f5140f99-ccd9-4a22-a7f2-09500c948b0d} |
| 2445481 | 2445481 | 2016-03-08 09:11:03+00:00 | Strada | TDSPHC-AGL-EV-- | 97168401.0 | 108.61582 | {7c6b4603-ed9c-4906-90c0-e95664e00c7d} |
| 1676671 | 1676671 | 2016-04-06 17:05:58+00:00 | Bike | TDSPHC-AGL-E--- | 94638201.0 | 43.7415 | {1119d36c-f303-4afd-8334-3cec111e75a2} |
| 1948418 | 1948418 | 2017-08-16 08:32:22+00:00 | Bike | TDSP-C-AGL-E--- | 94356001.0 | 44.5157 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 447133 | 447133 | 2020-01-20 00:51:10+00:00 | Bike | TDSPHC-AGL-E--- | 93753201.0 | 58.656 | {b6667d8d-8e4c-4bab-9053-88b1399f9095} |
| 249394 | 249394 | 2016-06-10 12:28:43+00:00 | Bike | TDSPHC-AGL-EV-- | 89040301.0 | 67.04751 | {fead7df2-7bc1-4682-bd0f-c4c77c654771} |
| 642820 | 642820 | 2016-06-16 10:17:23+00:00 | Bike | TDSPHC-AGL-EV-- | 88529701.0 | 18.54685 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
| 642821 | 642821 | 2016-06-16 10:17:24+00:00 | Bike | TDSPHC-AGL----- | 88529701.0 | 18.54685 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
| 550683 | 550683 | 2016-09-09 09:49:50+00:00 | Bike | TDSPHC-AGL-E--- | 81185401.0 | 48.6567 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 542474 | 542474 | 2018-04-29 22:57:18+00:00 | Bike | TDSP-C-AGL-E--- | 77436601.0 | 104.81886 | {be75202d-1a1e-41c6-a959-600f22469f9a} |
| 923954 | 923954 | 2016-11-18 21:01:56+00:00 | Bike | TDSPHC-AGL-EV-- | 75615401.0 | 114.84842 | {d6881f40-9735-4ccf-ac2b-6d83e4c62ae9} |
| 385992 | 385992 | 2007-04-05 21:42:24+00:00 | Bike | TDSP-C-AGL----- | 73234401.0 | 123.979 | {79c247de-f880-4c1e-a2d0-afefbd9762c4} |
| 919887 | 919887 | 2017-02-19 21:42:38+00:00 | Bike | TDSPHC-AGL-EV-- | 67059501.0 | 23.2343 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} |
| 253851 | 253851 | 2017-03-02 03:17:36+00:00 | Bike | TDSPHC-AGL-EV-- | 66532201.0 | 22.72228 | {b835e58e-84ac-4e76-a390-0e7bde2f9401} |
| 1974431 | 1974431 | 2017-03-27 21:51:51+00:00 | Bike | TDSPHC-AGL-E--- | 63951701.0 | 33.26046 | {7968d26c-73a6-4730-ab1f-d89ead4d0427} |
| 1544955 | 1544955 | 2017-04-14 07:22:40+00:00 | Bike | TDSPHC-AGL-EV-- | 62441401.0 | 113.19238 | {9861246f-a5e2-4cb5-8249-37f188810723} |
| 2224940 | 2224940 | 2017-04-23 06:33:45+00:00 | Bike | TDSPHC-AGL-EV-- | 61669301.0 | 66.49057 | {c39d264d-0971-456f-a181-5e246566ce76} |
| 2224941 | 2224941 | 2017-04-23 15:07:00+00:00 | Bike | TDSPHC-AGL-EV-- | 61669301.0 | 66.49057 | {c39d264d-0971-456f-a181-5e246566ce76} |
| 213593 | 213593 | 2017-01-25 08:52:02+00:00 | Bike | TDSPHC-AGL-E--- | 59881201.0 | 37.3469 | {68d4225d-c280-4f91-9c6f-9f8f1afe6998} |
| 1632366 | 1632366 | 2017-05-15 17:56:28+00:00 | Bike | TDSPHC-AGL-EV-- | 59726901.0 | 45.53434 | {60310096-c114-4420-b427-8c2fb0a801f6} |
| 865168 | 865168 | 2017-05-22 16:27:37+00:00 | Bike | TDSPHC-AGL-EV-- | 59132101.0 | 46.0116 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
| 1651000 | 1651000 | 2017-05-29 07:03:28+00:00 | Bike | TDSPHC-AGL-EV-- | 58555001.0 | 8.07405 | {284c633c-98cb-4ea4-86dc-a4bb54761fb4} |
| 1651005 | 1651005 | 2017-06-03 10:56:08+00:00 | Bike | TDSPHC-AGL-EV-- | 58107901.0 | 0.29891 | {284c633c-98cb-4ea4-86dc-a4bb54761fb4} |
| 1824762 | 1824762 | 2018-05-12 09:35:51+00:00 | race | TDSPHC-AGL-EV-- | 58070401.0 | 68.43018 | {68394158-ff37-4301-b00a-5c772c28ddd7} |
| 2402579 | 2402579 | 2018-05-12 09:35:51+00:00 | race | TDSPHC-AGL-EV-- | 58070401.0 | 68.43018 | {d420e4fa-be48-400b-92ec-535b9aa5a381} |
| 865185 | 865185 | 2017-06-13 11:24:36+00:00 | Bike | TDSPHC-AGL-EV-- | 57256801.0 | 81.477 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
| 643134 | 643134 | 2017-06-21 16:02:29+00:00 | Bike | TDSPHC-AGL----- | 56547401.0 | 36.2751 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
| 375679 | 375679 | 2017-07-05 01:25:29+00:00 | Bike | TDSPHC-AGL-E--- | 55382501.0 | 67.3562 | {48be26a3-90dc-466b-997a-611e019e8da9} |
| 919971 | 919971 | 2017-07-08 12:14:37+00:00 | TDSPHC-AGL-EV-- | 55088401.0 | 62.7794 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} | |
| 919973 | 919973 | 2017-07-08 15:05:13+00:00 | Bike | TDSPHC-AGL-EV-- | 55073801.0 | 38.326 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} |
| 865227 | 865227 | 2017-08-09 11:40:51+00:00 | Bike | TDSPHC-AGL-EV-- | 52329501.0 | 145.31 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
| 865230 | 865230 | 2017-08-14 10:28:50+00:00 | Bike | TDSPHC-AGL-EV-- | 51908101.0 | 106.219 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
| 643167 | 643167 | 2017-09-16 09:10:36+00:00 | Bike | TDSPHC-AGL-EV-- | 49056201.0 | 86.5667 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
| 1762913 | 1762913 | 2017-09-21 13:12:45+00:00 | Bike | TDSPHC-AGL-E--- | 48999701.0 | 64.3769 | {07476629-ae8d-478f-967b-67bff9d8f4fe} |
| 1937497 | 1937497 | 2016-03-09 06:13:20+00:00 | Bike | TDSPHC-AGL-EV-- | 48390301.0 | 29.2297 | {ac398fa9-97d1-4273-9998-29c2f715d2fd} |
| 1436491 | 1436491 | 2017-10-01 09:59:07+00:00 | Bike | TDSPHC-AGL-E--- | 47745901.0 | 6.11587 | {28eb831c-6d65-4a43-9c9e-882a0dad9c23} |
| 2425828 | 2425828 | 2017-06-12 20:50:41+00:00 | Bike | TDSPHC-AGL-EV-- | 43550701.0 | 38.069 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 1436533 | 1436533 | 2017-12-01 14:53:49+00:00 | Bike | TDSPHC-AGL-E--- | 42462901.0 | 35.1781 | {28eb831c-6d65-4a43-9c9e-882a0dad9c23} |
| 1436546 | 1436546 | 2017-12-19 19:24:35+00:00 | Bike | TDSPHC-AGL-E--- | 40886101.0 | 25.3149 | {28eb831c-6d65-4a43-9c9e-882a0dad9c23} |
| 1947929 | 1947929 | 2015-02-08 05:12:43+00:00 | Bike | TDSP-C-AGL-E--- | 38716401.0 | 42.80131 | {b965e142-03a8-48b9-aff8-a25d1e8b4093} |
| 892728 | 892728 | 2018-01-27 12:02:11+00:00 | Bike | TDSPHC-AGL-E--- | 38108901.0 | 43.8588 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 195320 | 195320 | 2018-02-19 14:48:39+00:00 | Bike | TDSP-C-AGL-EV-- | 35550601.0 | 78.10356 | {2c55a305-cdde-42cd-8fbd-e44c09c76c7b} |
| 751236 | 751236 | 2018-03-11 18:56:52+00:00 | Bike | TDSPHC-AGL-EV-- | 33873801.0 | 36.5975 | {1dbba82e-8924-4b10-b1da-151e8062680a} |
| 213753 | 213753 | 2017-09-23 12:26:16+00:00 | Bike | TDSP-C-AGL-E--- | 32836001.0 | 37.0877 | {68d4225d-c280-4f91-9c6f-9f8f1afe6998} |
| 766951 | 766951 | 2018-03-30 12:11:25+00:00 | Bike | TDSPHC-AGL-E--- | 32671501.0 | 92.4798 | {ab4fd78c-8437-4890-b22b-0ecd6d3da507} |
| 1480935 | 1480935 | 2018-03-30 08:10:43+00:00 | Bike | TDSPHC-AGL-E--- | 32671101.0 | 78.96091 | {29638c81-44fc-4a8b-b4b6-1c91d3fd5d95} |
| 1205462 | 1205462 | 2018-04-12 11:56:56+00:00 | Bike | TDSPHC-AGL-EV-- | 31458601.0 | 67.9301 | {df5c1f03-dba4-44c6-bf34-0daaac7f64ed} |
| 1627096 | 1627096 | 2018-05-07 08:33:15+00:00 | TDSPHC-AGL-E--- | 28916801.0 | 92.20652 | {de210a15-e9f2-4dd8-a914-81c4ed6d3966} | |
| 381402 | 381402 | 2018-08-31 16:10:46+00:00 | Bike | TDSPHC-AGL-EV-- | 27741601.0 | 16.6796 | {c469fc87-73b2-40ea-978b-a745288e9015} |
| 2561324 | 2561324 | 2018-05-25 12:50:42+00:00 | Bike | TDSP-C-AGL-EV-- | 27346101.0 | 27.77264 | {87020647-5bd4-47c3-a37e-ac70042794ba} |
| 1525348 | 1525348 | 2017-08-07 18:04:22+00:00 | Bike | TDSPHC-AGL-EV-- | 27220601.0 | 38.54906 | {16645598-494e-48fc-a2c4-fa380489e2c0} |
| 2523842 | 2523842 | 2018-06-10 13:40:08+00:00 | Bike | TDSPHC-AGL----- | 25961301.0 | 22.659 | {58ca145c-818c-412d-b2fc-027c30e71c9e} |
| 115221 | 115221 | 2018-06-22 06:45:06+00:00 | Bike | TDSP---AGL-E--- | 24950501.0 | 73.3485 | {f89b3094-ecf7-4279-b589-8ff43f3f1dd1} |
| 1023615 | 1023615 | 2018-06-30 10:11:02+00:00 | Bike | TDSPHC-AGL-E--- | 24825401.0 | 212.877 | {e79e279d-d990-4e4f-a391-f535ae60f0bd} |
| 2449852 | 2449852 | 2018-06-30 11:11:02+00:00 | Bike | TDSPHC-AGL-E--- | 24825401.0 | 212.877 | {da5ed8b3-41b4-40e5-b0e4-5f8c9c3e4409} |
| 1204916 | 1204916 | 2020-04-20 20:32:17+00:00 | Bike | T-SPHC-AG--E--- | 24800301.0 | {45eab89c-c876-48c9-9f9a-726e96ea821c} | |
| 808876 | 808876 | 2018-08-24 00:57:31+00:00 | Bike | TDSPHCNAGL-EV-- | 24653301.0 | 74.85733 | {caea47ff-9f07-4009-828b-67e14681eb02} |
| 808986 | 808986 | 2019-06-05 20:38:15+00:00 | Bike | TDSPHCNAGL-EV-- | 24653301.0 | 74.85733 | {caea47ff-9f07-4009-828b-67e14681eb02} |
| 1211279 | 1211279 | 2017-05-30 13:12:34+00:00 | Bike | TDSP-C-AGL-E--- | 23893001.0 | 14.7217 | {cd9f32bb-adbf-41d3-9b0d-9b44cf3ec3aa} |
| 1584383 | 1584383 | 2018-07-14 00:14:01+00:00 | Bike | TDSPHC-AGL-E--- | 23074401.0 | 40.7845 | {aa5165ba-5072-4b77-86c5-5c00284e3b53} |
| 2452719 | 2452719 | 2018-08-21 05:31:15+00:00 | TDSPHC-AGL-EV-- | 19988101.0 | 121.722 | {481aee29-ca3f-47ab-ae20-688b0b28f997} | |
| 2448944 | 2448944 | 2018-08-25 14:27:11+00:00 | Bike | TDSPHC-AGL-E--- | 19968801.0 | 53.93793 | {f9960deb-9dd3-4854-b1b5-899b739ab105} |
| 2204650 | 2204650 | 2018-08-22 11:17:18+00:00 | Bike | TDSPHC-AGL-E--- | 19963101.0 | 35.28336 | {e3cab080-161c-4462-8d3c-51cf91e428a4} |
| 1858333 | 1858333 | 2018-08-19 05:38:31+00:00 | Bike | TDSP-C-AGL-E--- | 19949001.0 | 42.212 | {1e518c35-d331-4d7f-8df7-195f7ca9faaa} |
| 1707233 | 1707233 | 2018-08-26 10:39:31+00:00 | Bike | TDSPHC-AGL-EV-- | 19364301.0 | 82.6976 | {e58c276d-9e21-4dcf-8121-703ee2c6f729} |
| 1858349 | 1858349 | 2018-09-08 10:11:21+00:00 | Bike | TD-PHC-AGL-E--- | 18196501.0 | 0.51668 | {1e518c35-d331-4d7f-8df7-195f7ca9faaa} |
| 2230804 | 2230804 | 2018-02-07 07:30:12+00:00 | Bike | TDSPHC-AGL-E--- | 16892201.0 | 21.63455 | {5d7d3a8c-4df8-48ba-a06a-c08d1a6ac4d8} |
| 1459572 | 1459572 | 2018-12-15 11:52:14+00:00 | Bike | TDSPHC-AGL-EV-- | 15746501.0 | 128.14374 | {8451ed8f-9574-4f33-a963-d9ad2e5441b9} |
| 1555074 | 1555074 | 2016-09-23 06:05:00+00:00 | Bike | TDSP-C-AGL-E--- | 15237101.0 | 75.1017 | {19ce09b7-6e69-40a0-bf03-1ca40117cad1} |
| 1286540 | 1286540 | 2017-10-25 01:38:26+00:00 | Bike | TDSP-C-AGL-EV-- | 14805901.0 | 35.0738 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 2561489 | 2561489 | 2018-10-28 07:23:26+00:00 | Bike | TDSPHC-AGL-EV-- | 13894701.0 | 53.0783 | {87020647-5bd4-47c3-a37e-ac70042794ba} |
| 2061977 | 2061977 | 2018-11-16 23:52:08+00:00 | Bike | TDSP-C-AGL-E--- | 12728901.0 | 107.96726 | {26c7ecf8-d2af-44d6-9c31-204a89fd1cf5} |
| 2192034 | 2192034 | 2018-12-01 10:12:15+00:00 | Bike | TDSPHC-AGL-E--- | 10950201.0 | 110.51807 | {d217622d-92f7-44c5-b935-72700aa29598} |
| 1202772 | 1202772 | 2019-07-13 00:43:26+00:00 | Bike | TDSPHC-AGL-E--- | 10906001.0 | 67.793 | {ffb71181-c71d-4b00-9fbd-fa441c125566} |
| 329370 | 329370 | 2013-04-26 06:39:05+00:00 | Bike | TD-PHC-AGL-E--- | 10794101.0 | 0.01884 | {d2f8bc28-039d-4f21-b112-9a21d51b008c} |
| 915789 | 915789 | 2017-02-27 02:50:08+00:00 | Bike | TDSPHC-AGL-EV-- | 9802981.0 | 18.281 | {f0a0412f-0a3d-4d71-b9ef-5d839a5e8aa9} |
| 1682833 | 1682833 | 2017-02-27 02:50:09+00:00 | Bike | TDSPHC-AGL-E--- | 9802981.0 | 18.281 | {a31f3639-3565-4597-be26-69f37057230a} |
| 830068 | 830068 | 2015-01-13 18:14:50+00:00 | Bike | TDSPHC-AGL-E--- | 9068471.0 | 1.8567 | {94fb1d7e-3a03-41de-8b80-a4b587b8ab0d} |
| 2525191 | 2525191 | 2019-02-23 13:43:14+00:00 | Bike | TDSPHC-AGL-E--- | 8470041.0 | 60.23691 | {b22a5567-7cf5-4413-8a88-35c59245c99c} |
| 2309321 | 2309321 | 2013-10-10 06:38:32+00:00 | Bike | TDSPHC-AGL-E--- | 7864191.0 | 12.101 | {8343d0a4-7254-48d3-9666-c1e39be0e0d2} |
| 1093992 | 1093992 | 2019-10-31 19:27:41+00:00 | Bike | TDSPHC-AGL-E--- | 7864011.0 | 9.79668 | {779ec98d-2fee-4e4f-a631-a22a05dde2b1} |
| 1132949 | 1132949 | 2017-05-10 17:18:13+00:00 | Bike | TDSPHC-AGL-E--- | 7280191.0 | 27.0608 | {b8101019-6f71-42f3-ac72-b5b6fbc3bd2e} |
| 1617096 | 1617096 | 2017-05-10 17:18:13+00:00 | Bike | TDSPHC-AGL-E--- | 7280191.0 | 27.0608 | {d686b098-3e13-47c9-bb1c-b79fc96454df} |
| 2165835 | 2165835 | 2017-05-07 12:18:05+00:00 | Bike | TDSP-CN-------- | 7102272.52 | 249.174 | {7675bb4e-8371-4db6-83af-d20849b995d9} |
| 2254691 | 2254691 | 2017-05-07 12:18:05+00:00 | Bike | TDSP-CN-------- | 7102272.52 | 249.174 | {d0245d64-c91f-49be-975c-ad89e21bb74c} |
| 494197 | 494197 | 2019-01-27 07:27:55+00:00 | Bike | TDSPHC-AGL-EV-- | 6064141.0 | 133.02966 | {5fb378ab-7d06-4ad5-8a6b-488321c5513a} |
| 1201838 | 1201838 | 2019-01-27 09:29:10+00:00 | Bike | TDSPHC-AGL-E--- | 6056261.0 | 89.268 | {5f4345ea-270d-4342-915a-92c28eb0b4b2} |
| 2191655 | 2191655 | 2015-06-10 15:18:54+00:00 | Bike | TDSP-C-AGL-EV-- | 5961571.0 | 48.32498 | {be5b3a14-ab73-46b6-b956-649a47b9a404} |
| 1273185 | 1273185 | 2016-09-03 11:00:04+00:00 | Bike | TDSPHC-A-L-EV-- | 5959581.0 | 5.7029 | {9fa04826-c54d-4e3f-8278-403f3854c750} |
| 1822479 | 1822479 | 2017-12-17 09:36:18+00:00 | Bike | TDSPHC-AGL-E--- | 5577681.0 | 35.9304 | {c5302ad9-dd0d-4307-a1dd-25489c3da0e7} |
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");