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_gsr
value of the gsr channel.

where group_session = "exp_2022_10_21_15"

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_10_21_15 200 leopard 0 1666394101.7185602 2022-10-21T23:15:01.718560+00:00 281687.0
exp_2022_10_21_15 200 leopard 1 1666394101.7235603 2022-10-21T23:15:01.723560+00:00 281684.0
exp_2022_10_21_15 200 leopard 2 1666394101.7285602 2022-10-21T23:15:01.728560+00:00 281682.0
exp_2022_10_21_15 200 leopard 3 1666394101.7335603 2022-10-21T23:15:01.733560+00:00 281679.0
exp_2022_10_21_15 200 leopard 4 1666394101.7385602 2022-10-21T23:15:01.738560+00:00 281677.0
exp_2022_10_21_15 200 leopard 5 1666394101.7435603 2022-10-21T23:15:01.743560+00:00 281674.0
exp_2022_10_21_15 200 leopard 6 1666394101.7485602 2022-10-21T23:15:01.748560+00:00 281672.0
exp_2022_10_21_15 200 leopard 7 1666394101.7535603 2022-10-21T23:15:01.753560+00:00 281670.0
exp_2022_10_21_15 200 leopard 8 1666394101.7585602 2022-10-21T23:15:01.758560+00:00 281667.0
exp_2022_10_21_15 200 leopard 9 1666394101.7635603 2022-10-21T23:15:01.763560+00:00 281665.0
exp_2022_10_21_15 200 leopard 10 1666394101.7685602 2022-10-21T23:15:01.768560+00:00 281662.0
exp_2022_10_21_15 200 leopard 11 1666394101.7735603 2022-10-21T23:15:01.773560+00:00 281660.0
exp_2022_10_21_15 200 leopard 12 1666394101.7785602 2022-10-21T23:15:01.778560+00:00 281658.0
exp_2022_10_21_15 200 leopard 13 1666394101.7835603 2022-10-21T23:15:01.783560+00:00 281655.0
exp_2022_10_21_15 200 leopard 14 1666394101.7885602 2022-10-21T23:15:01.788560+00:00 281653.0
exp_2022_10_21_15 200 leopard 15 1666394101.7935603 2022-10-21T23:15:01.793560+00:00 281650.0
exp_2022_10_21_15 200 leopard 16 1666394101.7985601 2022-10-21T23:15:01.798560+00:00 281648.0
exp_2022_10_21_15 200 leopard 17 1666394101.8035603 2022-10-21T23:15:01.803560+00:00 281645.0
exp_2022_10_21_15 200 leopard 18 1666394101.8085601 2022-10-21T23:15:01.808560+00:00 281643.0
exp_2022_10_21_15 200 leopard 19 1666394101.8135602 2022-10-21T23:15:01.813560+00:00 281641.0
exp_2022_10_21_15 200 leopard 20 1666394101.8185601 2022-10-21T23:15:01.818560+00:00 281638.0
exp_2022_10_21_15 200 leopard 21 1666394101.8235602 2022-10-21T23:15:01.823560+00:00 281636.0
exp_2022_10_21_15 200 leopard 22 1666394101.82856 2022-10-21T23:15:01.828560+00:00 281633.0
exp_2022_10_21_15 200 leopard 23 1666394101.8335602 2022-10-21T23:15:01.833560+00:00 281631.0
exp_2022_10_21_15 200 leopard 24 1666394101.83856 2022-10-21T23:15:01.838560+00:00 281629.0
exp_2022_10_21_15 200 leopard 25 1666394101.8435602 2022-10-21T23:15:01.843560+00:00 281626.0
exp_2022_10_21_15 200 leopard 26 1666394101.8485603 2022-10-21T23:15:01.848560+00:00 281624.0
exp_2022_10_21_15 200 leopard 27 1666394101.8535602 2022-10-21T23:15:01.853560+00:00 281621.0
exp_2022_10_21_15 200 leopard 28 1666394101.8585603 2022-10-21T23:15:01.858560+00:00 281619.0
exp_2022_10_21_15 200 leopard 29 1666394101.8635602 2022-10-21T23:15:01.863560+00:00 281616.0
exp_2022_10_21_15 200 leopard 30 1666394101.8685603 2022-10-21T23:15:01.868560+00:00 281614.0
exp_2022_10_21_15 200 leopard 31 1666394101.8735602 2022-10-21T23:15:01.873560+00:00 281611.0
exp_2022_10_21_15 200 leopard 32 1666394101.8785603 2022-10-21T23:15:01.878560+00:00 281609.0
exp_2022_10_21_15 200 leopard 33 1666394101.8835602 2022-10-21T23:15:01.883560+00:00 281606.0
exp_2022_10_21_15 200 leopard 34 1666394101.8885603 2022-10-21T23:15:01.888560+00:00 281604.0
exp_2022_10_21_15 200 leopard 35 1666394101.8935602 2022-10-21T23:15:01.893560+00:00 281601.0
exp_2022_10_21_15 200 leopard 36 1666394101.8985603 2022-10-21T23:15:01.898560+00:00 281599.0
exp_2022_10_21_15 200 leopard 37 1666394101.9035602 2022-10-21T23:15:01.903560+00:00 281596.0
exp_2022_10_21_15 200 leopard 38 1666394101.9085603 2022-10-21T23:15:01.908560+00:00 281594.0
exp_2022_10_21_15 200 leopard 39 1666394101.9135602 2022-10-21T23:15:01.913560+00:00 281591.0
exp_2022_10_21_15 200 leopard 40 1666394101.9185603 2022-10-21T23:15:01.918560+00:00 281589.0
exp_2022_10_21_15 200 leopard 41 1666394101.9235601 2022-10-21T23:15:01.923560+00:00 281586.0
exp_2022_10_21_15 200 leopard 42 1666394101.9285603 2022-10-21T23:15:01.928560+00:00 281583.0
exp_2022_10_21_15 200 leopard 43 1666394101.9335601 2022-10-21T23:15:01.933560+00:00 281581.0
exp_2022_10_21_15 200 leopard 44 1666394101.9385602 2022-10-21T23:15:01.938560+00:00 281579.0
exp_2022_10_21_15 200 leopard 45 1666394101.9435601 2022-10-21T23:15:01.943560+00:00 281576.0
exp_2022_10_21_15 200 leopard 46 1666394101.9485602 2022-10-21T23:15:01.948560+00:00 281573.0
exp_2022_10_21_15 200 leopard 47 1666394101.95356 2022-10-21T23:15:01.953560+00:00 281571.0
exp_2022_10_21_15 200 leopard 48 1666394101.9585602 2022-10-21T23:15:01.958560+00:00 281568.0
exp_2022_10_21_15 200 leopard 49 1666394101.96356 2022-10-21T23:15:01.963560+00:00 281566.0
exp_2022_10_21_15 200 leopard 50 1666394101.9685602 2022-10-21T23:15:01.968560+00:00 281563.0
exp_2022_10_21_15 200 leopard 51 1666394101.9735603 2022-10-21T23:15:01.973560+00:00 281561.0
exp_2022_10_21_15 200 leopard 52 1666394101.9785602 2022-10-21T23:15:01.978560+00:00 281558.0
exp_2022_10_21_15 200 leopard 53 1666394101.9835603 2022-10-21T23:15:01.983560+00:00 281555.0
exp_2022_10_21_15 200 leopard 54 1666394101.9885602 2022-10-21T23:15:01.988560+00:00 281553.0
exp_2022_10_21_15 200 leopard 55 1666394101.9935603 2022-10-21T23:15:01.993560+00:00 281550.0
exp_2022_10_21_15 200 leopard 56 1666394101.9985602 2022-10-21T23:15:01.998560+00:00 281548.0
exp_2022_10_21_15 200 leopard 57 1666394102.0035603 2022-10-21T23:15:02.003560+00:00 281545.0
exp_2022_10_21_15 200 leopard 58 1666394102.0085602 2022-10-21T23:15:02.008560+00:00 281542.0
exp_2022_10_21_15 200 leopard 59 1666394102.0135603 2022-10-21T23:15:02.013560+00:00 281540.0
exp_2022_10_21_15 200 leopard 60 1666394102.0185602 2022-10-21T23:15:02.018560+00:00 281537.0
exp_2022_10_21_15 200 leopard 61 1666394102.0235603 2022-10-21T23:15:02.023560+00:00 281534.0
exp_2022_10_21_15 200 leopard 62 1666394102.0285602 2022-10-21T23:15:02.028560+00:00 281532.0
exp_2022_10_21_15 200 leopard 63 1666394102.0335603 2022-10-21T23:15:02.033560+00:00 281529.0
exp_2022_10_21_15 200 leopard 64 1666394102.0385602 2022-10-21T23:15:02.038560+00:00 281527.0
exp_2022_10_21_15 200 leopard 65 1666394102.0435603 2022-10-21T23:15:02.043560+00:00 281524.0
exp_2022_10_21_15 200 leopard 66 1666394102.0485601 2022-10-21T23:15:02.048560+00:00 281521.0
exp_2022_10_21_15 200 leopard 67 1666394102.0535603 2022-10-21T23:15:02.053560+00:00 281519.0
exp_2022_10_21_15 200 leopard 68 1666394102.0585601 2022-10-21T23:15:02.058560+00:00 281516.0
exp_2022_10_21_15 200 leopard 69 1666394102.0635602 2022-10-21T23:15:02.063560+00:00 281513.0
exp_2022_10_21_15 200 leopard 70 1666394102.0685601 2022-10-21T23:15:02.068560+00:00 281510.0
exp_2022_10_21_15 200 leopard 71 1666394102.0735602 2022-10-21T23:15:02.073560+00:00 281508.0
exp_2022_10_21_15 200 leopard 72 1666394102.07856 2022-10-21T23:15:02.078560+00:00 281505.0
exp_2022_10_21_15 200 leopard 73 1666394102.0835602 2022-10-21T23:15:02.083560+00:00 281502.0
exp_2022_10_21_15 200 leopard 74 1666394102.08856 2022-10-21T23:15:02.088560+00:00 281499.0
exp_2022_10_21_15 200 leopard 75 1666394102.0935602 2022-10-21T23:15:02.093560+00:00 281497.0
exp_2022_10_21_15 200 leopard 76 1666394102.0985603 2022-10-21T23:15:02.098560+00:00 281494.0
exp_2022_10_21_15 200 leopard 77 1666394102.1035602 2022-10-21T23:15:02.103560+00:00 281491.0
exp_2022_10_21_15 200 leopard 78 1666394102.1085603 2022-10-21T23:15:02.108560+00:00 281488.0
exp_2022_10_21_15 200 leopard 79 1666394102.1135602 2022-10-21T23:15:02.113560+00:00 281486.0
exp_2022_10_21_15 200 leopard 80 1666394102.1185603 2022-10-21T23:15:02.118560+00:00 281483.0
exp_2022_10_21_15 200 leopard 81 1666394102.1235602 2022-10-21T23:15:02.123560+00:00 281480.0
exp_2022_10_21_15 200 leopard 82 1666394102.1285603 2022-10-21T23:15:02.128560+00:00 281477.0
exp_2022_10_21_15 200 leopard 83 1666394102.1335602 2022-10-21T23:15:02.133560+00:00 281474.0
exp_2022_10_21_15 200 leopard 84 1666394102.1385603 2022-10-21T23:15:02.138560+00:00 281472.0
exp_2022_10_21_15 200 leopard 85 1666394102.1435602 2022-10-21T23:15:02.143560+00:00 281469.0
exp_2022_10_21_15 200 leopard 86 1666394102.1485603 2022-10-21T23:15:02.148560+00:00 281466.0
exp_2022_10_21_15 200 leopard 87 1666394102.1535602 2022-10-21T23:15:02.153560+00:00 281463.0
exp_2022_10_21_15 200 leopard 88 1666394102.1585603 2022-10-21T23:15:02.158560+00:00 281460.0
exp_2022_10_21_15 200 leopard 89 1666394102.1635602 2022-10-21T23:15:02.163560+00:00 281457.0
exp_2022_10_21_15 200 leopard 90 1666394102.1685603 2022-10-21T23:15:02.168560+00:00 281454.0
exp_2022_10_21_15 200 leopard 91 1666394102.1735601 2022-10-21T23:15:02.173560+00:00 281452.0
exp_2022_10_21_15 200 leopard 92 1666394102.1785603 2022-10-21T23:15:02.178560+00:00 281449.0
exp_2022_10_21_15 200 leopard 93 1666394102.1835601 2022-10-21T23:15:02.183560+00:00 281446.0
exp_2022_10_21_15 200 leopard 94 1666394102.1885602 2022-10-21T23:15:02.188560+00:00 281443.0
exp_2022_10_21_15 200 leopard 95 1666394102.1935601 2022-10-21T23:15:02.193560+00:00 281441.0
exp_2022_10_21_15 200 leopard 96 1666394102.1985602 2022-10-21T23:15:02.198560+00:00 281438.0
exp_2022_10_21_15 200 leopard 97 1666394102.20356 2022-10-21T23:15:02.203560+00:00 281435.0
exp_2022_10_21_15 200 leopard 98 1666394102.2085602 2022-10-21T23:15:02.208560+00:00 281432.0
exp_2022_10_21_15 200 leopard 99 1666394102.21356 2022-10-21T23:15:02.213560+00:00 281429.0

Next page

Advanced export

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

CSV options:

CREATE TABLE "gsr_sync" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [frequency] INTEGER,
   [station] TEXT REFERENCES [station]([id]),
   [id] INTEGER,
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [gsr] FLOAT,
   PRIMARY KEY ([group_session], [frequency], [station], [id])
);
CREATE INDEX [idx_gsr_sync_station]
    ON [gsr_sync] ([station]);
CREATE INDEX [idx_gsr_sync_group_session]
    ON [gsr_sync] ([group_session]);