Column descriptions

group_session
Group session ID
frequency
Frequency of the samples (main clock frequency).
station
The iMac that the participant was stationed at.
timestamp_unix
The Unix timestamp of the event.
timestamp_iso8601
The ISO-8601 timestamp of the event.
aux_ekg
value of the ekg channel.

where group_session = "exp_2023_01_31_14"

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 ekg heart_rate
exp_2023_01_31_14 200 leopard 0 1675205833.7892847 2023-01-31T22:57:13.789285+00:00 6597.31 104.987
exp_2023_01_31_14 200 leopard 1 1675205833.7942848 2023-01-31T22:57:13.794285+00:00 -27978.8 105.016
exp_2023_01_31_14 200 leopard 2 1675205833.7992847 2023-01-31T22:57:13.799285+00:00 -65665.2 105.046
exp_2023_01_31_14 200 leopard 3 1675205833.8042848 2023-01-31T22:57:13.804285+00:00 -93554.1 105.075
exp_2023_01_31_14 200 leopard 4 1675205833.8092847 2023-01-31T22:57:13.809285+00:00 -102232.0 105.105
exp_2023_01_31_14 200 leopard 5 1675205833.8142848 2023-01-31T22:57:13.814285+00:00 -82149.3 105.135
exp_2023_01_31_14 200 leopard 6 1675205833.8192847 2023-01-31T22:57:13.819285+00:00 -34320.9 105.165
exp_2023_01_31_14 200 leopard 7 1675205833.8242848 2023-01-31T22:57:13.824285+00:00 19012.5 105.196
exp_2023_01_31_14 200 leopard 8 1675205833.8292847 2023-01-31T22:57:13.829285+00:00 56767.6 105.227
exp_2023_01_31_14 200 leopard 9 1675205833.8342848 2023-01-31T22:57:13.834285+00:00 74908.0 105.258
exp_2023_01_31_14 200 leopard 10 1675205833.8392847 2023-01-31T22:57:13.839285+00:00 71600.3 105.289
exp_2023_01_31_14 200 leopard 11 1675205833.8442848 2023-01-31T22:57:13.844285+00:00 54201.0 105.32
exp_2023_01_31_14 200 leopard 12 1675205833.8492846 2023-01-31T22:57:13.849285+00:00 38161.7 105.352
exp_2023_01_31_14 200 leopard 13 1675205833.8542848 2023-01-31T22:57:13.854285+00:00 27164.7 105.384
exp_2023_01_31_14 200 leopard 14 1675205833.8592846 2023-01-31T22:57:13.859285+00:00 17371.9 105.416
exp_2023_01_31_14 200 leopard 15 1675205833.8642848 2023-01-31T22:57:13.864285+00:00 10923.3 105.448
exp_2023_01_31_14 200 leopard 16 1675205833.8692846 2023-01-31T22:57:13.869285+00:00 9765.29 105.481
exp_2023_01_31_14 200 leopard 17 1675205833.8742847 2023-01-31T22:57:13.874285+00:00 9007.19 105.513
exp_2023_01_31_14 200 leopard 18 1675205833.8792846 2023-01-31T22:57:13.879285+00:00 7752.91 105.546
exp_2023_01_31_14 200 leopard 19 1675205833.8842847 2023-01-31T22:57:13.884285+00:00 8787.56 105.579
exp_2023_01_31_14 200 leopard 20 1675205833.8892846 2023-01-31T22:57:13.889285+00:00 9399.83 105.612
exp_2023_01_31_14 200 leopard 21 1675205833.8942847 2023-01-31T22:57:13.894285+00:00 7342.16 105.646
exp_2023_01_31_14 200 leopard 22 1675205833.8992846 2023-01-31T22:57:13.899285+00:00 7176.91 105.679
exp_2023_01_31_14 200 leopard 23 1675205833.9042847 2023-01-31T22:57:13.904285+00:00 9648.58 105.713
exp_2023_01_31_14 200 leopard 24 1675205833.9092846 2023-01-31T22:57:13.909285+00:00 10201.6 105.747
exp_2023_01_31_14 200 leopard 25 1675205833.9142847 2023-01-31T22:57:13.914285+00:00 11499.5 105.78
exp_2023_01_31_14 200 leopard 26 1675205833.9192848 2023-01-31T22:57:13.919285+00:00 16596.0 105.815
exp_2023_01_31_14 200 leopard 27 1675205833.9242847 2023-01-31T22:57:13.924285+00:00 21960.2 105.849
exp_2023_01_31_14 200 leopard 28 1675205833.9292848 2023-01-31T22:57:13.929285+00:00 28832.5 105.883
exp_2023_01_31_14 200 leopard 29 1675205833.9342847 2023-01-31T22:57:13.934285+00:00 42329.9 105.918
exp_2023_01_31_14 200 leopard 30 1675205833.9392848 2023-01-31T22:57:13.939285+00:00 55872.9 105.952
exp_2023_01_31_14 200 leopard 31 1675205833.9442847 2023-01-31T22:57:13.944285+00:00 60106.9 105.987
exp_2023_01_31_14 200 leopard 32 1675205833.9492848 2023-01-31T22:57:13.949285+00:00 54761.8 106.022
exp_2023_01_31_14 200 leopard 33 1675205833.9542847 2023-01-31T22:57:13.954285+00:00 35740.0 106.057
exp_2023_01_31_14 200 leopard 34 1675205833.9592848 2023-01-31T22:57:13.959285+00:00 4956.22 106.092
exp_2023_01_31_14 200 leopard 35 1675205833.9642847 2023-01-31T22:57:13.964285+00:00 -25840.2 106.127
exp_2023_01_31_14 200 leopard 36 1675205833.9692848 2023-01-31T22:57:13.969285+00:00 -49263.0 106.163
exp_2023_01_31_14 200 leopard 37 1675205833.9742846 2023-01-31T22:57:13.974285+00:00 -64785.1 106.198
exp_2023_01_31_14 200 leopard 38 1675205833.9792848 2023-01-31T22:57:13.979285+00:00 -73589.6 106.234
exp_2023_01_31_14 200 leopard 39 1675205833.9842846 2023-01-31T22:57:13.984285+00:00 -73219.2 106.269
exp_2023_01_31_14 200 leopard 40 1675205833.9892848 2023-01-31T22:57:13.989285+00:00 -67580.3 106.305
exp_2023_01_31_14 200 leopard 41 1675205833.9942846 2023-01-31T22:57:13.994285+00:00 -61195.4 106.341
exp_2023_01_31_14 200 leopard 42 1675205833.9992847 2023-01-31T22:57:13.999285+00:00 -50063.7 106.377
exp_2023_01_31_14 200 leopard 43 1675205834.0042846 2023-01-31T22:57:14.004285+00:00 -36942.0 106.413
exp_2023_01_31_14 200 leopard 44 1675205834.0092847 2023-01-31T22:57:14.009285+00:00 -28280.5 106.449
exp_2023_01_31_14 200 leopard 45 1675205834.0142846 2023-01-31T22:57:14.014285+00:00 -21248.1 106.485
exp_2023_01_31_14 200 leopard 46 1675205834.0192847 2023-01-31T22:57:14.019285+00:00 -16456.2 106.521
exp_2023_01_31_14 200 leopard 47 1675205834.0242846 2023-01-31T22:57:14.024285+00:00 -18896.9 106.558
exp_2023_01_31_14 200 leopard 48 1675205834.0292847 2023-01-31T22:57:14.029285+00:00 -24701.0 106.594
exp_2023_01_31_14 200 leopard 49 1675205834.0342846 2023-01-31T22:57:14.034285+00:00 -29414.9 106.63
exp_2023_01_31_14 200 leopard 50 1675205834.0392847 2023-01-31T22:57:14.039285+00:00 -34687.8 106.667
exp_2023_01_31_14 200 leopard 51 1675205834.0442848 2023-01-31T22:57:14.044285+00:00 -39156.4 106.704
exp_2023_01_31_14 200 leopard 52 1675205834.0492847 2023-01-31T22:57:14.049285+00:00 -39291.9 106.74
exp_2023_01_31_14 200 leopard 53 1675205834.0542848 2023-01-31T22:57:14.054285+00:00 -36749.6 106.777
exp_2023_01_31_14 200 leopard 54 1675205834.0592847 2023-01-31T22:57:14.059285+00:00 -34280.3 106.813
exp_2023_01_31_14 200 leopard 55 1675205834.0642848 2023-01-31T22:57:14.064285+00:00 -30236.1 106.85
exp_2023_01_31_14 200 leopard 56 1675205834.0692847 2023-01-31T22:57:14.069285+00:00 -24923.1 106.887
exp_2023_01_31_14 200 leopard 57 1675205834.0742848 2023-01-31T22:57:14.074285+00:00 -22888.8 106.924
exp_2023_01_31_14 200 leopard 58 1675205834.0792847 2023-01-31T22:57:14.079285+00:00 -22902.3 106.96
exp_2023_01_31_14 200 leopard 59 1675205834.0842848 2023-01-31T22:57:14.084285+00:00 -21471.2 106.997
exp_2023_01_31_14 200 leopard 60 1675205834.0892847 2023-01-31T22:57:14.089285+00:00 -21223.9 107.034
exp_2023_01_31_14 200 leopard 61 1675205834.0942848 2023-01-31T22:57:14.094285+00:00 -21666.4 107.071
exp_2023_01_31_14 200 leopard 62 1675205834.0992846 2023-01-31T22:57:14.099285+00:00 -17630.7 107.108
exp_2023_01_31_14 200 leopard 63 1675205834.1042848 2023-01-31T22:57:14.104285+00:00 -12949.4 107.145
exp_2023_01_31_14 200 leopard 64 1675205834.1092846 2023-01-31T22:57:14.109285+00:00 -11467.5 107.181
exp_2023_01_31_14 200 leopard 65 1675205834.1142848 2023-01-31T22:57:14.114285+00:00 -8000.46 107.218
exp_2023_01_31_14 200 leopard 66 1675205834.1192846 2023-01-31T22:57:14.119285+00:00 -4549.05 107.255
exp_2023_01_31_14 200 leopard 67 1675205834.1242847 2023-01-31T22:57:14.124285+00:00 -4918.24 107.292
exp_2023_01_31_14 200 leopard 68 1675205834.1292846 2023-01-31T22:57:14.129285+00:00 -3029.85 107.329
exp_2023_01_31_14 200 leopard 69 1675205834.1342847 2023-01-31T22:57:14.134285+00:00 1298.08 107.366
exp_2023_01_31_14 200 leopard 70 1675205834.1392846 2023-01-31T22:57:14.139285+00:00 2238.68 107.402
exp_2023_01_31_14 200 leopard 71 1675205834.1442847 2023-01-31T22:57:14.144285+00:00 3368.86 107.439
exp_2023_01_31_14 200 leopard 72 1675205834.1492846 2023-01-31T22:57:14.149285+00:00 7120.36 107.476
exp_2023_01_31_14 200 leopard 73 1675205834.1542847 2023-01-31T22:57:14.154285+00:00 8524.23 107.513
exp_2023_01_31_14 200 leopard 74 1675205834.1592846 2023-01-31T22:57:14.159285+00:00 9441.66 107.549
exp_2023_01_31_14 200 leopard 75 1675205834.1642847 2023-01-31T22:57:14.164285+00:00 14032.7 107.586
exp_2023_01_31_14 200 leopard 76 1675205834.1692848 2023-01-31T22:57:14.169285+00:00 17847.1 107.622
exp_2023_01_31_14 200 leopard 77 1675205834.1742847 2023-01-31T22:57:14.174285+00:00 19328.5 107.659
exp_2023_01_31_14 200 leopard 78 1675205834.1792848 2023-01-31T22:57:14.179285+00:00 22233.8 107.695
exp_2023_01_31_14 200 leopard 79 1675205834.1842847 2023-01-31T22:57:14.184285+00:00 24319.2 107.732
exp_2023_01_31_14 200 leopard 80 1675205834.1892848 2023-01-31T22:57:14.189285+00:00 23161.9 107.768
exp_2023_01_31_14 200 leopard 81 1675205834.1942847 2023-01-31T22:57:14.194285+00:00 21058.1 107.804
exp_2023_01_31_14 200 leopard 82 1675205834.1992848 2023-01-31T22:57:14.199285+00:00 19159.2 107.84
exp_2023_01_31_14 200 leopard 83 1675205834.2042847 2023-01-31T22:57:14.204285+00:00 15327.7 107.876
exp_2023_01_31_14 200 leopard 84 1675205834.2092848 2023-01-31T22:57:14.209285+00:00 9346.01 107.912
exp_2023_01_31_14 200 leopard 85 1675205834.2142847 2023-01-31T22:57:14.214285+00:00 4420.17 107.948
exp_2023_01_31_14 200 leopard 86 1675205834.2192848 2023-01-31T22:57:14.219285+00:00 -618.382 107.984
exp_2023_01_31_14 200 leopard 87 1675205834.2242846 2023-01-31T22:57:14.224285+00:00 -7362.69 108.02
exp_2023_01_31_14 200 leopard 88 1675205834.2292848 2023-01-31T22:57:14.229285+00:00 -11543.9 108.055
exp_2023_01_31_14 200 leopard 89 1675205834.2342846 2023-01-31T22:57:14.234285+00:00 -12042.0 108.091
exp_2023_01_31_14 200 leopard 90 1675205834.2392848 2023-01-31T22:57:14.239285+00:00 -11798.9 108.126
exp_2023_01_31_14 200 leopard 91 1675205834.2442846 2023-01-31T22:57:14.244285+00:00 -9514.56 108.162
exp_2023_01_31_14 200 leopard 92 1675205834.2492847 2023-01-31T22:57:14.249285+00:00 -3813.46 108.197
exp_2023_01_31_14 200 leopard 93 1675205834.2542846 2023-01-31T22:57:14.254285+00:00 1905.74 108.232
exp_2023_01_31_14 200 leopard 94 1675205834.2592847 2023-01-31T22:57:14.259285+00:00 5963.71 108.267
exp_2023_01_31_14 200 leopard 95 1675205834.2642846 2023-01-31T22:57:14.264285+00:00 11033.2 108.302
exp_2023_01_31_14 200 leopard 96 1675205834.2692847 2023-01-31T22:57:14.269285+00:00 15741.6 108.336
exp_2023_01_31_14 200 leopard 97 1675205834.2742846 2023-01-31T22:57:14.274285+00:00 17298.2 108.371
exp_2023_01_31_14 200 leopard 98 1675205834.2792847 2023-01-31T22:57:14.279285+00:00 18496.4 108.405
exp_2023_01_31_14 200 leopard 99 1675205834.2842846 2023-01-31T22:57:14.284285+00:00 20221.6 108.439

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "ekg_sync" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [frequency] INTEGER,
   [station] TEXT REFERENCES [station]([id]),
   [id] INTEGER,
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [ekg] FLOAT,
   [heart_rate] FLOAT,
   PRIMARY KEY ([group_session], [frequency], [station], [id])
);
CREATE INDEX [idx_ekg_sync_station]
    ON [ekg_sync] ([station]);
CREATE INDEX [idx_ekg_sync_group_session]
    ON [ekg_sync] ([group_session]);