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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_02_21_14 200 leopard 0 1677017372.843478 2023-02-21T22:09:32.843478+00:00 294592.0
exp_2023_02_21_14 200 leopard 1 1677017372.848478 2023-02-21T22:09:32.848478+00:00 294595.0
exp_2023_02_21_14 200 leopard 2 1677017372.853478 2023-02-21T22:09:32.853478+00:00 294598.0
exp_2023_02_21_14 200 leopard 3 1677017372.858478 2023-02-21T22:09:32.858478+00:00 294602.0
exp_2023_02_21_14 200 leopard 4 1677017372.863478 2023-02-21T22:09:32.863478+00:00 294605.0
exp_2023_02_21_14 200 leopard 5 1677017372.868478 2023-02-21T22:09:32.868478+00:00 294608.0
exp_2023_02_21_14 200 leopard 6 1677017372.873478 2023-02-21T22:09:32.873478+00:00 294611.0
exp_2023_02_21_14 200 leopard 7 1677017372.878478 2023-02-21T22:09:32.878478+00:00 294614.0
exp_2023_02_21_14 200 leopard 8 1677017372.883478 2023-02-21T22:09:32.883478+00:00 294617.0
exp_2023_02_21_14 200 leopard 9 1677017372.888478 2023-02-21T22:09:32.888478+00:00 294620.0
exp_2023_02_21_14 200 leopard 10 1677017372.893478 2023-02-21T22:09:32.893478+00:00 294623.0
exp_2023_02_21_14 200 leopard 11 1677017372.898478 2023-02-21T22:09:32.898478+00:00 294626.0
exp_2023_02_21_14 200 leopard 12 1677017372.903478 2023-02-21T22:09:32.903478+00:00 294628.0
exp_2023_02_21_14 200 leopard 13 1677017372.908478 2023-02-21T22:09:32.908478+00:00 294631.0
exp_2023_02_21_14 200 leopard 14 1677017372.913478 2023-02-21T22:09:32.913478+00:00 294634.0
exp_2023_02_21_14 200 leopard 15 1677017372.918478 2023-02-21T22:09:32.918478+00:00 294636.0
exp_2023_02_21_14 200 leopard 16 1677017372.923478 2023-02-21T22:09:32.923478+00:00 294639.0
exp_2023_02_21_14 200 leopard 17 1677017372.928478 2023-02-21T22:09:32.928478+00:00 294641.0
exp_2023_02_21_14 200 leopard 18 1677017372.9334779 2023-02-21T22:09:32.933478+00:00 294643.0
exp_2023_02_21_14 200 leopard 19 1677017372.938478 2023-02-21T22:09:32.938478+00:00 294646.0
exp_2023_02_21_14 200 leopard 20 1677017372.9434779 2023-02-21T22:09:32.943478+00:00 294648.0
exp_2023_02_21_14 200 leopard 21 1677017372.948478 2023-02-21T22:09:32.948478+00:00 294650.0
exp_2023_02_21_14 200 leopard 22 1677017372.9534779 2023-02-21T22:09:32.953478+00:00 294652.0
exp_2023_02_21_14 200 leopard 23 1677017372.958478 2023-02-21T22:09:32.958478+00:00 294654.0
exp_2023_02_21_14 200 leopard 24 1677017372.9634778 2023-02-21T22:09:32.963478+00:00 294656.0
exp_2023_02_21_14 200 leopard 25 1677017372.968478 2023-02-21T22:09:32.968478+00:00 294658.0
exp_2023_02_21_14 200 leopard 26 1677017372.973478 2023-02-21T22:09:32.973478+00:00 294660.0
exp_2023_02_21_14 200 leopard 27 1677017372.978478 2023-02-21T22:09:32.978478+00:00 294661.0
exp_2023_02_21_14 200 leopard 28 1677017372.983478 2023-02-21T22:09:32.983478+00:00 294663.0
exp_2023_02_21_14 200 leopard 29 1677017372.988478 2023-02-21T22:09:32.988478+00:00 294664.0
exp_2023_02_21_14 200 leopard 30 1677017372.993478 2023-02-21T22:09:32.993478+00:00 294666.0
exp_2023_02_21_14 200 leopard 31 1677017372.998478 2023-02-21T22:09:32.998478+00:00 294667.0
exp_2023_02_21_14 200 leopard 32 1677017373.003478 2023-02-21T22:09:33.003478+00:00 294668.0
exp_2023_02_21_14 200 leopard 33 1677017373.008478 2023-02-21T22:09:33.008478+00:00 294670.0
exp_2023_02_21_14 200 leopard 34 1677017373.013478 2023-02-21T22:09:33.013478+00:00 294671.0
exp_2023_02_21_14 200 leopard 35 1677017373.018478 2023-02-21T22:09:33.018478+00:00 294672.0
exp_2023_02_21_14 200 leopard 36 1677017373.023478 2023-02-21T22:09:33.023478+00:00 294673.0
exp_2023_02_21_14 200 leopard 37 1677017373.028478 2023-02-21T22:09:33.028478+00:00 294673.0
exp_2023_02_21_14 200 leopard 38 1677017373.033478 2023-02-21T22:09:33.033478+00:00 294674.0
exp_2023_02_21_14 200 leopard 39 1677017373.038478 2023-02-21T22:09:33.038478+00:00 294675.0
exp_2023_02_21_14 200 leopard 40 1677017373.043478 2023-02-21T22:09:33.043478+00:00 294676.0
exp_2023_02_21_14 200 leopard 41 1677017373.048478 2023-02-21T22:09:33.048478+00:00 294676.0
exp_2023_02_21_14 200 leopard 42 1677017373.053478 2023-02-21T22:09:33.053478+00:00 294677.0
exp_2023_02_21_14 200 leopard 43 1677017373.0584779 2023-02-21T22:09:33.058478+00:00 294677.0
exp_2023_02_21_14 200 leopard 44 1677017373.063478 2023-02-21T22:09:33.063478+00:00 294677.0
exp_2023_02_21_14 200 leopard 45 1677017373.0684779 2023-02-21T22:09:33.068478+00:00 294678.0
exp_2023_02_21_14 200 leopard 46 1677017373.073478 2023-02-21T22:09:33.073478+00:00 294678.0
exp_2023_02_21_14 200 leopard 47 1677017373.0784779 2023-02-21T22:09:33.078478+00:00 294678.0
exp_2023_02_21_14 200 leopard 48 1677017373.083478 2023-02-21T22:09:33.083478+00:00 294678.0
exp_2023_02_21_14 200 leopard 49 1677017373.0884778 2023-02-21T22:09:33.088478+00:00 294678.0
exp_2023_02_21_14 200 leopard 50 1677017373.093478 2023-02-21T22:09:33.093478+00:00 294678.0
exp_2023_02_21_14 200 leopard 51 1677017373.098478 2023-02-21T22:09:33.098478+00:00 294678.0
exp_2023_02_21_14 200 leopard 52 1677017373.103478 2023-02-21T22:09:33.103478+00:00 294677.0
exp_2023_02_21_14 200 leopard 53 1677017373.108478 2023-02-21T22:09:33.108478+00:00 294677.0
exp_2023_02_21_14 200 leopard 54 1677017373.113478 2023-02-21T22:09:33.113478+00:00 294677.0
exp_2023_02_21_14 200 leopard 55 1677017373.118478 2023-02-21T22:09:33.118478+00:00 294676.0
exp_2023_02_21_14 200 leopard 56 1677017373.123478 2023-02-21T22:09:33.123478+00:00 294676.0
exp_2023_02_21_14 200 leopard 57 1677017373.128478 2023-02-21T22:09:33.128478+00:00 294675.0
exp_2023_02_21_14 200 leopard 58 1677017373.133478 2023-02-21T22:09:33.133478+00:00 294675.0
exp_2023_02_21_14 200 leopard 59 1677017373.138478 2023-02-21T22:09:33.138478+00:00 294674.0
exp_2023_02_21_14 200 leopard 60 1677017373.143478 2023-02-21T22:09:33.143478+00:00 294673.0
exp_2023_02_21_14 200 leopard 61 1677017373.148478 2023-02-21T22:09:33.148478+00:00 294672.0
exp_2023_02_21_14 200 leopard 62 1677017373.153478 2023-02-21T22:09:33.153478+00:00 294671.0
exp_2023_02_21_14 200 leopard 63 1677017373.158478 2023-02-21T22:09:33.158478+00:00 294671.0
exp_2023_02_21_14 200 leopard 64 1677017373.163478 2023-02-21T22:09:33.163478+00:00 294670.0
exp_2023_02_21_14 200 leopard 65 1677017373.168478 2023-02-21T22:09:33.168478+00:00 294668.0
exp_2023_02_21_14 200 leopard 66 1677017373.173478 2023-02-21T22:09:33.173478+00:00 294667.0
exp_2023_02_21_14 200 leopard 67 1677017373.178478 2023-02-21T22:09:33.178478+00:00 294666.0
exp_2023_02_21_14 200 leopard 68 1677017373.1834779 2023-02-21T22:09:33.183478+00:00 294665.0
exp_2023_02_21_14 200 leopard 69 1677017373.188478 2023-02-21T22:09:33.188478+00:00 294664.0
exp_2023_02_21_14 200 leopard 70 1677017373.1934779 2023-02-21T22:09:33.193478+00:00 294663.0
exp_2023_02_21_14 200 leopard 71 1677017373.198478 2023-02-21T22:09:33.198478+00:00 294661.0
exp_2023_02_21_14 200 leopard 72 1677017373.2034779 2023-02-21T22:09:33.203478+00:00 294660.0
exp_2023_02_21_14 200 leopard 73 1677017373.208478 2023-02-21T22:09:33.208478+00:00 294658.0
exp_2023_02_21_14 200 leopard 74 1677017373.2134778 2023-02-21T22:09:33.213478+00:00 294657.0
exp_2023_02_21_14 200 leopard 75 1677017373.218478 2023-02-21T22:09:33.218478+00:00 294655.0
exp_2023_02_21_14 200 leopard 76 1677017373.223478 2023-02-21T22:09:33.223478+00:00 294654.0
exp_2023_02_21_14 200 leopard 77 1677017373.228478 2023-02-21T22:09:33.228478+00:00 294652.0
exp_2023_02_21_14 200 leopard 78 1677017373.233478 2023-02-21T22:09:33.233478+00:00 294650.0
exp_2023_02_21_14 200 leopard 79 1677017373.238478 2023-02-21T22:09:33.238478+00:00 294648.0
exp_2023_02_21_14 200 leopard 80 1677017373.243478 2023-02-21T22:09:33.243478+00:00 294646.0
exp_2023_02_21_14 200 leopard 81 1677017373.248478 2023-02-21T22:09:33.248478+00:00 294645.0
exp_2023_02_21_14 200 leopard 82 1677017373.253478 2023-02-21T22:09:33.253478+00:00 294643.0
exp_2023_02_21_14 200 leopard 83 1677017373.258478 2023-02-21T22:09:33.258478+00:00 294641.0
exp_2023_02_21_14 200 leopard 84 1677017373.263478 2023-02-21T22:09:33.263478+00:00 294639.0
exp_2023_02_21_14 200 leopard 85 1677017373.268478 2023-02-21T22:09:33.268478+00:00 294637.0
exp_2023_02_21_14 200 leopard 86 1677017373.273478 2023-02-21T22:09:33.273478+00:00 294634.0
exp_2023_02_21_14 200 leopard 87 1677017373.278478 2023-02-21T22:09:33.278478+00:00 294632.0
exp_2023_02_21_14 200 leopard 88 1677017373.283478 2023-02-21T22:09:33.283478+00:00 294630.0
exp_2023_02_21_14 200 leopard 89 1677017373.288478 2023-02-21T22:09:33.288478+00:00 294628.0
exp_2023_02_21_14 200 leopard 90 1677017373.293478 2023-02-21T22:09:33.293478+00:00 294625.0
exp_2023_02_21_14 200 leopard 91 1677017373.298478 2023-02-21T22:09:33.298478+00:00 294623.0
exp_2023_02_21_14 200 leopard 92 1677017373.303478 2023-02-21T22:09:33.303478+00:00 294621.0
exp_2023_02_21_14 200 leopard 93 1677017373.3084779 2023-02-21T22:09:33.308478+00:00 294618.0
exp_2023_02_21_14 200 leopard 94 1677017373.313478 2023-02-21T22:09:33.313478+00:00 294616.0
exp_2023_02_21_14 200 leopard 95 1677017373.3184779 2023-02-21T22:09:33.318478+00:00 294613.0
exp_2023_02_21_14 200 leopard 96 1677017373.323478 2023-02-21T22:09:33.323478+00:00 294610.0
exp_2023_02_21_14 200 leopard 97 1677017373.3284779 2023-02-21T22:09:33.328478+00:00 294608.0
exp_2023_02_21_14 200 leopard 98 1677017373.333478 2023-02-21T22:09:33.333478+00:00 294605.0
exp_2023_02_21_14 200 leopard 99 1677017373.3384778 2023-02-21T22:09:33.338478+00:00 294602.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]);