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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_10_14_10 200 leopard 0 1665771811.514909 2022-10-14T18:23:31.514909+00:00 375220.0
exp_2022_10_14_10 200 leopard 1 1665771811.5199091 2022-10-14T18:23:31.519909+00:00 375259.0
exp_2022_10_14_10 200 leopard 2 1665771811.524909 2022-10-14T18:23:31.524909+00:00 375298.0
exp_2022_10_14_10 200 leopard 3 1665771811.5299091 2022-10-14T18:23:31.529909+00:00 375339.0
exp_2022_10_14_10 200 leopard 4 1665771811.534909 2022-10-14T18:23:31.534909+00:00 375380.0
exp_2022_10_14_10 200 leopard 5 1665771811.5399091 2022-10-14T18:23:31.539909+00:00 375421.0
exp_2022_10_14_10 200 leopard 6 1665771811.544909 2022-10-14T18:23:31.544909+00:00 375463.0
exp_2022_10_14_10 200 leopard 7 1665771811.549909 2022-10-14T18:23:31.549909+00:00 375506.0
exp_2022_10_14_10 200 leopard 8 1665771811.554909 2022-10-14T18:23:31.554909+00:00 375550.0
exp_2022_10_14_10 200 leopard 9 1665771811.559909 2022-10-14T18:23:31.559909+00:00 375594.0
exp_2022_10_14_10 200 leopard 10 1665771811.564909 2022-10-14T18:23:31.564909+00:00 375639.0
exp_2022_10_14_10 200 leopard 11 1665771811.569909 2022-10-14T18:23:31.569909+00:00 375685.0
exp_2022_10_14_10 200 leopard 12 1665771811.574909 2022-10-14T18:23:31.574909+00:00 375732.0
exp_2022_10_14_10 200 leopard 13 1665771811.579909 2022-10-14T18:23:31.579909+00:00 375779.0
exp_2022_10_14_10 200 leopard 14 1665771811.584909 2022-10-14T18:23:31.584909+00:00 375827.0
exp_2022_10_14_10 200 leopard 15 1665771811.589909 2022-10-14T18:23:31.589909+00:00 375877.0
exp_2022_10_14_10 200 leopard 16 1665771811.594909 2022-10-14T18:23:31.594909+00:00 375927.0
exp_2022_10_14_10 200 leopard 17 1665771811.599909 2022-10-14T18:23:31.599909+00:00 375978.0
exp_2022_10_14_10 200 leopard 18 1665771811.604909 2022-10-14T18:23:31.604909+00:00 376030.0
exp_2022_10_14_10 200 leopard 19 1665771811.609909 2022-10-14T18:23:31.609909+00:00 376084.0
exp_2022_10_14_10 200 leopard 20 1665771811.614909 2022-10-14T18:23:31.614909+00:00 376138.0
exp_2022_10_14_10 200 leopard 21 1665771811.619909 2022-10-14T18:23:31.619909+00:00 376193.0
exp_2022_10_14_10 200 leopard 22 1665771811.624909 2022-10-14T18:23:31.624909+00:00 376250.0
exp_2022_10_14_10 200 leopard 23 1665771811.629909 2022-10-14T18:23:31.629909+00:00 376308.0
exp_2022_10_14_10 200 leopard 24 1665771811.634909 2022-10-14T18:23:31.634909+00:00 376368.0
exp_2022_10_14_10 200 leopard 25 1665771811.639909 2022-10-14T18:23:31.639909+00:00 376428.0
exp_2022_10_14_10 200 leopard 26 1665771811.6449091 2022-10-14T18:23:31.644909+00:00 376490.0
exp_2022_10_14_10 200 leopard 27 1665771811.649909 2022-10-14T18:23:31.649909+00:00 376553.0
exp_2022_10_14_10 200 leopard 28 1665771811.6549091 2022-10-14T18:23:31.654909+00:00 376618.0
exp_2022_10_14_10 200 leopard 29 1665771811.659909 2022-10-14T18:23:31.659909+00:00 376684.0
exp_2022_10_14_10 200 leopard 30 1665771811.6649091 2022-10-14T18:23:31.664909+00:00 376752.0
exp_2022_10_14_10 200 leopard 31 1665771811.669909 2022-10-14T18:23:31.669909+00:00 376822.0
exp_2022_10_14_10 200 leopard 32 1665771811.674909 2022-10-14T18:23:31.674909+00:00 376892.0
exp_2022_10_14_10 200 leopard 33 1665771811.679909 2022-10-14T18:23:31.679909+00:00 376964.0
exp_2022_10_14_10 200 leopard 34 1665771811.684909 2022-10-14T18:23:31.684909+00:00 377038.0
exp_2022_10_14_10 200 leopard 35 1665771811.689909 2022-10-14T18:23:31.689909+00:00 377113.0
exp_2022_10_14_10 200 leopard 36 1665771811.694909 2022-10-14T18:23:31.694909+00:00 377190.0
exp_2022_10_14_10 200 leopard 37 1665771811.699909 2022-10-14T18:23:31.699909+00:00 377267.0
exp_2022_10_14_10 200 leopard 38 1665771811.704909 2022-10-14T18:23:31.704909+00:00 377346.0
exp_2022_10_14_10 200 leopard 39 1665771811.709909 2022-10-14T18:23:31.709909+00:00 377427.0
exp_2022_10_14_10 200 leopard 40 1665771811.714909 2022-10-14T18:23:31.714909+00:00 377508.0
exp_2022_10_14_10 200 leopard 41 1665771811.719909 2022-10-14T18:23:31.719909+00:00 377590.0
exp_2022_10_14_10 200 leopard 42 1665771811.724909 2022-10-14T18:23:31.724909+00:00 377673.0
exp_2022_10_14_10 200 leopard 43 1665771811.729909 2022-10-14T18:23:31.729909+00:00 377757.0
exp_2022_10_14_10 200 leopard 44 1665771811.734909 2022-10-14T18:23:31.734909+00:00 377842.0
exp_2022_10_14_10 200 leopard 45 1665771811.739909 2022-10-14T18:23:31.739909+00:00 377926.0
exp_2022_10_14_10 200 leopard 46 1665771811.744909 2022-10-14T18:23:31.744909+00:00 378011.0
exp_2022_10_14_10 200 leopard 47 1665771811.749909 2022-10-14T18:23:31.749909+00:00 378096.0
exp_2022_10_14_10 200 leopard 48 1665771811.754909 2022-10-14T18:23:31.754909+00:00 378181.0
exp_2022_10_14_10 200 leopard 49 1665771811.759909 2022-10-14T18:23:31.759909+00:00 378266.0
exp_2022_10_14_10 200 leopard 50 1665771811.764909 2022-10-14T18:23:31.764909+00:00 378349.0
exp_2022_10_14_10 200 leopard 51 1665771811.7699091 2022-10-14T18:23:31.769909+00:00 378432.0
exp_2022_10_14_10 200 leopard 52 1665771811.774909 2022-10-14T18:23:31.774909+00:00 378515.0
exp_2022_10_14_10 200 leopard 53 1665771811.7799091 2022-10-14T18:23:31.779909+00:00 378595.0
exp_2022_10_14_10 200 leopard 54 1665771811.784909 2022-10-14T18:23:31.784909+00:00 378674.0
exp_2022_10_14_10 200 leopard 55 1665771811.7899091 2022-10-14T18:23:31.789909+00:00 378752.0
exp_2022_10_14_10 200 leopard 56 1665771811.794909 2022-10-14T18:23:31.794909+00:00 378828.0
exp_2022_10_14_10 200 leopard 57 1665771811.799909 2022-10-14T18:23:31.799909+00:00 378901.0
exp_2022_10_14_10 200 leopard 58 1665771811.804909 2022-10-14T18:23:31.804909+00:00 378972.0
exp_2022_10_14_10 200 leopard 59 1665771811.809909 2022-10-14T18:23:31.809909+00:00 379040.0
exp_2022_10_14_10 200 leopard 60 1665771811.814909 2022-10-14T18:23:31.814909+00:00 379106.0
exp_2022_10_14_10 200 leopard 61 1665771811.819909 2022-10-14T18:23:31.819909+00:00 379168.0
exp_2022_10_14_10 200 leopard 62 1665771811.824909 2022-10-14T18:23:31.824909+00:00 379227.0
exp_2022_10_14_10 200 leopard 63 1665771811.829909 2022-10-14T18:23:31.829909+00:00 379282.0
exp_2022_10_14_10 200 leopard 64 1665771811.834909 2022-10-14T18:23:31.834909+00:00 379335.0
exp_2022_10_14_10 200 leopard 65 1665771811.839909 2022-10-14T18:23:31.839909+00:00 379383.0
exp_2022_10_14_10 200 leopard 66 1665771811.844909 2022-10-14T18:23:31.844909+00:00 379427.0
exp_2022_10_14_10 200 leopard 67 1665771811.849909 2022-10-14T18:23:31.849909+00:00 379468.0
exp_2022_10_14_10 200 leopard 68 1665771811.854909 2022-10-14T18:23:31.854909+00:00 379504.0
exp_2022_10_14_10 200 leopard 69 1665771811.859909 2022-10-14T18:23:31.859909+00:00 379537.0
exp_2022_10_14_10 200 leopard 70 1665771811.864909 2022-10-14T18:23:31.864909+00:00 379565.0
exp_2022_10_14_10 200 leopard 71 1665771811.869909 2022-10-14T18:23:31.869909+00:00 379589.0
exp_2022_10_14_10 200 leopard 72 1665771811.874909 2022-10-14T18:23:31.874909+00:00 379609.0
exp_2022_10_14_10 200 leopard 73 1665771811.879909 2022-10-14T18:23:31.879909+00:00 379624.0
exp_2022_10_14_10 200 leopard 74 1665771811.884909 2022-10-14T18:23:31.884909+00:00 379635.0
exp_2022_10_14_10 200 leopard 75 1665771811.889909 2022-10-14T18:23:31.889909+00:00 379643.0
exp_2022_10_14_10 200 leopard 76 1665771811.8949091 2022-10-14T18:23:31.894909+00:00 379646.0
exp_2022_10_14_10 200 leopard 77 1665771811.899909 2022-10-14T18:23:31.899909+00:00 379646.0
exp_2022_10_14_10 200 leopard 78 1665771811.9049091 2022-10-14T18:23:31.904909+00:00 379641.0
exp_2022_10_14_10 200 leopard 79 1665771811.909909 2022-10-14T18:23:31.909909+00:00 379634.0
exp_2022_10_14_10 200 leopard 80 1665771811.9149091 2022-10-14T18:23:31.914909+00:00 379623.0
exp_2022_10_14_10 200 leopard 81 1665771811.919909 2022-10-14T18:23:31.919909+00:00 379608.0
exp_2022_10_14_10 200 leopard 82 1665771811.924909 2022-10-14T18:23:31.924909+00:00 379591.0
exp_2022_10_14_10 200 leopard 83 1665771811.929909 2022-10-14T18:23:31.929909+00:00 379571.0
exp_2022_10_14_10 200 leopard 84 1665771811.934909 2022-10-14T18:23:31.934909+00:00 379548.0
exp_2022_10_14_10 200 leopard 85 1665771811.939909 2022-10-14T18:23:31.939909+00:00 379523.0
exp_2022_10_14_10 200 leopard 86 1665771811.944909 2022-10-14T18:23:31.944909+00:00 379495.0
exp_2022_10_14_10 200 leopard 87 1665771811.949909 2022-10-14T18:23:31.949909+00:00 379467.0
exp_2022_10_14_10 200 leopard 88 1665771811.954909 2022-10-14T18:23:31.954909+00:00 379436.0
exp_2022_10_14_10 200 leopard 89 1665771811.959909 2022-10-14T18:23:31.959909+00:00 379405.0
exp_2022_10_14_10 200 leopard 90 1665771811.964909 2022-10-14T18:23:31.964909+00:00 379372.0
exp_2022_10_14_10 200 leopard 91 1665771811.969909 2022-10-14T18:23:31.969909+00:00 379339.0
exp_2022_10_14_10 200 leopard 92 1665771811.974909 2022-10-14T18:23:31.974909+00:00 379306.0
exp_2022_10_14_10 200 leopard 93 1665771811.979909 2022-10-14T18:23:31.979909+00:00 379272.0
exp_2022_10_14_10 200 leopard 94 1665771811.984909 2022-10-14T18:23:31.984909+00:00 379238.0
exp_2022_10_14_10 200 leopard 95 1665771811.989909 2022-10-14T18:23:31.989909+00:00 379205.0
exp_2022_10_14_10 200 leopard 96 1665771811.994909 2022-10-14T18:23:31.994909+00:00 379173.0
exp_2022_10_14_10 200 leopard 97 1665771811.999909 2022-10-14T18:23:31.999909+00:00 379142.0
exp_2022_10_14_10 200 leopard 98 1665771812.004909 2022-10-14T18:23:32.004909+00:00 379112.0
exp_2022_10_14_10 200 leopard 99 1665771812.009909 2022-10-14T18:23:32.009909+00:00 379083.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]);