rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by workout_time
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time ▼ | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 2567339 | 2567339 | 2018-10-08 09:00:00+00:00 | -DSPHC-AGLWE--- | 28.7473 | {062c0153-5e5b-4c62-ba7a-a1f5cdbdf876} | ||
| 2572544 | 2572544 | 2018-11-22 18:20:41+00:00 | Bike | TDSPHC-A-L-E--- | {2e8ec895-a09a-4866-9932-23bc9d92d38d} | ||
| 2582650 | 2582650 | 2020-03-25 13:56:53+00:00 | Bike | TDSPHC-AGL-EV-- | 53.09647 | {928209b1-b5b2-4c5b-ad9f-59010b19fefe} | |
| 2588835 | 2588835 | 2016-10-02 14:12:40+00:00 | Bike | TDSPHCNAGL-EV-- | 39.96123 | {53d206a4-3797-4f13-b638-7dc6b24e95e3} | |
| 58320 | 58320 | 2018-03-18 09:59:56+00:00 | Bike | --SPHC-AG------ | 1.0 | {266bb0ef-3fa6-48ee-901c-f75b0d906fb1} | |
| 58421 | 58421 | 2018-11-14 09:56:07+00:00 | Bike | --SP-C-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} | |
| 187375 | 187375 | 2020-03-15 15:29:23+00:00 | Bike | -DSPHC-A-L----- | 1.0 | 21.15821 | {468751ef-dce1-4504-845b-623097ec4d2f} |
| 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} | |
| 331244 | 331244 | 2017-11-20 19:48:20+00:00 | Bike | ---P---A------- | 1.0 | {df6f2e29-5e82-431d-8549-27ca0f2fccff} | |
| 380692 | 380692 | 2018-04-16 13:22:25+00:00 | Bike | ---P----------- | 1.0 | {fc2e40c8-d412-4775-a4af-b5519e29a30d} | |
| 404655 | 404655 | 2018-09-10 06:40:24+00:00 | Bike | TDSPHC-AGL--V-- | 1.0 | 25.11372 | {603f6742-9986-4282-8c0c-aed02ada2e5a} |
| 422681 | 422681 | 2018-02-15 06:07:07+00:00 | Bike | ---P-C--G--EV-- | 1.0 | {a3b9812c-124a-4504-a0a1-4f61ccb15896} | |
| 437508 | 437508 | 2018-09-22 08:49:48+00:00 | Bike | TDSPHC-AGL-EV-- | 1.0 | 0.0073 | {cbef31ef-2568-45ed-b7d3-cd128d52fe24} |
| 454483 | 454483 | 2016-11-20 12:15:12+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | 0.05111 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 454484 | 454484 | 2016-12-14 19:40:03+00:00 | Bike | TD-PHC-AGL-E--- | 1.0 | 0.00084 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 454485 | 454485 | 2016-12-15 17:46:11+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | 0.04049 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 454486 | 454486 | 2016-12-23 14:54:17+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | 0.10503 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 454487 | 454487 | 2016-12-24 10:39:34+00:00 | Bike | TD-PHC-AGL-E--- | 1.0 | 0.00023 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 455111 | 455111 | 2018-03-25 07:59:14+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | 23.1059 | {f8e40f36-1e98-4879-ad7f-c8d1b5143573} |
| 530177 | 530177 | 2020-03-29 17:10:46+00:00 | Bike | --SPHC-AG------ | 1.0 | {8ea990ba-0292-48db-b723-c5850168f558} | |
| 543710 | 543710 | 2019-02-03 19:50:49+00:00 | TDSP-C--------- | 1.0 | 4.67 | {528bd890-c2c2-4483-a523-f9c9ee0102ca} | |
| 550995 | 550995 | 2018-04-20 10:27:30+00:00 | Bike | -DSP----------- | 1.0 | 28465.00228 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 550999 | 550999 | 2018-04-25 17:37:33+00:00 | Bike | -DSP----------- | 1.0 | 28645.00214 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551011 | 551011 | 2018-05-17 09:37:10+00:00 | Bike | -DSPH--AGL----- | 1.0 | 39.75965 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551012 | 551012 | 2018-05-18 19:23:43+00:00 | Bike | -DSPH--AGL----- | 1.0 | 31.9157 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551015 | 551015 | 2018-05-23 09:35:46+00:00 | Bike | -DSPH--AGL----- | 1.0 | 44.7317 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551019 | 551019 | 2018-05-30 16:31:25+00:00 | Bike | -DSP----------- | 1.0 | 28.037 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551021 | 551021 | 2018-06-03 17:49:43+00:00 | Bike | -DSPH--AGL----- | 1.0 | 11.9466 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551023 | 551023 | 2018-06-05 18:36:12+00:00 | Bike | -DSP----------- | 1.0 | 28.501 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551025 | 551025 | 2018-06-06 17:40:19+00:00 | Bike | -DSP----------- | 1.0 | 27.287 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551074 | 551074 | 2018-09-18 16:00:31+00:00 | Bike | -DSP---AGL----- | 1.0 | 14.281 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551082 | 551082 | 2018-10-02 11:14:25+00:00 | Bike | -DSP----------- | 1.0 | 29141.00817 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 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} |
| 583584 | 583584 | 2016-04-03 00:18:00+00:00 | Bike | --SPHC-AG--E--- | 1.0 | {c683c679-fba2-40b2-8311-b26c6362efc2} | |
| 596780 | 596780 | 2015-11-16 15:45:54+00:00 | Bike | ---PHC-AG--E--- | 1.0 | {eaf6aa05-6ebd-40dd-ba5a-abb1912b40f9} | |
| 621879 | 621879 | 2017-10-09 18:12:50+00:00 | Bike | ---PHC-AG--EV-- | 1.0 | {0d5cb1a6-bcea-4df7-8e14-c07fa95a2e74} | |
| 637091 | 637091 | 2018-01-04 22:09:25+00:00 | --SPHC-A---EV-- | 1.0 | {b035580e-f6ac-43da-bdf1-cdcd94be699a} | ||
| 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} | |
| 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} | |
| 699218 | 699218 | 2018-01-04 22:09:25+00:00 | --SPHC-A---EV-- | 1.0 | {8dcc998c-09a3-4496-9872-a8d1390cc191} | ||
| 736747 | 736747 | 2019-11-08 05:30:22+00:00 | Swim | ---P----------- | 1.0 | {b00fa1aa-d332-4550-b093-b24a8f501417} | |
| 759541 | 759541 | 2018-05-09 18:44:27+00:00 | Bike | --SPHC-AG------ | 1.0 | {097f7381-8151-49d5-b4c7-a19193ef93ce} | |
| 912381 | 912381 | 2016-08-06 07:22:09+00:00 | Bike | ---P----------- | 1.0 | {e8d27149-e1c0-43e8-bb1d-f7369ec454a2} | |
| 930702 | 930702 | 2017-08-28 18:16:04+00:00 | Workout | ---PHC-AG------ | 1.0 | {580df49d-c327-4249-aeba-cd24b2143c7c} | |
| 956819 | 956819 | 2018-11-08 16:15:22+00:00 | Bike | -DSPH---G------ | 1.0 | 17.6692 | {fa183526-3dda-49fa-92a8-5b12f7c79b08} |
| 956824 | 956824 | 2018-11-16 19:15:21+00:00 | Bike | -DSPH---G------ | 1.0 | 16.1039 | {fa183526-3dda-49fa-92a8-5b12f7c79b08} |
| 956832 | 956832 | 2018-11-25 20:58:47+00:00 | Bike | -DSPH---------- | 1.0 | 15.80984 | {fa183526-3dda-49fa-92a8-5b12f7c79b08} |
| 988297 | 988297 | 2019-05-14 12:50:53+00:00 | Bike | TDSPHC-AGL-E--- | 1.0 | {982a84ce-6167-4ab9-8d52-f894882cbc78} | |
| 1041726 | 1041726 | 2018-02-12 14:15:42+00:00 | VirtualRide | -DSPH--AGL----- | 1.0 | 21.3363 | {5ca1341d-c4c0-41a4-a13e-121c4adb4edd} |
| 1086186 | 1086186 | 2017-12-19 12:04:22+00:00 | Bike | --SPHC-AG------ | 1.0 | {3190bec0-d5bd-4914-97ac-1a5d94b53019} | |
| 1181192 | 1181192 | 2009-04-26 23:12:50+00:00 | Bike | ---PHC-AG------ | 1.0 | {3775a9f5-db6a-45cf-b3ff-1f7921bf007d} | |
| 1186554 | 1186554 | 2019-11-20 15:41:32+00:00 | Bike | TDSPHC--------- | 1.0 | 5.67767 | {17cd7be3-23ca-4d8a-95d1-2d1eeff0f60d} |
| 1224733 | 1224733 | 2020-05-18 18:40:16+00:00 | Bike | TDSPHC-AGL-EV-- | 1.0 | {8aeab4d3-43f1-46af-bacc-59b2395daaea} | |
| 1292258 | 1292258 | 2018-07-15 16:42:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 31.1065 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292266 | 1292266 | 2018-07-28 07:29:12+00:00 | Bike | -DSPH--AGL----- | 1.0 | 26.9897 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292277 | 1292277 | 2018-08-12 09:18:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.9704 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292278 | 1292278 | 2018-08-13 17:49:23+00:00 | Bike | -DSPH--AGL----- | 1.0 | 14.9956 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292279 | 1292279 | 2018-08-14 18:21:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 20.3966 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292281 | 1292281 | 2018-08-16 08:24:30+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292286 | 1292286 | 2018-08-25 07:38:30+00:00 | Bike | -DSPH--AGL----- | 1.0 | 21.2044 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292294 | 1292294 | 2018-09-01 17:58:34+00:00 | Bike | -DSPH--AGL----- | 1.0 | 27.7099 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292298 | 1292298 | 2018-09-02 12:57:48+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.4352 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292299 | 1292299 | 2018-09-02 16:11:27+00:00 | Bike | -DSP---AGL----- | 1.0 | 10.9911 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292302 | 1292302 | 2018-09-08 07:26:05+00:00 | Bike | -DSPH--AGL----- | 1.0 | 8.27626 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292311 | 1292311 | 2018-09-22 07:31:02+00:00 | Bike | -DSPH--AGL----- | 1.0 | 10.5845 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292316 | 1292316 | 2018-09-29 08:56:03+00:00 | Bike | -DSPH--AGL----- | 1.0 | 62.4442 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292317 | 1292317 | 2018-09-29 11:03:49+00:00 | Bike | -DSPH--AGL----- | 1.0 | 4.9742 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292327 | 1292327 | 2018-10-16 18:02:39+00:00 | Bike | -DSPH--AGL----- | 1.0 | 26.2458 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292330 | 1292330 | 2018-10-20 10:54:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 60.2107 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292331 | 1292331 | 2018-10-21 08:41:23+00:00 | Bike | -DSPH--AGL----- | 1.0 | 67.3789 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292333 | 1292333 | 2018-10-24 18:06:33+00:00 | Bike | -DSPH--A-L----- | 1.0 | 9.4783 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292334 | 1292334 | 2018-10-25 18:08:07+00:00 | Bike | -DSPH--A-L----- | 1.0 | 6.9402 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292335 | 1292335 | 2018-10-25 18:23:39+00:00 | Bike | -DSPH--A-L----- | 1.0 | 8.5649 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292336 | 1292336 | 2018-10-25 18:54:12+00:00 | Bike | -DSPH--A-L----- | 1.0 | 5.5807 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292340 | 1292340 | 2018-10-31 19:12:43+00:00 | Bike | -D-PH--AGL----- | 1.0 | 0.001 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292342 | 1292342 | 2018-11-01 11:44:00+00:00 | Bike | -DSPH--AGL----- | 1.0 | 29.81353 | {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} |
| 1292348 | 1292348 | 2018-11-08 19:03:04+00:00 | Bike | ---PH--A------- | 1.0 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} | |
| 1292349 | 1292349 | 2018-11-09 14:37:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.8661 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292350 | 1292350 | 2018-11-10 10:52:24+00:00 | Bike | -DSPH--AGL----- | 1.0 | 29.2327 | {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} | |
| 1292361 | 1292361 | 2018-11-24 14:06:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.4337 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292370 | 1292370 | 2018-12-06 14:27:52+00:00 | Bike | -DSPH--AGL----- | 1.0 | 67.2021 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292374 | 1292374 | 2018-12-12 19:31:38+00:00 | Bike | -DSPH--A-L----- | 1.0 | 13.4927 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292376 | 1292376 | 2018-12-14 19:44:51+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.0028 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292379 | 1292379 | 2018-12-18 18:56:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 16.4035 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292380 | 1292380 | 2018-12-18 19:55:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 1.43373 | {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} | |
| 1292418 | 1292418 | 2019-02-05 19:34:12+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.007 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
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");