rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by date
This data as json, CSV (advanced)
| Link | rowid | date ▼ | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 257505 | 257505 | 1989-12-30 14:09:28+00:00 | Bike | TDSP-C-AGL----- | 3024.0 | 34.56261 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257506 | 257506 | 1989-12-30 14:09:29+00:00 | Bike | TDSP-C-AGL----- | 3013.0 | 25.0392 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257507 | 257507 | 1989-12-30 14:09:32+00:00 | Bike | TDSP-C-AGL----- | 3003.0 | 26.94764 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257508 | 257508 | 1989-12-30 14:09:33+00:00 | Bike | TDSP-C-AGL----- | 3016.0 | 31.75818 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257509 | 257509 | 1989-12-30 14:09:48+00:00 | Bike | TDSP-C-AGL----- | 3011.0 | 31.64402 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257510 | 257510 | 1989-12-30 14:10:24+00:00 | Bike | TDSPHC-AGL----- | 2807.0 | 19.0635 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257511 | 257511 | 1989-12-30 14:10:52+00:00 | Bike | TDSP-C-AGL----- | 2892.0 | 24.05067 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257512 | 257512 | 1989-12-30 14:11:19+00:00 | Bike | TDSP-C-AGL----- | 2905.0 | 30.36292 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257513 | 257513 | 1989-12-30 14:11:51+00:00 | Bike | TDSP-C-AGL----- | 2826.0 | 15.38827 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257514 | 257514 | 1989-12-30 14:12:01+00:00 | Bike | TDSP-C-AGL----- | 2852.0 | 17.18048 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257515 | 257515 | 1989-12-30 14:12:29+00:00 | Bike | TDSP-C-AGL----- | 2829.0 | 19.4077 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257516 | 257516 | 1989-12-30 14:12:41+00:00 | Bike | TDSP-C-AGL----- | 2788.0 | 28.38729 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257517 | 257517 | 1989-12-30 14:12:44+00:00 | Bike | TDSP-C-AGL----- | 2802.0 | 16.08391 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257518 | 257518 | 1989-12-30 14:12:52+00:00 | Bike | TDSP-C-AGL----- | 2807.0 | 23.58166 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257519 | 257519 | 1989-12-30 14:13:00+00:00 | Bike | TDSP-C-AGL----- | 2811.0 | 21.17284 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257520 | 257520 | 1989-12-30 14:13:03+00:00 | Bike | TDSP-C-AGL----- | 2746.0 | 27.46112 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257521 | 257521 | 1989-12-30 14:13:52+00:00 | Bike | TDSP-C-AGL----- | 2708.0 | 26.76066 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257522 | 257522 | 1989-12-30 14:13:57+00:00 | Bike | TDSP-C-AGL----- | 2720.0 | 25.46083 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257523 | 257523 | 1989-12-30 14:14:02+00:00 | Bike | TDSP-C-AGL----- | 2746.0 | 15.37046 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257524 | 257524 | 1989-12-30 14:14:05+00:00 | Bike | TDSP-C-AGL----- | 2739.0 | 21.4076 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257525 | 257525 | 1989-12-30 14:14:09+00:00 | Bike | TDSP-C-AGL----- | 2739.0 | 27.60457 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257526 | 257526 | 1989-12-30 14:14:17+00:00 | Bike | TDSP-C-AGL----- | 2712.0 | 19.57714 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257527 | 257527 | 1989-12-30 14:14:21+00:00 | Bike | TDSP-C-AGL----- | 2712.0 | 27.40208 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257528 | 257528 | 1989-12-30 14:14:25+00:00 | Bike | TDSP-C-AGL----- | 2727.0 | 24.52498 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257529 | 257529 | 1989-12-30 14:14:37+00:00 | Bike | TDSP-C-AGL----- | 2709.0 | 27.6413 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257530 | 257530 | 1989-12-30 14:14:48+00:00 | Bike | TDSP-C-AGL----- | 2703.0 | 27.07185 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257531 | 257531 | 1989-12-30 14:14:58+00:00 | Bike | TDSP-C-AGL----- | 2700.0 | 21.89805 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257532 | 257532 | 1989-12-30 14:15:15+00:00 | Bike | TDSP-C-AGL----- | 2683.0 | 27.38567 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257533 | 257533 | 1989-12-30 14:15:22+00:00 | Bike | TDSP-C-AGL----- | 2673.0 | 20.52819 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257534 | 257534 | 1989-12-30 14:16:15+00:00 | Bike | TDSP-C-AGL----- | 2623.0 | 20.4046 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257535 | 257535 | 1989-12-30 14:17:03+00:00 | Bike | TDSP-C-AGL----- | 2576.0 | 20.53936 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257536 | 257536 | 1989-12-30 14:17:21+00:00 | Bike | TDSP-C-AGL----- | 2494.0 | 22.13296 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257537 | 257537 | 1989-12-30 14:17:38+00:00 | Bike | TDSP-C-AGL----- | 2543.0 | 17.059 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257538 | 257538 | 1989-12-30 14:17:43+00:00 | Bike | TDSP-C-AGL----- | 2535.0 | 26.07096 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257539 | 257539 | 1989-12-30 14:18:26+00:00 | Bike | TDSP-C-AGL----- | 2403.0 | 14.86997 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257540 | 257540 | 1989-12-30 14:18:33+00:00 | Bike | TDSP-C-AGL----- | 2465.0 | 28.17736 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257541 | 257541 | 1989-12-30 14:18:47+00:00 | Bike | TDSP-C-AGL----- | 2420.0 | 23.86507 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257542 | 257542 | 1989-12-30 14:19:23+00:00 | Bike | TDSP-C-AGL----- | 2431.0 | 25.7248 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257543 | 257543 | 1989-12-30 14:19:29+00:00 | Bike | TDSP-C-AGL----- | 2370.0 | 28.10583 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257544 | 257544 | 1989-12-30 14:19:37+00:00 | Bike | TDSP-C-AGL----- | 2416.0 | 15.92053 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257545 | 257545 | 1989-12-30 14:19:54+00:00 | Bike | TDSP-C-AGL----- | 2135.0 | 20.72999 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257546 | 257546 | 1989-12-30 14:19:56+00:00 | Bike | TDSP-C-AGL----- | 1524.0 | 17.7148 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257547 | 257547 | 1989-12-30 14:20:04+00:00 | Bike | TDSP-C-AGL----- | 2388.0 | 16.20638 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257548 | 257548 | 1989-12-30 14:20:49+00:00 | Bike | TDSP-C-AGL----- | 2299.0 | 21.75136 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257549 | 257549 | 1989-12-30 14:20:51+00:00 | Bike | TDSP-C-AGL----- | 2349.0 | 13.86292 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257550 | 257550 | 1989-12-30 14:21:09+00:00 | Bike | TDSP-C-AGL----- | 2330.0 | 24.17566 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257551 | 257551 | 1989-12-30 14:21:35+00:00 | Bike | TDSP-C-AGL----- | 2305.0 | 28.26861 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257552 | 257552 | 1989-12-30 14:21:53+00:00 | Bike | TDSPHC-AGL----- | 2287.0 | 21.34451 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257553 | 257553 | 1989-12-30 14:21:54+00:00 | Bike | TDSP-C-AGL----- | 2276.0 | 15.57912 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257554 | 257554 | 1989-12-30 14:21:57+00:00 | Bike | TDSP-C-AGL----- | 2233.0 | 22.37917 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257555 | 257555 | 1989-12-30 14:22:13+00:00 | Bike | TDSP-C-AGL----- | 2232.0 | 21.28681 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257556 | 257556 | 1989-12-30 14:22:19+00:00 | Bike | TDSP-C-AGL----- | 2223.0 | 15.18788 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257557 | 257557 | 1989-12-30 14:22:28+00:00 | Bike | TDSP-C-AGL----- | 2226.0 | 22.1871 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257558 | 257558 | 1989-12-30 14:22:33+00:00 | Bike | TDSP-C-AGL----- | 2230.0 | 23.57418 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257559 | 257559 | 1989-12-30 14:22:40+00:00 | Bike | TDSP-C-AGL----- | 2223.0 | 15.2634 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257560 | 257560 | 1989-12-30 14:22:50+00:00 | Bike | TDSP-C-AGL----- | 2229.0 | 16.6133 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257561 | 257561 | 1989-12-30 14:23:26+00:00 | Bike | TDSP-C-AGL----- | 2119.0 | 12.45442 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257562 | 257562 | 1989-12-30 14:23:36+00:00 | Bike | TDSP-C-AGL----- | 2149.0 | 21.45793 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257563 | 257563 | 1989-12-30 14:23:49+00:00 | Bike | TDSP-C-AGL----- | 2170.0 | 25.33253 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257564 | 257564 | 1989-12-30 14:24:00+00:00 | Bike | TDSP-C-AGL----- | 2092.0 | 19.04046 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257565 | 257565 | 1989-12-30 14:24:29+00:00 | Bike | TDSP-C-AGL----- | 2116.0 | 13.85557 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257566 | 257566 | 1989-12-30 14:24:30+00:00 | Bike | TDSP-C-AGL----- | 1806.0 | 19.16984 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257567 | 257567 | 1989-12-30 14:24:47+00:00 | Bike | TDSP-C-AGL----- | 2051.0 | 13.73679 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257568 | 257568 | 1989-12-30 14:24:52+00:00 | Bike | TDSP-C-AGL----- | 2107.0 | 23.52792 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257569 | 257569 | 1989-12-30 14:24:54+00:00 | Bike | TDSP-C-AGL----- | 2105.0 | 17.05223 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257570 | 257570 | 1989-12-30 14:24:55+00:00 | Bike | TDSP-C-AGL----- | 2105.0 | 14.41662 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257571 | 257571 | 1989-12-30 14:25:06+00:00 | Bike | TDSP-C-AGL----- | 2078.0 | 13.3895 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257572 | 257572 | 1989-12-30 14:25:17+00:00 | Bike | TDSP-C-AGL----- | 2083.0 | 15.69515 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257573 | 257573 | 1989-12-30 14:25:54+00:00 | Bike | TDSP-C-AGL----- | 2036.0 | 20.87011 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257574 | 257574 | 1989-12-30 14:26:55+00:00 | Bike | TDSP-C-AGL----- | 1975.0 | 13.14192 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257575 | 257575 | 1989-12-30 14:27:02+00:00 | Bike | TDSP-C-AGL----- | 1944.0 | 9.15429 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257576 | 257576 | 1989-12-30 14:27:29+00:00 | Bike | TDSP-C-AGL----- | 1802.0 | 21.62139 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257577 | 257577 | 1989-12-30 14:27:32+00:00 | Bike | TDSP-C-AGL----- | 1947.0 | 20.11258 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257578 | 257578 | 1989-12-30 14:28:14+00:00 | Bike | TDSP-C-AGL----- | 1875.0 | 21.49177 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257579 | 257579 | 1989-12-30 14:28:22+00:00 | Bike | TDSP-C-AGL----- | 1898.0 | 22.40807 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257580 | 257580 | 1989-12-30 14:28:24+00:00 | Bike | TDSP-C-AGL----- | 1867.0 | 17.60725 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257581 | 257581 | 1989-12-30 14:28:38+00:00 | Bike | TDSPHC-AGL----- | 1877.0 | 20.64966 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257582 | 257582 | 1989-12-30 14:29:04+00:00 | Bike | TDSP-C-AGL----- | 1851.0 | 18.68624 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257583 | 257583 | 1989-12-30 14:29:14+00:00 | Bike | TDSP-C-AGL----- | 1801.0 | 18.30361 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257584 | 257584 | 1989-12-30 14:29:19+00:00 | Bike | TDSP-C-AGL----- | 1834.0 | 19.77397 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257585 | 257585 | 1989-12-30 14:29:22+00:00 | Bike | TDSP-C-AGL----- | 1837.0 | 20.34828 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257586 | 257586 | 1989-12-30 14:29:32+00:00 | Bike | TDSP-C-AGL----- | 1828.0 | 20.1599 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257587 | 257587 | 1989-12-30 14:29:33+00:00 | Bike | TDSP-C-AGL----- | 1783.0 | 16.28157 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257588 | 257588 | 1989-12-30 14:29:39+00:00 | Bike | TDSP-C-AGL----- | 1793.0 | 19.47473 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257589 | 257589 | 1989-12-30 14:29:44+00:00 | Bike | TDSP-C-AGL----- | 1815.0 | 21.17682 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257590 | 257590 | 1989-12-30 14:29:46+00:00 | Bike | TDSP-C-AGL----- | 1815.0 | 18.16619 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257591 | 257591 | 1989-12-30 14:29:47+00:00 | Bike | TDSP-C-AGL----- | 1812.0 | 19.44385 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257592 | 257592 | 1989-12-30 14:29:50+00:00 | Bike | TDSP-C-AGL----- | 1804.0 | 18.47991 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257593 | 257593 | 1989-12-30 14:29:51+00:00 | Bike | TDSP-C-AGL----- | 1808.0 | 13.4959 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257594 | 257594 | 1989-12-30 14:30:16+00:00 | Bike | TDSP-C-AGL----- | 1785.0 | 22.96176 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257595 | 257595 | 1989-12-30 14:30:20+00:00 | Bike | TDSP-C-AGL----- | 1780.0 | 18.88721 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257596 | 257596 | 1989-12-30 14:30:22+00:00 | Bike | TDSP-C-AGL----- | 1769.0 | 20.4876 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257597 | 257597 | 1989-12-30 14:31:41+00:00 | Bike | TDSP-C-AGL----- | 1681.0 | 15.19331 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257598 | 257598 | 1989-12-30 14:32:42+00:00 | Bike | TDSP-C-AGL----- | 1638.0 | 18.21067 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257599 | 257599 | 1989-12-30 14:32:57+00:00 | Bike | TDSP-C-AGL----- | 1614.0 | 19.5709 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257600 | 257600 | 1989-12-30 14:33:05+00:00 | Bike | TDSP-C-AGL----- | 1608.0 | 17.81978 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257601 | 257601 | 1989-12-30 14:33:13+00:00 | Bike | TDSP-C-AGL----- | 1519.0 | 14.80333 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257602 | 257602 | 1989-12-30 14:33:29+00:00 | Bike | TDSP-C-AGL----- | 1590.0 | 17.86964 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257603 | 257603 | 1989-12-30 14:33:30+00:00 | Bike | TDSP-C-AGL----- | 1575.0 | 16.13509 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257604 | 257604 | 1989-12-30 14:33:38+00:00 | Bike | TDSP-C-AGL----- | 1572.0 | 16.91083 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
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");