home / james_garmin_activities

activity_records

240 rows where activity_id = 18959687560

✎ 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
18959687560,0 Copenhagen Cycling 18959687560 0 2025-04-28 13:43:32.000000     0.0   21.799999999999955 74      
18959687560,1 Copenhagen Cycling 18959687560 1 2025-04-28 13:43:33.000000     0.0   21.799999999999955 74      
18959687560,2 Copenhagen Cycling 18959687560 2 2025-04-28 13:43:38.000000 55.70467287674546 12.556740213185549 0.0   21.799999999999955 75   2.7864  
18959687560,3 Copenhagen Cycling 18959687560 3 2025-04-28 13:43:39.000000 55.704698441550136 12.55676083266735 0.0   21.799999999999955 75   4.9716000000000005  
18959687560,4 Copenhagen Cycling 18959687560 4 2025-04-28 13:43:42.000000 55.70464504882693 12.556757060810924 0.005240000000000001   21.600000000000023 75   6.3144  
18959687560,5 Copenhagen Cycling 18959687560 5 2025-04-28 13:43:44.000000 55.70463792420924 12.556803496554494 0.00901   22.0 75   8.632800000000001  
18959687560,6 Copenhagen Cycling 18959687560 6 2025-04-28 13:43:46.000000 55.704636415466666 12.556905671954155 0.015210000000000001   22.0 76   11.4552  
18959687560,7 Copenhagen Cycling 18959687560 7 2025-04-28 13:43:47.000000 55.70463859476149 12.5569655187428 0.019010000000000003   22.0 81   12.3948  
18959687560,8 Copenhagen Cycling 18959687560 8 2025-04-28 13:43:48.000000 55.70461940020323 12.557011367753148 0.02227   21.600000000000023 85   12.898800000000001  
18959687560,9 Copenhagen Cycling 18959687560 9 2025-04-28 13:43:49.000000 55.70459601469338 12.557036932557821 0.02534   19.600000000000023 86   9.370800000000001  
18959687560,10 Copenhagen Cycling 18959687560 10 2025-04-28 13:43:50.000000 55.70456969551742 12.557044643908739 0.02815   18.0 88   9.036000000000001  
18959687560,11 Copenhagen Cycling 18959687560 11 2025-04-28 13:43:52.000000 55.70450808852911 12.557069538161159 0.03492   17.799999999999955 91   12.294  
18959687560,12 Copenhagen Cycling 18959687560 12 2025-04-28 13:43:55.000000 55.70438453927636 12.557098204270005 0.04895   17.799999999999955 94   15.685200000000002  
18959687560,13 Copenhagen Cycling 18959687560 13 2025-04-28 13:43:58.000000 55.70425780490041 12.557134414091706 0.06369000000000001   17.799999999999955 91   17.636400000000002  
18959687560,14 Copenhagen Cycling 18959687560 14 2025-04-28 13:44:01.000000 55.704126209020615 12.557178419083357 0.07848000000000001   17.799999999999955 95   16.1568  
18959687560,15 Copenhagen Cycling 18959687560 15 2025-04-28 13:44:02.000000 55.704086143523455 12.557193338871002 0.08311   17.799999999999955 95   15.3504  
18959687560,16 Copenhagen Cycling 18959687560 16 2025-04-28 13:44:08.000000 55.703871231526136 12.557269362732768 0.10773   18.200000000000045 94   13.572000000000001  
18959687560,17 Copenhagen Cycling 18959687560 17 2025-04-28 13:44:10.000000 55.703815910965204 12.557339770719409 0.11520000000000001   18.399999999999977 93   14.1768  
18959687560,18 Copenhagen Cycling 18959687560 18 2025-04-28 13:44:15.000000 55.70368674583733 12.55761050619185 0.13729   18.399999999999977 90   17.938800000000004  
18959687560,19 Copenhagen Cycling 18959687560 19 2025-04-28 13:44:16.000000 55.70365405641496 12.557669933885336 0.14244   18.399999999999977 89   18.5436  
18959687560,20 Copenhagen Cycling 18959687560 20 2025-04-28 13:44:21.000000 55.70344526320696 12.557894065976143 0.16945000000000002   18.399999999999977 91   18.979200000000002  
18959687560,21 Copenhagen Cycling 18959687560 21 2025-04-28 13:44:23.000000 55.70337602868676 12.558029517531395 0.1809   18.0 91   20.6244  
18959687560,22 Copenhagen Cycling 18959687560 22 2025-04-28 13:44:25.000000 55.70331140421331 12.558191120624542 0.19343000000000002   17.799999999999955 91   22.572000000000003  
18959687560,23 Copenhagen Cycling 18959687560 23 2025-04-28 13:44:30.000000 55.703141670674086 12.558620106428862 0.22624000000000002   17.0 92   24.7212  
18959687560,24 Copenhagen Cycling 18959687560 24 2025-04-28 13:44:33.000000 55.70303639397025 12.558887405321002 0.24695000000000003   16.600000000000023 91   24.7572  
18959687560,25 Copenhagen Cycling 18959687560 25 2025-04-28 13:44:39.000000 55.70283103734255 12.559388391673565 0.28585000000000005   16.600000000000023 88   22.438800000000004  
18959687560,26 Copenhagen Cycling 18959687560 26 2025-04-28 13:44:41.000000 55.70276725105941 12.559551671147346 0.29827   16.799999999999955 85   21.1968  
18959687560,27 Copenhagen Cycling 18959687560 27 2025-04-28 13:44:42.000000 55.70273615419865 12.559632891789079 0.30447   16.799999999999955 76   20.422800000000002  
18959687560,28 Copenhagen Cycling 18959687560 28 2025-04-28 13:44:43.000000 55.702703800052404 12.559716124087572 0.31115000000000004   16.799999999999955 70   19.7496  
18959687560,29 Copenhagen Cycling 18959687560 29 2025-04-28 13:44:48.000000 55.702580250799656 12.560080820694566 0.33769   16.600000000000023 68   20.120400000000004  
18959687560,30 Copenhagen Cycling 18959687560 30 2025-04-28 13:44:53.000000 55.7025090046227 12.560499496757984 0.36522000000000004   16.399999999999977 65   19.515600000000003  
18959687560,31 Copenhagen Cycling 18959687560 31 2025-04-28 13:44:55.000000 55.70248964242637 12.560664787888527 0.37576   16.600000000000023 66   19.346400000000003  
18959687560,32 Copenhagen Cycling 18959687560 32 2025-04-28 13:45:01.000000 55.70245259441435 12.56117608398199 0.40824   16.799999999999955 68   19.1808  
18959687560,33 Copenhagen Cycling 18959687560 33 2025-04-28 13:45:03.000000 55.70244614034891 12.56133190356195 0.4181   17.0 69   17.265600000000003  
18959687560,34 Copenhagen Cycling 18959687560 34 2025-04-28 13:45:09.000000 55.702444799244404 12.56170867010951 0.44171000000000005   17.200000000000045 69   10.6128  
18959687560,35 Copenhagen Cycling 18959687560 35 2025-04-28 13:45:14.000000 55.70244546979666 12.561908746138215 0.45515000000000005   17.200000000000045 71   10.7136  
18959687560,36 Copenhagen Cycling 18959687560 36 2025-04-28 13:45:19.000000 55.702451756224036 12.562214182689786 0.47416   16.600000000000023 72   15.3504  
18959687560,37 Copenhagen Cycling 18959687560 37 2025-04-28 13:45:23.000000 55.702457623556256 12.562514841556549 0.49295   16.399999999999977 75   17.838  
18959687560,38 Copenhagen Cycling 18959687560 38 2025-04-28 13:45:26.000000 55.70247237570584 12.562747858464718 0.5078   16.200000000000045 74   16.560000000000002  
18959687560,39 Copenhagen Cycling 18959687560 39 2025-04-28 13:45:27.000000 55.70246793329716 12.562822373583913 0.5124400000000001   16.200000000000045 75   16.3908  
18959687560,40 Copenhagen Cycling 18959687560 40 2025-04-28 13:45:30.000000 55.702459048479795 12.563022198155522 0.5251100000000001   16.200000000000045 72   13.9068  
18959687560,41 Copenhagen Cycling 18959687560 41 2025-04-28 13:45:31.000000 55.702456953004 12.563082799315453 0.5288100000000001   16.200000000000045 72   13.636800000000001  
18959687560,42 Copenhagen Cycling 18959687560 42 2025-04-28 13:45:37.000000 55.70247405208647 12.563399551436305 0.54925   16.799999999999955 70   11.7216  
18959687560,43 Copenhagen Cycling 18959687560 43 2025-04-28 13:45:41.000000 55.70259106345475 12.563478257507086 0.56288   16.600000000000023 71   12.798  
18959687560,44 Copenhagen Cycling 18959687560 44 2025-04-28 13:45:44.000000 55.70270539261401 12.563449256122112 0.57599   16.399999999999977 71   16.1892  
18959687560,45 Copenhagen Cycling 18959687560 45 2025-04-28 13:45:45.000000 55.70274252444506 12.56345646455884 0.57987   16.200000000000045 71   15.584399999999999  
18959687560,46 Copenhagen Cycling 18959687560 46 2025-04-28 13:45:50.000000 55.702961795032024 12.563498625531793 0.60414   16.200000000000045 73   18.072000000000003  
18959687560,47 Copenhagen Cycling 18959687560 47 2025-04-28 13:45:52.000000 55.70305164903402 12.563539193943143 0.61449   16.399999999999977 72   16.8624  
18959687560,48 Copenhagen Cycling 18959687560 48 2025-04-28 13:45:55.000000 55.70317469537258 12.563607590273023 0.62912   16.399999999999977 69   16.729200000000002  
18959687560,49 Copenhagen Cycling 18959687560 49 2025-04-28 13:45:58.000000 55.703293131664395 12.563698701560497 0.6435   16.399999999999977 67   17.1324  
18959687560,50 Copenhagen Cycling 18959687560 50 2025-04-28 13:45:59.000000 55.70333135314286 12.563739772886038 0.6481   16.399999999999977 67   18.0396  
18959687560,51 Copenhagen Cycling 18959687560 51 2025-04-28 13:46:01.000000 55.70340779609978 12.563824513927102 0.65819   16.399999999999977 67   17.4348  
18959687560,52 Copenhagen Cycling 18959687560 52 2025-04-28 13:46:04.000000 55.703517347574234 12.563977064564824 0.67352   16.399999999999977 71   18.342  
18959687560,53 Copenhagen Cycling 18959687560 53 2025-04-28 13:46:06.000000 55.70359529927373 12.564090974628925 0.6849700000000001   16.399999999999977 74   19.08  
18959687560,54 Copenhagen Cycling 18959687560 54 2025-04-28 13:46:10.000000 55.703736785799265 12.564328517764807 0.70697   15.799999999999955 76   18.003600000000002  
18959687560,55 Copenhagen Cycling 18959687560 55 2025-04-28 13:46:13.000000 55.70383426733315 12.564482828602195 0.7215800000000001   15.799999999999955 79   17.298  
18959687560,56 Copenhagen Cycling 18959687560 56 2025-04-28 13:46:14.000000 55.70386259816587 12.564539406448603 0.72627   15.799999999999955 80   17.298  
18959687560,57 Copenhagen Cycling 18959687560 57 2025-04-28 13:46:20.000000 55.704049514606595 12.564864540472627 0.75522   15.799999999999955 78   17.298  
18959687560,58 Copenhagen Cycling 18959687560 58 2025-04-28 13:46:23.000000 55.704149678349495 12.565024718642235 0.7702300000000001   15.799999999999955 78   17.0964  
18959687560,59 Copenhagen Cycling 18959687560 59 2025-04-28 13:46:28.000000 55.704316729679704 12.565311044454575 0.79628   16.200000000000045 81   18.2052  
18959687560,60 Copenhagen Cycling 18959687560 60 2025-04-28 13:46:33.000000 55.704493671655655 12.565596280619502 0.82276   16.0 82   18.7776  
18959687560,61 Copenhagen Cycling 18959687560 61 2025-04-28 13:46:38.000000 55.704658292233944 12.565896101295948 0.84902   16.0 79   13.3344  
18959687560,62 Copenhagen Cycling 18959687560 62 2025-04-28 13:46:39.000000 55.70468318648636 12.565927030518651 0.85228   16.0 78   10.882800000000001  
18959687560,63 Copenhagen Cycling 18959687560 63 2025-04-28 13:46:40.000000 55.70468972437084 12.5659797526896 0.85528   16.0 78   10.9152  
18959687560,64 Copenhagen Cycling 18959687560 64 2025-04-28 13:46:42.000000 55.70465016178787 12.566051334142685 0.86133   16.0 77   11.7216  
18959687560,65 Copenhagen Cycling 18959687560 65 2025-04-28 13:46:47.000000 55.7045310549438 12.566281082108617 0.88085   15.600000000000023 76   16.4268  
18959687560,66 Copenhagen Cycling 18959687560 66 2025-04-28 13:46:53.000000 55.70436039939523 12.566604288294911 0.90866   15.200000000000045 76   16.326  
18959687560,67 Copenhagen Cycling 18959687560 67 2025-04-28 13:46:55.000000 55.704301139339805 12.566715767607093 0.91798   15.200000000000045 74   16.358400000000003  
18959687560,68 Copenhagen Cycling 18959687560 68 2025-04-28 13:46:57.000000 55.70423969998956 12.566834622994065 0.92826   15.0 71   17.535600000000002  
18959687560,69 Copenhagen Cycling 18959687560 69 2025-04-28 13:47:01.000000 55.70412386208773 12.567065544426441 0.94765   15.200000000000045 68   16.9632  
18959687560,70 Copenhagen Cycling 18959687560 70 2025-04-28 13:47:03.000000 55.70406049489975 12.567185489460826 0.95789   15.0 68   18.273600000000002  
18959687560,71 Copenhagen Cycling 18959687560 71 2025-04-28 13:47:05.000000 55.70399109274149 12.567307027056813 0.9688000000000001   14.799999999999955 68   18.910800000000002  
18959687560,72 Copenhagen Cycling 18959687560 72 2025-04-28 13:47:09.000000 55.70385983213782 12.567544486373663 0.99006   14.799999999999955 71   18.0396  
18959687560,73 Copenhagen Cycling 18959687560 73 2025-04-28 13:47:10.000000 55.70382923819125 12.5675995554775 0.9945700000000001   14.799999999999955 72   17.870400000000004  
18959687560,74 Copenhagen Cycling 18959687560 74 2025-04-28 13:47:14.000000 55.70369604974985 12.567844558507204 1.01625   14.600000000000023 75   18.608400000000003  
18959687560,75 Copenhagen Cycling 18959687560 75 2025-04-28 13:47:17.000000 55.70359739474952 12.568027703091502 1.03209   14.600000000000023 77   19.144800000000004  
18959687560,76 Copenhagen Cycling 18959687560 76 2025-04-28 13:47:23.000000 55.70340326987207 12.568396423012018 1.0639200000000002   15.200000000000045 79   18.9468  
18959687560,77 Copenhagen Cycling 18959687560 77 2025-04-28 13:47:26.000000 55.703303860500455 12.568568168208003 1.07948   15.0 79   19.2456  
18959687560,78 Copenhagen Cycling 18959687560 78 2025-04-28 13:47:32.000000 55.703108897432685 12.56894962862134 1.1116400000000002   14.600000000000023 75   18.810000000000002  
18959687560,79 Copenhagen Cycling 18959687560 79 2025-04-28 13:47:34.000000 55.703044943511486 12.569069070741534 1.12174   14.600000000000023 72   18.5076  
18959687560,80 Copenhagen Cycling 18959687560 80 2025-04-28 13:47:35.000000 55.70301200263202 12.569129839539528 1.12704   14.600000000000023 72   18.172800000000002  
18959687560,81 Copenhagen Cycling 18959687560 81 2025-04-28 13:47:39.000000 55.70288225077093 12.569368304684758 1.14808   14.399999999999977 75   17.6688  
18959687560,82 Copenhagen Cycling 18959687560 82 2025-04-28 13:47:43.000000 55.70276138372719 12.569599812850356 1.1676700000000002   14.399999999999977 76   17.334000000000003  
18959687560,83 Copenhagen Cycling 18959687560 83 2025-04-28 13:47:49.000000 55.70256222970784 12.569957803934813 1.19946   14.600000000000023 75   18.6768  
18959687560,84 Copenhagen Cycling 18959687560 84 2025-04-28 13:47:53.000000 55.70243147201836 12.570199705660343 1.22053   14.399999999999977 75   18.4068  
18959687560,85 Copenhagen Cycling 18959687560 85 2025-04-28 13:47:59.000000 55.70224380120635 12.570551913231611 1.2512   13.799999999999955 75   17.3988  
18959687560,86 Copenhagen Cycling 18959687560 86 2025-04-28 13:48:01.000000 55.702187307178974 12.570664146915078 1.2606700000000002   14.0 78   17.3664  
18959687560,87 Copenhagen Cycling 18959687560 87 2025-04-28 13:48:06.000000 55.702036432921886 12.570942342281342 1.2846000000000002   13.799999999999955 80   17.3988  
18959687560,88 Copenhagen Cycling 18959687560 88 2025-04-28 13:48:12.000000 55.70185764692724 12.57127795368433 1.31414   14.0 81   17.2332  
18959687560,89 Copenhagen Cycling 18959687560 89 2025-04-28 13:48:17.000000 55.70170920342207 12.571553466841578 1.33792   14.200000000000045 84   17.7372  
18959687560,90 Copenhagen Cycling 18959687560 90 2025-04-28 13:48:21.000000 55.70159001275897 12.571772988885641 1.3569300000000002   14.200000000000045 83   17.2332  
18959687560,91 Copenhagen Cycling 18959687560 91 2025-04-28 13:48:27.000000 55.70140133611858 12.572114383801818 1.38704   14.0 82   17.535600000000002  
18959687560,92 Copenhagen Cycling 18959687560 92 2025-04-28 13:48:31.000000 55.701280888170004 12.572348155081272 1.40697   14.200000000000045 83   17.870400000000004  
18959687560,93 Copenhagen Cycling 18959687560 93 2025-04-28 13:48:37.000000 55.70110134780407 12.5726817548275 1.43605   14.0 84   18.342  
18959687560,94 Copenhagen Cycling 18959687560 94 2025-04-28 13:48:40.000000 55.70100990124047 12.572856517508626 1.45075   14.0 85   18.7092  
18959687560,95 Copenhagen Cycling 18959687560 95 2025-04-28 13:48:46.000000 55.7008165307343 12.573203863576055 1.48197   14.0 86   18.7452  
18959687560,96 Copenhagen Cycling 18959687560 96 2025-04-28 13:48:48.000000 55.70075408555567 12.573317103087902 1.4916200000000002   13.799999999999955 87   18.3744  
18959687560,97 Copenhagen Cycling 18959687560 97 2025-04-28 13:48:54.000000 55.70057068951428 12.573652379214764 1.52099   13.0 88   16.3908  
18959687560,98 Copenhagen Cycling 18959687560 98 2025-04-28 13:48:57.000000 55.70048754103482 12.573819430544972 1.5349400000000002   13.399999999999977 88   15.955200000000001  
18959687560,99 Copenhagen Cycling 18959687560 99 2025-04-28 13:49:03.000000 55.70031219162047 12.5741495937109 1.5636200000000002   14.200000000000045 87   17.1324  

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