Metadata for each ride in GoldenCheetah OpenData.

Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData

2,589,036 rows sorted by workout_time

View and edit SQL

Link rowid date sport data workout_time ▼ total_distance athlete
9282 2009-02-06 06:23:16+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9286 2009-02-07 07:02:14+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9289 2009-02-08 06:52:23+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9293 2009-02-09 06:16:41+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9295 2009-02-10 06:02:46+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9299 2009-02-11 06:09:17+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9302 2009-02-12 05:55:49+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9306 2009-02-13 06:40:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9308 2009-02-14 07:04:37+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9311 2009-02-15 07:49:11+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9314 2009-02-16 06:02:23+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9317 2009-02-17 06:51:33+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9320 2009-02-18 06:16:39+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9323 2009-02-19 06:06:42+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9325 2009-02-20 06:55:13+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9328 2009-02-21 07:05:06+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9330 2009-02-22 07:34:14+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9333 2009-02-23 06:55:24+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9336 2009-02-24 06:53:39+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9338 2009-02-25 06:39:39+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9341 2009-02-26 07:12:03+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9344 2009-02-27 06:38:36+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9347 2009-02-28 06:34:33+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9349 2009-03-01 07:50:12+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9352 2009-03-02 06:43:48+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9354 2009-03-03 06:48:34+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9357 2009-03-04 06:39:16+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9360 2009-03-05 06:54:54+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9362 2009-03-06 06:37:22+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9365 2009-03-07 06:56:08+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9368 2009-03-08 06:34:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9370 2009-03-08 09:59:23+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9372 2009-03-09 06:38:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9375 2009-03-10 06:44:03+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9378 2009-03-11 06:50:59+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9381 2009-03-12 06:32:27+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9384 2009-03-13 06:31:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9386 2009-03-14 06:34:02+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9389 2009-03-15 06:55:52+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9391 2009-03-15 08:45:47+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9393 2009-03-16 06:23:01+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9395 2009-03-17 06:41:08+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9398 2009-03-18 06:29:43+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9402 2009-03-19 06:18:55+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9405 2009-03-20 06:20:43+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9407 2009-03-21 06:14:17+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9410 2009-03-22 07:06:22+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9412 2009-03-23 06:50:53+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9415 2009-03-24 07:08:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9417 2009-03-25 06:32:48+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9420 2009-03-26 06:27:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9423 2009-03-27 06:18:54+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9425 2009-03-28 06:53:15+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9428 2009-03-29 07:58:31+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9431 2009-03-30 07:12:32+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9433 2009-03-31 06:50:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9436 2009-04-01 06:27:57+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9440 2009-04-02 06:41:58+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9442 2009-04-03 06:33:03+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9444 2009-04-04 06:20:42+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9447 2009-04-05 06:47:42+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9451 2009-04-06 06:46:59+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9453 2009-04-07 06:27:10+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9456 2009-04-08 06:54:11+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9458 2009-04-09 06:36:48+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9461 2009-04-10 06:52:47+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9463 2009-04-11 06:48:31+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9466 2009-04-12 07:50:00+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9469 2009-04-13 06:42:19+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9471 2009-04-14 06:39:59+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9474 2009-04-15 06:56:12+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9477 2009-04-16 06:33:38+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9480 2009-04-17 06:34:02+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9483 2009-04-18 08:03:12+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9487 2009-04-19 07:50:49+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9489 2009-04-19 15:52:28+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9491 2009-04-20 06:37:17+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9493 2009-04-21 06:34:45+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9496 2009-04-22 06:16:03+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9499 2009-04-23 06:14:08+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9502 2009-04-24 06:22:04+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9504 2009-04-25 06:34:38+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9508 2009-04-26 07:47:11+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9510 2009-04-27 06:39:00+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9513 2009-04-28 06:17:10+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9516 2009-04-29 06:37:17+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9518 2009-04-30 06:24:11+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9521 2009-05-01 06:39:48+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9523 2009-05-02 06:52:56+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9526 2009-05-03 06:01:21+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9528 2009-05-03 10:49:38+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9530 2009-05-04 06:33:19+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9533 2009-05-05 06:30:21+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9535 2009-05-06 06:32:04+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9538 2009-05-07 06:10:31+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9541 2009-05-08 06:33:04+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9543 2009-05-09 06:25:43+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9546 2009-05-10 07:02:37+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9548 2009-05-11 06:07:14+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}
9551 2009-05-12 06:07:51+00:00   ---------------     {d127ab04-6539-4d0e-b9bf-5bd242e0d36b}

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");