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_05_02_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_05_02_14 200 lion 0 1683065949.6312912 2023-05-02T22:19:09.631291+00:00 20917.3 76.231
exp_2023_05_02_14 200 lion 1 1683065949.6362913 2023-05-02T22:19:09.636291+00:00 15585.7 76.2156
exp_2023_05_02_14 200 lion 2 1683065949.6412911 2023-05-02T22:19:09.641291+00:00 11632.6 76.2002
exp_2023_05_02_14 200 lion 3 1683065949.6462913 2023-05-02T22:19:09.646291+00:00 17675.0 76.1847
exp_2023_05_02_14 200 lion 4 1683065949.6512911 2023-05-02T22:19:09.651291+00:00 16571.2 76.1692
exp_2023_05_02_14 200 lion 5 1683065949.6562912 2023-05-02T22:19:09.656291+00:00 8174.75 76.154
exp_2023_05_02_14 200 lion 6 1683065949.6612911 2023-05-02T22:19:09.661291+00:00 9679.6 76.1389
exp_2023_05_02_14 200 lion 7 1683065949.6662912 2023-05-02T22:19:09.666291+00:00 13600.5 76.1237
exp_2023_05_02_14 200 lion 8 1683065949.671291 2023-05-02T22:19:09.671291+00:00 6453.02 76.1085
exp_2023_05_02_14 200 lion 9 1683065949.6762912 2023-05-02T22:19:09.676291+00:00 2675.49 76.0934
exp_2023_05_02_14 200 lion 10 1683065949.681291 2023-05-02T22:19:09.681291+00:00 12139.1 76.0785
exp_2023_05_02_14 200 lion 11 1683065949.6862912 2023-05-02T22:19:09.686291+00:00 8023.48 76.0637
exp_2023_05_02_14 200 lion 12 1683065949.691291 2023-05-02T22:19:09.691291+00:00 -4878.17 76.0489
exp_2023_05_02_14 200 lion 13 1683065949.6962912 2023-05-02T22:19:09.696291+00:00 -270.72 76.0341
exp_2023_05_02_14 200 lion 14 1683065949.701291 2023-05-02T22:19:09.701291+00:00 -2484.26 76.0194
exp_2023_05_02_14 200 lion 15 1683065949.7062912 2023-05-02T22:19:09.706291+00:00 -13198.7 76.0049
exp_2023_05_02_14 200 lion 16 1683065949.711291 2023-05-02T22:19:09.711291+00:00 -5587.67 75.9905
exp_2023_05_02_14 200 lion 17 1683065949.7162912 2023-05-02T22:19:09.716291+00:00 4666.23 75.9761
exp_2023_05_02_14 200 lion 18 1683065949.721291 2023-05-02T22:19:09.721291+00:00 1969.65 75.9617
exp_2023_05_02_14 200 lion 19 1683065949.7262912 2023-05-02T22:19:09.726291+00:00 4982.33 75.9475
exp_2023_05_02_14 200 lion 20 1683065949.731291 2023-05-02T22:19:09.731291+00:00 16819.4 75.9336
exp_2023_05_02_14 200 lion 21 1683065949.7362912 2023-05-02T22:19:09.736291+00:00 19271.7 75.9197
exp_2023_05_02_14 200 lion 22 1683065949.741291 2023-05-02T22:19:09.741291+00:00 16809.9 75.9058
exp_2023_05_02_14 200 lion 23 1683065949.7462912 2023-05-02T22:19:09.746291+00:00 24192.2 75.8919
exp_2023_05_02_14 200 lion 24 1683065949.751291 2023-05-02T22:19:09.751291+00:00 29418.5 75.8783
exp_2023_05_02_14 200 lion 25 1683065949.7562912 2023-05-02T22:19:09.756291+00:00 23416.9 75.8648
exp_2023_05_02_14 200 lion 26 1683065949.7612913 2023-05-02T22:19:09.761291+00:00 22913.2 75.8515
exp_2023_05_02_14 200 lion 27 1683065949.7662911 2023-05-02T22:19:09.766291+00:00 29444.5 75.8382
exp_2023_05_02_14 200 lion 28 1683065949.7712913 2023-05-02T22:19:09.771291+00:00 25840.1 75.8249
exp_2023_05_02_14 200 lion 29 1683065949.7762911 2023-05-02T22:19:09.776291+00:00 19607.2 75.8119
exp_2023_05_02_14 200 lion 30 1683065949.7812912 2023-05-02T22:19:09.781291+00:00 24747.7 75.7991
exp_2023_05_02_14 200 lion 31 1683065949.7862911 2023-05-02T22:19:09.786291+00:00 22880.4 75.7864
exp_2023_05_02_14 200 lion 32 1683065949.7912912 2023-05-02T22:19:09.791291+00:00 5533.35 75.7737
exp_2023_05_02_14 200 lion 33 1683065949.796291 2023-05-02T22:19:09.796291+00:00 907.421 75.7612
exp_2023_05_02_14 200 lion 34 1683065949.8012912 2023-05-02T22:19:09.801291+00:00 5515.18 75.7489
exp_2023_05_02_14 200 lion 35 1683065949.806291 2023-05-02T22:19:09.806291+00:00 290.745 75.7368
exp_2023_05_02_14 200 lion 36 1683065949.8112912 2023-05-02T22:19:09.811291+00:00 7585.11 75.7248
exp_2023_05_02_14 200 lion 37 1683065949.816291 2023-05-02T22:19:09.816291+00:00 23880.0 75.7128
exp_2023_05_02_14 200 lion 38 1683065949.8212912 2023-05-02T22:19:09.821291+00:00 19722.8 75.701
exp_2023_05_02_14 200 lion 39 1683065949.826291 2023-05-02T22:19:09.826291+00:00 4679.22 75.6895
exp_2023_05_02_14 200 lion 40 1683065949.8312912 2023-05-02T22:19:09.831291+00:00 -9711.4 75.6781
exp_2023_05_02_14 200 lion 41 1683065949.836291 2023-05-02T22:19:09.836291+00:00 -40838.0 75.6669
exp_2023_05_02_14 200 lion 42 1683065949.8412912 2023-05-02T22:19:09.841291+00:00 -90528.5 75.6557
exp_2023_05_02_14 200 lion 43 1683065949.846291 2023-05-02T22:19:09.846291+00:00 -133350.0 75.6448
exp_2023_05_02_14 200 lion 44 1683065949.8512912 2023-05-02T22:19:09.851291+00:00 -160396.0 75.6341
exp_2023_05_02_14 200 lion 45 1683065949.856291 2023-05-02T22:19:09.856291+00:00 -174040.0 75.6236
exp_2023_05_02_14 200 lion 46 1683065949.8612912 2023-05-02T22:19:09.861291+00:00 -156216.0 75.6132
exp_2023_05_02_14 200 lion 47 1683065949.866291 2023-05-02T22:19:09.866291+00:00 -103693.0 75.6029
exp_2023_05_02_14 200 lion 48 1683065949.8712912 2023-05-02T22:19:09.871291+00:00 -49304.5 75.5928
exp_2023_05_02_14 200 lion 49 1683065949.876291 2023-05-02T22:19:09.876291+00:00 -11794.0 75.583
exp_2023_05_02_14 200 lion 50 1683065949.8812912 2023-05-02T22:19:09.881291+00:00 16271.3 75.5735
exp_2023_05_02_14 200 lion 51 1683065949.8862913 2023-05-02T22:19:09.886291+00:00 27052.7 75.564
exp_2023_05_02_14 200 lion 52 1683065949.8912911 2023-05-02T22:19:09.891291+00:00 9377.67 75.5546
exp_2023_05_02_14 200 lion 53 1683065949.8962913 2023-05-02T22:19:09.896291+00:00 -5208.4 75.5453
exp_2023_05_02_14 200 lion 54 1683065949.9012911 2023-05-02T22:19:09.901291+00:00 -1653.21 75.5362
exp_2023_05_02_14 200 lion 55 1683065949.9062912 2023-05-02T22:19:09.906291+00:00 -6078.04 75.5272
exp_2023_05_02_14 200 lion 56 1683065949.9112911 2023-05-02T22:19:09.911291+00:00 -5771.17 75.5183
exp_2023_05_02_14 200 lion 57 1683065949.9162912 2023-05-02T22:19:09.916291+00:00 10424.7 75.5093
exp_2023_05_02_14 200 lion 58 1683065949.921291 2023-05-02T22:19:09.921291+00:00 13916.5 75.5005
exp_2023_05_02_14 200 lion 59 1683065949.9262912 2023-05-02T22:19:09.926291+00:00 6694.22 75.4919
exp_2023_05_02_14 200 lion 60 1683065949.931291 2023-05-02T22:19:09.931291+00:00 10692.1 75.4833
exp_2023_05_02_14 200 lion 61 1683065949.9362912 2023-05-02T22:19:09.936291+00:00 15048.3 75.4748
exp_2023_05_02_14 200 lion 62 1683065949.941291 2023-05-02T22:19:09.941291+00:00 8707.78 75.4662
exp_2023_05_02_14 200 lion 63 1683065949.9462912 2023-05-02T22:19:09.946291+00:00 14059.9 75.4579
exp_2023_05_02_14 200 lion 64 1683065949.951291 2023-05-02T22:19:09.951291+00:00 19252.9 75.4497
exp_2023_05_02_14 200 lion 65 1683065949.9562912 2023-05-02T22:19:09.956291+00:00 4632.46 75.4416
exp_2023_05_02_14 200 lion 66 1683065949.961291 2023-05-02T22:19:09.961291+00:00 -296.761 75.4334
exp_2023_05_02_14 200 lion 67 1683065949.9662912 2023-05-02T22:19:09.966291+00:00 -3007.42 75.4253
exp_2023_05_02_14 200 lion 68 1683065949.971291 2023-05-02T22:19:09.971291+00:00 -13187.1 75.4173
exp_2023_05_02_14 200 lion 69 1683065949.9762912 2023-05-02T22:19:09.976291+00:00 -3325.41 75.4095
exp_2023_05_02_14 200 lion 70 1683065949.981291 2023-05-02T22:19:09.981291+00:00 1137.63 75.4017
exp_2023_05_02_14 200 lion 71 1683065949.9862912 2023-05-02T22:19:09.986291+00:00 -9688.0 75.3939
exp_2023_05_02_14 200 lion 72 1683065949.991291 2023-05-02T22:19:09.991291+00:00 -2940.97 75.3862
exp_2023_05_02_14 200 lion 73 1683065949.9962912 2023-05-02T22:19:09.996291+00:00 142.602 75.3785
exp_2023_05_02_14 200 lion 74 1683065950.001291 2023-05-02T22:19:10.001291+00:00 -9205.5 75.3711
exp_2023_05_02_14 200 lion 75 1683065950.0062912 2023-05-02T22:19:10.006291+00:00 -938.203 75.3637
exp_2023_05_02_14 200 lion 76 1683065950.0112913 2023-05-02T22:19:10.011291+00:00 4426.36 75.3562
exp_2023_05_02_14 200 lion 77 1683065950.0162911 2023-05-02T22:19:10.016291+00:00 -6809.88 75.3487
exp_2023_05_02_14 200 lion 78 1683065950.0212913 2023-05-02T22:19:10.021291+00:00 -8278.71 75.3414
exp_2023_05_02_14 200 lion 79 1683065950.0262911 2023-05-02T22:19:10.026291+00:00 -2957.77 75.3343
exp_2023_05_02_14 200 lion 80 1683065950.0312912 2023-05-02T22:19:10.031291+00:00 -8314.69 75.3272
exp_2023_05_02_14 200 lion 81 1683065950.0362911 2023-05-02T22:19:10.036291+00:00 -15215.2 75.32
exp_2023_05_02_14 200 lion 82 1683065950.0412912 2023-05-02T22:19:10.041291+00:00 -11061.2 75.3128
exp_2023_05_02_14 200 lion 83 1683065950.046291 2023-05-02T22:19:10.046291+00:00 -10639.6 75.3058
exp_2023_05_02_14 200 lion 84 1683065950.0512912 2023-05-02T22:19:10.051291+00:00 -19090.9 75.299
exp_2023_05_02_14 200 lion 85 1683065950.056291 2023-05-02T22:19:10.056291+00:00 -19149.0 75.2921
exp_2023_05_02_14 200 lion 86 1683065950.0612912 2023-05-02T22:19:10.061291+00:00 -14006.8 75.2851
exp_2023_05_02_14 200 lion 87 1683065950.066291 2023-05-02T22:19:10.066291+00:00 -19759.7 75.2783
exp_2023_05_02_14 200 lion 88 1683065950.0712912 2023-05-02T22:19:10.071291+00:00 -25348.2 75.2715
exp_2023_05_02_14 200 lion 89 1683065950.076291 2023-05-02T22:19:10.076291+00:00 -20049.8 75.2649
exp_2023_05_02_14 200 lion 90 1683065950.0812912 2023-05-02T22:19:10.081291+00:00 -19879.9 75.2582
exp_2023_05_02_14 200 lion 91 1683065950.086291 2023-05-02T22:19:10.086291+00:00 -29180.5 75.2515
exp_2023_05_02_14 200 lion 92 1683065950.0912912 2023-05-02T22:19:10.091291+00:00 -23012.2 75.2448
exp_2023_05_02_14 200 lion 93 1683065950.096291 2023-05-02T22:19:10.096291+00:00 -11350.7 75.2383
exp_2023_05_02_14 200 lion 94 1683065950.1012912 2023-05-02T22:19:10.101291+00:00 -17267.7 75.2319
exp_2023_05_02_14 200 lion 95 1683065950.106291 2023-05-02T22:19:10.106291+00:00 -15418.8 75.2254
exp_2023_05_02_14 200 lion 96 1683065950.1112912 2023-05-02T22:19:10.111291+00:00 -7008.98 75.2189
exp_2023_05_02_14 200 lion 97 1683065950.116291 2023-05-02T22:19:10.116291+00:00 -15989.7 75.2124
exp_2023_05_02_14 200 lion 98 1683065950.1212912 2023-05-02T22:19:10.121291+00:00 -22335.2 75.2061
exp_2023_05_02_14 200 lion 99 1683065950.126291 2023-05-02T22:19:10.126291+00:00 -13624.4 75.1998

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