rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by sport descending
This data as json, CSV (advanced)
| Link | rowid | date | sport ▲ | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 379028 | 379028 | 2020-01-19 09:04:12+00:00 | 🚴🏽♂️ TrainingCamp #CiudadDeAstorga2020 | TDSP-C-AGL-E--- | 10701.0 | 89.8996 | {9545778b-c44a-44e4-b947-70d52c5d25de} |
| 2384184 | 2384184 | 2018-02-17 08:47:49+00:00 | 😎solo😔😞👍 | TDSPHC-AGL----- | 28006.0 | 185.249 | {799ec19f-a69e-4c5d-88eb-7b5621851218} |
| 2384218 | 2384218 | 2018-04-29 06:49:21+00:00 | 🏇🏇🏇western | TDSPHC-AGL-E--- | 18927.0 | 119.036 | {799ec19f-a69e-4c5d-88eb-7b5621851218} |
| 959399 | 959399 | 2019-12-18 08:06:55+00:00 | 🍓🥦 | TDSP-C-AGL-E--- | 14601.0 | 106.308 | {8246c69a-0eb4-484c-820c-28c9593581d7} |
| 959401 | 959401 | 2019-12-21 08:49:54+00:00 | 🌞 | TDSP-C-AGL-E--- | 12007.0 | 71.7304 | {8246c69a-0eb4-484c-820c-28c9593581d7} |
| 167054 | 167054 | 2020-04-18 23:08:21+00:00 | 피노키오 with 사이클존 | TDSPHC-AGL-E--- | 10115.0 | 76.8612 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167068 | 167068 | 2020-04-25 23:44:56+00:00 | 정안 ic with 사이클존 | TDSPHC-AGL-E--- | 10361.0 | 88.9862 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167053 | 167053 | 2020-04-18 03:21:52+00:00 | 접대라이딩 | TDSPHC-AGL-E--- | 13486.0 | 70.2009 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167061 | 167061 | 2020-04-23 11:32:50+00:00 | 저녁 라이딩 | TDSPHC-AGL-E--- | 1078.0 | 7.1615 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167066 | 167066 | 2020-04-24 10:36:37+00:00 | 저녁 라이딩 | TDSPHC-A-L-E--- | 2266.0 | 18.3789 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167072 | 167072 | 2020-04-30 09:29:25+00:00 | 저녁 라이딩 | TDSPHC-AGL-E--- | 5500.0 | 42.3861 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167051 | 167051 | 2020-04-17 08:11:05+00:00 | 오후 라이딩 | TDSPHC-AGL-E--- | 1662.0 | 7.0995 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167049 | 167049 | 2020-04-17 00:33:47+00:00 | 오전 라이딩 | TDSPHC--------- | 2761.0 | 18.9151 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167052 | 167052 | 2020-04-18 00:26:08+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 2080.0 | 7.9039 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167056 | 167056 | 2020-04-20 21:29:51+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 1684.0 | 12.1329 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167057 | 167057 | 2020-04-20 22:05:40+00:00 | 오전 라이딩 | TDSPHC-A-L-E--- | 2868.0 | 13.474 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167058 | 167058 | 2020-04-20 23:01:13+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 1144.0 | 6.5597 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167060 | 167060 | 2020-04-22 01:54:30+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 1123.0 | 7.3454 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167065 | 167065 | 2020-04-23 23:43:56+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 3283.0 | 11.4108 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167069 | 167069 | 2020-04-27 22:09:01+00:00 | 오전 라이딩 | TDSPHC-A-L-E--- | 2376.0 | 19.8391 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167071 | 167071 | 2020-04-28 23:45:10+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 1348.0 | 7.3055 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167074 | 167074 | 2020-04-30 21:45:04+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 1478.0 | 11.6442 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167075 | 167075 | 2020-04-30 22:16:55+00:00 | 오전 라이딩 | TDSPHC-A-L-E--- | 2027.0 | 15.2973 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167076 | 167076 | 2020-04-30 23:14:45+00:00 | 오전 라이딩 | TDSPHC-AGL-E--- | 1160.0 | 6.5183 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167077 | 167077 | 2020-05-03 00:45:47+00:00 | 오전 라이딩 | TDSPHC-A-L-E--- | 6774.0 | 101.685 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167055 | 167055 | 2020-04-20 13:16:56+00:00 | 야간 라이딩 | TDSPHC-AGL-E--- | 1715.0 | 7.836 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167059 | 167059 | 2020-04-21 13:23:21+00:00 | 야간 라이딩 | TDSPHC-AGL-E--- | 1353.0 | 7.5849 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167062 | 167062 | 2020-04-23 12:08:25+00:00 | 야간 라이딩 | T--PHC-A---E--- | 1051.0 | {41e8c2bf-50af-4199-9764-e5298d436ed6} | |
| 167063 | 167063 | 2020-04-23 12:41:55+00:00 | 야간 라이딩 | T--PHC-A---E--- | 1214.0 | {41e8c2bf-50af-4199-9764-e5298d436ed6} | |
| 167064 | 167064 | 2020-04-23 13:31:20+00:00 | 야간 라이딩 | TDSPHC-AGL-E--- | 1864.0 | 11.4742 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167070 | 167070 | 2020-04-28 14:16:43+00:00 | 야간 라이딩 | TDSPHC-AGL-E--- | 1268.0 | 7.3931 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167073 | 167073 | 2020-04-30 15:02:12+00:00 | 야간 라이딩 | TDSPHC-AGL-E--- | 1316.0 | 7.6075 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 167067 | 167067 | 2020-04-24 23:04:09+00:00 | 사이클존-피반령 똥바람 | TDSPHC-AGL-E--- | 13392.0 | 85.7512 | {41e8c2bf-50af-4199-9764-e5298d436ed6} |
| 428742 | 428742 | 2019-04-06 02:47:51+00:00 | 花見ライド | TDSPHC-AGL-E--- | 13858.0 | 58.8403 | {7e2cc902-612f-44de-ad76-324d25219d1a} |
| 1100149 | 1100149 | 2020-02-05 13:49:27+00:00 | 澄清湖*5 | TDSPHC-AGL-E--- | 3758.0 | 34.9003 | {09504cba-b5b4-4b28-ac25-196b1b2d4246} |
| 1100151 | 1100151 | 2020-02-10 13:55:48+00:00 | 澄清湖*4 | TDSPHC-AGL-E--- | 3820.0 | 30.4599 | {09504cba-b5b4-4b28-ac25-196b1b2d4246} |
| 428756 | 428756 | 2019-05-06 00:31:46+00:00 | 朝のライド | TDSPHC-AGL-E--- | 27268.0 | 88.5725 | {7e2cc902-612f-44de-ad76-324d25219d1a} |
| 1100150 | 1100150 | 2020-02-08 22:50:51+00:00 | 月世界 田寮 中寮山 | TDSPHC-AGL-E--- | 21025.0 | 83.1892 | {09504cba-b5b4-4b28-ac25-196b1b2d4246} |
| 416167 | 416167 | 2020-03-30 13:42:53+00:00 | 晚间活动 | TDSPHC-AGL-E--- | 466.0 | 1.4414 | {2c0c2c07-fbf7-471d-ba96-99b7bd2cc89d} |
| 1100148 | 1100148 | 2020-02-05 09:50:39+00:00 | 午後騎乘 | TDSPHC-AGL-E--- | 1200.0 | 5.9156 | {09504cba-b5b4-4b28-ac25-196b1b2d4246} |
| 428747 | 428747 | 2019-04-18 07:58:44+00:00 | 午後のライド | TDSPHC-AGL-E--- | 5500.0 | 33.3562 | {7e2cc902-612f-44de-ad76-324d25219d1a} |
| 1895742 | 1895742 | 2019-12-08 04:58:29+00:00 | 全日本選手権シクロクロス 男子エリート | TDSPHC-AGL-E--- | 2902.0 | 14.7829 | {dabde884-825f-4257-bce2-feb184be5f4f} |
| 1100152 | 1100152 | 2020-02-12 06:25:13+00:00 | 中寮山 旗山 | TDSPHC-AGL-E--- | 11544.0 | 75.0143 | {09504cba-b5b4-4b28-ac25-196b1b2d4246} |
| 428745 | 428745 | 2019-04-13 01:08:22+00:00 | ハルヒル試走 | TDSPHC-AGL-E--- | 23529.0 | 63.5452 | {7e2cc902-612f-44de-ad76-324d25219d1a} |
| 1895723 | 1895723 | 2019-12-02 13:24:14+00:00 | クロス車ポジション出しローラー | TDSPHC-----E--- | 903.0 | 3.0238 | {dabde884-825f-4257-bce2-feb184be5f4f} |
| 1137028 | 1137028 | 2020-01-23 21:52:44+00:00 | ☁️ Sortie à vélo nocturne | TDSP-C-AGL-E--- | 140.0 | 0.0007 | {c0ed4a38-6eb7-481b-95b8-193fe4e55054} |
| 1137075 | 1137075 | 2020-02-08 13:07:01+00:00 | ☁️ Endurance i1-i2 - Vo2max 49 -> 50 | TDSPHC-AGL-E--- | 7404.0 | 52.9932 | {c0ed4a38-6eb7-481b-95b8-193fe4e55054} |
| 1137032 | 1137032 | 2020-01-25 12:51:12+00:00 | ☁️ En solo | TDSPHC-AGL-E--- | 8654.0 | 57.8241 | {c0ed4a38-6eb7-481b-95b8-193fe4e55054} |
| 2349615 | 2349615 | 2018-10-13 11:02:20+00:00 | ☀️sunshine reggae☀️ Flughafen...Steile Wand | TDSP-C-AGL-E--- | 15652.0 | 126.346 | {17c30fad-f9f1-452f-afea-16c8116f85e9} |
| 1201837 | 1201837 | 2019-01-26 09:21:06+00:00 | ☀️ 🤔 | TDSPHC-AGL-E--- | 10966.0 | 65.2429 | {5f4345ea-270d-4342-915a-92c28eb0b4b2} |
| 1977223 | 1977223 | 2019-01-06 17:33:21+00:00 | ☀️ day cruzin w. NP | TDSPHC-AGL-E--- | 9157.0 | 66.3561 | {ad6e148d-2013-4290-80a3-dd77034e55cd} |
| 2349696 | 2349696 | 2019-04-09 14:31:35+00:00 | „Nur ein glücklicher Kunde ist ein guter Kunde“ - der TBR-Werner Fahrradkurierservice | TDSP-C-AGL-E--- | 12087.0 | 74.14 | {17c30fad-f9f1-452f-afea-16c8116f85e9} |
| 1113763 | 1113763 | 2016-03-20 10:34:43+00:00 | шоссе | TDSPHC-AGL-EV-- | 26216.0 | 148.11045 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113764 | 1113764 | 2016-03-21 06:24:24+00:00 | шоссе | TDSP-C-AGL-EV-- | 1670.0 | 11.98232 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113765 | 1113765 | 2016-03-21 11:12:28+00:00 | шоссе | TDSPHC-AGL-EV-- | 3523.0 | 23.17981 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113766 | 1113766 | 2016-03-21 17:08:14+00:00 | шоссе | TDSPHC-AGL-EV-- | 3226.0 | 22.84329 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113767 | 1113767 | 2016-03-22 12:03:32+00:00 | шоссе | TDSPHC-AGL-EV-- | 16701.0 | 90.49883 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113768 | 1113768 | 2016-03-23 13:51:02+00:00 | шоссе | TDSPHC-AGL-EV-- | 8137.0 | 42.49676 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113771 | 1113771 | 2016-03-26 10:30:21+00:00 | шоссе | TDSPHC-AGL-EV-- | 14923.0 | 87.272 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113775 | 1113775 | 2016-03-30 10:04:58+00:00 | шоссе | TDSPHC-AGL-EV-- | 12599.0 | 78.40068 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113778 | 1113778 | 2016-04-01 13:58:20+00:00 | шоссе | TDSPHC-AGL-EV-- | 9296.0 | 45.31031 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113780 | 1113780 | 2016-04-03 12:07:44+00:00 | шоссе | TDSPHC-AGL-EV-- | 6045.0 | 37.32025 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113785 | 1113785 | 2016-04-13 12:29:31+00:00 | шоссе | TDSPHC-AGL-EV-- | 4682.0 | 42.83513 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113839 | 1113839 | 2016-06-04 05:16:01+00:00 | шоссе | TDSPHC-AGL-EV-- | 4793.0 | 29.122 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113847 | 1113847 | 2016-06-21 13:22:02+00:00 | шоссе | TDSPHC-AGL-EV-- | 10065.0 | 71.526 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113858 | 1113858 | 2016-07-06 09:44:23+00:00 | шоссе | TDSPHC-AGL-EV-- | 8996.0 | 51.47413 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113859 | 1113859 | 2016-07-08 05:05:25+00:00 | шоссе | TDSPHC-AGL-EV-- | 3757.0 | 26.86442 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113862 | 1113862 | 2016-07-10 07:54:42+00:00 | шоссе | TDSPHC-AGL-EV-- | 743.0 | 2.7484 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113863 | 1113863 | 2016-07-10 08:07:21+00:00 | шоссе | TDSPHC-AGL-EV-- | 10981.0 | 101.00618 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113870 | 1113870 | 2016-07-15 12:15:56+00:00 | шоссе | T--PHC-A---EV-- | 2206.0 | {23f4e898-6b27-450d-ab01-8f61b72561f0} | |
| 1113873 | 1113873 | 2016-07-19 15:57:35+00:00 | шоссе | TDSP-C-AGL-EV-- | 4537.0 | 29.66012 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113874 | 1113874 | 2016-07-20 05:10:24+00:00 | шоссе | TDSP-C-AGL-EV-- | 4765.0 | 27.4943 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113877 | 1113877 | 2016-07-24 13:11:18+00:00 | шоссе | TDSP-C-AGL-EV-- | 5313.0 | 31.9122 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113878 | 1113878 | 2016-07-28 06:12:19+00:00 | шоссе | TDSPHC-AGL-EV-- | 4057.0 | 28.53228 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113879 | 1113879 | 2016-07-29 08:52:07+00:00 | шоссе | TDSPHC-AGL-EV-- | 6768.0 | 46.89599 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113883 | 1113883 | 2016-08-02 03:58:38+00:00 | шоссе | TDSPHC-AGL-EV-- | 7334.0 | 59.71488 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113885 | 1113885 | 2016-08-03 04:14:00+00:00 | шоссе | TDSPHC-AGL-EV-- | 5896.0 | 50.78345 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113887 | 1113887 | 2016-08-04 13:44:21+00:00 | шоссе | TDSPHC-AGL-EV-- | 8396.0 | 55.03189 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113888 | 1113888 | 2016-08-05 04:12:29+00:00 | шоссе | TDSPHC-AGL-EV-- | 4806.0 | 39.60524 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113889 | 1113889 | 2016-08-05 07:22:25+00:00 | шоссе | TDSP-C-AGL-EV-- | 4687.0 | 27.34268 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113893 | 1113893 | 2016-08-09 05:08:38+00:00 | шоссе | TDSPHC-AGL-EV-- | 4143.0 | 31.008 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113895 | 1113895 | 2016-08-09 13:32:34+00:00 | шоссе | TDSP-C-AGL-EV-- | 5688.0 | 44.28935 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113896 | 1113896 | 2016-08-09 15:09:04+00:00 | шоссе | TDSP-C-AGL-EV-- | 5368.0 | 23.42906 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113898 | 1113898 | 2016-08-10 13:49:55+00:00 | шоссе | TDSPHC-AGL-EV-- | 6418.0 | 46.19152 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113907 | 1113907 | 2016-08-17 13:26:17+00:00 | шоссе | TDSPHC-AGL-EV-- | 8697.0 | 59.80832 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113908 | 1113908 | 2016-08-18 11:11:36+00:00 | шоссе | TDSPHC-AGL-EV-- | 7571.0 | 56.80029 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113909 | 1113909 | 2016-08-19 04:17:32+00:00 | шоссе | TDSPHC-AGL-EV-- | 5834.0 | 48.07906 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113912 | 1113912 | 2016-08-23 05:46:56+00:00 | шоссе | TDSP-C-AGL-EV-- | 3408.0 | 24.0993 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113913 | 1113913 | 2016-08-23 14:08:45+00:00 | шоссе | TDSPHC-AGL-EV-- | 5843.0 | 42.95309 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113914 | 1113914 | 2016-08-24 14:49:19+00:00 | шоссе | TDSPHC-AGL-EV-- | 3728.0 | 30.92023 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113918 | 1113918 | 2016-08-30 08:33:02+00:00 | шоссе | TDSP-C-AGL-EV-- | 6767.0 | 48.3998 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113919 | 1113919 | 2016-08-31 15:15:43+00:00 | шоссе | TDSPHC-AGL-EV-- | 4773.0 | 35.46029 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113926 | 1113926 | 2016-09-07 13:20:04+00:00 | шоссе | TDSPHC-AGL-EV-- | 4691.0 | 40.00341 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113927 | 1113927 | 2016-09-07 14:57:04+00:00 | шоссе | TDSPHC-AGL-EV-- | 3981.0 | 22147.20511 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113933 | 1113933 | 2016-09-13 11:11:15+00:00 | шоссе | TDSPHC-AGL-EV-- | 6717.0 | 50.65769 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113709 | 1113709 | 2015-12-03 06:00:27+00:00 | станок | TDSPHC-A-L-EV-- | 1539.0 | 7.95203 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113710 | 1113710 | 2015-12-03 06:33:35+00:00 | станок | TDSPHC-A-L-EV-- | 2467.0 | 17.91768 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113711 | 1113711 | 2015-12-03 07:24:23+00:00 | станок | TDSPHC-A-L-EV-- | 529.0 | 3.53266 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113712 | 1113712 | 2015-12-05 07:02:09+00:00 | станок | TDSPHC-A-L-EV-- | 6691.0 | 39.96405 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 1113734 | 1113734 | 2016-01-13 11:20:06+00:00 | станок | TDSPHC-AGL-EV-- | 9046.0 | 63.28764 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
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");