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)
These facets timed out: date
Link | rowid ▼ | date | sport | data | workout_time | total_distance | athlete |
---|---|---|---|---|---|---|---|
194 | 194 | 2020-04-14 21:14:52+00:00 | Bike | TDSPHC--------- | 3601.0 | 21.92338 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
195 | 195 | 2020-04-15 21:01:07+00:00 | Bike | TDSPHC--------- | 3601.0 | 20.86033 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
198 | 198 | 2020-04-22 20:27:00+00:00 | Bike | TDSPHC-AGL-EV-- | 4426.0 | 30.6013 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
199 | 199 | 2020-04-25 13:34:33+00:00 | Bike | TDSPHC-AGL-E--- | 12265.0 | 90.58273 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
200 | 200 | 2020-04-26 14:48:10+00:00 | Bike | TDSPHC-AGL-E--- | 4987.0 | 34.12898 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
201 | 201 | 2020-04-28 20:59:51+00:00 | Bike | TDSPHC-AGL-EV-- | 4485.0 | 27.04347 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
202 | 202 | 2020-04-29 20:43:00+00:00 | Bike | TDSPHC-AGL-E--- | 4082.0 | 28.255 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
203 | 203 | 2020-04-30 21:02:40+00:00 | Bike | TDSPHC-AGL-EV-- | 3721.0 | 25.23757 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
204 | 204 | 2020-05-02 14:03:12+00:00 | Bike | TDSPHC-AGL-EV-- | 10287.0 | 82.68389 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
205 | 205 | 2020-05-03 14:11:19+00:00 | Bike | TDSPHC-AGL-EV-- | 8911.0 | 65.91125 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
206 | 206 | 2020-05-05 20:58:13+00:00 | Bike | TDSPHC-AGL-EV-- | 5867.0 | 30.52833 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
207 | 207 | 2020-05-06 20:36:34+00:00 | Bike | TDSPHC-AGL-E--- | 3828.0 | 26.13592 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
208 | 208 | 2020-05-09 13:17:12+00:00 | Bike | TDSP-C-AGL----- | 5408.0 | 36.21909 | {862ffe90-6760-472e-969a-5b3cd11c2798} |
319 | 319 | 2017-07-17 22:13:22+00:00 | Bike | TDSP-C-AGL-E--- | 534.0 | 4.09016 | {96836b71-7497-4393-b0ef-810ee3041daa} |
320 | 320 | 2017-07-18 00:20:20+00:00 | Bike | TDSPHC-AGL-E--- | 3668.0 | 31.0941 | {96836b71-7497-4393-b0ef-810ee3041daa} |
321 | 321 | 2017-07-22 00:52:03+00:00 | Bike | TDSPHC-AGL-E--- | 2049.0 | 17.21171 | {96836b71-7497-4393-b0ef-810ee3041daa} |
322 | 322 | 2017-07-22 11:33:18+00:00 | Bike | TDSPHC-AGL-E--- | 14324.0 | 88.29575 | {96836b71-7497-4393-b0ef-810ee3041daa} |
323 | 323 | 2017-08-01 22:25:12+00:00 | Bike | TDSPHC-AGL-E--- | 4014.0 | 31.00498 | {96836b71-7497-4393-b0ef-810ee3041daa} |
324 | 324 | 2017-08-18 12:52:25+00:00 | Bike | TDSPHC-AGL-E--- | 3429.0 | 24.4407 | {96836b71-7497-4393-b0ef-810ee3041daa} |
325 | 325 | 2017-08-19 11:29:21+00:00 | Bike | TDSPHC-AGL-E--- | 12036.0 | 74.01646 | {96836b71-7497-4393-b0ef-810ee3041daa} |
326 | 326 | 2017-08-27 18:54:47+00:00 | Bike | TDSP-C-AGL-E--- | 1944.0 | 13.55716 | {96836b71-7497-4393-b0ef-810ee3041daa} |
327 | 327 | 2017-08-28 19:51:40+00:00 | Bike | TDSPHC-AGL-E--- | 6429.0 | 37.20679 | {96836b71-7497-4393-b0ef-810ee3041daa} |
328 | 328 | 2017-08-30 21:32:55+00:00 | Bike | TDSPHC-AGL-E--- | 11697.0 | 41.32341 | {96836b71-7497-4393-b0ef-810ee3041daa} |
329 | 329 | 2017-08-31 21:29:36+00:00 | Bike | TDSP-C-AGL-E--- | 13201.0 | 37.88767 | {96836b71-7497-4393-b0ef-810ee3041daa} |
330 | 330 | 2017-09-01 20:36:44+00:00 | Bike | TDSPHC-AGL-E--- | 4691.0 | 26.82651 | {96836b71-7497-4393-b0ef-810ee3041daa} |
331 | 331 | 2017-09-01 22:31:27+00:00 | Bike | TDSPHC-AGL-E--- | 5547.0 | 27.0869 | {96836b71-7497-4393-b0ef-810ee3041daa} |
332 | 332 | 2017-09-03 19:14:22+00:00 | Bike | TDSPHC-AGL-E--- | 4257.0 | 30.27633 | {96836b71-7497-4393-b0ef-810ee3041daa} |
333 | 333 | 2017-09-04 11:54:28+00:00 | Bike | TDSPHC-AGL-E--- | 11823.0 | 80.6936 | {96836b71-7497-4393-b0ef-810ee3041daa} |
334 | 334 | 2017-09-06 18:15:31+00:00 | Bike | TDSPHC-AGL-E--- | 1513.0 | 13.07619 | {96836b71-7497-4393-b0ef-810ee3041daa} |
335 | 335 | 2017-09-08 21:05:28+00:00 | Bike | TDSPHC-AGL-E--- | 3243.0 | 19.86376 | {96836b71-7497-4393-b0ef-810ee3041daa} |
336 | 336 | 2017-09-08 22:25:30+00:00 | Bike | TDSPHC-AGL-E--- | 6358.0 | 30.96654 | {96836b71-7497-4393-b0ef-810ee3041daa} |
337 | 337 | 2017-09-09 12:13:13+00:00 | Bike | TDSPHC-AGL-E--- | 19839.0 | 86.9855 | {96836b71-7497-4393-b0ef-810ee3041daa} |
338 | 338 | 2017-09-10 22:04:16+00:00 | Bike | TDSPHC-AGL-E--- | 8525.0 | 56.29619 | {96836b71-7497-4393-b0ef-810ee3041daa} |
339 | 339 | 2017-09-12 21:15:06+00:00 | Bike | TDSPHC-AGL-E--- | 3874.0 | 25.19631 | {96836b71-7497-4393-b0ef-810ee3041daa} |
340 | 340 | 2017-09-13 20:20:00+00:00 | Bike | TDSPHC-AGL-E--- | 7711.0 | 48.81881 | {96836b71-7497-4393-b0ef-810ee3041daa} |
341 | 341 | 2017-09-14 12:24:25+00:00 | Bike | TDSPHC-AGL-E--- | 8924.0 | 62.12092 | {96836b71-7497-4393-b0ef-810ee3041daa} |
342 | 342 | 2017-09-15 18:09:16+00:00 | Bike | TDSPHC-AGL-E--- | 6019.0 | 36.90414 | {96836b71-7497-4393-b0ef-810ee3041daa} |
343 | 343 | 2017-09-15 22:10:20+00:00 | Bike | TDSPHC-AGL-E--- | 6302.0 | 27.59755 | {96836b71-7497-4393-b0ef-810ee3041daa} |
344 | 344 | 2017-09-16 12:36:58+00:00 | Bike | TDSPHC-AGL-E--- | 18502.0 | 89.0871 | {96836b71-7497-4393-b0ef-810ee3041daa} |
345 | 345 | 2017-09-17 13:06:57+00:00 | Bike | TDSPHC-AGL-E--- | 9738.0 | 57.22736 | {96836b71-7497-4393-b0ef-810ee3041daa} |
346 | 346 | 2017-09-19 22:14:40+00:00 | Bike | TDSPHC-AGL-E--- | 10828.0 | 61.56088 | {96836b71-7497-4393-b0ef-810ee3041daa} |
347 | 347 | 2017-09-21 21:52:05+00:00 | Bike | TDSPHC-AGL-E--- | 6124.0 | 39.10301 | {96836b71-7497-4393-b0ef-810ee3041daa} |
348 | 348 | 2017-09-22 20:09:58+00:00 | Bike | TDSPHC-AGL-E--- | 6998.0 | 49.7972 | {96836b71-7497-4393-b0ef-810ee3041daa} |
349 | 349 | 2017-09-22 22:29:38+00:00 | Bike | TDSPHC-AGL-E--- | 6429.0 | 31.72333 | {96836b71-7497-4393-b0ef-810ee3041daa} |
350 | 350 | 2017-09-23 19:34:03+00:00 | Bike | TDSPHC-AGL-E--- | 12534.0 | 76.5956 | {96836b71-7497-4393-b0ef-810ee3041daa} |
351 | 351 | 2017-09-27 20:22:42+00:00 | Bike | TDSPHC-AGL-E--- | 8647.0 | 58.71574 | {96836b71-7497-4393-b0ef-810ee3041daa} |
352 | 352 | 2017-09-28 12:03:01+00:00 | Bike | TDSPHC-AGL-E--- | 3483.0 | 12.96848 | {96836b71-7497-4393-b0ef-810ee3041daa} |
353 | 353 | 2017-09-29 20:32:50+00:00 | Bike | TDSPHC-AGL-E--- | 2109.0 | 19.9852 | {96836b71-7497-4393-b0ef-810ee3041daa} |
354 | 354 | 2017-10-01 18:37:45+00:00 | Bike | TDSP-C-AGL----- | 3191.0 | 15.87556 | {96836b71-7497-4393-b0ef-810ee3041daa} |
355 | 355 | 2017-10-03 00:36:45+00:00 | Bike | TDSP-C-AGL----- | 4773.0 | 26.82461 | {96836b71-7497-4393-b0ef-810ee3041daa} |
356 | 356 | 2017-10-04 22:18:57+00:00 | Bike | TDSPHC-AGL-E--- | 5161.0 | 24.78389 | {96836b71-7497-4393-b0ef-810ee3041daa} |
357 | 357 | 2017-10-07 22:15:46+00:00 | Bike | TDSPHC-AGL-E--- | 5100.0 | 33.87105 | {96836b71-7497-4393-b0ef-810ee3041daa} |
358 | 358 | 2017-10-11 22:22:44+00:00 | Bike | TDSPHC-AGL-E--- | 6860.0 | 39.65757 | {96836b71-7497-4393-b0ef-810ee3041daa} |
359 | 359 | 2017-10-12 22:29:43+00:00 | Bike | TDSPHC-AGL-E--- | 6614.0 | 44.05074 | {96836b71-7497-4393-b0ef-810ee3041daa} |
360 | 360 | 2017-10-13 22:19:02+00:00 | Bike | TDSPHC-AGL-E--- | 4046.0 | 26.78708 | {96836b71-7497-4393-b0ef-810ee3041daa} |
361 | 361 | 2017-10-14 12:22:11+00:00 | Bike | TDSPHC-AGL-E--- | 17801.0 | 98.64461 | {96836b71-7497-4393-b0ef-810ee3041daa} |
362 | 362 | 2017-10-18 15:52:53+00:00 | Bike | TDSPHC-AGL-E--- | 12574.0 | 80.83406 | {96836b71-7497-4393-b0ef-810ee3041daa} |
363 | 363 | 2017-10-18 19:24:28+00:00 | Bike | TDSPHC-AGL-E--- | 4554.0 | 16.97053 | {96836b71-7497-4393-b0ef-810ee3041daa} |
364 | 364 | 2017-10-20 21:34:09+00:00 | Bike | TDSPHC-AGL-E--- | 3403.0 | 20.23282 | {96836b71-7497-4393-b0ef-810ee3041daa} |
365 | 365 | 2017-10-21 12:34:26+00:00 | Bike | TDSPHC-AGL-E--- | 18973.0 | 102.44139 | {96836b71-7497-4393-b0ef-810ee3041daa} |
366 | 366 | 2017-10-22 14:50:53+00:00 | Bike | TDSPHC-AGL-E--- | 9378.0 | 46.41634 | {96836b71-7497-4393-b0ef-810ee3041daa} |
367 | 367 | 2017-10-25 21:15:28+00:00 | Bike | TDSPHC-AGL-E--- | 9600.0 | 60.31268 | {96836b71-7497-4393-b0ef-810ee3041daa} |
368 | 368 | 2017-10-27 20:21:37+00:00 | Bike | TD-PHC-AGL-E--- | 1939.0 | 0.0306 | {96836b71-7497-4393-b0ef-810ee3041daa} |
369 | 369 | 2017-10-27 21:30:00+00:00 | Bike | TDSPHC-AGL-E--- | 5525.0 | 31.47507 | {96836b71-7497-4393-b0ef-810ee3041daa} |
370 | 370 | 2017-10-28 12:42:05+00:00 | Bike | TDSPHC-AGL-E--- | 22385.0 | 124.30694 | {96836b71-7497-4393-b0ef-810ee3041daa} |
371 | 371 | 2017-11-02 22:30:02+00:00 | Bike | TDSPHC-AGL-E--- | 6107.0 | 39.81462 | {96836b71-7497-4393-b0ef-810ee3041daa} |
372 | 372 | 2017-11-03 21:13:41+00:00 | Bike | TDSPHC-AGL-E--- | 6232.0 | 32.67123 | {96836b71-7497-4393-b0ef-810ee3041daa} |
373 | 373 | 2017-11-05 14:33:15+00:00 | Bike | TDSPHC-AGL-E--- | 11662.0 | 57.68642 | {96836b71-7497-4393-b0ef-810ee3041daa} |
375 | 375 | 2017-11-10 20:26:25+00:00 | Bike | TDSPHC-AGL-E--- | 6357.0 | 45.42376 | {96836b71-7497-4393-b0ef-810ee3041daa} |
376 | 376 | 2017-11-10 22:35:23+00:00 | Bike | TDSPHC-AGL-E--- | 4078.0 | 24.71413 | {96836b71-7497-4393-b0ef-810ee3041daa} |
377 | 377 | 2017-11-11 13:49:56+00:00 | Bike | TDSPHC-AGL-E--- | 35366.0 | 175.13286 | {96836b71-7497-4393-b0ef-810ee3041daa} |
378 | 378 | 2017-11-13 20:02:05+00:00 | Bike | TDSPHC-AGL-E--- | 5854.0 | 37.77379 | {96836b71-7497-4393-b0ef-810ee3041daa} |
379 | 379 | 2017-11-14 20:27:58+00:00 | Bike | TDSPHC-AGL-E--- | 7543.0 | 42.04212 | {96836b71-7497-4393-b0ef-810ee3041daa} |
380 | 380 | 2017-11-17 22:34:12+00:00 | Bike | TDSPHC-AGL-E--- | 4824.0 | 25.7309 | {96836b71-7497-4393-b0ef-810ee3041daa} |
381 | 381 | 2017-11-22 18:31:51+00:00 | Bike | TDSPHC-AGL-E--- | 9430.0 | 71.01595 | {96836b71-7497-4393-b0ef-810ee3041daa} |
382 | 382 | 2017-11-23 21:54:47+00:00 | Bike | TDSPHC-AGL-E--- | 2403.0 | 17.69902 | {96836b71-7497-4393-b0ef-810ee3041daa} |
383 | 383 | 2017-11-24 18:04:20+00:00 | Bike | TDSPHC-AGL-E--- | 6587.0 | 41.5857 | {96836b71-7497-4393-b0ef-810ee3041daa} |
384 | 384 | 2017-11-25 21:58:35+00:00 | Bike | TDSPHC-AGL-E--- | 3679.0 | 29.01854 | {96836b71-7497-4393-b0ef-810ee3041daa} |
385 | 385 | 2017-11-27 21:51:12+00:00 | Bike | TDSPHC-AGL-E--- | 6471.0 | 45.21933 | {96836b71-7497-4393-b0ef-810ee3041daa} |
386 | 386 | 2017-11-28 22:24:46+00:00 | Bike | TDSPHC-AGL-E--- | 4591.0 | 31.1149 | {96836b71-7497-4393-b0ef-810ee3041daa} |
387 | 387 | 2017-11-30 00:24:34+00:00 | Bike | TDSP-C-AGL-E--- | 3227.0 | 19.53738 | {96836b71-7497-4393-b0ef-810ee3041daa} |
388 | 388 | 2017-11-30 14:13:00+00:00 | Bike | TDSPHC-AGL-E--- | 7212.0 | 46.96369 | {96836b71-7497-4393-b0ef-810ee3041daa} |
389 | 389 | 2017-12-01 13:31:45+00:00 | Bike | TDSPHC-AGL-E--- | 10603.0 | 80.01314 | {96836b71-7497-4393-b0ef-810ee3041daa} |
390 | 390 | 2017-12-01 22:32:10+00:00 | Bike | TDSPHC-AGL-E--- | 4379.0 | 25.21053 | {96836b71-7497-4393-b0ef-810ee3041daa} |
391 | 391 | 2017-12-02 14:07:13+00:00 | Bike | TDSPHC-AGL-E--- | 18795.0 | 100.48146 | {96836b71-7497-4393-b0ef-810ee3041daa} |
392 | 392 | 2017-12-04 14:16:21+00:00 | Bike | TDSPHC-AGL-E--- | 8580.0 | 56.4412 | {96836b71-7497-4393-b0ef-810ee3041daa} |
393 | 393 | 2017-12-07 00:23:57+00:00 | Bike | TDSP-C-AGL----- | 5130.0 | 35.08635 | {96836b71-7497-4393-b0ef-810ee3041daa} |
394 | 394 | 2017-12-12 21:57:54+00:00 | Bike | TDSPHC-AGL-E--- | 6071.0 | 41.0606 | {96836b71-7497-4393-b0ef-810ee3041daa} |
395 | 395 | 2017-12-14 00:01:58+00:00 | Bike | TDSP-C-AGL----- | 4137.0 | 24.39981 | {96836b71-7497-4393-b0ef-810ee3041daa} |
396 | 396 | 2017-12-14 22:26:38+00:00 | Bike | TDSPHC-AGL-E--- | 3762.0 | 26.43329 | {96836b71-7497-4393-b0ef-810ee3041daa} |
397 | 397 | 2017-12-15 22:32:10+00:00 | Bike | TDSP-C-AGL-E--- | 3956.0 | 23.99412 | {96836b71-7497-4393-b0ef-810ee3041daa} |
398 | 398 | 2017-12-20 21:40:55+00:00 | Bike | TDSPHC-AGL-E--- | 3613.0 | 31.44325 | {96836b71-7497-4393-b0ef-810ee3041daa} |
399 | 399 | 2017-12-23 13:21:24+00:00 | Bike | TDSPHC-AGL-E--- | 6370.0 | 48.71321 | {96836b71-7497-4393-b0ef-810ee3041daa} |
400 | 400 | 2017-12-24 20:40:35+00:00 | Bike | TDSPHC-AGL-E--- | 9131.0 | 67.31335 | {96836b71-7497-4393-b0ef-810ee3041daa} |
401 | 401 | 2018-01-03 02:43:55+00:00 | Bike | TDSP-C-AGL----- | 4948.0 | 38.8034 | {96836b71-7497-4393-b0ef-810ee3041daa} |
402 | 402 | 2018-01-03 22:36:08+00:00 | TDSP-C-AGL-E--- | 5140.0 | 42.50397 | {96836b71-7497-4393-b0ef-810ee3041daa} | |
403 | 403 | 2018-01-04 22:16:41+00:00 | Bike | TDSP-C-AGL-E--- | 4359.0 | 22.7792 | {96836b71-7497-4393-b0ef-810ee3041daa} |
404 | 404 | 2018-01-05 20:38:03+00:00 | Bike | TDSP-C-AGL-E--- | 4120.0 | 32.02049 | {96836b71-7497-4393-b0ef-810ee3041daa} |
405 | 405 | 2018-01-07 20:09:49+00:00 | Bike | TDSPHC-AGL-E--- | 6677.0 | 50.14301 | {96836b71-7497-4393-b0ef-810ee3041daa} |
406 | 406 | 2018-01-08 15:45:17+00:00 | Bike | TDSPHC-AGL-E--- | 15056.0 | 84.21008 | {96836b71-7497-4393-b0ef-810ee3041daa} |
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");