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 data descending
This data as json, CSV (advanced)
Link | rowid | date | sport | data ▲ | workout_time | total_distance | athlete |
---|---|---|---|---|---|---|---|
1346085 | 1346085 | 2016-06-23 06:55:57+00:00 | Bike | TDSPHCNAGLWEV-- | 1949.0 | 13.20296 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346086 | 1346086 | 2016-06-23 07:34:00+00:00 | Bike | TDSPHCNAGLWEV-- | 1819.0 | 12.3518 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346092 | 1346092 | 2016-06-25 22:17:00+00:00 | Bike | TDSPHCNAGLWEV-- | 1081.0 | 0.04133 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346093 | 1346093 | 2016-06-25 22:59:06+00:00 | Bike | TDSPHCNAGLWEV-- | 5326.0 | 47.3598 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346102 | 1346102 | 2016-07-02 04:14:36+00:00 | Bike | TDSPHCNAGLWEV-- | 1215.0 | 0.0529 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346103 | 1346103 | 2016-07-02 05:38:56+00:00 | Bike | TDSPHCNAGLWEV-- | 4013.0 | 36.0643 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346105 | 1346105 | 2016-07-02 23:23:35+00:00 | Bike | TDSPHCNAGLWEV-- | 1805.0 | 0.17551 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346106 | 1346106 | 2016-07-03 00:13:55+00:00 | Bike | TDSPHCNAGLWEV-- | 14524.0 | 77.8374 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1346118 | 1346118 | 2016-07-10 23:50:45+00:00 | Bike | TDSPHCNAGLWEV-- | 7446.0 | 51.47745 | {2bf4beac-396c-4b3b-9c59-556a8754491a} |
1426762 | 1426762 | 2016-03-16 07:13:29+00:00 | Bike | TDSPHCNAGLWEV-- | 11457.0 | 90.72802 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426763 | 1426763 | 2016-03-17 11:23:12+00:00 | Bike | TDSPHCNAGLWEV-- | 10540.0 | 82.15645 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426802 | 1426802 | 2016-06-11 08:09:11+00:00 | Bike | TDSPHCNAGLWEV-- | 24155.0 | 186.53335 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426803 | 1426803 | 2016-06-13 15:30:38+00:00 | Bike | TDSPHCNAGLWEV-- | 11005.0 | 87.3081 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426805 | 1426805 | 2016-06-22 16:27:47+00:00 | Bike | TDSPHCNAGLWEV-- | 8631.0 | 79.62686 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426808 | 1426808 | 2016-06-25 08:57:32+00:00 | Bike | TDSPHCNAGLWEV-- | 16002.0 | 122.61728 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426809 | 1426809 | 2016-06-28 17:40:24+00:00 | Bike | TDSPHCNAGLWEV-- | 9041.0 | 84.49275 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426810 | 1426810 | 2016-07-02 07:32:58+00:00 | Bike | TDSPHCNAGLWEV-- | 11571.0 | 87.17714 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426811 | 1426811 | 2016-07-03 12:13:38+00:00 | Bike | TDSPHCNAGLWEV-- | 17149.0 | 133.45097 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1426814 | 1426814 | 2016-07-09 16:03:24+00:00 | Bike | TDSPHCNAGLWEV-- | 12704.0 | 114.04047 | {3a112b2b-947e-411e-9977-32949cfb9cc3} |
1429844 | 1429844 | 2016-02-26 14:26:08+00:00 | Bike | TDSPHCNAGLWEV-- | 9037.0 | 52.9248 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429853 | 1429853 | 2016-03-05 07:02:47+00:00 | Bike | TDSPHCNAGLWEV-- | 15651.0 | 90.2775 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429854 | 1429854 | 2016-03-06 06:17:00+00:00 | Bike | TDSPHCNAGLWEV-- | 17210.0 | 98.6283 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429857 | 1429857 | 2016-03-08 15:45:46+00:00 | Bike | TDSPHCNAGLWEV-- | 10387.0 | 53.4409 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429859 | 1429859 | 2016-03-11 15:20:09+00:00 | Bike | TDSPHCNAGLWEV-- | 10251.0 | 53.16858 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429860 | 1429860 | 2016-03-13 06:17:11+00:00 | Bike | TDSPHCNAGLWEV-- | 18494.0 | 105.215 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429872 | 1429872 | 2016-03-26 07:18:31+00:00 | Bike | TDSPHCNAGLWEV-- | 13373.0 | 87.1475 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429873 | 1429873 | 2016-03-27 05:45:12+00:00 | Bike | TDSPHCNAGLWEV-- | 20615.0 | 116.803 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429879 | 1429879 | 2016-04-02 05:20:56+00:00 | Bike | TDSPHCNAGLWEV-- | 13445.0 | 86.72955 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429880 | 1429880 | 2016-04-03 05:02:18+00:00 | Bike | TDSPHCNAGLWEV-- | 18242.0 | 100.36687 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429886 | 1429886 | 2016-04-09 06:04:28+00:00 | Bike | TDSPHCNAGLWEV-- | 19682.0 | 118.88408 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429887 | 1429887 | 2016-04-10 05:08:33+00:00 | Bike | TDSPHCNAGLWEV-- | 18325.0 | 111.23445 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429889 | 1429889 | 2016-04-13 14:42:06+00:00 | Bike | TDSPHCNAGLWEV-- | 14084.0 | 85.2152 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429891 | 1429891 | 2016-04-15 15:00:35+00:00 | Bike | TDSPHCNAGLWEV-- | 9407.0 | 69.4149 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429892 | 1429892 | 2016-04-16 05:13:42+00:00 | Bike | TDSPHCNAGLWEV-- | 11011.0 | 69.8636 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429897 | 1429897 | 2016-04-22 11:16:22+00:00 | Bike | TDSPHCNAGLWEV-- | 20631.0 | 139.40693 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429903 | 1429903 | 2016-05-03 14:57:17+00:00 | Bike | TDSPHCNAGLWEV-- | 9184.0 | 44.5708 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429904 | 1429904 | 2016-05-04 15:01:06+00:00 | Bike | TDSPHCNAGLWEV-- | 11601.0 | 74.6107 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429905 | 1429905 | 2016-05-05 15:07:15+00:00 | Bike | TDSPHCNAGLWEV-- | 10283.0 | 59.4819 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429907 | 1429907 | 2016-05-08 05:11:35+00:00 | Bike | TDSPHCNAGLWEV-- | 15193.0 | 92.8897 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429909 | 1429909 | 2016-05-11 15:19:51+00:00 | Bike | TDSPHCNAGLWEV-- | 6112.0 | 36.06864 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429911 | 1429911 | 2016-05-12 16:14:53+00:00 | Bike | TDSPHCNAGLWEV-- | 9468.0 | 48.9258 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429912 | 1429912 | 2016-05-14 08:14:29+00:00 | Bike | TDSPHCNAGLWEV-- | 14574.0 | 89.537 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429913 | 1429913 | 2016-05-15 04:53:18+00:00 | Bike | TDSPHCNAGLWEV-- | 22796.0 | 133.159 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429922 | 1429922 | 2016-05-24 14:55:10+00:00 | Bike | TDSPHCNAGLWEV-- | 10735.0 | 69.3514 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429925 | 1429925 | 2016-05-29 04:37:12+00:00 | Bike | TDSPHCNAGLWEV-- | 23766.0 | 151.201 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429926 | 1429926 | 2016-05-31 16:09:35+00:00 | Bike | TDSPHCNAGLWEV-- | 8897.0 | 37.28489 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429928 | 1429928 | 2016-06-02 14:09:30+00:00 | Bike | TDSPHCNAGLWEV-- | 13503.0 | 70.79374 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429929 | 1429929 | 2016-06-05 04:35:11+00:00 | Bike | TDSPHCNAGLWEV-- | 25477.0 | 144.545 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429932 | 1429932 | 2016-06-09 15:22:23+00:00 | Bike | TDSPHCNAGLWEV-- | 11971.0 | 70.73748 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429933 | 1429933 | 2016-06-11 07:06:29+00:00 | Bike | TDSPHCNAGLWEV-- | 11622.0 | 52.8913 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429934 | 1429934 | 2016-06-12 04:44:52+00:00 | Bike | TDSPHCNAGLWEV-- | 20830.0 | 133.57373 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429935 | 1429935 | 2016-06-14 16:04:49+00:00 | Bike | TDSPHCNAGLWEV-- | 12894.0 | 77.69323 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429939 | 1429939 | 2016-06-15 16:36:46+00:00 | Bike | TDSPHCNAGLWEV-- | 9339.0 | 36.40666 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429940 | 1429940 | 2016-06-19 04:39:55+00:00 | Bike | TDSPHCNAGLWEV-- | 21207.0 | 139.298 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429941 | 1429941 | 2016-06-20 13:21:15+00:00 | Bike | TDSPHCNAGLWEV-- | 15284.0 | 111.552 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429942 | 1429942 | 2016-06-24 05:13:07+00:00 | Bike | TDSPHCNAGLWEV-- | 13477.0 | 87.14371 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429943 | 1429943 | 2016-06-25 16:40:58+00:00 | Bike | TDSPHCNAGLWEV-- | 7379.0 | 42.26609 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429944 | 1429944 | 2016-06-26 15:29:46+00:00 | Bike | TDSPHCNAGLWEV-- | 10674.0 | 43.51056 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429945 | 1429945 | 2016-06-27 09:50:27+00:00 | Bike | TDSPHCNAGLWEV-- | 9401.0 | 31.2272 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429946 | 1429946 | 2016-06-27 14:26:02+00:00 | Bike | TDSPHCNAGLWEV-- | 11617.0 | 40.063 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429947 | 1429947 | 2016-06-29 06:48:03+00:00 | Bike | TDSPHCNAGLWEV-- | 30016.0 | 110.603 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429948 | 1429948 | 2016-07-02 05:48:15+00:00 | Bike | TDSPHCNAGLWEV-- | 34245.0 | 175.61533 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429951 | 1429951 | 2016-07-07 16:57:48+00:00 | Bike | TDSPHCNAGLWEV-- | 6923.0 | 30.7048 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429952 | 1429952 | 2016-07-08 08:19:42+00:00 | Bike | TDSPHCNAGLWEV-- | 13126.0 | 68.159 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429953 | 1429953 | 2016-07-09 06:05:41+00:00 | Bike | TDSPHCNAGLWEV-- | 30919.0 | 162.801 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429959 | 1429959 | 2016-07-24 04:17:32+00:00 | Bike | TDSPHCNAGLWEV-- | 22859.0 | 139.76136 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1429994 | 1429994 | 2016-10-02 05:31:51+00:00 | Bike | TDSPHCNAGLWEV-- | 19189.0 | 119.08 | {c28589ec-0f48-42fd-bb68-749dd04c21f6} |
1449165 | 1449165 | 2016-10-05 16:28:33+00:00 | Bike | TDSPHCNAGLWEV-- | 6831.0 | 51.2439 | {895a4257-6f49-4e99-bec9-0b0ffe538c10} |
1545265 | 1545265 | 2019-09-23 10:26:17+00:00 | TDSPHCNAGLWEV-- | 7882.0 | 62.23076 | {9e5c160d-0301-4319-a128-aad95b52e189} | |
1545266 | 1545266 | 2019-09-24 15:52:32+00:00 | TDSPHCNAGLWEV-- | 12364.0 | 68.6263 | {9e5c160d-0301-4319-a128-aad95b52e189} | |
1545290 | 1545290 | 2019-10-18 09:06:48+00:00 | TDSPHCNAGLWEV-- | 7887.0 | 66.13586 | {9e5c160d-0301-4319-a128-aad95b52e189} | |
1545292 | 1545292 | 2019-10-20 08:32:29+00:00 | TDSPHCNAGLWEV-- | 8858.0 | 60.49494 | {9e5c160d-0301-4319-a128-aad95b52e189} | |
1545312 | 1545312 | 2019-11-18 08:42:59+00:00 | Carretera | TDSPHCNAGLWEV-- | 12886.0 | 103.04361 | {9e5c160d-0301-4319-a128-aad95b52e189} |
1545315 | 1545315 | 2019-11-22 11:23:53+00:00 | Carretera | TDSPHCNAGLWEV-- | 14361.0 | 100.9746 | {9e5c160d-0301-4319-a128-aad95b52e189} |
1892572 | 1892572 | 2016-03-12 22:36:06+00:00 | Bike | TDSPHCNAGLWEV-- | 18622.0 | 100.17646 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892585 | 1892585 | 2016-03-20 00:11:09+00:00 | Bike | TDSPHCNAGLWEV-- | 1443.0 | 0.83515 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892586 | 1892586 | 2016-03-20 00:49:07+00:00 | 0 | TDSPHCNAGLWEV-- | 2178.0 | 16.9772 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892587 | 1892587 | 2016-03-22 01:48:24+00:00 | Bike | TDSPHCNAGLWEV-- | 33590.0 | 204.052 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892596 | 1892596 | 2016-03-26 06:39:18+00:00 | Bike | TDSPHCNAGLWEV-- | 8001.0 | 46.44519 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892598 | 1892598 | 2016-03-26 22:24:15+00:00 | Bike | TDSPHCNAGLWEV-- | 18813.0 | 97.41181 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892617 | 1892617 | 2016-04-03 04:58:16+00:00 | Bike | TDSPHCNAGLWEV-- | 9625.0 | 53.2154 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892652 | 1892652 | 2016-04-17 04:12:40+00:00 | Bike | TDSPHCNAGLWEV-- | 3001.0 | 23.75268 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892711 | 1892711 | 2016-05-18 11:18:42+00:00 | Bike | TDSPHCNAGLWEV-- | 7885.0 | 40.51025 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892717 | 1892717 | 2016-05-21 02:48:56+00:00 | Bike | TDSPHCNAGLWEV-- | 20032.0 | 116.4509 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892718 | 1892718 | 2016-05-21 22:28:21+00:00 | Bike | TDSPHCNAGLWEV-- | 19008.0 | 96.28767 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892722 | 1892722 | 2016-05-24 10:38:51+00:00 | Bike | TDSPHCNAGLWEV-- | 1952.0 | 12.14628 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892726 | 1892726 | 2016-05-26 10:55:07+00:00 | Bike | TDSPHCNAGLWEV-- | 1922.0 | 11.9397 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892730 | 1892730 | 2016-05-28 05:58:27+00:00 | Bike | TDSPHCNAGLWEV-- | 7885.0 | 78.0664 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892731 | 1892731 | 2016-05-29 01:56:42+00:00 | Bike | TDSPHCNAGLWEV-- | 1382.0 | 0.0055 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892732 | 1892732 | 2016-05-29 02:58:35+00:00 | Bike | TDSPHCNAGLWEV-- | 9231.0 | 86.4919 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892754 | 1892754 | 2016-06-11 23:02:17+00:00 | Bike | TDSPHCNAGLWEV-- | 1880.0 | 15.2575 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892755 | 1892755 | 2016-06-11 23:39:55+00:00 | Bike | TDSPHCNAGLWEV-- | 2520.0 | 0.49502 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892756 | 1892756 | 2016-06-12 00:53:09+00:00 | Bike | TDSPHCNAGLWEV-- | 1067.0 | 10.7696 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892771 | 1892771 | 2016-06-23 06:55:57+00:00 | Bike | TDSPHCNAGLWEV-- | 1949.0 | 13.20296 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892772 | 1892772 | 2016-06-23 07:34:00+00:00 | Bike | TDSPHCNAGLWEV-- | 1819.0 | 12.3518 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892779 | 1892779 | 2016-06-25 22:17:00+00:00 | Bike | TDSPHCNAGLWEV-- | 1081.0 | 0.04133 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892780 | 1892780 | 2016-06-25 22:59:06+00:00 | Bike | TDSPHCNAGLWEV-- | 5326.0 | 47.3598 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892789 | 1892789 | 2016-07-02 04:14:36+00:00 | Bike | TDSPHCNAGLWEV-- | 1215.0 | 0.0529 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892790 | 1892790 | 2016-07-02 05:38:56+00:00 | Bike | TDSPHCNAGLWEV-- | 4013.0 | 36.0643 | {dabde884-825f-4257-bce2-feb184be5f4f} |
1892792 | 1892792 | 2016-07-02 23:23:35+00:00 | Bike | TDSPHCNAGLWEV-- | 1805.0 | 0.17551 | {dabde884-825f-4257-bce2-feb184be5f4f} |
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");