rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by workout_time descending
This data as json, CSV (advanced)
Link | rowid | date | sport | data | workout_time ▲ | total_distance | athlete |
---|---|---|---|---|---|---|---|
218563 | 218563 | 2018-12-12 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218567 | 218567 | 2018-12-15 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218571 | 218571 | 2018-12-18 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218584 | 218584 | 2018-12-26 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218588 | 218588 | 2018-12-29 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218589 | 218589 | 2018-12-30 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218592 | 218592 | 2019-01-02 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218593 | 218593 | 2019-01-03 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218598 | 218598 | 2019-01-06 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218599 | 218599 | 2019-01-07 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218611 | 218611 | 2019-01-19 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218618 | 218618 | 2019-01-25 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218621 | 218621 | 2019-01-28 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218629 | 218629 | 2019-02-04 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218631 | 218631 | 2019-02-06 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218633 | 218633 | 2019-02-08 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218635 | 218635 | 2019-02-10 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
218646 | 218646 | 2019-02-20 23:00:01+00:00 | Day Off | --------------- | 1.79769e+308 | {12b5fa4c-4ee5-4df2-85be-e8d446af349b} | |
1229746 | 1229746 | Bike | T-------G------ | 63586100001.0 | {f4db7965-6fba-4a5f-bc5c-173f18f46a4a} | ||
396180 | 396180 | 1989-12-31 02:25:19+00:00 | TDS-HC-AGL-E--R | 4294840001.0 | 1655.43 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | |
396181 | 396181 | 1989-12-31 03:37:29+00:00 | TDS-HC-AGL-E--R | 4294630001.0 | 1816.0 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | |
396183 | 396183 | 1990-03-13 19:37:31+00:00 | TDS-HC-AGL-E--R | 4271900001.0 | 7070.43 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | |
1862428 | 1862428 | 2000-08-18 14:45:23+00:00 | T------AG--E--- | 3506440001.0 | {f4d64878-666c-484b-a271-fb36494ef432} | ||
1757177 | 1757177 | 2016-08-29 12:47:22+00:00 | TDSPHC-AGL-EV-- | 3453560001.0 | 24985.00646 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
2530018 | 2530018 | 2016-11-03 14:40:51+00:00 | Bike | TDS-H--AGLWE--- | 3447780001.0 | 16276.8 | {06f81197-504a-478b-a347-052d4df03044} |
2587463 | 2587463 | 2017-06-03 22:14:17+00:00 | TDSPHC-AGL-EV-- | 3421180001.0 | 1766.84774 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
220464 | 220464 | 2018-02-15 13:16:54+00:00 | TDSPHC-AGL-EV-- | 3406810001.0 | 27032.9 | {4f653f36-e2da-47d2-b65c-04c935c72a54} | |
477500 | 477500 | 2018-02-21 06:18:50+00:00 | TDS-HC-AGL-E--R | 3406770001.0 | 2549.0519 | {00cab3f8-83c3-4bb8-8c17-aff839b4bed9} | |
46824 | 46824 | 2017-08-31 16:57:34+00:00 | TDSPHC-AGL-EV-- | 3405060001.0 | 5.42759 | {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} |
1757176 | 1757176 | 2016-08-27 07:52:13+00:00 | TDSPHC-AGL-EV-- | 3403880001.0 | 87.8285 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
46827 | 46827 | 2017-09-23 07:30:17+00:00 | TDSPHC-AGL-EV-- | 3403630001.0 | 6838.66861 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
46823 | 46823 | 2017-08-26 11:05:32+00:00 | Bike | TDSPHC-AGL-EV-- | 3391300001.0 | 2673.9022 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} |
1863969 | 1863969 | 2018-03-19 17:18:40+00:00 | T---H--A---E--- | 3387880001.0 | {f4d64878-666c-484b-a271-fb36494ef432} | ||
46826 | 46826 | 2017-09-17 16:48:51+00:00 | TDSPHC-AGL-EV-- | 3382160001.0 | 6065.38201 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
1757174 | 1757174 | 2016-08-22 05:50:38+00:00 | TDSPHC-AGL-EV-- | 3371580001.0 | 15028.00734 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
396218 | 396218 | 2019-05-04 10:29:43+00:00 | TDS-HC-AGL-E--R | 3369000001.0 | 10905.0 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | |
1060188 | 1060188 | 2018-05-19 07:51:32+00:00 | TDSPHC-AGL-EV-- | 3335220001.0 | 2209.22229 | {03ca9de9-5379-4bdf-9e7a-c9748c937452} | |
46825 | 46825 | 2017-09-02 16:13:31+00:00 | TDSPHC-AGL-EV-- | 3304070001.0 | 36920.60379 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
264955 | 264955 | 2018-11-06 17:56:48+00:00 | TDS-HC--------- | 3265360001.0 | 28101.8 | {0aa89ce6-0350-45a5-b6f5-0b584ffe2462} | |
1282138 | 1282138 | 2016-10-17 09:57:51+00:00 | TDSPHC-AGL-EV-- | 3265290001.0 | 18645.1 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
553086 | 553086 | 2018-04-19 13:44:27+00:00 | TDS-HC-AGL-E--- | 3234130001.0 | 22944.90579 | {0bbd1f9b-27c0-4c86-bf8c-67d11120d5e1} | |
1757173 | 1757173 | 2016-08-21 07:00:49+00:00 | TDSPHC-AGL-EV-- | 3200480001.0 | 19021.40719 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
1757175 | 1757175 | 2016-08-25 05:07:03+00:00 | TDSPHC-AGL-EV-- | 3164530001.0 | 1618.08752 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
1282092 | 1282092 | 2016-09-05 08:55:58+00:00 | TDSP-C-AGL-EV-- | 3134330001.0 | 8806.75 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
1949354 | 1949354 | 2016-04-17 12:42:45+00:00 | Bike | TDSP-C-AGL-EV-- | 3094120001.0 | 138.36831 | {183916d7-1d2a-4117-a9b2-31824ed66fbc} |
1202009 | 1202009 | 2020-01-19 19:56:36+00:00 | Bike | TDSPHC-AGL-EV-- | 3043170001.0 | 109.66995 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} |
2587433 | 2587433 | 2017-05-03 00:19:58+00:00 | TDSP-C-AGL-E--- | 3032090001.0 | 24408.20709 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
1201993 | 1201993 | 2019-12-30 17:50:17+00:00 | TDSPHC-AGL-EV-- | 2880780001.0 | 4865.74242 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} | |
695330 | 695330 | 2017-10-03 02:16:34+00:00 | Bike | TDS----AGL----- | 2787990001.0 | 0.9315 | {65d470c1-9339-41c9-a6d0-0330b7ab14f0} |
1499049 | 1499049 | 2018-11-15 09:57:40+00:00 | Bike | T-------------- | 2752690001.0 | {7c2ac275-ad88-44a4-a827-589a4e99c0c3} | |
1499050 | 1499050 | 2018-11-15 22:35:47+00:00 | Bike | T-------------- | 2752650001.0 | {7c2ac275-ad88-44a4-a827-589a4e99c0c3} | |
1499056 | 1499056 | 2018-11-28 06:17:57+00:00 | Bike | T-------------- | 2752650001.0 | {7c2ac275-ad88-44a4-a827-589a4e99c0c3} | |
1452835 | 1452835 | 2019-11-15 21:13:07+00:00 | Bike | TDSP-C-AGL-EV-- | 2737830001.0 | 203.342 | {3efb16ec-07f3-4996-8157-3b29a11e55f3} |
1905148 | 1905148 | 2019-10-16 17:25:41+00:00 | Bike | T-------------- | 2723720001.0 | {a9322bf8-14fc-4ca7-a7a2-7be1412952b9} | |
264959 | 264959 | 2018-11-13 17:49:50+00:00 | TDS-HC--------- | 2700200001.0 | 10575.0 | {0aa89ce6-0350-45a5-b6f5-0b584ffe2462} | |
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} |
1188661 | 1188661 | 2020-05-23 05:06:23+00:00 | TDSPHC-AGL-EVO- | 2331140001.0 | 0.06057 | {11176adc-4b3d-4532-8544-d29fe0b88199} | |
2588214 | 2588214 | 2019-08-12 05:51:28+00:00 | TDSP-C-AGL-E--- | 2223140001.0 | 7780.02492 | {c11aed3d-11f7-496f-940e-8b93a1c18ead} | |
185551 | 185551 | 2000-07-30 17:37:18+00:00 | TDSPHC-AGL-EV-- | 2083830001.0 | 0.02483 | {a042f83c-2b84-4abc-8b0d-8c726a236239} | |
1951605 | 1951605 | 2014-06-08 04:01:32+00:00 | TDS-HC-AGL-E--- | 1865260001.0 | 1036.53 | {702f4866-cebf-4fe6-b281-8fb10240dfb5} | |
396182 | 396182 | 1990-02-19 01:44:45+00:00 | TD--HC-A-L-E--- | 1841300001.0 | 35.982 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | |
860600 | 860600 | 1989-12-31 11:24:48+00:00 | Bike | TDSPHC-AGL-E--- | 1634540001.0 | 44.1465 | {5c85dcdc-c315-44d2-8783-389a83921c4d} |
1578390 | 1578390 | 2016-01-03 07:33:27+00:00 | T------AG------ | 1172060001.0 | {b6461ded-13f5-43c5-931c-39630a0884d0} | ||
860602 | 860602 | 1989-12-31 15:14:38+00:00 | Bike | TDSPHC-AGL-E--- | 1146950001.0 | 57.9529 | {5c85dcdc-c315-44d2-8783-389a83921c4d} |
1746428 | 1746428 | 1990-07-13 04:37:19+00:00 | TDSPH--AGL-E--- | 1124070001.0 | {efedc7e0-6cfa-4f05-ac3a-6ea3eb27676b} | ||
396184 | 396184 | 1990-07-13 04:37:19+00:00 | T-S-HC-AG--E--R | 1056960001.0 | {9753425e-27a2-42ba-8edf-67d3a33c8192} | ||
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} | |
1910560 | 1910560 | 2016-08-22 06:17:48+00:00 | TDSPHC-AGL-E--- | 960215001.0 | 42949.00154 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
179349 | 179349 | 1989-12-30 23:59:59+00:00 | TD-----AGL----- | 931202001.0 | 28.0679 | {555b6a52-0860-458f-a1e1-a603df335f8a} | |
808022 | 808022 | 2009-02-28 18:50:04+00:00 | Bike | TDS-H--AGL----- | 910830001.0 | 984.152 | {f035c04c-be77-4ab9-b3c0-4ff6235a57bc} |
860601 | 860601 | 1989-12-31 14:36:19+00:00 | TDSPH--AGL-E--- | 904379001.0 | 23488.6 | {5c85dcdc-c315-44d2-8783-389a83921c4d} | |
1910580 | 1910580 | 2016-09-19 07:53:00+00:00 | TDSPHC-AGL-E--- | 802732001.0 | 34057.70222 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
550602 | 550602 | 2016-03-12 14:13:04+00:00 | TDSPHC-AGL----- | 767613001.0 | 39.1863 | {5353813e-daab-4089-98d2-f51864e09bd0} | |
550596 | 550596 | 2016-03-06 14:27:24+00:00 | TDSPHC-AGL----- | 767092001.0 | 15.0576 | {5353813e-daab-4089-98d2-f51864e09bd0} | |
2341635 | 2341635 | 2020-05-05 00:01:38+00:00 | Bike | TDSP-C-AGL-E--- | 653362001.0 | 103.33394 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
1679193 | 1679193 | 1999-08-22 00:00:18+00:00 | Bike | TDSP-C-A-L-E--- | 651772001.0 | 20.3411 | {5dc91693-ea82-4268-83a0-a5c44e0bd33a} |
1030534 | 1030534 | 2020-01-03 00:07:09+00:00 | Bike | TDSPHC-AGL-E--- | 642763001.0 | 26.12062 | {1db2d738-ee9d-4ff2-8ceb-18e90f281bde} |
1030524 | 1030524 | 2019-11-30 00:00:11+00:00 | Bike | TDSPHC-AGL-E--- | 639826001.0 | 73.6783 | {1db2d738-ee9d-4ff2-8ceb-18e90f281bde} |
2341592 | 2341592 | 1999-08-22 00:01:45+00:00 | Bike | TDSP-C-AGL-E--- | 635511001.0 | 24.38343 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
2341589 | 2341589 | 1999-08-22 00:00:38+00:00 | Bike | TDSP-C-AGL-E--- | 635375001.0 | 37.13633 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
2341591 | 2341591 | 1999-08-22 00:01:05+00:00 | Bike | TDS----AGL-E--- | 635122001.0 | 11.2236 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
2012366 | 2012366 | 2018-04-03 18:39:54+00:00 | Bike | TDS----AGL----- | 630766001.0 | 161.257 | {717b1a3a-fc99-45e4-97d8-5782270ff01d} |
2341590 | 2341590 | 1999-08-22 00:01:02+00:00 | Bike | TDSP-C-AGL-E--- | 629680001.0 | 44.0534 | {13d431ce-9c61-40e1-a2e1-eff423baa4d3} |
919950 | 919950 | 2017-06-06 20:41:41+00:00 | TDSPHC-AGL-EV-- | 627456001.0 | 11841.1 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} | |
1867614 | 1867614 | 2020-01-09 20:54:29+00:00 | Bike | TDSP-C-A-L----- | 619399001.0 | 0.23866 | {7efc5625-f856-4a15-9089-11b76f8979f2} |
1867518 | 1867518 | 2019-04-21 11:30:30+00:00 | Bike | TDSP-C-AGL----- | 619319001.0 | 0.00875 | {7efc5625-f856-4a15-9089-11b76f8979f2} |
1792478 | 1792478 | 2020-04-23 04:10:02+00:00 | Bike | TDSPHC-AGL----- | 619316001.0 | 7.4482 | {6637cc35-f314-4448-b32b-aae24d42905c} |
1580830 | 1580830 | 2017-03-05 22:01:39+00:00 | Bike | TDS-HC-AGL-E--- | 619233001.0 | 25.4002 | {c231317d-303d-45fa-9d80-f6a1b5d2b034} |
906344 | 906344 | 2019-04-20 06:36:59+00:00 | Bike | TDS-H--AGL-E--- | 618731001.0 | 167.11241 | {069b28a9-6a90-4a3a-a264-df9848f0e5c2} |
1282548 | 1282548 | 2017-12-24 08:08:48+00:00 | Bike | TDSPHC-AGL----- | 618724001.0 | 123.967 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} |
1858266 | 1858266 | 2018-03-14 18:06:33+00:00 | Bike | TDSPHC-AGL-E--- | 618715001.0 | 35.0028 | {1e518c35-d331-4d7f-8df7-195f7ca9faaa} |
1489665 | 1489665 | 2019-04-21 08:23:41+00:00 | Bike | TDS----AGL-E--- | 618685001.0 | 113.556 | {59ec5293-931b-42e3-9b3c-ac7a3f5542e4} |
2216388 | 2216388 | 2018-10-17 08:08:59+00:00 | Bike | TDSPHC-AGL-E--- | 618422001.0 | 1.20664 | {f302a094-a06f-4218-8735-5f1867fef0b3} |
1970201 | 1970201 | 2019-04-18 08:01:57+00:00 | Bike | TDS-H--AGL-E--- | 618344001.0 | 31.5824 | {4f554351-678b-478c-b51b-6ebc56c811a2} |
1299489 | 1299489 | 2019-05-18 05:11:27+00:00 | Bike | TDSPHC-AGL-EV-- | 618188001.0 | 108.092 | {d2e9643e-3681-408f-afd5-48b646180891} |
1068058 | 1068058 | 2019-07-02 12:18:19+00:00 | Bike | TDSPHC-AGL-E--- | 618109001.0 | 21.21 | {204e4cf7-7992-439a-8252-fd0a74e6c749} |
1713652 | 1713652 | 2018-03-03 19:25:47+00:00 | Bike | TDSPHC-AGL-EV-- | 617830001.0 | 91.05639 | {95ed433d-ab1c-4a69-989c-f05028fac2f9} |
800483 | 800483 | 2017-08-23 06:15:56+00:00 | Bike | TDSPHC-AGL-E--- | 617515001.0 | 102.915 | {d8814b25-9784-4348-9569-40847a564782} |
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");