rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,238,511 rows where data contains "H" and data contains "P" sorted by rowid
This data as json, CSV (advanced)
| Link | rowid ▼ | date | sport | data | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 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} |
| 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} |
| 449 | 449 | 2018-03-03 15:00:16+00:00 | Bike | TDSPHC-AGL-E--- | 1593.0 | 13.6743 | {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} |
| 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} |
| 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} |
| 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} |
| 569 | 569 | 2015-01-01 11:55:46+00:00 | Bike | TDSPHC-AGL-E--- | 3913.0 | 33.68118 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 570 | 570 | 2015-01-11 10:58:13+00:00 | Bike | TDSPHC-AGL-E--- | 5508.0 | 49.72039 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 571 | 571 | 2015-01-17 12:01:14+00:00 | Bike | TDSPHC-AGL-E--- | 3980.0 | 35.64628 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 572 | 572 | 2015-01-18 08:12:27+00:00 | Bike | TDSPHC-AGL-E--- | 5095.0 | 43.99091 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 573 | 573 | 2015-01-20 18:38:01+00:00 | Elite Fluid | TDSPHC-AGL----- | 2839.0 | 17.02071 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 574 | 574 | 2015-01-21 14:22:49+00:00 | Bike | TDSPHC-AGL-E--- | 3544.0 | 34.29863 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 576 | 576 | 2015-01-25 14:46:52+00:00 | Elite Fluid | TDSPHC-A-L----- | 3673.0 | 22.10276 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 580 | 580 | 2015-02-01 17:41:00+00:00 | Elite Fluid | TDSPHC-A-L----- | 3314.0 | 21.47108 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 581 | 581 | 2015-02-03 13:53:13+00:00 | Bike | TDSPHC-AGL-E--- | 3649.0 | 36.39004 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 582 | 582 | 2015-02-06 18:17:48+00:00 | Elite Fluid | TDSPHC-A-L----- | 3491.0 | 21.57716 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 583 | 583 | 2015-02-07 15:13:45+00:00 | Elite Fluid | TDSPHC-A-L----- | 3814.0 | 22.32253 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 584 | 584 | 2015-02-08 18:45:20+00:00 | Elite Fluid | TDSPHC-A-L----- | 2719.0 | 17.70389 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 585 | 585 | 2015-02-10 17:11:33+00:00 | Elite Fluid | TDSPHC-A-L----- | 4404.0 | 24.27558 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 586 | 586 | 2015-02-11 15:35:57+00:00 | Elite Fluid | TDSPHC-A-L----- | 3628.0 | 23.11757 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 587 | 587 | 2015-02-12 19:19:42+00:00 | Elite Fluid | TDSPHC-A-L----- | 4216.0 | 27.58969 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 588 | 588 | 2015-02-14 12:48:18+00:00 | Bike | TDSPHC-AGL-E--- | 7559.0 | 68.39319 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 589 | 589 | 2015-02-15 09:48:15+00:00 | Bike | TDSPHC-AGL-E--- | 8932.0 | 60.78063 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 590 | 590 | 2015-02-17 08:15:28+00:00 | Bike | TDSPHC-AGL-E--- | 3980.0 | 32.57721 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 591 | 591 | 2015-02-18 16:31:04+00:00 | Elite Fluid | TDSPHC-A-L----- | 3962.0 | 24.98177 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 592 | 592 | 2015-02-19 19:14:27+00:00 | Elite Fluid | TDSPHC-A-L----- | 4418.0 | 29.57007 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 593 | 593 | 2015-02-21 11:24:21+00:00 | Bike | TDSPHC-AGL-E--- | 8512.0 | 70.80928 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 594 | 594 | 2015-02-22 08:03:54+00:00 | Bike | TDSPHC-AGL-E--- | 8299.0 | 70.51125 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 595 | 595 | 2015-02-24 14:29:45+00:00 | Bike | TDSPHC-AGL-E--- | 4069.0 | 33.48663 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 596 | 596 | 2015-02-25 19:04:27+00:00 | Elite Fluid | TDSPHC-A-L----- | 3607.0 | 24.00596 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 597 | 597 | 2015-02-26 19:16:03+00:00 | Elite Fluid | TDSPHC-A-L----- | 2403.0 | 14.72096 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 598 | 598 | 2015-03-01 10:29:16+00:00 | Bike | TDSPHC-AGL-E--- | 11790.0 | 73.23188 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 599 | 599 | 2015-03-02 13:59:37+00:00 | Bike | TDSPHC-AGL-E--- | 7308.0 | 65.77522 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 600 | 600 | 2015-03-05 19:20:40+00:00 | Elite Fluid | TDSPHC--------- | 3480.0 | 22.24813 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 601 | 601 | 2015-03-06 18:13:15+00:00 | Elite Fluid | TDSPHC--------- | 4140.0 | 29.00802 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 602 | 602 | 2015-03-07 13:52:01+00:00 | Elite Fluid | TDSPHC--------- | 4320.0 | 32.31284 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 603 | 603 | 2015-03-08 13:32:46+00:00 | Bike | TDSPHC-AGL----- | 6007.0 | 55.18342 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 604 | 604 | 2015-03-10 14:36:29+00:00 | Elite Fluid | TDSPHC--------- | 3900.0 | 29.81156 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 605 | 605 | 2015-03-11 19:52:15+00:00 | Elite Fluid | TDSPHC--------- | 4560.0 | 33.94397 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 606 | 606 | 2015-03-12 15:59:38+00:00 | Elite Fluid | TDSPHC--------- | 4260.0 | 32.38121 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 609 | 609 | 2015-03-17 18:51:33+00:00 | Elite Fluid | TDSPHC--------- | 3420.0 | 24.47714 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 611 | 611 | 2015-03-19 19:09:37+00:00 | Elite Fluid | TDSPHC--------- | 4140.0 | 31.57142 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 612 | 612 | 2015-03-21 08:11:57+00:00 | Bike | TDSPHC-AGL----- | 2422.0 | 17.579 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 613 | 613 | 2015-03-22 08:47:53+00:00 | Bike | TDSPHC-AGL----- | 11895.0 | 74.02964 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 615 | 615 | 2015-03-25 19:34:21+00:00 | Elite Fluid | TDSPHC--------- | 3783.0 | 29.24009 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 617 | 617 | 2015-03-28 16:36:05+00:00 | Elite Fluid | TDSPHC--------- | 5100.0 | 39.49068 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 620 | 620 | 2015-04-02 16:35:38+00:00 | Elite Fluid | TDSPHC--------- | 3364.0 | 25.62305 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 621 | 621 | 2015-04-04 09:45:51+00:00 | Bike | TDSPHC-AGL-E--- | 7298.0 | 61.37893 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 622 | 622 | 2015-04-05 14:09:08+00:00 | Bike | TDSPHC--------- | 4925.0 | 36.41657 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 623 | 623 | 2015-04-06 17:40:53+00:00 | Elite Fluid | TDSPHC--------- | 5103.0 | 38.19768 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 624 | 624 | 2015-04-08 17:56:38+00:00 | Elite Fluid | TDSPHC--------- | 3364.0 | 26.13043 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 625 | 625 | 2015-04-09 18:53:28+00:00 | Elite Fluid | TDSPHC--------- | 3602.0 | 27.1592 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 626 | 626 | 2015-04-10 11:03:27+00:00 | Bike | TDSPHC-AGL-E--- | 5253.0 | 40.01272 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 627 | 627 | 2015-04-11 08:11:14+00:00 | Bike | TDSPHC-AGL-E--- | 13129.0 | 109.61891 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 628 | 628 | 2015-04-12 07:36:20+00:00 | Bike | TDSPHC-AGL-E--- | 4190.0 | 35.13393 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 629 | 629 | 2015-04-13 08:48:56+00:00 | Bike | TDSPHC-AGL-E--- | 11378.0 | 94.1292 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 630 | 630 | 2015-04-15 14:19:34+00:00 | Bike | TDSPHC-AGL-E--- | 5305.0 | 38.09973 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 631 | 631 | 2015-04-16 14:16:24+00:00 | Bike | TDSPHC-AGL-E--- | 5310.0 | 39.98344 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 632 | 632 | 2015-04-18 13:16:34+00:00 | Bike | TDSPHC--------- | 3004.0 | 21.47138 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 633 | 633 | 2015-04-19 08:55:32+00:00 | Bike | TDSPHC-AGL-E--- | 8825.0 | 59.32628 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 634 | 634 | 2015-04-21 14:17:05+00:00 | Bike | TDSPHC-AGL-E--- | 4579.0 | 42.15795 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 635 | 635 | 2015-04-22 14:20:57+00:00 | Bike | TDSPHC-AGL-E--- | 4405.0 | 29.64696 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 636 | 636 | 2015-04-23 14:45:05+00:00 | Bike | TDSPHC-AGL-E--- | 5595.0 | 37.5593 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 637 | 637 | 2015-04-25 07:07:40+00:00 | Bike | TDSPHC-AGL-E--- | 7300.0 | 63.37305 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 639 | 639 | 2015-04-28 15:10:43+00:00 | Bike | TDSPHC-AGL-E--- | 6554.0 | 44.93513 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 640 | 640 | 2015-04-29 15:15:13+00:00 | Bike | TDSPHC-AGL-E--- | 5212.0 | 38.15051 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
| 641 | 641 | 2015-04-30 15:28:02+00:00 | Bike | TDSPHC-AGL-E--- | 5620.0 | 45.04576 | {35266436-ec7a-4e34-b67d-eb2b6dcf9347} |
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");