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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_12_02_15 200 leopard 0 1670023040.1878002 2022-12-02T23:17:20.187800+00:00 1308.41
exp_2022_12_02_15 200 leopard 1 1670023040.1928003 2022-12-02T23:17:20.192800+00:00 1308.27
exp_2022_12_02_15 200 leopard 2 1670023040.1978002 2022-12-02T23:17:20.197800+00:00 1308.12
exp_2022_12_02_15 200 leopard 3 1670023040.2028003 2022-12-02T23:17:20.202800+00:00 1307.97
exp_2022_12_02_15 200 leopard 4 1670023040.2078001 2022-12-02T23:17:20.207800+00:00 1307.8
exp_2022_12_02_15 200 leopard 5 1670023040.2128003 2022-12-02T23:17:20.212800+00:00 1307.64
exp_2022_12_02_15 200 leopard 6 1670023040.2178001 2022-12-02T23:17:20.217800+00:00 1307.46
exp_2022_12_02_15 200 leopard 7 1670023040.2228003 2022-12-02T23:17:20.222800+00:00 1307.29
exp_2022_12_02_15 200 leopard 8 1670023040.2278001 2022-12-02T23:17:20.227800+00:00 1307.11
exp_2022_12_02_15 200 leopard 9 1670023040.2328002 2022-12-02T23:17:20.232800+00:00 1306.93
exp_2022_12_02_15 200 leopard 10 1670023040.2378001 2022-12-02T23:17:20.237800+00:00 1306.75
exp_2022_12_02_15 200 leopard 11 1670023040.2428002 2022-12-02T23:17:20.242800+00:00 1306.57
exp_2022_12_02_15 200 leopard 12 1670023040.2478 2022-12-02T23:17:20.247800+00:00 1306.4
exp_2022_12_02_15 200 leopard 13 1670023040.2528002 2022-12-02T23:17:20.252800+00:00 1306.22
exp_2022_12_02_15 200 leopard 14 1670023040.2578 2022-12-02T23:17:20.257800+00:00 1306.05
exp_2022_12_02_15 200 leopard 15 1670023040.2628002 2022-12-02T23:17:20.262800+00:00 1305.88
exp_2022_12_02_15 200 leopard 16 1670023040.2678 2022-12-02T23:17:20.267800+00:00 1305.72
exp_2022_12_02_15 200 leopard 17 1670023040.2728002 2022-12-02T23:17:20.272800+00:00 1305.56
exp_2022_12_02_15 200 leopard 18 1670023040.2778 2022-12-02T23:17:20.277800+00:00 1305.41
exp_2022_12_02_15 200 leopard 19 1670023040.2828002 2022-12-02T23:17:20.282800+00:00 1305.26
exp_2022_12_02_15 200 leopard 20 1670023040.2878 2022-12-02T23:17:20.287800+00:00 1305.12
exp_2022_12_02_15 200 leopard 21 1670023040.2928002 2022-12-02T23:17:20.292800+00:00 1304.98
exp_2022_12_02_15 200 leopard 22 1670023040.2978 2022-12-02T23:17:20.297800+00:00 1304.85
exp_2022_12_02_15 200 leopard 23 1670023040.3028002 2022-12-02T23:17:20.302800+00:00 1304.73
exp_2022_12_02_15 200 leopard 24 1670023040.3078 2022-12-02T23:17:20.307800+00:00 1304.61
exp_2022_12_02_15 200 leopard 25 1670023040.3128002 2022-12-02T23:17:20.312800+00:00 1304.49
exp_2022_12_02_15 200 leopard 26 1670023040.3178003 2022-12-02T23:17:20.317800+00:00 1304.38
exp_2022_12_02_15 200 leopard 27 1670023040.3228002 2022-12-02T23:17:20.322800+00:00 1304.28
exp_2022_12_02_15 200 leopard 28 1670023040.3278003 2022-12-02T23:17:20.327800+00:00 1304.18
exp_2022_12_02_15 200 leopard 29 1670023040.3328001 2022-12-02T23:17:20.332800+00:00 1304.08
exp_2022_12_02_15 200 leopard 30 1670023040.3378003 2022-12-02T23:17:20.337800+00:00 1303.99
exp_2022_12_02_15 200 leopard 31 1670023040.3428001 2022-12-02T23:17:20.342800+00:00 1303.9
exp_2022_12_02_15 200 leopard 32 1670023040.3478003 2022-12-02T23:17:20.347800+00:00 1303.81
exp_2022_12_02_15 200 leopard 33 1670023040.3528001 2022-12-02T23:17:20.352800+00:00 1303.73
exp_2022_12_02_15 200 leopard 34 1670023040.3578002 2022-12-02T23:17:20.357800+00:00 1303.64
exp_2022_12_02_15 200 leopard 35 1670023040.3628001 2022-12-02T23:17:20.362800+00:00 1303.56
exp_2022_12_02_15 200 leopard 36 1670023040.3678002 2022-12-02T23:17:20.367800+00:00 1303.47
exp_2022_12_02_15 200 leopard 37 1670023040.3728 2022-12-02T23:17:20.372800+00:00 1303.39
exp_2022_12_02_15 200 leopard 38 1670023040.3778002 2022-12-02T23:17:20.377800+00:00 1303.31
exp_2022_12_02_15 200 leopard 39 1670023040.3828 2022-12-02T23:17:20.382800+00:00 1303.22
exp_2022_12_02_15 200 leopard 40 1670023040.3878002 2022-12-02T23:17:20.387800+00:00 1303.13
exp_2022_12_02_15 200 leopard 41 1670023040.3928 2022-12-02T23:17:20.392800+00:00 1303.05
exp_2022_12_02_15 200 leopard 42 1670023040.3978002 2022-12-02T23:17:20.397800+00:00 1302.96
exp_2022_12_02_15 200 leopard 43 1670023040.4028 2022-12-02T23:17:20.402800+00:00 1302.86
exp_2022_12_02_15 200 leopard 44 1670023040.4078002 2022-12-02T23:17:20.407800+00:00 1302.77
exp_2022_12_02_15 200 leopard 45 1670023040.4128 2022-12-02T23:17:20.412800+00:00 1302.68
exp_2022_12_02_15 200 leopard 46 1670023040.4178002 2022-12-02T23:17:20.417800+00:00 1302.58
exp_2022_12_02_15 200 leopard 47 1670023040.4228 2022-12-02T23:17:20.422800+00:00 1302.48
exp_2022_12_02_15 200 leopard 48 1670023040.4278002 2022-12-02T23:17:20.427800+00:00 1302.38
exp_2022_12_02_15 200 leopard 49 1670023040.4328 2022-12-02T23:17:20.432800+00:00 1302.28
exp_2022_12_02_15 200 leopard 50 1670023040.4378002 2022-12-02T23:17:20.437800+00:00 1302.18
exp_2022_12_02_15 200 leopard 51 1670023040.4428003 2022-12-02T23:17:20.442800+00:00 1302.08
exp_2022_12_02_15 200 leopard 52 1670023040.4478002 2022-12-02T23:17:20.447800+00:00 1301.98
exp_2022_12_02_15 200 leopard 53 1670023040.4528003 2022-12-02T23:17:20.452800+00:00 1301.88
exp_2022_12_02_15 200 leopard 54 1670023040.4578001 2022-12-02T23:17:20.457800+00:00 1301.78
exp_2022_12_02_15 200 leopard 55 1670023040.4628003 2022-12-02T23:17:20.462800+00:00 1301.68
exp_2022_12_02_15 200 leopard 56 1670023040.4678001 2022-12-02T23:17:20.467800+00:00 1301.59
exp_2022_12_02_15 200 leopard 57 1670023040.4728003 2022-12-02T23:17:20.472800+00:00 1301.49
exp_2022_12_02_15 200 leopard 58 1670023040.4778001 2022-12-02T23:17:20.477800+00:00 1301.4
exp_2022_12_02_15 200 leopard 59 1670023040.4828002 2022-12-02T23:17:20.482800+00:00 1301.32
exp_2022_12_02_15 200 leopard 60 1670023040.4878001 2022-12-02T23:17:20.487800+00:00 1301.23
exp_2022_12_02_15 200 leopard 61 1670023040.4928002 2022-12-02T23:17:20.492800+00:00 1301.15
exp_2022_12_02_15 200 leopard 62 1670023040.4978 2022-12-02T23:17:20.497800+00:00 1301.08
exp_2022_12_02_15 200 leopard 63 1670023040.5028002 2022-12-02T23:17:20.502800+00:00 1301.01
exp_2022_12_02_15 200 leopard 64 1670023040.5078 2022-12-02T23:17:20.507800+00:00 1300.95
exp_2022_12_02_15 200 leopard 65 1670023040.5128002 2022-12-02T23:17:20.512800+00:00 1300.89
exp_2022_12_02_15 200 leopard 66 1670023040.5178 2022-12-02T23:17:20.517800+00:00 1300.83
exp_2022_12_02_15 200 leopard 67 1670023040.5228002 2022-12-02T23:17:20.522800+00:00 1300.78
exp_2022_12_02_15 200 leopard 68 1670023040.5278 2022-12-02T23:17:20.527800+00:00 1300.74
exp_2022_12_02_15 200 leopard 69 1670023040.5328002 2022-12-02T23:17:20.532800+00:00 1300.7
exp_2022_12_02_15 200 leopard 70 1670023040.5378 2022-12-02T23:17:20.537800+00:00 1300.67
exp_2022_12_02_15 200 leopard 71 1670023040.5428002 2022-12-02T23:17:20.542800+00:00 1300.64
exp_2022_12_02_15 200 leopard 72 1670023040.5478 2022-12-02T23:17:20.547800+00:00 1300.61
exp_2022_12_02_15 200 leopard 73 1670023040.5528002 2022-12-02T23:17:20.552800+00:00 1300.59
exp_2022_12_02_15 200 leopard 74 1670023040.5578 2022-12-02T23:17:20.557800+00:00 1300.57
exp_2022_12_02_15 200 leopard 75 1670023040.5628002 2022-12-02T23:17:20.562800+00:00 1300.56
exp_2022_12_02_15 200 leopard 76 1670023040.5678003 2022-12-02T23:17:20.567800+00:00 1300.55
exp_2022_12_02_15 200 leopard 77 1670023040.5728002 2022-12-02T23:17:20.572800+00:00 1300.54
exp_2022_12_02_15 200 leopard 78 1670023040.5778003 2022-12-02T23:17:20.577800+00:00 1300.53
exp_2022_12_02_15 200 leopard 79 1670023040.5828001 2022-12-02T23:17:20.582800+00:00 1300.52
exp_2022_12_02_15 200 leopard 80 1670023040.5878003 2022-12-02T23:17:20.587800+00:00 1300.52
exp_2022_12_02_15 200 leopard 81 1670023040.5928001 2022-12-02T23:17:20.592800+00:00 1300.51
exp_2022_12_02_15 200 leopard 82 1670023040.5978003 2022-12-02T23:17:20.597800+00:00 1300.5
exp_2022_12_02_15 200 leopard 83 1670023040.6028001 2022-12-02T23:17:20.602800+00:00 1300.49
exp_2022_12_02_15 200 leopard 84 1670023040.6078002 2022-12-02T23:17:20.607800+00:00 1300.48
exp_2022_12_02_15 200 leopard 85 1670023040.6128001 2022-12-02T23:17:20.612800+00:00 1300.47
exp_2022_12_02_15 200 leopard 86 1670023040.6178002 2022-12-02T23:17:20.617800+00:00 1300.46
exp_2022_12_02_15 200 leopard 87 1670023040.6228 2022-12-02T23:17:20.622800+00:00 1300.44
exp_2022_12_02_15 200 leopard 88 1670023040.6278002 2022-12-02T23:17:20.627800+00:00 1300.42
exp_2022_12_02_15 200 leopard 89 1670023040.6328 2022-12-02T23:17:20.632800+00:00 1300.39
exp_2022_12_02_15 200 leopard 90 1670023040.6378002 2022-12-02T23:17:20.637800+00:00 1300.36
exp_2022_12_02_15 200 leopard 91 1670023040.6428 2022-12-02T23:17:20.642800+00:00 1300.33
exp_2022_12_02_15 200 leopard 92 1670023040.6478002 2022-12-02T23:17:20.647800+00:00 1300.3
exp_2022_12_02_15 200 leopard 93 1670023040.6528 2022-12-02T23:17:20.652800+00:00 1300.26
exp_2022_12_02_15 200 leopard 94 1670023040.6578002 2022-12-02T23:17:20.657800+00:00 1300.21
exp_2022_12_02_15 200 leopard 95 1670023040.6628 2022-12-02T23:17:20.662800+00:00 1300.17
exp_2022_12_02_15 200 leopard 96 1670023040.6678002 2022-12-02T23:17:20.667800+00:00 1300.12
exp_2022_12_02_15 200 leopard 97 1670023040.6728 2022-12-02T23:17:20.672800+00:00 1300.07
exp_2022_12_02_15 200 leopard 98 1670023040.6778002 2022-12-02T23:17:20.677800+00:00 1300.02
exp_2022_12_02_15 200 leopard 99 1670023040.6828 2022-12-02T23:17:20.682800+00:00 1299.97

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