rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by athlete
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance | athlete ▼ |
|---|---|---|---|---|---|---|---|
| 2578737 | 2578737 | 2018-02-19 14:35:28+00:00 | Bike | TDSPHC-AGL----- | 9260.0 | 50.76951 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578738 | 2578738 | 2018-02-21 10:01:24+00:00 | Bike | TDSPHC-AGL----R | 16425.0 | 83.64948 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578739 | 2578739 | 2018-02-21 14:47:59+00:00 | Bike | T--PHC-A------- | 3614.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578740 | 2578740 | 2018-02-21 17:14:02+00:00 | Bike | T--PH--A------- | 3628.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578741 | 2578741 | 2018-02-22 05:10:58+00:00 | Bike | T--PHC-A------- | 2706.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578742 | 2578742 | 2018-02-22 09:55:25+00:00 | Bike | TDSPH--AGL----- | 14360.0 | 103.93816 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578743 | 2578743 | 2018-02-24 08:59:13+00:00 | Bike | TDSPHC-AGL----- | 9930.0 | 115.211 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578744 | 2578744 | 2018-02-25 08:44:41+00:00 | Bike | TDSPHC-AGL----- | 17823.0 | 131.45972 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578745 | 2578745 | 2018-02-26 07:17:15+00:00 | Bike | TDSPHC-AGL----R | 8372.0 | 68.75691 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578746 | 2578746 | 2018-03-02 18:14:55+00:00 | Bike | T--PH--A------- | 3616.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578747 | 2578747 | 2018-03-03 16:21:38+00:00 | Bike | T--PHC-A------R | 8156.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578748 | 2578748 | 2018-03-05 09:03:33+00:00 | Bike | TDSPH--AGL----- | 7482.0 | 61.38685 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578749 | 2578749 | 2018-03-05 15:05:20+00:00 | Bike | T--PHC-A------- | 3187.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578750 | 2578750 | 2018-03-06 10:01:04+00:00 | Bike | TDSPHC-AGL----- | 16930.0 | 118.70545 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578751 | 2578751 | 2018-03-06 15:08:52+00:00 | Bike | T--PHC-A------- | 1014.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578752 | 2578752 | 2018-03-07 12:25:36+00:00 | Bike | TDSPHC-AGL----- | 16362.0 | 130.33186 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578753 | 2578753 | 2018-03-08 09:09:29+00:00 | Bike | TDSPHC-AGL----- | 7811.0 | 51.16592 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578754 | 2578754 | 2018-03-08 14:07:37+00:00 | Bike | TDSPH--AGL----- | 12684.0 | 105.02869 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578755 | 2578755 | 2018-03-09 11:33:35+00:00 | Bike | TDSPHC-AGL----- | 6634.0 | 51.971 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578756 | 2578756 | 2018-03-10 13:57:09+00:00 | Bike | TDSPHC-AGL----- | 7980.0 | 88.9931 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578757 | 2578757 | 2018-03-11 08:56:28+00:00 | Bike | TDSPHC-AGL----R | 7349.0 | 79.2182 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578758 | 2578758 | 2018-03-14 09:49:26+00:00 | Bike | TDSPHC-AGL----- | 5089.0 | 39.15672 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578759 | 2578759 | 2018-03-16 09:00:30+00:00 | Bike | TDSPHC-AGL----- | 3128.0 | 21.24874 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578760 | 2578760 | 2018-03-18 17:16:39+00:00 | Bike | T--PHC-A------- | 3520.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578761 | 2578761 | 2018-03-18 18:53:37+00:00 | Bike | T--PHC-A------- | 2477.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578762 | 2578762 | 2018-03-19 09:04:48+00:00 | Bike | T--PHC-A------- | 4206.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578763 | 2578763 | 2018-03-19 18:12:06+00:00 | Bike | T--PHC-A------- | 1811.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578764 | 2578764 | 2018-03-20 16:47:21+00:00 | Bike | TDSPHC-AGL----- | 4462.0 | 36.32527 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578765 | 2578765 | 2018-03-21 10:53:12+00:00 | Bike | TDSPHC-AGL----- | 1247.0 | 13.26498 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578766 | 2578766 | 2018-03-21 12:08:52+00:00 | Bike | TDSPHC-AGL----- | 5087.0 | 51.7117 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578767 | 2578767 | 2018-03-22 09:29:39+00:00 | Bike | TDSPHC-AGL----R | 7159.0 | 61.71787 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578768 | 2578768 | 2018-03-22 14:39:24+00:00 | Bike | TDSPHC-AGL----- | 10095.0 | 74.9648 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578769 | 2578769 | 2018-03-23 11:51:26+00:00 | Bike | TDSPHC-AGL----- | 7481.0 | 46.796 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578770 | 2578770 | 2018-03-24 08:20:12+00:00 | Bike | TDSPH--AGL----- | 7895.0 | 45.3664 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578771 | 2578771 | 2018-03-25 08:00:07+00:00 | Bike | TDSPHC-AGL----- | 8792.0 | 85.7792 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578772 | 2578772 | 2018-03-25 10:26:59+00:00 | Bike | TDSPHC-AGL----- | 2971.0 | 15.18407 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578773 | 2578773 | 2018-03-27 08:53:34+00:00 | Bike | TDSPHC-AGL----- | 12208.0 | 91.32908 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578774 | 2578774 | 2018-03-28 09:25:21+00:00 | Bike | TDSPH--AGL----- | 22800.0 | 174.55508 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578775 | 2578775 | 2018-03-29 09:12:34+00:00 | Bike | TDSPHC-AGL----- | 10490.0 | 57.11887 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578776 | 2578776 | 2018-03-30 08:29:19+00:00 | Bike | TDSPHC-AGL----- | 15070.0 | 97.82698 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578777 | 2578777 | 2018-03-31 07:12:47+00:00 | Bike | TDSP-C-AGL----- | 3372.0 | 0.00234 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578778 | 2578778 | 2018-04-05 08:49:19+00:00 | Bike | TDSP-C-AGL----- | 5422.0 | 32.58645 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578779 | 2578779 | 2018-04-16 07:14:42+00:00 | Bike | TDSP-C-AGL----- | 10580.0 | 90.55437 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578780 | 2578780 | 2018-04-17 15:39:42+00:00 | Bike | TDSP-C-AGL----- | 11122.0 | 99.13826 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578781 | 2578781 | 2018-04-18 09:25:34+00:00 | Bike | TDSP-C-AGL----- | 20020.0 | 144.70723 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578782 | 2578782 | 2018-04-19 08:17:48+00:00 | Bike | TDSP-C-AGL----- | 19561.0 | 141.34035 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578783 | 2578783 | 2018-04-20 10:26:57+00:00 | Bike | TDSP-C-AGL----- | 4441.0 | 32.48085 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578784 | 2578784 | 2018-04-21 07:45:13+00:00 | Bike | TDSP-C-AGL----- | 17306.0 | 115.86689 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578785 | 2578785 | 2018-04-22 06:45:35+00:00 | Bike | TDSP-C-AGL----- | 10567.0 | 74.4366 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578786 | 2578786 | 2018-04-23 14:26:46+00:00 | Bike | TDSP-C-AGL----- | 8382.0 | 52.44031 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578787 | 2578787 | 2018-04-24 13:37:47+00:00 | Bike | TDSP-C-AGL----- | 15022.0 | 121.32465 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578788 | 2578788 | 2018-04-25 09:15:36+00:00 | Bike | TDSP-C-AGL----- | 21516.0 | 153.22065 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578789 | 2578789 | 2018-04-26 06:42:33+00:00 | Bike | TDSP-C-AGL----- | 24108.0 | 167.29742 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578790 | 2578790 | 2018-04-27 14:49:45+00:00 | Bike | TDSP-C-AGL----- | 9577.0 | 72.64567 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578791 | 2578791 | 2018-04-28 07:16:44+00:00 | Bike | TDSP-C-AGL----- | 9232.0 | 54.32581 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578792 | 2578792 | 2018-04-29 07:48:51+00:00 | Bike | TDSP-C-AGL----- | 14673.0 | 150.46995 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578793 | 2578793 | 2018-04-30 07:07:30+00:00 | Bike | TDSP-C-AGL----- | 4731.0 | 33.33456 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578794 | 2578794 | 2018-04-30 15:17:09+00:00 | Bike | TDSP-C-AGL----- | 8406.0 | 60.68691 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578795 | 2578795 | 2018-05-01 06:02:29+00:00 | Bike | TDSP-C-AGL----- | 11367.0 | 106.73575 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578796 | 2578796 | 2018-05-01 15:12:32+00:00 | Bike | TDSP-C-AGL----- | 7857.0 | 63.30029 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578797 | 2578797 | 2018-05-02 09:07:23+00:00 | Bike | TDSP-C-AGL----- | 10932.0 | 69.14977 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578798 | 2578798 | 2018-05-03 08:25:32+00:00 | Bike | TDSP-C-AGL----- | 14949.0 | 96.24379 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578799 | 2578799 | 2018-05-04 15:15:48+00:00 | Bike | TDSP-C-AGL----- | 9150.0 | 70.22296 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578800 | 2578800 | 2018-05-05 07:07:11+00:00 | Bike | TDSP-C-AGL----- | 11324.0 | 78.9568 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578801 | 2578801 | 2018-05-06 07:38:53+00:00 | Bike | TDSP-C-AGL----- | 12585.0 | 145.64913 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578802 | 2578802 | 2018-05-08 15:16:39+00:00 | Bike | TDSP-C-AGL----- | 6900.0 | 60.26751 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578803 | 2578803 | 2018-05-09 09:11:25+00:00 | Bike | TDSP-C-AGL----- | 20906.0 | 157.3999 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578804 | 2578804 | 2018-05-10 11:45:36+00:00 | Bike | TDSP-C-AGL----- | 10459.0 | 83.52769 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578805 | 2578805 | 2018-05-11 16:25:19+00:00 | Bike | TDSP-C-AGL----- | 4353.0 | 37.6787 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578806 | 2578806 | 2018-05-12 13:03:32+00:00 | Bike | TDSP-C-AGL----- | 6582.0 | 74.0556 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578807 | 2578807 | 2018-05-13 08:30:11+00:00 | Bike | TDSP-C-AGL----- | 9819.0 | 114.102 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578809 | 2578809 | 2018-05-15 09:39:38+00:00 | Bike | TDSP-C-AGL----- | 6557.0 | 49.45101 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578810 | 2578810 | 2018-05-15 11:31:50+00:00 | Bike | TDSP-C-AGL----- | 9798.0 | 79.86258 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578812 | 2578812 | 2018-05-16 15:53:34+00:00 | Bike | TDSP-C-AGL----- | 7160.0 | 55.9403 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578813 | 2578813 | 2018-05-17 07:31:21+00:00 | Bike | TDSP-C-AGL----- | 12800.0 | 74.6513 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578814 | 2578814 | 2018-05-18 11:26:48+00:00 | Bike | TDSP-C-AGL----- | 12102.0 | 147.83319 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578815 | 2578815 | 2018-05-19 12:07:49+00:00 | Bike | TDSP-C-AGL----- | 11119.0 | 115.98467 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578816 | 2578816 | 2018-05-20 08:09:40+00:00 | Bike | TDSP-C-AGL----- | 12896.0 | 69.9048 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578818 | 2578818 | 2018-05-21 09:15:34+00:00 | Bike | TDSP-C-AGL----- | 9084.0 | 58.26338 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578819 | 2578819 | 2018-05-22 14:08:35+00:00 | Bike | TDSP-C-AGL----- | 13061.0 | 142.071 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578820 | 2578820 | 2018-05-24 15:55:32+00:00 | Bike | TDSP-C-AGL----- | 8113.0 | 68.71582 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578821 | 2578821 | 2018-05-25 07:50:24+00:00 | Bike | TDSP-C-AGL----- | 10503.0 | 56.67017 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578822 | 2578822 | 2018-05-26 14:07:59+00:00 | Bike | TDSP-C-AGL----- | 6351.0 | 73.8788 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578823 | 2578823 | 2018-05-27 08:06:29+00:00 | Bike | TDSP-C-AGL----- | 7961.0 | 57.1577 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578824 | 2578824 | 2018-05-30 06:52:16+00:00 | Bike | TDSP-C-AGL----- | 8548.0 | 62.44133 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578825 | 2578825 | 2018-05-30 16:37:26+00:00 | Bike | TDSP-C-AGL----- | 8201.0 | 70.54682 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578826 | 2578826 | 2018-05-31 09:41:29+00:00 | Bike | TDSP-C-AGL----- | 8756.0 | 56.35854 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578827 | 2578827 | 2018-06-03 08:02:19+00:00 | Bike | TDSP-C-AGL----- | 18053.0 | 137.31721 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578828 | 2578828 | 2018-06-04 09:03:23+00:00 | Bike | TDSP-C-AGL----- | 7186.0 | 48.92208 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578829 | 2578829 | 2018-06-05 06:12:16+00:00 | Bike | TDSP-C-AGL----- | 19162.0 | 140.616 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578830 | 2578830 | 2018-06-06 08:09:18+00:00 | Bike | TDSP-C-AGL----- | 6191.0 | 36.2351 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578831 | 2578831 | 2018-06-07 07:32:12+00:00 | Bike | TDSP-C-AGL----- | 6072.0 | 39.93466 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578832 | 2578832 | 2018-06-08 14:05:39+00:00 | Bike | TDSP-C-AGL----- | 12050.0 | 129.69107 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578833 | 2578833 | 2018-06-09 12:00:33+00:00 | Bike | TDSP-C-AGL----- | 17507.0 | 158.159 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578834 | 2578834 | 2018-06-10 08:36:43+00:00 | Bike | TDSP-C-AGL----- | 10040.0 | 103.75305 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578835 | 2578835 | 2018-06-11 13:27:52+00:00 | Bike | TDSP-C-AGL----- | 8190.0 | 67.3514 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578836 | 2578836 | 2018-06-12 14:01:55+00:00 | Bike | TDSP-C-AGL----- | 5293.0 | 56.10874 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578837 | 2578837 | 2018-06-13 13:59:40+00:00 | Bike | TDSP-C-AGL----- | 11454.0 | 127.67 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578838 | 2578838 | 2018-06-15 10:27:27+00:00 | Bike | TDSP-C-AGL----- | 7176.0 | 46.96812 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578839 | 2578839 | 2018-06-16 12:00:34+00:00 | Bike | TDSP-C-AGL----- | 10669.0 | 107.267 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
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");