activity_records

918 rows where activity_id = 19020449796

✎ 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
19020449796,0 Copenhagen Walking 19020449796 0 2025-05-04 10:50:11.000000 55.7047625631094 12.556770220398903 0.0 0 23.600000000000023 99   0.0  
19020449796,1 Copenhagen Walking 19020449796 1 2025-05-04 10:50:12.000000 55.70474957115948 12.556788325309753 0.0008900000000000001 0 23.600000000000023 99   4.4352  
19020449796,2 Copenhagen Walking 19020449796 2 2025-05-04 10:50:18.000000 55.70476474240422 12.55671925842762 0.0035700000000000003 0 22.0 100   3.9636  
19020449796,3 Copenhagen Walking 19020449796 3 2025-05-04 10:50:21.000000 55.704774716869 12.55669285543263 0.0037600000000000003 0 20.799999999999955 99   0.0  
19020449796,4 Copenhagen Walking 19020449796 4 2025-05-04 10:50:22.000000 55.70477924309671 12.556691346690059 0.00393 0 20.600000000000023 99   0.0  
19020449796,5 Copenhagen Walking 19020449796 5 2025-05-04 10:50:24.000000 55.70478033274412 12.556690005585551 0.00491 0 19.799999999999955 99   0.0  
19020449796,6 Copenhagen Walking 19020449796 6 2025-05-04 10:50:27.000000 55.704764155671 12.556710708886385 0.00521 52 18.799999999999955 98   0.0  
19020449796,7 Copenhagen Walking 19020449796 7 2025-05-04 10:50:30.000000 55.70474521256983 12.556719593703747 0.008660000000000001 47 18.399999999999977 97   0.0  
19020449796,8 Copenhagen Walking 19020449796 8 2025-05-04 10:50:33.000000 55.7047364115715 12.556642396375537 0.010450000000000001 0 18.0 101   4.7016  
19020449796,9 Copenhagen Walking 19020449796 9 2025-05-04 10:50:34.000000 55.70473398081958 12.556631416082382 0.0106 68 17.799999999999955 101   4.032000000000001  
19020449796,10 Copenhagen Walking 19020449796 10 2025-05-04 10:50:35.000000 55.70473004132509 12.556629069149494 0.01088 68 17.799999999999955 102   3.5928  
19020449796,11 Copenhagen Walking 19020449796 11 2025-05-04 10:50:39.000000 55.70469995029271 12.556640384718776 0.013620000000000002 0 17.799999999999955 105   2.4840000000000004  
19020449796,12 Copenhagen Walking 19020449796 12 2025-05-04 10:50:40.000000 55.7046864554286 12.556661674752831 0.01497 0 17.799999999999955 105   2.4840000000000004  
19020449796,13 Copenhagen Walking 19020449796 13 2025-05-04 10:50:44.000000 55.704661225900054 12.556670056656003 0.019190000000000002 73 17.799999999999955 106   4.8384  
19020449796,14 Copenhagen Walking 19020449796 14 2025-05-04 10:50:49.000000 55.704630548134446 12.55672655068338 0.0239 0 18.0 106   3.762  
19020449796,15 Copenhagen Walking 19020449796 15 2025-05-04 10:50:55.000000 55.70452309213579 12.556974906474352 0.0436 86 18.200000000000045 106   10.6128  
19020449796,16 Copenhagen Walking 19020449796 16 2025-05-04 10:51:01.000000 55.70438797585666 12.55711111240089 0.056670000000000005 86 18.200000000000045 106   8.564400000000001  
19020449796,17 Copenhagen Walking 19020449796 17 2025-05-04 10:51:07.000000 55.70421991869807 12.557213874533772 0.07955 88 18.200000000000045 106   11.9916  
19020449796,18 Copenhagen Walking 19020449796 18 2025-05-04 10:51:08.000000 55.704179015010595 12.557243378832936 0.08481000000000001 87 18.0 106   13.8384  
19020449796,19 Copenhagen Walking 19020449796 19 2025-05-04 10:51:12.000000 55.70406845770776 12.557357624173164 0.09933 86 18.0 108   13.6728  
19020449796,20 Copenhagen Walking 19020449796 20 2025-05-04 10:51:17.000000 55.70391674526036 12.557452088221908 0.11733 87 17.799999999999955 110   13.132800000000001  
19020449796,21 Copenhagen Walking 19020449796 21 2025-05-04 10:51:23.000000 55.70374583825469 12.557580498978496 0.13781000000000002 89 17.399999999999977 112   12.3948  
19020449796,22 Copenhagen Walking 19020449796 22 2025-05-04 10:51:24.000000 55.70371666923165 12.557602040469646 0.14152 89 17.399999999999977 113   12.3948  
19020449796,23 Copenhagen Walking 19020449796 23 2025-05-04 10:51:28.000000 55.703588090837 12.557684350758791 0.15718000000000001 87 17.600000000000023 113   13.6728  
19020449796,24 Copenhagen Walking 19020449796 24 2025-05-04 10:51:32.000000 55.70345993153751 12.557813348248601 0.17355 88 17.399999999999977 114   14.277600000000001  
19020449796,25 Copenhagen Walking 19020449796 25 2025-05-04 10:51:36.000000 55.70335297845304 12.558011999353766 0.19084 88 17.399999999999977 116   14.4792  
19020449796,26 Copenhagen Walking 19020449796 26 2025-05-04 10:51:40.000000 55.70325340144336 12.558274772018194 0.21065 92 17.0 115   15.552000000000001  
19020449796,27 Copenhagen Walking 19020449796 27 2025-05-04 10:51:44.000000 55.70314234122634 12.55854089744389 0.23148000000000002 94 17.0 115   16.8624  
19020449796,28 Copenhagen Walking 19020449796 28 2025-05-04 10:51:45.000000 55.703110322356224 12.558588171377778 0.23634 95 17.200000000000045 115   16.83  
19020449796,29 Copenhagen Walking 19020449796 29 2025-05-04 10:51:47.000000 55.70305483415723 12.558693615719676 0.24554 96 17.200000000000045 116   16.4268  
19020449796,30 Copenhagen Walking 19020449796 30 2025-05-04 10:51:49.000000 55.70301007479429 12.558799730613828 0.25392000000000003 95 17.0 117   15.318  
19020449796,31 Copenhagen Walking 19020449796 31 2025-05-04 10:51:54.000000 55.702921729534864 12.559032328426838 0.27154 87 16.799999999999955 119   13.6044  
19020449796,32 Copenhagen Walking 19020449796 32 2025-05-04 10:51:59.000000 55.70284511893988 12.559243300929666 0.28709 85 16.799999999999955 119   12.765600000000001  
19020449796,33 Copenhagen Walking 19020449796 33 2025-05-04 10:52:03.000000 55.702812345698476 12.55935788154602 0.29493 84 17.0 120   8.298  
19020449796,34 Copenhagen Walking 19020449796 34 2025-05-04 10:52:08.000000 55.70275627076626 12.55948687903583 0.3055 77 17.0 120   7.7256  
19020449796,35 Copenhagen Walking 19020449796 35 2025-05-04 10:52:14.000000 55.70269634015858 12.559663066640496 0.31829 75 17.200000000000045 120   7.758000000000001  
19020449796,36 Copenhagen Walking 19020449796 36 2025-05-04 10:52:16.000000 55.7026644051075 12.559715118259192 0.32306 74 17.200000000000045 120   7.758000000000001  
19020449796,37 Copenhagen Walking 19020449796 37 2025-05-04 10:52:19.000000 55.702612940222025 12.559765493497252 0.32946 74 17.200000000000045 119   7.8264  
19020449796,38 Copenhagen Walking 19020449796 38 2025-05-04 10:52:24.000000 55.70253440178931 12.559867417439818 0.34084000000000003 75 17.0 120   7.9596  
19020449796,39 Copenhagen Walking 19020449796 39 2025-05-04 10:52:29.000000 55.70242929272354 12.559965569525957 0.35358 76 17.0 120   7.9956000000000005  
19020449796,40 Copenhagen Walking 19020449796 40 2025-05-04 10:52:35.000000 55.702273389324546 12.560074618086219 0.37253000000000003 84 16.399999999999977 121   11.016  
19020449796,41 Copenhagen Walking 19020449796 41 2025-05-04 10:52:41.000000 55.702158473432064 12.560128848999739 0.38532 80 16.600000000000023 121   8.028  
19020449796,42 Copenhagen Walking 19020449796 42 2025-05-04 10:52:47.000000 55.702044647186995 12.560187606140971 0.39836000000000005 73 16.399999999999977 121   8.1972  
19020449796,43 Copenhagen Walking 19020449796 43 2025-05-04 10:52:48.000000 55.70202587172389 12.560194982215762 0.40054 73 16.399999999999977 122   8.028  
19020449796,44 Copenhagen Walking 19020449796 44 2025-05-04 10:52:54.000000 55.70192218758166 12.560247452929616 0.41282 72 16.200000000000045 121   7.9272  
19020449796,45 Copenhagen Walking 19020449796 45 2025-05-04 10:52:55.000000 55.70190726779401 12.560258517041802 0.41435000000000005 72 16.200000000000045 121   7.8588  
19020449796,46 Copenhagen Walking 19020449796 46 2025-05-04 10:53:01.000000 55.701809199526906 12.56031023338437 0.42659 72 16.399999999999977 120   7.7940000000000005  
19020449796,47 Copenhagen Walking 19020449796 47 2025-05-04 10:53:07.000000 55.701723704114556 12.560352310538292 0.43590000000000007 72 16.200000000000045 119   7.4232  
19020449796,48 Copenhagen Walking 19020449796 48 2025-05-04 10:53:08.000000 55.701702665537596 12.56035809405148 0.43804000000000004 72 16.200000000000045 119   7.322400000000001  
19020449796,49 Copenhagen Walking 19020449796 49 2025-05-04 10:53:14.000000 55.701591772958636 12.5603864248842 0.45109000000000005 72 16.0 118   7.354800000000001  
19020449796,50 Copenhagen Walking 19020449796 50 2025-05-04 10:53:19.000000 55.70150250568986 12.560407966375351 0.46107 70 16.200000000000045 115   7.2540000000000004  
19020449796,51 Copenhagen Walking 19020449796 51 2025-05-04 10:53:20.000000 55.70148699916899 12.560414420440793 0.46295 70 16.200000000000045 114   7.2540000000000004  
19020449796,52 Copenhagen Walking 19020449796 52 2025-05-04 10:53:25.000000 55.70140074938536 12.560417773202062 0.47254 72 16.200000000000045 114   7.1892000000000005  
19020449796,53 Copenhagen Walking 19020449796 53 2025-05-04 10:53:31.000000 55.70129823870957 12.56041768938303 0.48376 71 16.0 114   7.0884  
19020449796,54 Copenhagen Walking 19020449796 54 2025-05-04 10:53:33.000000 55.701262364163995 12.560418276116252 0.48756 71 16.0 114   7.02  
19020449796,55 Copenhagen Walking 19020449796 55 2025-05-04 10:53:39.000000 55.70114677771926 12.560432944446802 0.5005200000000001 72 15.799999999999955 117   7.0524000000000004  
19020449796,56 Copenhagen Walking 19020449796 56 2025-05-04 10:53:40.000000 55.70113160647452 12.560425568372011 0.5023500000000001 72 15.799999999999955 116   7.0524000000000004  
19020449796,57 Copenhagen Walking 19020449796 57 2025-05-04 10:53:46.000000 55.70102599449456 12.560412408784032 0.51414 72 16.0 116   7.0524000000000004  
19020449796,58 Copenhagen Walking 19020449796 58 2025-05-04 10:53:52.000000 55.70092365145683 12.560386341065168 0.52563 72 16.0 116   7.02  
19020449796,59 Copenhagen Walking 19020449796 59 2025-05-04 10:53:53.000000 55.70091032423079 12.560379886999726 0.52736 72 16.0 116   7.02  
19020449796,60 Copenhagen Walking 19020449796 60 2025-05-04 10:53:58.000000 55.70081736892462 12.560365973040462 0.53744 72 16.0 114   7.02  
19020449796,61 Copenhagen Walking 19020449796 61 2025-05-04 10:54:01.000000 55.70076531730592 12.560340156778693 0.54332 72 16.0 111   6.9876000000000005  
19020449796,62 Copenhagen Walking 19020449796 62 2025-05-04 10:54:04.000000 55.700722401961684 12.560315262526274 0.5482100000000001 72 16.0 110   6.9192  
19020449796,63 Copenhagen Walking 19020449796 63 2025-05-04 10:54:09.000000 55.700632464140654 12.560288021340966 0.5581900000000001 72 16.200000000000045 110   6.9192  
19020449796,64 Copenhagen Walking 19020449796 64 2025-05-04 10:54:15.000000 55.70050271227956 12.560290955007076 0.5720600000000001 72 16.200000000000045 110   6.9192  
19020449796,65 Copenhagen Walking 19020449796 65 2025-05-04 10:54:21.000000 55.70037874393165 12.560298833996058 0.5865 71 16.0 110   6.8868  
19020449796,66 Copenhagen Walking 19020449796 66 2025-05-04 10:54:27.000000 55.70027916692197 12.560260025784373 0.5993400000000001 74 16.0 110   6.8868  
19020449796,67 Copenhagen Walking 19020449796 67 2025-05-04 10:54:28.000000 55.70026240311563 12.560282908380032 0.60146 74 16.0 110   7.02  
19020449796,68 Copenhagen Walking 19020449796 68 2025-05-04 10:54:31.000000 55.700205489993095 12.560366056859493 0.6088100000000001 74 16.0 109   7.6248  
19020449796,69 Copenhagen Walking 19020449796 69 2025-05-04 10:54:35.000000 55.700095519423485 12.56054274737835 0.62494 88 16.0 110   14.544  
19020449796,70 Copenhagen Walking 19020449796 70 2025-05-04 10:54:37.000000 55.700031565502286 12.560607036575675 0.63353 88 15.799999999999955 109   14.544  
19020449796,71 Copenhagen Walking 19020449796 71 2025-05-04 10:54:40.000000 55.699924444779754 12.560659004375339 0.64587 87 15.399999999999977 110   12.999600000000001  
19020449796,72 Copenhagen Walking 19020449796 72 2025-05-04 10:54:45.000000 55.699744736775756 12.560671409592032 0.66547 89 15.399999999999977 111   13.435200000000002  
19020449796,73 Copenhagen Walking 19020449796 73 2025-05-04 10:54:50.000000 55.69956796243787 12.560681970790029 0.68551 89 15.200000000000045 112   14.443200000000003  
19020449796,74 Copenhagen Walking 19020449796 74 2025-05-04 10:54:55.000000 55.69943234324455 12.560715582221746 0.7011000000000001 85 16.600000000000023 113   12.1608  
19020449796,75 Copenhagen Walking 19020449796 75 2025-05-04 10:54:56.000000 55.69941122084856 12.56075045093894 0.7044400000000001 84 16.600000000000023 114   12.1608  
19020449796,76 Copenhagen Walking 19020449796 76 2025-05-04 10:54:57.000000 55.69940107874572 12.560774590820074 0.70635 84 16.799999999999955 114   12.1608  
19020449796,77 Copenhagen Walking 19020449796 77 2025-05-04 10:55:01.000000 55.69935732521117 12.560880538076162 0.71451 85 17.0 113   7.6932  
19020449796,78 Copenhagen Walking 19020449796 78 2025-05-04 10:55:07.000000 55.699312230572104 12.561048679053783 0.7265199999999999 75 17.0 113   6.8508000000000004  
19020449796,79 Copenhagen Walking 19020449796 79 2025-05-04 10:55:08.000000 55.699311308562756 12.561080027371645 0.72866 75 17.0 112   9.0684  
19020449796,80 Copenhagen Walking 19020449796 80 2025-05-04 10:55:14.000000 55.69929965771735 12.561263591051102 0.7403500000000001 71 17.200000000000045 112   8.866800000000001  
19020449796,81 Copenhagen Walking 19020449796 81 2025-05-04 10:55:20.000000 55.699249701574445 12.56142963655293 0.75182 72 17.200000000000045 112   7.9596  
19020449796,82 Copenhagen Walking 19020449796 82 2025-05-04 10:55:25.000000 55.69917233660817 12.561564836651087 0.76478 73 16.799999999999955 111   8.967600000000001  
19020449796,83 Copenhagen Walking 19020449796 83 2025-05-04 10:55:31.000000 55.69906982593238 12.56163390353322 0.77698 74 16.399999999999977 111   8.028  
19020449796,84 Copenhagen Walking 19020449796 84 2025-05-04 10:55:36.000000 55.698973601683974 12.561620827764273 0.7878400000000001 72 16.399999999999977 111   8.0604  
19020449796,85 Copenhagen Walking 19020449796 85 2025-05-04 10:55:42.000000 55.69885516539216 12.561604231595993 0.80104 73 16.399999999999977 111   8.028  
19020449796,86 Copenhagen Walking 19020449796 86 2025-05-04 10:55:48.000000 55.6987513974309 12.561581851914525 0.8129 73 16.600000000000023 112   7.8588  
19020449796,87 Copenhagen Walking 19020449796 87 2025-05-04 10:55:54.000000 55.698636062443256 12.561581013724208 0.82538 75 16.399999999999977 113   7.657200000000001  
19020449796,88 Copenhagen Walking 19020449796 88 2025-05-04 10:56:00.000000 55.69851737469435 12.561569614335895 0.83854 74 16.200000000000045 112   7.6248  
19020449796,89 Copenhagen Walking 19020449796 89 2025-05-04 10:56:06.000000 55.69840723648667 12.561568608507514 0.8506800000000001 72 15.799999999999955 114   7.556400000000001  
19020449796,90 Copenhagen Walking 19020449796 90 2025-05-04 10:56:08.000000 55.698373541235924 12.561560058966279 0.85474 72 15.799999999999955 115   7.4916  
19020449796,91 Copenhagen Walking 19020449796 91 2025-05-04 10:56:13.000000 55.698287123814225 12.561554191634059 0.86441 72 16.200000000000045 115   7.4232  
19020449796,92 Copenhagen Walking 19020449796 92 2025-05-04 10:56:19.000000 55.69817924872041 12.561544133350253 0.8769500000000001 72 16.200000000000045 116   7.322400000000001  
19020449796,93 Copenhagen Walking 19020449796 93 2025-05-04 10:56:20.000000 55.69816273637116 12.561538182199001 0.8788100000000001 72 16.200000000000045 115   7.322400000000001  
19020449796,94 Copenhagen Walking 19020449796 94 2025-05-04 10:56:26.000000 55.69806642830372 12.561506414785981 0.8899600000000001 71 16.200000000000045 115   7.153200000000001  
19020449796,95 Copenhagen Walking 19020449796 95 2025-05-04 10:56:27.000000 55.698054526001215 12.561500631272793 0.8912000000000001 71 16.200000000000045 115   7.153200000000001  
19020449796,96 Copenhagen Walking 19020449796 96 2025-05-04 10:56:33.000000 55.69795059040189 12.561479760333896 0.90236 71 16.399999999999977 115   6.9192  
19020449796,97 Copenhagen Walking 19020449796 97 2025-05-04 10:56:39.000000 55.69784673862159 12.561482694000006 0.9136700000000001 71 16.200000000000045 114   6.7860000000000005  
19020449796,98 Copenhagen Walking 19020449796 98 2025-05-04 10:56:40.000000 55.697829220443964 12.561480514705181 0.91549 71 16.200000000000045 114   6.7860000000000005  
19020449796,99 Copenhagen Walking 19020449796 99 2025-05-04 10:56:46.000000 55.69771598093212 12.561472048982978 0.9293600000000001 72 16.0 114   6.8868  

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)
);