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 sport
This data as json, CSV (advanced)
| Link | rowid | date | sport ▼ | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1999 | 1999 | 2014-12-30 18:02:53+00:00 | TDSPHC-A-L-E--- | 2789.0 | 22.05755 | {c951a4f7-b06e-4743-8ad0-24271b8f7cd6} | |
| 3680 | 3680 | 2015-08-30 10:11:01+00:00 | TDSPHC-AGL-E--- | 4898.0 | 34.0139 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3681 | 3681 | 2015-08-31 18:52:55+00:00 | TDSPHC-AGL-E--- | 7264.0 | 51.1193 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3682 | 3682 | 2015-09-03 10:26:06+00:00 | TDSPHC-AGL-E--- | 12291.0 | 80.1604 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3683 | 3683 | 2015-09-04 14:39:40+00:00 | TDSPHC-AGL-E--- | 7012.0 | 51.2787 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3684 | 3684 | 2015-09-12 10:26:41+00:00 | TDSPHC-AGL-E--- | 11132.0 | 67.7325 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3686 | 3686 | 2015-10-09 11:15:13+00:00 | TDSPHC-AGL-E--- | 6436.0 | 43.8053 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3687 | 3687 | 2015-10-17 12:43:03+00:00 | TDSPHC-AGL-E--- | 2654.0 | 16.5944 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3688 | 3688 | 2015-11-02 12:15:16+00:00 | TDSPHC-AGL-E--- | 5468.0 | 36.4833 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3689 | 3689 | 2015-11-03 14:33:20+00:00 | TDSPHC-AGL-E--- | 6562.0 | 42.3458 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3690 | 3690 | 2015-11-04 15:51:22+00:00 | TDSPHC-AGL-E--- | 4336.0 | 28.3004 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3692 | 3692 | 2018-03-17 15:01:36+00:00 | TDSPHC-AGL-E--- | 3084.0 | 15.7083 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3710 | 3710 | 2018-05-13 09:49:32+00:00 | TDSPHC-AGL-E--- | 5416.0 | 37.2659 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3849 | 3849 | 2019-02-09 15:23:02+00:00 | TDSPHC-AGL----- | 5535.0 | 31.7478 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3858 | 3858 | 2019-03-31 22:42:00+00:00 | TDSPHC-AGL----- | 3618.0 | 24.2706 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3859 | 3859 | 2019-04-01 23:59:13+00:00 | TDSPHC-AGL----- | 3616.0 | 31.8582 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 3970 | 3970 | 2019-11-12 23:32:45+00:00 | TDSPHC-AGL----- | 1000.0 | 7.77837 | {bcffcd4a-1727-481b-8eda-858e976c3cea} | |
| 4384 | 4384 | 2017-07-15 22:43:29+00:00 | TDSPHC-AGL-E--- | 3896.0 | 0.77267 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4385 | 4385 | 2017-07-17 07:35:44+00:00 | TDSPHC-AGL-E--- | 2725.0 | 0.5867 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4386 | 4386 | 2017-07-17 12:01:09+00:00 | TDSPHC-AGL-E--- | 1812.0 | 0.48128 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4387 | 4387 | 2017-07-17 22:52:51+00:00 | TDSPHC-AGL-E--- | 3014.0 | 0.75159 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4390 | 4390 | 2017-07-18 20:20:03+00:00 | TDSPHC-AGL-E--- | 3674.0 | 21.4632 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4391 | 4391 | 2017-07-19 20:17:53+00:00 | TDSPHC-AGL-E--- | 2791.0 | 21.5164 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4392 | 4392 | 2017-07-20 07:32:45+00:00 | TDSPHC-AGL-E--- | 8897.0 | 0.69932 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4393 | 4393 | 2017-07-20 12:02:17+00:00 | TDSPHC-AGL-E--- | 2081.0 | 0.67438 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4394 | 4394 | 2017-07-20 20:25:14+00:00 | TDSPHC-AGL-E--- | 2374.0 | 17.707 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4395 | 4395 | 2017-07-22 21:54:32+00:00 | TDSPHC-AGL-E--- | 4410.0 | 37.0385 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4396 | 4396 | 2017-07-23 07:30:01+00:00 | TDSPHC-AGL-E--- | 3183.0 | 0.98768 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4397 | 4397 | 2017-07-23 20:24:11+00:00 | TDSPHC-AGL-E--- | 3354.0 | 23.8249 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4398 | 4398 | 2017-07-24 22:36:53+00:00 | TDSPHC-AGL-E--- | 1213.0 | 0.23852 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4401 | 4401 | 2017-07-25 08:17:06+00:00 | TDSPHC-AGL-E--- | 4541.0 | 1.05581 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4403 | 4403 | 2017-07-25 20:26:48+00:00 | TDSPHC-AGL-E--- | 3096.0 | 25.0604 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4404 | 4404 | 2017-07-26 22:29:16+00:00 | TDSPHC-AGL-E--- | 1805.0 | 0.42778 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4405 | 4405 | 2017-07-28 08:03:37+00:00 | TDSPHC-AGL-E--- | 3768.0 | 0.89728 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4406 | 4406 | 2017-07-28 20:26:52+00:00 | TDSPHC-AGL-E--- | 2403.0 | 0.63304 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4407 | 4407 | 2017-07-29 23:15:39+00:00 | TDSPHC-AGL-E--- | 8533.0 | 67.1894 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4408 | 4408 | 2017-07-30 08:03:45+00:00 | TDSPHC-AGL-E--- | 2702.0 | 0.60366 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4409 | 4409 | 2017-07-30 20:13:11+00:00 | TDSPHC-AGL-E--- | 3070.0 | 20.7665 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4410 | 4410 | 2017-07-31 20:16:13+00:00 | TDSPHC-AGL-E--- | 5617.0 | 36.6737 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4411 | 4411 | 2017-08-01 20:27:41+00:00 | TDSPHC-AGL-E--- | 4263.0 | 32.1887 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4414 | 4414 | 2017-08-02 20:17:19+00:00 | TDSPHC-AGL-E--- | 2906.0 | 21.9927 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4417 | 4417 | 2017-08-03 23:37:05+00:00 | TDSPHC-AGL-E--- | 3903.0 | 0.99162 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4418 | 4418 | 2017-08-04 03:27:48+00:00 | TDSPHC-AGL-E--- | 3612.0 | 1.56731 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4421 | 4421 | 2017-08-05 07:11:19+00:00 | TDSPHC-AGL-E--- | 628.0 | 3.02219 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4422 | 4422 | 2017-08-05 07:49:48+00:00 | TDSPHC-AGL-E--- | 3606.0 | 0.86829 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4423 | 4423 | 2017-08-05 21:35:58+00:00 | TDSPHC-AGL-E--- | 7331.0 | 55.0952 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4446 | 4446 | 2017-08-18 23:36:26+00:00 | TDSPHC-AGL-E--- | 9199.0 | 66.461 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4447 | 4447 | 2017-08-19 07:48:46+00:00 | TDSPHC-AGL-E--- | 4502.0 | 0.71147 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4448 | 4448 | 2017-08-19 23:10:59+00:00 | TDSPHC-AGL-E--- | 16839.0 | 90.411 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4449 | 4449 | 2017-08-20 08:13:58+00:00 | TDSPHC-AGL-E--- | 3002.0 | 0.68942 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4450 | 4450 | 2017-08-20 21:35:37+00:00 | TDSPHC-AGL-E--- | 3557.0 | 20.4046 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4451 | 4451 | 2017-08-21 08:09:40+00:00 | TDSPHC-AGL-E--- | 2888.0 | 17.5564 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4452 | 4452 | 2017-08-21 10:03:01+00:00 | TDSPHC-AGL-E--- | 3499.0 | 0.65552 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4453 | 4453 | 2017-08-21 20:53:23+00:00 | TDSPHC-AGL-E--- | 5856.0 | 36.0676 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4454 | 4454 | 2017-08-22 08:10:30+00:00 | TDSPHC-AGL-E--- | 2755.0 | 18.0394 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4455 | 4455 | 2017-08-22 10:20:32+00:00 | TDSPHC-AGL-E--- | 5666.0 | 41.0299 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4456 | 4456 | 2017-08-22 21:31:24+00:00 | TDSPHC-AGL-E--- | 3797.0 | 21.1915 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4457 | 4457 | 2017-08-23 08:12:42+00:00 | TDSPHC-AGL-E--- | 3004.0 | 17.4482 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4458 | 4458 | 2017-08-23 21:02:05+00:00 | TDSPHC-AGL-E--- | 5604.0 | 28.6048 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4459 | 4459 | 2017-08-24 08:28:52+00:00 | TDSPHC-AGL-E--- | 2989.0 | 16.4651 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4460 | 4460 | 2017-08-24 21:33:08+00:00 | TDSPHC-AGL-E--- | 3603.0 | 18.9706 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4461 | 4461 | 2017-08-25 08:16:01+00:00 | TDSPHC-AGL-E--- | 2739.0 | 16.6124 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4463 | 4463 | 2017-08-26 22:00:03+00:00 | TDSPHC-AGL-E--- | 3792.0 | 20.0427 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4464 | 4464 | 2017-08-27 00:03:35+00:00 | TDSPHC-AGL-E--- | 3894.0 | 19.8348 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4465 | 4465 | 2017-08-27 21:40:36+00:00 | TDSPHC-AGL-E--- | 3297.0 | 17.6954 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4466 | 4466 | 2017-08-28 08:15:08+00:00 | TDSPHC-AGL-E--- | 2597.0 | 16.6733 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4467 | 4467 | 2017-08-28 20:42:05+00:00 | TDSPHC-AGL-E--- | 6823.0 | 47.5995 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4468 | 4468 | 2017-08-29 08:11:50+00:00 | TDSPHC-AGL-E--- | 2861.0 | 18.0431 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4469 | 4469 | 2017-08-29 10:11:45+00:00 | TDSPHC-AGL-E--- | 3839.0 | 28.2677 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4470 | 4470 | 2017-08-29 20:54:40+00:00 | TDSPHC-AGL-E--- | 5295.0 | 31.681 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4471 | 4471 | 2017-08-30 09:21:39+00:00 | TDSPHC-AGL-E--- | 2418.0 | 16.3222 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4472 | 4472 | 2017-08-30 20:43:19+00:00 | TDSPHC-AGL-E--- | 7139.0 | 49.768 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4473 | 4473 | 2017-08-31 08:10:47+00:00 | TDSPHC-AGL-E--- | 2867.0 | 16.1963 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4474 | 4474 | 2017-08-31 09:53:33+00:00 | TDSPHC-AGL-E--- | 4941.0 | 36.4222 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4475 | 4475 | 2017-08-31 21:30:31+00:00 | TDSPHC-AGL-E--- | 3906.0 | 19.9961 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4476 | 4476 | 2017-09-01 08:20:55+00:00 | TDSPHC-AGL-E--- | 2964.0 | 16.6542 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4477 | 4477 | 2017-09-01 21:24:10+00:00 | TDSPHC-AGL-E--- | 10372.0 | 78.7936 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4480 | 4480 | 2017-09-02 06:19:02+00:00 | TDSPHC-AGL-E--- | 6200.0 | 46.8749 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4481 | 4481 | 2017-09-02 22:56:20+00:00 | TDSPHC-AGL-E--- | 5875.0 | 50.0447 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4482 | 4482 | 2017-09-03 00:51:04+00:00 | TDSPHC-AGL-E--- | 4167.0 | 38.9913 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4483 | 4483 | 2017-09-03 02:06:47+00:00 | TDSPHC-AGL-E--- | 7793.0 | 22.3764 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 4484 | 4484 | 2017-09-03 06:29:43+00:00 | TDSPHC-AGL-E--- | 6273.0 | 48.7881 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
| 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} | |
| 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} |
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");