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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_01_10 200 lion 0 1667326799.8491125 2022-11-01T18:19:59.849113+00:00 714424.0
exp_2022_11_01_10 200 lion 1 1667326799.8541126 2022-11-01T18:19:59.854113+00:00 714360.0
exp_2022_11_01_10 200 lion 2 1667326799.8591125 2022-11-01T18:19:59.859113+00:00 714295.0
exp_2022_11_01_10 200 lion 3 1667326799.8641126 2022-11-01T18:19:59.864113+00:00 714230.0
exp_2022_11_01_10 200 lion 4 1667326799.8691125 2022-11-01T18:19:59.869112+00:00 714164.0
exp_2022_11_01_10 200 lion 5 1667326799.8741126 2022-11-01T18:19:59.874113+00:00 714098.0
exp_2022_11_01_10 200 lion 6 1667326799.8791125 2022-11-01T18:19:59.879112+00:00 714031.0
exp_2022_11_01_10 200 lion 7 1667326799.8841126 2022-11-01T18:19:59.884113+00:00 713963.0
exp_2022_11_01_10 200 lion 8 1667326799.8891125 2022-11-01T18:19:59.889112+00:00 713894.0
exp_2022_11_01_10 200 lion 9 1667326799.8941126 2022-11-01T18:19:59.894113+00:00 713824.0
exp_2022_11_01_10 200 lion 10 1667326799.8991125 2022-11-01T18:19:59.899112+00:00 713752.0
exp_2022_11_01_10 200 lion 11 1667326799.9041126 2022-11-01T18:19:59.904113+00:00 713680.0
exp_2022_11_01_10 200 lion 12 1667326799.9091125 2022-11-01T18:19:59.909112+00:00 713606.0
exp_2022_11_01_10 200 lion 13 1667326799.9141126 2022-11-01T18:19:59.914113+00:00 713530.0
exp_2022_11_01_10 200 lion 14 1667326799.9191124 2022-11-01T18:19:59.919112+00:00 713452.0
exp_2022_11_01_10 200 lion 15 1667326799.9241126 2022-11-01T18:19:59.924113+00:00 713373.0
exp_2022_11_01_10 200 lion 16 1667326799.9291124 2022-11-01T18:19:59.929112+00:00 713292.0
exp_2022_11_01_10 200 lion 17 1667326799.9341125 2022-11-01T18:19:59.934113+00:00 713209.0
exp_2022_11_01_10 200 lion 18 1667326799.9391124 2022-11-01T18:19:59.939112+00:00 713124.0
exp_2022_11_01_10 200 lion 19 1667326799.9441125 2022-11-01T18:19:59.944113+00:00 713036.0
exp_2022_11_01_10 200 lion 20 1667326799.9491124 2022-11-01T18:19:59.949112+00:00 712947.0
exp_2022_11_01_10 200 lion 21 1667326799.9541125 2022-11-01T18:19:59.954113+00:00 712854.0
exp_2022_11_01_10 200 lion 22 1667326799.9591124 2022-11-01T18:19:59.959112+00:00 712759.0
exp_2022_11_01_10 200 lion 23 1667326799.9641125 2022-11-01T18:19:59.964113+00:00 712662.0
exp_2022_11_01_10 200 lion 24 1667326799.9691124 2022-11-01T18:19:59.969112+00:00 712562.0
exp_2022_11_01_10 200 lion 25 1667326799.9741125 2022-11-01T18:19:59.974113+00:00 712459.0
exp_2022_11_01_10 200 lion 26 1667326799.9791126 2022-11-01T18:19:59.979113+00:00 712353.0
exp_2022_11_01_10 200 lion 27 1667326799.9841125 2022-11-01T18:19:59.984113+00:00 712244.0
exp_2022_11_01_10 200 lion 28 1667326799.9891126 2022-11-01T18:19:59.989113+00:00 712133.0
exp_2022_11_01_10 200 lion 29 1667326799.9941125 2022-11-01T18:19:59.994112+00:00 712019.0
exp_2022_11_01_10 200 lion 30 1667326799.9991126 2022-11-01T18:19:59.999113+00:00 711901.0
exp_2022_11_01_10 200 lion 31 1667326800.0041125 2022-11-01T18:20:00.004112+00:00 711781.0
exp_2022_11_01_10 200 lion 32 1667326800.0091126 2022-11-01T18:20:00.009113+00:00 711658.0
exp_2022_11_01_10 200 lion 33 1667326800.0141125 2022-11-01T18:20:00.014112+00:00 711532.0
exp_2022_11_01_10 200 lion 34 1667326800.0191126 2022-11-01T18:20:00.019113+00:00 711404.0
exp_2022_11_01_10 200 lion 35 1667326800.0241125 2022-11-01T18:20:00.024112+00:00 711272.0
exp_2022_11_01_10 200 lion 36 1667326800.0291126 2022-11-01T18:20:00.029113+00:00 711138.0
exp_2022_11_01_10 200 lion 37 1667326800.0341125 2022-11-01T18:20:00.034112+00:00 711001.0
exp_2022_11_01_10 200 lion 38 1667326800.0391126 2022-11-01T18:20:00.039113+00:00 710862.0
exp_2022_11_01_10 200 lion 39 1667326800.0441124 2022-11-01T18:20:00.044112+00:00 710721.0
exp_2022_11_01_10 200 lion 40 1667326800.0491126 2022-11-01T18:20:00.049113+00:00 710577.0
exp_2022_11_01_10 200 lion 41 1667326800.0541124 2022-11-01T18:20:00.054112+00:00 710432.0
exp_2022_11_01_10 200 lion 42 1667326800.0591125 2022-11-01T18:20:00.059113+00:00 710284.0
exp_2022_11_01_10 200 lion 43 1667326800.0641124 2022-11-01T18:20:00.064112+00:00 710135.0
exp_2022_11_01_10 200 lion 44 1667326800.0691125 2022-11-01T18:20:00.069113+00:00 709985.0
exp_2022_11_01_10 200 lion 45 1667326800.0741124 2022-11-01T18:20:00.074112+00:00 709834.0
exp_2022_11_01_10 200 lion 46 1667326800.0791125 2022-11-01T18:20:00.079113+00:00 709681.0
exp_2022_11_01_10 200 lion 47 1667326800.0841124 2022-11-01T18:20:00.084112+00:00 709528.0
exp_2022_11_01_10 200 lion 48 1667326800.0891125 2022-11-01T18:20:00.089113+00:00 709374.0
exp_2022_11_01_10 200 lion 49 1667326800.0941124 2022-11-01T18:20:00.094112+00:00 709221.0
exp_2022_11_01_10 200 lion 50 1667326800.0991125 2022-11-01T18:20:00.099113+00:00 709067.0
exp_2022_11_01_10 200 lion 51 1667326800.1041126 2022-11-01T18:20:00.104113+00:00 708914.0
exp_2022_11_01_10 200 lion 52 1667326800.1091125 2022-11-01T18:20:00.109113+00:00 708762.0
exp_2022_11_01_10 200 lion 53 1667326800.1141126 2022-11-01T18:20:00.114113+00:00 708612.0
exp_2022_11_01_10 200 lion 54 1667326800.1191125 2022-11-01T18:20:00.119112+00:00 708462.0
exp_2022_11_01_10 200 lion 55 1667326800.1241126 2022-11-01T18:20:00.124113+00:00 708315.0
exp_2022_11_01_10 200 lion 56 1667326800.1291125 2022-11-01T18:20:00.129112+00:00 708170.0
exp_2022_11_01_10 200 lion 57 1667326800.1341126 2022-11-01T18:20:00.134113+00:00 708027.0
exp_2022_11_01_10 200 lion 58 1667326800.1391125 2022-11-01T18:20:00.139112+00:00 707888.0
exp_2022_11_01_10 200 lion 59 1667326800.1441126 2022-11-01T18:20:00.144113+00:00 707751.0
exp_2022_11_01_10 200 lion 60 1667326800.1491125 2022-11-01T18:20:00.149112+00:00 707619.0
exp_2022_11_01_10 200 lion 61 1667326800.1541126 2022-11-01T18:20:00.154113+00:00 707490.0
exp_2022_11_01_10 200 lion 62 1667326800.1591125 2022-11-01T18:20:00.159112+00:00 707366.0
exp_2022_11_01_10 200 lion 63 1667326800.1641126 2022-11-01T18:20:00.164113+00:00 707247.0
exp_2022_11_01_10 200 lion 64 1667326800.1691124 2022-11-01T18:20:00.169112+00:00 707132.0
exp_2022_11_01_10 200 lion 65 1667326800.1741126 2022-11-01T18:20:00.174113+00:00 707023.0
exp_2022_11_01_10 200 lion 66 1667326800.1791124 2022-11-01T18:20:00.179112+00:00 706920.0
exp_2022_11_01_10 200 lion 67 1667326800.1841125 2022-11-01T18:20:00.184113+00:00 706823.0
exp_2022_11_01_10 200 lion 68 1667326800.1891124 2022-11-01T18:20:00.189112+00:00 706732.0
exp_2022_11_01_10 200 lion 69 1667326800.1941125 2022-11-01T18:20:00.194113+00:00 706647.0
exp_2022_11_01_10 200 lion 70 1667326800.1991124 2022-11-01T18:20:00.199112+00:00 706570.0
exp_2022_11_01_10 200 lion 71 1667326800.2041125 2022-11-01T18:20:00.204113+00:00 706499.0
exp_2022_11_01_10 200 lion 72 1667326800.2091124 2022-11-01T18:20:00.209112+00:00 706435.0
exp_2022_11_01_10 200 lion 73 1667326800.2141125 2022-11-01T18:20:00.214113+00:00 706379.0
exp_2022_11_01_10 200 lion 74 1667326800.2191124 2022-11-01T18:20:00.219112+00:00 706331.0
exp_2022_11_01_10 200 lion 75 1667326800.2241125 2022-11-01T18:20:00.224113+00:00 706290.0
exp_2022_11_01_10 200 lion 76 1667326800.2291126 2022-11-01T18:20:00.229113+00:00 706256.0
exp_2022_11_01_10 200 lion 77 1667326800.2341125 2022-11-01T18:20:00.234113+00:00 706231.0
exp_2022_11_01_10 200 lion 78 1667326800.2391126 2022-11-01T18:20:00.239113+00:00 706214.0
exp_2022_11_01_10 200 lion 79 1667326800.2441125 2022-11-01T18:20:00.244112+00:00 706204.0
exp_2022_11_01_10 200 lion 80 1667326800.2491126 2022-11-01T18:20:00.249113+00:00 706202.0
exp_2022_11_01_10 200 lion 81 1667326800.2541125 2022-11-01T18:20:00.254112+00:00 706207.0
exp_2022_11_01_10 200 lion 82 1667326800.2591126 2022-11-01T18:20:00.259113+00:00 706221.0
exp_2022_11_01_10 200 lion 83 1667326800.2641125 2022-11-01T18:20:00.264112+00:00 706242.0
exp_2022_11_01_10 200 lion 84 1667326800.2691126 2022-11-01T18:20:00.269113+00:00 706270.0
exp_2022_11_01_10 200 lion 85 1667326800.2741125 2022-11-01T18:20:00.274112+00:00 706306.0
exp_2022_11_01_10 200 lion 86 1667326800.2791126 2022-11-01T18:20:00.279113+00:00 706349.0
exp_2022_11_01_10 200 lion 87 1667326800.2841125 2022-11-01T18:20:00.284112+00:00 706398.0
exp_2022_11_01_10 200 lion 88 1667326800.2891126 2022-11-01T18:20:00.289113+00:00 706454.0
exp_2022_11_01_10 200 lion 89 1667326800.2941124 2022-11-01T18:20:00.294112+00:00 706517.0
exp_2022_11_01_10 200 lion 90 1667326800.2991126 2022-11-01T18:20:00.299113+00:00 706585.0
exp_2022_11_01_10 200 lion 91 1667326800.3041124 2022-11-01T18:20:00.304112+00:00 706660.0
exp_2022_11_01_10 200 lion 92 1667326800.3091125 2022-11-01T18:20:00.309113+00:00 706739.0
exp_2022_11_01_10 200 lion 93 1667326800.3141124 2022-11-01T18:20:00.314112+00:00 706823.0
exp_2022_11_01_10 200 lion 94 1667326800.3191125 2022-11-01T18:20:00.319113+00:00 706913.0
exp_2022_11_01_10 200 lion 95 1667326800.3241124 2022-11-01T18:20:00.324112+00:00 707006.0
exp_2022_11_01_10 200 lion 96 1667326800.3291125 2022-11-01T18:20:00.329113+00:00 707103.0
exp_2022_11_01_10 200 lion 97 1667326800.3341124 2022-11-01T18:20:00.334112+00:00 707203.0
exp_2022_11_01_10 200 lion 98 1667326800.3391125 2022-11-01T18:20:00.339113+00:00 707307.0
exp_2022_11_01_10 200 lion 99 1667326800.3441124 2022-11-01T18:20:00.344112+00:00 707413.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]);