activity_records
77 rows where activity_id = 18853587800
This data as json, CSV (advanced)
Suggested facets: altitude, hr, timestamp (date)
| Link | activity_id | record | timestamp | position_lat | position_long | distance | cadence | altitude | hr | rr | speed | temperature |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18853587800,0 | Copenhagen Cycling 18853587800 | 0 | 2025-04-17 13:59:43.000000 | 55.70728400722146 | 12.560860589146614 | 0.0 | 18.600000000000023 | 100 | 0.9072 | |||
| 18853587800,1 | Copenhagen Cycling 18853587800 | 1 | 2025-04-17 13:59:44.000000 | 55.70728291757405 | 12.560851871967316 | 0.0 | 18.600000000000023 | 100 | 1.4112 | |||
| 18853587800,2 | Copenhagen Cycling 18853587800 | 2 | 2025-04-17 13:59:49.000000 | 55.70724746212363 | 12.560869138687849 | 0.00246 | 18.600000000000023 | 100 | 4.6008000000000004 | |||
| 18853587800,3 | Copenhagen Cycling 18853587800 | 3 | 2025-04-17 13:59:52.000000 | 55.70718887262046 | 12.560921609401703 | 0.00982 | 18.799999999999955 | 101 | 4.3992 | |||
| 18853587800,4 | Copenhagen Cycling 18853587800 | 4 | 2025-04-17 13:59:54.000000 | 55.707149393856525 | 12.560967961326241 | 0.01409 | 18.200000000000045 | 101 | 2.7864 | |||
| 18853587800,5 | Copenhagen Cycling 18853587800 | 5 | 2025-04-17 13:59:55.000000 | 55.707136150449514 | 12.560971649363637 | 0.01411 | 17.799999999999955 | 100 | 4.5684000000000005 | |||
| 18853587800,6 | Copenhagen Cycling 18853587800 | 6 | 2025-04-17 13:59:56.000000 | 55.707122990861535 | 12.56095857359469 | 0.015870000000000002 | 17.600000000000023 | 100 | 6.6168000000000005 | |||
| 18853587800,7 | Copenhagen Cycling 18853587800 | 7 | 2025-04-17 13:59:59.000000 | 55.70709843188524 | 12.56090434268117 | 0.02007 | 17.600000000000023 | 100 | 6.516 | |||
| 18853587800,8 | Copenhagen Cycling 18853587800 | 8 | 2025-04-17 14:00:05.000000 | 55.70705811493099 | 12.56065808236599 | 0.03649 | 17.600000000000023 | 98 | 13.636800000000001 | |||
| 18853587800,9 | Copenhagen Cycling 18853587800 | 9 | 2025-04-17 14:00:10.000000 | 55.707015870139 | 12.560284836217761 | 0.06043 | 17.0 | 101 | 17.4996 | |||
| 18853587800,10 | Copenhagen Cycling 18853587800 | 10 | 2025-04-17 14:00:11.000000 | 55.707011092454195 | 12.560207387432456 | 0.06529 | 17.0 | 101 | 17.636400000000002 | |||
| 18853587800,11 | Copenhagen Cycling 18853587800 | 11 | 2025-04-17 14:00:16.000000 | 55.70696524344385 | 12.559833386912942 | 0.08933 | 16.600000000000023 | 103 | 17.802000000000003 | |||
| 18853587800,12 | Copenhagen Cycling 18853587800 | 12 | 2025-04-17 14:00:19.000000 | 55.706940768286586 | 12.55958503112197 | 0.10501 | 16.200000000000045 | 105 | 17.7372 | |||
| 18853587800,13 | Copenhagen Cycling 18853587800 | 13 | 2025-04-17 14:00:22.000000 | 55.706974379718304 | 12.559376740828156 | 0.11864000000000001 | 16.200000000000045 | 105 | 15.318 | |||
| 18853587800,14 | Copenhagen Cycling 18853587800 | 14 | 2025-04-17 14:00:23.000000 | 55.70700564421713 | 12.559328880161047 | 0.12347 | 16.200000000000045 | 105 | 15.6528 | |||
| 18853587800,15 | Copenhagen Cycling 18853587800 | 15 | 2025-04-17 14:00:24.000000 | 55.70703808218241 | 12.55929971113801 | 0.12747 | 16.200000000000045 | 105 | 16.729200000000002 | |||
| 18853587800,16 | Copenhagen Cycling 18853587800 | 16 | 2025-04-17 14:00:28.000000 | 55.707200858742 | 12.559193009510636 | 0.1465 | 17.0 | 108 | 18.979200000000002 | |||
| 18853587800,17 | Copenhagen Cycling 18853587800 | 17 | 2025-04-17 14:00:29.000000 | 55.70724586956203 | 12.559167444705963 | 0.15184999999999998 | 17.200000000000045 | 110 | 19.2132 | |||
| 18853587800,18 | Copenhagen Cycling 18853587800 | 18 | 2025-04-17 14:00:32.000000 | 55.70738844573498 | 12.55908027291298 | 0.16841 | 17.399999999999977 | 113 | 20.556 | |||
| 18853587800,19 | Copenhagen Cycling 18853587800 | 19 | 2025-04-17 14:00:37.000000 | 55.707641411572695 | 12.558955382555723 | 0.19727 | 17.0 | 113 | 21.261599999999998 | |||
| 18853587800,20 | Copenhagen Cycling 18853587800 | 20 | 2025-04-17 14:00:43.000000 | 55.707997139543295 | 12.558855973184109 | 0.23804 | 17.200000000000045 | 112 | 22.773600000000002 | |||
| 18853587800,21 | Copenhagen Cycling 18853587800 | 21 | 2025-04-17 14:00:45.000000 | 55.70811222307384 | 12.55881942808628 | 0.25125000000000003 | 17.200000000000045 | 111 | 23.479200000000002 | |||
| 18853587800,22 | Copenhagen Cycling 18853587800 | 22 | 2025-04-17 14:00:51.000000 | 55.70843266323209 | 12.558674504980445 | 0.28741000000000005 | 17.600000000000023 | 109 | 21.8664 | |||
| 18853587800,23 | Copenhagen Cycling 18853587800 | 23 | 2025-04-17 14:00:52.000000 | 55.70849024690688 | 12.558663357049227 | 0.29369 | 17.600000000000023 | 108 | 21.229200000000002 | |||
| 18853587800,24 | Copenhagen Cycling 18853587800 | 24 | 2025-04-17 14:00:54.000000 | 55.70860197767615 | 12.558658411726356 | 0.30622000000000005 | 17.799999999999955 | 104 | 18.7092 | |||
| 18853587800,25 | Copenhagen Cycling 18853587800 | 25 | 2025-04-17 14:00:56.000000 | 55.708695435896516 | 12.558650197461247 | 0.31714 | 17.799999999999955 | 101 | 12.6972 | |||
| 18853587800,26 | Copenhagen Cycling 18853587800 | 26 | 2025-04-17 14:00:58.000000 | 55.70877288468182 | 12.558639720082283 | 0.32549 | 18.0 | 98 | 11.79 | |||
| 18853587800,27 | Copenhagen Cycling 18853587800 | 27 | 2025-04-17 14:01:02.000000 | 55.70884865708649 | 12.558618849143386 | 0.33494999999999997 | 18.0 | 97 | 0.9072 | |||
| 18853587800,28 | Copenhagen Cycling 18853587800 | 28 | 2025-04-17 14:01:06.000000 | 55.708844466134906 | 12.55860686302185 | 0.33584 | 18.200000000000045 | 98 | 3.528 | |||
| 18853587800,29 | Copenhagen Cycling 18853587800 | 29 | 2025-04-17 14:01:11.000000 | 55.70885133929551 | 12.558598900213838 | 0.33708 | 17.799999999999955 | 98 | 0.0 | |||
| 18853587800,30 | Copenhagen Cycling 18853587800 | 30 | 2025-04-17 14:01:14.000000 | 55.708851255476475 | 12.55859948694706 | 0.33842 | 17.799999999999955 | 98 | 4.5684000000000005 | |||
| 18853587800,31 | Copenhagen Cycling 18853587800 | 31 | 2025-04-17 14:01:16.000000 | 55.70885821245611 | 12.558589093387127 | 0.33925 | 17.799999999999955 | 99 | 3.9960000000000004 | |||
| 18853587800,32 | Copenhagen Cycling 18853587800 | 32 | 2025-04-17 14:01:17.000000 | 55.70887003093958 | 12.558588422834873 | 0.34019 | 17.799999999999955 | 99 | 4.8384 | |||
| 18853587800,33 | Copenhagen Cycling 18853587800 | 33 | 2025-04-17 14:01:18.000000 | 55.70888947695494 | 12.558600073680282 | 0.34226 | 17.600000000000023 | 99 | 7.524 | |||
| 18853587800,34 | Copenhagen Cycling 18853587800 | 34 | 2025-04-17 14:01:21.000000 | 55.70895410142839 | 12.558688754215837 | 0.35104 | 17.600000000000023 | 100 | 12.294 | |||
| 18853587800,35 | Copenhagen Cycling 18853587800 | 35 | 2025-04-17 14:01:24.000000 | 55.70904730819166 | 12.558830408379436 | 0.36494 | 17.600000000000023 | 101 | 16.8624 | |||
| 18853587800,36 | Copenhagen Cycling 18853587800 | 36 | 2025-04-17 14:01:25.000000 | 55.7090815063566 | 12.55888681858778 | 0.37010000000000004 | 17.799999999999955 | 102 | 18.306 | |||
| 18853587800,37 | Copenhagen Cycling 18853587800 | 37 | 2025-04-17 14:01:31.000000 | 55.7092921435833 | 12.559243217110634 | 0.40282 | 18.0 | 103 | 18.306 | |||
| 18853587800,38 | Copenhagen Cycling 18853587800 | 38 | 2025-04-17 14:01:33.000000 | 55.709359450265765 | 12.55935880355537 | 0.41316 | 18.0 | 102 | 19.144800000000004 | |||
| 18853587800,39 | Copenhagen Cycling 18853587800 | 39 | 2025-04-17 14:01:35.000000 | 55.70942549966276 | 12.55946533754468 | 0.42286 | 17.799999999999955 | 99 | 18.442800000000002 | |||
| 18853587800,40 | Copenhagen Cycling 18853587800 | 40 | 2025-04-17 14:01:37.000000 | 55.709493309259415 | 12.559591233730316 | 0.43407 | 17.799999999999955 | 96 | 18.306 | |||
| 18853587800,41 | Copenhagen Cycling 18853587800 | 41 | 2025-04-17 14:01:40.000000 | 55.709572434425354 | 12.55979130975902 | 0.44973 | 18.0 | 95 | 17.334000000000003 | |||
| 18853587800,42 | Copenhagen Cycling 18853587800 | 42 | 2025-04-17 14:01:46.000000 | 55.709696067497134 | 12.560179308056831 | 0.47759 | 18.200000000000045 | 95 | 15.955200000000001 | |||
| 18853587800,43 | Copenhagen Cycling 18853587800 | 43 | 2025-04-17 14:01:48.000000 | 55.709732696413994 | 12.560308473184705 | 0.48672000000000004 | 18.200000000000045 | 95 | 15.685200000000002 | |||
| 18853587800,44 | Copenhagen Cycling 18853587800 | 44 | 2025-04-17 14:01:54.000000 | 55.70979891344905 | 12.560648024082184 | 0.50934 | 18.0 | 95 | 9.1692 | |||
| 18853587800,45 | Copenhagen Cycling 18853587800 | 45 | 2025-04-17 14:01:58.000000 | 55.709792878478765 | 12.560709966346622 | 0.51334 | 17.600000000000023 | 94 | 1.4796000000000002 | |||
| 18853587800,46 | Copenhagen Cycling 18853587800 | 46 | 2025-04-17 14:02:04.000000 | 55.709788436070085 | 12.560714492574334 | 0.51378 | 17.200000000000045 | 95 | 0.0 | |||
| 18853587800,47 | Copenhagen Cycling 18853587800 | 47 | 2025-04-17 14:02:06.000000 | 55.709788436070085 | 12.560714492574334 | 0.51378 | 17.200000000000045 | 96 | 0.0 | |||
| 18853587800,48 | Copenhagen Cycling 18853587800 | 48 | 2025-04-17 14:02:12.000000 | 55.709788436070085 | 12.560714492574334 | 0.51378 | 17.200000000000045 | 94 | 0.0 | |||
| 18853587800,49 | Copenhagen Cycling 18853587800 | 49 | 2025-04-17 14:02:18.000000 | 55.709788436070085 | 12.560714492574334 | 0.51378 | 17.399999999999977 | 92 | 0.0 | |||
| 18853587800,50 | Copenhagen Cycling 18853587800 | 50 | 2025-04-17 14:02:21.000000 | 55.709788436070085 | 12.560714492574334 | 0.51378 | 17.200000000000045 | 91 | 0.0 | |||
| 18853587800,51 | Copenhagen Cycling 18853587800 | 51 | 2025-04-17 14:02:27.000000 | 55.70978835225105 | 12.560714408755302 | 0.51378 | 17.0 | 93 | 0.0 | |||
| 18853587800,52 | Copenhagen Cycling 18853587800 | 52 | 2025-04-17 14:02:33.000000 | 55.709788519889116 | 12.560715163126588 | 0.51378 | 17.0 | 92 | 0.0 | |||
| 18853587800,53 | Copenhagen Cycling 18853587800 | 53 | 2025-04-17 14:02:34.000000 | 55.709788519889116 | 12.56071524694562 | 0.51378 | 17.200000000000045 | 92 | 0.0 | |||
| 18853587800,54 | Copenhagen Cycling 18853587800 | 54 | 2025-04-17 14:02:40.000000 | 55.709788519889116 | 12.560716336593032 | 0.51378 | 17.399999999999977 | 89 | 0.0 | |||
| 18853587800,55 | Copenhagen Cycling 18853587800 | 55 | 2025-04-17 14:02:43.000000 | 55.709793800488114 | 12.56077241152525 | 0.51746 | 17.399999999999977 | 85 | 7.221600000000001 | |||
| 18853587800,56 | Copenhagen Cycling 18853587800 | 56 | 2025-04-17 14:02:44.000000 | 55.70980628952384 | 12.56080862134695 | 0.5199600000000001 | 17.399999999999977 | 84 | 10.112400000000001 | |||
| 18853587800,57 | Copenhagen Cycling 18853587800 | 57 | 2025-04-17 14:02:48.000000 | 55.709868567064404 | 12.561058821156621 | 0.53728 | 18.200000000000045 | 85 | 16.2252 | |||
| 18853587800,58 | Copenhagen Cycling 18853587800 | 58 | 2025-04-17 14:02:53.000000 | 55.7099258992821 | 12.561373058706522 | 0.5577000000000001 | 18.0 | 87 | 12.0924 | |||
| 18853587800,59 | Copenhagen Cycling 18853587800 | 59 | 2025-04-17 14:02:56.000000 | 55.70983428508043 | 12.561464421451092 | 0.56838 | 16.799999999999955 | 88 | 16.1568 | |||
| 18853587800,60 | Copenhagen Cycling 18853587800 | 60 | 2025-04-17 14:02:59.000000 | 55.7097633741796 | 12.561554359272122 | 0.57853 | 17.799999999999955 | 88 | 7.354800000000001 | |||
| 18853587800,61 | Copenhagen Cycling 18853587800 | 61 | 2025-04-17 14:03:03.000000 | 55.709770834073424 | 12.561648823320866 | 0.58438 | 18.0 | 88 | 0.8388000000000001 | |||
| 18853587800,62 | Copenhagen Cycling 18853587800 | 62 | 2025-04-17 14:03:09.000000 | 55.709733283147216 | 12.561716716736555 | 0.59229 | 17.799999999999955 | 87 | 5.475600000000001 | |||
| 18853587800,63 | Copenhagen Cycling 18853587800 | 63 | 2025-04-17 14:03:13.000000 | 55.709729762747884 | 12.561735408380628 | 0.59441 | 17.799999999999955 | 88 | 3.528 | |||
| 18853587800,64 | Copenhagen Cycling 18853587800 | 64 | 2025-04-17 14:03:15.000000 | 55.70973479188979 | 12.56176382303238 | 0.59618 | 17.799999999999955 | 88 | 5.040000000000001 | |||
| 18853587800,65 | Copenhagen Cycling 18853587800 | 65 | 2025-04-17 14:03:17.000000 | 55.70974417962134 | 12.561809252947569 | 0.5989500000000001 | 17.799999999999955 | 89 | 6.3144 | |||
| 18853587800,66 | Copenhagen Cycling 18853587800 | 66 | 2025-04-17 14:03:18.000000 | 55.70975155569613 | 12.56182886660099 | 0.59977 | 18.0 | 89 | 5.3748000000000005 | |||
| 18853587800,67 | Copenhagen Cycling 18853587800 | 67 | 2025-04-17 14:03:20.000000 | 55.70973881520331 | 12.561867758631706 | 0.6016 | 18.0 | 89 | 4.0644 | |||
| 18853587800,68 | Copenhagen Cycling 18853587800 | 68 | 2025-04-17 14:03:23.000000 | 55.70968265645206 | 12.561902375891805 | 0.60904 | 18.0 | 90 | 5.040000000000001 | |||
| 18853587800,69 | Copenhagen Cycling 18853587800 | 69 | 2025-04-17 14:03:28.000000 | 55.70955860428512 | 12.562024584040046 | 0.6237100000000001 | 17.799999999999955 | 93 | 4.1328000000000005 | |||
| 18853587800,70 | Copenhagen Cycling 18853587800 | 70 | 2025-04-17 14:03:29.000000 | 55.709540247917175 | 12.562025841325521 | 0.62589 | 17.799999999999955 | 93 | 5.040000000000001 | |||
| 18853587800,71 | Copenhagen Cycling 18853587800 | 71 | 2025-04-17 14:03:34.000000 | 55.70948735810816 | 12.562059117481112 | 0.63254 | 17.799999999999955 | 95 | 0.0 | |||
| 18853587800,72 | Copenhagen Cycling 18853587800 | 72 | 2025-04-17 14:03:40.000000 | 55.70948920212686 | 12.562061129137874 | 0.63287 | 18.0 | 96 | 0.0 | |||
| 18853587800,73 | Copenhagen Cycling 18853587800 | 73 | 2025-04-17 14:03:46.000000 | 55.70949004031718 | 12.562062051147223 | 0.63287 | 18.0 | 96 | 0.0 | |||
| 18853587800,74 | Copenhagen Cycling 18853587800 | 74 | 2025-04-17 14:03:47.000000 | 55.70948970504105 | 12.562060793861747 | 0.63287 | 18.0 | 95 | 0.0 | |||
| 18853587800,75 | Copenhagen Cycling 18853587800 | 75 | 2025-04-17 14:03:53.000000 | 55.709466906264424 | 12.562053417786956 | 0.63426 | 18.0 | 97 | 3.3588000000000005 | |||
| 18853587800,76 | Copenhagen Cycling 18853587800 | 76 | 2025-04-17 14:03:55.000000 | 55.70943647995591 | 12.562066912651062 | 0.63752 | 18.0 | 97 | 4.1328000000000005 |
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) );