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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_10_28_10 200 leopard 0 1666980592.5989792 2022-10-28T18:09:52.598979+00:00 515025.0
exp_2022_10_28_10 200 leopard 1 1666980592.6039793 2022-10-28T18:09:52.603979+00:00 515013.0
exp_2022_10_28_10 200 leopard 2 1666980592.6089792 2022-10-28T18:09:52.608979+00:00 515001.0
exp_2022_10_28_10 200 leopard 3 1666980592.6139793 2022-10-28T18:09:52.613979+00:00 514989.0
exp_2022_10_28_10 200 leopard 4 1666980592.6189792 2022-10-28T18:09:52.618979+00:00 514977.0
exp_2022_10_28_10 200 leopard 5 1666980592.6239793 2022-10-28T18:09:52.623979+00:00 514965.0
exp_2022_10_28_10 200 leopard 6 1666980592.6289792 2022-10-28T18:09:52.628979+00:00 514953.0
exp_2022_10_28_10 200 leopard 7 1666980592.6339793 2022-10-28T18:09:52.633979+00:00 514941.0
exp_2022_10_28_10 200 leopard 8 1666980592.6389792 2022-10-28T18:09:52.638979+00:00 514930.0
exp_2022_10_28_10 200 leopard 9 1666980592.6439793 2022-10-28T18:09:52.643979+00:00 514918.0
exp_2022_10_28_10 200 leopard 10 1666980592.6489792 2022-10-28T18:09:52.648979+00:00 514905.0
exp_2022_10_28_10 200 leopard 11 1666980592.6539793 2022-10-28T18:09:52.653979+00:00 514893.0
exp_2022_10_28_10 200 leopard 12 1666980592.6589792 2022-10-28T18:09:52.658979+00:00 514882.0
exp_2022_10_28_10 200 leopard 13 1666980592.6639793 2022-10-28T18:09:52.663979+00:00 514870.0
exp_2022_10_28_10 200 leopard 14 1666980592.6689792 2022-10-28T18:09:52.668979+00:00 514857.0
exp_2022_10_28_10 200 leopard 15 1666980592.6739793 2022-10-28T18:09:52.673979+00:00 514845.0
exp_2022_10_28_10 200 leopard 16 1666980592.6789792 2022-10-28T18:09:52.678979+00:00 514834.0
exp_2022_10_28_10 200 leopard 17 1666980592.6839793 2022-10-28T18:09:52.683979+00:00 514822.0
exp_2022_10_28_10 200 leopard 18 1666980592.6889791 2022-10-28T18:09:52.688979+00:00 514809.0
exp_2022_10_28_10 200 leopard 19 1666980592.6939793 2022-10-28T18:09:52.693979+00:00 514797.0
exp_2022_10_28_10 200 leopard 20 1666980592.6989791 2022-10-28T18:09:52.698979+00:00 514786.0
exp_2022_10_28_10 200 leopard 21 1666980592.7039793 2022-10-28T18:09:52.703979+00:00 514774.0
exp_2022_10_28_10 200 leopard 22 1666980592.7089791 2022-10-28T18:09:52.708979+00:00 514762.0
exp_2022_10_28_10 200 leopard 23 1666980592.7139792 2022-10-28T18:09:52.713979+00:00 514750.0
exp_2022_10_28_10 200 leopard 24 1666980592.7189791 2022-10-28T18:09:52.718979+00:00 514739.0
exp_2022_10_28_10 200 leopard 25 1666980592.7239792 2022-10-28T18:09:52.723979+00:00 514728.0
exp_2022_10_28_10 200 leopard 26 1666980592.7289793 2022-10-28T18:09:52.728979+00:00 514716.0
exp_2022_10_28_10 200 leopard 27 1666980592.7339792 2022-10-28T18:09:52.733979+00:00 514705.0
exp_2022_10_28_10 200 leopard 28 1666980592.7389793 2022-10-28T18:09:52.738979+00:00 514694.0
exp_2022_10_28_10 200 leopard 29 1666980592.7439792 2022-10-28T18:09:52.743979+00:00 514683.0
exp_2022_10_28_10 200 leopard 30 1666980592.7489793 2022-10-28T18:09:52.748979+00:00 514671.0
exp_2022_10_28_10 200 leopard 31 1666980592.7539792 2022-10-28T18:09:52.753979+00:00 514660.0
exp_2022_10_28_10 200 leopard 32 1666980592.7589793 2022-10-28T18:09:52.758979+00:00 514650.0
exp_2022_10_28_10 200 leopard 33 1666980592.7639792 2022-10-28T18:09:52.763979+00:00 514640.0
exp_2022_10_28_10 200 leopard 34 1666980592.7689793 2022-10-28T18:09:52.768979+00:00 514629.0
exp_2022_10_28_10 200 leopard 35 1666980592.7739792 2022-10-28T18:09:52.773979+00:00 514619.0
exp_2022_10_28_10 200 leopard 36 1666980592.7789793 2022-10-28T18:09:52.778979+00:00 514609.0
exp_2022_10_28_10 200 leopard 37 1666980592.7839792 2022-10-28T18:09:52.783979+00:00 514599.0
exp_2022_10_28_10 200 leopard 38 1666980592.7889793 2022-10-28T18:09:52.788979+00:00 514589.0
exp_2022_10_28_10 200 leopard 39 1666980592.7939792 2022-10-28T18:09:52.793979+00:00 514580.0
exp_2022_10_28_10 200 leopard 40 1666980592.7989793 2022-10-28T18:09:52.798979+00:00 514571.0
exp_2022_10_28_10 200 leopard 41 1666980592.8039792 2022-10-28T18:09:52.803979+00:00 514562.0
exp_2022_10_28_10 200 leopard 42 1666980592.8089793 2022-10-28T18:09:52.808979+00:00 514552.0
exp_2022_10_28_10 200 leopard 43 1666980592.8139791 2022-10-28T18:09:52.813979+00:00 514543.0
exp_2022_10_28_10 200 leopard 44 1666980592.8189793 2022-10-28T18:09:52.818979+00:00 514535.0
exp_2022_10_28_10 200 leopard 45 1666980592.8239791 2022-10-28T18:09:52.823979+00:00 514527.0
exp_2022_10_28_10 200 leopard 46 1666980592.8289793 2022-10-28T18:09:52.828979+00:00 514518.0
exp_2022_10_28_10 200 leopard 47 1666980592.8339791 2022-10-28T18:09:52.833979+00:00 514510.0
exp_2022_10_28_10 200 leopard 48 1666980592.8389792 2022-10-28T18:09:52.838979+00:00 514503.0
exp_2022_10_28_10 200 leopard 49 1666980592.8439791 2022-10-28T18:09:52.843979+00:00 514495.0
exp_2022_10_28_10 200 leopard 50 1666980592.8489792 2022-10-28T18:09:52.848979+00:00 514487.0
exp_2022_10_28_10 200 leopard 51 1666980592.8539793 2022-10-28T18:09:52.853979+00:00 514480.0
exp_2022_10_28_10 200 leopard 52 1666980592.8589792 2022-10-28T18:09:52.858979+00:00 514473.0
exp_2022_10_28_10 200 leopard 53 1666980592.8639793 2022-10-28T18:09:52.863979+00:00 514466.0
exp_2022_10_28_10 200 leopard 54 1666980592.8689792 2022-10-28T18:09:52.868979+00:00 514458.0
exp_2022_10_28_10 200 leopard 55 1666980592.8739793 2022-10-28T18:09:52.873979+00:00 514451.0
exp_2022_10_28_10 200 leopard 56 1666980592.8789792 2022-10-28T18:09:52.878979+00:00 514445.0
exp_2022_10_28_10 200 leopard 57 1666980592.8839793 2022-10-28T18:09:52.883979+00:00 514438.0
exp_2022_10_28_10 200 leopard 58 1666980592.8889792 2022-10-28T18:09:52.888979+00:00 514430.0
exp_2022_10_28_10 200 leopard 59 1666980592.8939793 2022-10-28T18:09:52.893979+00:00 514423.0
exp_2022_10_28_10 200 leopard 60 1666980592.8989792 2022-10-28T18:09:52.898979+00:00 514417.0
exp_2022_10_28_10 200 leopard 61 1666980592.9039793 2022-10-28T18:09:52.903979+00:00 514410.0
exp_2022_10_28_10 200 leopard 62 1666980592.9089792 2022-10-28T18:09:52.908979+00:00 514402.0
exp_2022_10_28_10 200 leopard 63 1666980592.9139793 2022-10-28T18:09:52.913979+00:00 514396.0
exp_2022_10_28_10 200 leopard 64 1666980592.9189792 2022-10-28T18:09:52.918979+00:00 514389.0
exp_2022_10_28_10 200 leopard 65 1666980592.9239793 2022-10-28T18:09:52.923979+00:00 514382.0
exp_2022_10_28_10 200 leopard 66 1666980592.9289792 2022-10-28T18:09:52.928979+00:00 514374.0
exp_2022_10_28_10 200 leopard 67 1666980592.9339793 2022-10-28T18:09:52.933979+00:00 514366.0
exp_2022_10_28_10 200 leopard 68 1666980592.9389791 2022-10-28T18:09:52.938979+00:00 514359.0
exp_2022_10_28_10 200 leopard 69 1666980592.9439793 2022-10-28T18:09:52.943979+00:00 514351.0
exp_2022_10_28_10 200 leopard 70 1666980592.9489791 2022-10-28T18:09:52.948979+00:00 514343.0
exp_2022_10_28_10 200 leopard 71 1666980592.9539793 2022-10-28T18:09:52.953979+00:00 514335.0
exp_2022_10_28_10 200 leopard 72 1666980592.9589791 2022-10-28T18:09:52.958979+00:00 514327.0
exp_2022_10_28_10 200 leopard 73 1666980592.9639792 2022-10-28T18:09:52.963979+00:00 514318.0
exp_2022_10_28_10 200 leopard 74 1666980592.9689791 2022-10-28T18:09:52.968979+00:00 514308.0
exp_2022_10_28_10 200 leopard 75 1666980592.9739792 2022-10-28T18:09:52.973979+00:00 514299.0
exp_2022_10_28_10 200 leopard 76 1666980592.9789793 2022-10-28T18:09:52.978979+00:00 514290.0
exp_2022_10_28_10 200 leopard 77 1666980592.9839792 2022-10-28T18:09:52.983979+00:00 514281.0
exp_2022_10_28_10 200 leopard 78 1666980592.9889793 2022-10-28T18:09:52.988979+00:00 514270.0
exp_2022_10_28_10 200 leopard 79 1666980592.9939792 2022-10-28T18:09:52.993979+00:00 514260.0
exp_2022_10_28_10 200 leopard 80 1666980592.9989793 2022-10-28T18:09:52.998979+00:00 514251.0
exp_2022_10_28_10 200 leopard 81 1666980593.0039792 2022-10-28T18:09:53.003979+00:00 514240.0
exp_2022_10_28_10 200 leopard 82 1666980593.0089793 2022-10-28T18:09:53.008979+00:00 514229.0
exp_2022_10_28_10 200 leopard 83 1666980593.0139792 2022-10-28T18:09:53.013979+00:00 514218.0
exp_2022_10_28_10 200 leopard 84 1666980593.0189793 2022-10-28T18:09:53.018979+00:00 514207.0
exp_2022_10_28_10 200 leopard 85 1666980593.0239792 2022-10-28T18:09:53.023979+00:00 514196.0
exp_2022_10_28_10 200 leopard 86 1666980593.0289793 2022-10-28T18:09:53.028979+00:00 514184.0
exp_2022_10_28_10 200 leopard 87 1666980593.0339792 2022-10-28T18:09:53.033979+00:00 514172.0
exp_2022_10_28_10 200 leopard 88 1666980593.0389793 2022-10-28T18:09:53.038979+00:00 514161.0
exp_2022_10_28_10 200 leopard 89 1666980593.0439792 2022-10-28T18:09:53.043979+00:00 514149.0
exp_2022_10_28_10 200 leopard 90 1666980593.0489793 2022-10-28T18:09:53.048979+00:00 514137.0
exp_2022_10_28_10 200 leopard 91 1666980593.0539792 2022-10-28T18:09:53.053979+00:00 514125.0
exp_2022_10_28_10 200 leopard 92 1666980593.0589793 2022-10-28T18:09:53.058979+00:00 514114.0
exp_2022_10_28_10 200 leopard 93 1666980593.0639791 2022-10-28T18:09:53.063979+00:00 514102.0
exp_2022_10_28_10 200 leopard 94 1666980593.0689793 2022-10-28T18:09:53.068979+00:00 514089.0
exp_2022_10_28_10 200 leopard 95 1666980593.0739791 2022-10-28T18:09:53.073979+00:00 514077.0
exp_2022_10_28_10 200 leopard 96 1666980593.0789793 2022-10-28T18:09:53.078979+00:00 514066.0
exp_2022_10_28_10 200 leopard 97 1666980593.0839791 2022-10-28T18:09:53.083979+00:00 514054.0
exp_2022_10_28_10 200 leopard 98 1666980593.0889792 2022-10-28T18:09:53.088979+00:00 514042.0
exp_2022_10_28_10 200 leopard 99 1666980593.0939791 2022-10-28T18:09:53.093979+00:00 514030.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]);