rides
Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData
2,589,036 rows
This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | sport | data | workout_time | total_distance | athlete |
---|---|---|---|---|---|---|---|
1 | 1 | 2018-07-07 11:33:58+00:00 | Bike | TDS-H--AGL-E--- | 9461.0 | 82.2777 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
2 | 2 | 2018-07-08 14:19:39+00:00 | Bike | TDS-H--AGL-E--- | 6674.0 | 39.6764 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
3 | 3 | 2018-07-10 22:30:43+00:00 | Bike | TDS-H--AGL-E--- | 7228.0 | 60.56882 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
4 | 4 | 2018-07-12 21:38:29+00:00 | Bike | TDS-H--AGL-E--- | 5024.0 | 16.90347 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
5 | 5 | 2018-07-14 12:04:18+00:00 | Bike | TDS-H--AGL-E--- | 9781.0 | 79.10735 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
6 | 6 | 2018-07-15 14:18:59+00:00 | Bike | TDS-H--AGL-E--- | 5181.0 | 43.6815 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
7 | 7 | 2018-07-17 22:30:04+00:00 | Bike | TDS-H--AGL-E--- | 6427.0 | 54.68898 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
8 | 8 | 2018-07-19 21:01:53+00:00 | Bike | TDS-H--AGL-E--- | 4398.0 | 37.72233 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
9 | 9 | 2018-07-21 13:14:05+00:00 | Bike | TDS-H--AGL-E--- | 8386.0 | 70.5535 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
10 | 10 | 2018-07-28 13:10:51+00:00 | Bike | TDS-H--AGL-E--- | 5783.0 | 51.32727 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
11 | 11 | 2018-07-29 13:44:12+00:00 | Bike | TDS----AGL-E--- | 9532.0 | 77.36283 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
12 | 12 | 2018-07-31 14:01:53+00:00 | Bike | TDS-H--AGL-E--- | 9340.0 | 77.326 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
13 | 13 | 2018-08-02 13:36:22+00:00 | Bike | TDS-H--AGL-E--- | 8113.0 | 66.70456 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
14 | 14 | 2018-08-03 13:19:36+00:00 | Bike | TDS-H--AGL-E--- | 5342.0 | 43.9868 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
15 | 15 | 2018-08-05 13:49:57+00:00 | Bike | TDS-H--AGL-E--- | 7531.0 | 58.76861 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
16 | 16 | 2018-08-08 22:03:57+00:00 | Bike | TDS-H--AGL-E--- | 3670.0 | 22.81351 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
17 | 17 | 2018-08-11 13:41:02+00:00 | Bike | TDS-H--AGL-E--- | 7540.0 | 59.45814 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
18 | 18 | 2018-08-12 12:42:33+00:00 | Bike | TDS-H--AGL-E--- | 7268.0 | 58.05615 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
19 | 19 | 2018-08-14 20:57:30+00:00 | Bike | TDS-H--AGL-E--- | 8210.0 | 66.54857 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
20 | 20 | 2018-08-16 21:42:56+00:00 | Bike | TDS-H--AGL-E--- | 4078.0 | 26.22698 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
21 | 21 | 2018-08-18 13:55:24+00:00 | Bike | TDS----AGL-E--- | 10191.0 | 78.684 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
22 | 22 | 2018-08-19 14:12:16+00:00 | Bike | TDS----AGL-E--- | 6796.0 | 48.64709 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
23 | 23 | 2018-08-21 21:57:30+00:00 | Bike | TDS-H--AGL-E--- | 4771.0 | 27.25624 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
24 | 24 | 2018-08-23 21:32:18+00:00 | Bike | TDS-H--AGL-E--- | 6741.0 | 55.77193 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
25 | 25 | 2018-08-25 12:59:44+00:00 | Bike | TDS-H--AGL-E--- | 10919.0 | 91.59971 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
26 | 26 | 2018-08-26 13:53:54+00:00 | Bike | TDS-H--AGL-E--- | 8671.0 | 51.54341 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
27 | 27 | 2018-08-28 20:39:39+00:00 | Bike | TDS-H--AGL-E--- | 3317.0 | 21.26509 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
28 | 28 | 2018-09-01 12:44:44+00:00 | Bike | TDS-H--AGL-E--- | 11686.0 | 71.00108 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
29 | 29 | 2018-09-02 14:05:59+00:00 | Bike | TDS-H--AGL-E--- | 7063.0 | 57.74023 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
30 | 30 | 2018-09-06 20:44:12+00:00 | Bike | TDS-H--AGL-E--- | 6876.0 | 57.46943 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
31 | 31 | 2018-09-08 13:12:43+00:00 | Bike | TDS-H--AGL-E--- | 5493.0 | 46.45597 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
32 | 32 | 2018-09-09 12:44:38+00:00 | Bike | TDS-H--AGL-E--- | 8824.0 | 39.11958 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
33 | 33 | 2018-09-11 21:02:18+00:00 | Bike | TDS-H--AGL-E--- | 6859.0 | 56.56734 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
34 | 34 | 2018-09-13 22:08:46+00:00 | Bike | TDS-H--AGL-E--- | 4084.0 | 19.51168 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
35 | 35 | 2018-09-15 13:25:04+00:00 | Bike | TDS-H--AGL-E--- | 6558.0 | 53.11692 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
36 | 36 | 2018-09-16 13:08:29+00:00 | Bike | TDS-H--AGL-E--- | 9913.0 | 81.05589 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
37 | 37 | 2018-09-18 21:32:52+00:00 | Bike | TDS-H--AGL-E--- | 6143.0 | 38.32656 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
38 | 38 | 2018-09-22 12:39:34+00:00 | Bike | TDS-H--AGL-E--- | 6982.0 | 58.34663 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
39 | 39 | 2018-09-23 12:45:05+00:00 | Bike | TDS-H--AGL-E--- | 9163.0 | 48.26446 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
40 | 40 | 2018-09-25 21:02:28+00:00 | Bike | TDS-H--AGL-E--- | 3886.0 | 28.4059 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
41 | 41 | 2018-09-29 13:33:40+00:00 | Bike | TDS-H--AGL-E--- | 10204.0 | 75.6633 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
42 | 42 | 2018-09-30 13:30:53+00:00 | Bike | TDS----AGL-E--- | 3858.0 | 25.61622 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
43 | 43 | 2018-10-07 12:37:58+00:00 | Bike | TDS----AGL-E--- | 7889.0 | 36.31397 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
44 | 44 | 2018-10-08 13:43:59+00:00 | Bike | TDS----AGL-E--- | 8185.0 | 45.95568 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
45 | 45 | 2018-10-10 20:43:02+00:00 | Bike | TDS----AGL-E--- | 6995.0 | 41.1246 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
46 | 46 | 2018-10-14 13:13:09+00:00 | Bike | TDS----AGL-E--- | 6931.0 | 31.6827 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
47 | 47 | 2018-10-15 21:40:59+00:00 | Bike | TDS----AGL-E--- | 6837.0 | 34.6308 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
48 | 48 | 2018-10-18 23:02:50+00:00 | Bike | TDS----AGL-E--- | 5919.0 | 28.78155 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
49 | 49 | 2018-10-20 13:34:52+00:00 | Bike | TDS----AGL-E--- | 7238.0 | 46.41149 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
50 | 50 | 2018-10-21 12:47:46+00:00 | Bike | TDS----AGL-E--- | 9836.0 | 44.39642 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
51 | 51 | 2018-10-22 21:54:34+00:00 | Bike | TDS----AGL-E--- | 6171.0 | 40.0424 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
52 | 52 | 2018-10-29 21:41:51+00:00 | Bike | TDS----AGL-E--- | 5325.0 | 21.9971 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
53 | 53 | 2018-11-03 14:40:34+00:00 | Bike | TDS----AGL-E--- | 5718.0 | 44.21793 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
54 | 54 | 2018-11-04 14:10:50+00:00 | Bike | TDS----AGL-E--- | 8693.0 | 63.15389 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
55 | 55 | 2018-11-05 22:49:55+00:00 | Bike | TDS----AGL-E--- | 8683.0 | 42.2118 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
56 | 56 | 2018-11-11 14:04:06+00:00 | Bike | TDS----AGL-E--- | 9872.0 | 35.82186 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
57 | 57 | 2018-11-12 22:44:21+00:00 | Bike | TDS----AGL-E--- | 6697.0 | 43.3922 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
58 | 58 | 2018-11-17 14:11:37+00:00 | Bike | TDS----AGL-E--- | 1974.0 | 7.34998 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
59 | 59 | 2018-11-22 23:27:30+00:00 | Bike | TDS----AGL-E--- | 6305.0 | 17.66357 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
60 | 60 | 2018-11-25 14:58:53+00:00 | Bike | TDS----AGL-E--- | 5689.0 | 22.79068 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
61 | 61 | 2018-12-01 14:42:50+00:00 | Bike | TDS----AGL-E--- | 7517.0 | 44.80934 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
62 | 62 | 2018-12-03 22:45:20+00:00 | Bike | TDS----AGL-E--- | 10105.0 | 43.23107 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
63 | 63 | 2018-12-08 14:09:06+00:00 | Bike | TDS----AGL-E--- | 6989.0 | 18.4453 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
64 | 64 | 2018-12-09 13:45:39+00:00 | Bike | TDS----AGL-E--- | 8945.0 | 42.48479 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
65 | 65 | 2018-12-10 22:55:43+00:00 | Bike | TDS----AGL-E--- | 7701.0 | 20.76378 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
66 | 66 | 2018-12-15 15:22:15+00:00 | Bike | TDS----AGL-E--- | 5632.0 | 16.5011 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
67 | 67 | 2018-12-16 14:05:11+00:00 | Bike | TDS-H--AGL-E--- | 10266.0 | 24.34646 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
68 | 68 | 2018-12-23 14:41:41+00:00 | Bike | TDS-H--AGL-E--- | 7141.0 | 32.79855 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
69 | 69 | 2018-12-26 15:03:49+00:00 | Bike | TDS-H--AGL-E--- | 7367.0 | 32.66147 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
70 | 70 | 2018-12-27 16:03:12+00:00 | Bike | TDS-H--AGL-E--- | 6000.0 | 26.88388 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
71 | 71 | 2018-12-30 14:07:52+00:00 | Bike | TDS-H--AGL-E--- | 8127.0 | 24.83275 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
72 | 72 | 2019-01-06 14:16:17+00:00 | Bike | TDS-H--AGL-E--- | 6213.0 | 18.4468 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
73 | 73 | 2019-01-12 14:01:12+00:00 | Bike | TDS-H--AGL-E--- | 3703.0 | 19.1207 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
74 | 74 | 2019-01-20 14:21:36+00:00 | Bike | TDS----AGL-E--- | 9125.0 | 18.17449 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
75 | 75 | 2019-01-26 19:00:51+00:00 | Bike | TDS-H--AGL-E--- | 3868.0 | 13.298 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
76 | 76 | 2019-02-02 15:19:34+00:00 | Bike | TDS-H--AGL-E--- | 8579.0 | 21.87237 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
77 | 77 | 2019-02-10 14:07:18+00:00 | Bike | TDS-H--AGL-E--- | 8037.0 | 49.96073 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
78 | 78 | 2019-02-17 14:03:32+00:00 | Bike | TDS-H--AGL-E--- | 8719.0 | 24.9473 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
79 | 79 | 2019-02-23 14:25:49+00:00 | Bike | TDS-H--AGL-E--- | 6254.0 | 22.842 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
80 | 80 | 2019-03-03 15:22:34+00:00 | Bike | TDS-H--AGL-E--- | 5800.0 | 12.8706 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
81 | 81 | 2019-03-04 23:39:27+00:00 | Bike | TDS-H--AGL-E--- | 4299.0 | 11.41563 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
82 | 82 | 2019-03-09 13:57:05+00:00 | Bike | TDS-H--AGL-E--- | 8852.0 | 27.68319 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
83 | 83 | 2019-03-17 17:14:39+00:00 | Bike | TDS-H--AGL-E--- | 7251.0 | 50.30427 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
84 | 84 | 2019-03-19 21:04:29+00:00 | Bike | TDS-H--AGL-E--- | 3435.0 | 17.64515 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
85 | 85 | 2019-03-21 20:48:20+00:00 | Bike | TDS-H--AGL-E--- | 4679.0 | 35.17268 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
86 | 86 | 2019-03-23 13:34:57+00:00 | Bike | TDS-H--AGL-E--- | 6233.0 | 45.98868 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
87 | 87 | 2019-03-24 13:02:08+00:00 | Bike | TDS-H--AGL-E--- | 6718.0 | 48.84507 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
88 | 88 | 2019-03-26 21:38:59+00:00 | Bike | TDS-H--AGL-E--- | 4577.0 | 28.91636 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
89 | 89 | 2019-03-27 20:44:08+00:00 | Bike | TDS-H--AGL-E--- | 7089.0 | 51.11704 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
90 | 90 | 2019-04-06 12:55:10+00:00 | Bike | TDS-H--AGL-E--- | 5190.0 | 40.48332 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
91 | 91 | 2019-04-07 12:30:23+00:00 | Bike | TDS-H--AGL-E--- | 9622.0 | 69.65101 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
92 | 92 | 2019-04-13 12:16:21+00:00 | Bike | TDS-H--AGL-E--- | 12892.0 | 84.90858 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
93 | 93 | 2019-05-02 21:42:10+00:00 | Bike | TDS-H--AGL-E--- | 5372.0 | 25.30364 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
94 | 94 | 2019-05-07 21:00:05+00:00 | Bike | TDS-H--AGL-E--- | 5899.0 | 49.25954 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
95 | 95 | 2019-05-08 20:51:41+00:00 | Bike | TDS-H--AGL-E--- | 4762.0 | 25.6847 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
96 | 96 | 2019-05-16 21:26:04+00:00 | Bike | TDS-H--AGL-E--- | 7677.0 | 58.50062 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
97 | 97 | 2019-05-18 13:39:56+00:00 | Bike | TDS-H--AGL-E--- | 8062.0 | 57.67858 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
98 | 98 | 2019-05-19 13:30:42+00:00 | Bike | TDS-H--AGL-E--- | 7055.0 | 54.03515 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
99 | 99 | 2019-05-21 22:52:10+00:00 | Bike | TDS-H--AGL-E--- | 3989.0 | 20.0038 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
100 | 100 | 2019-05-26 13:52:31+00:00 | Bike | TDS----AGL-E--- | 5816.0 | 45.50784 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
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");