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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_08_11 200 leopard 0 1667935114.639505 2022-11-08T19:18:34.639505+00:00 269782.0
exp_2022_11_08_11 200 leopard 1 1667935114.644505 2022-11-08T19:18:34.644505+00:00 269824.0
exp_2022_11_08_11 200 leopard 2 1667935114.649505 2022-11-08T19:18:34.649505+00:00 269866.0
exp_2022_11_08_11 200 leopard 3 1667935114.654505 2022-11-08T19:18:34.654505+00:00 269907.0
exp_2022_11_08_11 200 leopard 4 1667935114.659505 2022-11-08T19:18:34.659505+00:00 269948.0
exp_2022_11_08_11 200 leopard 5 1667935114.664505 2022-11-08T19:18:34.664505+00:00 269988.0
exp_2022_11_08_11 200 leopard 6 1667935114.669505 2022-11-08T19:18:34.669505+00:00 270028.0
exp_2022_11_08_11 200 leopard 7 1667935114.674505 2022-11-08T19:18:34.674505+00:00 270068.0
exp_2022_11_08_11 200 leopard 8 1667935114.6795049 2022-11-08T19:18:34.679505+00:00 270107.0
exp_2022_11_08_11 200 leopard 9 1667935114.684505 2022-11-08T19:18:34.684505+00:00 270146.0
exp_2022_11_08_11 200 leopard 10 1667935114.6895049 2022-11-08T19:18:34.689505+00:00 270185.0
exp_2022_11_08_11 200 leopard 11 1667935114.694505 2022-11-08T19:18:34.694505+00:00 270223.0
exp_2022_11_08_11 200 leopard 12 1667935114.6995049 2022-11-08T19:18:34.699505+00:00 270261.0
exp_2022_11_08_11 200 leopard 13 1667935114.704505 2022-11-08T19:18:34.704505+00:00 270299.0
exp_2022_11_08_11 200 leopard 14 1667935114.7095048 2022-11-08T19:18:34.709505+00:00 270336.0
exp_2022_11_08_11 200 leopard 15 1667935114.714505 2022-11-08T19:18:34.714505+00:00 270373.0
exp_2022_11_08_11 200 leopard 16 1667935114.7195048 2022-11-08T19:18:34.719505+00:00 270410.0
exp_2022_11_08_11 200 leopard 17 1667935114.724505 2022-11-08T19:18:34.724505+00:00 270447.0
exp_2022_11_08_11 200 leopard 18 1667935114.7295048 2022-11-08T19:18:34.729505+00:00 270483.0
exp_2022_11_08_11 200 leopard 19 1667935114.734505 2022-11-08T19:18:34.734505+00:00 270519.0
exp_2022_11_08_11 200 leopard 20 1667935114.7395048 2022-11-08T19:18:34.739505+00:00 270554.0
exp_2022_11_08_11 200 leopard 21 1667935114.744505 2022-11-08T19:18:34.744505+00:00 270589.0
exp_2022_11_08_11 200 leopard 22 1667935114.7495048 2022-11-08T19:18:34.749505+00:00 270624.0
exp_2022_11_08_11 200 leopard 23 1667935114.754505 2022-11-08T19:18:34.754505+00:00 270659.0
exp_2022_11_08_11 200 leopard 24 1667935114.7595048 2022-11-08T19:18:34.759505+00:00 270694.0
exp_2022_11_08_11 200 leopard 25 1667935114.764505 2022-11-08T19:18:34.764505+00:00 270728.0
exp_2022_11_08_11 200 leopard 26 1667935114.769505 2022-11-08T19:18:34.769505+00:00 270762.0
exp_2022_11_08_11 200 leopard 27 1667935114.774505 2022-11-08T19:18:34.774505+00:00 270796.0
exp_2022_11_08_11 200 leopard 28 1667935114.779505 2022-11-08T19:18:34.779505+00:00 270829.0
exp_2022_11_08_11 200 leopard 29 1667935114.784505 2022-11-08T19:18:34.784505+00:00 270863.0
exp_2022_11_08_11 200 leopard 30 1667935114.789505 2022-11-08T19:18:34.789505+00:00 270896.0
exp_2022_11_08_11 200 leopard 31 1667935114.794505 2022-11-08T19:18:34.794505+00:00 270928.0
exp_2022_11_08_11 200 leopard 32 1667935114.799505 2022-11-08T19:18:34.799505+00:00 270961.0
exp_2022_11_08_11 200 leopard 33 1667935114.8045049 2022-11-08T19:18:34.804505+00:00 270994.0
exp_2022_11_08_11 200 leopard 34 1667935114.809505 2022-11-08T19:18:34.809505+00:00 271026.0
exp_2022_11_08_11 200 leopard 35 1667935114.8145049 2022-11-08T19:18:34.814505+00:00 271058.0
exp_2022_11_08_11 200 leopard 36 1667935114.819505 2022-11-08T19:18:34.819505+00:00 271090.0
exp_2022_11_08_11 200 leopard 37 1667935114.8245049 2022-11-08T19:18:34.824505+00:00 271121.0
exp_2022_11_08_11 200 leopard 38 1667935114.829505 2022-11-08T19:18:34.829505+00:00 271153.0
exp_2022_11_08_11 200 leopard 39 1667935114.8345048 2022-11-08T19:18:34.834505+00:00 271184.0
exp_2022_11_08_11 200 leopard 40 1667935114.839505 2022-11-08T19:18:34.839505+00:00 271215.0
exp_2022_11_08_11 200 leopard 41 1667935114.8445048 2022-11-08T19:18:34.844505+00:00 271246.0
exp_2022_11_08_11 200 leopard 42 1667935114.849505 2022-11-08T19:18:34.849505+00:00 271276.0
exp_2022_11_08_11 200 leopard 43 1667935114.8545048 2022-11-08T19:18:34.854505+00:00 271307.0
exp_2022_11_08_11 200 leopard 44 1667935114.859505 2022-11-08T19:18:34.859505+00:00 271337.0
exp_2022_11_08_11 200 leopard 45 1667935114.8645048 2022-11-08T19:18:34.864505+00:00 271367.0
exp_2022_11_08_11 200 leopard 46 1667935114.869505 2022-11-08T19:18:34.869505+00:00 271397.0
exp_2022_11_08_11 200 leopard 47 1667935114.8745048 2022-11-08T19:18:34.874505+00:00 271427.0
exp_2022_11_08_11 200 leopard 48 1667935114.879505 2022-11-08T19:18:34.879505+00:00 271457.0
exp_2022_11_08_11 200 leopard 49 1667935114.8845048 2022-11-08T19:18:34.884505+00:00 271486.0
exp_2022_11_08_11 200 leopard 50 1667935114.889505 2022-11-08T19:18:34.889505+00:00 271515.0
exp_2022_11_08_11 200 leopard 51 1667935114.894505 2022-11-08T19:18:34.894505+00:00 271544.0
exp_2022_11_08_11 200 leopard 52 1667935114.899505 2022-11-08T19:18:34.899505+00:00 271573.0
exp_2022_11_08_11 200 leopard 53 1667935114.904505 2022-11-08T19:18:34.904505+00:00 271602.0
exp_2022_11_08_11 200 leopard 54 1667935114.909505 2022-11-08T19:18:34.909505+00:00 271630.0
exp_2022_11_08_11 200 leopard 55 1667935114.914505 2022-11-08T19:18:34.914505+00:00 271659.0
exp_2022_11_08_11 200 leopard 56 1667935114.919505 2022-11-08T19:18:34.919505+00:00 271687.0
exp_2022_11_08_11 200 leopard 57 1667935114.924505 2022-11-08T19:18:34.924505+00:00 271715.0
exp_2022_11_08_11 200 leopard 58 1667935114.9295049 2022-11-08T19:18:34.929505+00:00 271743.0
exp_2022_11_08_11 200 leopard 59 1667935114.934505 2022-11-08T19:18:34.934505+00:00 271770.0
exp_2022_11_08_11 200 leopard 60 1667935114.9395049 2022-11-08T19:18:34.939505+00:00 271798.0
exp_2022_11_08_11 200 leopard 61 1667935114.944505 2022-11-08T19:18:34.944505+00:00 271825.0
exp_2022_11_08_11 200 leopard 62 1667935114.9495049 2022-11-08T19:18:34.949505+00:00 271852.0
exp_2022_11_08_11 200 leopard 63 1667935114.954505 2022-11-08T19:18:34.954505+00:00 271878.0
exp_2022_11_08_11 200 leopard 64 1667935114.9595048 2022-11-08T19:18:34.959505+00:00 271905.0
exp_2022_11_08_11 200 leopard 65 1667935114.964505 2022-11-08T19:18:34.964505+00:00 271931.0
exp_2022_11_08_11 200 leopard 66 1667935114.9695048 2022-11-08T19:18:34.969505+00:00 271957.0
exp_2022_11_08_11 200 leopard 67 1667935114.974505 2022-11-08T19:18:34.974505+00:00 271983.0
exp_2022_11_08_11 200 leopard 68 1667935114.9795048 2022-11-08T19:18:34.979505+00:00 272009.0
exp_2022_11_08_11 200 leopard 69 1667935114.984505 2022-11-08T19:18:34.984505+00:00 272034.0
exp_2022_11_08_11 200 leopard 70 1667935114.9895048 2022-11-08T19:18:34.989505+00:00 272060.0
exp_2022_11_08_11 200 leopard 71 1667935114.994505 2022-11-08T19:18:34.994505+00:00 272085.0
exp_2022_11_08_11 200 leopard 72 1667935114.9995048 2022-11-08T19:18:34.999505+00:00 272110.0
exp_2022_11_08_11 200 leopard 73 1667935115.004505 2022-11-08T19:18:35.004505+00:00 272134.0
exp_2022_11_08_11 200 leopard 74 1667935115.0095048 2022-11-08T19:18:35.009505+00:00 272159.0
exp_2022_11_08_11 200 leopard 75 1667935115.014505 2022-11-08T19:18:35.014505+00:00 272183.0
exp_2022_11_08_11 200 leopard 76 1667935115.019505 2022-11-08T19:18:35.019505+00:00 272207.0
exp_2022_11_08_11 200 leopard 77 1667935115.024505 2022-11-08T19:18:35.024505+00:00 272230.0
exp_2022_11_08_11 200 leopard 78 1667935115.029505 2022-11-08T19:18:35.029505+00:00 272254.0
exp_2022_11_08_11 200 leopard 79 1667935115.034505 2022-11-08T19:18:35.034505+00:00 272277.0
exp_2022_11_08_11 200 leopard 80 1667935115.039505 2022-11-08T19:18:35.039505+00:00 272300.0
exp_2022_11_08_11 200 leopard 81 1667935115.044505 2022-11-08T19:18:35.044505+00:00 272323.0
exp_2022_11_08_11 200 leopard 82 1667935115.049505 2022-11-08T19:18:35.049505+00:00 272345.0
exp_2022_11_08_11 200 leopard 83 1667935115.0545049 2022-11-08T19:18:35.054505+00:00 272368.0
exp_2022_11_08_11 200 leopard 84 1667935115.059505 2022-11-08T19:18:35.059505+00:00 272390.0
exp_2022_11_08_11 200 leopard 85 1667935115.0645049 2022-11-08T19:18:35.064505+00:00 272412.0
exp_2022_11_08_11 200 leopard 86 1667935115.069505 2022-11-08T19:18:35.069505+00:00 272433.0
exp_2022_11_08_11 200 leopard 87 1667935115.0745049 2022-11-08T19:18:35.074505+00:00 272455.0
exp_2022_11_08_11 200 leopard 88 1667935115.079505 2022-11-08T19:18:35.079505+00:00 272476.0
exp_2022_11_08_11 200 leopard 89 1667935115.0845048 2022-11-08T19:18:35.084505+00:00 272497.0
exp_2022_11_08_11 200 leopard 90 1667935115.089505 2022-11-08T19:18:35.089505+00:00 272518.0
exp_2022_11_08_11 200 leopard 91 1667935115.0945048 2022-11-08T19:18:35.094505+00:00 272539.0
exp_2022_11_08_11 200 leopard 92 1667935115.099505 2022-11-08T19:18:35.099505+00:00 272559.0
exp_2022_11_08_11 200 leopard 93 1667935115.1045048 2022-11-08T19:18:35.104505+00:00 272579.0
exp_2022_11_08_11 200 leopard 94 1667935115.109505 2022-11-08T19:18:35.109505+00:00 272599.0
exp_2022_11_08_11 200 leopard 95 1667935115.1145048 2022-11-08T19:18:35.114505+00:00 272619.0
exp_2022_11_08_11 200 leopard 96 1667935115.119505 2022-11-08T19:18:35.119505+00:00 272639.0
exp_2022_11_08_11 200 leopard 97 1667935115.1245048 2022-11-08T19:18:35.124505+00:00 272659.0
exp_2022_11_08_11 200 leopard 98 1667935115.129505 2022-11-08T19:18:35.129505+00:00 272678.0
exp_2022_11_08_11 200 leopard 99 1667935115.1345048 2022-11-08T19:18:35.134505+00:00 272697.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]);