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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 ekg heart_rate
exp_2022_12_02_15 200 lion 0 1670023040.1878002 2022-12-02T23:17:20.187800+00:00 6694.72 80.6743
exp_2022_12_02_15 200 lion 1 1670023040.1928003 2022-12-02T23:17:20.192800+00:00 6151.38 80.7722
exp_2022_12_02_15 200 lion 2 1670023040.1978002 2022-12-02T23:17:20.197800+00:00 23422.6 80.8693
exp_2022_12_02_15 200 lion 3 1670023040.2028003 2022-12-02T23:17:20.202800+00:00 14226.0 80.9658
exp_2022_12_02_15 200 lion 4 1670023040.2078001 2022-12-02T23:17:20.207800+00:00 2774.15 81.0614
exp_2022_12_02_15 200 lion 5 1670023040.2128003 2022-12-02T23:17:20.212800+00:00 18705.7 81.1562
exp_2022_12_02_15 200 lion 6 1670023040.2178001 2022-12-02T23:17:20.217800+00:00 19961.8 81.2502
exp_2022_12_02_15 200 lion 7 1670023040.2228003 2022-12-02T23:17:20.222800+00:00 2758.53 81.3432
exp_2022_12_02_15 200 lion 8 1670023040.2278001 2022-12-02T23:17:20.227800+00:00 12194.6 81.4353
exp_2022_12_02_15 200 lion 9 1670023040.2328002 2022-12-02T23:17:20.232800+00:00 24126.1 81.5263
exp_2022_12_02_15 200 lion 10 1670023040.2378001 2022-12-02T23:17:20.237800+00:00 8281.4 81.6163
exp_2022_12_02_15 200 lion 11 1670023040.2428002 2022-12-02T23:17:20.242800+00:00 7319.51 81.7052
exp_2022_12_02_15 200 lion 12 1670023040.2478 2022-12-02T23:17:20.247800+00:00 24615.7 81.7929
exp_2022_12_02_15 200 lion 13 1670023040.2528002 2022-12-02T23:17:20.252800+00:00 15643.2 81.8795
exp_2022_12_02_15 200 lion 14 1670023040.2578 2022-12-02T23:17:20.257800+00:00 4090.48 81.9647
exp_2022_12_02_15 200 lion 15 1670023040.2628002 2022-12-02T23:17:20.262800+00:00 20143.5 82.0487
exp_2022_12_02_15 200 lion 16 1670023040.2678 2022-12-02T23:17:20.267800+00:00 21880.3 82.1313
exp_2022_12_02_15 200 lion 17 1670023040.2728002 2022-12-02T23:17:20.272800+00:00 4748.71 82.2126
exp_2022_12_02_15 200 lion 18 1670023040.2778 2022-12-02T23:17:20.277800+00:00 13971.3 82.2924
exp_2022_12_02_15 200 lion 19 1670023040.2828002 2022-12-02T23:17:20.282800+00:00 25982.5 82.3707
exp_2022_12_02_15 200 lion 20 1670023040.2878 2022-12-02T23:17:20.287800+00:00 9901.33 82.4475
exp_2022_12_02_15 200 lion 21 1670023040.2928002 2022-12-02T23:17:20.292800+00:00 7918.68 82.5227
exp_2022_12_02_15 200 lion 22 1670023040.2978 2022-12-02T23:17:20.297800+00:00 24156.1 82.5962
exp_2022_12_02_15 200 lion 23 1670023040.3028002 2022-12-02T23:17:20.302800+00:00 13545.0 82.6681
exp_2022_12_02_15 200 lion 24 1670023040.3078 2022-12-02T23:17:20.307800+00:00 -763.991 82.7382
exp_2022_12_02_15 200 lion 25 1670023040.3128002 2022-12-02T23:17:20.312800+00:00 12820.3 82.8066
exp_2022_12_02_15 200 lion 26 1670023040.3178003 2022-12-02T23:17:20.317800+00:00 12911.7 82.8731
exp_2022_12_02_15 200 lion 27 1670023040.3228002 2022-12-02T23:17:20.322800+00:00 -5134.77 82.9377
exp_2022_12_02_15 200 lion 28 1670023040.3278003 2022-12-02T23:17:20.327800+00:00 4374.76 83.0004
exp_2022_12_02_15 200 lion 29 1670023040.3328001 2022-12-02T23:17:20.332800+00:00 17425.6 83.0611
exp_2022_12_02_15 200 lion 30 1670023040.3378003 2022-12-02T23:17:20.337800+00:00 2464.53 83.1198
exp_2022_12_02_15 200 lion 31 1670023040.3428001 2022-12-02T23:17:20.342800+00:00 1644.32 83.1764
exp_2022_12_02_15 200 lion 32 1670023040.3478003 2022-12-02T23:17:20.347800+00:00 19490.3 83.2309
exp_2022_12_02_15 200 lion 33 1670023040.3528001 2022-12-02T23:17:20.352800+00:00 11718.7 83.2832
exp_2022_12_02_15 200 lion 34 1670023040.3578002 2022-12-02T23:17:20.357800+00:00 1134.12 83.3332
exp_2022_12_02_15 200 lion 35 1670023040.3628001 2022-12-02T23:17:20.362800+00:00 18650.6 83.381
exp_2022_12_02_15 200 lion 36 1670023040.3678002 2022-12-02T23:17:20.367800+00:00 22741.5 83.4265
exp_2022_12_02_15 200 lion 37 1670023040.3728 2022-12-02T23:17:20.372800+00:00 7529.41 83.4696
exp_2022_12_02_15 200 lion 38 1670023040.3778002 2022-12-02T23:17:20.377800+00:00 17985.9 83.5102
exp_2022_12_02_15 200 lion 39 1670023040.3828 2022-12-02T23:17:20.382800+00:00 31393.9 83.5484
exp_2022_12_02_15 200 lion 40 1670023040.3878002 2022-12-02T23:17:20.387800+00:00 16381.1 83.5841
exp_2022_12_02_15 200 lion 41 1670023040.3928 2022-12-02T23:17:20.392800+00:00 14574.3 83.6172
exp_2022_12_02_15 200 lion 42 1670023040.3978002 2022-12-02T23:17:20.397800+00:00 31519.4 83.6477
exp_2022_12_02_15 200 lion 43 1670023040.4028 2022-12-02T23:17:20.402800+00:00 22691.1 83.6755
exp_2022_12_02_15 200 lion 44 1670023040.4078002 2022-12-02T23:17:20.407800+00:00 9852.54 83.7007
exp_2022_12_02_15 200 lion 45 1670023040.4128 2022-12-02T23:17:20.412800+00:00 24598.3 83.723
exp_2022_12_02_15 200 lion 46 1670023040.4178002 2022-12-02T23:17:20.417800+00:00 26155.4 83.7426
exp_2022_12_02_15 200 lion 47 1670023040.4228 2022-12-02T23:17:20.422800+00:00 8250.8 83.7594
exp_2022_12_02_15 200 lion 48 1670023040.4278002 2022-12-02T23:17:20.427800+00:00 16799.8 83.7732
exp_2022_12_02_15 200 lion 49 1670023040.4328 2022-12-02T23:17:20.432800+00:00 30513.4 83.7841
exp_2022_12_02_15 200 lion 50 1670023040.4378002 2022-12-02T23:17:20.437800+00:00 16841.5 83.7921
exp_2022_12_02_15 200 lion 51 1670023040.4428003 2022-12-02T23:17:20.442800+00:00 15340.1 83.797
exp_2022_12_02_15 200 lion 52 1670023040.4478002 2022-12-02T23:17:20.447800+00:00 28905.1 83.7989
exp_2022_12_02_15 200 lion 53 1670023040.4528003 2022-12-02T23:17:20.452800+00:00 8356.06 83.798
exp_2022_12_02_15 200 lion 54 1670023040.4578001 2022-12-02T23:17:20.457800+00:00 -29188.1 83.7948
exp_2022_12_02_15 200 lion 55 1670023040.4628003 2022-12-02T23:17:20.462800+00:00 -51538.5 83.7895
exp_2022_12_02_15 200 lion 56 1670023040.4678001 2022-12-02T23:17:20.467800+00:00 -94181.7 83.782
exp_2022_12_02_15 200 lion 57 1670023040.4728003 2022-12-02T23:17:20.472800+00:00 -152298.0 83.7723
exp_2022_12_02_15 200 lion 58 1670023040.4778001 2022-12-02T23:17:20.477800+00:00 -164568.0 83.7605
exp_2022_12_02_15 200 lion 59 1670023040.4828002 2022-12-02T23:17:20.482800+00:00 -143782.0 83.7465
exp_2022_12_02_15 200 lion 60 1670023040.4878001 2022-12-02T23:17:20.487800+00:00 -125498.0 83.7306
exp_2022_12_02_15 200 lion 61 1670023040.4928002 2022-12-02T23:17:20.492800+00:00 -82235.1 83.7126
exp_2022_12_02_15 200 lion 62 1670023040.4978 2022-12-02T23:17:20.497800+00:00 -24579.9 83.6925
exp_2022_12_02_15 200 lion 63 1670023040.5028002 2022-12-02T23:17:20.502800+00:00 -7645.62 83.6706
exp_2022_12_02_15 200 lion 64 1670023040.5078 2022-12-02T23:17:20.507800+00:00 -9898.58 83.6466
exp_2022_12_02_15 200 lion 65 1670023040.5128002 2022-12-02T23:17:20.512800+00:00 7893.75 83.6208
exp_2022_12_02_15 200 lion 66 1670023040.5178 2022-12-02T23:17:20.517800+00:00 11557.7 83.5931
exp_2022_12_02_15 200 lion 67 1670023040.5228002 2022-12-02T23:17:20.522800+00:00 -4277.99 83.5635
exp_2022_12_02_15 200 lion 68 1670023040.5278 2022-12-02T23:17:20.527800+00:00 5889.98 83.5321
exp_2022_12_02_15 200 lion 69 1670023040.5328002 2022-12-02T23:17:20.532800+00:00 20576.6 83.499
exp_2022_12_02_15 200 lion 70 1670023040.5378 2022-12-02T23:17:20.537800+00:00 6065.17 83.464
exp_2022_12_02_15 200 lion 71 1670023040.5428002 2022-12-02T23:17:20.542800+00:00 3708.76 83.4274
exp_2022_12_02_15 200 lion 72 1670023040.5478 2022-12-02T23:17:20.547800+00:00 21343.8 83.3891
exp_2022_12_02_15 200 lion 73 1670023040.5528002 2022-12-02T23:17:20.552800+00:00 13306.2 83.3491
exp_2022_12_02_15 200 lion 74 1670023040.5578 2022-12-02T23:17:20.557800+00:00 43.417 83.3075
exp_2022_12_02_15 200 lion 75 1670023040.5628002 2022-12-02T23:17:20.562800+00:00 15232.8 83.2643
exp_2022_12_02_15 200 lion 76 1670023040.5678003 2022-12-02T23:17:20.567800+00:00 18091.9 83.2196
exp_2022_12_02_15 200 lion 77 1670023040.5728002 2022-12-02T23:17:20.572800+00:00 243.477 83.1733
exp_2022_12_02_15 200 lion 78 1670023040.5778003 2022-12-02T23:17:20.577800+00:00 7644.49 83.1256
exp_2022_12_02_15 200 lion 79 1670023040.5828001 2022-12-02T23:17:20.582800+00:00 20091.5 83.0763
exp_2022_12_02_15 200 lion 80 1670023040.5878003 2022-12-02T23:17:20.587800+00:00 4223.83 83.0257
exp_2022_12_02_15 200 lion 81 1670023040.5928001 2022-12-02T23:17:20.592800+00:00 539.87 82.9737
exp_2022_12_02_15 200 lion 82 1670023040.5978003 2022-12-02T23:17:20.597800+00:00 17362.3 82.9203
exp_2022_12_02_15 200 lion 83 1670023040.6028001 2022-12-02T23:17:20.602800+00:00 9306.32 82.8656
exp_2022_12_02_15 200 lion 84 1670023040.6078002 2022-12-02T23:17:20.607800+00:00 -4406.46 82.8095
exp_2022_12_02_15 200 lion 85 1670023040.6128001 2022-12-02T23:17:20.612800+00:00 9961.36 82.7523
exp_2022_12_02_15 200 lion 86 1670023040.6178002 2022-12-02T23:17:20.617800+00:00 12402.8 82.6938
exp_2022_12_02_15 200 lion 87 1670023040.6228 2022-12-02T23:17:20.622800+00:00 -6380.85 82.6341
exp_2022_12_02_15 200 lion 88 1670023040.6278002 2022-12-02T23:17:20.627800+00:00 -349.591 82.5732
exp_2022_12_02_15 200 lion 89 1670023040.6328 2022-12-02T23:17:20.632800+00:00 11209.6 82.5112
exp_2022_12_02_15 200 lion 90 1670023040.6378002 2022-12-02T23:17:20.637800+00:00 -5679.0 82.4481
exp_2022_12_02_15 200 lion 91 1670023040.6428 2022-12-02T23:17:20.642800+00:00 -10964.8 82.384
exp_2022_12_02_15 200 lion 92 1670023040.6478002 2022-12-02T23:17:20.647800+00:00 4360.27 82.3188
exp_2022_12_02_15 200 lion 93 1670023040.6528 2022-12-02T23:17:20.652800+00:00 -5172.32 82.2526
exp_2022_12_02_15 200 lion 94 1670023040.6578002 2022-12-02T23:17:20.657800+00:00 -20964.9 82.1854
exp_2022_12_02_15 200 lion 95 1670023040.6628 2022-12-02T23:17:20.662800+00:00 -8720.62 82.1174
exp_2022_12_02_15 200 lion 96 1670023040.6678002 2022-12-02T23:17:20.667800+00:00 -7924.99 82.0484
exp_2022_12_02_15 200 lion 97 1670023040.6728 2022-12-02T23:17:20.672800+00:00 -28415.0 81.9785
exp_2022_12_02_15 200 lion 98 1670023040.6778002 2022-12-02T23:17:20.677800+00:00 -24100.3 81.9078
exp_2022_12_02_15 200 lion 99 1670023040.6828 2022-12-02T23:17:20.682800+00:00 -13566.8 81.8363

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