rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by athlete descending
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance | athlete ▲ |
|---|---|---|---|---|---|---|---|
| 1135277 | 1135277 | 2020-04-09 05:40:45+00:00 | Bike | TDSPHC-AGL----- | 3159.0 | 24.1394 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135278 | 1135278 | 2020-04-10 06:01:13+00:00 | Bike | TDSPHC-A-L----- | 6198.0 | 38.4654 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135279 | 1135279 | 2020-04-11 05:46:47+00:00 | Bike | TDSPHC-AGL----- | 2786.0 | 21.1825 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135280 | 1135280 | 2020-04-12 06:02:07+00:00 | Bike | TDSPHC-A-L----- | 4909.0 | 39.0683 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135281 | 1135281 | 2020-04-13 17:00:44+00:00 | Bike | TDSPHC-A-L----- | 4889.0 | 33.0395 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135282 | 1135282 | 2020-04-14 15:43:12+00:00 | Bike | TDSPHC-AGL----- | 2001.0 | 16.0546 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135283 | 1135283 | 2020-04-16 15:41:51+00:00 | Bike | TDSPHC-AGL----- | 3972.0 | 30.2342 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135284 | 1135284 | 2020-04-18 05:58:40+00:00 | Bike | TDSPHC-A-L----- | 5522.0 | 32.8041 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135285 | 1135285 | 2020-04-19 06:21:57+00:00 | Bike | TDSP-C-AGL----- | 3370.0 | 28.6048 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135286 | 1135286 | 2020-04-20 15:24:21+00:00 | Bike | TDSPHC-AGL----- | 3133.0 | 26.3525 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135287 | 1135287 | 2020-04-22 16:34:02+00:00 | Bike | TDSPHC-----E--- | 3609.0 | 27.2706 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135288 | 1135288 | 2020-04-24 16:34:14+00:00 | Bike | TDSPHC-AGL----- | 3045.0 | 26.5913 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135289 | 1135289 | 2020-04-25 05:53:25+00:00 | Bike | TDSPHC-----E--- | 3972.0 | 23.2011 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135290 | 1135290 | 2020-04-25 06:19:44+00:00 | Bike | TDSPHC-AGL----- | 2744.0 | 17.0826 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135291 | 1135291 | 2020-04-26 04:45:47+00:00 | Bike | TDSPHC-AGL----- | 3835.0 | 27.9579 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135292 | 1135292 | 2020-04-27 15:57:31+00:00 | Bike | TDSPHC-AGL----- | 2385.0 | 21.1113 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135293 | 1135293 | 2020-04-29 15:22:25+00:00 | Bike | TDSPHC-AGL----- | 2879.0 | 21.5308 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135294 | 1135294 | 2020-05-01 05:38:36+00:00 | Bike | TDSPHC-AGL----- | 3034.0 | 22.7166 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1135295 | 1135295 | 2020-05-01 06:31:17+00:00 | Bike | TDSPHC-AGL----- | 1249.0 | 10.649 | {fff1d0ee-c37d-4955-99a5-e3e963e1a461} |
| 1204925 | 1204925 | 2018-12-03 19:52:34+00:00 | Bike | TDSPHC-A-L-EV-- | 2088.0 | 13.8061 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204926 | 1204926 | 2018-12-06 09:56:57+00:00 | Bike | TDSPHC-A-L-EV-- | 3880.0 | 23.5149 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204927 | 1204927 | 2018-12-08 09:24:36+00:00 | Bike | TDSPHC-AGL-EV-- | 8986.0 | 66.88576 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204928 | 1204928 | 2018-12-09 18:56:36+00:00 | Bike | TDSPHC-A-L-EV-- | 2764.0 | 14.8254 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204929 | 1204929 | 2018-12-12 09:28:04+00:00 | Bike | TDSPHC-AGL-EV-- | 6906.0 | 49.30815 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204930 | 1204930 | 2018-12-16 19:12:35+00:00 | Bike | TDSPHC-A-L-EV-- | 2224.0 | 11.11393 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204931 | 1204931 | 2018-12-19 10:05:47+00:00 | Bike | TDSPHC-A-L-EV-- | 3628.0 | 20.10278 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204932 | 1204932 | 2018-12-22 08:12:51+00:00 | Bike | TDSPHC-AGL-EV-- | 11414.0 | 83.27757 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204933 | 1204933 | 2018-12-27 18:30:12+00:00 | Bike | TDSPHC-A-L-EV-- | 3059.0 | 3.32922 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204934 | 1204934 | 2018-12-28 18:36:49+00:00 | Bike | TDSPHC-A-L-EV-- | 2744.0 | 21.7981 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204935 | 1204935 | 2018-12-30 08:45:19+00:00 | Bike | TDSPHC-AGL-EV-- | 10610.0 | 64.47404 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204936 | 1204936 | 2018-12-31 18:40:06+00:00 | Bike | TDSPHC-A-L-EV-- | 3084.0 | 17.2622 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204937 | 1204937 | 2019-01-04 17:49:51+00:00 | Bike | TDSPHC-A-L-EV-- | 3056.0 | 20.45992 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204938 | 1204938 | 2019-01-06 19:24:10+00:00 | Bike | TDSPHC-A-L-EV-- | 2370.0 | 14.7665 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204939 | 1204939 | 2019-01-06 20:05:16+00:00 | Bike | TDSPHC-A-L-EV-- | 717.0 | 5.74419 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204940 | 1204940 | 2019-01-07 19:46:10+00:00 | Bike | TDSPHC-A-L-EV-- | 2595.0 | 12.677 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204941 | 1204941 | 2019-01-09 10:23:10+00:00 | Bike | TDSPHC-A-L-EV-- | 3191.0 | 21.68625 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204942 | 1204942 | 2019-01-12 10:00:45+00:00 | Bike | TDSPHC-A-L-EV-- | 4595.0 | 27.49597 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204943 | 1204943 | 2019-01-13 09:12:32+00:00 | Bike | TDSPHC-AGL-EV-- | 10961.0 | 77.05934 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204944 | 1204944 | 2019-01-14 19:45:35+00:00 | Bike | TDSPHC-A-L-EV-- | 3283.0 | 17.81726 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204945 | 1204945 | 2019-01-15 19:19:49+00:00 | Bike | TDSPHC-A-L-EV-- | 2932.0 | 16.0659 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204946 | 1204946 | 2019-01-19 09:38:22+00:00 | Bike | TDSPHC-A-L-EV-- | 5786.0 | 42.82211 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204947 | 1204947 | 2019-01-20 17:58:47+00:00 | Bike | TDSPHC-A-L-EV-- | 2982.0 | 15.55067 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204948 | 1204948 | 2019-01-24 19:05:51+00:00 | Bike | TDSPHC-A-L-EV-- | 3522.0 | 20.65097 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204949 | 1204949 | 2019-01-26 08:00:48+00:00 | Bike | TDSPHC-AGL-EV-- | 14514.0 | 102.95821 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204950 | 1204950 | 2019-01-27 18:30:30+00:00 | Bike | TDSPHC-A-L-EV-- | 2831.0 | 10.7652 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204951 | 1204951 | 2019-01-28 19:10:24+00:00 | Bike | TDSPHC-A-L-EV-- | 3838.0 | 27.44482 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204952 | 1204952 | 2019-01-30 10:57:35+00:00 | Bike | TDSPHC-A-L-EV-- | 3219.0 | 18.585 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204953 | 1204953 | 2019-01-31 10:30:27+00:00 | Bike | TDSPHC-A-L-EV-- | 3586.0 | 25.77977 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204954 | 1204954 | 2019-02-02 17:50:32+00:00 | Bike | TDSPHC-A-L-EV-- | 3502.0 | 25.97533 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204955 | 1204955 | 2019-02-03 17:14:30+00:00 | Bike | TDSPHC-A-L-EV-- | 4288.0 | 31.76149 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204956 | 1204956 | 2019-02-06 11:24:02+00:00 | Bike | TDSPHC-A-L-EV-- | 2611.0 | 14.47624 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204957 | 1204957 | 2019-02-07 10:45:23+00:00 | Bike | TDSPHC-A-L-EV-- | 3347.0 | 25.16837 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204958 | 1204958 | 2019-02-08 10:19:43+00:00 | Bike | TDSPHC-A-L-EV-- | 4247.0 | 25.43097 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204959 | 1204959 | 2019-02-09 08:23:35+00:00 | Bike | TDSPHC-A-L-EV-- | 8470.0 | 57.23936 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204960 | 1204960 | 2019-02-11 18:59:05+00:00 | Bike | TDSPHC-A-L-EV-- | 3135.0 | 25.47957 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204961 | 1204961 | 2019-02-13 19:52:52+00:00 | Bike | TDSPHC-A-L-EV-- | 1637.0 | 11.89587 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204962 | 1204962 | 2019-02-14 10:56:31+00:00 | Bike | TDSPHC-A-L-EV-- | 2159.0 | 11.94039 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204963 | 1204963 | 2019-02-15 10:43:43+00:00 | Bike | TDSPHC-A-L-EV-- | 6928.0 | 55.02923 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204964 | 1204964 | 2019-02-16 18:23:30+00:00 | Bike | TDSPHC-A-L-EV-- | 3442.0 | 25.36775 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204965 | 1204965 | 2019-02-17 08:47:25+00:00 | Bike | TDSPHC-AGL-EV-- | 15175.0 | 90.67256 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204966 | 1204966 | 2019-02-18 19:10:55+00:00 | Bike | TDSPHC-A-L-EV-- | 2634.0 | 16.58229 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204967 | 1204967 | 2019-02-19 11:48:49+00:00 | Bike | TDSPHC-A-L-EV-- | 4183.0 | 25.33512 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204968 | 1204968 | 2019-02-20 19:38:17+00:00 | Bike | TDSPHC-A-L-EV-- | 3772.0 | 27.25769 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204969 | 1204969 | 2019-02-23 08:54:59+00:00 | Bike | TDSPHC-AGL-EV-- | 8875.0 | 64.72271 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204970 | 1204970 | 2019-02-25 18:36:43+00:00 | Bike | TDSPHC-A-L-EV-- | 3649.0 | 28.4781 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204971 | 1204971 | 2019-02-26 11:37:53+00:00 | Bike | TDSPHC-A-L-EV-- | 4007.0 | 23.89245 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204972 | 1204972 | 2019-02-27 10:25:02+00:00 | Bike | TDSPHC-A-L-EV-- | 6173.0 | 40.42484 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204973 | 1204973 | 2019-03-01 10:09:00+00:00 | Bike | TDSPHC-AGL-EV-- | 8069.0 | 65.69648 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204974 | 1204974 | 2019-03-01 18:38:43+00:00 | Bike | TDSPHC-A-L-EV-- | 3353.0 | 27.21815 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204975 | 1204975 | 2019-03-02 08:35:16+00:00 | Bike | TDSPHC-AGL-EV-- | 10639.0 | 81.35111 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204976 | 1204976 | 2019-03-03 08:43:57+00:00 | Bike | TDSPHC-AGL-EV-- | 12893.0 | 86.40038 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204977 | 1204977 | 2019-03-05 11:45:38+00:00 | Bike | TDSPHC-A-L-EV-- | 3020.0 | 18.2732 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204978 | 1204978 | 2019-03-06 10:47:03+00:00 | Bike | TDSPHC-A-L-EV-- | 4497.0 | 34.849 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204979 | 1204979 | 2019-03-07 10:51:55+00:00 | Bike | TDSPHC-A-L-EV-- | 3037.0 | 22.54178 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204980 | 1204980 | 2019-03-09 08:46:20+00:00 | Bike | TDSPHC-AGL-EV-- | 12213.0 | 96.52749 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204981 | 1204981 | 2019-03-10 08:49:33+00:00 | Bike | TDSPHC-AGL-EV-- | 10758.0 | 77.83649 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204982 | 1204982 | 2019-03-12 11:17:20+00:00 | Bike | TDSPHC-AGL-EV-- | 3217.0 | 23.91178 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204983 | 1204983 | 2019-03-13 17:42:54+00:00 | Bike | TDSPHC-A-L-EV-- | 3598.0 | 23.37534 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204984 | 1204984 | 2019-03-15 09:23:51+00:00 | Bike | TDSPHC-A-L-EV-- | 4475.0 | 34.02567 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204985 | 1204985 | 2019-03-16 07:48:15+00:00 | Bike | TDSPHC-AGL-EV-- | 13466.0 | 100.63462 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204986 | 1204986 | 2019-03-18 18:47:53+00:00 | Bike | TDSPHC-A-L-EV-- | 3803.0 | 29.03669 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204987 | 1204987 | 2019-03-20 11:12:44+00:00 | Bike | TDSPHC-A-L-EV-- | 3419.0 | 19.85131 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204988 | 1204988 | 2019-03-21 11:03:13+00:00 | Bike | TDSPHC-A-L-EV-- | 5015.0 | 24.80731 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204989 | 1204989 | 2019-03-23 09:13:41+00:00 | Bike | TDSPHC-A-L-EV-- | 7306.0 | 57.12817 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204990 | 1204990 | 2019-03-24 08:13:57+00:00 | Bike | TDSPHC-AGL-EV-- | 11466.0 | 76.26051 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204991 | 1204991 | 2019-03-25 18:59:13+00:00 | Bike | TDSPHC-A-L-EV-- | 2881.0 | 19.6754 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204992 | 1204992 | 2019-03-26 16:48:15+00:00 | Bike | TDSPHC-AGL-EV-- | 6070.0 | 54.8243 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204993 | 1204993 | 2019-03-30 07:40:41+00:00 | Bike | TDSPHC-AGL-EV-- | 14959.0 | 106.83041 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204994 | 1204994 | 2019-04-01 18:48:01+00:00 | Bike | TDSPHC-A-L-EV-- | 4351.0 | 29.54683 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204995 | 1204995 | 2019-04-02 17:54:41+00:00 | Bike | TDSPHC-A-L-EV-- | 3534.0 | 26.74601 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204996 | 1204996 | 2019-04-04 19:23:30+00:00 | Bike | TDSPHC-A-L-EV-- | 2409.0 | 12.7292 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204997 | 1204997 | 2019-04-05 10:49:04+00:00 | Bike | TDSPHC-A-L-EV-- | 3801.0 | 30.14316 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204998 | 1204998 | 2019-04-06 09:52:23+00:00 | Bike | TDSPHC-A-L-EV-- | 7979.0 | 62.22566 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1204999 | 1204999 | 2019-04-06 12:07:26+00:00 | Bike | TDSPHC-A-L-EV-- | 3280.0 | 27.6096 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1205000 | 1205000 | 2019-04-07 10:36:01+00:00 | Bike | TDSPHC-A-L-EV-- | 3716.0 | 21.90607 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1205001 | 1205001 | 2019-04-08 19:31:55+00:00 | Bike | TDSPHC-A-L-EV-- | 2786.0 | 16.71704 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1205002 | 1205002 | 2019-04-12 10:55:54+00:00 | Bike | TDSPHC-A-L-EV-- | 3228.0 | 18.93607 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1205003 | 1205003 | 2019-04-13 08:19:46+00:00 | Bike | TDSPHC-AGL-EV-- | 12364.0 | 94.24958 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1205004 | 1205004 | 2019-04-15 07:33:10+00:00 | Bike | TDSPHC-AGL-EV-- | 15238.0 | 91.2254 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
| 1205005 | 1205005 | 2019-04-18 10:46:31+00:00 | Bike | TDSPHC-A-L-EV-- | 2998.0 | 21.03451 | {ffea5c2b-1898-4cbd-8fb4-64502aa4e962} |
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");