rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by data descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data ▲ | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1345990 | 1345990 | 2016-04-30 00:07:36+00:00 | Bike | TDSPHCNAGLWEVO- | 30254.0 | 189.6422 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345995 | 1345995 | 2016-05-04 03:01:02+00:00 | Bike | TDSPHCNAGLWEVO- | 28168.0 | 162.621 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346030 | 1346030 | 2016-05-21 02:48:56+00:00 | Bike | TDSPHCNAGLWEVO- | 20060.0 | 116.4509 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346031 | 1346031 | 2016-05-21 22:28:21+00:00 | Bike | TDSPHCNAGLWEVO- | 19070.0 | 96.28767 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346080 | 1346080 | 2016-06-17 22:12:14+00:00 | TDSPHCNAGLWEVO- | 20474.0 | 115.0718 | {2bf4beac-396c-4b3b-9c59-556a8754491a} | |
| 1892677 | 1892677 | 2016-04-30 00:07:36+00:00 | Bike | TDSPHCNAGLWEVO- | 30254.0 | 189.6422 | {dabde884-825f-4257-bce2-feb184be5f4f} |
| 1892682 | 1892682 | 2016-05-04 03:01:02+00:00 | Bike | TDSPHCNAGLWEVO- | 28168.0 | 162.621 | {dabde884-825f-4257-bce2-feb184be5f4f} |
| 1892766 | 1892766 | 2016-06-17 22:12:14+00:00 | TDSPHCNAGLWEVO- | 20474.0 | 115.0718 | {dabde884-825f-4257-bce2-feb184be5f4f} | |
| 1309521 | 1309521 | 2016-04-23 11:03:04+00:00 | Run | TDSPHCNAGLWEV-R | 4320.0 | 25.9336 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309530 | 1309530 | 2016-06-12 11:24:56+00:00 | Run | TDSPHCNAGLWEV-R | 17284.0 | 112.429 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309531 | 1309531 | 2016-06-18 10:52:00+00:00 | Run | TDSPHCNAGLWEV-R | 9770.0 | 51.8136 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 182950 | 182950 | 2016-03-16 07:13:29+00:00 | Bike | TDSPHCNAGLWEV-- | 11457.0 | 90.72802 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 182951 | 182951 | 2016-03-17 11:23:12+00:00 | Bike | TDSPHCNAGLWEV-- | 10540.0 | 82.15645 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183026 | 183026 | 2016-06-11 08:09:11+00:00 | Bike | TDSPHCNAGLWEV-- | 24155.0 | 186.53335 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183027 | 183027 | 2016-06-13 15:30:38+00:00 | Bike | TDSPHCNAGLWEV-- | 11005.0 | 87.3081 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183032 | 183032 | 2016-06-22 16:27:47+00:00 | Bike | TDSPHCNAGLWEV-- | 8631.0 | 79.62686 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183036 | 183036 | 2016-06-25 08:57:32+00:00 | Bike | TDSPHCNAGLWEV-- | 16002.0 | 122.61728 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183039 | 183039 | 2016-06-28 17:40:24+00:00 | Bike | TDSPHCNAGLWEV-- | 9041.0 | 84.49275 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183041 | 183041 | 2016-07-02 07:32:58+00:00 | Bike | TDSPHCNAGLWEV-- | 11571.0 | 87.17714 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183042 | 183042 | 2016-07-03 12:13:38+00:00 | Bike | TDSPHCNAGLWEV-- | 17149.0 | 133.45097 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 183048 | 183048 | 2016-07-09 16:03:24+00:00 | Bike | TDSPHCNAGLWEV-- | 12704.0 | 114.04047 | {bc3dd711-a083-4f7f-8943-d5924858bba6} |
| 192455 | 192455 | 2016-05-18 16:11:44+00:00 | Bike | TDSPHCNAGLWEV-- | 6791.0 | 53.0789 | {bda5356a-eb0a-4cb6-9231-5110c7bcc7d0} |
| 192477 | 192477 | 2016-07-07 01:46:51+00:00 | Bike | TDSPHCNAGLWEV-- | 8636.0 | 62.2812 | {bda5356a-eb0a-4cb6-9231-5110c7bcc7d0} |
| 1087741 | 1087741 | 2016-04-07 17:11:32+00:00 | Bike | TDSPHCNAGLWEV-- | 5404.0 | 0.97906 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087742 | 1087742 | 2016-04-09 12:46:37+00:00 | Bike | TDSPHCNAGLWEV-- | 11300.0 | 97.14222 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087743 | 1087743 | 2016-04-14 16:09:31+00:00 | Bike | TDSPHCNAGLWEV-- | 5070.0 | 48.84271 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087744 | 1087744 | 2016-04-16 10:56:30+00:00 | Bike | TDSPHCNAGLWEV-- | 12621.0 | 108.7881 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087745 | 1087745 | 2016-04-17 06:59:39+00:00 | Bike | TDSPHCNAGLWEV-- | 5407.0 | 49.84824 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087746 | 1087746 | 2016-04-19 16:07:49+00:00 | Bike | TDSPHCNAGLWEV-- | 3844.0 | 36.80384 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087747 | 1087747 | 2016-04-21 16:08:20+00:00 | Bike | TDSPHCNAGLWEV-- | 2569.0 | 24.40575 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087748 | 1087748 | 2016-04-22 16:08:24+00:00 | Bike | TDSPHCNAGLWEV-- | 3133.0 | 29.94446 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087749 | 1087749 | 2016-04-24 06:59:19+00:00 | Bike | TDSPHCNAGLWEV-- | 13748.0 | 103.88245 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087753 | 1087753 | 2016-04-30 11:35:54+00:00 | Bike | TDSPHCNAGLWEV-- | 10095.0 | 92.30546 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087760 | 1087760 | 2016-05-14 11:35:03+00:00 | Bike | TDSPHCNAGLWEV-- | 14625.0 | 127.38145 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087761 | 1087761 | 2016-05-15 08:20:58+00:00 | Bike | TDSPHCNAGLWEV-- | 6195.0 | 54.7134 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087767 | 1087767 | 2016-05-22 08:10:20+00:00 | Bike | TDSPHCNAGLWEV-- | 6207.0 | 55.9911 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087769 | 1087769 | 2016-05-26 16:19:00+00:00 | Bike | TDSPHCNAGLWEV-- | 3922.0 | 37.23456 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087773 | 1087773 | 2016-06-02 07:35:48+00:00 | Bike | TDSPHCNAGLWEV-- | 8164.0 | 75.8452 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087774 | 1087774 | 2016-06-04 06:08:03+00:00 | Bike | TDSPHCNAGLWEV-- | 12624.0 | 110.7214 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087776 | 1087776 | 2016-06-11 11:13:31+00:00 | Bike | TDSPHCNAGLWEV-- | 13106.0 | 114.22961 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087777 | 1087777 | 2016-06-12 08:20:44+00:00 | Bike | TDSPHCNAGLWEV-- | 6234.0 | 55.95555 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087780 | 1087780 | 2016-06-18 07:31:40+00:00 | Bike | TDSPHCNAGLWEV-- | 2783.0 | 25.75391 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087781 | 1087781 | 2016-06-19 05:13:02+00:00 | Bike | TDSPHCNAGLWEV-- | 21973.0 | 131.26892 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087782 | 1087782 | 2016-06-21 16:30:27+00:00 | Bike | TDSPHCNAGLWEV-- | 4203.0 | 39.66182 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087783 | 1087783 | 2016-06-23 16:21:51+00:00 | Bike | TDSPHCNAGLWEV-- | 3723.0 | 35.05058 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087784 | 1087784 | 2016-06-25 15:21:12+00:00 | Bike | TDSPHCNAGLWEV-- | 2847.0 | 26.93687 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087786 | 1087786 | 2016-06-28 16:39:04+00:00 | Bike | TDSPHCNAGLWEV-- | 7083.0 | 60.77388 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087787 | 1087787 | 2016-06-30 16:29:37+00:00 | Bike | TDSPHCNAGLWEV-- | 6520.0 | 62.19606 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087788 | 1087788 | 2016-07-02 13:38:43+00:00 | Bike | TDSPHCNAGLWEV-- | 11553.0 | 106.7478 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087789 | 1087789 | 2016-07-03 07:49:57+00:00 | Bike | TDSPHCNAGLWEV-- | 3514.0 | 30.23997 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087790 | 1087790 | 2016-07-07 16:39:57+00:00 | Bike | TDSPHCNAGLWEV-- | 4459.0 | 40.48789 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087791 | 1087791 | 2016-07-09 16:36:16+00:00 | Bike | TDSPHCNAGLWEV-- | 2896.0 | 27.09983 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087792 | 1087792 | 2016-07-10 05:30:41+00:00 | Bike | TDSPHCNAGLWEV-- | 12410.0 | 111.95297 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087793 | 1087793 | 2016-07-12 16:48:42+00:00 | Bike | TDSPHCNAGLWEV-- | 4416.0 | 36.86617 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087796 | 1087796 | 2016-07-19 16:39:32+00:00 | Bike | TDSPHCNAGLWEV-- | 5685.0 | 54.74395 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087797 | 1087797 | 2016-07-21 06:04:56+00:00 | Bike | TDSPHCNAGLWEV-- | 6767.0 | 59.92887 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087798 | 1087798 | 2016-07-23 05:18:03+00:00 | Bike | TDSPHCNAGLWEV-- | 15271.0 | 124.63706 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087799 | 1087799 | 2016-07-24 05:32:15+00:00 | Bike | TDSPHCNAGLWEV-- | 6721.0 | 62.8965 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087800 | 1087800 | 2016-07-26 16:42:35+00:00 | Bike | TDSPHCNAGLWEV-- | 6913.0 | 62.40068 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087802 | 1087802 | 2016-07-30 05:27:28+00:00 | Bike | TDSPHCNAGLWEV-- | 13339.0 | 99.4729 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087803 | 1087803 | 2016-07-31 05:35:20+00:00 | Bike | TDSPHCNAGLWEV-- | 8763.0 | 79.18379 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087804 | 1087804 | 2016-08-02 17:19:39+00:00 | Bike | TDSPHCNAGLWEV-- | 3935.0 | 34.76783 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087806 | 1087806 | 2016-08-04 15:58:17+00:00 | Bike | TDSPHCNAGLWEV-- | 7084.0 | 62.83693 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1087807 | 1087807 | 2016-08-06 06:15:27+00:00 | Bike | TDSPHCNAGLWEV-- | 12690.0 | 75.05195 | {47be1108-e004-423d-b984-66c30ec22fa5} |
| 1152635 | 1152635 | 2019-03-06 16:14:07+00:00 | TDSPHCNAGLWEV-- | 5470.0 | 45.41923 | {31974efd-7867-4648-b73e-7a58c8d742ee} | |
| 1152788 | 1152788 | 2019-09-23 10:26:17+00:00 | TDSPHCNAGLWEV-- | 7882.0 | 62.23076 | {31974efd-7867-4648-b73e-7a58c8d742ee} | |
| 1152789 | 1152789 | 2019-09-24 15:52:32+00:00 | TDSPHCNAGLWEV-- | 12364.0 | 68.6263 | {31974efd-7867-4648-b73e-7a58c8d742ee} | |
| 1152813 | 1152813 | 2019-10-18 09:06:48+00:00 | TDSPHCNAGLWEV-- | 7887.0 | 66.13586 | {31974efd-7867-4648-b73e-7a58c8d742ee} | |
| 1152815 | 1152815 | 2019-10-20 08:32:29+00:00 | TDSPHCNAGLWEV-- | 8858.0 | 60.49494 | {31974efd-7867-4648-b73e-7a58c8d742ee} | |
| 1152835 | 1152835 | 2019-11-18 08:42:59+00:00 | Carretera | TDSPHCNAGLWEV-- | 12886.0 | 103.04361 | {31974efd-7867-4648-b73e-7a58c8d742ee} |
| 1152838 | 1152838 | 2019-11-22 11:23:53+00:00 | Carretera | TDSPHCNAGLWEV-- | 14361.0 | 100.9746 | {31974efd-7867-4648-b73e-7a58c8d742ee} |
| 1309513 | 1309513 | 2016-04-10 06:09:21+00:00 | Bike | TDSPHCNAGLWEV-- | 18611.0 | 128.529 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309515 | 1309515 | 2016-04-12 10:36:08+00:00 | Bike | TDSPHCNAGLWEV-- | 6010.0 | 52.5897 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309516 | 1309516 | 2016-04-14 10:33:15+00:00 | Bike | TDSPHCNAGLWEV-- | 8006.0 | 69.6431 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309518 | 1309518 | 2016-04-16 06:57:17+00:00 | Bike | TDSPHCNAGLWEV-- | 9127.0 | 69.1072 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309522 | 1309522 | 2016-04-26 10:35:50+00:00 | Bike | TDSPHCNAGLWEV-- | 7864.0 | 69.2282 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309524 | 1309524 | 2016-05-03 10:37:14+00:00 | Bike | TDSPHCNAGLWEV-- | 7127.0 | 60.7274 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309525 | 1309525 | 2016-05-07 06:49:17+00:00 | Bike | TDSPHCNAGLWEV-- | 16847.0 | 127.301 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309527 | 1309527 | 2016-06-02 08:07:46+00:00 | Bike | TDSPHCNAGLWEV-- | 9411.0 | 74.7322 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309532 | 1309532 | 2016-07-05 17:50:57+00:00 | Bike | TDSPHCNAGLWEV-- | 4311.0 | 36.2986 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1309534 | 1309534 | 2016-07-07 10:02:31+00:00 | Bike | TDSPHCNAGLWEV-- | 3646.0 | 30.8677 | {ea75244f-a60a-4398-90c6-fdc225b319c2} |
| 1345887 | 1345887 | 2016-03-12 22:36:06+00:00 | Bike | TDSPHCNAGLWEV-- | 18622.0 | 100.17646 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345900 | 1345900 | 2016-03-20 00:11:09+00:00 | Bike | TDSPHCNAGLWEV-- | 1443.0 | 0.83515 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345901 | 1345901 | 2016-03-20 00:49:07+00:00 | 0 | TDSPHCNAGLWEV-- | 2178.0 | 16.9772 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345902 | 1345902 | 2016-03-22 01:48:24+00:00 | Bike | TDSPHCNAGLWEV-- | 33590.0 | 204.052 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345911 | 1345911 | 2016-03-26 06:39:18+00:00 | Bike | TDSPHCNAGLWEV-- | 8001.0 | 46.44519 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345914 | 1345914 | 2016-03-26 22:24:15+00:00 | Bike | TDSPHCNAGLWEV-- | 18813.0 | 97.41181 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345932 | 1345932 | 2016-04-03 04:58:16+00:00 | Bike | TDSPHCNAGLWEV-- | 9625.0 | 53.2154 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1345965 | 1345965 | 2016-04-17 04:12:40+00:00 | Bike | TDSPHCNAGLWEV-- | 3001.0 | 23.75268 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346024 | 1346024 | 2016-05-18 11:18:42+00:00 | Bike | TDSPHCNAGLWEV-- | 7885.0 | 40.51025 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346034 | 1346034 | 2016-05-24 01:37:38+00:00 | Bike | TDSPHCNAGLWEV-- | 1706.0 | 11.43382 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346035 | 1346035 | 2016-05-24 10:38:51+00:00 | Bike | TDSPHCNAGLWEV-- | 1952.0 | 12.14628 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346038 | 1346038 | 2016-05-26 01:09:03+00:00 | Bike | TDSPHCNAGLWEV-- | 1714.0 | 11.97992 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346039 | 1346039 | 2016-05-26 10:55:07+00:00 | Bike | TDSPHCNAGLWEV-- | 1922.0 | 11.9397 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346043 | 1346043 | 2016-05-28 05:58:27+00:00 | Bike | TDSPHCNAGLWEV-- | 7885.0 | 78.0664 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346044 | 1346044 | 2016-05-29 01:56:42+00:00 | Bike | TDSPHCNAGLWEV-- | 1382.0 | 0.0055 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346045 | 1346045 | 2016-05-29 02:58:35+00:00 | Bike | TDSPHCNAGLWEV-- | 9231.0 | 86.4919 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346067 | 1346067 | 2016-06-11 23:02:17+00:00 | Bike | TDSPHCNAGLWEV-- | 1880.0 | 15.2575 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346068 | 1346068 | 2016-06-11 23:39:55+00:00 | Bike | TDSPHCNAGLWEV-- | 2520.0 | 0.49502 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
| 1346069 | 1346069 | 2016-06-12 00:53:09+00:00 | Bike | TDSPHCNAGLWEV-- | 1067.0 | 10.7696 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
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");