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 |
|---|---|---|---|---|---|---|---|
| 1937056 | 1937056 | 2015-01-01 20:08:46+00:00 | Bike | TDSPHCNA-L-E--- | 35228.0 | 974062.001 | {ac398fa9-97d1-4273-9998-29c2f715d2fd} |
| 386504 | 386504 | 2013-07-14 05:34:03+00:00 | TDSPHCN----E--- | 20121.4 | 171020.905 | {79c247de-f880-4c1e-a2d0-afefbd9762c4} | |
| 90838 | 90838 | 2019-08-11 07:59:45+00:00 | TDSPHC-AGL-E--- | 12605.0 | 143942.0 | {eb78184c-32d6-4b60-93a9-ffed00a8d898} | |
| 1292269 | 1292269 | 2018-07-31 06:24:19+00:00 | Bike | TDSPH--AGL----- | 10001.0 | 129934.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 647251 | 647251 | 2018-04-29 05:55:41+00:00 | Bike | TDSPH---------- | 8748.0 | 92705.00608 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647119 | 647119 | 2017-09-11 06:40:31+00:00 | Bike | TD-PH---------- | 9038.0 | 91915.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647062 | 647062 | 2017-04-16 09:34:59+00:00 | Bike | TD-PH---------- | 9077.0 | 91870.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 380716 | 380716 | 2018-05-13 07:20:18+00:00 | Bike | TDSPH--AGL----- | 20001.0 | 90748.4 | {fc2e40c8-d412-4775-a4af-b5519e29a30d} |
| 647021 | 647021 | 2016-07-27 05:16:49+00:00 | Bike | TD-PH---------- | 6358.0 | 85164.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 380717 | 380717 | 2018-05-14 10:17:51+00:00 | Bike | TDSPH--AGL----- | 10001.0 | 74077.6 | {fc2e40c8-d412-4775-a4af-b5519e29a30d} |
| 647042 | 647042 | 2017-01-21 07:12:29+00:00 | Bike | TD-PH---------- | 6766.0 | 71719.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647078 | 647078 | 2017-06-03 07:51:50+00:00 | Bike | TD-PH---------- | 6766.0 | 70506.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647054 | 647054 | 2017-03-18 08:59:02+00:00 | Bike | TD-PH---------- | 6707.0 | 60908.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647107 | 647107 | 2017-08-09 05:22:32+00:00 | Bike | TD-PH---------- | 5498.0 | 59064.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647012 | 647012 | 2016-06-08 05:07:52+00:00 | Bike | TD-PH---------- | 5093.0 | 57773.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647020 | 647020 | 2016-07-26 05:34:46+00:00 | Bike | TD-PH---------- | 4210.0 | 56849.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647086 | 647086 | 2017-06-10 06:10:09+00:00 | Bike | TD-PH---------- | 6232.0 | 53968.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647076 | 647076 | 2017-05-29 07:10:52+00:00 | Bike | TD-PH---------- | 4638.0 | 49310.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647099 | 647099 | 2017-07-07 04:58:11+00:00 | Bike | TD-PH---------- | 4576.0 | 49028.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647084 | 647084 | 2017-06-07 05:02:58+00:00 | Bike | TD-PH---------- | 4320.0 | 47965.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647089 | 647089 | 2017-06-14 05:18:10+00:00 | Bike | TD-PH---------- | 3877.0 | 46289.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647108 | 647108 | 2017-08-11 05:09:38+00:00 | Bike | TD-PH---------- | 3877.0 | 44545.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647097 | 647097 | 2017-07-01 05:10:02+00:00 | Bike | TD-PH---------- | 3776.0 | 43608.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647151 | 647151 | 2017-12-15 06:16:01+00:00 | Bike | TD-PH---------- | 3698.0 | 43328.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 2490695 | 2490695 | 2017-12-15 06:16:01+00:00 | Bike | TD-PH---------- | 3698.0 | 43328.3 | {7e63dd42-48f0-4d2b-896e-62f5e22c8e88} |
| 647022 | 647022 | 2016-07-28 05:28:07+00:00 | Bike | TD-PH---------- | 3300.0 | 43288.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647063 | 647063 | 2017-04-18 05:58:56+00:00 | Bike | TD-PH---------- | 3693.0 | 43144.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1910560 | 1910560 | 2016-08-22 06:17:48+00:00 | TDSPHC-AGL-E--- | 960215001.0 | 42949.00154 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
| 656141 | 656141 | 2018-05-12 05:10:45+00:00 | Bike | TD-PHC-A-L-E--- | 2705.0 | 42949.0 | {18cece44-5338-4e6e-9e8d-0da4f6004e35} |
| 1684400 | 1684400 | 2018-02-28 10:46:00+00:00 | Bike | TD-PHC-AGL-EV-- | 6901.0 | 42949.0 | {abf4bf77-5b84-4dd9-a3e8-7bac69f88718} |
| 647037 | 647037 | 2016-12-29 06:26:20+00:00 | Bike | TD-PH---------- | 3665.0 | 42181.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647058 | 647058 | 2017-03-30 05:41:35+00:00 | Bike | TD-PH---------- | 3547.0 | 41871.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647116 | 647116 | 2017-08-27 07:54:30+00:00 | Bike | TD-PH---------- | 3699.0 | 40679.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1294203 | 1294203 | 2018-01-13 12:06:10+00:00 | Bike | TD-PH--AGL----- | 12730.0 | 40605.9 | {fde35fe9-5c6c-4c46-a3af-bfcff42eef13} |
| 647010 | 647010 | 2016-06-03 06:58:59+00:00 | Bike | TD-PH---------- | 3590.0 | 40594.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647299 | 647299 | 2018-09-11 07:53:48+00:00 | Bike | TDSPH---G------ | 6135.0 | 40569.50767 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647006 | 647006 | 2016-04-07 05:23:06+00:00 | Bike | TD-PH---------- | 3415.0 | 40111.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647115 | 647115 | 2017-08-23 05:19:51+00:00 | Bike | TD-PH---------- | 3547.0 | 39748.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647059 | 647059 | 2017-04-01 05:19:09+00:00 | Bike | TD-PH---------- | 3660.0 | 39684.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647014 | 647014 | 2016-06-10 05:18:56+00:00 | Bike | TD-PH---------- | 3502.0 | 39614.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647118 | 647118 | 2017-09-06 05:21:36+00:00 | Bike | TD-PH---------- | 3479.0 | 38864.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647317 | 647317 | 2018-11-04 07:41:38+00:00 | Bike | TDSPH---------- | 4769.0 | 38689.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1294202 | 1294202 | 2018-01-09 16:10:06+00:00 | Bike | TD-PH--AGL----- | 10957.0 | 38005.3 | {fde35fe9-5c6c-4c46-a3af-bfcff42eef13} |
| 647008 | 647008 | 2016-05-25 05:19:46+00:00 | Bike | TD-PH---------- | 3547.0 | 37909.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647015 | 647015 | 2016-06-17 05:15:54+00:00 | Bike | TD-PH---------- | 3360.0 | 37478.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647007 | 647007 | 2016-04-27 05:34:04+00:00 | Bike | TD-PH---------- | 3051.0 | 37094.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 46825 | 46825 | 2017-09-02 16:13:31+00:00 | TDSPHC-AGL-EV-- | 3304070001.0 | 36920.60379 | {eae1fba0-7105-4cf7-9933-f13fb56e3152} | |
| 647117 | 647117 | 2017-09-05 05:15:52+00:00 | Bike | TD-PH---------- | 3415.0 | 36372.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647124 | 647124 | 2017-09-21 05:13:36+00:00 | Bike | TD-PH---------- | 3406.0 | 35860.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647065 | 647065 | 2017-04-26 05:15:10+00:00 | Bike | TD-PH---------- | 3350.0 | 35791.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647057 | 647057 | 2017-03-28 05:21:03+00:00 | Bike | TD-PH---------- | 3051.0 | 35462.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647123 | 647123 | 2017-09-19 05:23:30+00:00 | Bike | TD-PH---------- | 3659.0 | 35334.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647130 | 647130 | 2017-09-29 05:14:34+00:00 | Bike | TD-PH---------- | 3349.0 | 35302.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647127 | 647127 | 2017-09-26 05:17:28+00:00 | Bike | TD-PH---------- | 3659.0 | 34885.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647005 | 647005 | 2016-04-01 05:34:28+00:00 | Bike | TD-PH---------- | 2969.0 | 34680.0 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647053 | 647053 | 2017-03-14 06:19:08+00:00 | Bike | TD-PH---------- | 3659.0 | 34445.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 646999 | 646999 | 2016-03-15 06:24:42+00:00 | Bike | TD-PH---------- | 3415.0 | 34381.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 646997 | 646997 | 2016-03-10 06:30:57+00:00 | Bike | TD-PH---------- | 3415.0 | 34377.2 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 1910580 | 1910580 | 2016-09-19 07:53:00+00:00 | TDSPHC-AGL-E--- | 802732001.0 | 34057.70222 | {bc1b5e15-9057-4393-bab1-477d9aaa73f8} | |
| 647095 | 647095 | 2017-06-27 05:23:46+00:00 | Bike | TD-PH---------- | 2959.0 | 32885.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647018 | 647018 | 2016-06-28 05:28:40+00:00 | Bike | TD-PH---------- | 2825.0 | 32629.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647082 | 647082 | 2017-06-06 05:36:41+00:00 | Bike | TD-PH---------- | 2794.0 | 32409.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647214 | 647214 | 2018-03-13 06:20:03+00:00 | Bike | TD-PH---------- | 3045.0 | 32361.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 2490758 | 2490758 | 2018-03-13 06:20:03+00:00 | Bike | TD-PH---------- | 3045.0 | 32361.5 | {7e63dd42-48f0-4d2b-896e-62f5e22c8e88} |
| 647096 | 647096 | 2017-06-29 06:04:22+00:00 | Bike | TD-PH---------- | 2969.0 | 31403.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 551156 | 551156 | 2019-02-07 13:10:58+00:00 | Bike | TD-PH---------- | 10001.0 | 31274.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551184 | 551184 | 2019-03-21 13:09:56+00:00 | Bike | -D-PH---------- | 1.0 | 31264.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 647066 | 647066 | 2017-04-27 05:31:04+00:00 | Bike | TD-PH---------- | 2836.0 | 31080.8 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647125 | 647125 | 2017-09-22 05:18:40+00:00 | Bike | TD-PH---------- | 2633.0 | 30172.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647129 | 647129 | 2017-09-28 05:32:56+00:00 | Bike | TD-PH---------- | 2867.0 | 29702.5 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 551185 | 551185 | 2019-03-25 11:06:26+00:00 | Bike | -D-PH---------- | 1.0 | 29547.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 647111 | 647111 | 2017-08-15 05:39:19+00:00 | Bike | TD-PH---------- | 2347.0 | 29389.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647040 | 647040 | 2017-01-14 08:48:43+00:00 | Bike | TD-PH---------- | 3699.0 | 29140.1 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647128 | 647128 | 2017-09-27 05:19:52+00:00 | Bike | TD-PH---------- | 2998.0 | 27303.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647001 | 647001 | 2016-03-17 06:28:23+00:00 | Bike | TD-PH---------- | 2312.0 | 27203.7 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 220464 | 220464 | 2018-02-15 13:16:54+00:00 | TDSPHC-AGL-EV-- | 3406810001.0 | 27032.9 | {4f653f36-e2da-47d2-b65c-04c935c72a54} | |
| 1522197 | 1522197 | 2019-01-15 18:21:48+00:00 | TDSPHC-AGL-EV-R | 2544.0 | 26992.30063 | {4b213def-3979-4380-b5d2-617a9e269652} | |
| 647049 | 647049 | 2017-02-15 07:09:23+00:00 | Bike | TD-PH---------- | 3698.0 | 26499.9 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647041 | 647041 | 2017-01-20 06:14:03+00:00 | Bike | TD-PH---------- | 3699.0 | 26019.6 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 647045 | 647045 | 2017-01-25 06:21:16+00:00 | Bike | TD-PH---------- | 2313.0 | 25968.3 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 646966 | 646966 | 2016-01-09 09:28:55+00:00 | Bike | TD-PH---G------ | 4004.0 | 25533.4 | {4221a20b-fcf5-4d27-9df4-046648a0ac64} |
| 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} | |
| 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} | |
| 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} |
| 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} |
| 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} | |
| 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} |
| 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} | |
| 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} |
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");