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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_05_02_14 200 leopard 0 1683065949.6312912 2023-05-02T22:19:09.631291+00:00 -1277.41
exp_2023_05_02_14 200 leopard 1 1683065949.6362913 2023-05-02T22:19:09.636291+00:00 -1277.42
exp_2023_05_02_14 200 leopard 2 1683065949.6412911 2023-05-02T22:19:09.641291+00:00 -1277.42
exp_2023_05_02_14 200 leopard 3 1683065949.6462913 2023-05-02T22:19:09.646291+00:00 -1277.43
exp_2023_05_02_14 200 leopard 4 1683065949.6512911 2023-05-02T22:19:09.651291+00:00 -1277.43
exp_2023_05_02_14 200 leopard 5 1683065949.6562912 2023-05-02T22:19:09.656291+00:00 -1277.43
exp_2023_05_02_14 200 leopard 6 1683065949.6612911 2023-05-02T22:19:09.661291+00:00 -1277.42
exp_2023_05_02_14 200 leopard 7 1683065949.6662912 2023-05-02T22:19:09.666291+00:00 -1277.42
exp_2023_05_02_14 200 leopard 8 1683065949.671291 2023-05-02T22:19:09.671291+00:00 -1277.41
exp_2023_05_02_14 200 leopard 9 1683065949.6762912 2023-05-02T22:19:09.676291+00:00 -1277.4
exp_2023_05_02_14 200 leopard 10 1683065949.681291 2023-05-02T22:19:09.681291+00:00 -1277.38
exp_2023_05_02_14 200 leopard 11 1683065949.6862912 2023-05-02T22:19:09.686291+00:00 -1277.37
exp_2023_05_02_14 200 leopard 12 1683065949.691291 2023-05-02T22:19:09.691291+00:00 -1277.35
exp_2023_05_02_14 200 leopard 13 1683065949.6962912 2023-05-02T22:19:09.696291+00:00 -1277.33
exp_2023_05_02_14 200 leopard 14 1683065949.701291 2023-05-02T22:19:09.701291+00:00 -1277.3
exp_2023_05_02_14 200 leopard 15 1683065949.7062912 2023-05-02T22:19:09.706291+00:00 -1277.27
exp_2023_05_02_14 200 leopard 16 1683065949.711291 2023-05-02T22:19:09.711291+00:00 -1277.25
exp_2023_05_02_14 200 leopard 17 1683065949.7162912 2023-05-02T22:19:09.716291+00:00 -1277.22
exp_2023_05_02_14 200 leopard 18 1683065949.721291 2023-05-02T22:19:09.721291+00:00 -1277.18
exp_2023_05_02_14 200 leopard 19 1683065949.7262912 2023-05-02T22:19:09.726291+00:00 -1277.15
exp_2023_05_02_14 200 leopard 20 1683065949.731291 2023-05-02T22:19:09.731291+00:00 -1277.12
exp_2023_05_02_14 200 leopard 21 1683065949.7362912 2023-05-02T22:19:09.736291+00:00 -1277.09
exp_2023_05_02_14 200 leopard 22 1683065949.741291 2023-05-02T22:19:09.741291+00:00 -1277.05
exp_2023_05_02_14 200 leopard 23 1683065949.7462912 2023-05-02T22:19:09.746291+00:00 -1277.02
exp_2023_05_02_14 200 leopard 24 1683065949.751291 2023-05-02T22:19:09.751291+00:00 -1276.99
exp_2023_05_02_14 200 leopard 25 1683065949.7562912 2023-05-02T22:19:09.756291+00:00 -1276.96
exp_2023_05_02_14 200 leopard 26 1683065949.7612913 2023-05-02T22:19:09.761291+00:00 -1276.93
exp_2023_05_02_14 200 leopard 27 1683065949.7662911 2023-05-02T22:19:09.766291+00:00 -1276.91
exp_2023_05_02_14 200 leopard 28 1683065949.7712913 2023-05-02T22:19:09.771291+00:00 -1276.89
exp_2023_05_02_14 200 leopard 29 1683065949.7762911 2023-05-02T22:19:09.776291+00:00 -1276.87
exp_2023_05_02_14 200 leopard 30 1683065949.7812912 2023-05-02T22:19:09.781291+00:00 -1276.85
exp_2023_05_02_14 200 leopard 31 1683065949.7862911 2023-05-02T22:19:09.786291+00:00 -1276.84
exp_2023_05_02_14 200 leopard 32 1683065949.7912912 2023-05-02T22:19:09.791291+00:00 -1276.83
exp_2023_05_02_14 200 leopard 33 1683065949.796291 2023-05-02T22:19:09.796291+00:00 -1276.82
exp_2023_05_02_14 200 leopard 34 1683065949.8012912 2023-05-02T22:19:09.801291+00:00 -1276.82
exp_2023_05_02_14 200 leopard 35 1683065949.806291 2023-05-02T22:19:09.806291+00:00 -1276.82
exp_2023_05_02_14 200 leopard 36 1683065949.8112912 2023-05-02T22:19:09.811291+00:00 -1276.83
exp_2023_05_02_14 200 leopard 37 1683065949.816291 2023-05-02T22:19:09.816291+00:00 -1276.84
exp_2023_05_02_14 200 leopard 38 1683065949.8212912 2023-05-02T22:19:09.821291+00:00 -1276.85
exp_2023_05_02_14 200 leopard 39 1683065949.826291 2023-05-02T22:19:09.826291+00:00 -1276.86
exp_2023_05_02_14 200 leopard 40 1683065949.8312912 2023-05-02T22:19:09.831291+00:00 -1276.89
exp_2023_05_02_14 200 leopard 41 1683065949.836291 2023-05-02T22:19:09.836291+00:00 -1276.91
exp_2023_05_02_14 200 leopard 42 1683065949.8412912 2023-05-02T22:19:09.841291+00:00 -1276.94
exp_2023_05_02_14 200 leopard 43 1683065949.846291 2023-05-02T22:19:09.846291+00:00 -1276.97
exp_2023_05_02_14 200 leopard 44 1683065949.8512912 2023-05-02T22:19:09.851291+00:00 -1277.01
exp_2023_05_02_14 200 leopard 45 1683065949.856291 2023-05-02T22:19:09.856291+00:00 -1277.05
exp_2023_05_02_14 200 leopard 46 1683065949.8612912 2023-05-02T22:19:09.861291+00:00 -1277.09
exp_2023_05_02_14 200 leopard 47 1683065949.866291 2023-05-02T22:19:09.866291+00:00 -1277.14
exp_2023_05_02_14 200 leopard 48 1683065949.8712912 2023-05-02T22:19:09.871291+00:00 -1277.19
exp_2023_05_02_14 200 leopard 49 1683065949.876291 2023-05-02T22:19:09.876291+00:00 -1277.24
exp_2023_05_02_14 200 leopard 50 1683065949.8812912 2023-05-02T22:19:09.881291+00:00 -1277.29
exp_2023_05_02_14 200 leopard 51 1683065949.8862913 2023-05-02T22:19:09.886291+00:00 -1277.35
exp_2023_05_02_14 200 leopard 52 1683065949.8912911 2023-05-02T22:19:09.891291+00:00 -1277.42
exp_2023_05_02_14 200 leopard 53 1683065949.8962913 2023-05-02T22:19:09.896291+00:00 -1277.48
exp_2023_05_02_14 200 leopard 54 1683065949.9012911 2023-05-02T22:19:09.901291+00:00 -1277.55
exp_2023_05_02_14 200 leopard 55 1683065949.9062912 2023-05-02T22:19:09.906291+00:00 -1277.62
exp_2023_05_02_14 200 leopard 56 1683065949.9112911 2023-05-02T22:19:09.911291+00:00 -1277.69
exp_2023_05_02_14 200 leopard 57 1683065949.9162912 2023-05-02T22:19:09.916291+00:00 -1277.77
exp_2023_05_02_14 200 leopard 58 1683065949.921291 2023-05-02T22:19:09.921291+00:00 -1277.84
exp_2023_05_02_14 200 leopard 59 1683065949.9262912 2023-05-02T22:19:09.926291+00:00 -1277.92
exp_2023_05_02_14 200 leopard 60 1683065949.931291 2023-05-02T22:19:09.931291+00:00 -1278.01
exp_2023_05_02_14 200 leopard 61 1683065949.9362912 2023-05-02T22:19:09.936291+00:00 -1278.09
exp_2023_05_02_14 200 leopard 62 1683065949.941291 2023-05-02T22:19:09.941291+00:00 -1278.18
exp_2023_05_02_14 200 leopard 63 1683065949.9462912 2023-05-02T22:19:09.946291+00:00 -1278.27
exp_2023_05_02_14 200 leopard 64 1683065949.951291 2023-05-02T22:19:09.951291+00:00 -1278.37
exp_2023_05_02_14 200 leopard 65 1683065949.9562912 2023-05-02T22:19:09.956291+00:00 -1278.46
exp_2023_05_02_14 200 leopard 66 1683065949.961291 2023-05-02T22:19:09.961291+00:00 -1278.56
exp_2023_05_02_14 200 leopard 67 1683065949.9662912 2023-05-02T22:19:09.966291+00:00 -1278.67
exp_2023_05_02_14 200 leopard 68 1683065949.971291 2023-05-02T22:19:09.971291+00:00 -1278.77
exp_2023_05_02_14 200 leopard 69 1683065949.9762912 2023-05-02T22:19:09.976291+00:00 -1278.88
exp_2023_05_02_14 200 leopard 70 1683065949.981291 2023-05-02T22:19:09.981291+00:00 -1279.0
exp_2023_05_02_14 200 leopard 71 1683065949.9862912 2023-05-02T22:19:09.986291+00:00 -1279.11
exp_2023_05_02_14 200 leopard 72 1683065949.991291 2023-05-02T22:19:09.991291+00:00 -1279.23
exp_2023_05_02_14 200 leopard 73 1683065949.9962912 2023-05-02T22:19:09.996291+00:00 -1279.36
exp_2023_05_02_14 200 leopard 74 1683065950.001291 2023-05-02T22:19:10.001291+00:00 -1279.49
exp_2023_05_02_14 200 leopard 75 1683065950.0062912 2023-05-02T22:19:10.006291+00:00 -1279.63
exp_2023_05_02_14 200 leopard 76 1683065950.0112913 2023-05-02T22:19:10.011291+00:00 -1279.77
exp_2023_05_02_14 200 leopard 77 1683065950.0162911 2023-05-02T22:19:10.016291+00:00 -1279.91
exp_2023_05_02_14 200 leopard 78 1683065950.0212913 2023-05-02T22:19:10.021291+00:00 -1280.07
exp_2023_05_02_14 200 leopard 79 1683065950.0262911 2023-05-02T22:19:10.026291+00:00 -1280.22
exp_2023_05_02_14 200 leopard 80 1683065950.0312912 2023-05-02T22:19:10.031291+00:00 -1280.38
exp_2023_05_02_14 200 leopard 81 1683065950.0362911 2023-05-02T22:19:10.036291+00:00 -1280.55
exp_2023_05_02_14 200 leopard 82 1683065950.0412912 2023-05-02T22:19:10.041291+00:00 -1280.73
exp_2023_05_02_14 200 leopard 83 1683065950.046291 2023-05-02T22:19:10.046291+00:00 -1280.9
exp_2023_05_02_14 200 leopard 84 1683065950.0512912 2023-05-02T22:19:10.051291+00:00 -1281.09
exp_2023_05_02_14 200 leopard 85 1683065950.056291 2023-05-02T22:19:10.056291+00:00 -1281.28
exp_2023_05_02_14 200 leopard 86 1683065950.0612912 2023-05-02T22:19:10.061291+00:00 -1281.48
exp_2023_05_02_14 200 leopard 87 1683065950.066291 2023-05-02T22:19:10.066291+00:00 -1281.68
exp_2023_05_02_14 200 leopard 88 1683065950.0712912 2023-05-02T22:19:10.071291+00:00 -1281.88
exp_2023_05_02_14 200 leopard 89 1683065950.076291 2023-05-02T22:19:10.076291+00:00 -1282.1
exp_2023_05_02_14 200 leopard 90 1683065950.0812912 2023-05-02T22:19:10.081291+00:00 -1282.31
exp_2023_05_02_14 200 leopard 91 1683065950.086291 2023-05-02T22:19:10.086291+00:00 -1282.53
exp_2023_05_02_14 200 leopard 92 1683065950.0912912 2023-05-02T22:19:10.091291+00:00 -1282.76
exp_2023_05_02_14 200 leopard 93 1683065950.096291 2023-05-02T22:19:10.096291+00:00 -1282.98
exp_2023_05_02_14 200 leopard 94 1683065950.1012912 2023-05-02T22:19:10.101291+00:00 -1283.21
exp_2023_05_02_14 200 leopard 95 1683065950.106291 2023-05-02T22:19:10.106291+00:00 -1283.45
exp_2023_05_02_14 200 leopard 96 1683065950.1112912 2023-05-02T22:19:10.111291+00:00 -1283.68
exp_2023_05_02_14 200 leopard 97 1683065950.116291 2023-05-02T22:19:10.116291+00:00 -1283.91
exp_2023_05_02_14 200 leopard 98 1683065950.1212912 2023-05-02T22:19:10.121291+00:00 -1284.15
exp_2023_05_02_14 200 leopard 99 1683065950.126291 2023-05-02T22:19:10.126291+00:00 -1284.38

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]);