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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_04_10 200 leopard 0 1667586199.6340227 2022-11-04T18:23:19.634023+00:00 423927.0
exp_2022_11_04_10 200 leopard 1 1667586199.6390228 2022-11-04T18:23:19.639023+00:00 423919.0
exp_2022_11_04_10 200 leopard 2 1667586199.6440227 2022-11-04T18:23:19.644023+00:00 423911.0
exp_2022_11_04_10 200 leopard 3 1667586199.6490228 2022-11-04T18:23:19.649023+00:00 423904.0
exp_2022_11_04_10 200 leopard 4 1667586199.6540227 2022-11-04T18:23:19.654023+00:00 423896.0
exp_2022_11_04_10 200 leopard 5 1667586199.6590228 2022-11-04T18:23:19.659023+00:00 423888.0
exp_2022_11_04_10 200 leopard 6 1667586199.6640227 2022-11-04T18:23:19.664023+00:00 423880.0
exp_2022_11_04_10 200 leopard 7 1667586199.6690228 2022-11-04T18:23:19.669023+00:00 423873.0
exp_2022_11_04_10 200 leopard 8 1667586199.6740227 2022-11-04T18:23:19.674023+00:00 423865.0
exp_2022_11_04_10 200 leopard 9 1667586199.6790228 2022-11-04T18:23:19.679023+00:00 423857.0
exp_2022_11_04_10 200 leopard 10 1667586199.6840227 2022-11-04T18:23:19.684023+00:00 423849.0
exp_2022_11_04_10 200 leopard 11 1667586199.6890228 2022-11-04T18:23:19.689023+00:00 423842.0
exp_2022_11_04_10 200 leopard 12 1667586199.6940227 2022-11-04T18:23:19.694023+00:00 423834.0
exp_2022_11_04_10 200 leopard 13 1667586199.6990228 2022-11-04T18:23:19.699023+00:00 423826.0
exp_2022_11_04_10 200 leopard 14 1667586199.7040226 2022-11-04T18:23:19.704023+00:00 423818.0
exp_2022_11_04_10 200 leopard 15 1667586199.7090228 2022-11-04T18:23:19.709023+00:00 423810.0
exp_2022_11_04_10 200 leopard 16 1667586199.7140226 2022-11-04T18:23:19.714023+00:00 423803.0
exp_2022_11_04_10 200 leopard 17 1667586199.7190228 2022-11-04T18:23:19.719023+00:00 423795.0
exp_2022_11_04_10 200 leopard 18 1667586199.7240226 2022-11-04T18:23:19.724023+00:00 423787.0
exp_2022_11_04_10 200 leopard 19 1667586199.7290227 2022-11-04T18:23:19.729023+00:00 423779.0
exp_2022_11_04_10 200 leopard 20 1667586199.7340226 2022-11-04T18:23:19.734023+00:00 423771.0
exp_2022_11_04_10 200 leopard 21 1667586199.7390227 2022-11-04T18:23:19.739023+00:00 423763.0
exp_2022_11_04_10 200 leopard 22 1667586199.7440226 2022-11-04T18:23:19.744023+00:00 423755.0
exp_2022_11_04_10 200 leopard 23 1667586199.7490227 2022-11-04T18:23:19.749023+00:00 423747.0
exp_2022_11_04_10 200 leopard 24 1667586199.7540226 2022-11-04T18:23:19.754023+00:00 423738.0
exp_2022_11_04_10 200 leopard 25 1667586199.7590227 2022-11-04T18:23:19.759023+00:00 423730.0
exp_2022_11_04_10 200 leopard 26 1667586199.7640228 2022-11-04T18:23:19.764023+00:00 423722.0
exp_2022_11_04_10 200 leopard 27 1667586199.7690227 2022-11-04T18:23:19.769023+00:00 423714.0
exp_2022_11_04_10 200 leopard 28 1667586199.7740228 2022-11-04T18:23:19.774023+00:00 423705.0
exp_2022_11_04_10 200 leopard 29 1667586199.7790227 2022-11-04T18:23:19.779023+00:00 423697.0
exp_2022_11_04_10 200 leopard 30 1667586199.7840228 2022-11-04T18:23:19.784023+00:00 423689.0
exp_2022_11_04_10 200 leopard 31 1667586199.7890227 2022-11-04T18:23:19.789023+00:00 423680.0
exp_2022_11_04_10 200 leopard 32 1667586199.7940228 2022-11-04T18:23:19.794023+00:00 423672.0
exp_2022_11_04_10 200 leopard 33 1667586199.7990227 2022-11-04T18:23:19.799023+00:00 423663.0
exp_2022_11_04_10 200 leopard 34 1667586199.8040228 2022-11-04T18:23:19.804023+00:00 423655.0
exp_2022_11_04_10 200 leopard 35 1667586199.8090227 2022-11-04T18:23:19.809023+00:00 423646.0
exp_2022_11_04_10 200 leopard 36 1667586199.8140228 2022-11-04T18:23:19.814023+00:00 423637.0
exp_2022_11_04_10 200 leopard 37 1667586199.8190227 2022-11-04T18:23:19.819023+00:00 423629.0
exp_2022_11_04_10 200 leopard 38 1667586199.8240228 2022-11-04T18:23:19.824023+00:00 423620.0
exp_2022_11_04_10 200 leopard 39 1667586199.8290226 2022-11-04T18:23:19.829023+00:00 423611.0
exp_2022_11_04_10 200 leopard 40 1667586199.8340228 2022-11-04T18:23:19.834023+00:00 423602.0
exp_2022_11_04_10 200 leopard 41 1667586199.8390226 2022-11-04T18:23:19.839023+00:00 423594.0
exp_2022_11_04_10 200 leopard 42 1667586199.8440228 2022-11-04T18:23:19.844023+00:00 423585.0
exp_2022_11_04_10 200 leopard 43 1667586199.8490226 2022-11-04T18:23:19.849023+00:00 423576.0
exp_2022_11_04_10 200 leopard 44 1667586199.8540227 2022-11-04T18:23:19.854023+00:00 423567.0
exp_2022_11_04_10 200 leopard 45 1667586199.8590226 2022-11-04T18:23:19.859023+00:00 423558.0
exp_2022_11_04_10 200 leopard 46 1667586199.8640227 2022-11-04T18:23:19.864023+00:00 423549.0
exp_2022_11_04_10 200 leopard 47 1667586199.8690226 2022-11-04T18:23:19.869023+00:00 423540.0
exp_2022_11_04_10 200 leopard 48 1667586199.8740227 2022-11-04T18:23:19.874023+00:00 423531.0
exp_2022_11_04_10 200 leopard 49 1667586199.8790226 2022-11-04T18:23:19.879023+00:00 423522.0
exp_2022_11_04_10 200 leopard 50 1667586199.8840227 2022-11-04T18:23:19.884023+00:00 423513.0
exp_2022_11_04_10 200 leopard 51 1667586199.8890228 2022-11-04T18:23:19.889023+00:00 423504.0
exp_2022_11_04_10 200 leopard 52 1667586199.8940227 2022-11-04T18:23:19.894023+00:00 423495.0
exp_2022_11_04_10 200 leopard 53 1667586199.8990228 2022-11-04T18:23:19.899023+00:00 423486.0
exp_2022_11_04_10 200 leopard 54 1667586199.9040227 2022-11-04T18:23:19.904023+00:00 423477.0
exp_2022_11_04_10 200 leopard 55 1667586199.9090228 2022-11-04T18:23:19.909023+00:00 423467.0
exp_2022_11_04_10 200 leopard 56 1667586199.9140227 2022-11-04T18:23:19.914023+00:00 423458.0
exp_2022_11_04_10 200 leopard 57 1667586199.9190228 2022-11-04T18:23:19.919023+00:00 423449.0
exp_2022_11_04_10 200 leopard 58 1667586199.9240227 2022-11-04T18:23:19.924023+00:00 423440.0
exp_2022_11_04_10 200 leopard 59 1667586199.9290228 2022-11-04T18:23:19.929023+00:00 423431.0
exp_2022_11_04_10 200 leopard 60 1667586199.9340227 2022-11-04T18:23:19.934023+00:00 423422.0
exp_2022_11_04_10 200 leopard 61 1667586199.9390228 2022-11-04T18:23:19.939023+00:00 423412.0
exp_2022_11_04_10 200 leopard 62 1667586199.9440227 2022-11-04T18:23:19.944023+00:00 423403.0
exp_2022_11_04_10 200 leopard 63 1667586199.9490228 2022-11-04T18:23:19.949023+00:00 423394.0
exp_2022_11_04_10 200 leopard 64 1667586199.9540226 2022-11-04T18:23:19.954023+00:00 423385.0
exp_2022_11_04_10 200 leopard 65 1667586199.9590228 2022-11-04T18:23:19.959023+00:00 423375.0
exp_2022_11_04_10 200 leopard 66 1667586199.9640226 2022-11-04T18:23:19.964023+00:00 423366.0
exp_2022_11_04_10 200 leopard 67 1667586199.9690228 2022-11-04T18:23:19.969023+00:00 423357.0
exp_2022_11_04_10 200 leopard 68 1667586199.9740226 2022-11-04T18:23:19.974023+00:00 423348.0
exp_2022_11_04_10 200 leopard 69 1667586199.9790227 2022-11-04T18:23:19.979023+00:00 423338.0
exp_2022_11_04_10 200 leopard 70 1667586199.9840226 2022-11-04T18:23:19.984023+00:00 423329.0
exp_2022_11_04_10 200 leopard 71 1667586199.9890227 2022-11-04T18:23:19.989023+00:00 423320.0
exp_2022_11_04_10 200 leopard 72 1667586199.9940226 2022-11-04T18:23:19.994023+00:00 423311.0
exp_2022_11_04_10 200 leopard 73 1667586199.9990227 2022-11-04T18:23:19.999023+00:00 423301.0
exp_2022_11_04_10 200 leopard 74 1667586200.0040226 2022-11-04T18:23:20.004023+00:00 423292.0
exp_2022_11_04_10 200 leopard 75 1667586200.0090227 2022-11-04T18:23:20.009023+00:00 423283.0
exp_2022_11_04_10 200 leopard 76 1667586200.0140228 2022-11-04T18:23:20.014023+00:00 423273.0
exp_2022_11_04_10 200 leopard 77 1667586200.0190227 2022-11-04T18:23:20.019023+00:00 423264.0
exp_2022_11_04_10 200 leopard 78 1667586200.0240228 2022-11-04T18:23:20.024023+00:00 423255.0
exp_2022_11_04_10 200 leopard 79 1667586200.0290227 2022-11-04T18:23:20.029023+00:00 423246.0
exp_2022_11_04_10 200 leopard 80 1667586200.0340228 2022-11-04T18:23:20.034023+00:00 423236.0
exp_2022_11_04_10 200 leopard 81 1667586200.0390227 2022-11-04T18:23:20.039023+00:00 423227.0
exp_2022_11_04_10 200 leopard 82 1667586200.0440228 2022-11-04T18:23:20.044023+00:00 423218.0
exp_2022_11_04_10 200 leopard 83 1667586200.0490227 2022-11-04T18:23:20.049023+00:00 423209.0
exp_2022_11_04_10 200 leopard 84 1667586200.0540228 2022-11-04T18:23:20.054023+00:00 423199.0
exp_2022_11_04_10 200 leopard 85 1667586200.0590227 2022-11-04T18:23:20.059023+00:00 423190.0
exp_2022_11_04_10 200 leopard 86 1667586200.0640228 2022-11-04T18:23:20.064023+00:00 423181.0
exp_2022_11_04_10 200 leopard 87 1667586200.0690227 2022-11-04T18:23:20.069023+00:00 423172.0
exp_2022_11_04_10 200 leopard 88 1667586200.0740228 2022-11-04T18:23:20.074023+00:00 423162.0
exp_2022_11_04_10 200 leopard 89 1667586200.0790226 2022-11-04T18:23:20.079023+00:00 423153.0
exp_2022_11_04_10 200 leopard 90 1667586200.0840228 2022-11-04T18:23:20.084023+00:00 423144.0
exp_2022_11_04_10 200 leopard 91 1667586200.0890226 2022-11-04T18:23:20.089023+00:00 423135.0
exp_2022_11_04_10 200 leopard 92 1667586200.0940228 2022-11-04T18:23:20.094023+00:00 423126.0
exp_2022_11_04_10 200 leopard 93 1667586200.0990226 2022-11-04T18:23:20.099023+00:00 423117.0
exp_2022_11_04_10 200 leopard 94 1667586200.1040227 2022-11-04T18:23:20.104023+00:00 423108.0
exp_2022_11_04_10 200 leopard 95 1667586200.1090226 2022-11-04T18:23:20.109023+00:00 423099.0
exp_2022_11_04_10 200 leopard 96 1667586200.1140227 2022-11-04T18:23:20.114023+00:00 423090.0
exp_2022_11_04_10 200 leopard 97 1667586200.1190226 2022-11-04T18:23:20.119023+00:00 423081.0
exp_2022_11_04_10 200 leopard 98 1667586200.1240227 2022-11-04T18:23:20.124023+00:00 423072.0
exp_2022_11_04_10 200 leopard 99 1667586200.1290226 2022-11-04T18:23:20.129023+00:00 423063.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]);