rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by athlete
This data as json, CSV (advanced)
Link | rowid | date | sport | data | workout_time | total_distance | athlete ▼ |
---|---|---|---|---|---|---|---|
2578615 | 2578615 | 2017-08-11 07:50:24+00:00 | Bike | TDSPHC-AGL-E--- | 2306.0 | 5.50205 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578616 | 2578616 | 2017-08-11 13:58:05+00:00 | Bike | TDSP-C-AGL-E--- | 9438.0 | 100.115 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578637 | 2578637 | 2017-11-10 06:52:08+00:00 | Bike | TDSPHC-AGL----- | 15960.0 | 115.73551 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578639 | 2578639 | 2017-11-12 06:52:55+00:00 | Bike | TDSPHC-AGL----R | 23749.0 | 144.02843 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578640 | 2578640 | 2017-11-14 18:25:49+00:00 | Bike | T--PHC-A------- | 2033.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578641 | 2578641 | 2017-11-15 12:59:14+00:00 | Bike | TDSPHC-AGL----- | 11067.0 | 87.4819 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578642 | 2578642 | 2017-11-16 13:15:51+00:00 | Bike | TDSPHC-AGL----- | 6717.0 | 50.18972 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578643 | 2578643 | 2017-11-17 10:32:28+00:00 | Bike | TDSPHC-AGL----- | 10868.0 | 89.23507 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578644 | 2578644 | 2017-11-18 07:39:09+00:00 | Bike | TDSPHC-AGL----- | 18957.0 | 115.709 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578645 | 2578645 | 2017-11-21 09:33:36+00:00 | Bike | TDSPHC-AGL----R | 10452.0 | 78.73888 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578646 | 2578646 | 2017-11-22 13:11:35+00:00 | Bike | TDSPH--AGL----- | 13521.0 | 103.38114 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578647 | 2578647 | 2017-11-23 13:11:48+00:00 | Bike | TDSPHC-AGL----- | 11123.0 | 87.84501 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578648 | 2578648 | 2017-11-24 09:20:00+00:00 | Bike | TDSPHC-AGL----- | 15467.0 | 113.92305 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578649 | 2578649 | 2017-11-25 07:54:47+00:00 | Bike | TDSPHC-AGL----- | 15202.0 | 95.75164 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578650 | 2578650 | 2017-11-28 10:55:34+00:00 | Bike | TDSPHC-AGL----- | 8228.0 | 70.40977 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578651 | 2578651 | 2017-11-30 11:55:32+00:00 | Bike | TDSPHC-AGL----- | 16216.0 | 114.03177 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578652 | 2578652 | 2017-12-01 08:10:04+00:00 | Bike | TDSPHC-AGL----R | 10917.0 | 78.60286 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578653 | 2578653 | 2017-12-02 09:08:39+00:00 | Bike | TDSPHC-AGL----- | 20737.0 | 130.38608 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578654 | 2578654 | 2017-12-03 07:41:27+00:00 | Bike | TDSPH--AGL----- | 19758.0 | 140.19773 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578655 | 2578655 | 2017-12-06 07:40:54+00:00 | Bike | T--PHC-A------- | 3121.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578656 | 2578656 | 2017-12-06 09:19:34+00:00 | Bike | TDSPHC-AGL----R | 16785.0 | 115.968 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578657 | 2578657 | 2017-12-07 07:11:52+00:00 | Bike | T--PHC-A------R | 3002.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578658 | 2578658 | 2017-12-07 09:10:25+00:00 | Bike | TDSPH--AGL----- | 15883.0 | 103.88891 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578659 | 2578659 | 2017-12-08 09:04:07+00:00 | Bike | TDSPHC-AGL----- | 20516.0 | 148.27616 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578660 | 2578660 | 2017-12-09 09:13:34+00:00 | Bike | TDSPHC-AGL----- | 14943.0 | 93.78401 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578661 | 2578661 | 2017-12-10 08:02:59+00:00 | Bike | TDSPH--AGL----- | 22063.0 | 148.34327 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578662 | 2578662 | 2017-12-11 05:11:06+00:00 | Bike | T--PHC-A------- | 3614.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578663 | 2578663 | 2017-12-13 12:43:54+00:00 | Bike | TDSPHC-AGL----- | 5856.0 | 46.85974 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578664 | 2578664 | 2017-12-15 09:35:29+00:00 | Bike | TDSPHC-AGL----- | 17909.0 | 113.93568 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578665 | 2578665 | 2017-12-16 08:26:33+00:00 | Bike | TDSPHC-AGL----- | 10674.0 | 84.2975 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578666 | 2578666 | 2017-12-17 07:17:48+00:00 | Bike | TDSPHC-AGL----R | 20299.0 | 140.89011 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578667 | 2578667 | 2017-12-18 14:22:54+00:00 | Bike | TDSPH--AGL----- | 6103.0 | 50.63983 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578668 | 2578668 | 2017-12-19 12:52:53+00:00 | Bike | TDSPHC-AGL----- | 10902.0 | 82.6051 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578669 | 2578669 | 2017-12-20 13:01:36+00:00 | Bike | TDSPHC-AGL----- | 7758.0 | 60.16999 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578670 | 2578670 | 2017-12-21 11:49:36+00:00 | Bike | TDSPHC-AGL----- | 10165.0 | 84.015 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578671 | 2578671 | 2017-12-22 08:22:18+00:00 | Bike | TDSPHC-AGL----R | 24837.0 | 165.92223 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578672 | 2578672 | 2017-12-23 09:21:36+00:00 | Bike | TDSPHC-AGL----- | 12746.0 | 95.26613 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578673 | 2578673 | 2017-12-23 13:01:37+00:00 | Bike | T--PHC-A------- | 1209.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578674 | 2578674 | 2017-12-24 08:34:29+00:00 | Bike | TDSPHC-AGL----- | 22066.0 | 140.4255 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578675 | 2578675 | 2017-12-25 09:18:35+00:00 | Bike | TDSPH--AGL----- | 8898.0 | 66.70647 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578676 | 2578676 | 2017-12-26 09:38:51+00:00 | Bike | TDSPH--AGL----- | 12470.0 | 94.63577 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578677 | 2578677 | 2017-12-26 13:10:40+00:00 | Bike | T--PHC-A------R | 1280.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578678 | 2578678 | 2017-12-27 09:38:32+00:00 | Bike | T--PH--A------- | 11075.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578679 | 2578679 | 2017-12-28 09:20:07+00:00 | Bike | T--PHC-A------- | 4050.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578680 | 2578680 | 2017-12-28 16:33:26+00:00 | Bike | T--PHC-A------- | 1806.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578681 | 2578681 | 2017-12-29 05:59:22+00:00 | Bike | T--PHC-A------- | 2710.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578683 | 2578683 | 2017-12-30 08:43:27+00:00 | Bike | TDSPHC-AGL----R | 16637.0 | 106.68929 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578684 | 2578684 | 2017-12-31 08:02:19+00:00 | Bike | TDSPHC-AGL----R | 23014.0 | 162.8193 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578685 | 2578685 | 2018-01-01 09:33:53+00:00 | Bike | TDSPHC-AGL----R | 9060.0 | 68.8623 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578686 | 2578686 | 2018-01-02 08:56:24+00:00 | Bike | TDSPHC-AGL----R | 17619.0 | 142.757 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578687 | 2578687 | 2018-01-03 08:18:17+00:00 | Bike | T--PHC-A------- | 3657.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578688 | 2578688 | 2018-01-03 10:57:55+00:00 | Bike | TDSPHC-AGL----- | 8318.0 | 60.8527 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578689 | 2578689 | 2018-01-04 08:59:03+00:00 | Bike | TDSPHC-AGL----R | 15540.0 | 104.691 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578690 | 2578690 | 2018-01-05 08:12:43+00:00 | Bike | TDSPHC-AGL----R | 21856.0 | 148.88139 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578691 | 2578691 | 2018-01-06 06:19:19+00:00 | Bike | T--PHC-A------- | 3305.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578692 | 2578692 | 2018-01-06 08:31:39+00:00 | Bike | TDSPHC-AGL----- | 10170.0 | 69.01111 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578693 | 2578693 | 2018-01-07 07:08:27+00:00 | Bike | TDSPHC-AGL----R | 26274.0 | 166.08788 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578694 | 2578694 | 2018-01-09 11:03:32+00:00 | Bike | TDSPHC-AGL----- | 8380.0 | 57.638 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578695 | 2578695 | 2018-01-10 09:21:40+00:00 | Bike | TDSPHC-AGL----R | 16178.0 | 129.76885 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578696 | 2578696 | 2018-01-11 07:18:08+00:00 | Bike | T--PHC-A------- | 3128.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578697 | 2578697 | 2018-01-11 08:51:20+00:00 | Bike | TDSPHC-AGL----- | 11248.0 | 72.13651 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578698 | 2578698 | 2018-01-12 10:57:42+00:00 | Bike | TDSPHC-AGL----R | 14777.0 | 111.32672 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578699 | 2578699 | 2018-01-13 07:32:28+00:00 | Bike | T--PHC-A------- | 4294.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578700 | 2578700 | 2018-01-13 10:20:44+00:00 | Bike | TDSPHC-AGL----R | 12192.0 | 94.25281 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578701 | 2578701 | 2018-01-14 07:04:26+00:00 | Bike | TDSPHC-AGL----R | 22383.0 | 156.13989 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578702 | 2578702 | 2018-01-15 10:33:43+00:00 | Bike | TDSPHC-AGL----- | 12073.0 | 73.11387 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578703 | 2578703 | 2018-01-16 07:09:54+00:00 | Bike | TDSPHC-AGL----R | 28139.0 | 190.54263 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578704 | 2578704 | 2018-01-17 08:43:41+00:00 | Bike | TDSPHC-AGL----- | 13315.0 | 96.27591 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578705 | 2578705 | 2018-01-19 06:48:50+00:00 | Bike | T--PHC-A------- | 3138.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578706 | 2578706 | 2018-01-19 08:36:25+00:00 | Bike | TDSPHC-AGL----R | 11579.0 | 90.81104 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578707 | 2578707 | 2018-01-20 09:10:59+00:00 | Bike | TDSPHC-AGL----R | 13364.0 | 119.34196 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578708 | 2578708 | 2018-01-21 08:57:40+00:00 | Bike | TDSPHC-AGL----R | 13338.0 | 86.525 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578709 | 2578709 | 2018-01-22 11:59:43+00:00 | Bike | TDSPHC-AGL----- | 8578.0 | 69.88912 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578710 | 2578710 | 2018-01-23 12:17:25+00:00 | Bike | TDSPHC-AGL----- | 9350.0 | 73.01857 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578711 | 2578711 | 2018-01-24 09:42:01+00:00 | Bike | TDSPH--AGL----- | 18658.0 | 133.741 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578712 | 2578712 | 2018-01-25 09:32:28+00:00 | Bike | TDSPHC-AGL----R | 18414.0 | 119.787 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578713 | 2578713 | 2018-01-26 09:15:06+00:00 | Bike | TDSPHC-AGL----R | 19912.0 | 130.12243 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578714 | 2578714 | 2018-01-27 09:15:53+00:00 | Bike | TDSPHC-AGL----R | 21694.0 | 139.907 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578715 | 2578715 | 2018-01-28 07:52:22+00:00 | Bike | TDSPHC-AGL----R | 9267.0 | 70.24056 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578716 | 2578716 | 2018-01-29 04:34:12+00:00 | Bike | T--PHC-A------- | 3611.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578717 | 2578717 | 2018-01-29 12:47:41+00:00 | Bike | TDSPHC-AGL----R | 8906.0 | 66.85389 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578718 | 2578718 | 2018-01-30 13:33:34+00:00 | Bike | TDSPHC-AGL----R | 12316.0 | 96.8157 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578719 | 2578719 | 2018-01-31 13:11:33+00:00 | Bike | TDSPHC-AGL----R | 12559.0 | 96.97684 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578720 | 2578720 | 2018-02-01 08:34:12+00:00 | Bike | TDSPHC-AGL----R | 18327.0 | 136.24641 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578721 | 2578721 | 2018-02-02 11:55:20+00:00 | Bike | TDSPHC-AGL----- | 11079.0 | 87.74909 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578722 | 2578722 | 2018-02-03 06:35:16+00:00 | Bike | TDSPH--AGL----- | 27572.0 | 201.28372 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578723 | 2578723 | 2018-02-05 13:57:34+00:00 | Bike | TDSPH--AGL----- | 10331.0 | 78.34942 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578724 | 2578724 | 2018-02-07 15:59:58+00:00 | Bike | T--PHC-A------- | 5475.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
2578725 | 2578725 | 2018-02-08 10:26:13+00:00 | Bike | TDSPHC-AGL----- | 21135.0 | 142.86873 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578726 | 2578726 | 2018-02-09 12:21:09+00:00 | Bike | TDSPHC-AGL----- | 11733.0 | 90.51074 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578727 | 2578727 | 2018-02-10 11:07:40+00:00 | Bike | TDSPHC-AGL----R | 8005.0 | 55.63889 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578728 | 2578728 | 2018-02-10 14:03:19+00:00 | Bike | TDSPHC-AGL----- | 936.0 | 5.81314 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578729 | 2578729 | 2018-02-10 14:33:08+00:00 | Bike | TDSPH--AGL----- | 5819.0 | 60.7632 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578730 | 2578730 | 2018-02-10 16:23:59+00:00 | Bike | TDSPHC-AGL----- | 6473.0 | 55.76339 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578731 | 2578731 | 2018-02-13 07:39:46+00:00 | Bike | TDSPHC-AGL----- | 21964.0 | 151.83701 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578732 | 2578732 | 2018-02-14 10:09:34+00:00 | Bike | TDSPHC-AGL----- | 21184.0 | 145.30935 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578733 | 2578733 | 2018-02-15 10:38:00+00:00 | Bike | TDSPHC-AGL----- | 13530.0 | 106.04391 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578734 | 2578734 | 2018-02-16 14:09:35+00:00 | Bike | TDSPHC-AGL----- | 8291.0 | 61.31711 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578735 | 2578735 | 2018-02-17 06:17:35+00:00 | Bike | TDSPH--AGL----- | 28152.0 | 173.80918 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
2578736 | 2578736 | 2018-02-18 08:37:17+00:00 | Bike | TDSPHC-AGL----- | 13622.0 | 113.10054 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
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");