rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by total_distance descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance ▲ | athlete |
|---|---|---|---|---|---|---|---|
| 647047 | 647047 | 2017-02-03 06:49:12+00:00 | Bike | TD-PH---------- | 2704.0 | 18863.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1282138 | 1282138 | 2016-10-17 09:57:51+00:00 | TDSPHC-AGL-EV-- | 3265290001.0 | 18645.1 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
| 647110 | 647110 | 2017-08-15 05:10:59+00:00 | Bike | TD-PH---------- | 1361.0 | 17500.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 854319 | 854319 | 2017-12-20 02:32:08+00:00 | Bike | TDSPHC-AGL----- | 4590.0 | 16811.605 | {d9ed8357-6ef0-4cfa-a820-b31a020e2bb4} |
| 647120 | 647120 | 2017-09-13 05:13:42+00:00 | Bike | TD-PH---------- | 1405.0 | 15552.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1757174 | 1757174 | 2016-08-22 05:50:38+00:00 | TDSPHC-AGL-EV-- | 3371580001.0 | 15028.00734 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 647121 | 647121 | 2017-09-13 05:41:11+00:00 | Bike | TD-PH---------- | 1123.0 | 11877.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647034 | 647034 | 2016-12-21 09:28:53+00:00 | Bike | TD-PH---------- | 1014.0 | 11868.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 919950 | 919950 | 2017-06-06 20:41:41+00:00 | TDSPHC-AGL-EV-- | 627456001.0 | 11841.1 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} | |
| 2486708 | 2486708 | 2018-06-25 19:11:42+00:00 | Bike | -DSPH--AGL----- | 1.0 | 10981.6 | {70a04cc3-c23e-4247-bf51-15f62957126e} |
| 891764 | 891764 | 2014-07-23 06:40:29+00:00 | Bike | TDSPHC-AGL-E--- | 2465990001.0 | 9060.34137 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 892100 | 892100 | 2015-08-20 08:13:39+00:00 | Bike | TDSPHC-AGL-E--- | 2465990001.0 | 9060.34137 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 1282092 | 1282092 | 2016-09-05 08:55:58+00:00 | TDSP-C-AGL-EV-- | 3134330001.0 | 8806.75 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
| 2588214 | 2588214 | 2019-08-12 05:51:28+00:00 | TDSP-C-AGL-E--- | 2223140001.0 | 7780.02492 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 1337902 | 1337902 | 2014-02-02 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 2517332.418 | 7052.08189 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 46827 | 46827 | 2017-09-23 07:30:17+00:00 | TDSPHC-AGL-EV-- | 3403630001.0 | 6838.66861 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
| 2437099 | 2437099 | 2016-12-10 15:59:19+00:00 | Bike | TDSPHC-AGL-EV-- | 3404400001.0 | 6711.54 | {4b1ede08-6163-4bfa-bc74-c58ae4d2dc2b} |
| 46826 | 46826 | 2017-09-17 16:48:51+00:00 | TDSPHC-AGL-EV-- | 3382160001.0 | 6065.38201 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
| 697846 | 697846 | 2018-11-25 09:27:48+00:00 | TDSPHC-AGL-E--- | 9691.0 | 5834.57 | {8ef0e834-ce30-4d38-9d40-fa25d2769b28} | |
| 1338034 | 1338034 | 2014-10-25 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 3140881.001 | 5736.61392 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337582 | 1337582 | 2012-01-22 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3647291.026 | 5339.24442 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1201993 | 1201993 | 2019-12-30 17:50:17+00:00 | TDSPHC-AGL-EV-- | 2880780001.0 | 4865.74242 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} | |
| 1337905 | 1337905 | 2014-02-09 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3887311.036 | 4642.0357 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 649288 | 649288 | 2018-04-21 05:55:33+00:00 | Bike | TDSPHC-AGL-E--- | 26625.0 | 4488.76595 | {2679ee70-0c56-49be-ae29-6856e4a92fe3} |
| 647013 | 647013 | 2016-06-10 05:12:10+00:00 | Bike | TD-PH---------- | 380.0 | 4326.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 2588193 | 2588193 | 2019-07-15 13:19:42+00:00 | TD-P-C-A-L-E--- | 989068001.0 | 4313.91 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 1337222 | 1337222 | 2010-01-24 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3227381.001 | 4219.26589 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337399 | 1337399 | 2011-01-02 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 681187.021 | 4035.77476 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337202 | 1337202 | 2009-12-13 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1448591.032 | 3920.96376 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337216 | 1337216 | 2010-01-16 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1063701.022 | 3843.36318 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337004 | 1337004 | 2008-12-20 08:00:00+00:00 | Bike | TDSPH--A-L----- | 4063811.001 | 3617.12172 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 276551 | 276551 | 2011-05-15 04:00:00+00:00 | Bike | TDSPHC--------- | 1130551.0 | 3526.41 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1337398 | 1337398 | 2011-01-01 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3335343.465 | 3483.58 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 276589 | 276589 | 2011-08-14 19:05:00+00:00 | Bike | TDSPHC--------- | 556542.0 | 3465.32 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1337066 | 1337066 | 2009-04-23 22:06:23+00:00 | Bike | TDSP-C--------- | 1505591.0 | 3036.18128 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337912 | 1337912 | 2014-02-25 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 184339.002 | 2828.5139 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337023 | 1337023 | 2009-01-24 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1394901.032 | 2723.8512 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 46823 | 46823 | 2017-08-26 11:05:32+00:00 | Bike | TDSPHC-AGL-EV-- | 3391300001.0 | 2673.9022 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} |
| 1338394 | 1338394 | 2016-10-25 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 2893951.077 | 2663.2861 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337891 | 1337891 | 2014-01-08 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1427391.054 | 2657.77498 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 276495 | 276495 | 2011-01-23 05:00:00+00:00 | Bike | TDSPHC--------- | 1437031.0 | 2656.95306 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 697950 | 697950 | 2019-07-16 13:14:50+00:00 | TDSP-C-AGL-E--- | 539408.0 | 2625.68 | {8ef0e834-ce30-4d38-9d40-fa25d2769b28} | |
| 1338435 | 1338435 | 2017-01-22 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3707411.057 | 2615.48687 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338245 | 1338245 | 2016-01-16 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 639749.027 | 2599.86602 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338246 | 1338246 | 2016-01-17 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 4036661.045 | 2585.51537 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337907 | 1337907 | 2014-02-12 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1163561.031 | 2578.68513 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338429 | 1338429 | 2017-01-07 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3793721.014 | 2577.76476 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 585830 | 585830 | 2018-08-16 07:29:10+00:00 | Bike | TDSPHCNAGL-EV-- | 706002.0 | 2573.72 | {50327b7c-17c5-4f72-a742-4611d70aa1b2} |
| 1336868 | 1336868 | 2008-02-23 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1387921.122 | 2544.91087 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338237 | 1338237 | 2016-01-04 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1296561.073 | 2525.95441 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 276518 | 276518 | 2011-02-20 05:00:00+00:00 | Bike | TDSPHC--------- | 3308811.0 | 2516.2125 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1338049 | 1338049 | 2014-11-19 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 373247.032 | 2469.88439 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337013 | 1337013 | 2009-01-10 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1641011.022 | 2445.5427 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338590 | 1338590 | 2018-01-25 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 927393.026 | 2445.47681 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337777 | 1337777 | 2013-03-21 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 2573201.004 | 2429.81432 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336975 | 1336975 | 2008-11-01 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 245831.002 | 2427.58008 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1093393 | 1093393 | 2017-11-09 04:00:28+00:00 | Bike | TDSPH--AGL-E--- | 1410401.0 | 2427.33 | {66413ae7-c18a-46dd-8991-5ca2f3e6dc1d} |
| 1338450 | 1338450 | 2017-02-21 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 4152001.06 | 2417.61727 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338396 | 1338396 | 2016-10-27 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 977375.08 | 2415.81429 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338442 | 1338442 | 2017-02-07 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3602091.024 | 2412.33654 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338054 | 1338054 | 2014-12-03 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 785498.021 | 2409.18511 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338243 | 1338243 | 2016-01-14 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1859651.062 | 2408.53389 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337867 | 1337867 | 2013-11-19 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3134131.024 | 2408.32381 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337903 | 1337903 | 2014-02-03 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1233821.005 | 2404.97614 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336725 | 1336725 | 2007-04-23 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 2856291.001 | 2395.27259 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338584 | 1338584 | 2018-01-16 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 2324921.061 | 2390.33466 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338053 | 1338053 | 2014-12-01 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 2454411.031 | 2374.85538 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337838 | 1337838 | 2013-09-17 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 2005291.002 | 2374.56576 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338061 | 1338061 | 2014-12-16 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 2552791.192 | 2357.67616 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338277 | 1338277 | 2016-03-12 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 2567021.022 | 2356.11432 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337914 | 1337914 | 2014-02-28 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1719641.051 | 2349.33683 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338275 | 1338275 | 2016-03-09 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3723531.088 | 2345.1874 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337915 | 1337915 | 2014-03-03 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 470223.062 | 2319.78531 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337776 | 1337776 | 2013-03-20 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 1400851.416 | 2314.76531 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337943 | 1337943 | 2014-04-24 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 3455351.012 | 2305.99498 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338418 | 1338418 | 2016-12-08 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3692401.048 | 2294.72422 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337913 | 1337913 | 2014-02-27 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3448701.022 | 2293.74497 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337036 | 1337036 | 2009-02-14 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3005851.001 | 2290.15047 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338229 | 1338229 | 2015-12-14 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1172171.021 | 2285.90306 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337783 | 1337783 | 2013-04-08 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 264296.005 | 2275.08561 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336716 | 1336716 | 2007-03-20 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 1173901.002 | 2270.50175 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338227 | 1338227 | 2015-12-09 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 2950611.012 | 2265.74694 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 276516 | 276516 | 2011-02-17 05:00:00+00:00 | Bike | TDSPHC--------- | 3843651.0 | 2250.58089 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1336855 | 1336855 | 2008-02-02 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2752071.002 | 2243.9317 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338449 | 1338449 | 2017-02-20 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1761021.043 | 2216.93707 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338586 | 1338586 | 2018-01-18 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 256684.055 | 2216.54692 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338417 | 1338417 | 2016-12-07 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3511091.025 | 2211.14604 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338436 | 1338436 | 2017-01-23 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1074181.0 | 2210.94533 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1060188 | 1060188 | 2018-05-19 07:51:32+00:00 | TDSPHC-AGL-EV-- | 3335220001.0 | 2209.22229 | {03ca9de9-5379-4bdf-9e7a-c9748c937452} | |
| 1338425 | 1338425 | 2016-12-31 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 163308.028 | 2193.09371 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 541241 | 541241 | 2015-10-28 12:22:39+00:00 | Bike | TDSPHC-AGL-E--- | 30296.0 | 2186.45569 | {d1ad12c9-86b2-4589-83cb-d944b2440ce5} |
| 1338430 | 1338430 | 2017-01-10 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 2093851.024 | 2185.89606 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337916 | 1337916 | 2014-03-04 08:00:00+00:00 | Bike | TDSP---A-L----- | 2072011.052 | 2177.64622 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337906 | 1337906 | 2014-02-11 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 1988791.449 | 2168.36 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338273 | 1338273 | 2016-03-07 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 437627.045 | 2164.6443 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337217 | 1337217 | 2010-01-17 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 4130281.001 | 2091.99459 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1338443 | 1338443 | 2017-02-08 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 4178381.053 | 2086.89611 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337782 | 1337782 | 2013-04-07 07:00:00+00:00 | Bike | TDSP-C-A-L----- | 1280661.023 | 2066.9248 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336718 | 1336718 | 2007-03-22 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3899021.032 | 2058.61295 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336907 | 1336907 | 2008-05-24 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3616001.001 | 2054.61231 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
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");