activity_records
3,077 rows where activity_id = 18940329576
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18940329576,0 | Marrakech Walking 18940329576 | 0 | 2025-04-26 09:30:51.000000 | 0.0 | 0 | 467.79999999999995 | 93 | |||||
| 18940329576,1 | Marrakech Walking 18940329576 | 1 | 2025-04-26 09:30:52.000000 | 0.0 | 0 | 467.79999999999995 | 93 | 0.0 | ||||
| 18940329576,2 | Marrakech Walking 18940329576 | 2 | 2025-04-26 09:30:58.000000 | 0.0 | 0 | 468.0 | 92 | 0.0 | ||||
| 18940329576,3 | Marrakech Walking 18940329576 | 3 | 2025-04-26 09:31:04.000000 | 0.0 | 0 | 467.79999999999995 | 90 | 0.0 | ||||
| 18940329576,4 | Marrakech Walking 18940329576 | 4 | 2025-04-26 09:31:10.000000 | 0.0 | 0 | 467.79999999999995 | 88 | 0.0 | ||||
| 18940329576,5 | Marrakech Walking 18940329576 | 5 | 2025-04-26 09:31:14.000000 | 31.623293152078986 | -7.98769379965961 | 0.0 | 0 | 468.0 | 90 | 0.0 | ||
| 18940329576,6 | Marrakech Walking 18940329576 | 6 | 2025-04-26 09:31:20.000000 | 31.623251494020224 | -7.987692961469293 | 0.0024100000000000002 | 53 | 468.0 | 90 | 0.0 | ||
| 18940329576,7 | Marrakech Walking 18940329576 | 7 | 2025-04-26 09:31:26.000000 | 31.623354759067297 | -7.9877461027354 | 0.00744 | 50 | 468.20000000000005 | 91 | 0.0 | ||
| 18940329576,8 | Marrakech Walking 18940329576 | 8 | 2025-04-26 09:31:31.000000 | 31.623395076021552 | -7.987748198211193 | 0.011980000000000001 | 49 | 468.20000000000005 | 91 | 2.5524 | ||
| 18940329576,9 | Marrakech Walking 18940329576 | 9 | 2025-04-26 09:31:36.000000 | 31.6233978420496 | -7.987707043066621 | 0.016100000000000003 | 47 | 468.20000000000005 | 91 | 3.8628 | ||
| 18940329576,10 | Marrakech Walking 18940329576 | 10 | 2025-04-26 09:31:42.000000 | 31.623429358005524 | -7.987673347815871 | 0.019719999999999998 | 0 | 468.4 | 90 | 2.8224 | ||
| 18940329576,11 | Marrakech Walking 18940329576 | 11 | 2025-04-26 09:31:44.000000 | 31.62342768162489 | -7.987643927335739 | 0.02164 | 48 | 468.6 | 90 | 0.0 | ||
| 18940329576,12 | Marrakech Walking 18940329576 | 12 | 2025-04-26 09:31:50.000000 | 31.62344830110669 | -7.9875682387501 | 0.028210000000000002 | 49 | 468.6 | 89 | 2.2824 | ||
| 18940329576,13 | Marrakech Walking 18940329576 | 13 | 2025-04-26 09:31:52.000000 | 31.623463137075305 | -7.9875660594552755 | 0.030580000000000003 | 48 | 468.79999999999995 | 89 | 2.6856 | ||
| 18940329576,14 | Marrakech Walking 18940329576 | 14 | 2025-04-26 09:31:57.000000 | 31.623514350503683 | -7.987516187131405 | 0.03613 | 49 | 468.79999999999995 | 85 | 3.1248 | ||
| 18940329576,15 | Marrakech Walking 18940329576 | 15 | 2025-04-26 09:31:58.000000 | 31.62352105602622 | -7.987501518800855 | 0.03836 | 49 | 468.79999999999995 | 82 | 3.258 | ||
| 18940329576,16 | Marrakech Walking 18940329576 | 16 | 2025-04-26 09:32:02.000000 | 31.623562211170793 | -7.987470086663961 | 0.04593 | 50 | 468.79999999999995 | 79 | 5.274 | ||
| 18940329576,17 | Marrakech Walking 18940329576 | 17 | 2025-04-26 09:32:04.000000 | 31.623578555881977 | -7.987438319250941 | 0.04882 | 49 | 468.6 | 79 | 4.77 | ||
| 18940329576,18 | Marrakech Walking 18940329576 | 18 | 2025-04-26 09:32:09.000000 | 31.6236465331167 | -7.987451059743762 | 0.050210000000000005 | 47 | 468.4 | 79 | 4.8384 | ||
| 18940329576,19 | Marrakech Walking 18940329576 | 19 | 2025-04-26 09:32:15.000000 | 31.62368525750935 | -7.98739087767899 | 0.057300000000000004 | 0 | 468.6 | 79 | 6.012 | ||
| 18940329576,20 | Marrakech Walking 18940329576 | 20 | 2025-04-26 09:32:16.000000 | 31.623686598613858 | -7.987388530746102 | 0.05872 | 0 | 468.6 | 78 | 5.9796000000000005 | ||
| 18940329576,21 | Marrakech Walking 18940329576 | 21 | 2025-04-26 09:32:22.000000 | 31.623703530058265 | -7.9873578529804945 | 0.0639 | 0 | 468.6 | 79 | 5.5764 | ||
| 18940329576,22 | Marrakech Walking 18940329576 | 22 | 2025-04-26 09:32:24.000000 | 31.623702691867948 | -7.987349387258291 | 0.06494 | 0 | 468.79999999999995 | 79 | 5.4432 | ||
| 18940329576,23 | Marrakech Walking 18940329576 | 23 | 2025-04-26 09:32:30.000000 | 31.62369355559349 | -7.987327007576823 | 0.06714 | 0 | 468.79999999999995 | 80 | 4.3668000000000005 | ||
| 18940329576,24 | Marrakech Walking 18940329576 | 24 | 2025-04-26 09:32:33.000000 | 31.623694645240903 | -7.987333629280329 | 0.06836 | 0 | 468.79999999999995 | 79 | 0.0 | ||
| 18940329576,25 | Marrakech Walking 18940329576 | 25 | 2025-04-26 09:32:39.000000 | 31.623684084042907 | -7.987347207963467 | 0.06909 | 0 | 468.79999999999995 | 79 | 0.0 | ||
| 18940329576,26 | Marrakech Walking 18940329576 | 26 | 2025-04-26 09:32:40.000000 | 31.623688777908683 | -7.987340418621898 | 0.06927 | 0 | 468.79999999999995 | 79 | 0.0 | ||
| 18940329576,27 | Marrakech Walking 18940329576 | 27 | 2025-04-26 09:32:46.000000 | 31.623701015487313 | -7.987305046990514 | 0.07065 | 0 | 468.79999999999995 | 80 | 0.0 | ||
| 18940329576,28 | Marrakech Walking 18940329576 | 28 | 2025-04-26 09:32:47.000000 | 31.623699674382806 | -7.987299766391516 | 0.07101 | 0 | 468.79999999999995 | 80 | 0.0 | ||
| 18940329576,29 | Marrakech Walking 18940329576 | 29 | 2025-04-26 09:32:53.000000 | 31.62371643818915 | -7.9872459545731544 | 0.0747 | 50 | 469.0 | 80 | 0.0 | ||
| 18940329576,30 | Marrakech Walking 18940329576 | 30 | 2025-04-26 09:32:54.000000 | 31.623716270551085 | -7.9872465413063765 | 0.07477 | 50 | 469.20000000000005 | 79 | 0.0 | ||
| 18940329576,31 | Marrakech Walking 18940329576 | 31 | 2025-04-26 09:33:00.000000 | 31.623744014650583 | -7.987175965681672 | 0.08256000000000001 | 45 | 469.4 | 80 | 2.8224 | ||
| 18940329576,32 | Marrakech Walking 18940329576 | 32 | 2025-04-26 09:33:02.000000 | 31.623753486201167 | -7.987153502181172 | 0.0854 | 47 | 469.6 | 79 | 4.77 | ||
| 18940329576,33 | Marrakech Walking 18940329576 | 33 | 2025-04-26 09:33:08.000000 | 31.62374476902187 | -7.98707814887166 | 0.09074 | 0 | 470.0 | 79 | 7.7940000000000005 | ||
| 18940329576,34 | Marrakech Walking 18940329576 | 34 | 2025-04-26 09:33:09.000000 | 31.623744601383805 | -7.9870798252522945 | 0.09096000000000001 | 0 | 470.0 | 80 | 6.4152000000000005 | ||
| 18940329576,35 | Marrakech Walking 18940329576 | 35 | 2025-04-26 09:33:15.000000 | 31.623748037964106 | -7.987068509683013 | 0.09318000000000001 | 0 | 470.0 | 79 | 0.0 | ||
| 18940329576,36 | Marrakech Walking 18940329576 | 36 | 2025-04-26 09:33:16.000000 | 31.623746193945408 | -7.987067420035601 | 0.09318000000000001 | 0 | 470.0 | 79 | 0.0 | ||
| 18940329576,37 | Marrakech Walking 18940329576 | 37 | 2025-04-26 09:33:22.000000 | 31.62373848259449 | -7.987078400328755 | 0.0942 | 0 | 470.0 | 80 | 0.0 | ||
| 18940329576,38 | Marrakech Walking 18940329576 | 38 | 2025-04-26 09:33:24.000000 | 31.623733956366777 | -7.987085608765483 | 0.09460000000000002 | 0 | 470.0 | 79 | 0.0 | ||
| 18940329576,39 | Marrakech Walking 18940329576 | 39 | 2025-04-26 09:33:26.000000 | 31.623729011043906 | -7.987084100022912 | 0.09460000000000002 | 0 | 470.20000000000005 | 76 | 0.0 | ||
| 18940329576,40 | Marrakech Walking 18940329576 | 40 | 2025-04-26 09:33:30.000000 | 31.623734207823873 | -7.98709424212575 | 0.09505 | 0 | 470.20000000000005 | 73 | 0.0 | ||
| 18940329576,41 | Marrakech Walking 18940329576 | 41 | 2025-04-26 09:33:31.000000 | 31.623736722394824 | -7.987095667049289 | 0.09566 | 0 | 470.20000000000005 | 73 | 0.0 | ||
| 18940329576,42 | Marrakech Walking 18940329576 | 42 | 2025-04-26 09:33:37.000000 | 31.62373169325292 | -7.987092230468988 | 0.09656 | 0 | 470.0 | 72 | 0.0 | ||
| 18940329576,43 | Marrakech Walking 18940329576 | 43 | 2025-04-26 09:33:39.000000 | 31.62372817285359 | -7.987087536603212 | 0.09737000000000001 | 0 | 470.0 | 72 | 0.0 | ||
| 18940329576,44 | Marrakech Walking 18940329576 | 44 | 2025-04-26 09:33:45.000000 | 31.623715348541737 | -7.987062642350793 | 0.09976 | 0 | 470.0 | 72 | 0.0 | ||
| 18940329576,45 | Marrakech Walking 18940329576 | 45 | 2025-04-26 09:33:49.000000 | 31.623707385733724 | -7.987040178850293 | 0.10144 | 0 | 470.20000000000005 | 74 | 0.0 | ||
| 18940329576,46 | Marrakech Walking 18940329576 | 46 | 2025-04-26 09:33:51.000000 | 31.623700764030218 | -7.987038586288691 | 0.10261 | 44 | 470.20000000000005 | 77 | 0.0 | ||
| 18940329576,47 | Marrakech Walking 18940329576 | 47 | 2025-04-26 09:33:55.000000 | 31.623693220317364 | -7.987030707299709 | 0.10355 | 0 | 470.20000000000005 | 80 | 0.0 | ||
| 18940329576,48 | Marrakech Walking 18940329576 | 48 | 2025-04-26 09:33:57.000000 | 31.623682407662272 | -7.9870212357491255 | 0.10406 | 44 | 470.20000000000005 | 80 | 0.0 | ||
| 18940329576,49 | Marrakech Walking 18940329576 | 49 | 2025-04-26 09:34:03.000000 | 31.623623315244913 | -7.9870097525417805 | 0.10897 | 46 | 470.4 | 80 | 1.1412 | ||
| 18940329576,50 | Marrakech Walking 18940329576 | 50 | 2025-04-26 09:34:04.000000 | 31.6236153524369 | -7.987007573246956 | 0.10941 | 46 | 470.4 | 80 | 1.278 | ||
| 18940329576,51 | Marrakech Walking 18940329576 | 51 | 2025-04-26 09:34:10.000000 | 31.623557517305017 | -7.987001622095704 | 0.11398000000000001 | 44 | 470.4 | 78 | 2.754 | ||
| 18940329576,52 | Marrakech Walking 18940329576 | 52 | 2025-04-26 09:34:12.000000 | 31.623540334403515 | -7.986997766420245 | 0.11588 | 0 | 470.4 | 77 | 2.9556000000000004 | ||
| 18940329576,53 | Marrakech Walking 18940329576 | 53 | 2025-04-26 09:34:18.000000 | 31.623491132631898 | -7.986971195787191 | 0.1254 | 79 | 470.4 | 75 | 2.7216 | ||
| 18940329576,54 | Marrakech Walking 18940329576 | 54 | 2025-04-26 09:34:21.000000 | 31.623471518978477 | -7.98696625046432 | 0.12809 | 44 | 470.6 | 74 | 4.5684000000000005 | ||
| 18940329576,55 | Marrakech Walking 18940329576 | 55 | 2025-04-26 09:34:27.000000 | 31.623426843434572 | -7.986940182745457 | 0.13192 | 43 | 470.6 | 74 | 3.3912000000000004 | ||
| 18940329576,56 | Marrakech Walking 18940329576 | 56 | 2025-04-26 09:34:33.000000 | 31.623366409912705 | -7.986917719244957 | 0.13951 | 42 | 470.6 | 74 | 3.8304000000000005 | ||
| 18940329576,57 | Marrakech Walking 18940329576 | 57 | 2025-04-26 09:34:36.000000 | 31.623342521488667 | -7.986905900761485 | 0.14233 | 41 | 470.6 | 75 | 3.9960000000000004 | ||
| 18940329576,58 | Marrakech Walking 18940329576 | 58 | 2025-04-26 09:34:42.000000 | 31.62331578321755 | -7.986831134185195 | 0.14681 | 0 | 470.6 | 75 | 4.266 | ||
| 18940329576,59 | Marrakech Walking 18940329576 | 59 | 2025-04-26 09:34:45.000000 | 31.623338581994176 | -7.9868080001324415 | 0.14681 | 0 | 470.79999999999995 | 75 | 0.0 | ||
| 18940329576,60 | Marrakech Walking 18940329576 | 60 | 2025-04-26 09:34:51.000000 | 31.623324835672975 | -7.986784698441625 | 0.14969 | 47 | 470.79999999999995 | 76 | 0.0 | ||
| 18940329576,61 | Marrakech Walking 18940329576 | 61 | 2025-04-26 09:34:55.000000 | 31.623317962512374 | -7.986773299053311 | 0.15323 | 47 | 471.0 | 76 | 2.9232000000000005 | ||
| 18940329576,62 | Marrakech Walking 18940329576 | 62 | 2025-04-26 09:34:57.000000 | 31.623300947248936 | -7.986771957948804 | 0.15574000000000002 | 48 | 471.0 | 77 | 3.3912000000000004 | ||
| 18940329576,63 | Marrakech Walking 18940329576 | 63 | 2025-04-26 09:35:03.000000 | 31.623236993327737 | -7.986746979877353 | 0.16371000000000002 | 50 | 471.20000000000005 | 76 | 4.2336 | ||
| 18940329576,64 | Marrakech Walking 18940329576 | 64 | 2025-04-26 09:35:08.000000 | 31.623178822919726 | -7.986728539690375 | 0.16923 | 46 | 471.20000000000005 | 72 | 4.3668000000000005 | ||
| 18940329576,65 | Marrakech Walking 18940329576 | 65 | 2025-04-26 09:35:11.000000 | 31.623136159032583 | -7.986726947128773 | 0.17375000000000002 | 45 | 471.20000000000005 | 70 | 4.9392000000000005 | ||
| 18940329576,66 | Marrakech Walking 18940329576 | 66 | 2025-04-26 09:35:17.000000 | 31.623080587014556 | -7.9867494106292725 | 0.17628 | 45 | 471.4 | 69 | 4.6008000000000004 | ||
| 18940329576,67 | Marrakech Walking 18940329576 | 67 | 2025-04-26 09:35:18.000000 | 31.62308854982257 | -7.986746560782194 | 0.17628 | 45 | 471.4 | 70 | 4.3992 | ||
| 18940329576,68 | Marrakech Walking 18940329576 | 68 | 2025-04-26 09:35:24.000000 | 31.623066840693355 | -7.986757205799222 | 0.17849 | 0 | 471.4 | 72 | 0.9756000000000001 | ||
| 18940329576,69 | Marrakech Walking 18940329576 | 69 | 2025-04-26 09:35:26.000000 | 31.623056447133422 | -7.986759636551142 | 0.17909 | 0 | 471.4 | 75 | 4.3668000000000005 | ||
| 18940329576,70 | Marrakech Walking 18940329576 | 70 | 2025-04-26 09:35:29.000000 | 31.623040353879333 | -7.98675712198019 | 0.18130000000000002 | 0 | 471.20000000000005 | 78 | 1.1088 | ||
| 18940329576,71 | Marrakech Walking 18940329576 | 71 | 2025-04-26 09:35:34.000000 | 31.622976483777165 | -7.986792828887701 | 0.18645000000000003 | 44 | 471.0 | 79 | 3.5604 | ||
| 18940329576,72 | Marrakech Walking 18940329576 | 72 | 2025-04-26 09:35:40.000000 | 31.622917894273996 | -7.9867729637771845 | 0.19311 | 57 | 471.4 | 81 | 4.0644 | ||
| 18940329576,73 | Marrakech Walking 18940329576 | 73 | 2025-04-26 09:35:42.000000 | 31.622904147952795 | -7.986762151122093 | 0.19429 | 58 | 471.4 | 81 | 4.3344 | ||
| 18940329576,74 | Marrakech Walking 18940329576 | 74 | 2025-04-26 09:35:48.000000 | 31.62287556566298 | -7.98673122189939 | 0.19885 | 0 | 471.4 | 80 | 4.5 | ||
| 18940329576,75 | Marrakech Walking 18940329576 | 75 | 2025-04-26 09:35:49.000000 | 31.622865926474333 | -7.986720995977521 | 0.20058 | 0 | 471.4 | 80 | 4.5 | ||
| 18940329576,76 | Marrakech Walking 18940329576 | 76 | 2025-04-26 09:35:55.000000 | 31.62280566059053 | -7.986682690680027 | 0.20863 | 45 | 471.4 | 79 | 4.6368 | ||
| 18940329576,77 | Marrakech Walking 18940329576 | 77 | 2025-04-26 09:36:01.000000 | 31.62277389317751 | -7.986647319048643 | 0.21333000000000002 | 46 | 471.6 | 79 | 4.3668000000000005 | ||
| 18940329576,78 | Marrakech Walking 18940329576 | 78 | 2025-04-26 09:36:04.000000 | 31.62274749018252 | -7.98663935624063 | 0.21536000000000002 | 45 | 471.6 | 80 | 4.2336 | ||
| 18940329576,79 | Marrakech Walking 18940329576 | 79 | 2025-04-26 09:36:10.000000 | 31.62269183434546 | -7.986592752858996 | 0.22467 | 48 | 471.79999999999995 | 80 | 4.467600000000001 | ||
| 18940329576,80 | Marrakech Walking 18940329576 | 80 | 2025-04-26 09:36:11.000000 | 31.62268890067935 | -7.986591411754489 | 0.22554 | 48 | 471.79999999999995 | 80 | 4.467600000000001 | ||
| 18940329576,81 | Marrakech Walking 18940329576 | 81 | 2025-04-26 09:36:16.000000 | 31.622679764404893 | -7.986576072871685 | 0.22846000000000002 | 0 | 471.79999999999995 | 79 | 0.0 | ||
| 18940329576,82 | Marrakech Walking 18940329576 | 82 | 2025-04-26 09:36:22.000000 | 31.6226604860276 | -7.986541455611587 | 0.23091 | 0 | 471.79999999999995 | 78 | 0.0 | ||
| 18940329576,83 | Marrakech Walking 18940329576 | 83 | 2025-04-26 09:36:24.000000 | 31.622647158801556 | -7.98652108758688 | 0.23301 | 40 | 472.0 | 79 | 0.0 | ||
| 18940329576,84 | Marrakech Walking 18940329576 | 84 | 2025-04-26 09:36:30.000000 | 31.6225999686867 | -7.986495019868016 | 0.23907 | 78 | 472.0 | 79 | 5.846400000000001 | ||
| 18940329576,85 | Marrakech Walking 18940329576 | 85 | 2025-04-26 09:36:31.000000 | 31.62258731201291 | -7.986492505297065 | 0.24024 | 78 | 472.0 | 79 | 5.846400000000001 | ||
| 18940329576,86 | Marrakech Walking 18940329576 | 86 | 2025-04-26 09:36:37.000000 | 31.62253836169839 | -7.986495941877365 | 0.24623000000000003 | 0 | 472.0 | 80 | 4.5 | ||
| 18940329576,87 | Marrakech Walking 18940329576 | 87 | 2025-04-26 09:36:38.000000 | 31.62253199145198 | -7.986497199162841 | 0.24697 | 0 | 472.0 | 80 | 4.096800000000001 | ||
| 18940329576,88 | Marrakech Walking 18940329576 | 88 | 2025-04-26 09:36:41.000000 | 31.622515060007572 | -7.986493511125445 | 0.24849000000000002 | 0 | 472.0 | 80 | 3.6288 | ||
| 18940329576,89 | Marrakech Walking 18940329576 | 89 | 2025-04-26 09:36:47.000000 | 31.62247776053846 | -7.986484291031957 | 0.2526 | 43 | 472.0 | 80 | 4.0644 | ||
| 18940329576,90 | Marrakech Walking 18940329576 | 90 | 2025-04-26 09:36:53.000000 | 31.62244121544063 | -7.986459396779537 | 0.25635 | 40 | 472.0 | 80 | 3.5928 | ||
| 18940329576,91 | Marrakech Walking 18940329576 | 91 | 2025-04-26 09:36:54.000000 | 31.622434426099062 | -7.9864563792943954 | 0.25735 | 40 | 472.0 | 80 | 3.3912000000000004 | ||
| 18940329576,92 | Marrakech Walking 18940329576 | 92 | 2025-04-26 09:37:00.000000 | 31.62240299396217 | -7.98644196242094 | 0.25998000000000004 | 0 | 472.0 | 78 | 0.0 | ||
| 18940329576,93 | Marrakech Walking 18940329576 | 93 | 2025-04-26 09:37:01.000000 | 31.622397964820266 | -7.986440034583211 | 0.26032 | 0 | 472.20000000000005 | 79 | 0.0 | ||
| 18940329576,94 | Marrakech Walking 18940329576 | 94 | 2025-04-26 09:37:07.000000 | 31.622354965656996 | -7.9864233545959 | 0.26745 | 0 | 472.20000000000005 | 79 | 5.475600000000001 | ||
| 18940329576,95 | Marrakech Walking 18940329576 | 95 | 2025-04-26 09:37:08.000000 | 31.62235563620925 | -7.98642142675817 | 0.26774000000000003 | 0 | 472.20000000000005 | 79 | 5.475600000000001 | ||
| 18940329576,96 | Marrakech Walking 18940329576 | 96 | 2025-04-26 09:37:14.000000 | 31.622326467186213 | -7.98642092384398 | 0.27073 | 40 | 472.20000000000005 | 79 | 2.6208 | ||
| 18940329576,97 | Marrakech Walking 18940329576 | 97 | 2025-04-26 09:37:16.000000 | 31.62233074195683 | -7.986418744549155 | 0.27074000000000004 | 40 | 472.20000000000005 | 78 | 2.8872000000000004 | ||
| 18940329576,98 | Marrakech Walking 18940329576 | 98 | 2025-04-26 09:37:22.000000 | 31.622294699773192 | -7.9864054173231125 | 0.2732 | 0 | 472.20000000000005 | 78 | 0.0 | ||
| 18940329576,99 | Marrakech Walking 18940329576 | 99 | 2025-04-26 09:37:23.000000 | 31.6222873236984 | -7.986399885267019 | 0.27427 | 0 | 472.20000000000005 | 78 | 0.0 |
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) );