activity_records
240 rows where activity_id = 18959687560
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );