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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_22_10 200 leopard 0 1669141411.9815924 2022-11-22T18:23:31.981592+00:00 246828.0
exp_2022_11_22_10 200 leopard 1 1669141411.9865925 2022-11-22T18:23:31.986593+00:00 246802.0
exp_2022_11_22_10 200 leopard 2 1669141411.9915924 2022-11-22T18:23:31.991592+00:00 246776.0
exp_2022_11_22_10 200 leopard 3 1669141411.9965925 2022-11-22T18:23:31.996593+00:00 246750.0
exp_2022_11_22_10 200 leopard 4 1669141412.0015924 2022-11-22T18:23:32.001592+00:00 246723.0
exp_2022_11_22_10 200 leopard 5 1669141412.0065925 2022-11-22T18:23:32.006593+00:00 246697.0
exp_2022_11_22_10 200 leopard 6 1669141412.0115924 2022-11-22T18:23:32.011592+00:00 246671.0
exp_2022_11_22_10 200 leopard 7 1669141412.0165925 2022-11-22T18:23:32.016593+00:00 246644.0
exp_2022_11_22_10 200 leopard 8 1669141412.0215924 2022-11-22T18:23:32.021592+00:00 246617.0
exp_2022_11_22_10 200 leopard 9 1669141412.0265925 2022-11-22T18:23:32.026592+00:00 246591.0
exp_2022_11_22_10 200 leopard 10 1669141412.0315924 2022-11-22T18:23:32.031592+00:00 246564.0
exp_2022_11_22_10 200 leopard 11 1669141412.0365925 2022-11-22T18:23:32.036592+00:00 246537.0
exp_2022_11_22_10 200 leopard 12 1669141412.0415924 2022-11-22T18:23:32.041592+00:00 246509.0
exp_2022_11_22_10 200 leopard 13 1669141412.0465925 2022-11-22T18:23:32.046592+00:00 246482.0
exp_2022_11_22_10 200 leopard 14 1669141412.0515924 2022-11-22T18:23:32.051592+00:00 246455.0
exp_2022_11_22_10 200 leopard 15 1669141412.0565925 2022-11-22T18:23:32.056592+00:00 246427.0
exp_2022_11_22_10 200 leopard 16 1669141412.0615923 2022-11-22T18:23:32.061592+00:00 246400.0
exp_2022_11_22_10 200 leopard 17 1669141412.0665925 2022-11-22T18:23:32.066592+00:00 246372.0
exp_2022_11_22_10 200 leopard 18 1669141412.0715923 2022-11-22T18:23:32.071592+00:00 246344.0
exp_2022_11_22_10 200 leopard 19 1669141412.0765924 2022-11-22T18:23:32.076592+00:00 246316.0
exp_2022_11_22_10 200 leopard 20 1669141412.0815923 2022-11-22T18:23:32.081592+00:00 246288.0
exp_2022_11_22_10 200 leopard 21 1669141412.0865924 2022-11-22T18:23:32.086592+00:00 246260.0
exp_2022_11_22_10 200 leopard 22 1669141412.0915923 2022-11-22T18:23:32.091592+00:00 246232.0
exp_2022_11_22_10 200 leopard 23 1669141412.0965924 2022-11-22T18:23:32.096592+00:00 246203.0
exp_2022_11_22_10 200 leopard 24 1669141412.1015923 2022-11-22T18:23:32.101592+00:00 246175.0
exp_2022_11_22_10 200 leopard 25 1669141412.1065924 2022-11-22T18:23:32.106592+00:00 246147.0
exp_2022_11_22_10 200 leopard 26 1669141412.1115925 2022-11-22T18:23:32.111593+00:00 246118.0
exp_2022_11_22_10 200 leopard 27 1669141412.1165924 2022-11-22T18:23:32.116592+00:00 246089.0
exp_2022_11_22_10 200 leopard 28 1669141412.1215925 2022-11-22T18:23:32.121593+00:00 246060.0
exp_2022_11_22_10 200 leopard 29 1669141412.1265924 2022-11-22T18:23:32.126592+00:00 246032.0
exp_2022_11_22_10 200 leopard 30 1669141412.1315925 2022-11-22T18:23:32.131593+00:00 246003.0
exp_2022_11_22_10 200 leopard 31 1669141412.1365924 2022-11-22T18:23:32.136592+00:00 245973.0
exp_2022_11_22_10 200 leopard 32 1669141412.1415925 2022-11-22T18:23:32.141593+00:00 245944.0
exp_2022_11_22_10 200 leopard 33 1669141412.1465924 2022-11-22T18:23:32.146592+00:00 245915.0
exp_2022_11_22_10 200 leopard 34 1669141412.1515925 2022-11-22T18:23:32.151592+00:00 245886.0
exp_2022_11_22_10 200 leopard 35 1669141412.1565924 2022-11-22T18:23:32.156592+00:00 245856.0
exp_2022_11_22_10 200 leopard 36 1669141412.1615925 2022-11-22T18:23:32.161592+00:00 245826.0
exp_2022_11_22_10 200 leopard 37 1669141412.1665924 2022-11-22T18:23:32.166592+00:00 245797.0
exp_2022_11_22_10 200 leopard 38 1669141412.1715925 2022-11-22T18:23:32.171592+00:00 245767.0
exp_2022_11_22_10 200 leopard 39 1669141412.1765924 2022-11-22T18:23:32.176592+00:00 245737.0
exp_2022_11_22_10 200 leopard 40 1669141412.1815925 2022-11-22T18:23:32.181592+00:00 245707.0
exp_2022_11_22_10 200 leopard 41 1669141412.1865923 2022-11-22T18:23:32.186592+00:00 245678.0
exp_2022_11_22_10 200 leopard 42 1669141412.1915925 2022-11-22T18:23:32.191592+00:00 245647.0
exp_2022_11_22_10 200 leopard 43 1669141412.1965923 2022-11-22T18:23:32.196592+00:00 245617.0
exp_2022_11_22_10 200 leopard 44 1669141412.2015924 2022-11-22T18:23:32.201592+00:00 245587.0
exp_2022_11_22_10 200 leopard 45 1669141412.2065923 2022-11-22T18:23:32.206592+00:00 245557.0
exp_2022_11_22_10 200 leopard 46 1669141412.2115924 2022-11-22T18:23:32.211592+00:00 245526.0
exp_2022_11_22_10 200 leopard 47 1669141412.2165923 2022-11-22T18:23:32.216592+00:00 245496.0
exp_2022_11_22_10 200 leopard 48 1669141412.2215924 2022-11-22T18:23:32.221592+00:00 245465.0
exp_2022_11_22_10 200 leopard 49 1669141412.2265923 2022-11-22T18:23:32.226592+00:00 245435.0
exp_2022_11_22_10 200 leopard 50 1669141412.2315924 2022-11-22T18:23:32.231592+00:00 245404.0
exp_2022_11_22_10 200 leopard 51 1669141412.2365925 2022-11-22T18:23:32.236593+00:00 245373.0
exp_2022_11_22_10 200 leopard 52 1669141412.2415924 2022-11-22T18:23:32.241592+00:00 245342.0
exp_2022_11_22_10 200 leopard 53 1669141412.2465925 2022-11-22T18:23:32.246593+00:00 245312.0
exp_2022_11_22_10 200 leopard 54 1669141412.2515924 2022-11-22T18:23:32.251592+00:00 245281.0
exp_2022_11_22_10 200 leopard 55 1669141412.2565925 2022-11-22T18:23:32.256593+00:00 245250.0
exp_2022_11_22_10 200 leopard 56 1669141412.2615924 2022-11-22T18:23:32.261592+00:00 245219.0
exp_2022_11_22_10 200 leopard 57 1669141412.2665925 2022-11-22T18:23:32.266593+00:00 245188.0
exp_2022_11_22_10 200 leopard 58 1669141412.2715924 2022-11-22T18:23:32.271592+00:00 245157.0
exp_2022_11_22_10 200 leopard 59 1669141412.2765925 2022-11-22T18:23:32.276592+00:00 245125.0
exp_2022_11_22_10 200 leopard 60 1669141412.2815924 2022-11-22T18:23:32.281592+00:00 245094.0
exp_2022_11_22_10 200 leopard 61 1669141412.2865925 2022-11-22T18:23:32.286592+00:00 245063.0
exp_2022_11_22_10 200 leopard 62 1669141412.2915924 2022-11-22T18:23:32.291592+00:00 245032.0
exp_2022_11_22_10 200 leopard 63 1669141412.2965925 2022-11-22T18:23:32.296592+00:00 245000.0
exp_2022_11_22_10 200 leopard 64 1669141412.3015924 2022-11-22T18:23:32.301592+00:00 244969.0
exp_2022_11_22_10 200 leopard 65 1669141412.3065925 2022-11-22T18:23:32.306592+00:00 244938.0
exp_2022_11_22_10 200 leopard 66 1669141412.3115923 2022-11-22T18:23:32.311592+00:00 244906.0
exp_2022_11_22_10 200 leopard 67 1669141412.3165925 2022-11-22T18:23:32.316592+00:00 244875.0
exp_2022_11_22_10 200 leopard 68 1669141412.3215923 2022-11-22T18:23:32.321592+00:00 244844.0
exp_2022_11_22_10 200 leopard 69 1669141412.3265924 2022-11-22T18:23:32.326592+00:00 244812.0
exp_2022_11_22_10 200 leopard 70 1669141412.3315923 2022-11-22T18:23:32.331592+00:00 244781.0
exp_2022_11_22_10 200 leopard 71 1669141412.3365924 2022-11-22T18:23:32.336592+00:00 244749.0
exp_2022_11_22_10 200 leopard 72 1669141412.3415923 2022-11-22T18:23:32.341592+00:00 244718.0
exp_2022_11_22_10 200 leopard 73 1669141412.3465924 2022-11-22T18:23:32.346592+00:00 244687.0
exp_2022_11_22_10 200 leopard 74 1669141412.3515923 2022-11-22T18:23:32.351592+00:00 244655.0
exp_2022_11_22_10 200 leopard 75 1669141412.3565924 2022-11-22T18:23:32.356592+00:00 244624.0
exp_2022_11_22_10 200 leopard 76 1669141412.3615925 2022-11-22T18:23:32.361593+00:00 244592.0
exp_2022_11_22_10 200 leopard 77 1669141412.3665924 2022-11-22T18:23:32.366592+00:00 244561.0
exp_2022_11_22_10 200 leopard 78 1669141412.3715925 2022-11-22T18:23:32.371593+00:00 244530.0
exp_2022_11_22_10 200 leopard 79 1669141412.3765924 2022-11-22T18:23:32.376592+00:00 244498.0
exp_2022_11_22_10 200 leopard 80 1669141412.3815925 2022-11-22T18:23:32.381593+00:00 244467.0
exp_2022_11_22_10 200 leopard 81 1669141412.3865924 2022-11-22T18:23:32.386592+00:00 244436.0
exp_2022_11_22_10 200 leopard 82 1669141412.3915925 2022-11-22T18:23:32.391593+00:00 244404.0
exp_2022_11_22_10 200 leopard 83 1669141412.3965924 2022-11-22T18:23:32.396592+00:00 244373.0
exp_2022_11_22_10 200 leopard 84 1669141412.4015925 2022-11-22T18:23:32.401592+00:00 244342.0
exp_2022_11_22_10 200 leopard 85 1669141412.4065924 2022-11-22T18:23:32.406592+00:00 244311.0
exp_2022_11_22_10 200 leopard 86 1669141412.4115925 2022-11-22T18:23:32.411592+00:00 244280.0
exp_2022_11_22_10 200 leopard 87 1669141412.4165924 2022-11-22T18:23:32.416592+00:00 244249.0
exp_2022_11_22_10 200 leopard 88 1669141412.4215925 2022-11-22T18:23:32.421592+00:00 244218.0
exp_2022_11_22_10 200 leopard 89 1669141412.4265924 2022-11-22T18:23:32.426592+00:00 244187.0
exp_2022_11_22_10 200 leopard 90 1669141412.4315925 2022-11-22T18:23:32.431592+00:00 244156.0
exp_2022_11_22_10 200 leopard 91 1669141412.4365923 2022-11-22T18:23:32.436592+00:00 244125.0
exp_2022_11_22_10 200 leopard 92 1669141412.4415925 2022-11-22T18:23:32.441592+00:00 244094.0
exp_2022_11_22_10 200 leopard 93 1669141412.4465923 2022-11-22T18:23:32.446592+00:00 244063.0
exp_2022_11_22_10 200 leopard 94 1669141412.4515924 2022-11-22T18:23:32.451592+00:00 244032.0
exp_2022_11_22_10 200 leopard 95 1669141412.4565923 2022-11-22T18:23:32.456592+00:00 244002.0
exp_2022_11_22_10 200 leopard 96 1669141412.4615924 2022-11-22T18:23:32.461592+00:00 243971.0
exp_2022_11_22_10 200 leopard 97 1669141412.4665923 2022-11-22T18:23:32.466592+00:00 243940.0
exp_2022_11_22_10 200 leopard 98 1669141412.4715924 2022-11-22T18:23:32.471592+00:00 243910.0
exp_2022_11_22_10 200 leopard 99 1669141412.4765923 2022-11-22T18:23:32.476592+00:00 243879.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]);