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 |
|---|---|---|---|---|---|---|---|
| 512 | 512 | 2018-06-23 12:54:36+00:00 | Bike | TDSP-C-AGL-E--- | 12795.0 | 47.88152 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 513 | 513 | 2018-06-29 13:16:55+00:00 | Bike | TDSP-C-AGL-E--- | 2528.0 | 17.35419 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 514 | 514 | 2018-06-29 19:07:02+00:00 | Bike | TDSP-C-AGL-E--- | 3011.0 | 17.75897 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 516 | 516 | 2018-07-08 20:15:23+00:00 | Bike | TDSP-C-AGL-E--- | 2577.0 | 17.73972 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 517 | 517 | 2018-07-08 21:39:38+00:00 | Bike | TDSP-C-AGL-E--- | 2874.0 | 18.22334 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 518 | 518 | 2018-07-10 13:23:09+00:00 | Bike | TDSP-C-AGL-E--- | 1229.0 | 8.31468 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 519 | 519 | 2018-07-10 22:35:26+00:00 | Bike | TDSP-C-AGL-E--- | 1695.0 | 11.4634 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 520 | 520 | 2018-07-10 23:23:23+00:00 | Bike | TDSP-C-AGL-E--- | 4232.0 | 18.26119 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 521 | 521 | 2018-07-12 13:25:26+00:00 | Bike | TDSP-C-AGL-E--- | 1328.0 | 8.38507 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 522 | 522 | 2018-07-12 22:40:52+00:00 | Bike | TDSP-C-AGL-E--- | 1948.0 | 12.48301 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 523 | 523 | 2018-07-13 00:02:17+00:00 | Bike | TDSP-C-AGL-E--- | 2721.0 | 18.17955 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 524 | 524 | 2018-07-13 22:39:48+00:00 | Bike | TDSP-C-AGL-E--- | 23109.0 | 33.44506 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 525 | 525 | 2018-08-02 22:44:51+00:00 | Bike | TDSP-C-AGL-E--- | 989.0 | 6.46157 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 526 | 526 | 2018-08-03 22:18:25+00:00 | Bike | TDSP-C-AGL-E--- | 3949.0 | 21.86938 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 527 | 527 | 2018-08-05 20:07:33+00:00 | Bike | TDSP-C-AGL-E--- | 10464.0 | 52.8175 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 528 | 528 | 2018-08-18 17:47:05+00:00 | Bike | TDSP-C-AGL-E--- | 1416.0 | 8.52088 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 529 | 529 | 2018-08-18 21:04:17+00:00 | Bike | TDSP-C-AGL-E--- | 1156.0 | 7.1781 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 530 | 530 | 2018-08-24 22:19:46+00:00 | Bike | TDSP-C-AGL-E--- | 4266.0 | 27.4391 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 531 | 531 | 2018-08-26 13:54:42+00:00 | Bike | TDSP-C-AGL-E--- | 10249.0 | 61.77855 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 532 | 532 | 2018-08-31 22:18:48+00:00 | Bike | TDSP-C-AGL-E--- | 3961.0 | 23.78397 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 533 | 533 | 2018-09-01 12:42:09+00:00 | Bike | TDSP-C-AGL-E--- | 15711.0 | 94.606 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 534 | 534 | 2018-09-21 22:30:54+00:00 | Bike | TDSP-C-AGL-E--- | 3874.0 | 26.039 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 535 | 535 | 2018-09-25 22:25:23+00:00 | Bike | TDSP-C-AGL-E--- | 2989.0 | 22.75214 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 536 | 536 | 2018-09-28 22:05:26+00:00 | Bike | TDSP-C-AGL-E--- | 6094.0 | 34.5228 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 537 | 537 | 2018-10-05 22:14:50+00:00 | Bike | TDSP-C-AGL-E--- | 5283.0 | 32.47231 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 538 | 538 | 2018-10-12 22:11:28+00:00 | Bike | TDSP-C-AGL-E--- | 5657.0 | 32.7263 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 539 | 539 | 2018-10-25 22:16:35+00:00 | Bike | TDSP-C-AGL-E--- | 6868.0 | 40.74255 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 540 | 540 | 2018-10-26 22:42:20+00:00 | Bike | TDSP-C-AGL-E--- | 3507.0 | 20.94552 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 541 | 541 | 2018-10-27 12:22:37+00:00 | Bike | TDSP-C-AGL-E--- | 17510.0 | 98.32734 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 542 | 542 | 2018-11-03 12:28:40+00:00 | Bike | TDSP-C-AGL-E--- | 18596.0 | 115.82161 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 543 | 543 | 2018-11-17 13:05:22+00:00 | Bike | TDSP-C-AGL-E--- | 35972.0 | 202.55317 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 544 | 544 | 2018-12-01 13:08:41+00:00 | Bike | TDSP-C-AGL-E--- | 15504.0 | 89.707 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 545 | 545 | 2019-01-05 21:49:34+00:00 | Bike | TDSP-C-AGL-E--- | 3779.0 | 25.89251 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 546 | 546 | 2019-01-11 13:09:12+00:00 | Bike | TDSP-C-AGL-E--- | 1652.0 | 0.10228 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 547 | 547 | 2019-01-15 13:12:47+00:00 | Bike | TDSP-C-AGL----- | 1843.0 | 12.45064 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 550 | 550 | 2019-03-25 22:29:27+00:00 | Bike | TDSP-C-AGL-E--- | 2899.0 | 21.02238 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 551 | 551 | 2019-03-29 22:26:25+00:00 | Bike | TDSP-C-AGL-E--- | 4385.0 | 29.28879 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 552 | 552 | 2019-04-05 22:13:41+00:00 | Bike | TDSP-C-AGL-E--- | 5642.0 | 31.4484 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 553 | 553 | 2019-04-08 22:56:45+00:00 | Bike | TDSP-C-AGL-E--- | 3540.0 | 26.7 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 554 | 554 | 2019-04-10 22:48:05+00:00 | Bike | TDSP-C-AGL-E--- | 3410.0 | 25.1621 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 555 | 555 | 2019-04-12 22:39:58+00:00 | Bike | TDSP-C-AGL-E--- | 3451.0 | 23.27448 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 556 | 556 | 2019-04-15 22:44:50+00:00 | Bike | TDSP-C-AGL-E--- | 2197.0 | 15.93686 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 557 | 557 | 2019-04-18 22:37:47+00:00 | Bike | TDSP-C-AGL-E--- | 3832.0 | 27.38456 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 558 | 558 | 2019-05-12 20:55:56+00:00 | Bike | TDSP-C-AGL-E--- | 2960.0 | 21.015 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 559 | 559 | 2019-05-17 22:15:36+00:00 | Bike | TDSP-C-AGL-E--- | 4719.0 | 31.4637 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 560 | 560 | 2019-05-18 12:32:18+00:00 | Bike | TDSP-C-AGL-E--- | 8938.0 | 52.04843 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 564 | 564 | 2019-06-01 18:25:53+00:00 | Bike | TDSP-C-AGL-E--- | 3329.0 | 23.57788 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 565 | 565 | 2019-06-13 22:54:04+00:00 | Bike | TDSP-C-AGL-E--- | 3715.0 | 25.6448 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 566 | 566 | 2019-06-14 22:34:06+00:00 | Bike | TDSP-C-AGL-E--- | 3084.0 | 21.28658 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 567 | 567 | 2019-06-21 22:42:28+00:00 | Bike | TDSP-C-AGL-E--- | 4963.0 | 31.71613 | {96836b71-7497-4393-b0ef-810ee3041daa} |
| 568 | 568 | 2019-06-22 16:27:04+00:00 | Bike | TDSP-C-AGL-E--- | 5474.0 | 32.28636 | {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} |
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");