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
This data as json, CSV (advanced)
| Link | rowid | date | sport | data ▼ | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 1743821 | 1743821 | 2019-01-31 20:11:17+00:00 | Bike | ---PH---------- | 1.0 | {28370ae4-e020-4965-a12c-44c0bda6f353} | |
| 1480096 | 1480096 | 2016-11-13 05:07:24+00:00 | Bike | ---PH---G--E--- | 1.0 | {13f64d1c-6c50-46fb-995e-f13bfaacb9b6} | |
| 1292281 | 1292281 | 2018-08-16 08:24:30+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292348 | 1292348 | 2018-11-08 19:03:04+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292356 | 1292356 | 2018-11-18 10:37:57+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292386 | 1292386 | 2018-12-29 10:44:24+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292387 | 1292387 | 2018-12-30 10:10:29+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292388 | 1292388 | 2018-12-31 09:42:58+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292390 | 1292390 | 2019-01-01 10:37:09+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292391 | 1292391 | 2019-01-02 19:42:44+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292417 | 1292417 | 2019-02-04 20:00:35+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292419 | 1292419 | 2019-02-05 20:20:00+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292462 | 1292462 | 2019-04-06 12:52:45+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292463 | 1292463 | 2019-04-06 13:11:23+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 2223060 | 2223060 | 2016-12-29 16:58:20+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223062 | 2223062 | 2017-01-09 12:01:54+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223065 | 2223065 | 2017-01-13 15:21:44+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223066 | 2223066 | 2017-01-23 14:27:12+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223068 | 2223068 | 2017-01-25 14:11:57+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223072 | 2223072 | 2017-01-31 11:18:10+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223080 | 2223080 | 2017-02-13 12:56:22+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223084 | 2223084 | 2017-02-21 09:52:53+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223193 | 2223193 | 2017-09-12 07:25:20+00:00 | Ride | ---PH--A------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2128914 | 2128914 | 2018-05-20 08:12:51+00:00 | Workout | ---PH--A---E--- | 1.0 | {f99eaa6a-c6eb-45d9-b3da-e5f5775d7897} | |
| 2477595 | 2477595 | 2014-11-25 10:30:47+00:00 | Bike | ---PHC--G--E--- | 1.0 | {c2b16c2e-f96a-4530-9c32-ba8a5a2b9580} | |
| 1418411 | 1418411 | 2017-04-23 06:52:28+00:00 | Bike | ---PHC-A---E--- | 1.0 | {7358bfec-ff9b-40aa-8200-572eb8f426fb} | |
| 2424915 | 2424915 | 2019-03-16 07:42:10+00:00 | ---PHC-A---E--- | 1.0 | {e105d096-a57e-488e-bcef-3cb9b4935dc7} | ||
| 930702 | 930702 | 2017-08-28 18:16:04+00:00 | Workout | ---PHC-AG------ | 1.0 | {580df49d-c327-4249-aeba-cd24b2143c7c} | |
| 1181192 | 1181192 | 2009-04-26 23:12:50+00:00 | Bike | ---PHC-AG------ | 1.0 | {3775a9f5-db6a-45cf-b3ff-1f7921bf007d} | |
| 1365280 | 1365280 | 2019-01-11 02:27:05+00:00 | Build Me Up - Halvfems | ---PHC-AG------ | 1.0 | {50db70a0-982a-46ba-992d-6b92228a88ee} | |
| 1662121 | 1662121 | 2010-09-07 16:10:09+00:00 | Radfahren | ---PHC-AG------ | 1.0 | {86061b96-d5e5-4da8-962b-e4a3aea552cd} | |
| 1662128 | 1662128 | 2010-11-01 13:10:09+00:00 | Radfahren | ---PHC-AG------ | 1.0 | {86061b96-d5e5-4da8-962b-e4a3aea552cd} | |
| 1662129 | 1662129 | 2010-11-16 16:10:09+00:00 | Radfahren | ---PHC-AG------ | 1.0 | {86061b96-d5e5-4da8-962b-e4a3aea552cd} | |
| 1706478 | 1706478 | 2015-08-26 08:08:27+00:00 | Bike | ---PHC-AG------ | 1.0 | {e58c276d-9e21-4dcf-8121-703ee2c6f729} | |
| 1760253 | 1760253 | 2009-04-26 23:12:50+00:00 | Bike | ---PHC-AG------ | 1.0 | {b96fedff-9aca-400a-a685-ff7e60559e5b} | |
| 2208656 | 2208656 | 2016-04-21 19:21:18+00:00 | Bike | ---PHC-AG------ | 1.0 | {cff11714-94f5-449e-a2ce-5f4e83d9b8fd} | |
| 596780 | 596780 | 2015-11-16 15:45:54+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {eaf6aa05-6ebd-40dd-ba5a-abb1912b40f9} | |
| 656065 | 656065 | 2020-01-09 00:55:41+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {d59e8284-a466-4373-84b2-0854103393c3} | |
| 656068 | 656068 | 2020-01-10 23:11:01+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {d59e8284-a466-4373-84b2-0854103393c3} | |
| 1670912 | 1670912 | 2018-05-28 11:21:53+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {be22c76f-3772-4277-b2f5-ecb8aed313fa} | |
| 1670923 | 1670923 | 2018-06-04 11:18:03+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {be22c76f-3772-4277-b2f5-ecb8aed313fa} | |
| 2134000 | 2134000 | 2016-01-16 10:19:47+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {1211f67e-546d-413d-8a80-e5f18a4392e2} | |
| 2580461 | 2580461 | 2019-01-08 11:49:49+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {2a8ebad8-cb54-41a7-a076-523bd21eed0c} | |
| 621879 | 621879 | 2017-10-09 18:12:50+00:00 | Bike | ---PHC-AG--EV-- | 1.0 | {0d5cb1a6-bcea-4df7-8e14-c07fa95a2e74} | |
| 662936 | 662936 | 2015-01-14 11:42:32+00:00 | Bike | ---PHC-AG--EV-- | 1.0 | {8597fa79-938f-4796-b9d8-4d3e326d86bb} | |
| 662937 | 662937 | 2015-01-14 11:43:23+00:00 | Bike | ---PHC-AG--EV-- | 1.0 | {8597fa79-938f-4796-b9d8-4d3e326d86bb} | |
| 1809887 | 1809887 | 2019-12-18 10:44:17+00:00 | Bike | --SPH--AG------ | 1.0 | {c2aa810a-7e07-4571-86ac-8828f919d347} | |
| 2014733 | 2014733 | 2018-11-28 06:13:38+00:00 | Bike | --SPH--AG------ | 1.0 | {03a6bb49-6d13-4055-b462-9770cd76c80b} | |
| 637091 | 637091 | 2018-01-04 22:09:25+00:00 | --SPHC-A---EV-- | 1.0 | {b035580e-f6ac-43da-bdf1-cdcd94be699a} | ||
| 699218 | 699218 | 2018-01-04 22:09:25+00:00 | --SPHC-A---EV-- | 1.0 | {8dcc998c-09a3-4496-9872-a8d1390cc191} | ||
| 1600090 | 1600090 | 2018-01-04 22:09:25+00:00 | --SPHC-A---EV-- | 1.0 | {2ab8d935-396d-4fe9-99e2-97b516d61825} | ||
| 1936628 | 1936628 | 2018-01-04 22:09:25+00:00 | --SPHC-A---EV-- | 1.0 | {d650625e-d98c-4e79-8a9b-5f93932c017c} | ||
| 58320 | 58320 | 2018-03-18 09:59:56+00:00 | Bike | --SPHC-AG------ | 1.0 | {266bb0ef-3fa6-48ee-901c-f75b0d906fb1} | |
| 58433 | 58433 | 2018-11-22 10:18:26+00:00 | Bike | --SPHC-AG------ | 1.0 | {266bb0ef-3fa6-48ee-901c-f75b0d906fb1} | |
| 202759 | 202759 | 2020-04-18 06:16:41+00:00 | Bike | --SPHC-AG------ | 1.0 | {6657492a-a0ea-4483-a862-cfb828979d8c} | |
| 223684 | 223684 | 2017-10-06 17:19:43+00:00 | Bike | --SPHC-AG------ | 1.0 | {60ec9b36-d194-47c3-b022-2634eccb582e} | |
| 223718 | 223718 | 2017-11-22 19:02:22+00:00 | Bike | --SPHC-AG------ | 1.0 | {60ec9b36-d194-47c3-b022-2634eccb582e} | |
| 530177 | 530177 | 2020-03-29 17:10:46+00:00 | Bike | --SPHC-AG------ | 1.0 | {8ea990ba-0292-48db-b723-c5850168f558} | |
| 759541 | 759541 | 2018-05-09 18:44:27+00:00 | Bike | --SPHC-AG------ | 1.0 | {097f7381-8151-49d5-b4c7-a19193ef93ce} | |
| 1086186 | 1086186 | 2017-12-19 12:04:22+00:00 | Bike | --SPHC-AG------ | 1.0 | {3190bec0-d5bd-4914-97ac-1a5d94b53019} | |
| 2203905 | 2203905 | 2019-04-14 14:53:41+00:00 | Bike | --SPHC-AG------ | 1.0 | {393eb140-bc80-4fa4-9324-5e3bb9c28220} | |
| 2203943 | 2203943 | 2019-12-13 01:58:04+00:00 | Bike | --SPHC-AG------ | 1.0 | {393eb140-bc80-4fa4-9324-5e3bb9c28220} | |
| 2463474 | 2463474 | 2016-10-08 13:02:15+00:00 | Bike | --SPHC-AG------ | 1.0 | {bce0f962-41e6-4d36-a5f0-e12f6474ea71} | |
| 583584 | 583584 | 2016-04-03 00:18:00+00:00 | Bike | --SPHC-AG--E--- | 1.0 | {c683c679-fba2-40b2-8311-b26c6362efc2} | |
| 1666633 | 1666633 | 2018-11-09 10:50:36+00:00 | --SPHC-AG--E--- | 1.0 | {68d0b421-4d73-4a6d-a301-3e239903c9e5} | ||
| 1462895 | 1462895 | 2015-05-16 12:26:56+00:00 | Bike | --SPHC-AG--EV-- | 1.0 | {771b83e6-3278-4d79-bdaa-7c66ba5d30d8} | |
| 1985895 | 1985895 | 2017-11-09 11:19:38+00:00 | Bike | --SPHC-AG--EV-- | 1.0 | {2a852bd1-8d94-4fb4-9b1a-b9076c4d2304} | |
| 2496897 | 2496897 | 2018-03-08 10:00:40+00:00 | Bike | --SPHC-AG--EV-- | 1.0 | {df61f1fb-4875-4b04-ad09-e60140505de4} | |
| 2552036 | 2552036 | 2016-07-22 12:43:07+00:00 | Bike | --SPHC-AG--EV-- | 1.0 | {6abdb782-34e9-40a2-b15a-23d71cb9f165} | |
| 551184 | 551184 | 2019-03-21 13:09:56+00:00 | Bike | -D-PH---------- | 1.0 | 31264.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551185 | 551185 | 2019-03-25 11:06:26+00:00 | Bike | -D-PH---------- | 1.0 | 29547.0 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 2223385 | 2223385 | 2019-02-11 09:38:30+00:00 | Bike | -D-PH---------- | 1.0 | 30.1534 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 1292340 | 1292340 | 2018-10-31 19:12:43+00:00 | Bike | -D-PH--AGL----- | 1.0 | 0.001 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292346 | 1292346 | 2018-11-06 18:47:08+00:00 | Bike | -D-PH--AGL----- | 1.0 | 0.003 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 956832 | 956832 | 2018-11-25 20:58:47+00:00 | Bike | -DSPH---------- | 1.0 | 15.80984 | {fa183526-3dda-49fa-92a8-5b12f7c79b08} |
| 1748666 | 1748666 | 2018-03-06 17:10:20+00:00 | Bike | -DSPH---------- | 1.0 | 3.52125 | {8b359616-b732-44f8-b9a3-c0a6d92b933c} |
| 2223061 | 2223061 | 2016-12-29 16:58:43+00:00 | Ride | -DSPH---------- | 1.0 | 26.8022 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223208 | 2223208 | 2017-12-29 12:16:17+00:00 | Bike | -DSPH---------- | 1.0 | 27.106 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223209 | 2223209 | 2017-12-31 15:41:26+00:00 | Bike | -DSPH---------- | 1.0 | 4.54043 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223316 | 2223316 | 2018-07-19 09:18:55+00:00 | Bike | -DSPH---------- | 1.0 | 15.0715 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223350 | 2223350 | 2019-01-07 07:52:54+00:00 | Bike | -DSPH---------- | 1.0 | 7.28274 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223351 | 2223351 | 2019-01-07 08:10:37+00:00 | Bike | -DSPH---------- | 1.0 | 24.2955 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223361 | 2223361 | 2019-01-25 15:50:09+00:00 | Bike | -DSPH---------- | 1.0 | 23.3568 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223364 | 2223364 | 2019-02-01 16:46:04+00:00 | Bike | -DSPH---------- | 1.0 | 47.0336 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223366 | 2223366 | 2019-02-02 18:22:21+00:00 | Bike | -DSPH---------- | 1.0 | 2.0298 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223368 | 2223368 | 2019-02-03 15:00:03+00:00 | Bike | -DSPH---------- | 1.0 | 5.28604 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223370 | 2223370 | 2019-02-03 21:30:34+00:00 | Bike | -DSPH---------- | 1.0 | 1.10282 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223371 | 2223371 | 2019-02-04 18:06:58+00:00 | Bike | -DSPH---------- | 1.0 | 12.978 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223373 | 2223373 | 2019-02-06 21:48:45+00:00 | Bike | -DSPH---------- | 1.0 | 2.20491 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223374 | 2223374 | 2019-02-07 12:39:31+00:00 | Bike | -DSPH---------- | 1.0 | 5.26968 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223376 | 2223376 | 2019-02-07 13:59:21+00:00 | Bike | -DSPH---------- | 1.0 | 2.51902 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223377 | 2223377 | 2019-02-08 14:21:19+00:00 | Bike | -DSPH---------- | 1.0 | 2.01306 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223379 | 2223379 | 2019-02-08 15:19:44+00:00 | Bike | -DSPH---------- | 1.0 | 0.4052 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223380 | 2223380 | 2019-02-10 08:43:24+00:00 | Bike | -DSPH---------- | 1.0 | 1.515 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223381 | 2223381 | 2019-02-10 08:46:43+00:00 | Bike | -DSPH---------- | 1.0 | 26.663 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223382 | 2223382 | 2019-02-10 09:42:51+00:00 | Bike | -DSPH---------- | 1.0 | 4.21835 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223383 | 2223383 | 2019-02-11 08:10:23+00:00 | Bike | -DSPH---------- | 1.0 | 25.367 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223384 | 2223384 | 2019-02-11 09:35:36+00:00 | Bike | -DSPH---------- | 1.0 | 1.03337 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223386 | 2223386 | 2019-02-11 10:38:12+00:00 | Bike | -DSPH---------- | 1.0 | 3.2375 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2486707 | 2486707 | 2018-06-25 09:07:35+00:00 | Bike | -DSPH---------- | 1.0 | 3.00253 | {70a04cc3-c23e-4247-bf51-15f62957126e} |
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");