rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by data
This data as json, CSV (advanced)
| Link | rowid | date | sport | data ▼ | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1292299 | 1292299 | 2018-09-02 16:11:27+00:00 | Bike | -DSP---AGL----- | 1.0 | 10.9911 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1894626 | 1894626 | 2018-08-10 00:46:10+00:00 | Bike | -DSP---AGL----- | 1.0 | 11.7223 | {dabde884-825f-4257-bce2-feb184be5f4f} |
| 2223179 | 2223179 | 2017-08-07 18:31:12+00:00 | Ride | -DSP---AGL----- | 1.0 | 3.9559 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223200 | 2223200 | 2017-10-02 06:54:15+00:00 | Ride | -DSP---AGL----- | 1.0 | 32.2759 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223202 | 2223202 | 2017-11-14 08:52:42+00:00 | Ride | -DSP---AGL----- | 1.0 | 32.1062 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223203 | 2223203 | 2017-11-14 16:57:00+00:00 | Ride | -DSP---AGL----- | 1.0 | 25.2277 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223206 | 2223206 | 2017-11-23 18:14:12+00:00 | Ride | -DSP---AGL----- | 1.0 | 24.9922 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223215 | 2223215 | 2018-01-08 16:31:32+00:00 | Bike | -DSP---AGL----- | 1.0 | 24.1706 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223266 | 2223266 | 2018-04-20 16:13:28+00:00 | Bike | -DSP---AGL----- | 1.0 | 25.2632 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223277 | 2223277 | 2018-05-09 07:05:07+00:00 | Bike | -DSP---AGL----- | 1.0 | 42.6901 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223278 | 2223278 | 2018-05-09 15:08:24+00:00 | Bike | -DSP---AGL----- | 1.0 | 31.5566 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223287 | 2223287 | 2018-05-31 07:15:22+00:00 | Bike | -DSP---AGL----- | 1.0 | 42.9758 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223288 | 2223288 | 2018-05-31 15:40:48+00:00 | Bike | -DSP---AGL----- | 1.0 | 25.1238 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223300 | 2223300 | 2018-06-19 17:05:22+00:00 | Bike | -DSP---AGL----- | 1.0 | 24.7877 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223301 | 2223301 | 2018-06-20 08:21:05+00:00 | Bike | -DSP---AGL----- | 1.0 | 10.4541 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223304 | 2223304 | 2018-06-22 13:09:29+00:00 | Bike | -DSP---AGL----- | 1.0 | 2.43238 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223308 | 2223308 | 2018-06-26 08:05:20+00:00 | Bike | -DSP---AGL----- | 1.0 | 32.2143 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223309 | 2223309 | 2018-07-09 09:23:31+00:00 | Bike | -DSP---AGL----- | 1.0 | 14.8529 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223319 | 2223319 | 2018-08-02 14:02:13+00:00 | Bike | -DSP---AGL----- | 1.0 | 1.8019 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223327 | 2223327 | 2018-08-08 08:42:52+00:00 | Bike | -DSP---AGL----- | 1.0 | 32.1476 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223337 | 2223337 | 2018-10-19 12:31:02+00:00 | Bike | -DSP---AGL----- | 1.0 | 27.8246 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223388 | 2223388 | 2019-02-13 17:34:09+00:00 | Bike | -DSP---AGL----- | 1.0 | 25.4492 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223393 | 2223393 | 2019-02-20 07:43:31+00:00 | Bike | -DSP---AGL----- | 1.0 | 40.8614 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223400 | 2223400 | 2019-02-26 08:08:52+00:00 | Bike | -DSP---AGL----- | 1.0 | 28.2253 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 1507791 | 1507791 | 2017-10-30 10:10:00+00:00 | Bike | -DSP-C-AGL-EV-- | 1.0 | 14.74408 | {2fef6519-05c8-4a53-b058-869226cf7bdc} |
| 956832 | 956832 | 2018-11-25 20:58:47+00:00 | Bike | -DSPH---------- | 1.0 | 15.80984 | {fa183526-3dda-49fa-92a8-5b12f7c79b08} |
| 1748666 | 1748666 | 2018-03-06 17:10:20+00:00 | Bike | -DSPH---------- | 1.0 | 3.52125 | {8b359616-b732-44f8-b9a3-c0a6d92b933c} |
| 2223061 | 2223061 | 2016-12-29 16:58:43+00:00 | Ride | -DSPH---------- | 1.0 | 26.8022 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223208 | 2223208 | 2017-12-29 12:16:17+00:00 | Bike | -DSPH---------- | 1.0 | 27.106 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223209 | 2223209 | 2017-12-31 15:41:26+00:00 | Bike | -DSPH---------- | 1.0 | 4.54043 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223316 | 2223316 | 2018-07-19 09:18:55+00:00 | Bike | -DSPH---------- | 1.0 | 15.0715 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223350 | 2223350 | 2019-01-07 07:52:54+00:00 | Bike | -DSPH---------- | 1.0 | 7.28274 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223351 | 2223351 | 2019-01-07 08:10:37+00:00 | Bike | -DSPH---------- | 1.0 | 24.2955 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223361 | 2223361 | 2019-01-25 15:50:09+00:00 | Bike | -DSPH---------- | 1.0 | 23.3568 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223364 | 2223364 | 2019-02-01 16:46:04+00:00 | Bike | -DSPH---------- | 1.0 | 47.0336 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223366 | 2223366 | 2019-02-02 18:22:21+00:00 | Bike | -DSPH---------- | 1.0 | 2.0298 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223368 | 2223368 | 2019-02-03 15:00:03+00:00 | Bike | -DSPH---------- | 1.0 | 5.28604 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223370 | 2223370 | 2019-02-03 21:30:34+00:00 | Bike | -DSPH---------- | 1.0 | 1.10282 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223371 | 2223371 | 2019-02-04 18:06:58+00:00 | Bike | -DSPH---------- | 1.0 | 12.978 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223373 | 2223373 | 2019-02-06 21:48:45+00:00 | Bike | -DSPH---------- | 1.0 | 2.20491 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223374 | 2223374 | 2019-02-07 12:39:31+00:00 | Bike | -DSPH---------- | 1.0 | 5.26968 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223376 | 2223376 | 2019-02-07 13:59:21+00:00 | Bike | -DSPH---------- | 1.0 | 2.51902 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223377 | 2223377 | 2019-02-08 14:21:19+00:00 | Bike | -DSPH---------- | 1.0 | 2.01306 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223379 | 2223379 | 2019-02-08 15:19:44+00:00 | Bike | -DSPH---------- | 1.0 | 0.4052 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223380 | 2223380 | 2019-02-10 08:43:24+00:00 | Bike | -DSPH---------- | 1.0 | 1.515 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223381 | 2223381 | 2019-02-10 08:46:43+00:00 | Bike | -DSPH---------- | 1.0 | 26.663 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223382 | 2223382 | 2019-02-10 09:42:51+00:00 | Bike | -DSPH---------- | 1.0 | 4.21835 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223383 | 2223383 | 2019-02-11 08:10:23+00:00 | Bike | -DSPH---------- | 1.0 | 25.367 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223384 | 2223384 | 2019-02-11 09:35:36+00:00 | Bike | -DSPH---------- | 1.0 | 1.03337 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223386 | 2223386 | 2019-02-11 10:38:12+00:00 | Bike | -DSPH---------- | 1.0 | 3.2375 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2486707 | 2486707 | 2018-06-25 09:07:35+00:00 | Bike | -DSPH---------- | 1.0 | 3.00253 | {70a04cc3-c23e-4247-bf51-15f62957126e} |
| 956819 | 956819 | 2018-11-08 16:15:22+00:00 | Bike | -DSPH---G------ | 1.0 | 17.6692 | {fa183526-3dda-49fa-92a8-5b12f7c79b08} |
| 956824 | 956824 | 2018-11-16 19:15:21+00:00 | Bike | -DSPH---G------ | 1.0 | 16.1039 | {fa183526-3dda-49fa-92a8-5b12f7c79b08} |
| 2241298 | 2241298 | 2018-10-13 18:20:42+00:00 | Bike | -DSPH---G------ | 1.0 | 8.44647 | {c8aabf2a-cda5-43b5-ad30-e1717ae79719} |
| 2261101 | 2261101 | 2018-10-13 18:20:42+00:00 | Bike | -DSPH---G------ | 1.0 | 8.44647 | {73c3336b-9633-48fb-a7fc-3ff0a190d2bf} |
| 1292333 | 1292333 | 2018-10-24 18:06:33+00:00 | Bike | -DSPH--A-L----- | 1.0 | 9.4783 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292334 | 1292334 | 2018-10-25 18:08:07+00:00 | Bike | -DSPH--A-L----- | 1.0 | 6.9402 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292335 | 1292335 | 2018-10-25 18:23:39+00:00 | Bike | -DSPH--A-L----- | 1.0 | 8.5649 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292336 | 1292336 | 2018-10-25 18:54:12+00:00 | Bike | -DSPH--A-L----- | 1.0 | 5.5807 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292374 | 1292374 | 2018-12-12 19:31:38+00:00 | Bike | -DSPH--A-L----- | 1.0 | 13.4927 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1743822 | 1743822 | 2019-02-01 15:42:42+00:00 | Bike | -DSPH--A-L----- | 1.0 | 25.8818 | {28370ae4-e020-4965-a12c-44c0bda6f353} |
| 2110933 | 2110933 | 2018-02-16 16:42:57+00:00 | Bike | -DSPH--A-L----- | 1.0 | 24.0023 | {4cf96090-8197-48c6-9570-ea2989b694e0} |
| 2223089 | 2223089 | 2017-02-27 10:25:48+00:00 | Ride | -DSPH--A-L----- | 1.0 | 31.9329 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223091 | 2223091 | 2017-03-02 07:56:57+00:00 | Ride | -DSPH--A-L----- | 1.0 | 26.3315 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223099 | 2223099 | 2017-03-18 14:36:31+00:00 | Ride | -DSPH--A-L----- | 1.0 | 41.9034 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223102 | 2223102 | 2017-03-22 10:31:40+00:00 | Ride | -DSPH--A-L----- | 1.0 | 26.3328 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223103 | 2223103 | 2017-03-23 11:28:11+00:00 | Ride | -DSPH--A-L----- | 1.0 | 23.8726 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223112 | 2223112 | 2017-04-03 08:32:48+00:00 | Ride | -DSPH--A-L----- | 1.0 | 17.2406 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223113 | 2223113 | 2017-04-03 10:05:38+00:00 | Ride | -DSPH--A-L----- | 1.0 | 16.763 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223117 | 2223117 | 2017-04-18 11:39:59+00:00 | Ride | -DSPH--A-L----- | 1.0 | 24.7519 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223122 | 2223122 | 2017-04-25 10:15:49+00:00 | Ride | -DSPH--A-L----- | 1.0 | 24.8832 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223124 | 2223124 | 2017-04-28 08:30:43+00:00 | Ride | -DSPH--A-L----- | 1.0 | 14.9353 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223125 | 2223125 | 2017-04-30 12:13:22+00:00 | Ride | -DSPH--A-L----- | 1.0 | 22.445 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223128 | 2223128 | 2017-05-05 09:51:31+00:00 | Ride | -DSPH--A-L----- | 1.0 | 2.6625 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223129 | 2223129 | 2017-05-05 10:35:39+00:00 | Ride | -DSPH--A-L----- | 1.0 | 5.5432 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223132 | 2223132 | 2017-05-09 08:30:51+00:00 | Ride | -DSPH--A-L----- | 1.0 | 17.7182 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223134 | 2223134 | 2017-05-14 15:28:22+00:00 | Ride | -DSPH--A-L----- | 1.0 | 26.7812 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223136 | 2223136 | 2017-05-16 07:14:26+00:00 | Ride | -DSPH--A-L----- | 1.0 | 5.3884 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223138 | 2223138 | 2017-05-18 12:42:24+00:00 | Ride | -DSPH--A-L----- | 1.0 | 8.9035 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223141 | 2223141 | 2017-05-23 10:40:58+00:00 | Ride | -DSPH--A-L----- | 1.0 | 22.4422 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223145 | 2223145 | 2017-05-30 07:19:27+00:00 | Ride | -DSPH--A-L----- | 1.0 | 19.4801 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223148 | 2223148 | 2017-06-04 14:46:50+00:00 | Ride | -DSPH--A-L----- | 1.0 | 27.191 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223150 | 2223150 | 2017-06-06 10:32:48+00:00 | Ride | -DSPH--A-L----- | 1.0 | 22.9014 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223155 | 2223155 | 2017-06-20 11:24:23+00:00 | Ride | -DSPH--A-L----- | 1.0 | 13.7459 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223161 | 2223161 | 2017-06-30 20:05:40+00:00 | Ride | -DSPH--A-L----- | 1.0 | 2.6973 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223204 | 2223204 | 2017-11-19 16:22:55+00:00 | Ride | -DSPH--A-L----- | 1.0 | 21.2275 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223207 | 2223207 | 2017-12-29 12:11:18+00:00 | Bike | -DSPH--A-L----- | 1.0 | 30.8883 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223212 | 2223212 | 2018-01-02 16:18:01+00:00 | Bike | -DSPH--A-L----- | 1.0 | 25.5667 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223231 | 2223231 | 2018-02-28 18:37:10+00:00 | Bike | -DSPH--A-L----- | 1.0 | 2.20991 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223234 | 2223234 | 2018-03-03 19:13:27+00:00 | Bike | -DSPH--A-L----- | 1.0 | 1.34189 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223240 | 2223240 | 2018-03-18 12:15:59+00:00 | Bike | -DSPH--A-L----- | 1.0 | 1.35185 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223245 | 2223245 | 2018-03-30 14:47:10+00:00 | Bike | -DSPH--A-L----- | 1.0 | 38.27819 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223247 | 2223247 | 2018-04-02 15:36:03+00:00 | Bike | -DSPH--A-L----- | 1.0 | 2.4597 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223260 | 2223260 | 2018-04-15 14:14:15+00:00 | Bike | -DSPH--A-L----- | 1.0 | 28.7107 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223274 | 2223274 | 2018-05-01 19:02:26+00:00 | Bike | -DSPH--A-L----- | 1.0 | 16.8425 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223275 | 2223275 | 2018-05-02 12:23:14+00:00 | Bike | -DSPH--A-L----- | 1.0 | 9.95492 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223289 | 2223289 | 2018-06-02 12:28:08+00:00 | Bike | -DSPH--A-L----- | 1.0 | 3.39541 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223290 | 2223290 | 2018-06-02 12:37:20+00:00 | Bike | -DSPH--A-L----- | 1.0 | 8.04733 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223291 | 2223291 | 2018-06-02 12:57:04+00:00 | Bike | -DSPH--A-L----- | 1.0 | 13.81999 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223295 | 2223295 | 2018-06-07 15:20:03+00:00 | Bike | -DSPH--A-L----- | 1.0 | 4.28838 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
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");