home / james_garmin_activities

activity_records

583 rows where activity_id = 18971654111

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cadence, timestamp (date)

Link activity_id record timestamp position_lat position_long distance cadence altitude hr rr speed temperature
18971654111,0 Copenhagen Walking 18971654111 0 2025-04-29 15:44:19.000000     0.0 0 19.799999999999955 83      
18971654111,1 Copenhagen Walking 18971654111 1 2025-04-29 15:44:20.000000     0.0 0 19.799999999999955 83   0.0  
18971654111,2 Copenhagen Walking 18971654111 2 2025-04-29 15:44:24.000000 55.70265468209982 12.55598827265203 0.0 0 20.0 83   0.0  
18971654111,3 Copenhagen Walking 18971654111 3 2025-04-29 15:44:30.000000 55.70263221859932 12.555928928777575 0.00684 0 19.799999999999955 84   5.911200000000001  
18971654111,4 Copenhagen Walking 18971654111 4 2025-04-29 15:44:36.000000 55.702581675723195 12.555849719792604 0.014310000000000002 56 20.0 84   5.7456000000000005  
18971654111,5 Copenhagen Walking 18971654111 5 2025-04-29 15:44:38.000000 55.70256222970784 12.555824154987931 0.01706 56 20.200000000000045 84   5.4072000000000005  
18971654111,6 Copenhagen Walking 18971654111 6 2025-04-29 15:44:42.000000 55.70252828299999 12.555773444473743 0.02153 55 21.0 84   4.266  
18971654111,7 Copenhagen Walking 18971654111 7 2025-04-29 15:44:45.000000 55.702498611062765 12.555714687332511 0.026810000000000004 54 21.0 84   4.5360000000000005  
18971654111,8 Copenhagen Walking 18971654111 8 2025-04-29 15:44:51.000000 55.702447229996324 12.555627850815654 0.03484 55 20.799999999999955 83   4.3992  
18971654111,9 Copenhagen Walking 18971654111 9 2025-04-29 15:44:53.000000 55.702428203076124 12.555597256869078 0.037340000000000005 55 20.799999999999955 83   4.4352  
18971654111,10 Copenhagen Walking 18971654111 10 2025-04-29 15:44:59.000000 55.70237489417195 12.555517544969916 0.04483 55 21.200000000000045 83   4.5360000000000005  
18971654111,11 Copenhagen Walking 18971654111 11 2025-04-29 15:45:00.000000 55.70236441679299 12.55549667403102 0.046950000000000006 56 21.0 83   4.6368  
18971654111,12 Copenhagen Walking 18971654111 12 2025-04-29 15:45:06.000000 55.702305575832725 12.555406400933862 0.05655 56 20.600000000000023 83   5.7456000000000005  
18971654111,13 Copenhagen Walking 18971654111 13 2025-04-29 15:45:07.000000 55.70229744538665 12.555392570793629 0.057390000000000004 56 20.399999999999977 82   5.6772  
18971654111,14 Copenhagen Walking 18971654111 14 2025-04-29 15:45:13.000000 55.702246483415365 12.5553007889539 0.06548999999999999 56 20.600000000000023 83   5.3424000000000005  
18971654111,15 Copenhagen Walking 18971654111 15 2025-04-29 15:45:14.000000 55.70223709568381 12.55528218112886 0.06753 56 20.799999999999955 84   5.274  
18971654111,16 Copenhagen Walking 18971654111 16 2025-04-29 15:45:20.000000 55.70218554697931 12.55520205013454 0.07466 55 21.0 83   5.2056  
18971654111,17 Copenhagen Walking 18971654111 17 2025-04-29 15:45:21.000000 55.70217817090452 12.555187717080116 0.07585000000000001 53 21.0 83   5.1732000000000005  
18971654111,18 Copenhagen Walking 18971654111 18 2025-04-29 15:45:27.000000 55.702131651341915 12.555116470903158 0.08315 55 20.799999999999955 83   4.9392000000000005  
18971654111,19 Copenhagen Walking 18971654111 19 2025-04-29 15:45:29.000000 55.70211614482105 12.555082524195313 0.08532000000000001 55 20.799999999999955 83   4.903200000000001  
18971654111,20 Copenhagen Walking 18971654111 20 2025-04-29 15:45:35.000000 55.70206107571721 12.554951179772615 0.09473000000000001 56 21.0 84   4.903200000000001  
18971654111,21 Copenhagen Walking 18971654111 21 2025-04-29 15:45:38.000000 55.70203970186412 12.554900804534554 0.09915 57 21.200000000000045 83   5.0040000000000004  
18971654111,22 Copenhagen Walking 18971654111 22 2025-04-29 15:45:44.000000 55.701986979693174 12.554796617478132 0.10761 56 21.399999999999977 83   6.3504000000000005  
18971654111,23 Copenhagen Walking 18971654111 23 2025-04-29 15:45:46.000000 55.70196929387748 12.554753702133894 0.11102 57 21.399999999999977 83   4.9716000000000005  
18971654111,24 Copenhagen Walking 18971654111 24 2025-04-29 15:45:51.000000 55.70192126557231 12.55464993417263 0.11979000000000001 57 21.0 79   6.282000000000001  
18971654111,25 Copenhagen Walking 18971654111 25 2025-04-29 15:45:53.000000 55.701900562271476 12.554622273892164 0.12269 58 20.799999999999955 78   5.5440000000000005  
18971654111,26 Copenhagen Walking 18971654111 26 2025-04-29 15:45:59.000000 55.70185286924243 12.554539209231734 0.13021000000000002 59 20.600000000000023 77   5.0724  
18971654111,27 Copenhagen Walking 18971654111 27 2025-04-29 15:46:00.000000 55.701843816787004 12.554525714367628 0.13166 59 20.600000000000023 77   5.0724  
18971654111,28 Copenhagen Walking 18971654111 28 2025-04-29 15:46:06.000000 55.70178841240704 12.554455557838082 0.13859000000000002 59 21.200000000000045 77   4.8384  
18971654111,29 Copenhagen Walking 18971654111 29 2025-04-29 15:46:08.000000 55.7017679605633 12.554422030225396 0.14216 58 21.200000000000045 77   4.77  
18971654111,30 Copenhagen Walking 18971654111 30 2025-04-29 15:46:14.000000 55.701706102117896 12.554337456822395 0.15084 58 21.0 77   4.77  
18971654111,31 Copenhagen Walking 18971654111 31 2025-04-29 15:46:15.000000 55.70169906131923 12.554325805976987 0.15184999999999998 58 21.0 78   4.8024000000000004  
18971654111,32 Copenhagen Walking 18971654111 32 2025-04-29 15:46:21.000000 55.701645920053124 12.554210387170315 0.16118000000000002 58 21.0 80   4.9716000000000005  
18971654111,33 Copenhagen Walking 18971654111 33 2025-04-29 15:46:24.000000 55.701628820970654 12.554132016375661 0.16656 57 21.0 81   6.4476  
18971654111,34 Copenhagen Walking 18971654111 34 2025-04-29 15:46:30.000000 55.70157811045647 12.55399220623076 0.17691 56 21.0 81   6.1128  
18971654111,35 Copenhagen Walking 18971654111 35 2025-04-29 15:46:31.000000 55.70156989619136 12.553971838206053 0.17843 56 21.0 81   5.274  
18971654111,36 Copenhagen Walking 18971654111 36 2025-04-29 15:46:37.000000 55.70152304135263 12.553869159892201 0.18653 57 20.799999999999955 82   4.9392000000000005  
18971654111,37 Copenhagen Walking 18971654111 37 2025-04-29 15:46:39.000000 55.7015036791563 12.553840409964323 0.18949000000000002 57 20.799999999999955 82   4.903200000000001  
18971654111,38 Copenhagen Walking 18971654111 38 2025-04-29 15:46:45.000000 55.701455315575004 12.553768074139953 0.19643000000000002 57 20.799999999999955 83   4.5360000000000005  
18971654111,39 Copenhagen Walking 18971654111 39 2025-04-29 15:46:46.000000 55.70144006051123 12.553749550133944 0.19841 57 20.799999999999955 82   4.5360000000000005  
18971654111,40 Copenhagen Walking 18971654111 40 2025-04-29 15:46:52.000000 55.70136864669621 12.553643770515919 0.20944000000000002 57 20.799999999999955 81   6.3828000000000005  
18971654111,41 Copenhagen Walking 18971654111 41 2025-04-29 15:46:58.000000 55.70132598280907 12.553552994504571 0.21655000000000002 55 21.200000000000045 83   4.6692  
18971654111,42 Copenhagen Walking 18971654111 42 2025-04-29 15:46:59.000000 55.701320031657815 12.553535476326942 0.21809 54 21.200000000000045 83   4.8384  
18971654111,43 Copenhagen Walking 18971654111 43 2025-04-29 15:47:05.000000 55.70127736777067 12.553423661738634 0.22656 56 21.200000000000045 84   5.040000000000001  
18971654111,44 Copenhagen Walking 18971654111 44 2025-04-29 15:47:06.000000 55.7012705784291 12.553411424160004 0.22766 56 21.200000000000045 83   5.040000000000001  
18971654111,45 Copenhagen Walking 18971654111 45 2025-04-29 15:47:12.000000 55.70123319514096 12.553304806351662 0.23509000000000002 56 21.200000000000045 84   4.6692  
18971654111,46 Copenhagen Walking 18971654111 46 2025-04-29 15:47:14.000000 55.70121131837368 12.55327588878572 0.23793 56 21.200000000000045 84   4.77  
18971654111,47 Copenhagen Walking 18971654111 47 2025-04-29 15:47:18.000000 55.701190028339624 12.553206821903586 0.24353 57 21.0 84   4.77  
18971654111,48 Copenhagen Walking 18971654111 48 2025-04-29 15:47:20.000000 55.70117670111358 12.55317522212863 0.24606 57 21.0 84   4.9716000000000005  
18971654111,49 Copenhagen Walking 18971654111 49 2025-04-29 15:47:26.000000 55.701127583160996 12.553080758079886 0.2539 59 21.0 84   4.77  
18971654111,50 Copenhagen Walking 18971654111 50 2025-04-29 15:47:27.000000 55.70111987181008 12.553061144426465 0.25537 59 21.0 84   4.8024000000000004  
18971654111,51 Copenhagen Walking 18971654111 51 2025-04-29 15:47:33.000000 55.701061617583036 12.55298025906086 0.26337 57 21.0 84   4.903200000000001  
18971654111,52 Copenhagen Walking 18971654111 52 2025-04-29 15:47:36.000000 55.70101828314364 12.552924351766706 0.26914 58 20.799999999999955 83   4.9392000000000005  
18971654111,53 Copenhagen Walking 18971654111 53 2025-04-29 15:47:42.000000 55.700958436354995 12.552835000678897 0.27796 57 20.799999999999955 81   5.2056  
18971654111,54 Copenhagen Walking 18971654111 54 2025-04-29 15:47:43.000000 55.70094804279506 12.552818907424808 0.27913 57 20.799999999999955 80   5.2056  
18971654111,55 Copenhagen Walking 18971654111 55 2025-04-29 15:47:49.000000 55.70089372806251 12.55271840840578 0.28803 58 20.399999999999977 80   5.274  
18971654111,56 Copenhagen Walking 18971654111 56 2025-04-29 15:47:51.000000 55.70087034255266 12.55267289467156 0.29254 57 20.399999999999977 79   5.274  
18971654111,57 Copenhagen Walking 18971654111 57 2025-04-29 15:47:57.000000 55.70080689154565 12.552586225792766 0.30181 57 20.200000000000045 80   5.274  
18971654111,58 Copenhagen Walking 18971654111 58 2025-04-29 15:47:58.000000 55.700796665623784 12.55257180891931 0.30326 58 20.200000000000045 80   5.3064  
18971654111,59 Copenhagen Walking 18971654111 59 2025-04-29 15:48:01.000000 55.70077495649457 12.552514895796776 0.3073 58 20.0 80   5.3424000000000005  
18971654111,60 Copenhagen Walking 18971654111 60 2025-04-29 15:48:06.000000 55.700723407790065 12.552436776459217 0.31460000000000005 58 20.200000000000045 80   5.3424000000000005  
18971654111,61 Copenhagen Walking 18971654111 61 2025-04-29 15:48:12.000000 55.7006714399904 12.55228984169662 0.32563 60 20.399999999999977 79   5.508  
18971654111,62 Copenhagen Walking 18971654111 62 2025-04-29 15:48:13.000000 55.70066314190626 12.552264025434852 0.32729 61 20.399999999999977 79   5.508  
18971654111,63 Copenhagen Walking 18971654111 63 2025-04-29 15:48:19.000000 55.70059709250927 12.55211004987359 0.33958 69 20.200000000000045 79   6.4836  
18971654111,64 Copenhagen Walking 18971654111 64 2025-04-29 15:48:25.000000 55.7005366589874 12.552021872252226 0.34817000000000004 67 19.799999999999955 79   6.0804  
18971654111,65 Copenhagen Walking 18971654111 65 2025-04-29 15:48:26.000000 55.70053079165518 12.5519990734756 0.34943 64 19.799999999999955 79   5.508  
18971654111,66 Copenhagen Walking 18971654111 66 2025-04-29 15:48:32.000000 55.700492318719625 12.551880721002817 0.35768 61 20.0 80   5.4072000000000005  
18971654111,67 Copenhagen Walking 18971654111 67 2025-04-29 15:48:34.000000 55.70047530345619 12.551838476210833 0.36134000000000005 61 20.0 81   5.475600000000001  
18971654111,68 Copenhagen Walking 18971654111 68 2025-04-29 15:48:38.000000 55.700440518558025 12.551761697977781 0.36775 62 19.799999999999955 84   5.7096  
18971654111,69 Copenhagen Walking 18971654111 69 2025-04-29 15:48:43.000000 55.70039249025285 12.551678968593478 0.37492000000000003 60 19.799999999999955 86   5.5764  
18971654111,70 Copenhagen Walking 18971654111 70 2025-04-29 15:48:49.000000 55.70034395903349 12.551570674404502 0.38337 61 19.600000000000023 86   5.4072000000000005  
18971654111,71 Copenhagen Walking 18971654111 71 2025-04-29 15:48:50.000000 55.70033725351095 12.55155592225492 0.38458 61 19.600000000000023 87   5.4072000000000005  
18971654111,72 Copenhagen Walking 18971654111 72 2025-04-29 15:48:54.000000 55.70030825212598 12.551470845937729 0.39071000000000006 60 19.600000000000023 86   5.3748000000000005  
18971654111,73 Copenhagen Walking 18971654111 73 2025-04-29 15:48:57.000000 55.700280759483576 12.551428182050586 0.39494 60 19.600000000000023 86   5.3748000000000005  
18971654111,74 Copenhagen Walking 18971654111 74 2025-04-29 15:49:03.000000 55.70021320134401 12.551345704123378 0.40396000000000004 62 19.600000000000023 85   5.3748000000000005  
18971654111,75 Copenhagen Walking 18971654111 75 2025-04-29 15:49:09.000000 55.70014916360378 12.551245875656605 0.41338 61 19.200000000000045 84   5.3748000000000005  
18971654111,76 Copenhagen Walking 18971654111 76 2025-04-29 15:49:15.000000 55.70009719580412 12.551147220656276 0.42141 61 19.200000000000045 85   5.3424000000000005  
18971654111,77 Copenhagen Walking 18971654111 77 2025-04-29 15:49:17.000000 55.7000775821507 12.551120147109032 0.42401 61 19.200000000000045 86   5.3424000000000005  
18971654111,78 Copenhagen Walking 18971654111 78 2025-04-29 15:49:23.000000 55.700009018182755 12.550986874848604 0.43589 59 19.399999999999977 88   5.508  
18971654111,79 Copenhagen Walking 18971654111 79 2025-04-29 15:49:29.000000 55.69995369762182 12.550910599529743 0.44295 60 19.200000000000045 88   5.508  
18971654111,80 Copenhagen Walking 18971654111 80 2025-04-29 15:49:30.000000 55.69994715973735 12.550898278132081 0.44399 60 19.200000000000045 89   5.4432  
18971654111,81 Copenhagen Walking 18971654111 81 2025-04-29 15:49:32.000000 55.699930395931005 12.550871204584837 0.44636000000000003 60 19.0 89   5.3424000000000005  
18971654111,82 Copenhagen Walking 18971654111 82 2025-04-29 15:49:38.000000 55.69987398572266 12.550773387774825 0.45537 62 19.0 87   5.2416  
18971654111,83 Copenhagen Walking 18971654111 83 2025-04-29 15:49:44.000000 55.699808774515986 12.550696358084679 0.46373000000000003 60 18.399999999999977 85   5.3424000000000005  
18971654111,84 Copenhagen Walking 18971654111 84 2025-04-29 15:49:50.000000 55.69973115809262 12.55060750991106 0.47582 59 18.200000000000045 85   6.1128  
18971654111,85 Copenhagen Walking 18971654111 85 2025-04-29 15:49:51.000000 55.6997218541801 12.550588650628924 0.47737 59 18.0 85   6.1128  
18971654111,86 Copenhagen Walking 18971654111 86 2025-04-29 15:49:52.000000 55.69971305318177 12.550560822710395 0.47957 59 18.0 85   5.7456000000000005  
18971654111,87 Copenhagen Walking 18971654111 87 2025-04-29 15:49:58.000000 55.69968271069229 12.550423108041286 0.48879000000000006 59 17.799999999999955 84   6.3504000000000005  
18971654111,88 Copenhagen Walking 18971654111 88 2025-04-29 15:49:59.000000 55.699677765369415 12.550398549064994 0.49057 59 18.0 84   6.1488  
18971654111,89 Copenhagen Walking 18971654111 89 2025-04-29 15:50:05.000000 55.69962713867426 12.550281789153814 0.4993 59 18.200000000000045 84   5.846400000000001  
18971654111,90 Copenhagen Walking 18971654111 90 2025-04-29 15:50:06.000000 55.69962034933269 12.550260331481695 0.50117 59 18.200000000000045 84   5.8104000000000005  
18971654111,91 Copenhagen Walking 18971654111 91 2025-04-29 15:50:12.000000 55.69956033490598 12.550151953473687 0.51086 60 18.200000000000045 84   5.7456000000000005  
18971654111,92 Copenhagen Walking 18971654111 92 2025-04-29 15:50:13.000000 55.69955153390765 12.5501340162009 0.51229 60 18.0 83   5.7456000000000005  
18971654111,93 Copenhagen Walking 18971654111 93 2025-04-29 15:50:19.000000 55.699495961889625 12.550032176077366 0.52162 59 18.200000000000045 80   5.7096  
18971654111,94 Copenhagen Walking 18971654111 94 2025-04-29 15:50:20.000000 55.69948581978679 12.550018429756165 0.52278 59 18.200000000000045 80   5.7096  
18971654111,95 Copenhagen Walking 18971654111 95 2025-04-29 15:50:26.000000 55.69943561218679 12.549916002899408 0.53168 60 17.799999999999955 80   5.6088000000000005  
18971654111,96 Copenhagen Walking 18971654111 96 2025-04-29 15:50:31.000000 55.69939311593771 12.549839140847325 0.53861 61 18.200000000000045 83   5.5764  
18971654111,97 Copenhagen Walking 18971654111 97 2025-04-29 15:50:32.000000 55.699382554739714 12.549822963774204 0.54016 61 18.200000000000045 83   5.5440000000000005  
18971654111,98 Copenhagen Walking 18971654111 98 2025-04-29 15:50:37.000000 55.6993452552706 12.549726068973541 0.54767 61 18.0 86   5.508  
18971654111,99 Copenhagen Walking 18971654111 99 2025-04-29 15:50:38.000000 55.69933829829097 12.549705784767866 0.5489400000000001 61 18.0 89   5.508  

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 18.082ms