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 |
---|---|---|---|---|---|---|---|
919971 | 919971 | 2017-07-08 12:14:37+00:00 | TDSPHC-AGL-EV-- | 55088401.0 | 62.7794 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} | |
919973 | 919973 | 2017-07-08 15:05:13+00:00 | Bike | TDSPHC-AGL-EV-- | 55073801.0 | 38.326 | {10bf4326-2165-4ef5-b60d-2c74f5b2d85d} |
865227 | 865227 | 2017-08-09 11:40:51+00:00 | Bike | TDSPHC-AGL-EV-- | 52329501.0 | 145.31 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
865230 | 865230 | 2017-08-14 10:28:50+00:00 | Bike | TDSPHC-AGL-EV-- | 51908101.0 | 106.219 | {20b431ec-c039-4416-baf4-b7ca7a0a4a6a} |
643167 | 643167 | 2017-09-16 09:10:36+00:00 | Bike | TDSPHC-AGL-EV-- | 49056201.0 | 86.5667 | {92cd810d-ba84-42dc-a182-88aebfc2f689} |
1762913 | 1762913 | 2017-09-21 13:12:45+00:00 | Bike | TDSPHC-AGL-E--- | 48999701.0 | 64.3769 | {07476629-ae8d-478f-967b-67bff9d8f4fe} |
1937497 | 1937497 | 2016-03-09 06:13:20+00:00 | Bike | TDSPHC-AGL-EV-- | 48390301.0 | 29.2297 | {ac398fa9-97d1-4273-9998-29c2f715d2fd} |
1436491 | 1436491 | 2017-10-01 09:59:07+00:00 | Bike | TDSPHC-AGL-E--- | 47745901.0 | 6.11587 | {28eb831c-6d65-4a43-9c9e-882a0dad9c23} |
2425828 | 2425828 | 2017-06-12 20:50:41+00:00 | Bike | TDSPHC-AGL-EV-- | 43550701.0 | 38.069 | {e8864ee0-92f6-4681-bc01-db71d8347742} |
1436533 | 1436533 | 2017-12-01 14:53:49+00:00 | Bike | TDSPHC-AGL-E--- | 42462901.0 | 35.1781 | {28eb831c-6d65-4a43-9c9e-882a0dad9c23} |
1436546 | 1436546 | 2017-12-19 19:24:35+00:00 | Bike | TDSPHC-AGL-E--- | 40886101.0 | 25.3149 | {28eb831c-6d65-4a43-9c9e-882a0dad9c23} |
892728 | 892728 | 2018-01-27 12:02:11+00:00 | Bike | TDSPHC-AGL-E--- | 38108901.0 | 43.8588 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
751236 | 751236 | 2018-03-11 18:56:52+00:00 | Bike | TDSPHC-AGL-EV-- | 33873801.0 | 36.5975 | {1dbba82e-8924-4b10-b1da-151e8062680a} |
766951 | 766951 | 2018-03-30 12:11:25+00:00 | Bike | TDSPHC-AGL-E--- | 32671501.0 | 92.4798 | {ab4fd78c-8437-4890-b22b-0ecd6d3da507} |
1480935 | 1480935 | 2018-03-30 08:10:43+00:00 | Bike | TDSPHC-AGL-E--- | 32671101.0 | 78.96091 | {29638c81-44fc-4a8b-b4b6-1c91d3fd5d95} |
1205462 | 1205462 | 2018-04-12 11:56:56+00:00 | Bike | TDSPHC-AGL-EV-- | 31458601.0 | 67.9301 | {df5c1f03-dba4-44c6-bf34-0daaac7f64ed} |
1627096 | 1627096 | 2018-05-07 08:33:15+00:00 | TDSPHC-AGL-E--- | 28916801.0 | 92.20652 | {de210a15-e9f2-4dd8-a914-81c4ed6d3966} | |
381402 | 381402 | 2018-08-31 16:10:46+00:00 | Bike | TDSPHC-AGL-EV-- | 27741601.0 | 16.6796 | {c469fc87-73b2-40ea-978b-a745288e9015} |
1525348 | 1525348 | 2017-08-07 18:04:22+00:00 | Bike | TDSPHC-AGL-EV-- | 27220601.0 | 38.54906 | {16645598-494e-48fc-a2c4-fa380489e2c0} |
2523842 | 2523842 | 2018-06-10 13:40:08+00:00 | Bike | TDSPHC-AGL----- | 25961301.0 | 22.659 | {58ca145c-818c-412d-b2fc-027c30e71c9e} |
1023615 | 1023615 | 2018-06-30 10:11:02+00:00 | Bike | TDSPHC-AGL-E--- | 24825401.0 | 212.877 | {e79e279d-d990-4e4f-a391-f535ae60f0bd} |
2449852 | 2449852 | 2018-06-30 11:11:02+00:00 | Bike | TDSPHC-AGL-E--- | 24825401.0 | 212.877 | {da5ed8b3-41b4-40e5-b0e4-5f8c9c3e4409} |
1204916 | 1204916 | 2020-04-20 20:32:17+00:00 | Bike | T-SPHC-AG--E--- | 24800301.0 | {45eab89c-c876-48c9-9f9a-726e96ea821c} | |
808876 | 808876 | 2018-08-24 00:57:31+00:00 | Bike | TDSPHCNAGL-EV-- | 24653301.0 | 74.85733 | {caea47ff-9f07-4009-828b-67e14681eb02} |
808986 | 808986 | 2019-06-05 20:38:15+00:00 | Bike | TDSPHCNAGL-EV-- | 24653301.0 | 74.85733 | {caea47ff-9f07-4009-828b-67e14681eb02} |
1584383 | 1584383 | 2018-07-14 00:14:01+00:00 | Bike | TDSPHC-AGL-E--- | 23074401.0 | 40.7845 | {aa5165ba-5072-4b77-86c5-5c00284e3b53} |
2452719 | 2452719 | 2018-08-21 05:31:15+00:00 | TDSPHC-AGL-EV-- | 19988101.0 | 121.722 | {481aee29-ca3f-47ab-ae20-688b0b28f997} | |
2448944 | 2448944 | 2018-08-25 14:27:11+00:00 | Bike | TDSPHC-AGL-E--- | 19968801.0 | 53.93793 | {f9960deb-9dd3-4854-b1b5-899b739ab105} |
2204650 | 2204650 | 2018-08-22 11:17:18+00:00 | Bike | TDSPHC-AGL-E--- | 19963101.0 | 35.28336 | {e3cab080-161c-4462-8d3c-51cf91e428a4} |
1707233 | 1707233 | 2018-08-26 10:39:31+00:00 | Bike | TDSPHC-AGL-EV-- | 19364301.0 | 82.6976 | {e58c276d-9e21-4dcf-8121-703ee2c6f729} |
1858349 | 1858349 | 2018-09-08 10:11:21+00:00 | Bike | TD-PHC-AGL-E--- | 18196501.0 | 0.51668 | {1e518c35-d331-4d7f-8df7-195f7ca9faaa} |
2230804 | 2230804 | 2018-02-07 07:30:12+00:00 | Bike | TDSPHC-AGL-E--- | 16892201.0 | 21.63455 | {5d7d3a8c-4df8-48ba-a06a-c08d1a6ac4d8} |
1459572 | 1459572 | 2018-12-15 11:52:14+00:00 | Bike | TDSPHC-AGL-EV-- | 15746501.0 | 128.14374 | {8451ed8f-9574-4f33-a963-d9ad2e5441b9} |
2561489 | 2561489 | 2018-10-28 07:23:26+00:00 | Bike | TDSPHC-AGL-EV-- | 13894701.0 | 53.0783 | {87020647-5bd4-47c3-a37e-ac70042794ba} |
2192034 | 2192034 | 2018-12-01 10:12:15+00:00 | Bike | TDSPHC-AGL-E--- | 10950201.0 | 110.51807 | {d217622d-92f7-44c5-b935-72700aa29598} |
1202772 | 1202772 | 2019-07-13 00:43:26+00:00 | Bike | TDSPHC-AGL-E--- | 10906001.0 | 67.793 | {ffb71181-c71d-4b00-9fbd-fa441c125566} |
329370 | 329370 | 2013-04-26 06:39:05+00:00 | Bike | TD-PHC-AGL-E--- | 10794101.0 | 0.01884 | {d2f8bc28-039d-4f21-b112-9a21d51b008c} |
915789 | 915789 | 2017-02-27 02:50:08+00:00 | Bike | TDSPHC-AGL-EV-- | 9802981.0 | 18.281 | {f0a0412f-0a3d-4d71-b9ef-5d839a5e8aa9} |
1682833 | 1682833 | 2017-02-27 02:50:09+00:00 | Bike | TDSPHC-AGL-E--- | 9802981.0 | 18.281 | {a31f3639-3565-4597-be26-69f37057230a} |
830068 | 830068 | 2015-01-13 18:14:50+00:00 | Bike | TDSPHC-AGL-E--- | 9068471.0 | 1.8567 | {94fb1d7e-3a03-41de-8b80-a4b587b8ab0d} |
2525191 | 2525191 | 2019-02-23 13:43:14+00:00 | Bike | TDSPHC-AGL-E--- | 8470041.0 | 60.23691 | {b22a5567-7cf5-4413-8a88-35c59245c99c} |
2309321 | 2309321 | 2013-10-10 06:38:32+00:00 | Bike | TDSPHC-AGL-E--- | 7864191.0 | 12.101 | {8343d0a4-7254-48d3-9666-c1e39be0e0d2} |
1093992 | 1093992 | 2019-10-31 19:27:41+00:00 | Bike | TDSPHC-AGL-E--- | 7864011.0 | 9.79668 | {779ec98d-2fee-4e4f-a631-a22a05dde2b1} |
1132949 | 1132949 | 2017-05-10 17:18:13+00:00 | Bike | TDSPHC-AGL-E--- | 7280191.0 | 27.0608 | {b8101019-6f71-42f3-ac72-b5b6fbc3bd2e} |
1617096 | 1617096 | 2017-05-10 17:18:13+00:00 | Bike | TDSPHC-AGL-E--- | 7280191.0 | 27.0608 | {d686b098-3e13-47c9-bb1c-b79fc96454df} |
494197 | 494197 | 2019-01-27 07:27:55+00:00 | Bike | TDSPHC-AGL-EV-- | 6064141.0 | 133.02966 | {5fb378ab-7d06-4ad5-8a6b-488321c5513a} |
1201838 | 1201838 | 2019-01-27 09:29:10+00:00 | Bike | TDSPHC-AGL-E--- | 6056261.0 | 89.268 | {5f4345ea-270d-4342-915a-92c28eb0b4b2} |
1273185 | 1273185 | 2016-09-03 11:00:04+00:00 | Bike | TDSPHC-A-L-EV-- | 5959581.0 | 5.7029 | {9fa04826-c54d-4e3f-8278-403f3854c750} |
1822479 | 1822479 | 2017-12-17 09:36:18+00:00 | Bike | TDSPHC-AGL-E--- | 5577681.0 | 35.9304 | {c5302ad9-dd0d-4307-a1dd-25489c3da0e7} |
1781184 | 1781184 | 2017-06-29 16:12:47+00:00 | Bike | TDSPHC-AGL-EV-- | 5072951.0 | 33.6594 | {bdd7dbc1-d285-4130-85b6-e88ff370deec} |
2341652 | 2341652 | 2007-12-11 02:30:08+00:00 | TDSPHCN-------- | 4880881.26 | 362.468 | {a15ef869-c522-41df-a13a-c23e58339d34} | |
239608 | 239608 | 2015-02-28 09:11:49+00:00 | Bike | TDSPHC-AGL----- | 4854731.0 | 83.22988 | {f7cf7973-ca61-451d-bffd-467652af2a30} |
1858368 | 1858368 | 2018-12-11 00:11:00+00:00 | Bike | TDSPHC-AGL-E--- | 4707401.0 | 47.4034 | {1e518c35-d331-4d7f-8df7-195f7ca9faaa} |
1032677 | 1032677 | 2017-07-31 13:39:15+00:00 | Bike | TDSPHC-AGL-EV-- | 4652601.0 | 33.42613 | {144beb91-ca43-4f6d-8629-6d00ea70beca} |
662152 | 662152 | 2018-10-30 06:29:02+00:00 | Bike | TDSPHC-AGL-EV-- | 4593311.0 | 30.99423 | {47686a90-73eb-42c2-9cb1-7ec7a67a43b3} |
892322 | 892322 | 2016-07-18 15:37:35+00:00 | Bike | TDSPHC-AGL-E--- | 4495671.0 | 164.81 | {0291283c-c8f2-4c81-b9b1-294bf19378db} |
1752718 | 1752718 | 2020-03-07 15:56:10+00:00 | Bike | TDSPHC-AGL-E--- | 4294151.0 | 16.6875 | {2fee1f7c-e3b1-4a58-a03e-8359ef5cf023} |
1336859 | 1336859 | 2008-02-06 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 4269451.001 | 588.60214 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
2325928 | 2325928 | 2017-07-05 08:23:31+00:00 | Bike | TDSPHC-AGL-EV-- | 4258851.0 | 138.86562 | {bb9e4389-816d-4b5a-bea0-f2ec8136f692} |
1336987 | 1336987 | 2008-11-19 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 4244161.002 | 1715.13128 | {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} |
1337608 | 1337608 | 2012-03-14 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 4148211.003 | 1324.76248 | {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} |
1337004 | 1337004 | 2008-12-20 08:00:00+00:00 | Bike | TDSPH--A-L----- | 4063811.001 | 3617.12172 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
276512 | 276512 | 2011-02-11 05:00:00+00:00 | Bike | TDSPHC--------- | 4016641.0 | 1128.77122 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
1336738 | 1336738 | 2007-05-24 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3982891.002 | 735.29028 | {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} |
1337616 | 1337616 | 2012-03-31 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3954831.029 | 1171.90312 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
2462238 | 2462238 | 2017-06-24 12:51:40+00:00 | Bike | TDSPHC-AGL----- | 3902831.0 | 59.65793 | {ad349b18-fb38-4114-a395-95393679f9e0} |
1336718 | 1336718 | 2007-03-22 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3899021.032 | 2058.61295 | {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} |
586470 | 586470 | 2018-05-06 10:36:07+00:00 | Bike | TDSPHC-AGL-EV-- | 3833671.0 | 22.1404 | {07382a6a-c3cb-45e1-8b9b-fd13f9164ab5} |
1336845 | 1336845 | 2008-01-08 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3620681.001 | 1248.41072 | {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} |
1337022 | 1337022 | 2009-01-23 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3599531.031 | 1276.25069 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
276487 | 276487 | 2011-01-13 05:00:00+00:00 | Bike | TDSPHC--------- | 3591721.0 | 1132.68 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
1337431 | 1337431 | 2011-02-24 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3528171.022 | 702.24603 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1337612 | 1337612 | 2012-03-22 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3520281.001 | 916.86303 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1337204 | 1337204 | 2009-12-16 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3511871.002 | 1161.14468 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
276506 | 276506 | 2011-02-04 05:00:00+00:00 | Bike | TDSPHC--------- | 3500751.0 | 1142.74233 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
276503 | 276503 | 2011-01-31 05:00:00+00:00 | Bike | TDSPHC--------- | 3492631.0 | 1123.36089 | {3d296088-fb88-49c8-886e-3c020c5bba60} |
1337555 | 1337555 | 2011-11-17 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3477741.001 | 1071.19231 | {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} |
1202713 | 1202713 | 2019-02-26 12:18:06+00:00 | Bike | TDSPHC-AGL----- | 3415611.0 | 121.107 | {380a570a-f58a-4edf-816b-32cf6861c790} |
1931068 | 1931068 | 2018-03-04 12:55:30+00:00 | Bike | TDSPHC-AGL----- | 3388471.0 | 67.66347 | {be587e15-9693-42f1-972d-bdf2ec23f40b} |
1337613 | 1337613 | 2012-03-24 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3354941.035 | 1311.74273 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1337398 | 1337398 | 2011-01-01 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3335343.465 | 3483.58 | {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} |
1337740 | 1337740 | 2012-11-30 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3304281.014 | 1236.13707 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1337779 | 1337779 | 2013-04-02 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3268331.031 | 1286.06498 | {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} |
1336729 | 1336729 | 2007-04-30 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3254571.061 | 1545.40233 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1336996 | 1336996 | 2008-12-04 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3252671.002 | 1097.69028 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1336974 | 1336974 | 2008-10-30 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3252581.031 | 1209.96009 | {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} |
1337222 | 1337222 | 2010-01-24 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3227381.001 | 4219.26589 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1336867 | 1336867 | 2008-02-22 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3211141.002 | 1231.82097 | {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} |
1336847 | 1336847 | 2008-01-15 08:00:00+00:00 | Bike | TDSPHC-A-L----- | 3171661.001 | 1251.00053 | {8e6fb23f-d718-41ac-a1d5-dec50ba13f16} |
1336739 | 1336739 | 2007-06-01 07:00:00+00:00 | Bike | TDSPHC-A-L----- | 3167281.001 | 522.87486 | {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");