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_02_06_13"

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 ekg heart_rate
exp_2023_02_06_13 200 lion 0 1675718166.4628165 2023-02-06T21:16:06.462816+00:00 -5486.83 93.4361
exp_2023_02_06_13 200 lion 1 1675718166.4678166 2023-02-06T21:16:06.467817+00:00 -7215.21 93.4845
exp_2023_02_06_13 200 lion 2 1675718166.4728165 2023-02-06T21:16:06.472816+00:00 -7967.86 93.5324
exp_2023_02_06_13 200 lion 3 1675718166.4778166 2023-02-06T21:16:06.477817+00:00 -10758.0 93.5799
exp_2023_02_06_13 200 lion 4 1675718166.4828165 2023-02-06T21:16:06.482816+00:00 -13445.5 93.627
exp_2023_02_06_13 200 lion 5 1675718166.4878166 2023-02-06T21:16:06.487817+00:00 -14315.4 93.6737
exp_2023_02_06_13 200 lion 6 1675718166.4928164 2023-02-06T21:16:06.492816+00:00 -16590.9 93.72
exp_2023_02_06_13 200 lion 7 1675718166.4978166 2023-02-06T21:16:06.497817+00:00 -20133.7 93.7659
exp_2023_02_06_13 200 lion 8 1675718166.5028164 2023-02-06T21:16:06.502816+00:00 -21924.9 93.8114
exp_2023_02_06_13 200 lion 9 1675718166.5078166 2023-02-06T21:16:06.507817+00:00 -23882.1 93.8566
exp_2023_02_06_13 200 lion 10 1675718166.5128164 2023-02-06T21:16:06.512816+00:00 -27886.2 93.9013
exp_2023_02_06_13 200 lion 11 1675718166.5178165 2023-02-06T21:16:06.517817+00:00 -30775.9 93.9457
exp_2023_02_06_13 200 lion 12 1675718166.5228164 2023-02-06T21:16:06.522816+00:00 -32484.2 93.9898
exp_2023_02_06_13 200 lion 13 1675718166.5278165 2023-02-06T21:16:06.527817+00:00 -36149.2 94.0334
exp_2023_02_06_13 200 lion 14 1675718166.5328164 2023-02-06T21:16:06.532816+00:00 -39676.6 94.0767
exp_2023_02_06_13 200 lion 15 1675718166.5378165 2023-02-06T21:16:06.537817+00:00 -40930.0 94.1196
exp_2023_02_06_13 200 lion 16 1675718166.5428164 2023-02-06T21:16:06.542816+00:00 -42936.5 94.1622
exp_2023_02_06_13 200 lion 17 1675718166.5478165 2023-02-06T21:16:06.547817+00:00 -45598.4 94.2044
exp_2023_02_06_13 200 lion 18 1675718166.5528164 2023-02-06T21:16:06.552816+00:00 -45690.1 94.2463
exp_2023_02_06_13 200 lion 19 1675718166.5578165 2023-02-06T21:16:06.557817+00:00 -44913.5 94.2879
exp_2023_02_06_13 200 lion 20 1675718166.5628164 2023-02-06T21:16:06.562816+00:00 -45116.4 94.3291
exp_2023_02_06_13 200 lion 21 1675718166.5678165 2023-02-06T21:16:06.567816+00:00 -43006.3 94.37
exp_2023_02_06_13 200 lion 22 1675718166.5728164 2023-02-06T21:16:06.572816+00:00 -38154.1 94.4106
exp_2023_02_06_13 200 lion 23 1675718166.5778165 2023-02-06T21:16:06.577816+00:00 -33748.8 94.4508
exp_2023_02_06_13 200 lion 24 1675718166.5828164 2023-02-06T21:16:06.582816+00:00 -28261.6 94.4908
exp_2023_02_06_13 200 lion 25 1675718166.5878165 2023-02-06T21:16:06.587816+00:00 -19989.9 94.5304
exp_2023_02_06_13 200 lion 26 1675718166.5928166 2023-02-06T21:16:06.592817+00:00 -12491.1 94.5697
exp_2023_02_06_13 200 lion 27 1675718166.5978165 2023-02-06T21:16:06.597816+00:00 -6552.93 94.6087
exp_2023_02_06_13 200 lion 28 1675718166.6028166 2023-02-06T21:16:06.602817+00:00 678.221 94.6475
exp_2023_02_06_13 200 lion 29 1675718166.6078165 2023-02-06T21:16:06.607816+00:00 7328.01 94.6859
exp_2023_02_06_13 200 lion 30 1675718166.6128166 2023-02-06T21:16:06.612817+00:00 11086.8 94.724
exp_2023_02_06_13 200 lion 31 1675718166.6178164 2023-02-06T21:16:06.617816+00:00 14835.1 94.7619
exp_2023_02_06_13 200 lion 32 1675718166.6228166 2023-02-06T21:16:06.622817+00:00 19048.2 94.7995
exp_2023_02_06_13 200 lion 33 1675718166.6278164 2023-02-06T21:16:06.627816+00:00 20698.5 94.8368
exp_2023_02_06_13 200 lion 34 1675718166.6328166 2023-02-06T21:16:06.632817+00:00 21375.4 94.8738
exp_2023_02_06_13 200 lion 35 1675718166.6378164 2023-02-06T21:16:06.637816+00:00 23566.6 94.9106
exp_2023_02_06_13 200 lion 36 1675718166.6428165 2023-02-06T21:16:06.642817+00:00 24556.3 94.9472
exp_2023_02_06_13 200 lion 37 1675718166.6478164 2023-02-06T21:16:06.647816+00:00 23813.0 94.9834
exp_2023_02_06_13 200 lion 38 1675718166.6528165 2023-02-06T21:16:06.652817+00:00 24619.5 95.0194
exp_2023_02_06_13 200 lion 39 1675718166.6578164 2023-02-06T21:16:06.657816+00:00 25762.2 95.0552
exp_2023_02_06_13 200 lion 40 1675718166.6628165 2023-02-06T21:16:06.662817+00:00 24859.5 95.0908
exp_2023_02_06_13 200 lion 41 1675718166.6678164 2023-02-06T21:16:06.667816+00:00 24713.4 95.1261
exp_2023_02_06_13 200 lion 42 1675718166.6728165 2023-02-06T21:16:06.672817+00:00 26104.3 95.1612
exp_2023_02_06_13 200 lion 43 1675718166.6778164 2023-02-06T21:16:06.677816+00:00 25750.0 95.1961
exp_2023_02_06_13 200 lion 44 1675718166.6828165 2023-02-06T21:16:06.682817+00:00 24917.7 95.2308
exp_2023_02_06_13 200 lion 45 1675718166.6878164 2023-02-06T21:16:06.687816+00:00 26114.1 95.2652
exp_2023_02_06_13 200 lion 46 1675718166.6928165 2023-02-06T21:16:06.692816+00:00 26562.1 95.2995
exp_2023_02_06_13 200 lion 47 1675718166.6978164 2023-02-06T21:16:06.697816+00:00 25311.2 95.3335
exp_2023_02_06_13 200 lion 48 1675718166.7028165 2023-02-06T21:16:06.702816+00:00 25575.2 95.3674
exp_2023_02_06_13 200 lion 49 1675718166.7078164 2023-02-06T21:16:06.707816+00:00 26372.6 95.401
exp_2023_02_06_13 200 lion 50 1675718166.7128165 2023-02-06T21:16:06.712816+00:00 25102.7 95.4345
exp_2023_02_06_13 200 lion 51 1675718166.7178166 2023-02-06T21:16:06.717817+00:00 24522.2 95.4678
exp_2023_02_06_13 200 lion 52 1675718166.7228165 2023-02-06T21:16:06.722816+00:00 25599.0 95.5009
exp_2023_02_06_13 200 lion 53 1675718166.7278166 2023-02-06T21:16:06.727817+00:00 24940.7 95.5339
exp_2023_02_06_13 200 lion 54 1675718166.7328165 2023-02-06T21:16:06.732816+00:00 23537.7 95.5667
exp_2023_02_06_13 200 lion 55 1675718166.7378166 2023-02-06T21:16:06.737817+00:00 23986.0 95.5993
exp_2023_02_06_13 200 lion 56 1675718166.7428164 2023-02-06T21:16:06.742816+00:00 23680.4 95.6318
exp_2023_02_06_13 200 lion 57 1675718166.7478166 2023-02-06T21:16:06.747817+00:00 21447.3 95.6642
exp_2023_02_06_13 200 lion 58 1675718166.7528164 2023-02-06T21:16:06.752816+00:00 20594.8 95.6963
exp_2023_02_06_13 200 lion 59 1675718166.7578166 2023-02-06T21:16:06.757817+00:00 20474.6 95.7284
exp_2023_02_06_13 200 lion 60 1675718166.7628164 2023-02-06T21:16:06.762816+00:00 18311.1 95.7604
exp_2023_02_06_13 200 lion 61 1675718166.7678165 2023-02-06T21:16:06.767817+00:00 16657.7 95.7922
exp_2023_02_06_13 200 lion 62 1675718166.7728164 2023-02-06T21:16:06.772816+00:00 16665.5 95.8238
exp_2023_02_06_13 200 lion 63 1675718166.7778165 2023-02-06T21:16:06.777817+00:00 14944.8 95.8554
exp_2023_02_06_13 200 lion 64 1675718166.7828164 2023-02-06T21:16:06.782816+00:00 12525.0 95.8869
exp_2023_02_06_13 200 lion 65 1675718166.7878165 2023-02-06T21:16:06.787817+00:00 12514.4 95.9183
exp_2023_02_06_13 200 lion 66 1675718166.7928164 2023-02-06T21:16:06.792816+00:00 12831.6 95.9495
exp_2023_02_06_13 200 lion 67 1675718166.7978165 2023-02-06T21:16:06.797817+00:00 12240.4 95.9807
exp_2023_02_06_13 200 lion 68 1675718166.8028164 2023-02-06T21:16:06.802816+00:00 13700.6 96.0118
exp_2023_02_06_13 200 lion 69 1675718166.8078165 2023-02-06T21:16:06.807817+00:00 16369.9 96.0428
exp_2023_02_06_13 200 lion 70 1675718166.8128164 2023-02-06T21:16:06.812816+00:00 17058.1 96.0737
exp_2023_02_06_13 200 lion 71 1675718166.8178165 2023-02-06T21:16:06.817816+00:00 18033.4 96.1046
exp_2023_02_06_13 200 lion 72 1675718166.8228164 2023-02-06T21:16:06.822816+00:00 20930.2 96.1354
exp_2023_02_06_13 200 lion 73 1675718166.8278165 2023-02-06T21:16:06.827816+00:00 22570.2 96.1661
exp_2023_02_06_13 200 lion 74 1675718166.8328164 2023-02-06T21:16:06.832816+00:00 23372.8 96.1968
exp_2023_02_06_13 200 lion 75 1675718166.8378165 2023-02-06T21:16:06.837816+00:00 26065.8 96.2274
exp_2023_02_06_13 200 lion 76 1675718166.8428166 2023-02-06T21:16:06.842817+00:00 28155.3 96.258
exp_2023_02_06_13 200 lion 77 1675718166.8478165 2023-02-06T21:16:06.847816+00:00 27931.1 96.2886
exp_2023_02_06_13 200 lion 78 1675718166.8528166 2023-02-06T21:16:06.852817+00:00 28639.2 96.3192
exp_2023_02_06_13 200 lion 79 1675718166.8578165 2023-02-06T21:16:06.857816+00:00 30151.1 96.3496
exp_2023_02_06_13 200 lion 80 1675718166.8628166 2023-02-06T21:16:06.862817+00:00 29604.7 96.3801
exp_2023_02_06_13 200 lion 81 1675718166.8678164 2023-02-06T21:16:06.867816+00:00 29232.7 96.4107
exp_2023_02_06_13 200 lion 82 1675718166.8728166 2023-02-06T21:16:06.872817+00:00 30759.2 96.4411
exp_2023_02_06_13 200 lion 83 1675718166.8778164 2023-02-06T21:16:06.877816+00:00 30880.9 96.4716
exp_2023_02_06_13 200 lion 84 1675718166.8828166 2023-02-06T21:16:06.882817+00:00 29816.7 96.5021
exp_2023_02_06_13 200 lion 85 1675718166.8878164 2023-02-06T21:16:06.887816+00:00 30512.9 96.5326
exp_2023_02_06_13 200 lion 86 1675718166.8928165 2023-02-06T21:16:06.892817+00:00 30951.0 96.5631
exp_2023_02_06_13 200 lion 87 1675718166.8978164 2023-02-06T21:16:06.897816+00:00 29424.7 96.5936
exp_2023_02_06_13 200 lion 88 1675718166.9028165 2023-02-06T21:16:06.902817+00:00 28977.6 96.6242
exp_2023_02_06_13 200 lion 89 1675718166.9078164 2023-02-06T21:16:06.907816+00:00 29352.4 96.6548
exp_2023_02_06_13 200 lion 90 1675718166.9128165 2023-02-06T21:16:06.912817+00:00 25887.2 96.6854
exp_2023_02_06_13 200 lion 91 1675718166.9178164 2023-02-06T21:16:06.917816+00:00 18446.4 96.716
exp_2023_02_06_13 200 lion 92 1675718166.9228165 2023-02-06T21:16:06.922817+00:00 7190.93 96.7468
exp_2023_02_06_13 200 lion 93 1675718166.9278164 2023-02-06T21:16:06.927816+00:00 -13965.0 96.7776
exp_2023_02_06_13 200 lion 94 1675718166.9328165 2023-02-06T21:16:06.932817+00:00 -47080.5 96.8084
exp_2023_02_06_13 200 lion 95 1675718166.9378164 2023-02-06T21:16:06.937816+00:00 -87538.8 96.8394
exp_2023_02_06_13 200 lion 96 1675718166.9428165 2023-02-06T21:16:06.942816+00:00 -126766.0 96.8704
exp_2023_02_06_13 200 lion 97 1675718166.9478164 2023-02-06T21:16:06.947816+00:00 -150253.0 96.9015
exp_2023_02_06_13 200 lion 98 1675718166.9528165 2023-02-06T21:16:06.952816+00:00 -144857.0 96.9326
exp_2023_02_06_13 200 lion 99 1675718166.9578164 2023-02-06T21:16:06.957816+00:00 -108106.0 96.9639

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]);