home / james_garmin_activities

activity_records

262 rows where activity_id = 18843519154

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cadence, hr, timestamp (date)

Link activity_id record timestamp position_lat position_long distance cadence altitude hr rr speed temperature
18843519154,0 Copenhagen Walking 18843519154 0 2025-04-16 12:49:55.000000 55.695937257260084 12.570894565433264 0.0 0 11.0 97      
18843519154,1 Copenhagen Walking 18843519154 1 2025-04-16 12:49:56.000000 55.69593692198396 12.570907222107053 0.00071 0 11.0 97   0.0  
18843519154,2 Copenhagen Walking 18843519154 2 2025-04-16 12:49:59.000000 55.69596206769347 12.57091250270605 0.0032300000000000002 0 11.199999999999989 100   0.0  
18843519154,3 Copenhagen Walking 18843519154 3 2025-04-16 12:50:00.000000 55.69597405381501 12.570920297876 0.00479 0 11.199999999999989 101   0.0  
18843519154,4 Copenhagen Walking 18843519154 4 2025-04-16 12:50:05.000000 55.696046305820346 12.570902360603213 0.012530000000000001 57 11.399999999999977 101   5.0724  
18843519154,5 Copenhagen Walking 18843519154 5 2025-04-16 12:50:09.000000 55.69609626196325 12.570857433602214 0.018900000000000004 55 11.399999999999977 100   5.4432  
18843519154,6 Copenhagen Walking 18843519154 6 2025-04-16 12:50:14.000000 55.696150325238705 12.570761879906058 0.027670000000000004 0 11.0 100   6.2496  
18843519154,7 Copenhagen Walking 18843519154 7 2025-04-16 12:50:19.000000 55.696213440969586 12.570716785266995 0.03494 60 10.800000000000011 100   5.4432  
18843519154,8 Copenhagen Walking 18843519154 8 2025-04-16 12:50:25.000000 55.69628753699362 12.570688873529434 0.043070000000000004 57 11.199999999999989 98   4.8384  
18843519154,9 Copenhagen Walking 18843519154 9 2025-04-16 12:50:27.000000 55.69630631245673 12.570671858265996 0.04543 57 11.199999999999989 98   4.6368  
18843519154,10 Copenhagen Walking 18843519154 10 2025-04-16 12:50:32.000000 55.69638015702367 12.570668086409569 0.05367 55 11.0 95   4.8384  
18843519154,11 Copenhagen Walking 18843519154 11 2025-04-16 12:50:34.000000 55.69640404544771 12.570668756961823 0.05575 0 11.0 95   4.8708  
18843519154,12 Copenhagen Walking 18843519154 12 2025-04-16 12:50:39.000000 55.696453833952546 12.570654591545463 0.0621 57 11.0 94   6.6168000000000005  
18843519154,13 Copenhagen Walking 18843519154 13 2025-04-16 12:50:44.000000 55.696489876136184 12.570655597373843 0.06526000000000001 0 11.0 95   3.7944000000000004  
18843519154,14 Copenhagen Walking 18843519154 14 2025-04-16 12:50:50.000000 55.6965789757669 12.5706319604069 0.07521000000000001 60 11.0 98   6.3504000000000005  
18843519154,15 Copenhagen Walking 18843519154 15 2025-04-16 12:50:56.000000 55.69666623137891 12.570615699514747 0.08546000000000001 59 10.800000000000011 98   5.1408  
18843519154,16 Copenhagen Walking 18843519154 16 2025-04-16 12:50:58.000000 55.69669623859227 12.570611843839288 0.08874 0 10.800000000000011 97   5.2416  
18843519154,17 Copenhagen Walking 18843519154 17 2025-04-16 12:51:04.000000 55.696779219433665 12.570619387552142 0.09847 57 10.800000000000011 96   5.508  
18843519154,18 Copenhagen Walking 18843519154 18 2025-04-16 12:51:05.000000 55.696791959926486 12.570614777505398 0.10009000000000001 57 10.800000000000011 96   5.5764  
18843519154,19 Copenhagen Walking 18843519154 19 2025-04-16 12:51:11.000000 55.69687636569142 12.570624249055982 0.10922 58 10.800000000000011 95   5.6448  
18843519154,20 Copenhagen Walking 18843519154 20 2025-04-16 12:51:17.000000 55.69696135818958 12.570654675364494 0.11910000000000001 59 10.600000000000023 94   5.6448  
18843519154,21 Copenhagen Walking 18843519154 21 2025-04-16 12:51:18.000000 55.69697200320661 12.570647215470672 0.12043000000000001 59 10.600000000000023 95   5.6448  
18843519154,22 Copenhagen Walking 18843519154 22 2025-04-16 12:51:24.000000 55.69704291410744 12.570647215470672 0.12776 57 10.800000000000011 94   5.4072000000000005  
18843519154,23 Copenhagen Walking 18843519154 23 2025-04-16 12:51:26.000000 55.69706244394183 12.570652244612575 0.12968000000000002 57 10.800000000000011 94   5.3064  
18843519154,24 Copenhagen Walking 18843519154 24 2025-04-16 12:51:32.000000 55.697127571329474 12.570643527433276 0.13740000000000002 57 10.800000000000011 93   5.0724  
18843519154,25 Copenhagen Walking 18843519154 25 2025-04-16 12:51:33.000000 55.69714433513582 12.570637073367834 0.13897 57 10.800000000000011 93   5.040000000000001  
18843519154,26 Copenhagen Walking 18843519154 26 2025-04-16 12:51:39.000000 55.697231171652675 12.570622991770506 0.14877 0 10.800000000000011 93   5.1048  
18843519154,27 Copenhagen Walking 18843519154 27 2025-04-16 12:51:41.000000 55.697259083390236 12.570626260712743 0.15239000000000003 57 10.800000000000011 93   5.1408  
18843519154,28 Copenhagen Walking 18843519154 28 2025-04-16 12:51:47.000000 55.697335777804255 12.570637911558151 0.16158000000000003 57 10.800000000000011 93   5.2056  
18843519154,29 Copenhagen Walking 18843519154 29 2025-04-16 12:51:52.000000 55.6973837222904 12.570576053112745 0.16795000000000002 57 10.600000000000023 93   5.1732000000000005  
18843519154,30 Copenhagen Walking 18843519154 30 2025-04-16 12:51:58.000000 55.69743803702295 12.570510590448976 0.17485 0 10.800000000000011 92   5.040000000000001  
18843519154,31 Copenhagen Walking 18843519154 31 2025-04-16 12:51:59.000000 55.69744826294482 12.570498269051313 0.17622000000000002 58 10.800000000000011 92   4.9716000000000005  
18843519154,32 Copenhagen Walking 18843519154 32 2025-04-16 12:52:05.000000 55.69750316441059 12.57042626850307 0.18353 59 10.800000000000011 93   4.8708  
18843519154,33 Copenhagen Walking 18843519154 33 2025-04-16 12:52:07.000000 55.69751976057887 12.570394333451986 0.18578 59 10.800000000000011 93   4.8708  
18843519154,34 Copenhagen Walking 18843519154 34 2025-04-16 12:52:13.000000 55.69758757017553 12.570306658744812 0.19505000000000003 68 10.800000000000011 94   4.903200000000001  
18843519154,35 Copenhagen Walking 18843519154 35 2025-04-16 12:52:19.000000 55.69765496067703 12.57022300735116 0.20443 51 10.800000000000011 94   5.3064  
18843519154,36 Copenhagen Walking 18843519154 36 2025-04-16 12:52:25.000000 55.697727212682366 12.570134494453669 0.21411000000000002 61 10.399999999999977 94   5.4432  
18843519154,37 Copenhagen Walking 18843519154 37 2025-04-16 12:52:28.000000 55.697752023115754 12.570080179721117 0.2185 60 10.399999999999977 95   5.4072000000000005  
18843519154,38 Copenhagen Walking 18843519154 38 2025-04-16 12:52:34.000000 55.69779376499355 12.569962749257684 0.22714 57 11.0 94   5.274  
18843519154,39 Copenhagen Walking 18843519154 39 2025-04-16 12:52:36.000000 55.697807259857655 12.569912038743496 0.23076 57 10.800000000000011 93   5.3064  
18843519154,40 Copenhagen Walking 18843519154 40 2025-04-16 12:52:42.000000 55.69785344414413 12.56979008205235 0.24051 59 10.800000000000011 94   5.4432  
18843519154,41 Copenhagen Walking 18843519154 41 2025-04-16 12:52:46.000000 55.69786962121725 12.569710034877062 0.24567000000000003 59 10.800000000000011 95   5.2416  
18843519154,42 Copenhagen Walking 18843519154 42 2025-04-16 12:52:52.000000 55.69790541194379 12.5696078594774 0.25370000000000004 58 10.800000000000011 95   5.1732000000000005  
18843519154,43 Copenhagen Walking 18843519154 43 2025-04-16 12:52:55.000000 55.69790851324797 12.569564105942845 0.25588 55 10.800000000000011 92   5.0040000000000004  
18843519154,44 Copenhagen Walking 18843519154 44 2025-04-16 12:53:01.000000 55.697925025597215 12.569452039897442 0.26295 57 10.800000000000011 93   3.6612000000000005  
18843519154,45 Copenhagen Walking 18843519154 45 2025-04-16 12:53:03.000000 55.69793173111975 12.569420607760549 0.26523 57 11.0 94   3.8952000000000004  
18843519154,46 Copenhagen Walking 18843519154 46 2025-04-16 12:53:09.000000 55.69795888848603 12.569302255287766 0.27322 60 10.600000000000023 95   4.6008000000000004  
18843519154,47 Copenhagen Walking 18843519154 47 2025-04-16 12:53:14.000000 55.69797330535948 12.569206701591611 0.27913 59 11.199999999999989 96   4.266  
18843519154,48 Copenhagen Walking 18843519154 48 2025-04-16 12:53:20.000000 55.698007168248296 12.569049540907145 0.29006 59 11.0 97   5.1732000000000005  
18843519154,49 Copenhagen Walking 18843519154 49 2025-04-16 12:53:26.000000 55.69804983213544 12.568931607529521 0.29894 59 11.0 97   5.4072000000000005  
18843519154,50 Copenhagen Walking 18843519154 50 2025-04-16 12:53:27.000000 55.69805569946766 12.568911155685782 0.30061000000000004 58 11.0 97   5.475600000000001  
18843519154,51 Copenhagen Walking 18843519154 51 2025-04-16 12:53:33.000000 55.698090149089694 12.568783247843385 0.30922000000000005 0 11.0 97   5.1408  
18843519154,52 Copenhagen Walking 18843519154 52 2025-04-16 12:53:39.000000 55.69813105277717 12.568658273667097 0.31847000000000003 59 11.0 96   5.3748000000000005  
18843519154,53 Copenhagen Walking 18843519154 53 2025-04-16 12:53:40.000000 55.698136668652296 12.56863103248179 0.32025 59 11.0 97   5.3748000000000005  
18843519154,54 Copenhagen Walking 18843519154 54 2025-04-16 12:53:46.000000 55.698182601481676 12.568507734686136 0.32951 60 10.800000000000011 99   5.4072000000000005  
18843519154,55 Copenhagen Walking 18843519154 55 2025-04-16 12:53:48.000000 55.6981950905174 12.568460796028376 0.33294999999999997 59 10.800000000000011 96   5.4072000000000005  
18843519154,56 Copenhagen Walking 18843519154 56 2025-04-16 12:53:54.000000 55.69824680685997 12.568357782438397 0.3413 60 11.0 97   5.4072000000000005  
18843519154,57 Copenhagen Walking 18843519154 57 2025-04-16 12:53:55.000000 55.69825611077249 12.568337246775627 0.34307 60 11.0 97   5.4072000000000005  
18843519154,58 Copenhagen Walking 18843519154 58 2025-04-16 12:54:01.000000 55.69828670471907 12.568228617310524 0.35066 59 11.199999999999989 97   5.3064  
18843519154,59 Copenhagen Walking 18843519154 59 2025-04-16 12:54:07.000000 55.69832291454077 12.56808671168983 0.36059 60 11.199999999999989 96   5.3064  
18843519154,60 Copenhagen Walking 18843519154 60 2025-04-16 12:54:08.000000 55.69833096116781 12.568060057237744 0.36260000000000003 60 11.199999999999989 96   5.3424000000000005  
18843519154,61 Copenhagen Walking 18843519154 61 2025-04-16 12:54:14.000000 55.69837186485529 12.567953523248434 0.37075 60 11.199999999999989 95   5.3064  
18843519154,62 Copenhagen Walking 18843519154 62 2025-04-16 12:54:15.000000 55.69837957620621 12.567937010899186 0.37231000000000003 60 11.199999999999989 95   5.3064  
18843519154,63 Copenhagen Walking 18843519154 63 2025-04-16 12:54:21.000000 55.698417630046606 12.567844642326236 0.37939 61 11.199999999999989 96   5.1732000000000005  
18843519154,64 Copenhagen Walking 18843519154 64 2025-04-16 12:54:23.000000 55.698433723300695 12.567804157733917 0.38231 61 11.399999999999977 95   5.1408  
18843519154,65 Copenhagen Walking 18843519154 65 2025-04-16 12:54:29.000000 55.6984958332032 12.567706676200032 0.39152 59 11.399999999999977 96   5.1732000000000005  
18843519154,66 Copenhagen Walking 18843519154 66 2025-04-16 12:54:32.000000 55.69851209409535 12.567659821361303 0.39494 58 11.600000000000023 96   5.1408  
18843519154,67 Copenhagen Walking 18843519154 67 2025-04-16 12:54:38.000000 55.69855132140219 12.567552113905549 0.40223000000000003 59 11.600000000000023 96   5.0040000000000004  
18843519154,68 Copenhagen Walking 18843519154 68 2025-04-16 12:54:39.000000 55.69856003858149 12.56753308698535 0.40351 59 11.600000000000023 95   4.9716000000000005  
18843519154,69 Copenhagen Walking 18843519154 69 2025-04-16 12:54:45.000000 55.69860463030636 12.5674216914922 0.41253000000000006 60 11.800000000000011 96   4.9716000000000005  
18843519154,70 Copenhagen Walking 18843519154 70 2025-04-16 12:54:46.000000 55.69861049763858 12.567406436428428 0.41368 60 11.800000000000011 95   4.9716000000000005  
18843519154,71 Copenhagen Walking 18843519154 71 2025-04-16 12:54:52.000000 55.6986388284713 12.567301075905561 0.42093 59 11.800000000000011 96   4.8708  
18843519154,72 Copenhagen Walking 18843519154 72 2025-04-16 12:54:54.000000 55.69865140132606 12.567268973216414 0.42321000000000003 59 11.800000000000011 95   4.8024000000000004  
18843519154,73 Copenhagen Walking 18843519154 73 2025-04-16 12:55:00.000000 55.698696076869965 12.567149447277188 0.4322 60 12.0 95   4.8024000000000004  
18843519154,74 Copenhagen Walking 18843519154 74 2025-04-16 12:55:01.000000 55.698704374954104 12.56713000126183 0.43349000000000004 60 12.0 96   4.8384  
18843519154,75 Copenhagen Walking 18843519154 75 2025-04-16 12:55:07.000000 55.6987511459738 12.567004105076194 0.44217 60 12.0 95   4.8384  
18843519154,76 Copenhagen Walking 18843519154 76 2025-04-16 12:55:09.000000 55.6987614557147 12.56696772761643 0.44491 58 12.0 95   4.8708  
18843519154,77 Copenhagen Walking 18843519154 77 2025-04-16 12:55:15.000000 55.6988029461354 12.566850632429123 0.45405 59 12.200000000000045 95   4.903200000000001  
18843519154,78 Copenhagen Walking 18843519154 78 2025-04-16 12:55:17.000000 55.698813842609525 12.566816937178373 0.45711 59 12.200000000000045 95   4.9392000000000005  
18843519154,79 Copenhagen Walking 18843519154 79 2025-04-16 12:55:23.000000 55.698858769610524 12.566708559170365 0.46526 59 12.200000000000045 95   4.9392000000000005  
18843519154,80 Copenhagen Walking 18843519154 80 2025-04-16 12:55:25.000000 55.69888047873974 12.566677378490567 0.46819 58 12.200000000000045 96   4.9392000000000005  
18843519154,81 Copenhagen Walking 18843519154 81 2025-04-16 12:55:31.000000 55.69894158281386 12.566578052937984 0.47892 57 12.799999999999955 95   5.1048  
18843519154,82 Copenhagen Walking 18843519154 82 2025-04-16 12:55:33.000000 55.698955999687314 12.566537903621793 0.48151 59 12.799999999999955 95   5.1048  
18843519154,83 Copenhagen Walking 18843519154 83 2025-04-16 12:55:38.000000 55.6990051176399 12.566436566412449 0.49004000000000003 60 13.0 98   5.274  
18843519154,84 Copenhagen Walking 18843519154 84 2025-04-16 12:55:39.000000 55.69901970215142 12.566440422087908 0.49132 60 13.0 98   5.274  
18843519154,85 Copenhagen Walking 18843519154 85 2025-04-16 12:55:40.000000 55.69903068244457 12.566445786505938 0.49251 60 13.0 98   5.274  
18843519154,86 Copenhagen Walking 18843519154 86 2025-04-16 12:55:42.000000 55.699044512584805 12.566421730443835 0.49515000000000003 57 13.0 97   5.2056  
18843519154,87 Copenhagen Walking 18843519154 87 2025-04-16 12:55:44.000000 55.69904811680317 12.566375965252519 0.49734000000000006 57 13.0 98   5.1732000000000005  
18843519154,88 Copenhagen Walking 18843519154 88 2025-04-16 12:55:47.000000 55.699062617495656 12.566311089321971 0.50154 57 13.0 98   5.1048  
18843519154,89 Copenhagen Walking 18843519154 89 2025-04-16 12:55:50.000000 55.69909304380417 12.566252751275897 0.5062800000000001 61 13.200000000000045 98   5.1048  
18843519154,90 Copenhagen Walking 18843519154 90 2025-04-16 12:55:56.000000 55.69914928637445 12.566184438765049 0.5143800000000001 0 13.200000000000045 99   5.1408  
18843519154,91 Copenhagen Walking 18843519154 91 2025-04-16 12:56:02.000000 55.69920971989632 12.566092321649194 0.52258 60 13.399999999999977 97   5.0724  
18843519154,92 Copenhagen Walking 18843519154 92 2025-04-16 12:56:03.000000 55.69921885617077 12.56607798859477 0.52386 61 13.200000000000045 96   5.0724  
18843519154,93 Copenhagen Walking 18843519154 93 2025-04-16 12:56:09.000000 55.6992728356272 12.566000036895275 0.5317500000000001 59 13.399999999999977 96   5.0040000000000004  
18843519154,94 Copenhagen Walking 18843519154 94 2025-04-16 12:56:13.000000 55.69931784644723 12.565934658050537 0.5376000000000001 57 13.799999999999955 94   4.9716000000000005  
18843519154,95 Copenhagen Walking 18843519154 95 2025-04-16 12:56:19.000000 55.69938875734806 12.56584882736206 0.5477799999999999 59 14.0 95   5.274  
18843519154,96 Copenhagen Walking 18843519154 96 2025-04-16 12:56:20.000000 55.69940007291734 12.565834242850542 0.5494800000000001 60 14.0 95   5.3064  
18843519154,97 Copenhagen Walking 18843519154 97 2025-04-16 12:56:26.000000 55.699470061808825 12.565768025815487 0.55793 61 14.0 97   5.2416  
18843519154,98 Copenhagen Walking 18843519154 98 2025-04-16 12:56:28.000000 55.6994919385761 12.565746316686273 0.56077 60 14.0 97   5.2056  
18843519154,99 Copenhagen Walking 18843519154 99 2025-04-16 12:56:29.000000 55.69950392469764 12.56573743186891 0.56216 60 14.0 98   5.2056  

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.536ms