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 descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance ▲ | athlete |
|---|---|---|---|---|---|---|---|
| 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} |
| 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} | |
| 1201993 | 1201993 | 2019-12-30 17:50:17+00:00 | TDSPHC-AGL-EV-- | 2880780001.0 | 4865.74242 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} | |
| 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} |
| 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} |
| 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} |
| 276495 | 276495 | 2011-01-23 05:00:00+00:00 | Bike | TDSPHC--------- | 1437031.0 | 2656.95306 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 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} |
| 276518 | 276518 | 2011-02-20 05:00:00+00:00 | Bike | TDSPHC--------- | 3308811.0 | 2516.2125 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1337013 | 1337013 | 2009-01-10 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1641011.022 | 2445.5427 | {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} |
| 1336725 | 1336725 | 2007-04-23 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 2856291.001 | 2395.27259 | {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} |
| 1336716 | 1336716 | 2007-03-20 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 1173901.002 | 2270.50175 | {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} |
| 1060188 | 1060188 | 2018-05-19 07:51:32+00:00 | TDSPHC-AGL-EV-- | 3335220001.0 | 2209.22229 | {03ca9de9-5379-4bdf-9e7a-c9748c937452} | |
| 541241 | 541241 | 2015-10-28 12:22:39+00:00 | Bike | TDSPHC-AGL-E--- | 30296.0 | 2186.45569 | {d1ad12c9-86b2-4589-83cb-d944b2440ce5} |
| 1337217 | 1337217 | 2010-01-17 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 4130281.001 | 2091.99459 | {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} |
| 1336732 | 1336732 | 2007-05-02 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 1939531.002 | 2048.11212 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336853 | 1336853 | 2008-01-26 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 710720.012 | 1968.99171 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336844 | 1336844 | 2008-01-05 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2931091.011 | 1894.7309 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336719 | 1336719 | 2007-03-24 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 2702491.051 | 1894.01231 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337071 | 1337071 | 2009-05-02 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 233400.457 | 1858.72113 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336851 | 1336851 | 2008-01-22 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2067031.002 | 1852.0827 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 2587463 | 2587463 | 2017-06-03 22:14:17+00:00 | TDSPHC-AGL-EV-- | 3421180001.0 | 1766.84774 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 1337009 | 1337009 | 2009-01-03 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3145181.001 | 1757.22256 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336987 | 1336987 | 2008-11-19 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 4244161.002 | 1715.13128 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336726 | 1336726 | 2007-04-25 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3259541.011 | 1713.80219 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1757175 | 1757175 | 2016-08-25 05:07:03+00:00 | TDSPHC-AGL-EV-- | 3164530001.0 | 1618.08752 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 1337220 | 1337220 | 2010-01-21 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 493641.012 | 1617.31469 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336729 | 1336729 | 2007-04-30 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3254571.061 | 1545.40233 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337012 | 1337012 | 2009-01-09 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1711811.012 | 1543.97242 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336998 | 1336998 | 2008-12-06 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2611321.002 | 1542.44273 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1392338 | 1392338 | 2018-09-19 12:02:46+00:00 | Bike | T--PHC-A---EV-- | 5402.0 | 1541.0 | {49988e3b-053a-4bed-9797-9cb8e4999996} |
| 1337739 | 1337739 | 2012-11-29 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 213779.009 | 1535.22395 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337237 | 1337237 | 2010-03-03 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1450751.633 | 1522.14885 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337000 | 1337000 | 2008-12-10 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 247665.001 | 1504.81 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337435 | 1337435 | 2011-03-02 08:00:00+00:00 | Bike | TDSPHC--------- | 1612961.011 | 1501.83466 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336735 | 1336735 | 2007-05-04 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 442573.022 | 1500.24009 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337778 | 1337778 | 2013-03-24 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 2082291.011 | 1497.66371 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337734 | 1337734 | 2012-11-20 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 825145.535 | 1482.9769 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337011 | 1337011 | 2009-01-08 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2346111.011 | 1482.63039 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337481 | 1337481 | 2011-06-01 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 2559271.011 | 1480.87 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337445 | 1337445 | 2011-03-19 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 1015421.041 | 1476.15457 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337218 | 1337218 | 2010-01-19 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3474791.132 | 1462.06519 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337747 | 1337747 | 2012-12-16 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2655541.044 | 1457.69455 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337200 | 1337200 | 2009-12-09 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 4155831.001 | 1454.983 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337610 | 1337610 | 2012-03-20 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 2278951.022 | 1444.46102 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337003 | 1337003 | 2008-12-18 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2014431.001 | 1440.06189 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337621 | 1337621 | 2012-04-10 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 1745251.014 | 1438.24456 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337201 | 1337201 | 2009-12-11 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 713346.022 | 1415.96292 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336711 | 1336711 | 2007-03-07 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2601531.001 | 1408.15498 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336720 | 1336720 | 2007-03-26 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3119701.035 | 1379.9527 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337007 | 1337007 | 2009-01-01 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 800728.001 | 1371.50195 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337748 | 1337748 | 2012-12-17 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2612161.006 | 1361.6933 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337053 | 1337053 | 2009-04-02 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 416202.021 | 1351.92224 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337611 | 1337611 | 2012-03-21 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 836090.029 | 1341.7412 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337609 | 1337609 | 2012-03-15 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 676434.412 | 1336.95047 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336812 | 1336812 | 2007-10-31 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 889831.092 | 1335.48042 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337223 | 1337223 | 2010-01-29 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2025421.462 | 1325.67751 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337608 | 1337608 | 2012-03-14 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 4148211.003 | 1324.76248 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337613 | 1337613 | 2012-03-24 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3354941.035 | 1311.74273 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337743 | 1337743 | 2012-12-05 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 1158691.029 | 1309.78414 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337258 | 1337258 | 2010-03-30 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 1127231.001 | 1297.70373 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337614 | 1337614 | 2012-03-26 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 450410.007 | 1295.71397 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337618 | 1337618 | 2012-04-03 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 2900431.008 | 1295.18498 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 276527 | 276527 | 2011-03-08 05:00:00+00:00 | Bike | TDSPHC--------- | 2203901.0 | 1289.89122 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 276504 | 276504 | 2011-02-02 05:00:00+00:00 | Bike | TDSPHC--------- | 1439081.0 | 1289.66 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1337779 | 1337779 | 2013-04-02 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3268331.031 | 1286.06498 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337615 | 1337615 | 2012-03-29 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3962211.012 | 1282.40517 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337005 | 1337005 | 2008-12-30 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3178991.001 | 1281.28125 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336841 | 1336841 | 2007-12-30 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 117229.002 | 1279.95072 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337022 | 1337022 | 2009-01-23 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3599531.031 | 1276.25069 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337617 | 1337617 | 2012-04-02 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 1631432.744 | 1264.3889 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336860 | 1336860 | 2008-02-08 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 722625.032 | 1256.98034 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337199 | 1337199 | 2009-12-08 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2164251.031 | 1253.52017 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336847 | 1336847 | 2008-01-15 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3171661.001 | 1251.00053 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 276521 | 276521 | 2011-02-25 05:00:00+00:00 | Bike | TDSPHC--------- | 3242831.0 | 1250.50258 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1336845 | 1336845 | 2008-01-08 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3620681.001 | 1248.41072 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1337644 | 1337644 | 2012-05-21 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3050871.05 | 1240.53414 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1336846 | 1336846 | 2008-01-14 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 2284201.001 | 1239.34211 | {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");