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 |
|---|---|---|---|---|---|---|---|
| 6883 | 6883 | 2018-08-24 06:58:49+00:00 | TDSPHC-----E--- | 3324.0 | 21.62113 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6884 | 6884 | 2018-08-30 06:32:35+00:00 | TDSPHC-----E--- | 3312.0 | 21.498 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6885 | 6885 | 2018-09-04 07:37:16+00:00 | TDSPHC-----E--- | 3600.0 | 21.1311 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6886 | 6886 | 2018-09-12 06:21:41+00:00 | TDSPHC-----E--- | 3600.0 | 22.8555 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6887 | 6887 | 2018-09-20 10:50:12+00:00 | TDSPHC-----E--- | 3420.0 | 20.0508 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6888 | 6888 | 2018-09-24 08:36:10+00:00 | TDSPHC-----E--- | 3599.0 | 22.3082 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6889 | 6889 | 2018-09-27 11:08:38+00:00 | TDSPHC-----E--- | 3599.0 | 22.0396 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6890 | 6890 | 2018-10-02 08:05:57+00:00 | TDSPHC-----E--- | 3600.0 | 22.6769 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6891 | 6891 | 2018-10-05 09:22:45+00:00 | TDSPHC-----E--- | 3599.0 | 21.87886 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6892 | 6892 | 2018-10-09 10:18:47+00:00 | TDSPHC-----E--- | 633.0 | 2.15716 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6893 | 6893 | 2018-10-09 10:30:40+00:00 | TDSPHC-----E--- | 3600.0 | 22.5413 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6894 | 6894 | 2018-10-22 08:42:24+00:00 | TDSPHC-----E--- | 2620.0 | 15.492 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6895 | 6895 | 2018-10-24 11:42:59+00:00 | TDSPHC-----E--- | 2820.0 | 17.55909 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6896 | 6896 | 2018-10-26 14:21:43+00:00 | TDSPHC-----E--- | 3599.0 | 22.3576 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6897 | 6897 | 2018-10-29 09:53:54+00:00 | TDSPHC-----E--- | 3600.0 | 22.2631 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6898 | 6898 | 2018-11-01 07:43:50+00:00 | TDSPHC-----E--- | 3600.0 | 21.9503 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6899 | 6899 | 2018-11-06 08:10:25+00:00 | TDSPHC-----E--- | 2500.0 | 15.4605 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6900 | 6900 | 2018-11-08 12:19:54+00:00 | TDSPHC-----E--- | 2929.0 | 18.2621 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6901 | 6901 | 2018-11-11 09:37:46+00:00 | TDSPHC-----E--- | 4874.0 | 30.1089 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6902 | 6902 | 2018-11-13 09:30:59+00:00 | TDSPHC-----E--- | 3600.0 | 22.7018 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6903 | 6903 | 2018-11-15 09:24:05+00:00 | TDSPHC-----E--- | 3599.0 | 22.6485 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6904 | 6904 | 2018-11-17 10:45:25+00:00 | TDSPH------E--- | 4874.0 | 29.9832 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6905 | 6905 | 2018-11-20 08:03:32+00:00 | TDSPH------E--- | 3610.0 | 23.1182 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6906 | 6906 | 2018-11-22 08:24:25+00:00 | TDSPHC-----E--- | 2830.0 | 17.4722 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6907 | 6907 | 2018-11-25 09:30:57+00:00 | TDSPHC-----E--- | 4874.0 | 31.1212 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6908 | 6908 | 2018-11-26 12:56:51+00:00 | TDSPHC-----E--- | 3600.0 | 21.9999 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6909 | 6909 | 2018-11-28 06:59:58+00:00 | TDSPHC-----E--- | 2999.0 | 19.2773 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6910 | 6910 | 2018-12-01 10:08:56+00:00 | TDSPHC-----E--- | 5099.0 | 32.2559 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6911 | 6911 | 2018-12-06 09:42:43+00:00 | TDSPHC-----E--- | 3539.0 | 22.31683 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6912 | 6912 | 2018-12-11 08:56:43+00:00 | TDSPHC-----E--- | 4875.0 | 29.5232 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6913 | 6913 | 2018-12-14 08:30:12+00:00 | TDSPHC-----E--- | 4875.0 | 29.66445 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6914 | 6914 | 2018-12-17 12:06:28+00:00 | TDSPH------E--- | 3600.0 | 23.0812 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6915 | 6915 | 2018-12-19 08:15:13+00:00 | TDSPHC-----E--- | 3600.0 | 22.5053 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6916 | 6916 | 2018-12-21 09:12:44+00:00 | TDSPHC-----E--- | 5098.0 | 31.9004 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6917 | 6917 | 2018-12-23 09:33:45+00:00 | TDSPHC-----E--- | 4649.0 | 30.63 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6918 | 6918 | 2018-12-27 09:26:36+00:00 | TDSPHC-----E--- | 3600.0 | 22.9952 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6919 | 6919 | 2019-01-01 11:08:21+00:00 | TDSPHC-----E--- | 3600.0 | 22.9721 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6920 | 6920 | 2019-01-03 11:20:30+00:00 | TDSPHC-----E--- | 1019.0 | 6.34673 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6921 | 6921 | 2019-01-05 16:15:08+00:00 | TDSPHC-----E--- | 5099.0 | 32.1348 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6922 | 6922 | 2019-01-07 09:41:45+00:00 | TDSPHC-----E--- | 3557.0 | 23.20552 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6923 | 6923 | 2019-01-08 10:23:24+00:00 | TDSPHC-----E--- | 3600.0 | 23.26991 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6924 | 6924 | 2019-01-11 09:38:29+00:00 | TDSPHC-----E--- | 3599.0 | 22.985 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6925 | 6925 | 2019-01-13 09:27:24+00:00 | TDSPHC-----E--- | 5100.0 | 33.02804 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6926 | 6926 | 2019-01-16 08:37:21+00:00 | TDSPHC-----E--- | 2400.0 | 15.4525 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6927 | 6927 | 2019-01-19 15:33:42+00:00 | TDSPHC-----E--- | 2744.0 | 16.6324 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6928 | 6928 | 2019-01-21 08:23:08+00:00 | TDSPHC-----E--- | 3600.0 | 22.78443 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6929 | 6929 | 2019-01-23 08:52:08+00:00 | TDSPHC-----E--- | 1803.0 | 11.3101 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6930 | 6930 | 2019-01-28 08:33:02+00:00 | TDSPHC-----E--- | 3599.0 | 22.3801 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6931 | 6931 | 2019-01-30 08:46:18+00:00 | TDSPH------E--- | 2402.0 | 15.451 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6932 | 6932 | 2019-02-04 08:20:26+00:00 | TDSPHC-----E--- | 3600.0 | 22.5484 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6933 | 6933 | 2019-02-04 17:58:40+00:00 | TDSPHC-----E--- | 1802.0 | 11.69775 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6934 | 6934 | 2019-02-07 07:51:28+00:00 | TDSPHC-----E--- | 3600.0 | 22.9645 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6935 | 6935 | 2019-02-08 13:10:23+00:00 | TDSPHC-----E--- | 1810.0 | 11.6081 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6936 | 6936 | 2019-02-09 11:02:37+00:00 | TDSPHC-----E--- | 5099.0 | 32.9611 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6937 | 6937 | 2019-02-10 11:38:09+00:00 | TDSPH------E--- | 1803.0 | 11.3775 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6938 | 6938 | 2019-02-17 09:56:57+00:00 | TDSPHC-----E--- | 3600.0 | 22.9463 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6939 | 6939 | 2019-02-20 08:12:21+00:00 | TDSPHC-----E--- | 2401.0 | 14.9654 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6940 | 6940 | 2019-02-21 07:14:22+00:00 | TDSPHC-----E--- | 2100.0 | 13.08195 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6941 | 6941 | 2019-02-26 11:03:02+00:00 | TDSPHC-----E--- | 3600.0 | 22.7587 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6942 | 6942 | 2019-03-07 07:56:02+00:00 | TDSPHC-----E--- | 2270.0 | 14.4047 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6943 | 6943 | 2019-03-08 07:49:36+00:00 | TDSPHC-----E--- | 1877.0 | 11.4167 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6944 | 6944 | 2019-03-11 07:47:30+00:00 | TDSPHC--------- | 2404.0 | 15.3651 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6945 | 6945 | 2019-03-13 07:08:38+00:00 | TDSPHC--------- | 3001.0 | 19.1637 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6946 | 6946 | 2019-03-14 07:30:38+00:00 | TDSPHC--------- | 3600.0 | 22.5783 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6947 | 6947 | 2019-03-15 07:50:16+00:00 | TDSPHC--------- | 1805.0 | 9.61716 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6948 | 6948 | 2019-03-18 07:54:13+00:00 | TDSPHC--------- | 3359.0 | 21.1932 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6949 | 6949 | 2019-03-20 07:25:49+00:00 | TDSPHC--------- | 1805.0 | 11.4478 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6950 | 6950 | 2019-03-21 08:26:25+00:00 | TDSPHC--------- | 3599.0 | 22.6471 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6951 | 6951 | 2019-03-22 07:41:58+00:00 | TDSPHC--------- | 1805.0 | 11.52827 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6952 | 6952 | 2019-03-23 08:02:20+00:00 | TDSPHC--------- | 4874.0 | 30.7626 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6953 | 6953 | 2019-03-25 07:59:46+00:00 | TDSPHC--------- | 1805.0 | 11.2613 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6954 | 6954 | 2019-03-26 08:12:48+00:00 | TDSPHC--------- | 3799.0 | 25.6936 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6955 | 6955 | 2019-03-28 08:10:51+00:00 | TDSPHC--------- | 3599.0 | 22.7835 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6956 | 6956 | 2019-03-30 08:20:01+00:00 | TDSPHC--------- | 4875.0 | 30.1055 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6957 | 6957 | 2019-04-03 07:03:43+00:00 | TDSPHC--------- | 3360.0 | 21.3299 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6958 | 6958 | 2019-04-04 07:19:05+00:00 | TDSPHC--------- | 3599.0 | 22.90631 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6959 | 6959 | 2019-04-06 07:52:48+00:00 | TDSPHC--------- | 5099.0 | 31.897 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6960 | 6960 | 2019-04-09 07:05:36+00:00 | TDSPHC--------- | 3479.0 | 22.194 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6961 | 6961 | 2019-04-10 07:16:54+00:00 | TDSPHC--------- | 3600.0 | 22.7344 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6962 | 6962 | 2019-04-16 06:07:58+00:00 | TDSPHC--------- | 1800.0 | 11.204 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6963 | 6963 | 2019-04-16 12:55:25+00:00 | TDSPHC--------- | 2830.0 | 17.99452 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6964 | 6964 | 2019-04-18 06:48:48+00:00 | TDSPHC--------- | 3719.0 | 23.6607 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6965 | 6965 | 2019-04-20 13:19:56+00:00 | TDSPHC--------- | 5100.0 | 32.6385 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6966 | 6966 | 2019-04-24 07:57:29+00:00 | TDSPHC--------- | 3560.0 | 23.0548 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6967 | 6967 | 2019-05-06 07:10:12+00:00 | TDSPHC--------- | 3320.0 | 21.0954 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6968 | 6968 | 2019-05-08 06:56:39+00:00 | TDSPHC--------- | 3719.0 | 23.7942 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6969 | 6969 | 2019-05-09 07:31:37+00:00 | TDSPHC--------- | 1804.0 | 11.5313 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6970 | 6970 | 2019-05-13 06:59:25+00:00 | TDSPHC--------- | 3499.0 | 22.3716 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6971 | 6971 | 2019-05-15 07:44:50+00:00 | TDSPHC--------- | 3719.0 | 23.53433 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6972 | 6972 | 2019-05-16 08:34:33+00:00 | TDSPHC--------- | 4874.0 | 31.1934 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6973 | 6973 | 2019-05-18 12:50:06+00:00 | TDSPHC--------- | 1816.0 | 11.6273 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6974 | 6974 | 2019-05-20 06:48:11+00:00 | TDSPHC--------- | 1810.0 | 11.4389 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6975 | 6975 | 2019-05-21 06:59:13+00:00 | TDSPHC--------- | 3599.0 | 23.0448 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6976 | 6976 | 2019-05-23 07:49:44+00:00 | TDSPHC--------- | 3719.0 | 23.6804 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6977 | 6977 | 2019-05-25 14:20:21+00:00 | TDSPHC--------- | 1804.0 | 11.6376 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6978 | 6978 | 2019-05-27 06:57:05+00:00 | TDSPHC--------- | 1803.0 | 11.49057 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6979 | 6979 | 2019-05-29 07:43:09+00:00 | TDSPHC--------- | 3600.0 | 22.9212 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6980 | 6980 | 2019-06-03 08:05:22+00:00 | TDSPHC--------- | 2769.0 | 17.7023 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6981 | 6981 | 2019-06-04 06:48:24+00:00 | TDSPHC--------- | 1954.0 | 12.5319 | {dedad338-12be-45f6-8316-5258e560a5fe} | |
| 6982 | 6982 | 2019-06-06 11:20:46+00:00 | TDSPHC--------- | 2851.0 | 18.25762 | {dedad338-12be-45f6-8316-5258e560a5fe} |
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");