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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_05_01_13 200 leopard 0 1682975340.441846 2023-05-01T21:09:00.441846+00:00 174463.0
exp_2023_05_01_13 200 leopard 1 1682975340.446846 2023-05-01T21:09:00.446846+00:00 174460.0
exp_2023_05_01_13 200 leopard 2 1682975340.451846 2023-05-01T21:09:00.451846+00:00 174456.0
exp_2023_05_01_13 200 leopard 3 1682975340.456846 2023-05-01T21:09:00.456846+00:00 174452.0
exp_2023_05_01_13 200 leopard 4 1682975340.4618459 2023-05-01T21:09:00.461846+00:00 174449.0
exp_2023_05_01_13 200 leopard 5 1682975340.466846 2023-05-01T21:09:00.466846+00:00 174445.0
exp_2023_05_01_13 200 leopard 6 1682975340.4718459 2023-05-01T21:09:00.471846+00:00 174441.0
exp_2023_05_01_13 200 leopard 7 1682975340.476846 2023-05-01T21:09:00.476846+00:00 174438.0
exp_2023_05_01_13 200 leopard 8 1682975340.4818459 2023-05-01T21:09:00.481846+00:00 174434.0
exp_2023_05_01_13 200 leopard 9 1682975340.486846 2023-05-01T21:09:00.486846+00:00 174430.0
exp_2023_05_01_13 200 leopard 10 1682975340.4918458 2023-05-01T21:09:00.491846+00:00 174426.0
exp_2023_05_01_13 200 leopard 11 1682975340.496846 2023-05-01T21:09:00.496846+00:00 174423.0
exp_2023_05_01_13 200 leopard 12 1682975340.5018458 2023-05-01T21:09:00.501846+00:00 174419.0
exp_2023_05_01_13 200 leopard 13 1682975340.506846 2023-05-01T21:09:00.506846+00:00 174415.0
exp_2023_05_01_13 200 leopard 14 1682975340.5118458 2023-05-01T21:09:00.511846+00:00 174411.0
exp_2023_05_01_13 200 leopard 15 1682975340.516846 2023-05-01T21:09:00.516846+00:00 174408.0
exp_2023_05_01_13 200 leopard 16 1682975340.5218458 2023-05-01T21:09:00.521846+00:00 174404.0
exp_2023_05_01_13 200 leopard 17 1682975340.526846 2023-05-01T21:09:00.526846+00:00 174400.0
exp_2023_05_01_13 200 leopard 18 1682975340.5318458 2023-05-01T21:09:00.531846+00:00 174396.0
exp_2023_05_01_13 200 leopard 19 1682975340.536846 2023-05-01T21:09:00.536846+00:00 174392.0
exp_2023_05_01_13 200 leopard 20 1682975340.5418458 2023-05-01T21:09:00.541846+00:00 174389.0
exp_2023_05_01_13 200 leopard 21 1682975340.546846 2023-05-01T21:09:00.546846+00:00 174385.0
exp_2023_05_01_13 200 leopard 22 1682975340.5518458 2023-05-01T21:09:00.551846+00:00 174381.0
exp_2023_05_01_13 200 leopard 23 1682975340.556846 2023-05-01T21:09:00.556846+00:00 174377.0
exp_2023_05_01_13 200 leopard 24 1682975340.5618458 2023-05-01T21:09:00.561846+00:00 174373.0
exp_2023_05_01_13 200 leopard 25 1682975340.566846 2023-05-01T21:09:00.566846+00:00 174370.0
exp_2023_05_01_13 200 leopard 26 1682975340.571846 2023-05-01T21:09:00.571846+00:00 174366.0
exp_2023_05_01_13 200 leopard 27 1682975340.576846 2023-05-01T21:09:00.576846+00:00 174362.0
exp_2023_05_01_13 200 leopard 28 1682975340.581846 2023-05-01T21:09:00.581846+00:00 174358.0
exp_2023_05_01_13 200 leopard 29 1682975340.5868459 2023-05-01T21:09:00.586846+00:00 174354.0
exp_2023_05_01_13 200 leopard 30 1682975340.591846 2023-05-01T21:09:00.591846+00:00 174351.0
exp_2023_05_01_13 200 leopard 31 1682975340.5968459 2023-05-01T21:09:00.596846+00:00 174347.0
exp_2023_05_01_13 200 leopard 32 1682975340.601846 2023-05-01T21:09:00.601846+00:00 174343.0
exp_2023_05_01_13 200 leopard 33 1682975340.6068459 2023-05-01T21:09:00.606846+00:00 174339.0
exp_2023_05_01_13 200 leopard 34 1682975340.611846 2023-05-01T21:09:00.611846+00:00 174335.0
exp_2023_05_01_13 200 leopard 35 1682975340.6168458 2023-05-01T21:09:00.616846+00:00 174332.0
exp_2023_05_01_13 200 leopard 36 1682975340.621846 2023-05-01T21:09:00.621846+00:00 174328.0
exp_2023_05_01_13 200 leopard 37 1682975340.6268458 2023-05-01T21:09:00.626846+00:00 174324.0
exp_2023_05_01_13 200 leopard 38 1682975340.631846 2023-05-01T21:09:00.631846+00:00 174320.0
exp_2023_05_01_13 200 leopard 39 1682975340.6368458 2023-05-01T21:09:00.636846+00:00 174316.0
exp_2023_05_01_13 200 leopard 40 1682975340.641846 2023-05-01T21:09:00.641846+00:00 174312.0
exp_2023_05_01_13 200 leopard 41 1682975340.6468458 2023-05-01T21:09:00.646846+00:00 174309.0
exp_2023_05_01_13 200 leopard 42 1682975340.651846 2023-05-01T21:09:00.651846+00:00 174305.0
exp_2023_05_01_13 200 leopard 43 1682975340.6568458 2023-05-01T21:09:00.656846+00:00 174301.0
exp_2023_05_01_13 200 leopard 44 1682975340.661846 2023-05-01T21:09:00.661846+00:00 174297.0
exp_2023_05_01_13 200 leopard 45 1682975340.6668458 2023-05-01T21:09:00.666846+00:00 174293.0
exp_2023_05_01_13 200 leopard 46 1682975340.671846 2023-05-01T21:09:00.671846+00:00 174289.0
exp_2023_05_01_13 200 leopard 47 1682975340.6768458 2023-05-01T21:09:00.676846+00:00 174286.0
exp_2023_05_01_13 200 leopard 48 1682975340.681846 2023-05-01T21:09:00.681846+00:00 174282.0
exp_2023_05_01_13 200 leopard 49 1682975340.6868458 2023-05-01T21:09:00.686846+00:00 174278.0
exp_2023_05_01_13 200 leopard 50 1682975340.691846 2023-05-01T21:09:00.691846+00:00 174274.0
exp_2023_05_01_13 200 leopard 51 1682975340.696846 2023-05-01T21:09:00.696846+00:00 174270.0
exp_2023_05_01_13 200 leopard 52 1682975340.701846 2023-05-01T21:09:00.701846+00:00 174266.0
exp_2023_05_01_13 200 leopard 53 1682975340.706846 2023-05-01T21:09:00.706846+00:00 174262.0
exp_2023_05_01_13 200 leopard 54 1682975340.7118459 2023-05-01T21:09:00.711846+00:00 174259.0
exp_2023_05_01_13 200 leopard 55 1682975340.716846 2023-05-01T21:09:00.716846+00:00 174255.0
exp_2023_05_01_13 200 leopard 56 1682975340.7218459 2023-05-01T21:09:00.721846+00:00 174251.0
exp_2023_05_01_13 200 leopard 57 1682975340.726846 2023-05-01T21:09:00.726846+00:00 174247.0
exp_2023_05_01_13 200 leopard 58 1682975340.7318459 2023-05-01T21:09:00.731846+00:00 174243.0
exp_2023_05_01_13 200 leopard 59 1682975340.736846 2023-05-01T21:09:00.736846+00:00 174239.0
exp_2023_05_01_13 200 leopard 60 1682975340.7418458 2023-05-01T21:09:00.741846+00:00 174235.0
exp_2023_05_01_13 200 leopard 61 1682975340.746846 2023-05-01T21:09:00.746846+00:00 174232.0
exp_2023_05_01_13 200 leopard 62 1682975340.7518458 2023-05-01T21:09:00.751846+00:00 174228.0
exp_2023_05_01_13 200 leopard 63 1682975340.756846 2023-05-01T21:09:00.756846+00:00 174224.0
exp_2023_05_01_13 200 leopard 64 1682975340.7618458 2023-05-01T21:09:00.761846+00:00 174220.0
exp_2023_05_01_13 200 leopard 65 1682975340.766846 2023-05-01T21:09:00.766846+00:00 174217.0
exp_2023_05_01_13 200 leopard 66 1682975340.7718458 2023-05-01T21:09:00.771846+00:00 174213.0
exp_2023_05_01_13 200 leopard 67 1682975340.776846 2023-05-01T21:09:00.776846+00:00 174209.0
exp_2023_05_01_13 200 leopard 68 1682975340.7818458 2023-05-01T21:09:00.781846+00:00 174205.0
exp_2023_05_01_13 200 leopard 69 1682975340.786846 2023-05-01T21:09:00.786846+00:00 174202.0
exp_2023_05_01_13 200 leopard 70 1682975340.7918458 2023-05-01T21:09:00.791846+00:00 174198.0
exp_2023_05_01_13 200 leopard 71 1682975340.796846 2023-05-01T21:09:00.796846+00:00 174194.0
exp_2023_05_01_13 200 leopard 72 1682975340.8018458 2023-05-01T21:09:00.801846+00:00 174191.0
exp_2023_05_01_13 200 leopard 73 1682975340.806846 2023-05-01T21:09:00.806846+00:00 174187.0
exp_2023_05_01_13 200 leopard 74 1682975340.8118458 2023-05-01T21:09:00.811846+00:00 174183.0
exp_2023_05_01_13 200 leopard 75 1682975340.816846 2023-05-01T21:09:00.816846+00:00 174180.0
exp_2023_05_01_13 200 leopard 76 1682975340.821846 2023-05-01T21:09:00.821846+00:00 174176.0
exp_2023_05_01_13 200 leopard 77 1682975340.826846 2023-05-01T21:09:00.826846+00:00 174172.0
exp_2023_05_01_13 200 leopard 78 1682975340.831846 2023-05-01T21:09:00.831846+00:00 174169.0
exp_2023_05_01_13 200 leopard 79 1682975340.8368459 2023-05-01T21:09:00.836846+00:00 174165.0
exp_2023_05_01_13 200 leopard 80 1682975340.841846 2023-05-01T21:09:00.841846+00:00 174161.0
exp_2023_05_01_13 200 leopard 81 1682975340.8468459 2023-05-01T21:09:00.846846+00:00 174158.0
exp_2023_05_01_13 200 leopard 82 1682975340.851846 2023-05-01T21:09:00.851846+00:00 174154.0
exp_2023_05_01_13 200 leopard 83 1682975340.8568459 2023-05-01T21:09:00.856846+00:00 174151.0
exp_2023_05_01_13 200 leopard 84 1682975340.861846 2023-05-01T21:09:00.861846+00:00 174147.0
exp_2023_05_01_13 200 leopard 85 1682975340.8668458 2023-05-01T21:09:00.866846+00:00 174143.0
exp_2023_05_01_13 200 leopard 86 1682975340.871846 2023-05-01T21:09:00.871846+00:00 174140.0
exp_2023_05_01_13 200 leopard 87 1682975340.8768458 2023-05-01T21:09:00.876846+00:00 174136.0
exp_2023_05_01_13 200 leopard 88 1682975340.881846 2023-05-01T21:09:00.881846+00:00 174132.0
exp_2023_05_01_13 200 leopard 89 1682975340.8868458 2023-05-01T21:09:00.886846+00:00 174129.0
exp_2023_05_01_13 200 leopard 90 1682975340.891846 2023-05-01T21:09:00.891846+00:00 174125.0
exp_2023_05_01_13 200 leopard 91 1682975340.8968458 2023-05-01T21:09:00.896846+00:00 174122.0
exp_2023_05_01_13 200 leopard 92 1682975340.901846 2023-05-01T21:09:00.901846+00:00 174118.0
exp_2023_05_01_13 200 leopard 93 1682975340.9068458 2023-05-01T21:09:00.906846+00:00 174114.0
exp_2023_05_01_13 200 leopard 94 1682975340.911846 2023-05-01T21:09:00.911846+00:00 174111.0
exp_2023_05_01_13 200 leopard 95 1682975340.9168458 2023-05-01T21:09:00.916846+00:00 174107.0
exp_2023_05_01_13 200 leopard 96 1682975340.921846 2023-05-01T21:09:00.921846+00:00 174103.0
exp_2023_05_01_13 200 leopard 97 1682975340.9268458 2023-05-01T21:09:00.926846+00:00 174100.0
exp_2023_05_01_13 200 leopard 98 1682975340.931846 2023-05-01T21:09:00.931846+00:00 174096.0
exp_2023_05_01_13 200 leopard 99 1682975340.9368458 2023-05-01T21:09:00.936846+00:00 174092.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]);