rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by rowid
This data as json, CSV (advanced)
| Link | rowid ▼ | date | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 407 | 407 | 2018-01-09 15:51:28+00:00 | Bike | TDSPHC-AGL-E--- | 23273.0 | 161.83834 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 408 | 408 | 2018-01-10 16:05:03+00:00 | Bike | TDSPHC-AGL-E--- | 17170.0 | 124.91576 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 409 | 409 | 2018-01-11 15:27:25+00:00 | Bike | TDSPHC-AGL-E--- | 9548.0 | 61.63522 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 410 | 410 | 2018-01-13 18:42:01+00:00 | Bike | TDSPHC-AGL-E--- | 6166.0 | 46.86288 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 411 | 411 | 2018-01-14 18:51:22+00:00 | Bike | TDSPHC-AGL-E--- | 9917.0 | 71.6203 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 412 | 412 | 2018-01-15 20:25:49+00:00 | Bike | TDSPHC-AGL-E--- | 6168.0 | 43.13035 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 413 | 413 | 2018-01-19 16:51:53+00:00 | Bike | TDSPHC-AGL-E--- | 8927.0 | 67.92855 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 414 | 414 | 2018-01-20 19:42:17+00:00 | Bike | TDSPHC-AGL-E--- | 10701.0 | 81.73373 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 415 | 415 | 2018-01-21 20:07:43+00:00 | Bike | TDSPHC-AGL-E--- | 6556.0 | 45.90486 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 416 | 416 | 2018-01-23 18:21:41+00:00 | Bike | TDSPHC-AGL-E--- | 10055.0 | 80.69142 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 417 | 417 | 2018-01-25 21:05:20+00:00 | Bike | TDSPHC-AGL-E--- | 13026.0 | 98.41193 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 418 | 418 | 2018-01-26 21:08:43+00:00 | Bike | TDSPHC-AGL-E--- | 4334.0 | 26.474 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 419 | 419 | 2018-01-26 22:28:46+00:00 | Bike | TDSPHC-AGL-E--- | 6363.0 | 25.50217 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 420 | 420 | 2018-01-27 18:45:49+00:00 | Bike | TDSPHC-AGL-E--- | 7475.0 | 52.70509 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 423 | 423 | 2018-01-28 14:24:00+00:00 | Bike | TDSPHC-AGL-E--- | 10474.0 | 50.27981 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 424 | 424 | 2018-01-30 18:02:46+00:00 | Bike | TDSPHC-AGL-E--- | 14723.0 | 112.96994 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 425 | 425 | 2018-02-01 21:42:49+00:00 | Bike | TDSPHC-AGL-E--- | 8062.0 | 59.79623 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 426 | 426 | 2018-02-02 13:45:07+00:00 | Bike | TDSPHC-AGL-E--- | 9560.0 | 58.82671 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 427 | 427 | 2018-02-02 21:12:01+00:00 | Bike | TDSPHC-AGL-E--- | 3710.0 | 24.51001 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 428 | 428 | 2018-02-02 22:23:48+00:00 | Bike | TDSPHC-AGL-E--- | 4659.0 | 26.61713 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 429 | 429 | 2018-02-03 19:31:12+00:00 | Bike | TDSPHC-AGL-E--- | 7956.0 | 54.8319 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 430 | 430 | 2018-02-04 14:21:14+00:00 | Bike | TDSP-C-AGL-E--- | 9494.0 | 49.06972 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 431 | 431 | 2018-02-06 19:05:39+00:00 | Bike | TDSPHC-AGL-E--- | 8071.0 | 56.33055 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 432 | 432 | 2018-02-08 22:05:08+00:00 | Bike | TDSPHC-AGL-E--- | 5240.0 | 34.90696 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 433 | 433 | 2018-02-09 13:50:02+00:00 | Bike | TDSPHC-AGL-E--- | 19203.0 | 133.29724 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 434 | 434 | 2018-02-09 22:30:47+00:00 | Bike | TDSPHC-AGL-E--- | 4267.0 | 26.12202 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 435 | 435 | 2018-02-10 14:32:38+00:00 | Bike | TDSPHC-AGL-E--- | 17539.0 | 95.15941 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 436 | 436 | 2018-02-13 21:07:44+00:00 | Bike | TDSPHC-AGL-E--- | 7266.0 | 47.95566 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 437 | 437 | 2018-02-14 21:43:58+00:00 | Bike | TDSPHC-AGL-E--- | 8446.0 | 57.92928 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 438 | 438 | 2018-02-15 21:33:58+00:00 | Bike | TDSPHC-AGL-E--- | 7751.0 | 40.14204 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 439 | 439 | 2018-02-16 21:47:43+00:00 | Bike | TDSP-C-AGL-E--- | 7100.0 | 36.34687 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 440 | 440 | 2018-02-17 17:42:52+00:00 | Bike | TDSP-C-AGL-E--- | 4701.0 | 46.5357 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 441 | 441 | 2018-02-17 22:35:24+00:00 | Bike | TDSP-C-AGL-E--- | 997.0 | 10.3274 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 442 | 442 | 2018-02-18 14:01:09+00:00 | Bike | TDSP-C-AGL-E--- | 1937.0 | 20.05965 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 443 | 443 | 2018-02-23 17:07:15+00:00 | Bike | TDSP-C-AGL-E--- | 19853.0 | 143.34898 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 445 | 445 | 2018-02-26 02:17:18+00:00 | Bike | TD-P-C-AGL-E--- | 1802.0 | 0.09241 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 446 | 446 | 2018-02-27 03:28:07+00:00 | Bike | TD-P-C-AGL-E--- | 1946.0 | 0.09452 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 447 | 447 | 2018-02-27 18:46:34+00:00 | Bike | TDSP-C-AGL----- | 4939.0 | 32.41868 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 448 | 448 | 2018-03-02 15:03:55+00:00 | Bike | TDSP-C-AGL-E--- | 3467.0 | 25.29084 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 449 | 449 | 2018-03-03 15:00:16+00:00 | Bike | TDSPHC-AGL-E--- | 1593.0 | 13.6743 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 450 | 450 | 2018-03-03 21:21:01+00:00 | Bike | TDSP-C-AGL-E--- | 4090.0 | 32.59129 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 451 | 451 | 2018-03-09 22:30:53+00:00 | Bike | TDSP-C-AGL-E--- | 4304.0 | 22.43191 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 452 | 452 | 2018-03-16 22:20:18+00:00 | Bike | TDSP-C-AGL-E--- | 6008.0 | 28.00736 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 453 | 453 | 2018-03-17 21:42:07+00:00 | Bike | TDSP-C-AGL-E--- | 5519.0 | 41.73836 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 454 | 454 | 2018-03-18 15:03:23+00:00 | Bike | TDSP-C-AGL-E--- | 7651.0 | 43.4575 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 455 | 455 | 2018-03-19 22:26:58+00:00 | Bike | TDSP-C-AGL-E--- | 6917.0 | 45.29394 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 456 | 456 | 2018-03-20 13:36:27+00:00 | Bike | TDSP-C-AGL-E--- | 8142.0 | 51.63887 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 457 | 457 | 2018-03-23 21:03:11+00:00 | Bike | TDSP-C-AGL-E--- | 9606.0 | 53.67865 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 458 | 458 | 2018-03-24 12:12:03+00:00 | Bike | TDSPHC-AGL-E--- | 18153.0 | 98.39343 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 459 | 459 | 2018-03-29 13:52:22+00:00 | Bike | TDSPHC-AGL-E--- | 6506.0 | 43.57373 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 460 | 460 | 2018-04-02 23:42:03+00:00 | Bike | TDSP-C-AGL-E--- | 4723.0 | 32.17363 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 461 | 461 | 2018-04-04 23:45:38+00:00 | Bike | TDSPHC-AGL-E--- | 4143.0 | 24.86505 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 462 | 462 | 2018-04-05 21:18:54+00:00 | Bike | TDSPHC-AGL-E--- | 2169.0 | 9.96212 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 463 | 463 | 2018-04-05 22:01:31+00:00 | Bike | TDSPHC-AGL-E--- | 1690.0 | 19.80694 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 464 | 464 | 2018-04-05 23:13:43+00:00 | Bike | TDSPHC-AGL-E--- | 1430.0 | 10.36198 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 465 | 465 | 2018-04-06 19:08:42+00:00 | Bike | TDSPHC-AGL-E--- | 16173.0 | 88.61728 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 466 | 466 | 2018-04-12 21:16:05+00:00 | Bike | TDSP-C-AGL-E--- | 10935.0 | 35.7293 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 467 | 467 | 2018-04-13 15:44:29+00:00 | Bike | TDSPHC-AGL-E--- | 2703.0 | 18.10025 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 468 | 468 | 2018-04-13 22:32:46+00:00 | Bike | TDSPHC-AGL-E--- | 4329.0 | 25.58578 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 469 | 469 | 2018-04-14 21:27:48+00:00 | Bike | TDSPHC-AGL-E--- | 7212.0 | 50.44492 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 470 | 470 | 2018-04-15 15:33:37+00:00 | Bike | TDSPHC-AGL-E--- | 7625.0 | 39.5948 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 471 | 471 | 2018-04-17 19:09:13+00:00 | Bike | TDSPHC-AGL-E--- | 7776.0 | 42.31194 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 472 | 472 | 2018-04-27 18:02:56+00:00 | Bike | TDSPHC-AGL-E--- | 7250.0 | 53.06257 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 473 | 473 | 2018-04-27 22:32:10+00:00 | Bike | TDSP-C-AGL-E--- | 3841.0 | 24.36449 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 474 | 474 | 2018-04-29 14:05:56+00:00 | Bike | TDSPHC-AGL-E--- | 10095.0 | 52.188 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 475 | 475 | 2018-05-03 23:15:15+00:00 | Bike | TDSPHC-AGL-E--- | 1293.0 | 13.3248 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 476 | 476 | 2018-05-04 22:27:19+00:00 | Bike | TDSPHC-AGL-E--- | 4071.0 | 25.14925 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 477 | 477 | 2018-05-05 13:37:33+00:00 | Bike | TDSPHC-AGL-E--- | 17552.0 | 99.27133 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 478 | 478 | 2018-05-06 14:06:13+00:00 | Bike | TDSPHC-AGL-E--- | 9709.0 | 56.03836 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 479 | 479 | 2018-05-21 19:39:47+00:00 | Bike | TDSPHC-AGL-E--- | 3699.0 | 26.23361 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 480 | 480 | 2018-05-25 16:17:55+00:00 | Bike | TDSPHC-AGL-E--- | 4655.0 | 31.14608 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 481 | 481 | 2018-05-27 13:28:38+00:00 | Bike | TDSPHC-AGL-E--- | 14075.0 | 94.28457 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 482 | 482 | 2018-05-30 13:01:50+00:00 | Bike | TDSPHC-AGL-E--- | 3640.0 | 25.4517 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 483 | 483 | 2018-05-31 12:55:08+00:00 | Bike | TDSPHC-AGL-E--- | 2812.0 | 17.293 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 485 | 485 | 2018-06-03 19:52:56+00:00 | Bike | TDSP-C-AGL-E--- | 2683.0 | 18.26137 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 486 | 486 | 2018-06-04 12:51:20+00:00 | Bike | TDSP-C-AGL-E--- | 2545.0 | 17.0205 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 487 | 487 | 2018-06-05 20:33:54+00:00 | Bike | TDSP-C-AGL-E--- | 2934.0 | 17.79455 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 488 | 488 | 2018-06-05 21:36:43+00:00 | Bike | TDSP-C-AGL-E--- | 1793.0 | 11.77824 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 489 | 489 | 2018-06-06 11:49:51+00:00 | Bike | TDSP-C-AGL-E--- | 2676.0 | 17.77442 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 490 | 490 | 2018-06-06 23:09:58+00:00 | Bike | TDSP-C-AGL-E--- | 2978.0 | 18.1483 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 491 | 491 | 2018-06-07 13:16:42+00:00 | Bike | TDSP-C-AGL-E--- | 2354.0 | 16.70468 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 492 | 492 | 2018-06-07 22:45:01+00:00 | Bike | TDSP-C-AGL-E--- | 2933.0 | 18.21898 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 493 | 493 | 2018-06-08 13:32:34+00:00 | Bike | TDSP-C-AGL-E--- | 2551.0 | 17.63081 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 494 | 494 | 2018-06-08 22:38:11+00:00 | Bike | TDSP-C-AGL-E--- | 2788.0 | 18.15086 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 495 | 495 | 2018-06-10 22:55:19+00:00 | Bike | TDSP-C-AGL-E--- | 2618.0 | 18.10268 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 496 | 496 | 2018-06-11 13:38:46+00:00 | Bike | TDSP-C-AGL-E--- | 2629.0 | 17.07571 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 497 | 497 | 2018-06-11 23:28:30+00:00 | Bike | TDSP-C-AGL-E--- | 2790.0 | 18.0325 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 498 | 498 | 2018-06-12 12:04:38+00:00 | Bike | TDSP-C-AGL-E--- | 2716.0 | 17.671 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 499 | 499 | 2018-06-13 23:08:23+00:00 | Bike | TDSP-C-AGL-E--- | 2817.0 | 18.1734 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 501 | 501 | 2018-06-14 23:35:47+00:00 | Bike | TDSP-C-AGL-E--- | 2929.0 | 18.3709 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 502 | 502 | 2018-06-15 13:19:51+00:00 | Bike | TDSP-C-AGL-E--- | 5504.0 | 37.47119 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 503 | 503 | 2018-06-15 15:49:11+00:00 | Bike | TDSP-C-AGL-E--- | 2860.0 | 18.21751 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 504 | 504 | 2018-06-18 14:36:14+00:00 | Bike | TDSP-C-AGL-E--- | 2627.0 | 17.91096 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 505 | 505 | 2018-06-18 22:47:09+00:00 | Bike | TDSP-C-AGL-E--- | 3072.0 | 18.05003 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 506 | 506 | 2018-06-19 16:02:24+00:00 | Bike | TDSP-C-AGL-E--- | 2816.0 | 17.81073 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 507 | 507 | 2018-06-19 23:23:59+00:00 | Bike | TDSP-C-AGL-E--- | 2842.0 | 18.293 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 508 | 508 | 2018-06-20 13:00:08+00:00 | Bike | TDSP-C-AGL-E--- | 2905.0 | 17.43013 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 509 | 509 | 2018-06-21 21:49:51+00:00 | Bike | TDSP-C-AGL-E--- | 3138.0 | 18.20019 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 510 | 510 | 2018-06-22 13:38:32+00:00 | Bike | TDSP-C-AGL-E--- | 2875.0 | 17.86254 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 511 | 511 | 2018-06-22 22:23:54+00:00 | Bike | TDSP-C-AGL-E--- | 2906.0 | 17.87403 | {96836b71-7497-4393-b0ef-810ee3041daa} |
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");