rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by athlete
This data as json, CSV (advanced)
| Link | rowid | date | sport | data | workout_time | total_distance | athlete ▼ |
|---|---|---|---|---|---|---|---|
| 2578509 | 2578509 | 2017-01-31 17:36:44+00:00 | Bike | T--PHC-A---E--- | 3948.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578510 | 2578510 | 2017-02-01 13:48:14+00:00 | Bike | TDSPHC-AGL-E--- | 12753.0 | 84.50926 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578511 | 2578511 | 2017-02-04 12:45:56+00:00 | Bike | TDSP-C-AGL-E--- | 2194.0 | 7.98597 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578512 | 2578512 | 2017-02-06 14:31:55+00:00 | Bike | TDSP-C-AGL-E--- | 6999.0 | 56.78254 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578513 | 2578513 | 2017-02-07 14:03:11+00:00 | Bike | TDSP-C-AGL-E--- | 9118.0 | 67.66098 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578514 | 2578514 | 2017-02-10 11:34:00+00:00 | Bike | TDSP-C-AGL-E--- | 4499.0 | 38.67401 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578515 | 2578515 | 2017-02-11 08:32:10+00:00 | Bike | TDSP-C-AGL-E--- | 10904.0 | 70.02189 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578516 | 2578516 | 2017-02-15 14:05:14+00:00 | Bike | TDSPHC-AGL-E--- | 10652.0 | 82.82748 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578517 | 2578517 | 2017-02-18 07:38:56+00:00 | Bike | TDSPHC-AGL-E--- | 23457.0 | 113.20216 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578518 | 2578518 | 2017-02-19 08:53:59+00:00 | Bike | TDSPHC-AGL-E--- | 18207.0 | 129.89071 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578520 | 2578520 | 2017-02-20 14:18:10+00:00 | Bike | TDSPHC-AGL-E--- | 10173.0 | 87.4868 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578521 | 2578521 | 2017-02-21 14:22:56+00:00 | Bike | TDSPHC-AGL-E--- | 7158.0 | 57.8449 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578522 | 2578522 | 2017-02-22 14:03:45+00:00 | Bike | TDSPHC-AGL-E--- | 10910.0 | 85.5793 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578523 | 2578523 | 2017-02-23 07:02:37+00:00 | Bike | TDSPHC-AGL-E--- | 11260.0 | 84.18074 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578524 | 2578524 | 2017-02-24 06:48:24+00:00 | Bike | T--PHC-A---E--- | 5512.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578525 | 2578525 | 2017-02-27 14:09:01+00:00 | Bike | TDSPHC-AGL-E--- | 9685.0 | 83.40971 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578526 | 2578526 | 2017-03-01 13:42:53+00:00 | Bike | TDSPHC-AGL-E--- | 12350.0 | 103.32681 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578527 | 2578527 | 2017-03-02 13:59:41+00:00 | Bike | TDSPHC-AGL-E--- | 11624.0 | 88.85998 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578528 | 2578528 | 2017-03-03 07:21:28+00:00 | Bike | T--PHC-A---E--- | 2427.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578529 | 2578529 | 2017-03-04 09:13:00+00:00 | Bike | TDSPHC-AGL-E--- | 7551.0 | 52.9397 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578530 | 2578530 | 2017-05-03 13:41:33+00:00 | Bike | TDSPHC-AGL-E--- | 8496.0 | 71.47421 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578531 | 2578531 | 2017-05-04 06:17:38+00:00 | Bike | TDSPHC-AGL-E--- | 16573.0 | 113.85807 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578532 | 2578532 | 2017-05-06 06:40:37+00:00 | Bike | TDSPHC-AGL-E--- | 27901.0 | 136.263 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578533 | 2578533 | 2017-05-08 13:07:23+00:00 | Bike | TDSPHC-AGL-E--- | 8616.0 | 66.3638 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578534 | 2578534 | 2017-05-09 10:45:59+00:00 | Bike | TDSPHC-AGL-E--- | 7220.0 | 56.65655 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578535 | 2578535 | 2017-05-10 13:13:18+00:00 | Bike | TDSPHC-AGL-E--- | 10184.0 | 84.01992 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578536 | 2578536 | 2017-05-13 08:24:16+00:00 | Bike | TDSPHC-AGL-E--- | 5519.0 | 21.10807 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578537 | 2578537 | 2017-05-14 07:50:27+00:00 | Bike | TDSPHC-AGL-E--- | 9098.0 | 72.25288 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578538 | 2578538 | 2017-05-15 13:16:25+00:00 | Bike | TDSPHC-AGL-E--- | 10419.0 | 80.39875 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578539 | 2578539 | 2017-05-16 16:52:23+00:00 | Bike | TDSPHC-AGL-E--- | 5226.0 | 45.99861 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578540 | 2578540 | 2017-05-17 16:47:11+00:00 | Bike | TDSPHC-AGL-E--- | 6861.0 | 56.03488 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578541 | 2578541 | 2017-05-18 10:33:48+00:00 | Bike | TDSPHC-AGL-E--- | 23100.0 | 155.48445 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578542 | 2578542 | 2017-05-20 16:45:54+00:00 | Bike | TDSPHC-AGL-E--- | 4852.0 | 40.4327 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578543 | 2578543 | 2017-05-22 12:28:44+00:00 | Bike | TDSPHC-AGL-E--- | 12726.0 | 86.9122 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578544 | 2578544 | 2017-05-24 08:05:22+00:00 | Bike | TDSPHC-AGL-E--- | 15146.0 | 104.83355 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578546 | 2578546 | 2017-05-25 07:40:37+00:00 | Bike | TDSPHC-AGL-E--- | 13983.0 | 86.99619 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578547 | 2578547 | 2017-05-25 17:05:07+00:00 | Bike | TDSPHC-AGL-E--- | 6615.0 | 52.6643 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578548 | 2578548 | 2017-05-26 09:15:43+00:00 | Bike | TDSPHC-AGL-E--- | 7636.0 | 36.36596 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578550 | 2578550 | 2017-05-30 06:11:01+00:00 | Bike | TDSPHC-AGL-E--- | 25149.0 | 179.89687 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578551 | 2578551 | 2017-06-01 07:16:14+00:00 | Bike | TDSPHC-AGL-E--- | 7686.0 | 55.7674 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578552 | 2578552 | 2017-06-02 09:48:12+00:00 | Bike | TDSPHC-AGL-E--- | 4971.0 | 27.03776 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578553 | 2578553 | 2017-06-03 07:55:09+00:00 | Bike | TDSPHC-AGL-E--- | 11317.0 | 124.57 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578554 | 2578554 | 2017-06-04 07:26:23+00:00 | Bike | TDSPHC-AGL-E--- | 9047.0 | 93.2078 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578555 | 2578555 | 2017-06-05 16:28:42+00:00 | Bike | TDSPHC-AGL-E--- | 9269.0 | 75.5925 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578556 | 2578556 | 2017-06-07 15:27:38+00:00 | Bike | TDSPHC-AGL-E--- | 11015.0 | 88.2252 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578557 | 2578557 | 2017-06-09 09:34:49+00:00 | Bike | TDSPHC-AGL-E--- | 25193.0 | 170.96257 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578558 | 2578558 | 2017-06-11 05:54:51+00:00 | Bike | TDSPHC-AGL-E--- | 17835.0 | 129.16283 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578559 | 2578559 | 2017-06-12 16:26:16+00:00 | Bike | TDSPHC-AGL-E--- | 8437.0 | 69.38679 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578560 | 2578560 | 2017-06-13 08:16:10+00:00 | Bike | TDSPHC-AGL-E--- | 19911.0 | 141.46237 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578561 | 2578561 | 2017-06-14 06:53:51+00:00 | Bike | TDSPHC-AGL-E--- | 9151.0 | 70.27582 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578562 | 2578562 | 2017-06-16 07:54:17+00:00 | Bike | TDSPHC-AGL-E--- | 11354.0 | 78.63581 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578563 | 2578563 | 2017-06-20 08:57:51+00:00 | Bike | TDSPHC-AGL-E--- | 9366.0 | 68.85695 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578564 | 2578564 | 2017-06-21 05:59:49+00:00 | Bike | TDSPHC-AGL-E--- | 6795.0 | 56.11633 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578565 | 2578565 | 2017-06-22 05:30:36+00:00 | Bike | TDSPHC-AGL-E--- | 15255.0 | 114.975 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578566 | 2578566 | 2017-06-23 15:43:12+00:00 | Bike | TDSPHC-AGL-E--- | 5239.0 | 44.02941 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578567 | 2578567 | 2017-06-24 07:25:28+00:00 | Bike | TDSPHC-AGL-E--- | 9339.0 | 90.1642 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578568 | 2578568 | 2017-06-26 13:59:59+00:00 | Bike | TDSPHC-AGL-E--- | 12891.0 | 87.85498 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578569 | 2578569 | 2017-06-27 08:31:10+00:00 | Bike | TDSPHC-AGL-E--- | 14174.0 | 84.14893 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578570 | 2578570 | 2017-06-28 08:27:01+00:00 | Bike | TDSPHC-AGL-E--- | 6625.0 | 45.18732 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578571 | 2578571 | 2017-06-29 07:23:56+00:00 | Bike | TDSPHC-AGL-E--- | 11785.0 | 132.913 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578572 | 2578572 | 2017-06-30 08:13:42+00:00 | Bike | TDSPHC-AGL-E--- | 10560.0 | 81.82537 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578573 | 2578573 | 2017-07-01 08:45:36+00:00 | Bike | TDSPHC-AGL-E--- | 3529.0 | 29.86452 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578574 | 2578574 | 2017-07-02 07:52:46+00:00 | Bike | TDSPHC-AGL-E--- | 11205.0 | 116.414 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578575 | 2578575 | 2017-07-03 14:51:19+00:00 | Bike | TDSPHC-AGL-E--- | 13147.0 | 88.1261 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578576 | 2578576 | 2017-07-04 07:50:17+00:00 | Bike | TDSPHC-AGL-E--- | 9152.0 | 67.31983 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578577 | 2578577 | 2017-07-05 05:00:50+00:00 | Bike | TDSPHC-AGL-E--- | 19939.0 | 163.3084 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578578 | 2578578 | 2017-07-06 08:30:19+00:00 | Bike | TDSP-C-AGL-E--- | 8183.0 | 55.37698 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578579 | 2578579 | 2017-07-08 08:25:33+00:00 | Bike | TDSPHC-AGL-E--- | 13457.0 | 145.083 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578580 | 2578580 | 2017-07-09 07:25:00+00:00 | Bike | TDSPHC-AGL-E--- | 11134.0 | 121.625 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578581 | 2578581 | 2017-07-10 08:22:30+00:00 | Bike | TDSPHC-AGL-E--- | 11051.0 | 49.16317 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578582 | 2578582 | 2017-07-11 08:22:11+00:00 | Bike | TDSPHC-AGL-E--- | 30222.0 | 119.73875 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578583 | 2578583 | 2017-07-12 06:06:17+00:00 | Bike | TDSPHC-AGL-E--- | 23406.0 | 128.92583 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578584 | 2578584 | 2017-07-13 06:29:41+00:00 | Bike | TDSPHC-AGL-E--- | 19676.0 | 120.0152 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578585 | 2578585 | 2017-07-13 12:33:32+00:00 | Bike | TDSPHC-AGL-E--- | 1231.0 | 4.49955 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578586 | 2578586 | 2017-07-13 15:33:30+00:00 | Bike | TDSPHC-AGL-E--- | 7272.0 | 48.8961 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578587 | 2578587 | 2017-07-14 05:06:25+00:00 | Bike | TDSPHC-AGL-E--- | 6960.0 | 48.28677 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578588 | 2578588 | 2017-07-15 13:22:01+00:00 | Bike | TDSPHC-AGL-E--- | 12090.0 | 89.0623 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578589 | 2578589 | 2017-07-18 13:51:38+00:00 | Bike | TDSPHC-AGL-E--- | 11644.0 | 101.832 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578590 | 2578590 | 2017-07-19 07:19:25+00:00 | Bike | TDSPHC-AGL-E--- | 15888.0 | 123.99947 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578591 | 2578591 | 2017-07-20 07:12:40+00:00 | Bike | TDSPHC-AGL-E--- | 19762.0 | 138.24761 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578592 | 2578592 | 2017-07-21 11:00:36+00:00 | Bike | TDSPHC-AGL-E--- | 5425.0 | 46.37329 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578593 | 2578593 | 2017-07-21 16:28:47+00:00 | Bike | TDSPHC-AGL-E--- | 6098.0 | 46.01134 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578594 | 2578594 | 2017-07-22 06:15:05+00:00 | Bike | TDSPHC-AGL-E--- | 21043.0 | 147.04156 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578595 | 2578595 | 2017-07-23 05:44:50+00:00 | Bike | TDSPHC-AGL-E--- | 23863.0 | 148.66904 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578596 | 2578596 | 2017-07-24 08:36:58+00:00 | Bike | TDSPHC-AGL-E--- | 9224.0 | 59.2291 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578597 | 2578597 | 2017-07-25 08:08:35+00:00 | Bike | TDSPHC-AGL-E--- | 14001.0 | 70.2457 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578598 | 2578598 | 2017-07-25 12:02:08+00:00 | Bike | TDSPHC-AGL-E--- | 1310.0 | 11.2566 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578599 | 2578599 | 2017-07-26 08:29:46+00:00 | Bike | TDSPHC-AGL-E--- | 69.0 | 0.22368 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578600 | 2578600 | 2017-07-26 08:31:29+00:00 | Bike | TDSPHC-AGL-E--- | 21578.0 | 125.613 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578601 | 2578601 | 2017-07-27 07:00:04+00:00 | Bike | TDSPHC-AGL-E--- | 18063.0 | 106.31475 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578603 | 2578603 | 2017-07-28 09:58:33+00:00 | Bike | TDSPHC-AGL-E--- | 7119.0 | 41.20066 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578606 | 2578606 | 2017-08-02 07:32:46+00:00 | Bike | TDSPHC-AGL-E--- | 12213.0 | 95.1225 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578607 | 2578607 | 2017-08-02 10:59:09+00:00 | Bike | T--PHC-A---E--- | 1827.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578608 | 2578608 | 2017-08-03 07:51:35+00:00 | Bike | TDSPHC-AGL-E--- | 7555.0 | 52.73409 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578609 | 2578609 | 2017-08-03 10:08:20+00:00 | Bike | T--PHC-A---E--- | 982.0 | {000c6417-e1e4-497e-89e6-bb21e17ec355} | |
| 2578610 | 2578610 | 2017-08-07 07:00:18+00:00 | Bike | TDSPHC-AGL-E--- | 16517.0 | 116.31595 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578611 | 2578611 | 2017-08-07 16:04:11+00:00 | Bike | TDSPHC-AGL-E--- | 8018.0 | 53.22113 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578612 | 2578612 | 2017-08-08 07:03:23+00:00 | Bike | TDSPHC-AGL-E--- | 9593.0 | 67.42696 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578613 | 2578613 | 2017-08-09 07:52:47+00:00 | Bike | TDSPHC-AGL-E--- | 3457.0 | 27.2569 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
| 2578614 | 2578614 | 2017-08-09 13:59:47+00:00 | Bike | TDSP-C-AGL-E--- | 9561.0 | 100.674 | {000c6417-e1e4-497e-89e6-bb21e17ec355} |
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");