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 |
|---|---|---|---|---|---|---|---|
| 438891 | 438891 | 1989-12-30 21:41:31+00:00 | Bike | TDSPHC-AGL----- | 4677.0 | 42.2803 | {b5728df5-8b98-4857-b293-1a3a9e329f8c} |
| 1124277 | 1124277 | 1989-12-30 21:42:12+00:00 | Bike | TDSPHC-AGL----- | 4629.0 | 37.49631 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 438892 | 438892 | 1989-12-30 21:43:00+00:00 | Bike | TDSPHC-AGL----- | 4504.0 | 40.92139 | {b5728df5-8b98-4857-b293-1a3a9e329f8c} |
| 1639630 | 1639630 | 1989-12-30 21:43:37+00:00 | Bike | TDSPHC-AGL----- | 4584.0 | 32.18711 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124278 | 1124278 | 1989-12-30 21:43:50+00:00 | Bike | TDSPHC-AGL----- | 4541.0 | 31.77632 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1286341 | 1286341 | 1989-12-30 21:44:19+00:00 | Bike | TDSPHC-AGL----- | 918.0 | 5.04648 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 438893 | 438893 | 1989-12-30 21:44:22+00:00 | Bike | TDSPHC-AGL----- | 4329.0 | 47.28742 | {b5728df5-8b98-4857-b293-1a3a9e329f8c} |
| 1639631 | 1639631 | 1989-12-30 21:44:23+00:00 | Bike | TDSPHC-AGL----- | 4522.0 | 42.19262 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286342 | 1286342 | 1989-12-30 21:44:29+00:00 | Bike | TDSPHC-AGL----- | 931.0 | 7.76628 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1639632 | 1639632 | 1989-12-30 21:44:45+00:00 | Bike | TDSPHC-AGL----- | 4510.0 | 38.99068 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1676324 | 1676324 | 1989-12-30 21:46:07+00:00 | Bike | TDSPHC-AGL----- | 4433.0 | 34.44223 | {1119d36c-f303-4afd-8334-3cec111e75a2} |
| 1639633 | 1639633 | 1989-12-30 21:47:13+00:00 | Bike | TDSPHC-AGL----- | 3691.0 | 27.62337 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124279 | 1124279 | 1989-12-30 21:48:56+00:00 | Bike | TDSPHC-AGL----- | 4216.0 | 35.52954 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1124280 | 1124280 | 1989-12-30 21:49:17+00:00 | Bike | TDSPHC-AGL----- | 4217.0 | 28.64344 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639634 | 1639634 | 1989-12-30 21:49:19+00:00 | Bike | TDSPHC-AGL----- | 4232.0 | 41.96566 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639635 | 1639635 | 1989-12-30 21:49:32+00:00 | Bike | TDSPHC-AGL----- | 4219.0 | 36.0921 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639636 | 1639636 | 1989-12-30 21:49:52+00:00 | Bike | TDSPHC-AGL----- | 4208.0 | 30.14483 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639637 | 1639637 | 1989-12-30 21:51:29+00:00 | Bike | TDSPHC-AGL----- | 4045.0 | 41.16926 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639638 | 1639638 | 1989-12-30 21:51:37+00:00 | Bike | TDSPHC-AGL----- | 3964.0 | 44.95897 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124281 | 1124281 | 1989-12-30 21:52:04+00:00 | Bike | TDSPHC-AGL----- | 4030.0 | 29.34436 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639639 | 1639639 | 1989-12-30 21:52:09+00:00 | Bike | TDSPHC-AGL----- | 4048.0 | 25.85195 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639640 | 1639640 | 1989-12-30 21:52:21+00:00 | Bike | TDSPHC-AGL----- | 4038.0 | 37.30078 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1286343 | 1286343 | 1989-12-30 21:53:02+00:00 | Bike | TDSPHC-AGL----- | 403.0 | 2.16982 | {bebb02a2-a7e9-4801-b862-78ea822ef5f2} |
| 1124282 | 1124282 | 1989-12-30 21:53:37+00:00 | Bike | TDSPHC-AGL----- | 3919.0 | 31.24421 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639641 | 1639641 | 1989-12-30 21:53:51+00:00 | Bike | TDSPHC-AGL----- | 3889.0 | 41.79434 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124283 | 1124283 | 1989-12-30 21:53:58+00:00 | Bike | TDSPHC-AGL----- | 3909.0 | 29.60817 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639642 | 1639642 | 1989-12-30 21:54:01+00:00 | Bike | TDSPHC-AGL----- | 3679.0 | 36.13125 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124284 | 1124284 | 1989-12-30 21:54:49+00:00 | Bike | TDSPHC-AGL----- | 3871.0 | 30.71858 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639643 | 1639643 | 1989-12-30 21:54:50+00:00 | Bike | TDSPHC-AGL----- | 3882.0 | 27.76598 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639644 | 1639644 | 1989-12-30 21:55:11+00:00 | Bike | TDSPHC-AGL----- | 3877.0 | 33.88212 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124285 | 1124285 | 1989-12-30 21:55:15+00:00 | Bike | TDSPHC-AGL----- | 3855.0 | 30.40435 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639645 | 1639645 | 1989-12-30 21:55:16+00:00 | Bike | TDSPHC-AGL----- | 3832.0 | 41.98701 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124286 | 1124286 | 1989-12-30 21:55:20+00:00 | Bike | TDSPHC-AGL----- | 3849.0 | 30.84569 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639646 | 1639646 | 1989-12-30 21:55:20+00:00 | Bike | TDSPHC-AGL----- | 3858.0 | 32.30128 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639647 | 1639647 | 1989-12-30 21:55:32+00:00 | Bike | TDSPHC-AGL----- | 3740.0 | 40.16114 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639648 | 1639648 | 1989-12-30 21:56:35+00:00 | Bike | TDSPHC-AGL----- | 3767.0 | 41.60679 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639649 | 1639649 | 1989-12-30 21:56:43+00:00 | Bike | TDSPHC-AGL----- | 3703.0 | 36.63318 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124287 | 1124287 | 1989-12-30 21:57:04+00:00 | Bike | TDSPHC-AGL----- | 3729.0 | 29.13642 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639650 | 1639650 | 1989-12-30 21:57:17+00:00 | Bike | TDSPHC-AGL----- | 3751.0 | 32.46754 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639651 | 1639651 | 1989-12-30 21:57:22+00:00 | Bike | TDSPHC-AGL----- | 3690.0 | 25.10304 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1676325 | 1676325 | 1989-12-30 21:57:29+00:00 | Bike | TDSPHC-AGL----- | 3739.0 | 32.86804 | {1119d36c-f303-4afd-8334-3cec111e75a2} |
| 1639652 | 1639652 | 1989-12-30 21:57:34+00:00 | Bike | TDSPHC-AGL----- | 3545.0 | 23.58 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 696154 | 696154 | 1989-12-30 21:57:43+00:00 | Bike | TDSPHC-AGL----- | 3623.0 | 36.54092 | {6305af62-5eff-44fc-ab7e-ddd48511599d} |
| 1639653 | 1639653 | 1989-12-30 21:58:01+00:00 | Bike | TDSPHC-AGL----- | 3704.0 | 27.4451 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124288 | 1124288 | 1989-12-30 21:58:02+00:00 | Bike | TDSPHC-AGL----- | 3620.0 | 28.43649 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639654 | 1639654 | 1989-12-30 21:58:16+00:00 | Bike | TDSPHC-AGL----- | 3661.0 | 26.0442 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124289 | 1124289 | 1989-12-30 21:58:27+00:00 | Bike | TDSPHC-AGL----- | 3620.0 | 30.0513 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 438894 | 438894 | 1989-12-30 21:58:52+00:00 | Bike | TDSPHC-AGL----- | 3638.0 | 42.31616 | {b5728df5-8b98-4857-b293-1a3a9e329f8c} |
| 1278346 | 1278346 | 1989-12-30 21:58:52+00:00 | Bike | TDSPHC-AGL----- | 3621.0 | 36.81526 | {6e9c7d45-3eca-4be7-a114-404459d8e956} |
| 1639655 | 1639655 | 1989-12-30 21:58:58+00:00 | Bike | TDSPHC-AGL----- | 3628.0 | 35.44769 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 438895 | 438895 | 1989-12-30 21:59:00+00:00 | Bike | TDSPHC-AGL----- | 3611.0 | 36.04685 | {b5728df5-8b98-4857-b293-1a3a9e329f8c} |
| 1639656 | 1639656 | 1989-12-30 21:59:02+00:00 | Bike | TDSPHC-AGL----- | 3615.0 | 29.90737 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124290 | 1124290 | 1989-12-30 21:59:07+00:00 | Bike | TDSPHC-AGL----- | 3609.0 | 15.66005 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639657 | 1639657 | 1989-12-30 21:59:16+00:00 | Bike | TDSPHC-AGL----- | 3632.0 | 32.62186 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639658 | 1639658 | 1989-12-30 21:59:23+00:00 | Bike | TDSPHC-AGL----- | 3617.0 | 35.22997 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639659 | 1639659 | 1989-12-30 21:59:24+00:00 | Bike | TDSPHC-AGL----- | 3619.0 | 35.49221 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639660 | 1639660 | 1989-12-30 21:59:30+00:00 | Bike | TDSPHC-AGL----- | 3619.0 | 29.2213 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639661 | 1639661 | 1989-12-30 21:59:31+00:00 | Bike | TDSPHC-AGL----- | 3616.0 | 36.77892 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1676326 | 1676326 | 1989-12-30 21:59:32+00:00 | Bike | TDSPHC-AGL----- | 3609.0 | 28.69921 | {1119d36c-f303-4afd-8334-3cec111e75a2} |
| 1639662 | 1639662 | 1989-12-30 21:59:34+00:00 | Bike | TDSPHC-AGL----- | 3614.0 | 36.98329 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639663 | 1639663 | 1989-12-30 21:59:35+00:00 | Bike | TDSPHC-AGL----- | 3546.0 | 34.83215 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639664 | 1639664 | 1989-12-30 21:59:54+00:00 | Bike | TDSPHC-AGL----- | 3592.0 | 39.2033 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639665 | 1639665 | 1989-12-30 21:59:57+00:00 | Bike | TDSPHC-AGL----- | 3422.0 | 33.47951 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639666 | 1639666 | 1989-12-30 22:00:52+00:00 | Bike | TDSPHC-AGL----- | 3499.0 | 32.0792 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639667 | 1639667 | 1989-12-30 22:00:54+00:00 | Bike | TDSPHC-AGL----- | 3525.0 | 31.54917 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124291 | 1124291 | 1989-12-30 22:01:01+00:00 | Bike | TDSPHC-AGL----- | 3489.0 | 25.35269 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1124292 | 1124292 | 1989-12-30 22:01:09+00:00 | Bike | TDSPHC-AGL----- | 3491.0 | 23.0526 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639668 | 1639668 | 1989-12-30 22:01:09+00:00 | Bike | TDSPHC-AGL----- | 3502.0 | 34.03986 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124293 | 1124293 | 1989-12-30 22:01:18+00:00 | Bike | TDSPHC-AGL----- | 3493.0 | 25.64753 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639669 | 1639669 | 1989-12-30 22:01:25+00:00 | Bike | TDSPHC-AGL----- | 3498.0 | 34.37963 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639670 | 1639670 | 1989-12-30 22:01:56+00:00 | Bike | TDSPHC-AGL----- | 2836.0 | 20.12126 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639671 | 1639671 | 1989-12-30 22:02:23+00:00 | Bike | TDSPHC-AGL----- | 3439.0 | 31.0854 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639672 | 1639672 | 1989-12-30 22:03:26+00:00 | Bike | TDSPHC-AGL----- | 3305.0 | 38.4422 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639673 | 1639673 | 1989-12-30 22:03:28+00:00 | Bike | TDSPHC-AGL----- | 3310.0 | 31.14332 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124294 | 1124294 | 1989-12-30 22:03:58+00:00 | Bike | TDSPHC-AGL----- | 3310.0 | 22.49177 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1124295 | 1124295 | 1989-12-30 22:04:00+00:00 | Bike | TDSPHC-AGL----- | 3310.0 | 22.36961 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1676327 | 1676327 | 1989-12-30 22:04:29+00:00 | Bike | TDSPHC-AGL----- | 3302.0 | 25.86111 | {1119d36c-f303-4afd-8334-3cec111e75a2} |
| 1639674 | 1639674 | 1989-12-30 22:04:34+00:00 | Bike | TDSPHC-AGL----- | 3304.0 | 33.50031 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639675 | 1639675 | 1989-12-30 22:04:41+00:00 | Bike | TDSPHC-AGL----- | 3308.0 | 29.05071 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1676328 | 1676328 | 1989-12-30 22:04:44+00:00 | Bike | TDSPHC-AGL----- | 3304.0 | 28.3879 | {1119d36c-f303-4afd-8334-3cec111e75a2} |
| 1639676 | 1639676 | 1989-12-30 22:04:53+00:00 | Bike | TDSPHC-AGL----- | 3261.0 | 38.32195 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639677 | 1639677 | 1989-12-30 22:05:02+00:00 | Bike | TDSPHC-AGL----- | 3274.0 | 22.68405 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639678 | 1639678 | 1989-12-30 22:05:09+00:00 | Bike | TDSPHC-AGL----- | 3261.0 | 32.2799 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124296 | 1124296 | 1989-12-30 22:05:10+00:00 | Bike | TDSPHC-AGL----- | 3249.0 | 22.23078 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639679 | 1639679 | 1989-12-30 22:05:16+00:00 | Bike | TDSPHC-AGL----- | 3209.0 | 23.05969 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639680 | 1639680 | 1989-12-30 22:05:40+00:00 | Bike | TDSPHC-AGL----- | 3251.0 | 28.74966 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639681 | 1639681 | 1989-12-30 22:05:47+00:00 | Bike | TDSPHC-AGL----- | 3230.0 | 31.11875 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639682 | 1639682 | 1989-12-30 22:06:00+00:00 | Bike | TDSPHC-AGL----- | 1898.0 | 18.91405 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639683 | 1639683 | 1989-12-30 22:06:06+00:00 | Bike | TDSPHC-AGL----- | 3075.0 | 30.89149 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 438896 | 438896 | 1989-12-30 22:06:09+00:00 | Bike | TDSPHC-AGL----- | 3226.0 | 25.58507 | {b5728df5-8b98-4857-b293-1a3a9e329f8c} |
| 1639684 | 1639684 | 1989-12-30 22:06:09+00:00 | Bike | TDSPHC-AGL----- | 3152.0 | 30.45483 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 533825 | 533825 | 1989-12-30 22:06:11+00:00 | Bike | TDSPHC-AGL----- | 3229.0 | 20.27048 | {c9bf99dd-68a2-41b3-acbd-433ea4773e20} |
| 1639685 | 1639685 | 1989-12-30 22:06:26+00:00 | Bike | TDSPHC-AGL----- | 3176.0 | 32.29488 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639686 | 1639686 | 1989-12-30 22:06:58+00:00 | Bike | TDSPHC-AGL----- | 3153.0 | 27.30368 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639687 | 1639687 | 1989-12-30 22:07:21+00:00 | Bike | TDSPHC-AGL----- | 3153.0 | 30.69179 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639688 | 1639688 | 1989-12-30 22:07:28+00:00 | Bike | TDSPHC-AGL----- | 3134.0 | 39.49935 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639689 | 1639689 | 1989-12-30 22:08:23+00:00 | Bike | TDSPHC-AGL----- | 2948.0 | 34.01049 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1639690 | 1639690 | 1989-12-30 22:08:26+00:00 | Bike | TDSPHC-AGL----- | 3018.0 | 27.06581 | {18979252-0458-4ea3-a750-dc3ff28f8cda} |
| 1124297 | 1124297 | 1989-12-30 22:08:33+00:00 | Bike | TDSPHC-AGL----- | 3010.0 | 22.63529 | {aa00f192-c83b-4df7-b6b5-fd225c80fd83} |
| 1639691 | 1639691 | 1989-12-30 22:08:38+00:00 | Bike | TDSPHC-AGL----- | 3032.0 | 28.31251 | {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");