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 |
---|---|---|---|---|---|---|---|
402 | 402 | 2018-01-03 22:36:08+00:00 | TDSP-C-AGL-E--- | 5140.0 | 42.50397 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
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} | |
3691 | 3691 | 2018-03-15 13:34:41+00:00 | TDSP-C-AGL-E--- | 1172.0 | 6.0853 | {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} | |
3693 | 3693 | 2018-03-18 14:54:36+00:00 | TDSP-C-AGL-E--- | 3157.0 | 15.9903 | {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} | |
4402 | 4402 | 2017-07-25 12:26:00+00:00 | TDSP-C-AGL-E--- | 3031.0 | 0.23437 | {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} | |
4424 | 4424 | 2017-08-06 06:23:47+00:00 | TDSP-C-AGL-E--- | 6806.0 | 52.885 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4433 | 4433 | 2017-08-10 21:32:15+00:00 | TDSP-C-AGL-E--- | 3893.0 | 25.39 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4434 | 4434 | 2017-08-11 08:07:57+00:00 | TDSP-C-AGL-E--- | 2629.0 | 18.1995 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4435 | 4435 | 2017-08-11 21:14:48+00:00 | TDSP-C-AGL-E--- | 8761.0 | 62.649 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4436 | 4436 | 2017-08-12 06:03:59+00:00 | TDSP-C-AGL-E--- | 2702.0 | 1.10414 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4438 | 4438 | 2017-08-12 22:35:24+00:00 | TDSP-C-AGL-E--- | 7897.0 | 59.1623 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4439 | 4439 | 2017-08-13 08:07:42+00:00 | TDSP-C-AGL-E--- | 2702.0 | 1.48484 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4440 | 4440 | 2017-08-13 22:17:43+00:00 | TDSP-C-AGL-E--- | 4886.0 | 29.7815 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4441 | 4441 | 2017-08-15 21:52:06+00:00 | TDSP-C-AGL-E--- | 2220.0 | 5.38821 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4442 | 4442 | 2017-08-16 07:05:55+00:00 | TDSP-C-AGL-E--- | 2403.0 | 0.88587 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4443 | 4443 | 2017-08-16 21:28:22+00:00 | TDSP-C-AGL-E--- | 9861.0 | 74.7893 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4444 | 4444 | 2017-08-17 05:28:20+00:00 | TDSP-C-AGL-E--- | 3122.0 | 0.68335 | {75bc14e8-270b-4b8b-ae37-ed0219ca70ec} | |
4445 | 4445 | 2017-08-17 19:20:47+00:00 | TDSP-C-AGL-E--- | 8147.0 | 65.719 | {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} | |
4462 | 4462 | 2017-08-25 22:17:49+00:00 | TDSP-C-AGL-E--- | 479.0 | 2.82263 | {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} |
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");