rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
1,460,162 rows where data contains "P" sorted by data
This data as json, CSV (advanced)
| Link | rowid | date | sport | data ▼ | workout_time | total_distance | athlete |
|---|---|---|---|---|---|---|---|
| 2223296 | 2223296 | 2018-06-07 15:31:36+00:00 | Bike | -DSPH--A-L----- | 1.0 | 12.4257 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 551011 | 551011 | 2018-05-17 09:37:10+00:00 | Bike | -DSPH--AGL----- | 1.0 | 39.75965 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551012 | 551012 | 2018-05-18 19:23:43+00:00 | Bike | -DSPH--AGL----- | 1.0 | 31.9157 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551015 | 551015 | 2018-05-23 09:35:46+00:00 | Bike | -DSPH--AGL----- | 1.0 | 44.7317 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 551021 | 551021 | 2018-06-03 17:49:43+00:00 | Bike | -DSPH--AGL----- | 1.0 | 11.9466 | {5353813e-daab-4089-98d2-f51864e09bd0} |
| 1041726 | 1041726 | 2018-02-12 14:15:42+00:00 | VirtualRide | -DSPH--AGL----- | 1.0 | 21.3363 | {5ca1341d-c4c0-41a4-a13e-121c4adb4edd} |
| 1292258 | 1292258 | 2018-07-15 16:42:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 31.1065 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292266 | 1292266 | 2018-07-28 07:29:12+00:00 | Bike | -DSPH--AGL----- | 1.0 | 26.9897 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292277 | 1292277 | 2018-08-12 09:18:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.9704 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292278 | 1292278 | 2018-08-13 17:49:23+00:00 | Bike | -DSPH--AGL----- | 1.0 | 14.9956 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292279 | 1292279 | 2018-08-14 18:21:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 20.3966 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292286 | 1292286 | 2018-08-25 07:38:30+00:00 | Bike | -DSPH--AGL----- | 1.0 | 21.2044 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292294 | 1292294 | 2018-09-01 17:58:34+00:00 | Bike | -DSPH--AGL----- | 1.0 | 27.7099 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292298 | 1292298 | 2018-09-02 12:57:48+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.4352 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292302 | 1292302 | 2018-09-08 07:26:05+00:00 | Bike | -DSPH--AGL----- | 1.0 | 8.27626 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292311 | 1292311 | 2018-09-22 07:31:02+00:00 | Bike | -DSPH--AGL----- | 1.0 | 10.5845 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292316 | 1292316 | 2018-09-29 08:56:03+00:00 | Bike | -DSPH--AGL----- | 1.0 | 62.4442 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292317 | 1292317 | 2018-09-29 11:03:49+00:00 | Bike | -DSPH--AGL----- | 1.0 | 4.9742 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292327 | 1292327 | 2018-10-16 18:02:39+00:00 | Bike | -DSPH--AGL----- | 1.0 | 26.2458 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292330 | 1292330 | 2018-10-20 10:54:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 60.2107 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292331 | 1292331 | 2018-10-21 08:41:23+00:00 | Bike | -DSPH--AGL----- | 1.0 | 67.3789 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292342 | 1292342 | 2018-11-01 11:44:00+00:00 | Bike | -DSPH--AGL----- | 1.0 | 29.81353 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292349 | 1292349 | 2018-11-09 14:37:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.8661 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292350 | 1292350 | 2018-11-10 10:52:24+00:00 | Bike | -DSPH--AGL----- | 1.0 | 29.2327 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292361 | 1292361 | 2018-11-24 14:06:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.4337 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292370 | 1292370 | 2018-12-06 14:27:52+00:00 | Bike | -DSPH--AGL----- | 1.0 | 67.2021 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292376 | 1292376 | 2018-12-14 19:44:51+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.0028 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292379 | 1292379 | 2018-12-18 18:56:50+00:00 | Bike | -DSPH--AGL----- | 1.0 | 16.4035 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292380 | 1292380 | 2018-12-18 19:55:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 1.43373 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292418 | 1292418 | 2019-02-05 19:34:12+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.007 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292420 | 1292420 | 2019-02-06 19:31:22+00:00 | Bike | -DSPH--AGL----- | 1.0 | 13.9369 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292442 | 1292442 | 2019-03-08 18:18:29+00:00 | Bike | -DSPH--AGL----- | 1.0 | 32.508 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292443 | 1292443 | 2019-03-09 10:42:28+00:00 | Bike | -DSPH--AGL----- | 1.0 | 42.9329 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292450 | 1292450 | 2019-03-20 18:48:49+00:00 | Bike | -DSPH--AGL----- | 1.0 | 13.6489 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292451 | 1292451 | 2019-03-21 19:21:08+00:00 | Bike | -DSPH--AGL----- | 1.0 | 9.5544 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292456 | 1292456 | 2019-03-28 18:59:55+00:00 | Bike | -DSPH--AGL----- | 1.0 | 17.1699 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292460 | 1292460 | 2019-04-03 17:54:52+00:00 | Bike | -DSPH--AGL----- | 1.0 | 20.2673 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292461 | 1292461 | 2019-04-04 18:13:37+00:00 | Bike | -DSPH--AGL----- | 1.0 | 12.7492 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292466 | 1292466 | 2019-04-09 18:16:07+00:00 | Bike | -DSPH--AGL----- | 1.0 | 22.5055 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292467 | 1292467 | 2019-04-10 18:13:53+00:00 | Bike | -DSPH--AGL----- | 1.0 | 15.3131 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1292471 | 1292471 | 2019-04-14 10:51:07+00:00 | Bike | -DSPH--AGL----- | 1.0 | 0.95494 | {e1c4129e-c079-477c-9bff-40e92e4eb8c1} |
| 1677930 | 1677930 | 2018-08-28 10:28:03+00:00 | Bike | -DSPH--AGL----- | 1.0 | 56.246 | {7d770f18-c686-4d2a-9cea-3d0c00881b46} |
| 1677932 | 1677932 | 2018-08-28 19:38:18+00:00 | Bike | -DSPH--AGL----- | 1.0 | 8.813 | {7d770f18-c686-4d2a-9cea-3d0c00881b46} |
| 1743818 | 1743818 | 2019-01-29 19:28:03+00:00 | Bike | -DSPH--AGL----- | 1.0 | 20.2925 | {28370ae4-e020-4965-a12c-44c0bda6f353} |
| 1743820 | 1743820 | 2019-01-31 19:58:45+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.5667 | {28370ae4-e020-4965-a12c-44c0bda6f353} |
| 2223064 | 2223064 | 2017-01-12 15:03:25+00:00 | VirtualRide | -DSPH--AGL----- | 1.0 | 23.5857 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223074 | 2223074 | 2017-02-02 09:43:16+00:00 | Ride | -DSPH--AGL----- | 1.0 | 33.4509 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223083 | 2223083 | 2017-02-20 08:15:32+00:00 | Ride | -DSPH--AGL----- | 1.0 | 41.7037 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223185 | 2223185 | 2017-08-17 08:03:59+00:00 | Ride | -DSPH--AGL----- | 1.0 | 0.979 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223186 | 2223186 | 2017-08-17 08:07:16+00:00 | Ride | -DSPH--AGL----- | 1.0 | 23.6121 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223194 | 2223194 | 2017-09-12 08:06:20+00:00 | Ride | -DSPH--AGL----- | 1.0 | 0.7371 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223214 | 2223214 | 2018-01-08 08:10:24+00:00 | Bike | -DSPH--AGL----- | 1.0 | 31.9427 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223221 | 2223221 | 2018-01-15 15:20:33+00:00 | Bike | -DSPH--AGL----- | 1.0 | 24.4665 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223222 | 2223222 | 2018-01-17 09:01:36+00:00 | Bike | -DSPH--AGL----- | 1.0 | 32.0825 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223227 | 2223227 | 2018-02-25 09:05:23+00:00 | Bike | -DSPH--AGL----- | 1.0 | 16.17 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223229 | 2223229 | 2018-02-26 12:48:53+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.3844 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223236 | 2223236 | 2018-03-13 08:03:20+00:00 | Bike | -DSPH--AGL----- | 1.0 | 35.4246 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223242 | 2223242 | 2018-03-21 07:50:14+00:00 | Bike | -DSPH--AGL----- | 1.0 | 32.2149 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223251 | 2223251 | 2018-04-05 17:55:15+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.1344 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223282 | 2223282 | 2018-05-18 16:25:40+00:00 | Bike | -DSPH--AGL----- | 1.0 | 25.043 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223298 | 2223298 | 2018-06-18 10:24:35+00:00 | Bike | -DSPH--AGL----- | 1.0 | 18.3987 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223315 | 2223315 | 2018-07-16 14:33:39+00:00 | Bike | -DSPH--AGL----- | 1.0 | 23.62625 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223320 | 2223320 | 2018-08-03 05:32:26+00:00 | Bike | -DSPH--AGL----- | 1.0 | 12.4111 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223324 | 2223324 | 2018-08-05 06:43:11+00:00 | Bike | -DSPH--AGL----- | 1.0 | 1.35619 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223325 | 2223325 | 2018-08-05 07:04:35+00:00 | Bike | -DSPH--AGL----- | 1.0 | 17.4842 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223326 | 2223326 | 2018-08-05 08:00:28+00:00 | Bike | -DSPH--AGL----- | 1.0 | 4.20874 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223360 | 2223360 | 2019-01-24 13:15:34+00:00 | Bike | -DSPH--AGL----- | 1.0 | 3.05676 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2223392 | 2223392 | 2019-02-18 08:45:45+00:00 | Bike | -DSPH--AGL----- | 1.0 | 36.1882 | {69399d98-7ec9-4b58-b5b8-4bb33cb4d061} |
| 2486691 | 2486691 | 2018-05-27 06:03:51+00:00 | Bike | -DSPH--AGL----- | 1.0 | 16.5028 | {70a04cc3-c23e-4247-bf51-15f62957126e} |
| 2486708 | 2486708 | 2018-06-25 19:11:42+00:00 | Bike | -DSPH--AGL----- | 1.0 | 10981.6 | {70a04cc3-c23e-4247-bf51-15f62957126e} |
| 187375 | 187375 | 2020-03-15 15:29:23+00:00 | Bike | -DSPHC-A-L----- | 1.0 | 21.15821 | {468751ef-dce1-4504-845b-623097ec4d2f} |
| 1787469 | 1787469 | 2018-02-25 14:17:07+00:00 | Bike | -DSPHC-A-L----- | 1.0 | 15.2661 | {fc56b27b-0f6a-48be-91c3-0873527cb41f} |
| 2060727 | 2060727 | 2017-04-23 06:33:45+00:00 | Bike | -DSPHC-AGL-EV-- | 1.0 | 66.49057 | {ad527349-56f4-46fa-89d0-61c52f273af1} |
| 2567339 | 2567339 | 2018-10-08 09:00:00+00:00 | -DSPHC-AGLWE--- | 28.7473 | {062c0153-5e5b-4c62-ba7a-a1f5cdbdf876} | ||
| 48445 | 48445 | 2020-01-29 16:38:10+00:00 | Bike | T--P----------- | 4611.0 | {935f45ad-b92d-49ed-94c5-71588b5283ed} | |
| 48447 | 48447 | 2020-01-31 21:12:24+00:00 | Bike | T--P----------- | 1358.0 | {935f45ad-b92d-49ed-94c5-71588b5283ed} | |
| 92695 | 92695 | 2007-10-12 07:00:00+00:00 | Bike | T--P----------- | 3960.0 | {3a063e0d-8e76-4f6f-9bed-1b6826e42cb9} | |
| 120590 | 120590 | 2019-08-12 15:52:57+00:00 | Bike | T--P----------- | 638.0 | {7110b953-54f5-42f6-a33b-9cbdaf54fbcc} | |
| 125868 | 125868 | 2010-01-06 06:00:00+00:00 | Bike | T--P----------- | 4020.0 | {c42f666c-d1da-4f7e-a491-368f8d6c4ebd} | |
| 262777 | 262777 | 2019-12-10 10:14:34+00:00 | Bike | T--P----------- | 8240.0 | {59dee65f-5424-429f-b2d2-015fa66ebef4} | |
| 319953 | 319953 | 2010-12-04 18:00:00+00:00 | Mountain Bike | T--P----------- | 3600.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 320049 | 320049 | 2011-04-17 14:00:00+00:00 | Other | T--P----------- | 120.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 320098 | 320098 | 2011-06-17 15:00:00+00:00 | Bike | T--P----------- | 2700.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 320125 | 320125 | 2011-07-27 06:00:00+00:00 | Bike | T--P----------- | 7200.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 320168 | 320168 | 2011-10-01 15:30:00+00:00 | Mountain Bike | T--P----------- | 1800.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 320682 | 320682 | 2013-07-30 00:00:00+00:00 | Bike | T--P----------- | 5400.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 320741 | 320741 | 2013-10-23 23:00:00+00:00 | Bike | T--P----------- | 1980.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 320843 | 320843 | 2014-03-18 23:00:00+00:00 | Bike | T--P----------- | 5100.0 | {bbdff954-f5dd-483a-a283-0a0fa1ba5aa0} | |
| 490668 | 490668 | 2019-03-05 13:34:39+00:00 | Bike | T--P----------- | 4303.0 | {0dde6d45-ed7f-4a9a-a3d8-5cd73e44087f} | |
| 490671 | 490671 | 2019-03-11 17:53:55+00:00 | Bike | T--P----------- | 2721.0 | {0dde6d45-ed7f-4a9a-a3d8-5cd73e44087f} | |
| 490679 | 490679 | 2019-04-09 11:31:24+00:00 | Bike | T--P----------- | 3281.0 | {0dde6d45-ed7f-4a9a-a3d8-5cd73e44087f} | |
| 490703 | 490703 | 2019-05-27 17:03:40+00:00 | Bike | T--P----------- | 1853.0 | {0dde6d45-ed7f-4a9a-a3d8-5cd73e44087f} | |
| 498028 | 498028 | 2019-08-12 15:52:57+00:00 | Bike | T--P----------- | 638.0 | {4e236cd8-5367-4698-8af7-e6bbc4c5ce4b} | |
| 641164 | 641164 | 2018-01-30 18:23:18+00:00 | Bike | T--P----------- | 1621.0 | {57f79228-995e-460e-a5dd-cb0f0565df88} | |
| 667020 | 667020 | 2012-11-18 05:00:00+00:00 | Bike | T--P----------- | 10800.0 | {3a2073f0-c882-46b5-a907-f28b67246e78} | |
| 684435 | 684435 | 2019-09-18 11:47:42+00:00 | VirtualRide | T--P----------- | 46.0 | {5d85e4f5-d00c-4342-b331-ba97d8e4507f} | |
| 688490 | 688490 | 2019-05-19 20:56:49+00:00 | Bike | T--P----------- | 1535.0 | {1d554be1-da5b-4f10-9cee-ab6c824eb423} | |
| 688491 | 688491 | 2019-05-21 05:57:32+00:00 | Bike | T--P----------- | 1663.0 | {1d554be1-da5b-4f10-9cee-ab6c824eb423} | |
| 700112 | 700112 | 2018-04-16 16:29:59+00:00 | Bike | T--P----------- | 7022.0 | {9d911359-9867-4cd8-bd82-cef9a5a5ee16} | |
| 768892 | 768892 | 2015-01-31 10:22:00+00:00 | T--P----------- | 4723.0 | {87cddbe7-7d8b-4ff9-a0f6-21edc8c5c063} |
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");