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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_05_03_10 200 leopard 0 1683136875.9962802 2023-05-03T18:01:15.996280+00:00 137913.0
exp_2023_05_03_10 200 leopard 1 1683136876.0012803 2023-05-03T18:01:16.001280+00:00 137912.0
exp_2023_05_03_10 200 leopard 2 1683136876.0062802 2023-05-03T18:01:16.006280+00:00 137910.0
exp_2023_05_03_10 200 leopard 3 1683136876.0112803 2023-05-03T18:01:16.011280+00:00 137909.0
exp_2023_05_03_10 200 leopard 4 1683136876.0162802 2023-05-03T18:01:16.016280+00:00 137908.0
exp_2023_05_03_10 200 leopard 5 1683136876.0212803 2023-05-03T18:01:16.021280+00:00 137907.0
exp_2023_05_03_10 200 leopard 6 1683136876.0262802 2023-05-03T18:01:16.026280+00:00 137906.0
exp_2023_05_03_10 200 leopard 7 1683136876.0312803 2023-05-03T18:01:16.031280+00:00 137905.0
exp_2023_05_03_10 200 leopard 8 1683136876.0362802 2023-05-03T18:01:16.036280+00:00 137904.0
exp_2023_05_03_10 200 leopard 9 1683136876.0412803 2023-05-03T18:01:16.041280+00:00 137903.0
exp_2023_05_03_10 200 leopard 10 1683136876.0462801 2023-05-03T18:01:16.046280+00:00 137902.0
exp_2023_05_03_10 200 leopard 11 1683136876.0512803 2023-05-03T18:01:16.051280+00:00 137900.0
exp_2023_05_03_10 200 leopard 12 1683136876.0562801 2023-05-03T18:01:16.056280+00:00 137899.0
exp_2023_05_03_10 200 leopard 13 1683136876.0612803 2023-05-03T18:01:16.061280+00:00 137898.0
exp_2023_05_03_10 200 leopard 14 1683136876.0662801 2023-05-03T18:01:16.066280+00:00 137897.0
exp_2023_05_03_10 200 leopard 15 1683136876.0712802 2023-05-03T18:01:16.071280+00:00 137896.0
exp_2023_05_03_10 200 leopard 16 1683136876.07628 2023-05-03T18:01:16.076280+00:00 137895.0
exp_2023_05_03_10 200 leopard 17 1683136876.0812802 2023-05-03T18:01:16.081280+00:00 137894.0
exp_2023_05_03_10 200 leopard 18 1683136876.08628 2023-05-03T18:01:16.086280+00:00 137893.0
exp_2023_05_03_10 200 leopard 19 1683136876.0912802 2023-05-03T18:01:16.091280+00:00 137892.0
exp_2023_05_03_10 200 leopard 20 1683136876.09628 2023-05-03T18:01:16.096280+00:00 137891.0
exp_2023_05_03_10 200 leopard 21 1683136876.1012802 2023-05-03T18:01:16.101280+00:00 137891.0
exp_2023_05_03_10 200 leopard 22 1683136876.10628 2023-05-03T18:01:16.106280+00:00 137890.0
exp_2023_05_03_10 200 leopard 23 1683136876.1112802 2023-05-03T18:01:16.111280+00:00 137889.0
exp_2023_05_03_10 200 leopard 24 1683136876.11628 2023-05-03T18:01:16.116280+00:00 137888.0
exp_2023_05_03_10 200 leopard 25 1683136876.1212802 2023-05-03T18:01:16.121280+00:00 137887.0
exp_2023_05_03_10 200 leopard 26 1683136876.1262803 2023-05-03T18:01:16.126280+00:00 137886.0
exp_2023_05_03_10 200 leopard 27 1683136876.1312802 2023-05-03T18:01:16.131280+00:00 137885.0
exp_2023_05_03_10 200 leopard 28 1683136876.1362803 2023-05-03T18:01:16.136280+00:00 137885.0
exp_2023_05_03_10 200 leopard 29 1683136876.1412802 2023-05-03T18:01:16.141280+00:00 137884.0
exp_2023_05_03_10 200 leopard 30 1683136876.1462803 2023-05-03T18:01:16.146280+00:00 137883.0
exp_2023_05_03_10 200 leopard 31 1683136876.1512802 2023-05-03T18:01:16.151280+00:00 137882.0
exp_2023_05_03_10 200 leopard 32 1683136876.1562803 2023-05-03T18:01:16.156280+00:00 137882.0
exp_2023_05_03_10 200 leopard 33 1683136876.1612802 2023-05-03T18:01:16.161280+00:00 137881.0
exp_2023_05_03_10 200 leopard 34 1683136876.1662803 2023-05-03T18:01:16.166280+00:00 137880.0
exp_2023_05_03_10 200 leopard 35 1683136876.1712801 2023-05-03T18:01:16.171280+00:00 137880.0
exp_2023_05_03_10 200 leopard 36 1683136876.1762803 2023-05-03T18:01:16.176280+00:00 137879.0
exp_2023_05_03_10 200 leopard 37 1683136876.1812801 2023-05-03T18:01:16.181280+00:00 137878.0
exp_2023_05_03_10 200 leopard 38 1683136876.1862803 2023-05-03T18:01:16.186280+00:00 137878.0
exp_2023_05_03_10 200 leopard 39 1683136876.1912801 2023-05-03T18:01:16.191280+00:00 137877.0
exp_2023_05_03_10 200 leopard 40 1683136876.1962802 2023-05-03T18:01:16.196280+00:00 137876.0
exp_2023_05_03_10 200 leopard 41 1683136876.20128 2023-05-03T18:01:16.201280+00:00 137876.0
exp_2023_05_03_10 200 leopard 42 1683136876.2062802 2023-05-03T18:01:16.206280+00:00 137875.0
exp_2023_05_03_10 200 leopard 43 1683136876.21128 2023-05-03T18:01:16.211280+00:00 137874.0
exp_2023_05_03_10 200 leopard 44 1683136876.2162802 2023-05-03T18:01:16.216280+00:00 137874.0
exp_2023_05_03_10 200 leopard 45 1683136876.22128 2023-05-03T18:01:16.221280+00:00 137873.0
exp_2023_05_03_10 200 leopard 46 1683136876.2262802 2023-05-03T18:01:16.226280+00:00 137872.0
exp_2023_05_03_10 200 leopard 47 1683136876.23128 2023-05-03T18:01:16.231280+00:00 137872.0
exp_2023_05_03_10 200 leopard 48 1683136876.2362802 2023-05-03T18:01:16.236280+00:00 137871.0
exp_2023_05_03_10 200 leopard 49 1683136876.24128 2023-05-03T18:01:16.241280+00:00 137870.0
exp_2023_05_03_10 200 leopard 50 1683136876.2462802 2023-05-03T18:01:16.246280+00:00 137870.0
exp_2023_05_03_10 200 leopard 51 1683136876.2512803 2023-05-03T18:01:16.251280+00:00 137869.0
exp_2023_05_03_10 200 leopard 52 1683136876.2562802 2023-05-03T18:01:16.256280+00:00 137868.0
exp_2023_05_03_10 200 leopard 53 1683136876.2612803 2023-05-03T18:01:16.261280+00:00 137868.0
exp_2023_05_03_10 200 leopard 54 1683136876.2662802 2023-05-03T18:01:16.266280+00:00 137867.0
exp_2023_05_03_10 200 leopard 55 1683136876.2712803 2023-05-03T18:01:16.271280+00:00 137866.0
exp_2023_05_03_10 200 leopard 56 1683136876.2762802 2023-05-03T18:01:16.276280+00:00 137866.0
exp_2023_05_03_10 200 leopard 57 1683136876.2812803 2023-05-03T18:01:16.281280+00:00 137865.0
exp_2023_05_03_10 200 leopard 58 1683136876.2862802 2023-05-03T18:01:16.286280+00:00 137864.0
exp_2023_05_03_10 200 leopard 59 1683136876.2912803 2023-05-03T18:01:16.291280+00:00 137863.0
exp_2023_05_03_10 200 leopard 60 1683136876.2962801 2023-05-03T18:01:16.296280+00:00 137863.0
exp_2023_05_03_10 200 leopard 61 1683136876.3012803 2023-05-03T18:01:16.301280+00:00 137862.0
exp_2023_05_03_10 200 leopard 62 1683136876.3062801 2023-05-03T18:01:16.306280+00:00 137861.0
exp_2023_05_03_10 200 leopard 63 1683136876.3112803 2023-05-03T18:01:16.311280+00:00 137861.0
exp_2023_05_03_10 200 leopard 64 1683136876.3162801 2023-05-03T18:01:16.316280+00:00 137860.0
exp_2023_05_03_10 200 leopard 65 1683136876.3212802 2023-05-03T18:01:16.321280+00:00 137859.0
exp_2023_05_03_10 200 leopard 66 1683136876.32628 2023-05-03T18:01:16.326280+00:00 137858.0
exp_2023_05_03_10 200 leopard 67 1683136876.3312802 2023-05-03T18:01:16.331280+00:00 137858.0
exp_2023_05_03_10 200 leopard 68 1683136876.33628 2023-05-03T18:01:16.336280+00:00 137857.0
exp_2023_05_03_10 200 leopard 69 1683136876.3412802 2023-05-03T18:01:16.341280+00:00 137856.0
exp_2023_05_03_10 200 leopard 70 1683136876.34628 2023-05-03T18:01:16.346280+00:00 137856.0
exp_2023_05_03_10 200 leopard 71 1683136876.3512802 2023-05-03T18:01:16.351280+00:00 137855.0
exp_2023_05_03_10 200 leopard 72 1683136876.35628 2023-05-03T18:01:16.356280+00:00 137854.0
exp_2023_05_03_10 200 leopard 73 1683136876.3612802 2023-05-03T18:01:16.361280+00:00 137854.0
exp_2023_05_03_10 200 leopard 74 1683136876.36628 2023-05-03T18:01:16.366280+00:00 137853.0
exp_2023_05_03_10 200 leopard 75 1683136876.3712802 2023-05-03T18:01:16.371280+00:00 137852.0
exp_2023_05_03_10 200 leopard 76 1683136876.3762803 2023-05-03T18:01:16.376280+00:00 137852.0
exp_2023_05_03_10 200 leopard 77 1683136876.3812802 2023-05-03T18:01:16.381280+00:00 137851.0
exp_2023_05_03_10 200 leopard 78 1683136876.3862803 2023-05-03T18:01:16.386280+00:00 137851.0
exp_2023_05_03_10 200 leopard 79 1683136876.3912802 2023-05-03T18:01:16.391280+00:00 137850.0
exp_2023_05_03_10 200 leopard 80 1683136876.3962803 2023-05-03T18:01:16.396280+00:00 137850.0
exp_2023_05_03_10 200 leopard 81 1683136876.4012802 2023-05-03T18:01:16.401280+00:00 137849.0
exp_2023_05_03_10 200 leopard 82 1683136876.4062803 2023-05-03T18:01:16.406280+00:00 137849.0
exp_2023_05_03_10 200 leopard 83 1683136876.4112802 2023-05-03T18:01:16.411280+00:00 137848.0
exp_2023_05_03_10 200 leopard 84 1683136876.4162803 2023-05-03T18:01:16.416280+00:00 137848.0
exp_2023_05_03_10 200 leopard 85 1683136876.4212801 2023-05-03T18:01:16.421280+00:00 137847.0
exp_2023_05_03_10 200 leopard 86 1683136876.4262803 2023-05-03T18:01:16.426280+00:00 137847.0
exp_2023_05_03_10 200 leopard 87 1683136876.4312801 2023-05-03T18:01:16.431280+00:00 137846.0
exp_2023_05_03_10 200 leopard 88 1683136876.4362803 2023-05-03T18:01:16.436280+00:00 137846.0
exp_2023_05_03_10 200 leopard 89 1683136876.4412801 2023-05-03T18:01:16.441280+00:00 137846.0
exp_2023_05_03_10 200 leopard 90 1683136876.4462802 2023-05-03T18:01:16.446280+00:00 137845.0
exp_2023_05_03_10 200 leopard 91 1683136876.45128 2023-05-03T18:01:16.451280+00:00 137845.0
exp_2023_05_03_10 200 leopard 92 1683136876.4562802 2023-05-03T18:01:16.456280+00:00 137844.0
exp_2023_05_03_10 200 leopard 93 1683136876.46128 2023-05-03T18:01:16.461280+00:00 137844.0
exp_2023_05_03_10 200 leopard 94 1683136876.4662802 2023-05-03T18:01:16.466280+00:00 137843.0
exp_2023_05_03_10 200 leopard 95 1683136876.47128 2023-05-03T18:01:16.471280+00:00 137843.0
exp_2023_05_03_10 200 leopard 96 1683136876.4762802 2023-05-03T18:01:16.476280+00:00 137843.0
exp_2023_05_03_10 200 leopard 97 1683136876.48128 2023-05-03T18:01:16.481280+00:00 137842.0
exp_2023_05_03_10 200 leopard 98 1683136876.4862802 2023-05-03T18:01:16.486280+00:00 137841.0
exp_2023_05_03_10 200 leopard 99 1683136876.49128 2023-05-03T18:01:16.491280+00:00 137841.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]);