rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by data
This data as json, CSV (advanced)
| Link | rowid | date | sport | data ▼ | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 380692 | 380692 | 2018-04-16 13:22:25+00:00 | Bike | ---P----------- | 1.0 | {fc2e40c8-d412-4775-a4af-b5519e29a30d} | |
| 736747 | 736747 | 2019-11-08 05:30:22+00:00 | Swim | ---P----------- | 1.0 | {b00fa1aa-d332-4550-b093-b24a8f501417} | |
| 912381 | 912381 | 2016-08-06 07:22:09+00:00 | Bike | ---P----------- | 1.0 | {e8d27149-e1c0-43e8-bb1d-f7369ec454a2} | |
| 2223233 | 2223233 | 2018-03-03 18:04:29+00:00 | Bike | ---P----------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 331244 | 331244 | 2017-11-20 19:48:20+00:00 | Bike | ---P---A------- | 1.0 | {df6f2e29-5e82-431d-8549-27ca0f2fccff} | |
| 422681 | 422681 | 2018-02-15 06:07:07+00:00 | Bike | ---P-C--G--EV-- | 1.0 | {a3b9812c-124a-4504-a0a1-4f61ccb15896} | |
| 1670883 | 1670883 | 2018-05-09 11:54:26+00:00 | Bike | ---P-C-AG--E--- | 1.0 | {be22c76f-3772-4277-b2f5-ecb8aed313fa} | |
| 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} | |
| 58421 | 58421 | 2018-11-14 09:56:07+00:00 | Bike | --SP-C-AG------ | 1.0 | {266bb0ef-3fa6-48ee-901c-f75b0d906fb1} | |
| 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} |
| 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} |
| 551019 | 551019 | 2018-05-30 16:31:25+00:00 | Bike | -DSP----------- | 1.0 | 28.037 | {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} |
| 551082 | 551082 | 2018-10-02 11:14:25+00:00 | Bike | -DSP----------- | 1.0 | 29141.00817 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 2223367 | 2223367 | 2019-02-03 13:10:11+00:00 | Bike | -DSP----------- | 1.0 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} | |
| 2223389 | 2223389 | 2019-02-14 09:10:14+00:00 | Bike | -DSP----------- | 1.0 | 4.83327 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223396 | 2223396 | 2019-02-21 14:03:34+00:00 | Bike | -DSP----------- | 1.0 | 22.99621 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 1614068 | 1614068 | 2019-03-03 07:45:31+00:00 | Bike | -DSP----G------ | 1.0 | 22.2353 | {7390426c-213a-471e-aebb-f118d120c135} |
| 1614071 | 1614071 | 2019-03-07 14:10:41+00:00 | Bike | -DSP----G------ | 1.0 | 27.6863 | {7390426c-213a-471e-aebb-f118d120c135} |
| 1614081 | 1614081 | 2019-03-13 20:32:01+00:00 | Bike | -DSP----G------ | 1.0 | 35.6474 | {7390426c-213a-471e-aebb-f118d120c135} |
| 1614084 | 1614084 | 2019-03-16 17:45:38+00:00 | Bike | -DSP----G------ | 1.0 | 8.8834 | {7390426c-213a-471e-aebb-f118d120c135} |
| 1614088 | 1614088 | 2019-04-10 17:05:53+00:00 | Bike | -DSP----G------ | 1.0 | 13.6057 | {7390426c-213a-471e-aebb-f118d120c135} |
| 2223310 | 2223310 | 2018-07-12 09:41:53+00:00 | Bike | -DSP---A-L----- | 1.0 | 1.92312 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223311 | 2223311 | 2018-07-12 09:48:57+00:00 | Bike | -DSP---A-L----- | 1.0 | 9.85345 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223358 | 2223358 | 2019-01-23 07:18:17+00:00 | Bike | -DSP---A-L----- | 1.0 | 33010.6 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 551074 | 551074 | 2018-09-18 16:00:31+00:00 | Bike | -DSP---AGL----- | 1.0 | 14.281 | {5353813e-daab-4089-98d2-f51864e09bd0} |
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");