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 sport
This data as json, CSV (advanced)
| Link | rowid | date | sport ▼ | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 4505 | 4505 | 2017-09-13 09:22:55+00:00 | TDSPHC-AGL-E--- | 2622.0 | 16.4479 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4506 | 4506 | 2017-09-13 20:45:03+00:00 | TDSPHC-AGL-E--- | 6529.0 | 35.372 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4507 | 4507 | 2017-09-14 09:21:05+00:00 | TDSPHC-AGL-E--- | 2641.0 | 16.9201 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4508 | 4508 | 2017-09-14 21:37:54+00:00 | TDSPHC-AGL-E--- | 3411.0 | 18.8722 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4509 | 4509 | 2017-09-15 09:24:41+00:00 | TDSPHC-AGL-E--- | 2522.0 | 16.7211 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4510 | 4510 | 2017-09-15 21:09:45+00:00 | TDSPHC-AGL-E--- | 4151.0 | 32.1232 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4511 | 4511 | 2017-09-16 06:59:26+00:00 | TDSPHC-AGL-E--- | 2450.0 | 1.06036 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4512 | 4512 | 2017-09-16 21:58:09+00:00 | TDSPHC-AGL-E--- | 3030.0 | 22.5889 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4513 | 4513 | 2017-09-17 21:09:10+00:00 | TDSPHC-AGL-E--- | 5366.0 | 33.0164 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4514 | 4514 | 2017-09-18 08:48:21+00:00 | TDSPHC-AGL-E--- | 2496.0 | 16.6926 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4515 | 4515 | 2017-09-18 20:53:04+00:00 | TDSPHC-AGL-E--- | 6001.0 | 34.3157 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4516 | 4516 | 2017-09-19 08:32:47+00:00 | TDSPHC-AGL-E--- | 2535.0 | 16.6876 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4517 | 4517 | 2017-09-19 20:57:23+00:00 | TDSPHC-AGL-E--- | 5839.0 | 37.7598 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4518 | 4518 | 2017-09-20 10:21:59+00:00 | TDSPHC-AGL-E--- | 2344.0 | 17.8836 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4519 | 4519 | 2017-09-20 21:00:24+00:00 | TDSPHC-AGL-E--- | 6055.0 | 41.0044 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4520 | 4520 | 2017-09-21 10:23:29+00:00 | TDSPHC-AGL-E--- | 2555.0 | 16.9021 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4521 | 4521 | 2017-09-21 21:40:01+00:00 | TDSPHC-AGL-E--- | 3271.0 | 17.7342 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4522 | 4522 | 2017-09-22 10:23:48+00:00 | TDSPHC-AGL-E--- | 2654.0 | 16.973 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4523 | 4523 | 2017-09-22 23:11:03+00:00 | TDSPHC-AGL-E--- | 10178.0 | 75.5882 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4524 | 4524 | 2017-09-23 21:14:23+00:00 | TDSPHC-AGL-E--- | 14349.0 | 108.85 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4526 | 4526 | 2017-09-24 21:41:53+00:00 | TDSPHC-AGL-E--- | 3234.0 | 19.0228 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4527 | 4527 | 2017-09-25 10:20:45+00:00 | TDSPHC-AGL-E--- | 2374.0 | 16.9551 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4528 | 4528 | 2017-09-25 20:52:08+00:00 | TDSPHC-AGL-E--- | 6015.0 | 37.3058 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4529 | 4529 | 2017-09-26 10:24:52+00:00 | TDSPHC-AGL-E--- | 2549.0 | 16.8293 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4530 | 4530 | 2017-09-26 20:48:20+00:00 | TDSPHC-AGL-E--- | 4974.0 | 31.5893 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4532 | 4532 | 2017-09-27 21:35:56+00:00 | TDSPHC-AGL-E--- | 3639.0 | 18.9759 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4534 | 4534 | 2017-09-28 21:04:43+00:00 | TDSPHC-AGL-E--- | 5333.0 | 30.5495 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4537 | 4537 | 2017-09-30 06:57:44+00:00 | TDSPHC-AGL-E--- | 2902.0 | 21.4087 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4540 | 4540 | 2017-09-30 22:54:03+00:00 | TDSPHC-AGL-E--- | 6225.0 | 33.3556 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4541 | 4541 | 2017-10-01 00:49:29+00:00 | TDSPHC-AGL-E--- | 3867.0 | 17.5911 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4542 | 4542 | 2017-10-01 02:10:20+00:00 | TDSPHC-AGL-E--- | 8336.0 | 37.5937 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4543 | 4543 | 2017-10-01 09:59:49+00:00 | TDSPHC-AGL-E--- | 1922.0 | 0.52282 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4544 | 4544 | 2017-10-02 21:38:57+00:00 | TDSPHC-AGL-E--- | 3941.0 | 18.296 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4545 | 4545 | 2017-10-03 08:55:29+00:00 | TDSPHC-AGL-E--- | 2862.0 | 16.6955 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4546 | 4546 | 2017-10-03 11:15:09+00:00 | TDSPHC-AGL-E--- | 2522.0 | 0.62381 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4547 | 4547 | 2017-10-03 21:06:49+00:00 | TDSPHC-AGL-E--- | 5288.0 | 26.8278 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4548 | 4548 | 2017-10-04 08:52:39+00:00 | TDSPHC-AGL-E--- | 2450.0 | 16.6849 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4549 | 4549 | 2017-10-04 10:57:25+00:00 | TDSPHC-AGL-E--- | 3602.0 | 0.97636 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4550 | 4550 | 2017-10-04 21:12:40+00:00 | TDSPHC-AGL-E--- | 5081.0 | 27.8745 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4552 | 4552 | 2017-10-05 11:29:20+00:00 | TDSPHC-AGL-E--- | 2903.0 | 23.4165 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4553 | 4553 | 2017-10-05 21:03:13+00:00 | TDSPHC-AGL-E--- | 5038.0 | 24.8626 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4555 | 4555 | 2017-10-07 05:09:39+00:00 | TDSPHC-AGL-E--- | 5796.0 | 29.1501 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4556 | 4556 | 2017-10-07 21:57:10+00:00 | TDSPHC-AGL-E--- | 15044.0 | 83.4711 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4559 | 4559 | 2017-10-09 21:42:27+00:00 | TDSPHC-AGL-E--- | 3352.0 | 19.0285 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4560 | 4560 | 2017-10-10 08:54:51+00:00 | TDSPHC-AGL-E--- | 2810.0 | 16.9081 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4561 | 4561 | 2017-10-10 11:36:18+00:00 | TDSPHC-AGL-E--- | 1863.0 | 0.57824 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4562 | 4562 | 2017-10-10 21:05:22+00:00 | TDSPHC-AGL-E--- | 5450.0 | 30.6641 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4563 | 4563 | 2017-10-11 09:22:22+00:00 | TDSPHC-AGL-E--- | 2779.0 | 16.6322 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4564 | 4564 | 2017-10-11 09:45:46+00:00 | TDSPHC-AGL-E--- | 305.0 | 0.03082 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4565 | 4565 | 2017-10-11 11:28:44+00:00 | TDSPHC-AGL-E--- | 2522.0 | 0.62759 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4566 | 4566 | 2017-10-11 21:28:27+00:00 | TDSPHC-AGL-E--- | 4012.0 | 22.6366 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4567 | 4567 | 2017-10-12 09:25:40+00:00 | TDSPHC-AGL-E--- | 2492.0 | 16.6347 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4568 | 4568 | 2017-10-12 21:00:09+00:00 | TDSPHC-AGL-E--- | 5738.0 | 32.7453 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4570 | 4570 | 2017-10-13 09:05:57+00:00 | TDSPHC-AGL-E--- | 2351.0 | 0.40544 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4572 | 4572 | 2017-10-14 23:00:53+00:00 | TDSPHC-AGL-E--- | 3426.0 | 0.90945 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4573 | 4573 | 2017-10-15 06:47:34+00:00 | TDSPHC-AGL-E--- | 6511.0 | 1.15783 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4574 | 4574 | 2017-10-15 09:03:23+00:00 | TDSPHC-AGL-E--- | 2297.0 | 0.57995 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4577 | 4577 | 2017-10-16 21:05:00+00:00 | TDSPHC-AGL-E--- | 5333.0 | 28.5919 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4580 | 4580 | 2017-10-17 21:09:21+00:00 | TDSPHC-AGL-E--- | 5115.0 | 32.1195 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4582 | 4582 | 2017-10-18 08:14:19+00:00 | TDSPHC-AGL-E--- | 2642.0 | 16.6695 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4744 | 4744 | 2017-12-31 07:34:55+00:00 | TDSPHC-AGL-E--- | 6.0 | 0.03258 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4745 | 4745 | 2018-01-01 08:07:14+00:00 | TDSPHC-AGL-E--- | 6.0 | 0.03388 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4746 | 4746 | 2018-01-01 22:26:15+00:00 | TDSPHC-AGL-E--- | 8.0 | 0.02639 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4747 | 4747 | 2018-01-02 22:52:22+00:00 | TDSPHC-AGL-E--- | 3.0 | 0.01371 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4748 | 4748 | 2018-01-03 23:05:39+00:00 | TDSPH--AGL-E--- | 4.0 | 0.01066 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4894 | 4894 | 2018-03-03 22:00:17+00:00 | TDSPHC-AGL-E--- | 4373.0 | 1.5873 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4913 | 4913 | 2018-03-10 06:58:10+00:00 | TDSPHC-AGL-E--- | 3820.0 | 0.61982 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4915 | 4915 | 2018-03-10 23:51:41+00:00 | TDSPHC-AGL-E--- | 13831.0 | 81.8339 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 5388 | 5388 | 2018-09-29 02:35:50+00:00 | TDSPHC-AGL----- | 4314.0 | 49.1413 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 5946 | 5946 | 2019-06-01 08:32:56+00:00 | TDSPHC-AGL-E--- | 40852.0 | 4.00706 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 6824 | 6824 | 2018-02-17 12:12:26+00:00 | TDSPHC-----EV-- | 1808.0 | 26.6015 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6833 | 6833 | 2018-03-02 12:05:39+00:00 | TDSPHC-----EV-- | 2073.0 | 30.7458 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6834 | 6834 | 2018-03-10 11:53:02+00:00 | TDSPHC-----EV-- | 3600.0 | 51.829 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6835 | 6835 | 2018-03-11 11:25:39+00:00 | TDSPHC-----EV-- | 3600.0 | 53.2767 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6836 | 6836 | 2018-03-13 11:46:34+00:00 | TDSPHC-----EV-- | 3600.0 | 51.6886 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6837 | 6837 | 2018-03-15 18:39:20+00:00 | TDSPHC-----EV-- | 1810.0 | 26.6031 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6839 | 6839 | 2018-03-19 18:01:32+00:00 | TDSPHC-----EV-- | 1858.0 | 26.9941 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6841 | 6841 | 2018-03-21 12:56:01+00:00 | TDSPHC-----EV-- | 1819.0 | 27.1756 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6843 | 6843 | 2018-03-26 17:39:30+00:00 | TDSPHC-----EV-- | 1809.0 | 26.871 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6844 | 6844 | 2018-03-27 10:51:27+00:00 | TDSPHC-----EV-- | 2605.0 | 42.1864 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6847 | 6847 | 2018-04-02 10:58:01+00:00 | TDSPHC-----EV-- | 3599.0 | 57.1862 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6863 | 6863 | 2018-05-10 10:43:18+00:00 | TDSPHC-----EV-- | 4874.0 | 81.7472 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6864 | 6864 | 2018-05-15 11:23:35+00:00 | TDSPHC-----EV-- | 3600.0 | 61.4509 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6865 | 6865 | 2018-05-16 06:51:54+00:00 | TDSPHC-----EV-- | 4361.0 | 72.05675 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6867 | 6867 | 2018-05-20 10:16:51+00:00 | TDSPHC-----EV-- | 4499.0 | 75.25778 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6868 | 6868 | 2018-05-23 13:05:36+00:00 | TDSPHC-----EV-- | 4140.0 | 75.4448 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6869 | 6869 | 2018-05-24 11:10:43+00:00 | TDSPHC-----EV-- | 3599.0 | 62.0614 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6870 | 6870 | 2018-05-25 11:44:24+00:00 | TDSPHC-----EV-- | 3300.0 | 53.6218 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6871 | 6871 | 2018-05-30 10:29:10+00:00 | TDSPHC-----EV-- | 3599.0 | 59.69091 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6872 | 6872 | 2018-05-31 10:21:52+00:00 | TDSPHC-----EV-- | 4874.0 | 82.33895 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6873 | 6873 | 2018-06-20 07:07:22+00:00 | TDSPH------E--- | 3599.0 | 63.6147 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6874 | 6874 | 2018-06-22 07:03:24+00:00 | TDSPH------E--- | 4874.0 | 87.6619 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6875 | 6875 | 2018-07-09 11:07:41+00:00 | TDSPHC-----E--- | 3006.0 | 16.0359 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6876 | 6876 | 2018-07-10 06:15:11+00:00 | TDSPHC-----E--- | 3003.0 | 17.138 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6877 | 6877 | 2018-07-11 06:14:32+00:00 | TDSPHC-----E--- | 3003.0 | 18.35567 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6878 | 6878 | 2018-07-17 06:27:18+00:00 | TDSPHC-----E--- | 3302.0 | 19.8367 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6879 | 6879 | 2018-07-19 06:08:02+00:00 | TDSPHC-----E--- | 3599.0 | 22.0113 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6880 | 6880 | 2018-07-20 06:06:23+00:00 | TDSPHC-----E--- | 3301.0 | 18.50547 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6881 | 6881 | 2018-07-23 10:37:50+00:00 | TDSPHC-----E--- | 3000.0 | 18.77323 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6882 | 6882 | 2018-07-24 05:54:06+00:00 | TDSPHC-----E--- | 2172.0 | 13.9847 | {dedad338-12be-45f6-8316-5258e560a5fe} |
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");