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 workout_time descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time ▲ | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1757177 | 1757177 | 2016-08-29 12:47:22+00:00 | TDSPHC-AGL-EV-- | 3453560001.0 | 24985.00646 | {ac740e46-6a9a-422d-aef4-10c0dd85f5c2} | |
| 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} | |
| 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} |
| 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} | |
| 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} | |
| 1282138 | 1282138 | 2016-10-17 09:57:51+00:00 | TDSPHC-AGL-EV-- | 3265290001.0 | 18645.1 | {619a41cf-505c-47fa-b87a-8dbefc63a1a4} | |
| 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} | |
| 1202009 | 1202009 | 2020-01-19 19:56:36+00:00 | Bike | TDSPHC-AGL-EV-- | 3043170001.0 | 109.66995 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} |
| 1201993 | 1201993 | 2019-12-30 17:50:17+00:00 | TDSPHC-AGL-EV-- | 2880780001.0 | 4865.74242 | {0ca7e333-bc6a-4c42-8f9f-41c62da36702} | |
| 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} | |
| 185551 | 185551 | 2000-07-30 17:37:18+00:00 | TDSPHC-AGL-EV-- | 2083830001.0 | 0.02483 | {a042f83c-2b84-4abc-8b0d-8c726a236239} | |
| 860600 | 860600 | 1989-12-31 11:24:48+00:00 | Bike | TDSPHC-AGL-E--- | 1634540001.0 | 44.1465 | {5c85dcdc-c315-44d2-8783-389a83921c4d} |
| 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} | ||
| 1910560 | 1910560 | 2016-08-22 06:17:48+00:00 | TDSPHC-AGL-E--- | 960215001.0 | 42949.00154 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
| 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} | |
| 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} |
| 919950 | 919950 | 2017-06-06 20:41:41+00:00 | TDSPHC-AGL-EV-- | 627456001.0 | 11841.1 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} | |
| 1792478 | 1792478 | 2020-04-23 04:10:02+00:00 | Bike | TDSPHC-AGL----- | 619316001.0 | 7.4482 | {6637cc35-f314-4448-b32b-aae24d42905c} |
| 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} |
| 2216388 | 2216388 | 2018-10-17 08:08:59+00:00 | Bike | TDSPHC-AGL-E--- | 618422001.0 | 1.20664 | {f302a094-a06f-4218-8735-5f1867fef0b3} |
| 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} |
| 476777 | 476777 | 2019-06-08 07:25:11+00:00 | Bike | TDSPHC-AGL-EV-- | 613954001.0 | 108.69733 | {95e8e781-7722-4311-9102-3ed1089cc60b} |
| 2561943 | 2561943 | 2019-07-30 08:49:32+00:00 | Bike | TDSPHC-AGL-E--- | 609438001.0 | 32.9399 | {87020647-5bd4-47c3-a37e-ac70042794ba} |
| 1349896 | 1349896 | 1999-08-22 00:01:15+00:00 | Bike | TDSPHC-AGL-E--- | 603835001.0 | 27.8901 | {1dc7c187-3560-49eb-8f48-417a7bfa6fa9} |
| 280248 | 280248 | 2019-12-14 08:07:49+00:00 | Bike | TDSPHC-AGL-E--- | 597611001.0 | 81.7145 | {8b1597ea-3301-4f9e-b80a-d65f3a9161cf} |
| 2426137 | 2426137 | 2018-06-03 23:11:13+00:00 | Bike | TDSPHC-AGL-EV-- | 592784001.0 | 13.751 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 2426135 | 2426135 | 2018-06-02 03:00:00+00:00 | Bike | TDSPHC-AGL-EV-- | 592633001.0 | 19.9069 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 561604 | 561604 | 2019-04-01 11:15:21+00:00 | Bike | TDSPHC-AGL----- | 580608001.0 | 1.32917 | {71758615-f396-4e58-8b55-50ea2b7a340b} |
| 2424948 | 2424948 | 1999-08-22 00:00:06+00:00 | Bike | TDSPHC-AGL-EV-- | 580097001.0 | 28.6948 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 2424949 | 2424949 | 1999-08-22 00:02:54+00:00 | Bike | TDSPHC-AGL-EV-- | 579737001.0 | 8.14101 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
| 2453566 | 2453566 | 2017-12-21 23:01:01+00:00 | Bike | TDSPHC-AGL----- | 578703001.0 | 83.66476 | {24130e1a-fb17-4451-a1b0-cd6cb18506ed} |
| 2394443 | 2394443 | 2017-07-02 04:30:23+00:00 | Bike | TDSPHC-AGL----- | 561281001.0 | 136.66065 | {d1d0a4ca-2083-48a6-a31d-87e6dfa46ae4} |
| 891537 | 891537 | 2013-08-22 00:00:15+00:00 | Bike | TDSPHC-AGLWE--- | 524072001.0 | 34.9338 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
| 1019701 | 1019701 | 2019-02-28 16:14:13+00:00 | Bike | TDSPHC-AGL-EV-- | 448768001.0 | 38.11998 | {a3a67e0c-1c41-492b-a214-a0a2b2a09610} |
| 244130 | 244130 | 1999-08-22 00:00:32+00:00 | Bike | TDSPHC-AGL-E--- | 440630001.0 | 15.26438 | {86327876-a4f1-4614-8e5d-1d23d30c8e02} |
| 751007 | 751007 | 2017-04-28 02:48:59+00:00 | Bike | TDSPHC-AGL-E--- | 431835001.0 | 36.0849 | {1dbba82e-8924-4b10-b1da-151e8062680a} |
| 2081071 | 2081071 | 2014-09-12 00:30:43+00:00 | Bike | TDSPHC-AGL-E--- | 374373001.0 | 16.5868 | {a9edc025-0e5d-4c18-935c-a77e1f29ec95} |
| 787144 | 787144 | 2019-09-13 09:06:22+00:00 | Bike | TDSPHC-AGL-EV-- | 366858001.0 | 15.8957 | {8f4ea470-24bb-4a2a-99f2-bdf4522b6daf} |
| 1023641 | 1023641 | 2018-07-26 13:36:06+00:00 | Bike | TDSPHC-AGL-E--- | 365916001.0 | 89.1847 | {e79e279d-d990-4e4f-a391-f535ae60f0bd} |
| 2449878 | 2449878 | 2018-07-26 14:36:06+00:00 | Bike | TDSPHC-AGL-E--- | 365916001.0 | 89.1847 | {da5ed8b3-41b4-40e5-b0e4-5f8c9c3e4409} |
| 142707 | 142707 | 2014-11-26 00:48:46+00:00 | Bike | TDSPHC-AGL-E--- | 341117001.0 | 30.35058 | {bb13fc88-6570-497c-bd13-7521bf30439e} |
| 822907 | 822907 | 2014-11-26 00:48:46+00:00 | Bike | TDSPHC-AGL-E--- | 341117001.0 | 30.35058 | {029abbce-69c2-42fc-ad44-a85541cd98b4} |
| 1862427 | 1862427 | 1978-11-02 09:55:23+00:00 | T-SPHC-AG--E--- | 321615001.0 | {f4d64878-666c-484b-a271-fb36494ef432} | ||
| 2467703 | 2467703 | 2016-03-22 17:37:50+00:00 | Bike | TDSPHC-AGL-EV-- | 309664001.0 | 30.81636 | {f5b8bfcf-b234-42aa-8f6b-ba9a339b6088} |
| 2532715 | 2532715 | 2018-05-03 14:19:39+00:00 | Bike | TDSPHC-AGL-E--- | 309661001.0 | 18.3277 | {bdaa2e96-c1de-4716-a43d-a3730d14de88} |
| 958322 | 958322 | 2019-02-26 03:44:36+00:00 | Bike | TDSPHC-AGL-EV-- | 307249001.0 | 39.6763 | {b3638238-c2d6-4621-923d-f504546ed3f9} |
| 958323 | 958323 | 2019-02-26 03:44:37+00:00 | Bike | TDSPHC-AGL-EV-- | 307249001.0 | 39.6763 | {b3638238-c2d6-4621-923d-f504546ed3f9} |
| 1086002 | 1086002 | 2017-09-03 22:50:24+00:00 | Bike | TDSPHC-AGL-E--- | 292156001.0 | 23.70871 | {3190bec0-d5bd-4914-97ac-1a5d94b53019} |
| 1879127 | 1879127 | 2018-05-23 12:52:02+00:00 | Bike | TDSPHC-AGL-EV-- | 287896001.0 | 70.45555 | {29f05dee-e8a6-41c4-9ae2-cf6b653d6214} |
| 2465911 | 2465911 | 2019-01-05 08:08:07+00:00 | Bike | TDSPHC-AGL-E--- | 251614001.0 | 139.19868 | {36413bd0-f129-4a03-9dad-25e804f20b50} |
| 1855450 | 1855450 | 2019-11-27 21:52:20+00:00 | Bike | TDSPHC-AGL-E--- | 229824001.0 | 0.41585 | {37bef97a-2b4c-4b02-9c1e-61b04bf49ad2} |
| 1904822 | 1904822 | 2019-08-08 15:00:25+00:00 | SLC | TDSPHC-AGL-E--- | 154834001.0 | 40.97393 | {5c849db5-a881-44e5-b0ce-eee9c92cd971} |
| 550336 | 550336 | 2014-08-31 17:50:28+00:00 | Bike | TDSPHC-AGL----- | 145091001.0 | 29.5302 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 1610651 | 1610651 | 2019-02-27 14:28:22+00:00 | Bike | TDSPHC-AGL----- | 117339001.0 | 49.6544 | {bf112bad-2d34-4ff4-be9c-b7b2129f5a39} |
| 1093936 | 1093936 | 2019-09-17 16:56:57+00:00 | Bike | TDSPHC-AGL-E--- | 114309001.0 | 9.53824 | {779ec98d-2fee-4e4f-a631-a22a05dde2b1} |
| 1085950 | 1085950 | 2017-07-05 22:45:47+00:00 | Bike | TDSPHC-AGL-E--- | 106450001.0 | 24.45208 | {3190bec0-d5bd-4914-97ac-1a5d94b53019} |
| 1784935 | 1784935 | 2016-02-26 22:04:10+00:00 | Bike | TDSPHC-AGL-E--- | 98082901.0 | 69.92074 | {f5140f99-ccd9-4a22-a7f2-09500c948b0d} |
| 2445481 | 2445481 | 2016-03-08 09:11:03+00:00 | Strada | TDSPHC-AGL-EV-- | 97168401.0 | 108.61582 | {7c6b4603-ed9c-4906-90c0-e95664e00c7d} |
| 1676671 | 1676671 | 2016-04-06 17:05:58+00:00 | Bike | TDSPHC-AGL-E--- | 94638201.0 | 43.7415 | {1119d36c-f303-4afd-8334-3cec111e75a2} |
| 447133 | 447133 | 2020-01-20 00:51:10+00:00 | Bike | TDSPHC-AGL-E--- | 93753201.0 | 58.656 | {b6667d8d-8e4c-4bab-9053-88b1399f9095} |
| 249394 | 249394 | 2016-06-10 12:28:43+00:00 | Bike | TDSPHC-AGL-EV-- | 89040301.0 | 67.04751 | {fead7df2-7bc1-4682-bd0f-c4c77c654771} |
| 642820 | 642820 | 2016-06-16 10:17:23+00:00 | Bike | TDSPHC-AGL-EV-- | 88529701.0 | 18.54685 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
| 642821 | 642821 | 2016-06-16 10:17:24+00:00 | Bike | TDSPHC-AGL----- | 88529701.0 | 18.54685 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
| 550683 | 550683 | 2016-09-09 09:49:50+00:00 | Bike | TDSPHC-AGL-E--- | 81185401.0 | 48.6567 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 923954 | 923954 | 2016-11-18 21:01:56+00:00 | Bike | TDSPHC-AGL-EV-- | 75615401.0 | 114.84842 | {d6881f40-9735-4ccf-ac2b-6d83e4c62ae9} |
| 919887 | 919887 | 2017-02-19 21:42:38+00:00 | Bike | TDSPHC-AGL-EV-- | 67059501.0 | 23.2343 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} |
| 253851 | 253851 | 2017-03-02 03:17:36+00:00 | Bike | TDSPHC-AGL-EV-- | 66532201.0 | 22.72228 | {b835e58e-84ac-4e76-a390-0e7bde2f9401} |
| 1974431 | 1974431 | 2017-03-27 21:51:51+00:00 | Bike | TDSPHC-AGL-E--- | 63951701.0 | 33.26046 | {7968d26c-73a6-4730-ab1f-d89ead4d0427} |
| 1544955 | 1544955 | 2017-04-14 07:22:40+00:00 | Bike | TDSPHC-AGL-EV-- | 62441401.0 | 113.19238 | {9861246f-a5e2-4cb5-8249-37f188810723} |
| 2224940 | 2224940 | 2017-04-23 06:33:45+00:00 | Bike | TDSPHC-AGL-EV-- | 61669301.0 | 66.49057 | {c39d264d-0971-456f-a181-5e246566ce76} |
| 2224941 | 2224941 | 2017-04-23 15:07:00+00:00 | Bike | TDSPHC-AGL-EV-- | 61669301.0 | 66.49057 | {c39d264d-0971-456f-a181-5e246566ce76} |
| 213593 | 213593 | 2017-01-25 08:52:02+00:00 | Bike | TDSPHC-AGL-E--- | 59881201.0 | 37.3469 | {68d4225d-c280-4f91-9c6f-9f8f1afe6998} |
| 1632366 | 1632366 | 2017-05-15 17:56:28+00:00 | Bike | TDSPHC-AGL-EV-- | 59726901.0 | 45.53434 | {60310096-c114-4420-b427-8c2fb0a801f6} |
| 865168 | 865168 | 2017-05-22 16:27:37+00:00 | Bike | TDSPHC-AGL-EV-- | 59132101.0 | 46.0116 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
| 1651000 | 1651000 | 2017-05-29 07:03:28+00:00 | Bike | TDSPHC-AGL-EV-- | 58555001.0 | 8.07405 | {284c633c-98cb-4ea4-86dc-a4bb54761fb4} |
| 1651005 | 1651005 | 2017-06-03 10:56:08+00:00 | Bike | TDSPHC-AGL-EV-- | 58107901.0 | 0.29891 | {284c633c-98cb-4ea4-86dc-a4bb54761fb4} |
| 1824762 | 1824762 | 2018-05-12 09:35:51+00:00 | race | TDSPHC-AGL-EV-- | 58070401.0 | 68.43018 | {68394158-ff37-4301-b00a-5c772c28ddd7} |
| 2402579 | 2402579 | 2018-05-12 09:35:51+00:00 | race | TDSPHC-AGL-EV-- | 58070401.0 | 68.43018 | {d420e4fa-be48-400b-92ec-535b9aa5a381} |
| 865185 | 865185 | 2017-06-13 11:24:36+00:00 | Bike | TDSPHC-AGL-EV-- | 57256801.0 | 81.477 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
| 643134 | 643134 | 2017-06-21 16:02:29+00:00 | Bike | TDSPHC-AGL----- | 56547401.0 | 36.2751 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
| 375679 | 375679 | 2017-07-05 01:25:29+00:00 | Bike | TDSPHC-AGL-E--- | 55382501.0 | 67.3562 | {48be26a3-90dc-466b-997a-611e019e8da9} |
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");