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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_02_20_01 200 leopard 0 1676927618.301412 2023-02-20T21:13:38.301412+00:00 269028.0
exp_2023_02_20_01 200 leopard 1 1676927618.3064122 2023-02-20T21:13:38.306412+00:00 269026.0
exp_2023_02_20_01 200 leopard 2 1676927618.311412 2023-02-20T21:13:38.311412+00:00 269024.0
exp_2023_02_20_01 200 leopard 3 1676927618.3164122 2023-02-20T21:13:38.316412+00:00 269022.0
exp_2023_02_20_01 200 leopard 4 1676927618.321412 2023-02-20T21:13:38.321412+00:00 269020.0
exp_2023_02_20_01 200 leopard 5 1676927618.3264122 2023-02-20T21:13:38.326412+00:00 269018.0
exp_2023_02_20_01 200 leopard 6 1676927618.331412 2023-02-20T21:13:38.331412+00:00 269016.0
exp_2023_02_20_01 200 leopard 7 1676927618.3364122 2023-02-20T21:13:38.336412+00:00 269014.0
exp_2023_02_20_01 200 leopard 8 1676927618.341412 2023-02-20T21:13:38.341412+00:00 269012.0
exp_2023_02_20_01 200 leopard 9 1676927618.3464122 2023-02-20T21:13:38.346412+00:00 269010.0
exp_2023_02_20_01 200 leopard 10 1676927618.351412 2023-02-20T21:13:38.351412+00:00 269008.0
exp_2023_02_20_01 200 leopard 11 1676927618.3564122 2023-02-20T21:13:38.356412+00:00 269007.0
exp_2023_02_20_01 200 leopard 12 1676927618.361412 2023-02-20T21:13:38.361412+00:00 269005.0
exp_2023_02_20_01 200 leopard 13 1676927618.3664122 2023-02-20T21:13:38.366412+00:00 269003.0
exp_2023_02_20_01 200 leopard 14 1676927618.371412 2023-02-20T21:13:38.371412+00:00 269001.0
exp_2023_02_20_01 200 leopard 15 1676927618.3764122 2023-02-20T21:13:38.376412+00:00 268999.0
exp_2023_02_20_01 200 leopard 16 1676927618.381412 2023-02-20T21:13:38.381412+00:00 268998.0
exp_2023_02_20_01 200 leopard 17 1676927618.3864121 2023-02-20T21:13:38.386412+00:00 268996.0
exp_2023_02_20_01 200 leopard 18 1676927618.391412 2023-02-20T21:13:38.391412+00:00 268994.0
exp_2023_02_20_01 200 leopard 19 1676927618.3964121 2023-02-20T21:13:38.396412+00:00 268992.0
exp_2023_02_20_01 200 leopard 20 1676927618.401412 2023-02-20T21:13:38.401412+00:00 268990.0
exp_2023_02_20_01 200 leopard 21 1676927618.4064121 2023-02-20T21:13:38.406412+00:00 268989.0
exp_2023_02_20_01 200 leopard 22 1676927618.411412 2023-02-20T21:13:38.411412+00:00 268987.0
exp_2023_02_20_01 200 leopard 23 1676927618.416412 2023-02-20T21:13:38.416412+00:00 268985.0
exp_2023_02_20_01 200 leopard 24 1676927618.421412 2023-02-20T21:13:38.421412+00:00 268984.0
exp_2023_02_20_01 200 leopard 25 1676927618.426412 2023-02-20T21:13:38.426412+00:00 268982.0
exp_2023_02_20_01 200 leopard 26 1676927618.4314122 2023-02-20T21:13:38.431412+00:00 268980.0
exp_2023_02_20_01 200 leopard 27 1676927618.436412 2023-02-20T21:13:38.436412+00:00 268979.0
exp_2023_02_20_01 200 leopard 28 1676927618.4414122 2023-02-20T21:13:38.441412+00:00 268978.0
exp_2023_02_20_01 200 leopard 29 1676927618.446412 2023-02-20T21:13:38.446412+00:00 268976.0
exp_2023_02_20_01 200 leopard 30 1676927618.4514122 2023-02-20T21:13:38.451412+00:00 268975.0
exp_2023_02_20_01 200 leopard 31 1676927618.456412 2023-02-20T21:13:38.456412+00:00 268973.0
exp_2023_02_20_01 200 leopard 32 1676927618.4614122 2023-02-20T21:13:38.461412+00:00 268972.0
exp_2023_02_20_01 200 leopard 33 1676927618.466412 2023-02-20T21:13:38.466412+00:00 268971.0
exp_2023_02_20_01 200 leopard 34 1676927618.4714122 2023-02-20T21:13:38.471412+00:00 268969.0
exp_2023_02_20_01 200 leopard 35 1676927618.476412 2023-02-20T21:13:38.476412+00:00 268968.0
exp_2023_02_20_01 200 leopard 36 1676927618.4814122 2023-02-20T21:13:38.481412+00:00 268967.0
exp_2023_02_20_01 200 leopard 37 1676927618.486412 2023-02-20T21:13:38.486412+00:00 268966.0
exp_2023_02_20_01 200 leopard 38 1676927618.4914122 2023-02-20T21:13:38.491412+00:00 268965.0
exp_2023_02_20_01 200 leopard 39 1676927618.496412 2023-02-20T21:13:38.496412+00:00 268964.0
exp_2023_02_20_01 200 leopard 40 1676927618.5014122 2023-02-20T21:13:38.501412+00:00 268963.0
exp_2023_02_20_01 200 leopard 41 1676927618.506412 2023-02-20T21:13:38.506412+00:00 268962.0
exp_2023_02_20_01 200 leopard 42 1676927618.5114121 2023-02-20T21:13:38.511412+00:00 268961.0
exp_2023_02_20_01 200 leopard 43 1676927618.516412 2023-02-20T21:13:38.516412+00:00 268960.0
exp_2023_02_20_01 200 leopard 44 1676927618.5214121 2023-02-20T21:13:38.521412+00:00 268960.0
exp_2023_02_20_01 200 leopard 45 1676927618.526412 2023-02-20T21:13:38.526412+00:00 268959.0
exp_2023_02_20_01 200 leopard 46 1676927618.5314121 2023-02-20T21:13:38.531412+00:00 268958.0
exp_2023_02_20_01 200 leopard 47 1676927618.536412 2023-02-20T21:13:38.536412+00:00 268958.0
exp_2023_02_20_01 200 leopard 48 1676927618.541412 2023-02-20T21:13:38.541412+00:00 268957.0
exp_2023_02_20_01 200 leopard 49 1676927618.546412 2023-02-20T21:13:38.546412+00:00 268957.0
exp_2023_02_20_01 200 leopard 50 1676927618.551412 2023-02-20T21:13:38.551412+00:00 268956.0
exp_2023_02_20_01 200 leopard 51 1676927618.5564122 2023-02-20T21:13:38.556412+00:00 268956.0
exp_2023_02_20_01 200 leopard 52 1676927618.561412 2023-02-20T21:13:38.561412+00:00 268956.0
exp_2023_02_20_01 200 leopard 53 1676927618.5664122 2023-02-20T21:13:38.566412+00:00 268956.0
exp_2023_02_20_01 200 leopard 54 1676927618.571412 2023-02-20T21:13:38.571412+00:00 268955.0
exp_2023_02_20_01 200 leopard 55 1676927618.5764122 2023-02-20T21:13:38.576412+00:00 268955.0
exp_2023_02_20_01 200 leopard 56 1676927618.581412 2023-02-20T21:13:38.581412+00:00 268956.0
exp_2023_02_20_01 200 leopard 57 1676927618.5864122 2023-02-20T21:13:38.586412+00:00 268956.0
exp_2023_02_20_01 200 leopard 58 1676927618.591412 2023-02-20T21:13:38.591412+00:00 268956.0
exp_2023_02_20_01 200 leopard 59 1676927618.5964122 2023-02-20T21:13:38.596412+00:00 268956.0
exp_2023_02_20_01 200 leopard 60 1676927618.601412 2023-02-20T21:13:38.601412+00:00 268957.0
exp_2023_02_20_01 200 leopard 61 1676927618.6064122 2023-02-20T21:13:38.606412+00:00 268957.0
exp_2023_02_20_01 200 leopard 62 1676927618.611412 2023-02-20T21:13:38.611412+00:00 268957.0
exp_2023_02_20_01 200 leopard 63 1676927618.6164122 2023-02-20T21:13:38.616412+00:00 268958.0
exp_2023_02_20_01 200 leopard 64 1676927618.621412 2023-02-20T21:13:38.621412+00:00 268959.0
exp_2023_02_20_01 200 leopard 65 1676927618.6264122 2023-02-20T21:13:38.626412+00:00 268959.0
exp_2023_02_20_01 200 leopard 66 1676927618.631412 2023-02-20T21:13:38.631412+00:00 268960.0
exp_2023_02_20_01 200 leopard 67 1676927618.6364121 2023-02-20T21:13:38.636412+00:00 268961.0
exp_2023_02_20_01 200 leopard 68 1676927618.641412 2023-02-20T21:13:38.641412+00:00 268962.0
exp_2023_02_20_01 200 leopard 69 1676927618.6464121 2023-02-20T21:13:38.646412+00:00 268963.0
exp_2023_02_20_01 200 leopard 70 1676927618.651412 2023-02-20T21:13:38.651412+00:00 268964.0
exp_2023_02_20_01 200 leopard 71 1676927618.6564121 2023-02-20T21:13:38.656412+00:00 268966.0
exp_2023_02_20_01 200 leopard 72 1676927618.661412 2023-02-20T21:13:38.661412+00:00 268967.0
exp_2023_02_20_01 200 leopard 73 1676927618.666412 2023-02-20T21:13:38.666412+00:00 268968.0
exp_2023_02_20_01 200 leopard 74 1676927618.671412 2023-02-20T21:13:38.671412+00:00 268970.0
exp_2023_02_20_01 200 leopard 75 1676927618.676412 2023-02-20T21:13:38.676412+00:00 268972.0
exp_2023_02_20_01 200 leopard 76 1676927618.6814122 2023-02-20T21:13:38.681412+00:00 268973.0
exp_2023_02_20_01 200 leopard 77 1676927618.686412 2023-02-20T21:13:38.686412+00:00 268975.0
exp_2023_02_20_01 200 leopard 78 1676927618.6914122 2023-02-20T21:13:38.691412+00:00 268977.0
exp_2023_02_20_01 200 leopard 79 1676927618.696412 2023-02-20T21:13:38.696412+00:00 268979.0
exp_2023_02_20_01 200 leopard 80 1676927618.7014122 2023-02-20T21:13:38.701412+00:00 268981.0
exp_2023_02_20_01 200 leopard 81 1676927618.706412 2023-02-20T21:13:38.706412+00:00 268984.0
exp_2023_02_20_01 200 leopard 82 1676927618.7114122 2023-02-20T21:13:38.711412+00:00 268986.0
exp_2023_02_20_01 200 leopard 83 1676927618.716412 2023-02-20T21:13:38.716412+00:00 268988.0
exp_2023_02_20_01 200 leopard 84 1676927618.7214122 2023-02-20T21:13:38.721412+00:00 268991.0
exp_2023_02_20_01 200 leopard 85 1676927618.726412 2023-02-20T21:13:38.726412+00:00 268994.0
exp_2023_02_20_01 200 leopard 86 1676927618.7314122 2023-02-20T21:13:38.731412+00:00 268996.0
exp_2023_02_20_01 200 leopard 87 1676927618.736412 2023-02-20T21:13:38.736412+00:00 268999.0
exp_2023_02_20_01 200 leopard 88 1676927618.7414122 2023-02-20T21:13:38.741412+00:00 269002.0
exp_2023_02_20_01 200 leopard 89 1676927618.746412 2023-02-20T21:13:38.746412+00:00 269005.0
exp_2023_02_20_01 200 leopard 90 1676927618.7514122 2023-02-20T21:13:38.751412+00:00 269008.0
exp_2023_02_20_01 200 leopard 91 1676927618.756412 2023-02-20T21:13:38.756412+00:00 269011.0
exp_2023_02_20_01 200 leopard 92 1676927618.7614121 2023-02-20T21:13:38.761412+00:00 269015.0
exp_2023_02_20_01 200 leopard 93 1676927618.766412 2023-02-20T21:13:38.766412+00:00 269018.0
exp_2023_02_20_01 200 leopard 94 1676927618.7714121 2023-02-20T21:13:38.771412+00:00 269022.0
exp_2023_02_20_01 200 leopard 95 1676927618.776412 2023-02-20T21:13:38.776412+00:00 269025.0
exp_2023_02_20_01 200 leopard 96 1676927618.7814121 2023-02-20T21:13:38.781412+00:00 269029.0
exp_2023_02_20_01 200 leopard 97 1676927618.786412 2023-02-20T21:13:38.786412+00:00 269033.0
exp_2023_02_20_01 200 leopard 98 1676927618.791412 2023-02-20T21:13:38.791412+00:00 269037.0
exp_2023_02_20_01 200 leopard 99 1676927618.796412 2023-02-20T21:13:38.796412+00:00 269041.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]);