rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by total_distance descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance ▲ | athlete |
|---|---|---|---|---|---|---|---|
| 647090 | 647090 | 2017-06-16 06:09:14+00:00 | Bike | TD-PH---------- | 3905.0 | 25395.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1757177 | 1757177 | 2016-08-29 12:47:22+00:00 | TDSPHC-AGL-EV-- | 3453560001.0 | 24985.00646 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 2587433 | 2587433 | 2017-05-03 00:19:58+00:00 | TDSP-C-AGL-E--- | 3032090001.0 | 24408.20709 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 1181396 | 1181396 | 2010-06-20 15:42:33+00:00 | Bike | TDS-HC-A-L----- | 872.0 | 23856.40922 | {3775a9f5-db6a-45cf-b3ff-1f7921bf007d} |
| 1760457 | 1760457 | 2010-06-20 15:42:33+00:00 | Bike | TDS-HC-A-L----- | 872.0 | 23856.40922 | {b96fedff-9aca-400a-a685-ff7e60559e5b} |
| 916013 | 916013 | 2017-11-23 11:04:09+00:00 | TDSPHC-AGL-EV-- | 8187.0 | 23676.8 | {f0a0412f-0a3d-4d71-b9ef-5d839a5e8aa9} | |
| 860601 | 860601 | 1989-12-31 14:36:19+00:00 | TDSPH--AGL-E--- | 904379001.0 | 23488.6 | {5c85dcdc-c315-44d2-8783-389a83921c4d} | |
| 553086 | 553086 | 2018-04-19 13:44:27+00:00 | TDS-HC-AGL-E--- | 3234130001.0 | 22944.90579 | {0bbd1f9b-27c0-4c86-bf8c-67d11120d5e1} | |
| 1113927 | 1113927 | 2016-09-07 14:57:04+00:00 | шоссе | TDSPHC-AGL-EV-- | 3981.0 | 22147.20511 | {23f4e898-6b27-450d-ab01-8f61b72561f0} |
| 647085 | 647085 | 2017-06-09 05:08:53+00:00 | Bike | TD-PH---------- | 3544.0 | 21678.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 595509 | 595509 | 2013-03-20 18:58:35+00:00 | Run | TDS-H--AGL----- | 900.0 | 21464.76933 | {bf187e62-5915-41f3-bcfc-80b06a434b85} |
| 647077 | 647077 | 2017-05-30 07:47:59+00:00 | Bike | TD-PH---------- | 3042.0 | 21028.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647044 | 647044 | 2017-01-24 06:26:38+00:00 | Bike | TD-PH---------- | 3007.0 | 20425.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1565513 | 1565513 | 2016-01-07 15:54:14+00:00 | Hiking | TDS--C-AGL-E--- | 5919.0 | 20045.4 | {6ee03c60-67f3-42a3-8348-652de3ed6be8} |
| 2347831 | 2347831 | 2016-01-07 15:54:14+00:00 | Hiking | TDS--C-AGL-E--- | 5919.0 | 20045.4 | {a8dcd9f6-27fb-4a37-b347-745995178e96} |
| 1757173 | 1757173 | 2016-08-21 07:00:49+00:00 | TDSPHC-AGL-EV-- | 3200480001.0 | 19021.40719 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 647016 | 647016 | 2016-06-24 05:53:55+00:00 | Bike | TD-PH---------- | 1627.0 | 19000.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 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} | |
| 1639742 | 1639742 | 2014-05-01 12:23:38+00:00 | CanyonUltima | --------------- | 18034.0 | {18979252-0458-4ea3-a750-dc3ff28f8cda} | |
| 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} |
| 2530018 | 2530018 | 2016-11-03 14:40:51+00:00 | Bike | TDS-H--AGLWE--- | 3447780001.0 | 16276.8 | {06f81197-504a-478b-a347-052d4df03044} |
| 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} | |
| 2191439 | 2191439 | 2013-12-08 08:33:06+00:00 | Other | TDS-H--AGL-E--- | 1007263.36 | 12978.9455 | {be5b3a14-ab73-46b6-b956-649a47b9a404} |
| 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} |
| 396218 | 396218 | 2019-05-04 10:29:43+00:00 | TDS-HC-AGL-E--R | 3369000001.0 | 10905.0 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | |
| 264950 | 264950 | 2018-10-30 17:52:22+00:00 | TD--HC--------- | 152389001.0 | 10619.6 | {0aa89ce6-0350-45a5-b6f5-0b584ffe2462} | |
| 264959 | 264959 | 2018-11-13 17:49:50+00:00 | TDS-HC--------- | 2700200001.0 | 10575.0 | {0aa89ce6-0350-45a5-b6f5-0b584ffe2462} | |
| 1377941 | 1377941 | 1997-11-30 16:35:20+00:00 | Extras | --------------- | 10000.0 | {bb697b5c-8906-4343-ad73-288e50fc4390} | |
| 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} |
| 875809 | 875809 | 2014-01-29 23:58:38+00:00 | TDS----AGL----- | 2810.0 | 8997.94 | {1f3b7c35-940c-403c-af03-7fae965ccaee} | |
| 1282092 | 1282092 | 2016-09-05 08:55:58+00:00 | TDSP-C-AGL-EV-- | 3134330001.0 | 8806.75 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
| 894070 | 894070 | 2015-03-29 10:24:35+00:00 | TDS-----G------ | 5979.0 | 8485.36 | {81a614da-bb0c-41c9-9e73-502d9ba1e6c2} | |
| 2171385 | 2171385 | 2016-01-01 10:00:04+00:00 | --------------- | 8015.64 | {a49a2a94-9d8f-4df1-a6cb-347479fe7d2a} | ||
| 2588214 | 2588214 | 2019-08-12 05:51:28+00:00 | TDSP-C-AGL-E--- | 2223140001.0 | 7780.02492 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
| 55297 | 55297 | 2015-06-19 14:01:49+00:00 | TDS----AGL----- | 2940831.0 | 7237.09006 | {682707bf-7518-4412-a1c2-81908ce639a3} | |
| 396183 | 396183 | 1990-03-13 19:37:31+00:00 | TDS-HC-AGL-E--R | 4271900001.0 | 7070.43 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | |
| 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} |
| 1377938 | 1377938 | 1996-12-31 16:38:32+00:00 | Extras | --------------- | 6500.0 | {bb697b5c-8906-4343-ad73-288e50fc4390} | |
| 2171382 | 2171382 | 2015-01-01 10:00:01+00:00 | --------------- | 6169.5 | {a49a2a94-9d8f-4df1-a6cb-347479fe7d2a} | ||
| 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} |
| 891903 | 891903 | 2015-01-08 14:07:26+00:00 | TDS-----G------ | 7294.0 | 5363.94 | {0291283c-c8f2-4c81-b9b1-294bf19378db} | |
| 1337582 | 1337582 | 2012-01-22 08:00:00+00:00 | Bike | TDSP-C-A-L----- | 3647291.026 | 5339.24442 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 891634 | 891634 | 2014-03-13 05:31:21+00:00 | TDS-----G------ | 7953.0 | 5334.7 | {0291283c-c8f2-4c81-b9b1-294bf19378db} | |
| 891586 | 891586 | 2014-01-15 15:37:45+00:00 | TDS-----G------ | 2569.0 | 5327.44 | {0291283c-c8f2-4c81-b9b1-294bf19378db} | |
| 891685 | 891685 | 2014-04-23 18:04:00+00:00 | TDS-----G------ | 2280.0 | 5327.03 | {0291283c-c8f2-4c81-b9b1-294bf19378db} | |
| 2171384 | 2171384 | 2016-01-01 10:00:03+00:00 | --------------- | 4921.4 | {a49a2a94-9d8f-4df1-a6cb-347479fe7d2a} | ||
| 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} |
| 534971 | 534971 | 2016-07-10 06:36:36+00:00 | TDS----AGL----- | 10976.0 | 4206.39 | {3d3aa55f-5945-4a9d-b3ea-79edeee7bfd6} | |
| 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} |
| 1639740 | 1639740 | 2014-05-01 12:20:26+00:00 | CanyonNerve | --------------- | 3728.0 | {18979252-0458-4ea3-a750-dc3ff28f8cda} | |
| 534323 | 534323 | 2019-10-13 10:04:14+00:00 | Bike | TDS----AGL-E--- | 17917.0 | 3698.09 | {dd8dad05-8abb-4133-9dc4-c627e663755c} |
| 891159 | 891159 | 2018-02-07 12:13:58+00:00 | Bike | TDS----AGL----- | 19026.0 | 3663.9 | {3f01b73a-fd81-4ae0-a5fd-ab854e384748} |
| 1337004 | 1337004 | 2008-12-20 08:00:00+00:00 | Bike | TDSPH--A-L----- | 4063811.001 | 3617.12172 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1181182 | 1181182 | 2009-04-12 02:16:44+00:00 | Bike | TDS----AGL----- | 14486.0 | 3548.84032 | {3775a9f5-db6a-45cf-b3ff-1f7921bf007d} |
| 1760243 | 1760243 | 2009-04-12 02:16:44+00:00 | Bike | TDS----AGL----- | 14486.0 | 3548.84032 | {b96fedff-9aca-400a-a685-ff7e60559e5b} |
| 276551 | 276551 | 2011-05-15 04:00:00+00:00 | Bike | TDSPHC--------- | 1130551.0 | 3526.41 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
| 1377937 | 1377937 | 1995-11-30 16:41:43+00:00 | Extras | --------------- | 3500.0 | {bb697b5c-8906-4343-ad73-288e50fc4390} | |
| 86435 | 86435 | 2019-12-01 16:09:31+00:00 | Bike | TDS-HC-AGL-E--- | 6000.0 | 3487.0 | {d8d9a9c1-bb5e-4016-af64-ab4d3ade20d6} |
| 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} |
| 2564732 | 2564732 | 2015-01-01 17:24:08+00:00 | --------------- | 3163.23 | {dec50e77-07e1-4f81-8009-e0eb32528f1a} | ||
| 1337066 | 1337066 | 2009-04-23 22:06:23+00:00 | Bike | TDSP-C--------- | 1505591.0 | 3036.18128 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
| 1984587 | 1984587 | 2015-03-25 09:48:39+00:00 | Bike | TDS-H--AGL-E--- | 13512.0 | 2849.43 | {2d0db6bd-edc4-4260-9e83-40a2289d827a} |
| 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} |
| 1378113 | 1378113 | 1998-11-27 12:25:43+00:00 | Extras | --------------- | 2700.0 | {bb697b5c-8906-4343-ad73-288e50fc4390} | |
| 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} |
| 477500 | 477500 | 2018-02-21 06:18:50+00:00 | TDS-HC-AGL-E--R | 3406770001.0 | 2549.0519 | {00cab3f8-83c3-4bb8-8c17-aff839b4bed9} | |
| 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} |
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");