rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,238,511 rows where data contains "H" and data contains "P" sorted by total_distance
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance ▼ | athlete |
|---|---|---|---|---|---|---|---|
| 13039 | 13039 | 2018-04-24 06:49:57+00:00 | Bike | T--PHC-A---E--- | 3591.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |
| 13042 | 13042 | 2018-04-26 07:42:08+00:00 | Bike | T--PHC-A---E--- | 2684.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |
| 13053 | 13053 | 2018-05-03 07:27:53+00:00 | Bike | T--PHC-A---E--- | 3319.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |
| 13071 | 13071 | 2018-05-13 13:36:28+00:00 | Bike | T--PHC-A---E--- | 2697.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |
| 13074 | 13074 | 2018-05-15 06:50:34+00:00 | Bike | T--PHC-A---E--- | 3859.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |
| 13083 | 13083 | 2018-05-19 16:02:01+00:00 | Bike | T--PHC-A---E--- | 3568.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |
| 13086 | 13086 | 2018-05-24 14:05:40+00:00 | Bike | T--PHC-A---E--- | 5387.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |
| 13158 | 13158 | 2018-06-04 16:29:38+00:00 | Bike | T--PHC--------- | 748.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13159 | 13159 | 2018-06-05 02:56:31+00:00 | Bike | T--PHC--------- | 3601.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13346 | 13346 | 2019-01-09 13:25:23+00:00 | Bike | T--PHC--------- | 3601.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13351 | 13351 | 2019-01-15 15:57:43+00:00 | Bike | T--PHC--------- | 4428.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13352 | 13352 | 2019-01-17 16:07:49+00:00 | Bike | T--PHC--------- | 4924.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13355 | 13355 | 2019-01-22 16:09:46+00:00 | Bike | T--PHC--------- | 3601.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13356 | 13356 | 2019-01-24 16:19:54+00:00 | Bike | T--PHC--------- | 3601.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13359 | 13359 | 2019-01-29 15:52:57+00:00 | Bike | T--PHC--------- | 3598.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13360 | 13360 | 2019-01-31 16:00:17+00:00 | Bike | T--PHC--------- | 3722.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13362 | 13362 | 2019-02-04 16:38:21+00:00 | Bike | T--PHC--------- | 2221.0 | {1c11466e-fb84-4008-8c14-3b23ad95f5da} | |
| 13572 | 13572 | 2018-01-14 10:19:31+00:00 | Bike | T--PHC-A---EV-- | 6624.0 | {5d2bd528-f338-4d49-bbeb-b8d70f6cd38e} | |
| 14333 | 14333 | 2016-12-04 00:04:58+00:00 | Bike | T--PHC-A---E--- | 761.0 | {b8df10d5-da9a-4991-90e5-930838c9599c} | |
| 14522 | 14522 | 2017-09-01 22:53:08+00:00 | Bike | T--PHC-A---E--- | 2324.0 | {b8df10d5-da9a-4991-90e5-930838c9599c} | |
| 14523 | 14523 | 2017-09-01 23:55:23+00:00 | Bike | T--PHC-A---E--- | 2409.0 | {b8df10d5-da9a-4991-90e5-930838c9599c} | |
| 14607 | 14607 | 2017-12-19 12:29:34+00:00 | Bike | T--PHC-A---E--- | 6597.0 | {b8df10d5-da9a-4991-90e5-930838c9599c} | |
| 14609 | 14609 | 2017-12-22 20:45:52+00:00 | Bike | T--PHC-A---E--- | 4729.0 | {b8df10d5-da9a-4991-90e5-930838c9599c} | |
| 15165 | 15165 | 2016-06-02 07:29:11+00:00 | Bike | T--PHC-----EV-- | 2116.0 | {4acb16c8-015c-4f1f-8de5-c63bfc19ee6d} | |
| 15430 | 15430 | 2020-02-19 14:32:59+00:00 | Bike | TDSPHC-AGL-E--- | {ee04cfac-a3c8-4a96-9780-bf0b0999cf35} | ||
| 15979 | 15979 | 2014-11-24 16:06:36+00:00 | Bike | T--PHC-A------- | 415.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16029 | 16029 | 2014-12-24 16:15:48+00:00 | Bike | T--PHC-A------- | 1040.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16526 | 16526 | 2016-10-26 19:01:01+00:00 | Bike | T--PHC-A---E--- | 1036.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16527 | 16527 | 2016-10-26 19:22:23+00:00 | Bike | T--PHC-A---E--- | 2714.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16528 | 16528 | 2016-10-26 20:14:32+00:00 | Bike | T--PHC-A---E--- | 22.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16533 | 16533 | 2016-11-04 12:35:53+00:00 | Bike | T--PHC-A---E--- | 3291.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16566 | 16566 | 2016-12-29 19:04:21+00:00 | Bike | T--PHC-A---E--- | 4329.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16584 | 16584 | 2017-01-19 21:17:02+00:00 | Bike | T--PHC-A---E--- | 3807.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16743 | 16743 | 2017-09-20 08:44:14+00:00 | Bike | T--PHC-A---E--- | 3858.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16745 | 16745 | 2017-09-21 10:30:04+00:00 | Bike | T--PHC-A---E--- | 3886.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16746 | 16746 | 2017-09-23 18:47:18+00:00 | Bike | T--PHC-A---E--- | 3890.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16749 | 16749 | 2017-09-28 08:30:59+00:00 | Bike | T--PHC-A---E--- | 3902.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16759 | 16759 | 2017-11-03 09:31:17+00:00 | Bike | T--PHC-A---E--- | 3005.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16760 | 16760 | 2017-11-10 17:36:57+00:00 | Bike | T--PHC-A---E--- | 3622.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16761 | 16761 | 2017-11-11 15:17:50+00:00 | Bike | T--PHC-A---E--- | 3295.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16763 | 16763 | 2017-11-13 18:49:51+00:00 | Bike | T--PHC-A---E--- | 1451.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16764 | 16764 | 2017-11-14 14:50:02+00:00 | Bike | T--PHC-A---E--- | 3621.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16766 | 16766 | 2017-11-15 11:04:40+00:00 | Bike | T--PHC-A---E--- | 3611.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16768 | 16768 | 2017-11-16 17:24:58+00:00 | Bike | T--PHC-A---E--- | 1853.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16801 | 16801 | 2018-03-02 13:56:15+00:00 | Bike | T--PHC-----EV-- | 1203.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16803 | 16803 | 2018-03-02 14:22:49+00:00 | Bike | T--PHC-----EV-- | 1202.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16804 | 16804 | 2018-03-02 14:24:16+00:00 | Bike | T--PHC-A---EV-- | 1202.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16805 | 16805 | 2018-03-04 07:19:34+00:00 | Bike | T--PHC-----EV-- | 1202.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16806 | 16806 | 2018-03-04 07:21:01+00:00 | Bike | T--PHC-A---EV-- | 1202.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16807 | 16807 | 2018-03-07 18:36:53+00:00 | Bike | T--PHC-----EV-- | 1803.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16808 | 16808 | 2018-03-24 08:41:35+00:00 | Bike | T--PHC-----EV-- | 4324.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16809 | 16809 | 2018-03-24 08:43:20+00:00 | Bike | T--PHC-A---EV-- | 4323.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16810 | 16810 | 2018-03-25 07:29:20+00:00 | Bike | T--PHC-A---EV-- | 1266.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16811 | 16811 | 2018-03-25 07:35:02+00:00 | Bike | T--PHC-----EV-- | 822.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16812 | 16812 | 2018-03-25 07:50:54+00:00 | Bike | T--PHC-A---EV-- | 207.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16845 | 16845 | 2018-06-23 17:57:12+00:00 | Bike | T--PHC-A---EV-- | 3722.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16849 | 16849 | 2018-06-30 08:16:25+00:00 | Bike | T--PHC-----EV-- | 2312.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16858 | 16858 | 2018-07-26 17:34:48+00:00 | Bike | T--PHC-A---EV-- | 2124.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16859 | 16859 | 2018-07-30 17:36:53+00:00 | Bike | T--PHC-----EV-- | 2588.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16870 | 16870 | 2018-08-14 08:59:46+00:00 | Bike | T--PHC-----EV-- | 2682.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16882 | 16882 | 2018-09-17 11:10:09+00:00 | Bike | T--PHC-A---EV-- | 830.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16883 | 16883 | 2018-09-17 15:35:15+00:00 | Bike | T--PHC-A---EV-- | 5104.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16884 | 16884 | 2018-09-18 11:29:45+00:00 | Bike | T--PHC-A---EV-- | 302.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16885 | 16885 | 2018-09-18 12:07:26+00:00 | Bike | T--PHC-A---EV-- | 3305.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16886 | 16886 | 2018-09-19 11:21:50+00:00 | Bike | T--PHC-A---EV-- | 1192.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16887 | 16887 | 2018-09-19 18:23:50+00:00 | Bike | T--PHC-A---EV-- | 3300.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16888 | 16888 | 2018-09-20 18:24:04+00:00 | Bike | T--PHC-A---EV-- | 3690.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16889 | 16889 | 2018-09-22 19:13:12+00:00 | Bike | T--PHC-A---EV-- | 3289.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16890 | 16890 | 2018-09-25 08:49:05+00:00 | Bike | T--PHC-A---EV-- | 3298.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16891 | 16891 | 2018-09-26 09:48:08+00:00 | Bike | T--PHC-A---EV-- | 3675.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16892 | 16892 | 2018-09-27 08:09:52+00:00 | Bike | T--PHC-A---EV-- | 3633.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16907 | 16907 | 2018-10-11 18:14:37+00:00 | Bike | T--PHC-----EV-- | 3607.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16908 | 16908 | 2018-10-14 16:45:27+00:00 | Bike | T--PHC-----EV-- | 3621.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16909 | 16909 | 2018-10-14 16:45:43+00:00 | Bike | T--PHC-A---EV-- | 3615.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16910 | 16910 | 2018-10-15 17:12:24+00:00 | Bike | T--PHC-----EV-- | 2239.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16911 | 16911 | 2018-10-16 09:22:55+00:00 | Bike | T--PHC-----EV-- | 1804.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16912 | 16912 | 2018-10-17 08:50:22+00:00 | Bike | T--PHC-----EV-- | 3657.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16913 | 16913 | 2018-10-17 19:33:13+00:00 | Bike | T--PHC-----EV-- | 4165.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16914 | 16914 | 2018-10-18 17:18:24+00:00 | Bike | T--PHC-----EV-- | 5403.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16915 | 16915 | 2018-10-19 11:58:31+00:00 | Bike | T--PHC-----EV-- | 3327.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16916 | 16916 | 2018-10-23 17:14:31+00:00 | Bike | T--PHC-----EV-- | 4327.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16917 | 16917 | 2018-10-24 16:54:18+00:00 | Bike | T--PHC-----EV-- | 5359.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16918 | 16918 | 2018-10-25 17:09:09+00:00 | Bike | T--PHC-----EV-- | 3949.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16921 | 16921 | 2018-10-27 16:58:15+00:00 | Bike | T--PHC-----EV-- | 3892.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16922 | 16922 | 2018-10-28 17:05:36+00:00 | Bike | T--PHC-----EV-- | 5648.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16923 | 16923 | 2018-10-30 11:08:02+00:00 | Bike | T--PHC-----EV-- | 3190.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16924 | 16924 | 2018-10-31 10:35:43+00:00 | Bike | T--PHC-----EV-- | 3614.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16925 | 16925 | 2018-11-02 12:35:52+00:00 | Bike | T--PHC-----EV-- | 2044.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16926 | 16926 | 2018-11-03 13:35:04+00:00 | Bike | T--PHC-----EV-- | 3471.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16927 | 16927 | 2018-11-05 19:26:57+00:00 | Bike | T--PHC-----EV-- | 2297.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16928 | 16928 | 2018-11-15 11:29:11+00:00 | Bike | T--PHC-----EV-- | 3906.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16929 | 16929 | 2018-11-16 12:21:18+00:00 | Bike | T--PHC-----EV-- | 3666.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16930 | 16930 | 2018-11-17 13:38:54+00:00 | Bike | T--PHC-----EV-- | 3886.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16932 | 16932 | 2018-11-18 11:45:27+00:00 | Bike | T--PHC-----EV-- | 4323.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16933 | 16933 | 2018-11-18 18:45:02+00:00 | Bike | T--PHC-----EV-- | 2402.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16934 | 16934 | 2018-11-19 10:46:13+00:00 | Bike | T--PHC-----EV-- | 6271.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16935 | 16935 | 2018-11-20 12:25:12+00:00 | Bike | T--PHC-----EV-- | 3697.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16936 | 16936 | 2018-11-21 19:04:11+00:00 | Bike | T--PHC-----EV-- | 3292.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16937 | 16937 | 2018-11-23 16:42:00+00:00 | Bike | T--PHC-----EV-- | 4068.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} | |
| 16938 | 16938 | 2018-11-24 14:07:58+00:00 | Bike | T--PHC-----EV-- | 3203.0 | {d31f6c74-dde3-4b7f-bd1b-cd42e6f72404} |
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");