home / james_garmin_activities

activity_records

292 rows where activity_id = 18960172990

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Link activity_id record timestamp position_lat position_long distance cadence altitude hr rr speed temperature
18960172990,0 Copenhagen Cycling 18960172990 0 2025-04-28 14:38:33.000000 55.69973409175873 12.595886383205652 0.0   2.3999999999999773 83   0.0  
18960172990,1 Copenhagen Cycling 18960172990 1 2025-04-28 14:38:36.000000 55.699752029031515 12.595874816179276 0.0   2.3999999999999773 82   4.467600000000001  
18960172990,2 Copenhagen Cycling 18960172990 2 2025-04-28 14:38:38.000000 55.69974632933736 12.595849670469761 0.00222   2.3999999999999773 82   2.4516000000000004  
18960172990,3 Copenhagen Cycling 18960172990 3 2025-04-28 14:38:43.000000 55.69971405901015 12.595691503956914 0.00423   1.8000000000000114 79   6.6168000000000005  
18960172990,4 Copenhagen Cycling 18960172990 4 2025-04-28 14:38:44.000000 55.6997009832412 12.595669208094478 0.00423   1.3999999999999773 78   8.1972  
18960172990,5 Copenhagen Cycling 18960172990 5 2025-04-28 14:38:49.000000 55.6996095366776 12.595534594729543 0.016710000000000003   1.3999999999999773 77   7.4556000000000004  
18960172990,6 Copenhagen Cycling 18960172990 6 2025-04-28 14:38:53.000000 55.69952462799847 12.595314905047417 0.03535   1.8000000000000114 79   11.8908  
18960172990,7 Copenhagen Cycling 18960172990 7 2025-04-28 14:38:58.000000 55.699390936642885 12.595182890072465 0.05196   2.0 81   13.9068  
18960172990,8 Copenhagen Cycling 18960172990 8 2025-04-28 14:39:04.000000 55.699225729331374 12.595132598653436 0.06991   2.0 80   13.3344  
18960172990,9 Copenhagen Cycling 18960172990 9 2025-04-28 14:39:09.000000 55.69905222393572 12.59509270079434 0.08904000000000001   2.3999999999999773 81   14.31  
18960172990,10 Copenhagen Cycling 18960172990 10 2025-04-28 14:39:15.000000 55.69884343072772 12.59502966888249 0.11276000000000001   2.6000000000000227 82   14.04  
18960172990,11 Copenhagen Cycling 18960172990 11 2025-04-28 14:39:18.000000 55.69872239604592 12.594984322786331 0.12574000000000002   2.6000000000000227 82   14.277600000000001  
18960172990,12 Copenhagen Cycling 18960172990 12 2025-04-28 14:39:24.000000 55.698495749384165 12.594910813495517 0.15246   2.1999999999999886 82   12.9672  
18960172990,13 Copenhagen Cycling 18960172990 13 2025-04-28 14:39:27.000000 55.69839189760387 12.594861276447773 0.16539   2.6000000000000227 83   14.1408  
18960172990,14 Copenhagen Cycling 18960172990 14 2025-04-28 14:39:33.000000 55.698206909000874 12.59477167390287 0.18728999999999998   2.3999999999999773 84   14.0076  
18960172990,15 Copenhagen Cycling 18960172990 15 2025-04-28 14:39:34.000000 55.69818243384361 12.594747953116894 0.19039000000000003   2.3999999999999773 84   13.636800000000001  
18960172990,16 Copenhagen Cycling 18960172990 16 2025-04-28 14:39:40.000000 55.698001720011234 12.594702942296863 0.20956   3.3999999999999773 85   13.7052  
18960172990,17 Copenhagen Cycling 18960172990 17 2025-04-28 14:39:41.000000 55.697967605665326 12.594692716374993 0.21316   3.3999999999999773 86   13.4712  
18960172990,18 Copenhagen Cycling 18960172990 18 2025-04-28 14:39:43.000000 55.6978945992887 12.594675701111555 0.22135   3.6000000000000227 87   13.2696  
18960172990,19 Copenhagen Cycling 18960172990 19 2025-04-28 14:39:49.000000 55.69767759181559 12.59460411965847 0.24639000000000003   4.199999999999989 87   13.7376  
18960172990,20 Copenhagen Cycling 18960172990 20 2025-04-28 14:39:53.000000 55.69754566065967 12.594548547640443 0.26099   4.600000000000023 88   13.636800000000001  
18960172990,21 Copenhagen Cycling 18960172990 21 2025-04-28 14:39:56.000000 55.69746267981827 12.594452239573002 0.27202   4.600000000000023 87   13.3704  
18960172990,22 Copenhagen Cycling 18960172990 22 2025-04-28 14:39:59.000000 55.69746728986502 12.594238668680191 0.28444   5.0 88   13.6044  
18960172990,23 Copenhagen Cycling 18960172990 23 2025-04-28 14:40:05.000000 55.69751280359924 12.593775819987059 0.31442000000000003   5.0 89   19.011599999999998  
18960172990,24 Copenhagen Cycling 18960172990 24 2025-04-28 14:40:11.000000 55.697566866874695 12.593189338222146 0.35215   4.0 89   19.9872  
18960172990,25 Copenhagen Cycling 18960172990 25 2025-04-28 14:40:15.000000 55.697541888803244 12.592903347685933 0.37036   5.600000000000023 90   10.749600000000001  
18960172990,26 Copenhagen Cycling 18960172990 26 2025-04-28 14:40:16.000000 55.69752210751176 12.592902760952711 0.37228000000000006   5.600000000000023 90   8.3628  
18960172990,27 Copenhagen Cycling 18960172990 27 2025-04-28 14:40:21.000000 55.69736930541694 12.592949364334345 0.38866   5.199999999999989 92   15.5196  
18960172990,28 Copenhagen Cycling 18960172990 28 2025-04-28 14:40:27.000000 55.69712924771011 12.59301071986556 0.41576   5.0 93   16.83  
18960172990,29 Copenhagen Cycling 18960172990 29 2025-04-28 14:40:28.000000 55.6970864161849 12.593020023778081 0.4208   5.199999999999989 94   16.491600000000002  
18960172990,30 Copenhagen Cycling 18960172990 30 2025-04-28 14:40:34.000000 55.69684166461229 12.593106776475906 0.44864   6.0 95   17.7012  
18960172990,31 Copenhagen Cycling 18960172990 31 2025-04-28 14:40:35.000000 55.696797743439674 12.593124965205789 0.45342000000000005   6.0 95   17.9712  
18960172990,32 Copenhagen Cycling 18960172990 32 2025-04-28 14:40:41.000000 55.69654159247875 12.593263182789087 0.48363   6.199999999999989 96   17.0964  
18960172990,33 Copenhagen Cycling 18960172990 33 2025-04-28 14:40:44.000000 55.696422988548875 12.59336058050394 0.49741   6.600000000000023 97   17.2332  
18960172990,34 Copenhagen Cycling 18960172990 34 2025-04-28 14:40:45.000000 55.69638258777559 12.593388492241502 0.50195   6.800000000000011 97   17.7372  
18960172990,35 Copenhagen Cycling 18960172990 35 2025-04-28 14:40:51.000000 55.69612316787243 12.59360147640109 0.53363   7.0 95   19.9512  
18960172990,36 Copenhagen Cycling 18960172990 36 2025-04-28 14:40:57.000000 55.69582569412887 12.593768024817109 0.56993   6.199999999999989 95   20.0196  
18960172990,37 Copenhagen Cycling 18960172990 37 2025-04-28 14:40:59.000000 55.6957324873656 12.593797445297241 0.58038   6.0 96   19.2816  
18960172990,38 Copenhagen Cycling 18960172990 38 2025-04-28 14:41:05.000000 55.69544691592455 12.593804318457842 0.61238   5.600000000000023 98   18.5436  
18960172990,39 Copenhagen Cycling 18960172990 39 2025-04-28 14:41:06.000000 55.69540249183774 12.593785291537642 0.6173500000000001   5.600000000000023 99   18.6444  
18960172990,40 Copenhagen Cycling 18960172990 40 2025-04-28 14:41:08.000000 55.69532537832856 12.593721421435475 0.62675   6.0 99   18.003600000000002  
18960172990,41 Copenhagen Cycling 18960172990 41 2025-04-28 14:41:11.000000 55.69520015269518 12.593623353168368 0.6418200000000001   6.0 99   18.003600000000002  
18960172990,42 Copenhagen Cycling 18960172990 42 2025-04-28 14:41:14.000000 55.69507702253759 12.593506760895252 0.65758   6.800000000000011 100   18.2052  
18960172990,43 Copenhagen Cycling 18960172990 43 2025-04-28 14:41:16.000000 55.69499580189586 12.59342797100544 0.66786   6.800000000000011 100   18.2052  
18960172990,44 Copenhagen Cycling 18960172990 44 2025-04-28 14:41:19.000000 55.694871162995696 12.593298889696598 0.68392   7.0 101   18.306  
18960172990,45 Copenhagen Cycling 18960172990 45 2025-04-28 14:41:22.000000 55.69475490599871 12.593169640749693 0.69914   7.0 103   18.2052  
18960172990,46 Copenhagen Cycling 18960172990 46 2025-04-28 14:41:26.000000 55.69460696540773 12.5929481908679 0.72084   7.600000000000023 103   18.8784  
18960172990,47 Copenhagen Cycling 18960172990 47 2025-04-28 14:41:28.000000 55.69453462958336 12.592838890850544 0.73145   7.800000000000011 101   18.5076  
18960172990,48 Copenhagen Cycling 18960172990 48 2025-04-28 14:41:34.000000 55.694326339289546 12.592539992183447 0.7615000000000001   8.0 99   16.6284  
18960172990,49 Copenhagen Cycling 18960172990 49 2025-04-28 14:41:40.000000 55.694141602143645 12.592271100729704 0.7879400000000001   9.0 100   17.064  
18960172990,50 Copenhagen Cycling 18960172990 50 2025-04-28 14:41:44.000000 55.69401243701577 12.59207203052938 0.80716   9.199999999999989 101   16.9956  
18960172990,51 Copenhagen Cycling 18960172990 51 2025-04-28 14:41:50.000000 55.69381093606353 12.591785956174135 0.83578   9.0 103   17.0964  
18960172990,52 Copenhagen Cycling 18960172990 52 2025-04-28 14:41:52.000000 55.69373935461044 12.591690067201853 0.84573   9.0 103   18.072000000000003  
18960172990,53 Copenhagen Cycling 18960172990 53 2025-04-28 14:41:53.000000 55.69370348006487 12.591639021411538 0.8509   9.0 103   18.072000000000003  
18960172990,54 Copenhagen Cycling 18960172990 54 2025-04-28 14:41:59.000000 55.69350717589259 12.591306511312723 0.88131   9.0 101   18.172800000000002  
18960172990,55 Copenhagen Cycling 18960172990 55 2025-04-28 14:42:02.000000 55.69340952672064 12.5911505240947 0.89576   9.0 101   17.636400000000002  
18960172990,56 Copenhagen Cycling 18960172990 56 2025-04-28 14:42:08.000000 55.69320567883551 12.590833520516753 0.9260900000000001   9.399999999999977 100   17.334000000000003  
18960172990,57 Copenhagen Cycling 18960172990 57 2025-04-28 14:42:11.000000 55.693113980814815 12.590681975707412 0.9400900000000001   9.399999999999977 99   16.9632  
18960172990,58 Copenhagen Cycling 18960172990 58 2025-04-28 14:42:14.000000 55.693022618070245 12.59052992798388 0.95376   9.800000000000011 96   16.4592  
18960172990,59 Copenhagen Cycling 18960172990 59 2025-04-28 14:42:16.000000 55.69295925088227 12.590422639623284 0.9640299999999999   10.199999999999989 92   16.660800000000002  
18960172990,60 Copenhagen Cycling 18960172990 60 2025-04-28 14:42:21.000000 55.69281675852835 12.590179396793246 0.98602   10.800000000000011 89   15.886800000000001  
18960172990,61 Copenhagen Cycling 18960172990 61 2025-04-28 14:42:22.000000 55.692789014428854 12.590133966878057 0.9900700000000001   10.800000000000011 89   15.886800000000001  
18960172990,62 Copenhagen Cycling 18960172990 62 2025-04-28 14:42:28.000000 55.69261643104255 12.589847221970558 1.01647   10.199999999999989 89   15.753600000000002  
18960172990,63 Copenhagen Cycling 18960172990 63 2025-04-28 14:42:33.000000 55.692465556785464 12.589609175920486 1.03892   10.600000000000023 90   16.326  
18960172990,64 Copenhagen Cycling 18960172990 64 2025-04-28 14:42:37.000000 55.6923461984843 12.589426031336188 1.0566200000000001   11.399999999999977 90   15.6528  
18960172990,65 Copenhagen Cycling 18960172990 65 2025-04-28 14:42:40.000000 55.69225776940584 12.58928395807743 1.06955   12.399999999999977 90   16.491600000000002  
18960172990,66 Copenhagen Cycling 18960172990 66 2025-04-28 14:42:41.000000 55.6922270078212 12.589231738820672 1.07427   12.600000000000023 90   16.560000000000002  
18960172990,67 Copenhagen Cycling 18960172990 67 2025-04-28 14:42:47.000000 55.692033134400845 12.588921943679452 1.1032899999999999   13.200000000000045 92   16.9632  
18960172990,68 Copenhagen Cycling 18960172990 68 2025-04-28 14:42:49.000000 55.691969599574804 12.588817840442061 1.11311   13.0 92   16.2252  
18960172990,69 Copenhagen Cycling 18960172990 69 2025-04-28 14:42:50.000000 55.69194696843624 12.58876251988113 1.11752   13.0 92   15.217200000000002  
18960172990,70 Copenhagen Cycling 18960172990 70 2025-04-28 14:42:55.000000 55.691829873248935 12.588514918461442 1.1377000000000002   13.600000000000023 93   14.745600000000001  
18960172990,71 Copenhagen Cycling 18960172990 71 2025-04-28 14:42:57.000000 55.69177312776446 12.588415257632732 1.14639   13.799999999999955 92   15.181200000000002  
18960172990,72 Copenhagen Cycling 18960172990 72 2025-04-28 14:43:00.000000 55.691710179671645 12.588268658146262 1.15815   14.399999999999977 93   11.6568  
18960172990,73 Copenhagen Cycling 18960172990 73 2025-04-28 14:43:01.000000 55.691722920164466 12.588227922096848 1.1608800000000001   14.600000000000023 93   8.499600000000001  
18960172990,74 Copenhagen Cycling 18960172990 74 2025-04-28 14:43:03.000000 55.69173892959952 12.588215516880155 1.1631200000000002   15.799999999999955 94   0.0  
18960172990,75 Copenhagen Cycling 18960172990 75 2025-04-28 14:43:04.000000 55.69173884578049 12.588215516880155 1.1631200000000002   15.799999999999955 93   1.4112  
18960172990,76 Copenhagen Cycling 18960172990 76 2025-04-28 14:43:10.000000 55.6917383428663 12.588215349242091 1.1631200000000002   15.799999999999955 94   0.0  
18960172990,77 Copenhagen Cycling 18960172990 77 2025-04-28 14:43:12.000000 55.69173817522824 12.588215181604028 1.1631200000000002   15.600000000000023 102   0.0  
18960172990,78 Copenhagen Cycling 18960172990 78 2025-04-28 14:43:13.000000 55.69173792377114 12.588215181604028 1.1631200000000002   15.600000000000023 110   1.4796000000000002  
18960172990,79 Copenhagen Cycling 18960172990 79 2025-04-28 14:43:14.000000 55.69173892959952 12.588194478303194 1.16427   15.600000000000023 112   4.8024000000000004  
18960172990,80 Copenhagen Cycling 18960172990 80 2025-04-28 14:43:18.000000 55.691811349242926 12.58812633343041 1.17327   15.399999999999977 112   11.6892  
18960172990,81 Copenhagen Cycling 18960172990 81 2025-04-28 14:43:23.000000 55.69194185547531 12.587937489151955 1.19207   14.799999999999955 112   13.7376  
18960172990,82 Copenhagen Cycling 18960172990 82 2025-04-28 14:43:29.000000 55.69208610802889 12.58766314946115 1.21554   15.399999999999977 110   13.636800000000001  
18960172990,83 Copenhagen Cycling 18960172990 83 2025-04-28 14:43:31.000000 55.69213170558214 12.587580922991037 1.22292   16.0 108   12.830400000000001  
18960172990,84 Copenhagen Cycling 18960172990 84 2025-04-28 14:43:37.000000 55.69225559011102 12.587316641584039 1.2445899999999999   16.600000000000023 107   13.233600000000001  
18960172990,85 Copenhagen Cycling 18960172990 85 2025-04-28 14:43:39.000000 55.69229322485626 12.587214969098568 1.25207   16.399999999999977 107   13.806000000000001  
18960172990,86 Copenhagen Cycling 18960172990 86 2025-04-28 14:43:45.000000 55.692440662533045 12.586919339373708 1.2771400000000002   16.0 109   14.277600000000001  
18960172990,87 Copenhagen Cycling 18960172990 87 2025-04-28 14:43:50.000000 55.69254945963621 12.586717838421464 1.29471   16.399999999999977 112   6.9516  
18960172990,88 Copenhagen Cycling 18960172990 88 2025-04-28 14:43:51.000000 55.69254945963621 12.586717838421464 1.2961600000000002   16.600000000000023 113   4.0644  
18960172990,89 Copenhagen Cycling 18960172990 89 2025-04-28 14:43:57.000000 55.69256848655641 12.586690010502934 1.29725   16.399999999999977 111   0.0  
18960172990,90 Copenhagen Cycling 18960172990 90 2025-04-28 14:44:03.000000 55.6925655528903 12.586690094321966 1.29725   16.399999999999977 108   0.0  
18960172990,91 Copenhagen Cycling 18960172990 91 2025-04-28 14:44:04.000000 55.6925655528903 12.586690010502934 1.29725   16.0 105   0.0  
18960172990,92 Copenhagen Cycling 18960172990 92 2025-04-28 14:44:06.000000 55.69256538525224 12.586689926683903 1.29725   16.0 97   0.0  
18960172990,93 Copenhagen Cycling 18960172990 93 2025-04-28 14:44:07.000000 55.692565301433206 12.586689926683903 1.29725   16.0 90   0.0  
18960172990,94 Copenhagen Cycling 18960172990 94 2025-04-28 14:44:09.000000 55.69256513379514 12.586690010502934 1.29725   16.0 87   0.0  
18960172990,95 Copenhagen Cycling 18960172990 95 2025-04-28 14:44:13.000000 55.692564714699984 12.58668975904584 1.29725   16.0 86   0.774  
18960172990,96 Copenhagen Cycling 18960172990 96 2025-04-28 14:44:17.000000 55.69261886179447 12.586577106267214 1.3062200000000002   16.200000000000045 85   16.761599999999998  
18960172990,97 Copenhagen Cycling 18960172990 97 2025-04-28 14:44:20.000000 55.69272388704121 12.586422711610794 1.3217700000000001   15.799999999999955 86   19.011599999999998  
18960172990,98 Copenhagen Cycling 18960172990 98 2025-04-28 14:44:22.000000 55.692796390503645 12.586323218420148 1.33197   14.799999999999955 85   19.2132  
18960172990,99 Copenhagen Cycling 18960172990 99 2025-04-28 14:44:23.000000 55.692829079926014 12.586262030526996 1.33727   13.399999999999977 85   19.1808  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE activity_records (
	activity_id VARCHAR NOT NULL, 
	record INTEGER NOT NULL, 
	timestamp DATETIME, 
	position_lat FLOAT, 
	position_long FLOAT, 
	distance FLOAT, 
	cadence INTEGER, 
	altitude FLOAT, 
	hr INTEGER, 
	rr FLOAT, 
	speed FLOAT, 
	temperature FLOAT, 
	PRIMARY KEY (activity_id, record), 
	FOREIGN KEY(activity_id) REFERENCES activities (activity_id)
);
Powered by Datasette · Queries took 12.243ms