rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by total_distance
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance ▼ | athlete |
|---|---|---|---|---|---|---|---|
| 7830 | 7830 | 2018-10-12 12:05:56+00:00 | -------AG------ | 1.0 | {2f3ac106-9ea5-45d2-a645-06534b2439dd} | ||
| 7985 | 7985 | 2019-06-12 11:35:01+00:00 | Bike | T------AG------ | 3.0 | {2f3ac106-9ea5-45d2-a645-06534b2439dd} | |
| 7997 | 7997 | 2019-06-29 04:55:39+00:00 | Bike | --------------- | {2f3ac106-9ea5-45d2-a645-06534b2439dd} | ||
| 8043 | 8043 | 2019-09-30 12:10:34+00:00 | --------------- | {2f3ac106-9ea5-45d2-a645-06534b2439dd} | |||
| 8059 | 8059 | 2019-10-17 16:23:50+00:00 | Bike | T--PHC-A------- | 141.0 | {2f3ac106-9ea5-45d2-a645-06534b2439dd} | |
| 8129 | 8129 | 2020-02-10 08:28:47+00:00 | Bike | T--PHC-A------- | 2666.0 | {2f3ac106-9ea5-45d2-a645-06534b2439dd} | |
| 8411 | 8411 | 2015-06-18 16:29:16+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8412 | 8412 | 2015-06-21 07:07:17+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8413 | 8413 | 2015-06-23 16:39:38+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8414 | 8414 | 2015-06-30 16:35:02+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8415 | 8415 | 2015-07-05 07:05:51+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8416 | 8416 | 2015-07-07 16:38:09+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8417 | 8417 | 2015-07-09 16:43:50+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8418 | 8418 | 2015-07-12 16:31:46+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8419 | 8419 | 2015-07-14 16:37:04+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8420 | 8420 | 2015-07-17 12:15:42+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8421 | 8421 | 2015-07-21 16:32:25+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8422 | 8422 | 2015-07-24 16:29:25+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8423 | 8423 | 2015-07-28 16:36:05+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8424 | 8424 | 2015-07-31 16:37:25+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8425 | 8425 | 2015-08-02 07:06:52+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8426 | 8426 | 2015-08-04 16:32:02+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8427 | 8427 | 2015-08-06 16:31:17+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8428 | 8428 | 2015-08-09 07:03:58+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8429 | 8429 | 2015-08-11 16:33:20+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8430 | 8430 | 2015-08-15 06:13:38+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8431 | 8431 | 2015-08-18 16:38:16+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8432 | 8432 | 2015-08-20 16:39:55+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8433 | 8433 | 2015-08-23 07:08:49+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8434 | 8434 | 2015-08-28 16:25:07+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8435 | 8435 | 2015-08-30 16:24:49+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8455 | 8455 | 2015-12-06 08:23:29+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8456 | 8456 | 2015-12-12 12:44:06+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8457 | 8457 | 2015-12-23 09:06:05+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8458 | 8458 | 2015-12-25 07:48:55+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8459 | 8459 | 2015-12-27 08:15:06+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8460 | 8460 | 2015-12-30 12:21:42+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8461 | 8461 | 2016-01-03 12:01:19+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8462 | 8462 | 2016-02-06 08:35:50+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8463 | 8463 | 2016-02-28 08:11:09+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8470 | 8470 | 2016-04-03 07:06:53+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8471 | 8471 | 2016-04-05 16:32:53+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8472 | 8472 | 2016-04-09 12:38:15+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8473 | 8473 | 2016-04-10 13:15:43+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8474 | 8474 | 2016-04-12 16:31:41+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8475 | 8475 | 2016-04-14 16:49:58+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8476 | 8476 | 2016-04-17 07:06:13+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8477 | 8477 | 2016-04-19 16:34:30+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8478 | 8478 | 2016-04-22 16:31:00+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8479 | 8479 | 2016-04-26 16:35:57+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8480 | 8480 | 2016-05-01 11:10:10+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8481 | 8481 | 2016-05-03 16:33:20+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8482 | 8482 | 2016-05-05 07:10:06+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8483 | 8483 | 2016-05-08 07:07:34+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8484 | 8484 | 2016-05-10 16:34:13+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8485 | 8485 | 2016-05-15 07:06:38+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8486 | 8486 | 2016-05-17 16:35:08+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8487 | 8487 | 2016-05-19 17:36:11+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8488 | 8488 | 2016-05-28 06:52:57+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8489 | 8489 | 2016-06-03 16:49:27+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8490 | 8490 | 2016-06-07 16:30:00+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8491 | 8491 | 2016-06-19 07:16:35+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8492 | 8492 | 2016-06-28 16:39:25+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8493 | 8493 | 2016-07-05 16:32:28+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8494 | 8494 | 2016-07-08 17:09:35+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8495 | 8495 | 2016-07-10 07:08:54+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8496 | 8496 | 2016-07-12 16:34:32+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8497 | 8497 | 2016-07-17 16:52:15+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8498 | 8498 | 2016-07-19 16:44:20+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8499 | 8499 | 2016-07-24 07:07:38+00:00 | --------------- | {ffc038ac-716e-4c9f-bffd-f35edaf5640f} | |||
| 8959 | 8959 | 2019-09-29 10:52:12+00:00 | Bike | T------A---E--- | 31.5 | {0eac2a4c-f0c1-41f4-9a25-bc83fd2747ba} | |
| 9006 | 9006 | 2008-04-25 08:02:54+00:00 | --------------- | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |||
| 9007 | 9007 | 2008-04-25 08:21:00+00:00 | --------------- | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |||
| 9008 | 9008 | 2008-04-25 16:52:43+00:00 | --------------- | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | |||
| 9017 | 9017 | 2008-05-08 08:57:34+00:00 | T---H--A------- | 3960.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9018 | 9018 | 2008-05-09 09:01:40+00:00 | T---H--A------- | 3300.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9019 | 9019 | 2008-05-10 08:49:20+00:00 | T---HC-A------- | 4560.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9020 | 9020 | 2008-05-10 08:49:39+00:00 | T---H--A------- | 4560.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9021 | 9021 | 2008-05-10 13:47:00+00:00 | T---H--A------- | 6360.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9022 | 9022 | 2008-05-10 14:02:26+00:00 | T---HC-A------- | 4980.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9023 | 9023 | 2008-05-11 12:52:28+00:00 | T---H--A------- | 3060.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9026 | 9026 | 2008-05-13 08:56:09+00:00 | T---H--A------- | 6360.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9029 | 9029 | 2008-05-14 11:28:23+00:00 | T---H--A------- | 1860.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9030 | 9030 | 2008-05-15 08:04:57+00:00 | T---H--A------- | 5280.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9031 | 9031 | 2008-05-16 14:09:28+00:00 | T---H--A------- | 1800.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9032 | 9032 | 2008-05-17 13:25:42+00:00 | T---H--A------- | 5520.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9034 | 9034 | 2008-05-18 08:31:58+00:00 | T---H--A------- | 4500.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9037 | 9037 | 2008-05-20 13:29:54+00:00 | T---HC-A------- | 7440.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9038 | 9038 | 2008-05-20 13:30:16+00:00 | T---H--A------- | 6960.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9041 | 9041 | 2008-05-22 13:27:18+00:00 | T---H--A------- | 3600.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9043 | 9043 | 2008-05-25 09:00:45+00:00 | T---HC-A------- | 1800.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9045 | 9045 | 2008-05-25 12:56:41+00:00 | T----C-A------- | 1740.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9047 | 9047 | 2008-05-27 09:10:18+00:00 | T---H--A------- | 4440.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9048 | 9048 | 2008-05-27 13:00:39+00:00 | T---HC-A------- | 4500.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9050 | 9050 | 2008-05-29 08:00:24+00:00 | T---H--A------- | 5340.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9051 | 9051 | 2008-05-30 08:16:23+00:00 | T---H--A------- | 4500.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9055 | 9055 | 2008-06-04 09:14:10+00:00 | T---H--A------- | 5340.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9056 | 9056 | 2008-06-06 09:46:54+00:00 | T---H--A------- | 5520.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9058 | 9058 | 2008-06-08 06:48:43+00:00 | T----C-A------- | 1200.0 | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} | ||
| 9062 | 9062 | 2008-06-18 19:49:52+00:00 | --------------- | {d127ab04-6539-4d0e-b9bf-5bd242e0d36b} |
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");