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 date
This data as json, CSV (advanced)
| Link | rowid | date ▼ | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1286277 | 1286277 | 1989-12-30 20:06:59+00:00 | Bike | TDSPHC-AGL----- | 6646.0 | 50.38551 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286278 | 1286278 | 1989-12-30 20:20:41+00:00 | Bike | TDSPHC-AGL----- | 5826.0 | 41.88769 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286279 | 1286279 | 1989-12-30 20:26:42+00:00 | Bike | TDSPHC-AGL----- | 5539.0 | 33.71518 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 630476 | 630476 | 1989-12-30 20:35:14+00:00 | Bike | TDSPHC-AGL----- | 5038.0 | 34.66796 | {060e8ebe-06f0-4f3c-b85f-7a83c2b2e935} |
| 1286280 | 1286280 | 1989-12-30 20:36:16+00:00 | Bike | TDSPHC-AGL----- | 5025.0 | 23.10911 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286281 | 1286281 | 1989-12-30 20:37:02+00:00 | Bike | TDSPHC-AGL----- | 4916.0 | 19.97397 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286282 | 1286282 | 1989-12-30 20:38:38+00:00 | Bike | TDSPHC-AGL----- | 4840.0 | 19.80339 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286283 | 1286283 | 1989-12-30 20:39:03+00:00 | Bike | TDSPHC-AGL----- | 4809.0 | 20.69838 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286284 | 1286284 | 1989-12-30 20:39:55+00:00 | Bike | TDSPHC-AGL----- | 4628.0 | 43.13033 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286285 | 1286285 | 1989-12-30 20:40:56+00:00 | Bike | TDSPHC-AGL----- | 4678.0 | 20.01092 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286286 | 1286286 | 1989-12-30 20:41:16+00:00 | Bike | TDSPHC-AGL----- | 4682.0 | 19.74628 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286287 | 1286287 | 1989-12-30 20:43:20+00:00 | Bike | TDSPHC-AGL----- | 4538.0 | 19.76354 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286288 | 1286288 | 1989-12-30 20:45:52+00:00 | Bike | TDSPHC-AGL----- | 4328.0 | 19.73894 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286289 | 1286289 | 1989-12-30 20:46:13+00:00 | Bike | TDSPHC-AGL----- | 4355.0 | 19.85701 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286290 | 1286290 | 1989-12-30 20:48:14+00:00 | Bike | TDSPHC-AGL----- | 4083.0 | 30.0564 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 630477 | 630477 | 1989-12-30 20:48:56+00:00 | Bike | TDSPHC-AGL----- | 4173.0 | 33.20507 | {060e8ebe-06f0-4f3c-b85f-7a83c2b2e935} |
| 1286291 | 1286291 | 1989-12-30 20:52:14+00:00 | Bike | TDSPHC-AGL----- | 3986.0 | 29.88766 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286292 | 1286292 | 1989-12-30 20:52:16+00:00 | Bike | TDSPHC-AGL----- | 3892.0 | 27.51542 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286293 | 1286293 | 1989-12-30 20:52:45+00:00 | Bike | TDSPHC-AGL----- | 4036.0 | 31.51216 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286294 | 1286294 | 1989-12-30 20:53:18+00:00 | Bike | TDSPHC-AGL----- | 3806.0 | 27.28606 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286295 | 1286295 | 1989-12-30 20:54:06+00:00 | Bike | TDSPHC-AGL----- | 3909.0 | 29.56148 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286296 | 1286296 | 1989-12-30 20:54:24+00:00 | Bike | TDSPHC-AGL----- | 3757.0 | 27.98974 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286297 | 1286297 | 1989-12-30 20:55:39+00:00 | Bike | TDSPHC-AGL----- | 3754.0 | 30.22496 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286298 | 1286298 | 1989-12-30 20:55:53+00:00 | Bike | TDSPHC-AGL----- | 3807.0 | 30.14142 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286299 | 1286299 | 1989-12-30 20:56:06+00:00 | Bike | TDSPHC-AGL----- | 3663.0 | 26.00233 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 630478 | 630478 | 1989-12-30 20:57:55+00:00 | Bike | TDSPHC-AGL----- | 3612.0 | 21.0348 | {060e8ebe-06f0-4f3c-b85f-7a83c2b2e935} |
| 1286300 | 1286300 | 1989-12-30 20:57:59+00:00 | Bike | TDSPHC-AGL----- | 3670.0 | 24.96767 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286301 | 1286301 | 1989-12-30 20:58:15+00:00 | Bike | TDSPHC-AGL----- | 3635.0 | 26.818 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 630479 | 630479 | 1989-12-30 20:59:09+00:00 | Bike | TDSPHC-AGL----- | 3644.0 | 23.07498 | {060e8ebe-06f0-4f3c-b85f-7a83c2b2e935} |
| 1286302 | 1286302 | 1989-12-30 21:03:16+00:00 | Bike | TDSPHC-AGL----- | 3402.0 | 30.34431 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286303 | 1286303 | 1989-12-30 21:05:18+00:00 | Bike | TDSPHC-AGL----- | 3258.0 | 23.96679 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286304 | 1286304 | 1989-12-30 21:05:19+00:00 | Bike | TDSPHC-AGL----- | 3122.0 | 33.47406 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286305 | 1286305 | 1989-12-30 21:06:11+00:00 | Bike | TDSPHC-AGL----- | 3140.0 | 31.26406 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286306 | 1286306 | 1989-12-30 21:09:14+00:00 | Bike | TDSPHC-AGL----- | 3047.0 | 22.12875 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286307 | 1286307 | 1989-12-30 21:12:34+00:00 | Bike | TDSPHC-AGL----- | 2693.0 | 21.66087 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286308 | 1286308 | 1989-12-30 21:12:40+00:00 | Bike | TDSPHC-AGL----- | 2743.0 | 31.64737 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286309 | 1286309 | 1989-12-30 21:12:45+00:00 | Bike | TDSPHC-AGL----- | 2835.0 | 16.58326 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1360847 | 1360847 | 1989-12-30 21:13:03+00:00 | Bike | TDSPHC-AGL----- | 6351.0 | 39.07181 | {1c9d5b29-4cfe-4294-a2e8-8f4f23a25149} |
| 1521044 | 1521044 | 1989-12-30 21:13:03+00:00 | Bike | TDSPHC-AGL----- | 6351.0 | 39.07181 | {4b213def-3979-4380-b5d2-617a9e269652} |
| 804085 | 804085 | 1989-12-30 21:14:07+00:00 | Bike | TDSPHC-AGL----- | 6340.0 | 41.87223 | {13910f63-08f9-4dff-84bf-3b5b4308554f} |
| 1286310 | 1286310 | 1989-12-30 21:14:35+00:00 | Bike | TDSPHC-AGL----- | 2675.0 | 14.13848 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 630480 | 630480 | 1989-12-30 21:15:26+00:00 | Bike | TDSPHC-AGL----- | 2644.0 | 25.42471 | {060e8ebe-06f0-4f3c-b85f-7a83c2b2e935} |
| 1286312 | 1286312 | 1989-12-30 21:16:39+00:00 | Bike | TDSPHC-AGL----- | 2515.0 | 21.81532 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286313 | 1286313 | 1989-12-30 21:16:48+00:00 | Bike | TDSPHC-AGL----- | 2523.0 | 19.1576 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286314 | 1286314 | 1989-12-30 21:17:16+00:00 | Bike | TDSPHC-AGL----- | 2545.0 | 19.04158 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286315 | 1286315 | 1989-12-30 21:17:59+00:00 | Bike | TDSPHC-AGL----- | 2493.0 | 19.12713 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286316 | 1286316 | 1989-12-30 21:18:20+00:00 | Bike | TDSPHC-AGL----- | 2481.0 | 18.94089 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286317 | 1286317 | 1989-12-30 21:18:37+00:00 | Bike | TDSPHC-AGL----- | 2441.0 | 18.90272 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286318 | 1286318 | 1989-12-30 21:18:39+00:00 | Bike | TDSPHC-AGL----- | 2463.0 | 19.1372 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286319 | 1286319 | 1989-12-30 21:19:18+00:00 | Bike | TDSPHC-AGL----- | 2412.0 | 19.13454 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286320 | 1286320 | 1989-12-30 21:19:37+00:00 | Bike | TDSPHC-AGL----- | 2421.0 | 19.13684 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 804086 | 804086 | 1989-12-30 21:20:42+00:00 | Bike | TDSPHC-AGL----- | 5942.0 | 33.09723 | {13910f63-08f9-4dff-84bf-3b5b4308554f} |
| 1639612 | 1639612 | 1989-12-30 21:21:00+00:00 | Bike | TDSPHC-AGL----- | 4435.0 | 40.15543 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 804087 | 804087 | 1989-12-30 21:21:30+00:00 | Bike | TDSPHC-AGL----- | 5883.0 | 37.7892 | {13910f63-08f9-4dff-84bf-3b5b4308554f} |
| 1286321 | 1286321 | 1989-12-30 21:21:33+00:00 | Bike | TDSPHC-AGL----- | 2217.0 | 21.92562 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286322 | 1286322 | 1989-12-30 21:21:57+00:00 | Bike | TDSPHC-AGL----- | 2272.0 | 20.80393 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286323 | 1286323 | 1989-12-30 21:22:12+00:00 | Bike | TDSPHC-AGL----- | 2268.0 | 14.5778 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286324 | 1286324 | 1989-12-30 21:22:23+00:00 | Bike | TDSPHC-AGL----- | 2258.0 | 14.48111 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286325 | 1286325 | 1989-12-30 21:22:25+00:00 | Bike | TDSPHC-AGL----- | 2245.0 | 12.02933 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286326 | 1286326 | 1989-12-30 21:23:29+00:00 | Bike | TDSPHC-AGL----- | 2127.0 | 21.81081 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286327 | 1286327 | 1989-12-30 21:23:36+00:00 | Bike | TDSPHC-AGL----- | 2160.0 | 14.39551 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286328 | 1286328 | 1989-12-30 21:23:50+00:00 | Bike | TDSPHC-AGL----- | 2139.0 | 12.88964 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1360848 | 1360848 | 1989-12-30 21:24:15+00:00 | Bike | TDSPHC-AGL----- | 5663.0 | 39.06426 | {1c9d5b29-4cfe-4294-a2e8-8f4f23a25149} |
| 1521045 | 1521045 | 1989-12-30 21:24:15+00:00 | Bike | TDSPHC-AGL----- | 5663.0 | 39.06426 | {4b213def-3979-4380-b5d2-617a9e269652} |
| 1639613 | 1639613 | 1989-12-30 21:24:15+00:00 | Bike | TDSPHC-AGL----- | 5728.0 | 58.95706 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286329 | 1286329 | 1989-12-30 21:24:53+00:00 | Bike | TDSPHC-AGL----- | 2086.0 | 10.70939 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 804088 | 804088 | 1989-12-30 21:25:41+00:00 | Bike | TDSPHC-AGL----- | 5658.0 | 28.12418 | {13910f63-08f9-4dff-84bf-3b5b4308554f} |
| 1286330 | 1286330 | 1989-12-30 21:26:04+00:00 | Bike | TDSPHC-AGL----- | 2036.0 | 11.20227 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286331 | 1286331 | 1989-12-30 21:26:10+00:00 | Bike | TDSPHC-AGL----- | 1865.0 | 12.86595 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286332 | 1286332 | 1989-12-30 21:26:18+00:00 | Bike | TDSPHC-AGL----- | 1925.0 | 17.08025 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1286333 | 1286333 | 1989-12-30 21:26:29+00:00 | Bike | TDSPHC-AGL----- | 1968.0 | 13.83798 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1639614 | 1639614 | 1989-12-30 21:26:30+00:00 | Bike | TDSPHC-AGL----- | 5610.0 | 58.78423 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286334 | 1286334 | 1989-12-30 21:26:37+00:00 | Bike | TDSPHC-AGL----- | 1980.0 | 18.9139 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1639615 | 1639615 | 1989-12-30 21:27:50+00:00 | Bike | TDSPHC-AGL----- | 5524.0 | 39.154 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286336 | 1286336 | 1989-12-30 21:28:11+00:00 | Bike | TDSPHC-AGL----- | 1836.0 | 9.73418 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1639616 | 1639616 | 1989-12-30 21:28:28+00:00 | Bike | TDSPHC-AGL----- | 5483.0 | 48.46424 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286337 | 1286337 | 1989-12-30 21:28:32+00:00 | Bike | TDSPHC-AGL----- | 1876.0 | 15.15779 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1639617 | 1639617 | 1989-12-30 21:28:33+00:00 | Bike | TDSPHC-AGL----- | 5484.0 | 59.02533 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286338 | 1286338 | 1989-12-30 21:28:42+00:00 | Bike | TDSPHC-AGL----- | 1876.0 | 17.3489 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1124274 | 1124274 | 1989-12-30 21:28:45+00:00 | Bike | TDSPHC-AGL----- | 5407.0 | 38.2987 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639618 | 1639618 | 1989-12-30 21:28:59+00:00 | Bike | TDSPHC-AGL----- | 5437.0 | 56.07667 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639619 | 1639619 | 1989-12-30 21:29:39+00:00 | Bike | TDSPHC-AGL----- | 5402.0 | 43.721 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639620 | 1639620 | 1989-12-30 21:29:53+00:00 | Bike | TDSPHC-AGL----- | 5390.0 | 52.02354 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286339 | 1286339 | 1989-12-30 21:30:34+00:00 | Bike | TDSPHC-AGL----- | 1746.0 | 16.02421 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 907613 | 907613 | 1989-12-30 21:31:02+00:00 | Bike | TDSPH--AGL----- | 5318.0 | 34.21738 | {5463acf0-a907-4923-91b1-2104d7118ed8} |
| 1639621 | 1639621 | 1989-12-30 21:31:25+00:00 | Bike | TDSPHC-AGL----- | 5298.0 | 49.50883 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 804089 | 804089 | 1989-12-30 21:31:55+00:00 | Bike | TDSPHC-AGL----- | 5268.0 | 26.43372 | {13910f63-08f9-4dff-84bf-3b5b4308554f} |
| 1639622 | 1639622 | 1989-12-30 21:33:18+00:00 | Bike | TDSPHC-AGL----- | 5180.0 | 53.78919 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639623 | 1639623 | 1989-12-30 21:33:28+00:00 | Bike | TDSPHC-AGL----- | 5127.0 | 55.30217 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639624 | 1639624 | 1989-12-30 21:33:29+00:00 | Bike | TDSPHC-AGL----- | 5181.0 | 53.66033 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639625 | 1639625 | 1989-12-30 21:34:21+00:00 | Bike | TDSPHC-AGL----- | 5118.0 | 52.10184 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639626 | 1639626 | 1989-12-30 21:34:22+00:00 | Bike | TDSPHC-AGL----- | 5122.0 | 45.86472 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 438890 | 438890 | 1989-12-30 21:34:36+00:00 | Bike | TDSPHC-AGL----- | 5114.0 | 50.4527 | {b5728df5-8b98-4857-b293-1a3a9e329f8c} |
| 1124275 | 1124275 | 1989-12-30 21:34:45+00:00 | Bike | TDSPHC-AGL----- | 4990.0 | 34.52978 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639627 | 1639627 | 1989-12-30 21:35:26+00:00 | Bike | TDSPHC-AGL----- | 4991.0 | 47.42812 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 533824 | 533824 | 1989-12-30 21:35:46+00:00 | Bike | TDSPHC-AGL----- | 5050.0 | 35.74035 | {c9bf99dd-68a2-41b3-acbd-433ea4773e20} |
| 696153 | 696153 | 1989-12-30 21:37:52+00:00 | Bike | TDSPHC-AGL----- | 4881.0 | 40.95314 | {6305af62-5eff-44fc-ab7e-ddd48511599d} |
| 1286340 | 1286340 | 1989-12-30 21:38:24+00:00 | Bike | TDSPHC-AGL----- | 1297.0 | 8.87195 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1124276 | 1124276 | 1989-12-30 21:38:30+00:00 | Bike | TDSPHC-AGL----- | 4808.0 | 36.93462 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639628 | 1639628 | 1989-12-30 21:39:31+00:00 | Bike | TDSPHC-AGL----- | 4815.0 | 47.74698 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
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");