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 data
This data as json, CSV (advanced)
| Link | rowid | date | sport | data ▼ | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 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} |
| 2223296 | 2223296 | 2018-06-07 15:31:36+00:00 | Bike | -DSPH--A-L----- | 1.0 | 12.4257 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 551011 | 551011 | 2018-05-17 09:37:10+00:00 | Bike | -DSPH--AGL----- | 1.0 | 39.75965 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551012 | 551012 | 2018-05-18 19:23:43+00:00 | Bike | -DSPH--AGL----- | 1.0 | 31.9157 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551015 | 551015 | 2018-05-23 09:35:46+00:00 | Bike | -DSPH--AGL----- | 1.0 | 44.7317 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551021 | 551021 | 2018-06-03 17:49:43+00:00 | Bike | -DSPH--AGL----- | 1.0 | 11.9466 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 1041726 | 1041726 | 2018-02-12 14:15:42+00:00 | VirtualRide | -DSPH--AGL----- | 1.0 | 21.3363 | {5ca1341d-c4c0-41a4-a13e-121c4adb4edd} |
| 1292258 | 1292258 | 2018-07-15 16:42:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 31.1065 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292266 | 1292266 | 2018-07-28 07:29:12+00:00 | Bike | -DSPH--AGL----- | 1.0 | 26.9897 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292277 | 1292277 | 2018-08-12 09:18:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.9704 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292278 | 1292278 | 2018-08-13 17:49:23+00:00 | Bike | -DSPH--AGL----- | 1.0 | 14.9956 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292279 | 1292279 | 2018-08-14 18:21:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 20.3966 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292286 | 1292286 | 2018-08-25 07:38:30+00:00 | Bike | -DSPH--AGL----- | 1.0 | 21.2044 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292294 | 1292294 | 2018-09-01 17:58:34+00:00 | Bike | -DSPH--AGL----- | 1.0 | 27.7099 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292298 | 1292298 | 2018-09-02 12:57:48+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.4352 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292302 | 1292302 | 2018-09-08 07:26:05+00:00 | Bike | -DSPH--AGL----- | 1.0 | 8.27626 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292311 | 1292311 | 2018-09-22 07:31:02+00:00 | Bike | -DSPH--AGL----- | 1.0 | 10.5845 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292316 | 1292316 | 2018-09-29 08:56:03+00:00 | Bike | -DSPH--AGL----- | 1.0 | 62.4442 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292317 | 1292317 | 2018-09-29 11:03:49+00:00 | Bike | -DSPH--AGL----- | 1.0 | 4.9742 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292327 | 1292327 | 2018-10-16 18:02:39+00:00 | Bike | -DSPH--AGL----- | 1.0 | 26.2458 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292330 | 1292330 | 2018-10-20 10:54:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 60.2107 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292331 | 1292331 | 2018-10-21 08:41:23+00:00 | Bike | -DSPH--AGL----- | 1.0 | 67.3789 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292342 | 1292342 | 2018-11-01 11:44:00+00:00 | Bike | -DSPH--AGL----- | 1.0 | 29.81353 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292349 | 1292349 | 2018-11-09 14:37:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.8661 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292350 | 1292350 | 2018-11-10 10:52:24+00:00 | Bike | -DSPH--AGL----- | 1.0 | 29.2327 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292361 | 1292361 | 2018-11-24 14:06:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.4337 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292370 | 1292370 | 2018-12-06 14:27:52+00:00 | Bike | -DSPH--AGL----- | 1.0 | 67.2021 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292376 | 1292376 | 2018-12-14 19:44:51+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.0028 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292379 | 1292379 | 2018-12-18 18:56:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 16.4035 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292380 | 1292380 | 2018-12-18 19:55:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 1.43373 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292418 | 1292418 | 2019-02-05 19:34:12+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.007 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292420 | 1292420 | 2019-02-06 19:31:22+00:00 | Bike | -DSPH--AGL----- | 1.0 | 13.9369 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292442 | 1292442 | 2019-03-08 18:18:29+00:00 | Bike | -DSPH--AGL----- | 1.0 | 32.508 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292443 | 1292443 | 2019-03-09 10:42:28+00:00 | Bike | -DSPH--AGL----- | 1.0 | 42.9329 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292450 | 1292450 | 2019-03-20 18:48:49+00:00 | Bike | -DSPH--AGL----- | 1.0 | 13.6489 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292451 | 1292451 | 2019-03-21 19:21:08+00:00 | Bike | -DSPH--AGL----- | 1.0 | 9.5544 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292456 | 1292456 | 2019-03-28 18:59:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 17.1699 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292460 | 1292460 | 2019-04-03 17:54:52+00:00 | Bike | -DSPH--AGL----- | 1.0 | 20.2673 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292461 | 1292461 | 2019-04-04 18:13:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 12.7492 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292466 | 1292466 | 2019-04-09 18:16:07+00:00 | Bike | -DSPH--AGL----- | 1.0 | 22.5055 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292467 | 1292467 | 2019-04-10 18:13:53+00:00 | Bike | -DSPH--AGL----- | 1.0 | 15.3131 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292471 | 1292471 | 2019-04-14 10:51:07+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.95494 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1677930 | 1677930 | 2018-08-28 10:28:03+00:00 | Bike | -DSPH--AGL----- | 1.0 | 56.246 | {7d770f18-c686-4d2a-9cea-3d0c00881b46} |
| 1677932 | 1677932 | 2018-08-28 19:38:18+00:00 | Bike | -DSPH--AGL----- | 1.0 | 8.813 | {7d770f18-c686-4d2a-9cea-3d0c00881b46} |
| 1743818 | 1743818 | 2019-01-29 19:28:03+00:00 | Bike | -DSPH--AGL----- | 1.0 | 20.2925 | {28370ae4-e020-4965-a12c-44c0bda6f353} |
| 1743820 | 1743820 | 2019-01-31 19:58:45+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.5667 | {28370ae4-e020-4965-a12c-44c0bda6f353} |
| 2223064 | 2223064 | 2017-01-12 15:03:25+00:00 | VirtualRide | -DSPH--AGL----- | 1.0 | 23.5857 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223074 | 2223074 | 2017-02-02 09:43:16+00:00 | Ride | -DSPH--AGL----- | 1.0 | 33.4509 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223083 | 2223083 | 2017-02-20 08:15:32+00:00 | Ride | -DSPH--AGL----- | 1.0 | 41.7037 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223185 | 2223185 | 2017-08-17 08:03:59+00:00 | Ride | -DSPH--AGL----- | 1.0 | 0.979 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223186 | 2223186 | 2017-08-17 08:07:16+00:00 | Ride | -DSPH--AGL----- | 1.0 | 23.6121 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223194 | 2223194 | 2017-09-12 08:06:20+00:00 | Ride | -DSPH--AGL----- | 1.0 | 0.7371 | {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");