rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows sorted by date
This data as json, CSV (advanced)
| Link | rowid | date ▼ | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 257406 | 257406 | 1989-12-30 13:37:47+00:00 | Bike | TDSP-C-AGL----- | 4907.0 | 44.95314 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257407 | 257407 | 1989-12-30 13:38:01+00:00 | Bike | TDSP-C-AGL----- | 4910.0 | 36.12047 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257408 | 257408 | 1989-12-30 13:38:19+00:00 | Bike | TDSPHC-AGL----- | 4888.0 | 47.65769 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257409 | 257409 | 1989-12-30 13:40:29+00:00 | Bike | TDSP-C-AGL----- | 4427.0 | 30.35055 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257410 | 257410 | 1989-12-30 13:40:43+00:00 | Bike | TDSP-C-AGL----- | 4744.0 | 42.93625 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257411 | 257411 | 1989-12-30 13:43:02+00:00 | Bike | TDSP-C-AGL----- | 4593.0 | 43.53883 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257412 | 257412 | 1989-12-30 13:43:55+00:00 | Bike | TDSP-C-AGL----- | 4541.0 | 41.40476 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257413 | 257413 | 1989-12-30 13:44:47+00:00 | Bike | TDSP-C-AGL----- | 4505.0 | 37.96464 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257414 | 257414 | 1989-12-30 13:46:37+00:00 | Bike | TDSP-C-AGL----- | 4379.0 | 37.96111 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257415 | 257415 | 1989-12-30 13:46:46+00:00 | Bike | TDSP-C-AGL----- | 4387.0 | 33.70867 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257416 | 257416 | 1989-12-30 13:46:58+00:00 | Bike | TDSP-C-AGL----- | 4366.0 | 37.964 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257417 | 257417 | 1989-12-30 13:47:11+00:00 | Bike | TDSP-C-AGL----- | 4358.0 | 39.39392 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257418 | 257418 | 1989-12-30 13:47:17+00:00 | Bike | TDSP-C-AGL----- | 4306.0 | 37.95859 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257419 | 257419 | 1989-12-30 13:47:20+00:00 | Bike | TDSP-C-AGL----- | 4305.0 | 35.91932 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257420 | 257420 | 1989-12-30 13:47:24+00:00 | Bike | TDSP-C-AGL----- | 4287.0 | 40.98991 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257421 | 257421 | 1989-12-30 13:47:31+00:00 | Bike | TDSP-C-AGL----- | 4341.0 | 37.97698 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257422 | 257422 | 1989-12-30 13:47:34+00:00 | Bike | TDSP-C-AGL----- | 4267.0 | 37.96945 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257423 | 257423 | 1989-12-30 13:48:09+00:00 | Bike | TDSP-C-AGL----- | 4289.0 | 37.89878 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257424 | 257424 | 1989-12-30 13:48:10+00:00 | Bike | TDSP-C-AGL----- | 4292.0 | 36.54529 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257425 | 257425 | 1989-12-30 13:48:22+00:00 | Bike | TDSP-C-AGL----- | 4291.0 | 37.76023 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257426 | 257426 | 1989-12-30 13:48:34+00:00 | Bike | TDSP-C-AGL----- | 4249.0 | 37.96134 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257427 | 257427 | 1989-12-30 13:48:36+00:00 | Bike | TDSP-C-AGL----- | 4225.0 | 39.95055 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257428 | 257428 | 1989-12-30 13:48:47+00:00 | Bike | TDSP-C-AGL----- | 4267.0 | 39.98383 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257429 | 257429 | 1989-12-30 13:48:57+00:00 | Bike | TDSP-C-AGL----- | 4262.0 | 42.68017 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257430 | 257430 | 1989-12-30 13:48:58+00:00 | Bike | TDSP-C-AGL----- | 4253.0 | 38.18491 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257431 | 257431 | 1989-12-30 13:49:04+00:00 | Bike | TDSP-C-AGL----- | 4216.0 | 39.41307 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257432 | 257432 | 1989-12-30 13:49:13+00:00 | Bike | TDSP-C-AGL----- | 4222.0 | 37.99334 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257433 | 257433 | 1989-12-30 13:49:24+00:00 | Bike | TDSP-C-AGL----- | 4235.0 | 40.19729 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257434 | 257434 | 1989-12-30 13:49:29+00:00 | Bike | TDSP-C-AGL----- | 4213.0 | 37.96468 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257435 | 257435 | 1989-12-30 13:49:31+00:00 | Bike | TDSP-C-AGL----- | 4216.0 | 45.02695 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257436 | 257436 | 1989-12-30 13:49:32+00:00 | Bike | TDSP-C-AGL----- | 4202.0 | 37.90374 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257437 | 257437 | 1989-12-30 13:49:38+00:00 | Bike | TDSP-C-AGL----- | 4211.0 | 45.10488 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257438 | 257438 | 1989-12-30 13:49:43+00:00 | Bike | TDSP-C-AGL----- | 4203.0 | 37.80555 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257439 | 257439 | 1989-12-30 13:49:45+00:00 | Bike | TDSP-C-AGL----- | 4198.0 | 37.33463 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257440 | 257440 | 1989-12-30 13:49:48+00:00 | Bike | TDSP-C-AGL----- | 4205.0 | 42.38042 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257441 | 257441 | 1989-12-30 13:49:52+00:00 | Bike | TDSPHC-AGL----- | 4146.0 | 37.28066 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257442 | 257442 | 1989-12-30 13:50:02+00:00 | Bike | TDSP-C-AGL----- | 4197.0 | 40.29635 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257443 | 257443 | 1989-12-30 13:50:05+00:00 | Bike | TDSP-C-AGL----- | 4176.0 | 40.23649 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257444 | 257444 | 1989-12-30 13:50:07+00:00 | Bike | TDSP-C-AGL----- | 4158.0 | 37.96538 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257445 | 257445 | 1989-12-30 13:50:18+00:00 | Bike | TDSP-C-AGL----- | 4168.0 | 37.95602 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257446 | 257446 | 1989-12-30 13:50:25+00:00 | Bike | TDSP-C-AGL----- | 4156.0 | 37.21211 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257447 | 257447 | 1989-12-30 13:50:30+00:00 | Bike | TDSP-C-AGL----- | 4139.0 | 43.99459 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257448 | 257448 | 1989-12-30 13:50:36+00:00 | Bike | TDSP-C-AGL----- | 4148.0 | 37.25794 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257449 | 257449 | 1989-12-30 13:50:37+00:00 | Bike | TDSP-C-AGL----- | 4162.0 | 39.26118 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257450 | 257450 | 1989-12-30 13:50:39+00:00 | Bike | TDSP-C-AGL----- | 4160.0 | 37.99297 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257451 | 257451 | 1989-12-30 13:51:04+00:00 | Bike | TDSP-C-AGL----- | 4117.0 | 39.78031 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257452 | 257452 | 1989-12-30 13:51:48+00:00 | Bike | TDSP-C-AGL----- | 4081.0 | 33.8173 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257453 | 257453 | 1989-12-30 13:52:14+00:00 | Bike | TDSP-C-AGL----- | 4054.0 | 35.77624 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257454 | 257454 | 1989-12-30 13:52:23+00:00 | Bike | TDSP-C-AGL----- | 4034.0 | 36.02212 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257455 | 257455 | 1989-12-30 13:52:50+00:00 | Bike | TDSP-C-AGL----- | 4024.0 | 37.98524 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257456 | 257456 | 1989-12-30 13:53:10+00:00 | Bike | TDSP-C-AGL----- | 3972.0 | 32.44818 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257457 | 257457 | 1989-12-30 13:53:19+00:00 | Bike | TDSP-C-AGL----- | 3971.0 | 34.5076 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257458 | 257458 | 1989-12-30 13:53:33+00:00 | Bike | TDSP-C-AGL----- | 3976.0 | 31.42916 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257459 | 257459 | 1989-12-30 13:53:40+00:00 | Bike | TDSP-C-AGL----- | 3971.0 | 34.71046 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257460 | 257460 | 1989-12-30 13:53:52+00:00 | Bike | TDSP-C-AGL----- | 3931.0 | 31.21925 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257461 | 257461 | 1989-12-30 13:53:56+00:00 | Bike | TDSP-C-AGL----- | 3922.0 | 34.88805 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257462 | 257462 | 1989-12-30 13:54:20+00:00 | Bike | TDSP-C-AGL----- | 3930.0 | 41.31205 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257463 | 257463 | 1989-12-30 13:54:48+00:00 | Bike | TDSP-C-AGL----- | 3902.0 | 40.53512 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257464 | 257464 | 1989-12-30 13:54:51+00:00 | Bike | TDSP-C-AGL----- | 3903.0 | 37.22295 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257465 | 257465 | 1989-12-30 13:55:01+00:00 | Bike | TDSP-C-AGL----- | 3855.0 | 44.28537 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257466 | 257466 | 1989-12-30 13:56:14+00:00 | Bike | TDSP-C-AGL----- | 3820.0 | 36.52251 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257467 | 257467 | 1989-12-30 13:56:37+00:00 | Bike | TDSP-C-AGL----- | 3798.0 | 11.76069 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257468 | 257468 | 1989-12-30 13:57:01+00:00 | Bike | TDSP-C-AGL----- | 3769.0 | 30.62326 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257469 | 257469 | 1989-12-30 13:57:10+00:00 | Bike | TDSP-C-AGL----- | 3732.0 | 28.99117 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257470 | 257470 | 1989-12-30 13:57:15+00:00 | Bike | TDSP-C-AGL----- | 3622.0 | 32.3552 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257471 | 257471 | 1989-12-30 13:57:17+00:00 | Bike | TDSP-C-AGL----- | 3758.0 | 43.294 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257472 | 257472 | 1989-12-30 13:57:30+00:00 | Bike | TDSP-C-AGL----- | 3743.0 | 43.18978 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257473 | 257473 | 1989-12-30 13:58:11+00:00 | Bike | TDSP-C-AGL----- | 3680.0 | 36.85526 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257474 | 257474 | 1989-12-30 13:58:29+00:00 | Bike | TDSP-C-AGL----- | 3672.0 | 37.75883 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257475 | 257475 | 1989-12-30 13:58:38+00:00 | Bike | TDSP-C-AGL----- | 3677.0 | 38.01604 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257476 | 257476 | 1989-12-30 13:59:23+00:00 | Bike | TDSP-C-AGL----- | 3631.0 | 27.9494 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257477 | 257477 | 1989-12-30 13:59:38+00:00 | Bike | TDSP-C-AGL----- | 3617.0 | 40.1036 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 1432930 | 1432930 | 1989-12-30 14:00:03+00:00 | Bike | TDSPHC-AGL----- | 3600.0 | 24.39838 | {1bc1499d-9370-44a7-a2b8-cd1e8fabd8cd} |
| 257478 | 257478 | 1989-12-30 14:01:13+00:00 | Bike | TDSP-C-AGL----- | 3451.0 | 41.43527 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257479 | 257479 | 1989-12-30 14:01:26+00:00 | Bike | TDSP-C-AGL----- | 3489.0 | 27.07738 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257480 | 257480 | 1989-12-30 14:03:17+00:00 | Bike | TDSP-C-AGL----- | 3392.0 | 31.22971 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257481 | 257481 | 1989-12-30 14:03:31+00:00 | Bike | TDSP-C-AGL----- | 3338.0 | 25.15809 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257482 | 257482 | 1989-12-30 14:03:48+00:00 | Bike | TDSP-C-AGL----- | 3364.0 | 36.84635 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257483 | 257483 | 1989-12-30 14:03:51+00:00 | Bike | TDSP-C-AGL----- | 3330.0 | 34.7564 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257484 | 257484 | 1989-12-30 14:03:58+00:00 | Bike | TDSP-C-AGL----- | 3357.0 | 30.04751 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257485 | 257485 | 1989-12-30 14:04:21+00:00 | Bike | TDSP-C-AGL----- | 3313.0 | 25.68272 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257486 | 257486 | 1989-12-30 14:04:30+00:00 | Bike | TDSP-C-AGL----- | 3310.0 | 33.71354 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257487 | 257487 | 1989-12-30 14:04:35+00:00 | Bike | TDSP-C-AGL----- | 3310.0 | 25.33244 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257488 | 257488 | 1989-12-30 14:04:41+00:00 | Bike | TDSP-C-AGL----- | 3313.0 | 31.79362 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257489 | 257489 | 1989-12-30 14:04:45+00:00 | Bike | TDSP-C-AGL----- | 3305.0 | 30.40008 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257490 | 257490 | 1989-12-30 14:04:51+00:00 | Bike | TDSP-C-AGL----- | 3308.0 | 34.58448 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257491 | 257491 | 1989-12-30 14:05:14+00:00 | Bike | TDSP-C-AGL----- | 3273.0 | 35.21402 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257492 | 257492 | 1989-12-30 14:05:22+00:00 | Bike | TDSPHC-AGL----- | 3263.0 | 36.54607 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257493 | 257493 | 1989-12-30 14:05:55+00:00 | Bike | TDSP-C-AGL----- | 3219.0 | 32.34769 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257494 | 257494 | 1989-12-30 14:06:25+00:00 | Bike | TDSP-C-AGL----- | 3101.0 | 26.29385 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257495 | 257495 | 1989-12-30 14:06:48+00:00 | Bike | TDSP-C-AGL----- | 3149.0 | 31.49169 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257496 | 257496 | 1989-12-30 14:07:30+00:00 | Bike | TDSP-C-AGL----- | 3122.0 | 30.13937 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257497 | 257497 | 1989-12-30 14:07:47+00:00 | Bike | TDSP-C-AGL----- | 3075.0 | 29.08856 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257498 | 257498 | 1989-12-30 14:07:51+00:00 | Bike | TDSP-C-AGL----- | 3061.0 | 23.93736 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257499 | 257499 | 1989-12-30 14:08:18+00:00 | Bike | TDSP-C-AGL----- | 3056.0 | 29.13078 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257500 | 257500 | 1989-12-30 14:08:22+00:00 | Bike | TDSP-C-AGL----- | 3087.0 | 16.148 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257501 | 257501 | 1989-12-30 14:08:40+00:00 | Bike | TDSP-C-AGL----- | 3079.0 | 29.64165 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257502 | 257502 | 1989-12-30 14:08:48+00:00 | Bike | TDSP-C-AGL----- | 3072.0 | 29.94738 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257503 | 257503 | 1989-12-30 14:09:07+00:00 | Bike | TDSP-C-AGL----- | 3034.0 | 24.59682 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
| 257504 | 257504 | 1989-12-30 14:09:11+00:00 | Bike | TDSP-C-AGL----- | 3044.0 | 30.04703 | {32d6c85d-f3b9-4d5e-a0e2-36f83fec9093} |
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");