rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by athlete descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance | athlete ▲ |
|---|---|---|---|---|---|---|---|
| 2474502 | 2474502 | 2018-02-08 13:24:32+00:00 | Bike | TDSPHC-AGL----- | 7226.0 | 37.9741 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474576 | 2474576 | 2018-05-19 11:44:38+00:00 | Bike | TDSPHC-AGL-E--- | 4515.0 | 21.66608 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474577 | 2474577 | 2018-05-20 06:45:53+00:00 | Bike | TDSPHC-AGL-E--- | 1176.0 | 4.27186 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474578 | 2474578 | 2018-05-20 07:05:32+00:00 | Bike | TDSPHC-AGL-E--- | 1014.0 | 5.56227 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474579 | 2474579 | 2018-05-20 07:25:47+00:00 | Bike | TDSPHC-AGL-E--- | 6962.0 | 39.96742 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474580 | 2474580 | 2018-05-22 07:25:48+00:00 | Bike | TDSPHC-AGL-E--- | 3410.0 | 16.4238 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474581 | 2474581 | 2018-05-23 17:48:30+00:00 | Bike | TDSPHC-AGL-E--- | 3141.0 | 14.99106 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474582 | 2474582 | 2018-05-24 14:17:27+00:00 | Bike | TDSPHC-AGL-E--- | 5620.0 | 29.51051 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474583 | 2474583 | 2018-05-27 10:55:40+00:00 | Bike | TDSPHC-AGL-E--- | 5218.0 | 30.5208 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474584 | 2474584 | 2018-05-30 13:56:22+00:00 | Bike | TDSPHC-AGL-E--- | 4712.0 | 19.98557 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474585 | 2474585 | 2018-06-01 16:17:45+00:00 | Bike | TDSPHC-AGL-E--- | 3663.0 | 17.09045 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474586 | 2474586 | 2018-06-02 10:13:07+00:00 | Bike | TDSPHC-AGL-E--- | 5974.0 | 31.07731 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474587 | 2474587 | 2018-06-03 08:57:56+00:00 | Bike | TDSPHC-AGL-E--- | 11200.0 | 52.48372 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474588 | 2474588 | 2018-06-04 13:00:13+00:00 | Bike | TDSPHC-AGL-E--- | 3929.0 | 22.84119 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474589 | 2474589 | 2018-06-05 08:43:00+00:00 | Bike | TDSPHC-AGL-E--- | 3887.0 | 16.47815 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474590 | 2474590 | 2018-06-07 06:30:43+00:00 | Bike | TDSPHC-AGL-E--- | 6968.0 | 37.0991 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474591 | 2474591 | 2018-06-10 13:54:01+00:00 | Bike | TDSPHC-AGL-E--- | 6966.0 | 36.25412 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474592 | 2474592 | 2018-06-12 16:12:07+00:00 | Bike | TDSPHC-AGL-E--- | 7016.0 | 25.09017 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474593 | 2474593 | 2018-06-13 09:55:40+00:00 | Bike | TDSPHC-AGL-E--- | 3934.0 | 18.11665 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474594 | 2474594 | 2018-06-14 16:53:49+00:00 | Bike | TDSPHC-AGL-E--- | 11176.0 | 22.02217 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474595 | 2474595 | 2018-06-16 10:02:01+00:00 | Bike | TDSPHC-AGL-E--- | 5190.0 | 21.30339 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474596 | 2474596 | 2018-06-17 08:21:57+00:00 | Bike | TDSPHC-AGL-E--- | 2217.0 | 7.05996 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474597 | 2474597 | 2018-06-17 09:01:39+00:00 | Bike | TDSPHC-AGL-E--- | 4331.0 | 19.62827 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474647 | 2474647 | 2018-08-15 06:30:36+00:00 | Bike | TDSPHC-AGL-E--- | 19867.0 | 129.559 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474648 | 2474648 | 2018-08-16 07:59:42+00:00 | Bike | TDSPHC-AGL-E--- | 6446.0 | 22.02574 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474649 | 2474649 | 2018-08-17 15:41:11+00:00 | Bike | TDSPHC-AGL-E--- | 9300.0 | 68.95893 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474650 | 2474650 | 2018-08-17 18:16:43+00:00 | Bike | TDSPHC-AGL-E--- | 825.0 | 4.19567 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474651 | 2474651 | 2018-08-18 06:08:19+00:00 | Bike | TDSPHC-AGL-E--- | 11939.0 | 90.4113 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474652 | 2474652 | 2018-08-21 06:21:02+00:00 | Bike | TDSPHC-AGL-E--- | 7377.0 | 57.37736 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 2474653 | 2474653 | 2018-08-22 16:16:25+00:00 | Bike | TDSPHC-AGL-E--- | 7556.0 | 62.133 | {fff279c7-564e-43b5-a139-d6736c81b34b} |
| 1135203 | 1135203 | 2020-01-02 12:08:33+00:00 | Bike | TDSPH--A-L-E--- | 3620.0 | 18.675 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135204 | 1135204 | 2020-01-03 05:52:01+00:00 | Bike | TDSPH--A-L-E--- | 2282.0 | 10.9811 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135205 | 1135205 | 2020-01-04 07:05:41+00:00 | Bike | TDSPH--A-L-E--- | 2197.0 | 10.9951 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135206 | 1135206 | 2020-01-06 07:30:11+00:00 | Bike | TDSPH--A-L-E--- | 4475.0 | 19.9978 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135207 | 1135207 | 2020-01-08 04:57:58+00:00 | Bike | TDSPH--A-L-E--- | 1834.0 | 11.0903 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135208 | 1135208 | 2020-01-12 07:06:04+00:00 | Bike | TDSPH--A-L-E--- | 3076.0 | 20.0597 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135209 | 1135209 | 2020-01-13 05:04:02+00:00 | Bike | TDSPH--A-L-E--- | 1660.0 | 10.1053 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135210 | 1135210 | 2020-01-13 16:39:55+00:00 | Bike | TDSPH--A-L-E--- | 3142.0 | 20.0686 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135211 | 1135211 | 2020-01-16 15:46:05+00:00 | Bike | TDSPH--A-L-E--- | 3084.0 | 20.0635 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135212 | 1135212 | 2020-01-17 18:19:47+00:00 | Bike | TDSPH--A-L-E--- | 1855.0 | 11.0272 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135213 | 1135213 | 2020-01-18 07:23:43+00:00 | Bike | TDSPH--A-L-E--- | 2184.0 | 14.0502 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135214 | 1135214 | 2020-01-19 07:24:53+00:00 | Bike | TDSPH--A-L-E--- | 2249.0 | 15.0417 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135215 | 1135215 | 2020-01-20 16:17:07+00:00 | Bike | TDSPH--A-L-E--- | 2841.0 | 17.9711 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135216 | 1135216 | 2020-01-22 16:55:37+00:00 | Bike | TDSPH--A-L-E--- | 2881.0 | 20.0999 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135217 | 1135217 | 2020-01-24 11:20:54+00:00 | Bike | TDSPHC-A-L-E--- | 3377.0 | 22.0187 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135218 | 1135218 | 2020-01-28 04:49:12+00:00 | Bike | TDSPHC-A-L-E--- | 2087.0 | 11.0205 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135219 | 1135219 | 2020-01-29 14:48:55+00:00 | Bike | TDSPHC-A-L-E--- | 3756.0 | 22.1017 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135220 | 1135220 | 2020-01-30 18:42:45+00:00 | Bike | TDSPHC-A-L-E--- | 1389.0 | 10.1308 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135221 | 1135221 | 2020-01-31 04:47:43+00:00 | Bike | TDSPHC-A-L-E--- | 2389.0 | 15.1379 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135223 | 1135223 | 2020-02-02 06:58:03+00:00 | Bike | TDSPHC-A-L-E--- | 2569.0 | 14.0018 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135224 | 1135224 | 2020-02-03 05:32:40+00:00 | Bike | TDSPHC-A-L-E--- | 2047.0 | 10.0642 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135225 | 1135225 | 2020-02-03 17:47:27+00:00 | Bike | TDSPHC-A-L-E--- | 1168.0 | 3.5612 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135226 | 1135226 | 2020-02-05 04:54:13+00:00 | Bike | TDSPHC-A-L-E--- | 2568.0 | 13.0761 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135227 | 1135227 | 2020-02-05 05:22:02+00:00 | Bike | TDSP-C-AGL----- | 911.0 | 5.7417 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135228 | 1135228 | 2020-02-06 15:44:16+00:00 | Bike | TDSPHC-A-L-E--- | 2851.0 | 12.6522 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135229 | 1135229 | 2020-02-07 05:08:42+00:00 | Bike | TDSPHC-A-L-E--- | 2481.0 | 15.0969 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135230 | 1135230 | 2020-02-10 04:56:27+00:00 | Bike | TDSPHC-A-L-E--- | 1890.0 | 13.056 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135231 | 1135231 | 2020-02-11 05:07:01+00:00 | Bike | TDSPHC-A-L-E--- | 1437.0 | 10.0685 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135232 | 1135232 | 2020-02-12 14:56:17+00:00 | Bike | TDSPHC-A-L-E--- | 3673.0 | 24.1042 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135233 | 1135233 | 2020-02-15 07:06:24+00:00 | Bike | TDSPHC-A-L-E--- | 2414.0 | 15.1038 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135235 | 1135235 | 2020-02-19 13:49:38+00:00 | Bike | TDSPHC-A-L-E--- | 1904.0 | 10.0644 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135236 | 1135236 | 2020-02-23 06:33:40+00:00 | Bike | TDSPHC-A-L-E--- | 3881.0 | 25.0569 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135237 | 1135237 | 2020-02-24 05:32:24+00:00 | Bike | TDSPHC-A-L-E--- | 1841.0 | 12.2139 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135238 | 1135238 | 2020-02-26 16:09:27+00:00 | Bike | TDSPHC-A-L-E--- | 3131.0 | 18.2208 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135239 | 1135239 | 2020-02-28 10:37:31+00:00 | Bike | TDSPHC-AGL-E--- | 3385.0 | 15.6878 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135240 | 1135240 | 2020-02-28 11:34:23+00:00 | Bike | TDSPHC-AGL-E--- | 1686.0 | 8.1294 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135242 | 1135242 | 2020-03-02 04:47:53+00:00 | Bike | TDSPHC-A-L-E--- | 2339.0 | 10.0876 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135243 | 1135243 | 2020-03-03 04:55:21+00:00 | Bike | TDSPHC-A-L-E--- | 1871.0 | 3.7079 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135244 | 1135244 | 2020-03-04 15:51:26+00:00 | Bike | TDSPHC-A-L-E--- | 2527.0 | 17.0215 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135245 | 1135245 | 2020-03-06 04:42:40+00:00 | Bike | TDSPHC-A-L-E--- | 2467.0 | 16.984 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135247 | 1135247 | 2020-03-09 11:40:26+00:00 | Bike | TDSPHC-A-L-E--- | 1095.0 | 5.0602 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135248 | 1135248 | 2020-03-10 16:33:33+00:00 | Bike | TDSPHC-A-L-E--- | 2467.0 | 15.985 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135249 | 1135249 | 2020-03-10 17:17:16+00:00 | Bike | TDSPHC-A-L-E--- | 719.0 | 2.1265 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135250 | 1135250 | 2020-03-11 05:01:19+00:00 | Bike | TDSPHC-A-L-E--- | 1819.0 | 10.5638 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135251 | 1135251 | 2020-03-13 05:05:24+00:00 | Bike | TDSPHC-----E--- | 993.0 | 5.4362 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135252 | 1135252 | 2020-03-13 05:23:00+00:00 | Bike | TDSPHC-----E--- | 1633.0 | 11.0601 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135253 | 1135253 | 2020-03-15 06:48:34+00:00 | Bike | TDSPHC-----E--- | 3301.0 | 21.0448 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135254 | 1135254 | 2020-03-16 18:06:09+00:00 | Bike | TDSPHC-----E--- | 1103.0 | 7.5022 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135255 | 1135255 | 2020-03-16 18:25:02+00:00 | Bike | TDSPHC-----E--- | 939.0 | 7.0114 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135256 | 1135256 | 2020-03-17 07:36:52+00:00 | Bike | TDSPHC-----E--- | 2497.0 | 11.8996 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135257 | 1135257 | 2020-03-18 06:36:56+00:00 | Bike | TDSPHC-----E--- | 3611.0 | 24.0257 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135258 | 1135258 | 2020-03-19 15:50:51+00:00 | Bike | TDSPHC-----E--- | 2831.0 | 15.08 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135259 | 1135259 | 2020-03-20 07:12:14+00:00 | Bike | TDSPHC-AGL----- | 3921.0 | 23.0869 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135260 | 1135260 | 2020-03-21 17:53:46+00:00 | Bike | TDSPHC-----E--- | 2463.0 | 16.5174 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135261 | 1135261 | 2020-03-23 06:24:30+00:00 | Bike | TDSPHC-----E--- | 2896.0 | 13.0542 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135262 | 1135262 | 2020-03-24 10:11:38+00:00 | Bike | TDSPHC-----E--- | 2545.0 | 18.201 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135263 | 1135263 | 2020-03-25 08:21:41+00:00 | Bike | TDSPHC-----E--- | 3660.0 | 30.0925 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135264 | 1135264 | 2020-03-26 17:17:51+00:00 | Bike | TDSPHC-----E--- | 3094.0 | 24.0311 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135265 | 1135265 | 2020-03-28 06:55:08+00:00 | Bike | TDSPHC-----E--- | 3612.0 | 23.1151 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135266 | 1135266 | 2020-03-28 17:13:10+00:00 | Bike | TDSPHC-----E--- | 1844.0 | 10.1054 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135267 | 1135267 | 2020-03-29 17:48:31+00:00 | Bike | TDSPHC-----E--- | 1166.0 | 10.0661 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135268 | 1135268 | 2020-03-30 05:50:40+00:00 | Bike | TDSPHC-----E--- | 3654.0 | 26.1031 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135269 | 1135269 | 2020-03-31 06:10:05+00:00 | Bike | TDSPHC-----E--- | 3778.0 | 34.0354 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135270 | 1135270 | 2020-04-01 06:08:44+00:00 | Bike | TDSPHC-A-L-E--- | 3292.0 | 17.066 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135271 | 1135271 | 2020-04-02 06:58:34+00:00 | Bike | TDSPHC-----E--- | 2721.0 | 20.6268 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135272 | 1135272 | 2020-04-03 05:51:42+00:00 | Bike | TDSPHC-----E--- | 2945.0 | 27.4199 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135273 | 1135273 | 2020-04-04 06:27:12+00:00 | Bike | TDSPHC-AGL----- | 3351.0 | 26.3333 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135274 | 1135274 | 2020-04-05 06:15:52+00:00 | Bike | TDSPHC-A-L----- | 4538.0 | 32.3616 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135275 | 1135275 | 2020-04-07 05:25:38+00:00 | Bike | TDSPHC-----E--- | 3039.0 | 30.1124 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135276 | 1135276 | 2020-04-08 06:02:50+00:00 | Bike | TDSPHC-AGL----- | 6646.0 | 50.1653 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
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");