rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by sport
This data as json, CSV (advanced)
| Link | rowid | date | sport ▼ | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 4485 | 4485 | 2017-09-03 21:37:16+00:00 | TDSPHC-AGL-E--- | 3515.0 | 19.6997 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4486 | 4486 | 2017-09-04 08:45:03+00:00 | TDSPHC-AGL-E--- | 2809.0 | 16.1568 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4487 | 4487 | 2017-09-04 20:34:11+00:00 | TDSPHC-AGL-E--- | 7450.0 | 50.8044 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4488 | 4488 | 2017-09-05 08:14:28+00:00 | TDSPHC-AGL-E--- | 2733.0 | 17.8365 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4489 | 4489 | 2017-09-05 10:32:38+00:00 | TDSPHC-AGL-E--- | 337.0 | 0.13026 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4490 | 4490 | 2017-09-05 21:07:02+00:00 | TDSPHC-AGL-E--- | 5124.0 | 30.3786 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4491 | 4491 | 2017-09-06 08:58:01+00:00 | TDSPHC-AGL-E--- | 2677.0 | 18.0805 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4492 | 4492 | 2017-09-06 21:06:33+00:00 | TDSPHC-AGL-E--- | 5334.0 | 32.9134 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4493 | 4493 | 2017-09-07 08:51:42+00:00 | TDSPHC-AGL-E--- | 2601.0 | 16.4235 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4494 | 4494 | 2017-09-07 21:37:59+00:00 | TDSPHC-AGL-E--- | 3216.0 | 17.6765 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4495 | 4495 | 2017-09-08 09:36:22+00:00 | TDSPHC-AGL-E--- | 2277.0 | 16.7079 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4496 | 4496 | 2017-09-08 21:32:35+00:00 | TDSPHC-AGL-E--- | 1871.0 | 14.142 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4497 | 4497 | 2017-09-09 07:34:19+00:00 | TDSPHC-AGL-E--- | 1919.0 | 11.1743 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4498 | 4498 | 2017-09-09 20:44:34+00:00 | TDSP-C-AGL-E--- | 765.0 | 4.91149 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4499 | 4499 | 2017-09-09 21:30:03+00:00 | TDSP-C-AGL-E--- | 246.0 | 2.23977 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4500 | 4500 | 2017-09-09 22:00:01+00:00 | TDSPHC-AGL-E--- | 4104.0 | 27.1785 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4501 | 4501 | 2017-09-10 00:18:08+00:00 | TDSPHC-AGL-E--- | 4531.0 | 25.8687 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4502 | 4502 | 2017-09-11 21:34:51+00:00 | TDSPHC-AGL-E--- | 3558.0 | 17.0661 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4503 | 4503 | 2017-09-12 09:29:34+00:00 | TDSPHC-AGL-E--- | 2808.0 | 16.666 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4504 | 4504 | 2017-09-12 21:39:31+00:00 | TDSPHC-AGL-E--- | 3718.0 | 17.9336 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4505 | 4505 | 2017-09-13 09:22:55+00:00 | TDSPHC-AGL-E--- | 2622.0 | 16.4479 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4506 | 4506 | 2017-09-13 20:45:03+00:00 | TDSPHC-AGL-E--- | 6529.0 | 35.372 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4507 | 4507 | 2017-09-14 09:21:05+00:00 | TDSPHC-AGL-E--- | 2641.0 | 16.9201 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4508 | 4508 | 2017-09-14 21:37:54+00:00 | TDSPHC-AGL-E--- | 3411.0 | 18.8722 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4509 | 4509 | 2017-09-15 09:24:41+00:00 | TDSPHC-AGL-E--- | 2522.0 | 16.7211 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4510 | 4510 | 2017-09-15 21:09:45+00:00 | TDSPHC-AGL-E--- | 4151.0 | 32.1232 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4511 | 4511 | 2017-09-16 06:59:26+00:00 | TDSPHC-AGL-E--- | 2450.0 | 1.06036 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4512 | 4512 | 2017-09-16 21:58:09+00:00 | TDSPHC-AGL-E--- | 3030.0 | 22.5889 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4513 | 4513 | 2017-09-17 21:09:10+00:00 | TDSPHC-AGL-E--- | 5366.0 | 33.0164 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4514 | 4514 | 2017-09-18 08:48:21+00:00 | TDSPHC-AGL-E--- | 2496.0 | 16.6926 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4515 | 4515 | 2017-09-18 20:53:04+00:00 | TDSPHC-AGL-E--- | 6001.0 | 34.3157 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4516 | 4516 | 2017-09-19 08:32:47+00:00 | TDSPHC-AGL-E--- | 2535.0 | 16.6876 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4517 | 4517 | 2017-09-19 20:57:23+00:00 | TDSPHC-AGL-E--- | 5839.0 | 37.7598 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4518 | 4518 | 2017-09-20 10:21:59+00:00 | TDSPHC-AGL-E--- | 2344.0 | 17.8836 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4519 | 4519 | 2017-09-20 21:00:24+00:00 | TDSPHC-AGL-E--- | 6055.0 | 41.0044 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4520 | 4520 | 2017-09-21 10:23:29+00:00 | TDSPHC-AGL-E--- | 2555.0 | 16.9021 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4521 | 4521 | 2017-09-21 21:40:01+00:00 | TDSPHC-AGL-E--- | 3271.0 | 17.7342 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4522 | 4522 | 2017-09-22 10:23:48+00:00 | TDSPHC-AGL-E--- | 2654.0 | 16.973 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4523 | 4523 | 2017-09-22 23:11:03+00:00 | TDSPHC-AGL-E--- | 10178.0 | 75.5882 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4524 | 4524 | 2017-09-23 21:14:23+00:00 | TDSPHC-AGL-E--- | 14349.0 | 108.85 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4525 | 4525 | 2017-09-24 04:58:23+00:00 | TDSP-C-AGL-E--- | 10498.0 | 31.0771 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4526 | 4526 | 2017-09-24 21:41:53+00:00 | TDSPHC-AGL-E--- | 3234.0 | 19.0228 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4527 | 4527 | 2017-09-25 10:20:45+00:00 | TDSPHC-AGL-E--- | 2374.0 | 16.9551 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4528 | 4528 | 2017-09-25 20:52:08+00:00 | TDSPHC-AGL-E--- | 6015.0 | 37.3058 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4529 | 4529 | 2017-09-26 10:24:52+00:00 | TDSPHC-AGL-E--- | 2549.0 | 16.8293 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4530 | 4530 | 2017-09-26 20:48:20+00:00 | TDSPHC-AGL-E--- | 4974.0 | 31.5893 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4531 | 4531 | 2017-09-27 10:21:05+00:00 | TDSP-C-AGL-E--- | 2409.0 | 16.8906 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4532 | 4532 | 2017-09-27 21:35:56+00:00 | TDSPHC-AGL-E--- | 3639.0 | 18.9759 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4533 | 4533 | 2017-09-28 09:53:55+00:00 | TDSP-C-AGL-E--- | 2598.0 | 16.9433 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4534 | 4534 | 2017-09-28 21:04:43+00:00 | TDSPHC-AGL-E--- | 5333.0 | 30.5495 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4535 | 4535 | 2017-09-29 08:51:43+00:00 | TDSP-C-AGL-E--- | 2711.0 | 16.687 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4536 | 4536 | 2017-09-29 20:54:25+00:00 | TDSP-C-AGL-E--- | 9282.0 | 74.971 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4537 | 4537 | 2017-09-30 06:57:44+00:00 | TDSPHC-AGL-E--- | 2902.0 | 21.4087 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4540 | 4540 | 2017-09-30 22:54:03+00:00 | TDSPHC-AGL-E--- | 6225.0 | 33.3556 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4541 | 4541 | 2017-10-01 00:49:29+00:00 | TDSPHC-AGL-E--- | 3867.0 | 17.5911 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4542 | 4542 | 2017-10-01 02:10:20+00:00 | TDSPHC-AGL-E--- | 8336.0 | 37.5937 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4543 | 4543 | 2017-10-01 09:59:49+00:00 | TDSPHC-AGL-E--- | 1922.0 | 0.52282 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4544 | 4544 | 2017-10-02 21:38:57+00:00 | TDSPHC-AGL-E--- | 3941.0 | 18.296 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4545 | 4545 | 2017-10-03 08:55:29+00:00 | TDSPHC-AGL-E--- | 2862.0 | 16.6955 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4546 | 4546 | 2017-10-03 11:15:09+00:00 | TDSPHC-AGL-E--- | 2522.0 | 0.62381 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4547 | 4547 | 2017-10-03 21:06:49+00:00 | TDSPHC-AGL-E--- | 5288.0 | 26.8278 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4548 | 4548 | 2017-10-04 08:52:39+00:00 | TDSPHC-AGL-E--- | 2450.0 | 16.6849 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4549 | 4549 | 2017-10-04 10:57:25+00:00 | TDSPHC-AGL-E--- | 3602.0 | 0.97636 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4550 | 4550 | 2017-10-04 21:12:40+00:00 | TDSPHC-AGL-E--- | 5081.0 | 27.8745 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4551 | 4551 | 2017-10-05 09:20:17+00:00 | TDSP-C-AGL-E--- | 2613.0 | 16.7389 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4552 | 4552 | 2017-10-05 11:29:20+00:00 | TDSPHC-AGL-E--- | 2903.0 | 23.4165 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4553 | 4553 | 2017-10-05 21:03:13+00:00 | TDSPHC-AGL-E--- | 5038.0 | 24.8626 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4554 | 4554 | 2017-10-06 08:56:39+00:00 | TDSP-C-AGL-E--- | 2910.0 | 16.7369 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4555 | 4555 | 2017-10-07 05:09:39+00:00 | TDSPHC-AGL-E--- | 5796.0 | 29.1501 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4556 | 4556 | 2017-10-07 21:57:10+00:00 | TDSPHC-AGL-E--- | 15044.0 | 83.4711 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4557 | 4557 | 2017-10-08 23:47:21+00:00 | TDSP-C-AGL-E--- | 20570.0 | 143.742 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4559 | 4559 | 2017-10-09 21:42:27+00:00 | TDSPHC-AGL-E--- | 3352.0 | 19.0285 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4560 | 4560 | 2017-10-10 08:54:51+00:00 | TDSPHC-AGL-E--- | 2810.0 | 16.9081 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4561 | 4561 | 2017-10-10 11:36:18+00:00 | TDSPHC-AGL-E--- | 1863.0 | 0.57824 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4562 | 4562 | 2017-10-10 21:05:22+00:00 | TDSPHC-AGL-E--- | 5450.0 | 30.6641 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4563 | 4563 | 2017-10-11 09:22:22+00:00 | TDSPHC-AGL-E--- | 2779.0 | 16.6322 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4564 | 4564 | 2017-10-11 09:45:46+00:00 | TDSPHC-AGL-E--- | 305.0 | 0.03082 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4565 | 4565 | 2017-10-11 11:28:44+00:00 | TDSPHC-AGL-E--- | 2522.0 | 0.62759 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4566 | 4566 | 2017-10-11 21:28:27+00:00 | TDSPHC-AGL-E--- | 4012.0 | 22.6366 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4567 | 4567 | 2017-10-12 09:25:40+00:00 | TDSPHC-AGL-E--- | 2492.0 | 16.6347 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4568 | 4568 | 2017-10-12 21:00:09+00:00 | TDSPHC-AGL-E--- | 5738.0 | 32.7453 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4569 | 4569 | 2017-10-13 08:50:55+00:00 | TDSP-C-AGL-E--- | 2434.0 | 16.6737 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4570 | 4570 | 2017-10-13 09:05:57+00:00 | TDSPHC-AGL-E--- | 2351.0 | 0.40544 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4571 | 4571 | 2017-10-13 23:34:06+00:00 | TDSP-C-AGL-E--- | 5689.0 | 35.7983 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4572 | 4572 | 2017-10-14 23:00:53+00:00 | TDSPHC-AGL-E--- | 3426.0 | 0.90945 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4573 | 4573 | 2017-10-15 06:47:34+00:00 | TDSPHC-AGL-E--- | 6511.0 | 1.15783 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4574 | 4574 | 2017-10-15 09:03:23+00:00 | TDSPHC-AGL-E--- | 2297.0 | 0.57995 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4575 | 4575 | 2017-10-15 21:29:00+00:00 | TDSP-C-AGL-E--- | 3802.0 | 18.6799 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4576 | 4576 | 2017-10-16 09:28:12+00:00 | TDSP-C-AGL-E--- | 2705.0 | 16.7601 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4577 | 4577 | 2017-10-16 21:05:00+00:00 | TDSPHC-AGL-E--- | 5333.0 | 28.5919 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4578 | 4578 | 2017-10-17 08:29:32+00:00 | TDSP-C-AGL-E--- | 2849.0 | 16.6758 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4579 | 4579 | 2017-10-17 10:03:29+00:00 | TDSP-C-AGL-E--- | 5104.0 | 37.4566 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4580 | 4580 | 2017-10-17 21:09:21+00:00 | TDSPHC-AGL-E--- | 5115.0 | 32.1195 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4582 | 4582 | 2017-10-18 08:14:19+00:00 | TDSPHC-AGL-E--- | 2642.0 | 16.6695 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4584 | 4584 | 2017-10-18 21:20:59+00:00 | TDSP-C-AGL-E--- | 4156.0 | 20.9206 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4744 | 4744 | 2017-12-31 07:34:55+00:00 | TDSPHC-AGL-E--- | 6.0 | 0.03258 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4745 | 4745 | 2018-01-01 08:07:14+00:00 | TDSPHC-AGL-E--- | 6.0 | 0.03388 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4746 | 4746 | 2018-01-01 22:26:15+00:00 | TDSPHC-AGL-E--- | 8.0 | 0.02639 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4747 | 4747 | 2018-01-02 22:52:22+00:00 | TDSPHC-AGL-E--- | 3.0 | 0.01371 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4748 | 4748 | 2018-01-03 23:05:39+00:00 | TDSPH--AGL-E--- | 4.0 | 0.01066 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} |
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");