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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_18_10 200 leopard 0 1668795705.0372975 2022-11-18T18:21:45.037297+00:00 15123.2
exp_2022_11_18_10 200 leopard 1 1668795705.0422976 2022-11-18T18:21:45.042298+00:00 15123.0
exp_2022_11_18_10 200 leopard 2 1668795705.0472975 2022-11-18T18:21:45.047297+00:00 15122.8
exp_2022_11_18_10 200 leopard 3 1668795705.0522976 2022-11-18T18:21:45.052298+00:00 15122.5
exp_2022_11_18_10 200 leopard 4 1668795705.0572975 2022-11-18T18:21:45.057297+00:00 15122.3
exp_2022_11_18_10 200 leopard 5 1668795705.0622976 2022-11-18T18:21:45.062298+00:00 15122.1
exp_2022_11_18_10 200 leopard 6 1668795705.0672975 2022-11-18T18:21:45.067297+00:00 15121.9
exp_2022_11_18_10 200 leopard 7 1668795705.0722976 2022-11-18T18:21:45.072298+00:00 15121.7
exp_2022_11_18_10 200 leopard 8 1668795705.0772974 2022-11-18T18:21:45.077297+00:00 15121.4
exp_2022_11_18_10 200 leopard 9 1668795705.0822976 2022-11-18T18:21:45.082298+00:00 15121.2
exp_2022_11_18_10 200 leopard 10 1668795705.0872974 2022-11-18T18:21:45.087297+00:00 15121.0
exp_2022_11_18_10 200 leopard 11 1668795705.0922976 2022-11-18T18:21:45.092298+00:00 15120.8
exp_2022_11_18_10 200 leopard 12 1668795705.0972974 2022-11-18T18:21:45.097297+00:00 15120.6
exp_2022_11_18_10 200 leopard 13 1668795705.1022975 2022-11-18T18:21:45.102298+00:00 15120.5
exp_2022_11_18_10 200 leopard 14 1668795705.1072974 2022-11-18T18:21:45.107297+00:00 15120.3
exp_2022_11_18_10 200 leopard 15 1668795705.1122975 2022-11-18T18:21:45.112298+00:00 15120.1
exp_2022_11_18_10 200 leopard 16 1668795705.1172974 2022-11-18T18:21:45.117297+00:00 15119.9
exp_2022_11_18_10 200 leopard 17 1668795705.1222975 2022-11-18T18:21:45.122298+00:00 15119.7
exp_2022_11_18_10 200 leopard 18 1668795705.1272974 2022-11-18T18:21:45.127297+00:00 15119.5
exp_2022_11_18_10 200 leopard 19 1668795705.1322975 2022-11-18T18:21:45.132298+00:00 15119.3
exp_2022_11_18_10 200 leopard 20 1668795705.1372974 2022-11-18T18:21:45.137297+00:00 15119.2
exp_2022_11_18_10 200 leopard 21 1668795705.1422975 2022-11-18T18:21:45.142298+00:00 15119.0
exp_2022_11_18_10 200 leopard 22 1668795705.1472974 2022-11-18T18:21:45.147297+00:00 15118.8
exp_2022_11_18_10 200 leopard 23 1668795705.1522975 2022-11-18T18:21:45.152297+00:00 15118.6
exp_2022_11_18_10 200 leopard 24 1668795705.1572974 2022-11-18T18:21:45.157297+00:00 15118.4
exp_2022_11_18_10 200 leopard 25 1668795705.1622975 2022-11-18T18:21:45.162297+00:00 15118.2
exp_2022_11_18_10 200 leopard 26 1668795705.1672976 2022-11-18T18:21:45.167298+00:00 15118.1
exp_2022_11_18_10 200 leopard 27 1668795705.1722975 2022-11-18T18:21:45.172297+00:00 15117.9
exp_2022_11_18_10 200 leopard 28 1668795705.1772976 2022-11-18T18:21:45.177298+00:00 15117.7
exp_2022_11_18_10 200 leopard 29 1668795705.1822975 2022-11-18T18:21:45.182297+00:00 15117.5
exp_2022_11_18_10 200 leopard 30 1668795705.1872976 2022-11-18T18:21:45.187298+00:00 15117.3
exp_2022_11_18_10 200 leopard 31 1668795705.1922975 2022-11-18T18:21:45.192297+00:00 15117.1
exp_2022_11_18_10 200 leopard 32 1668795705.1972976 2022-11-18T18:21:45.197298+00:00 15116.9
exp_2022_11_18_10 200 leopard 33 1668795705.2022974 2022-11-18T18:21:45.202297+00:00 15116.8
exp_2022_11_18_10 200 leopard 34 1668795705.2072976 2022-11-18T18:21:45.207298+00:00 15116.6
exp_2022_11_18_10 200 leopard 35 1668795705.2122974 2022-11-18T18:21:45.212297+00:00 15116.4
exp_2022_11_18_10 200 leopard 36 1668795705.2172976 2022-11-18T18:21:45.217298+00:00 15116.2
exp_2022_11_18_10 200 leopard 37 1668795705.2222974 2022-11-18T18:21:45.222297+00:00 15116.0
exp_2022_11_18_10 200 leopard 38 1668795705.2272975 2022-11-18T18:21:45.227298+00:00 15115.8
exp_2022_11_18_10 200 leopard 39 1668795705.2322974 2022-11-18T18:21:45.232297+00:00 15115.6
exp_2022_11_18_10 200 leopard 40 1668795705.2372975 2022-11-18T18:21:45.237298+00:00 15115.5
exp_2022_11_18_10 200 leopard 41 1668795705.2422974 2022-11-18T18:21:45.242297+00:00 15115.3
exp_2022_11_18_10 200 leopard 42 1668795705.2472975 2022-11-18T18:21:45.247298+00:00 15115.1
exp_2022_11_18_10 200 leopard 43 1668795705.2522974 2022-11-18T18:21:45.252297+00:00 15114.9
exp_2022_11_18_10 200 leopard 44 1668795705.2572975 2022-11-18T18:21:45.257298+00:00 15114.8
exp_2022_11_18_10 200 leopard 45 1668795705.2622974 2022-11-18T18:21:45.262297+00:00 15114.6
exp_2022_11_18_10 200 leopard 46 1668795705.2672975 2022-11-18T18:21:45.267298+00:00 15114.4
exp_2022_11_18_10 200 leopard 47 1668795705.2722974 2022-11-18T18:21:45.272297+00:00 15114.3
exp_2022_11_18_10 200 leopard 48 1668795705.2772975 2022-11-18T18:21:45.277297+00:00 15114.1
exp_2022_11_18_10 200 leopard 49 1668795705.2822974 2022-11-18T18:21:45.282297+00:00 15114.0
exp_2022_11_18_10 200 leopard 50 1668795705.2872975 2022-11-18T18:21:45.287297+00:00 15113.9
exp_2022_11_18_10 200 leopard 51 1668795705.2922976 2022-11-18T18:21:45.292298+00:00 15113.7
exp_2022_11_18_10 200 leopard 52 1668795705.2972975 2022-11-18T18:21:45.297297+00:00 15113.6
exp_2022_11_18_10 200 leopard 53 1668795705.3022976 2022-11-18T18:21:45.302298+00:00 15113.5
exp_2022_11_18_10 200 leopard 54 1668795705.3072975 2022-11-18T18:21:45.307297+00:00 15113.3
exp_2022_11_18_10 200 leopard 55 1668795705.3122976 2022-11-18T18:21:45.312298+00:00 15113.2
exp_2022_11_18_10 200 leopard 56 1668795705.3172975 2022-11-18T18:21:45.317297+00:00 15113.1
exp_2022_11_18_10 200 leopard 57 1668795705.3222976 2022-11-18T18:21:45.322298+00:00 15113.0
exp_2022_11_18_10 200 leopard 58 1668795705.3272974 2022-11-18T18:21:45.327297+00:00 15112.9
exp_2022_11_18_10 200 leopard 59 1668795705.3322976 2022-11-18T18:21:45.332298+00:00 15112.8
exp_2022_11_18_10 200 leopard 60 1668795705.3372974 2022-11-18T18:21:45.337297+00:00 15112.7
exp_2022_11_18_10 200 leopard 61 1668795705.3422976 2022-11-18T18:21:45.342298+00:00 15112.6
exp_2022_11_18_10 200 leopard 62 1668795705.3472974 2022-11-18T18:21:45.347297+00:00 15112.5
exp_2022_11_18_10 200 leopard 63 1668795705.3522975 2022-11-18T18:21:45.352298+00:00 15112.4
exp_2022_11_18_10 200 leopard 64 1668795705.3572974 2022-11-18T18:21:45.357297+00:00 15112.3
exp_2022_11_18_10 200 leopard 65 1668795705.3622975 2022-11-18T18:21:45.362298+00:00 15112.2
exp_2022_11_18_10 200 leopard 66 1668795705.3672974 2022-11-18T18:21:45.367297+00:00 15112.1
exp_2022_11_18_10 200 leopard 67 1668795705.3722975 2022-11-18T18:21:45.372298+00:00 15112.0
exp_2022_11_18_10 200 leopard 68 1668795705.3772974 2022-11-18T18:21:45.377297+00:00 15111.9
exp_2022_11_18_10 200 leopard 69 1668795705.3822975 2022-11-18T18:21:45.382298+00:00 15111.9
exp_2022_11_18_10 200 leopard 70 1668795705.3872974 2022-11-18T18:21:45.387297+00:00 15111.8
exp_2022_11_18_10 200 leopard 71 1668795705.3922975 2022-11-18T18:21:45.392298+00:00 15111.7
exp_2022_11_18_10 200 leopard 72 1668795705.3972974 2022-11-18T18:21:45.397297+00:00 15111.6
exp_2022_11_18_10 200 leopard 73 1668795705.4022975 2022-11-18T18:21:45.402297+00:00 15111.5
exp_2022_11_18_10 200 leopard 74 1668795705.4072974 2022-11-18T18:21:45.407297+00:00 15111.4
exp_2022_11_18_10 200 leopard 75 1668795705.4122975 2022-11-18T18:21:45.412297+00:00 15111.3
exp_2022_11_18_10 200 leopard 76 1668795705.4172976 2022-11-18T18:21:45.417298+00:00 15111.2
exp_2022_11_18_10 200 leopard 77 1668795705.4222975 2022-11-18T18:21:45.422297+00:00 15111.1
exp_2022_11_18_10 200 leopard 78 1668795705.4272976 2022-11-18T18:21:45.427298+00:00 15111.0
exp_2022_11_18_10 200 leopard 79 1668795705.4322975 2022-11-18T18:21:45.432297+00:00 15110.8
exp_2022_11_18_10 200 leopard 80 1668795705.4372976 2022-11-18T18:21:45.437298+00:00 15110.7
exp_2022_11_18_10 200 leopard 81 1668795705.4422975 2022-11-18T18:21:45.442297+00:00 15110.6
exp_2022_11_18_10 200 leopard 82 1668795705.4472976 2022-11-18T18:21:45.447298+00:00 15110.5
exp_2022_11_18_10 200 leopard 83 1668795705.4522974 2022-11-18T18:21:45.452297+00:00 15110.3
exp_2022_11_18_10 200 leopard 84 1668795705.4572976 2022-11-18T18:21:45.457298+00:00 15110.2
exp_2022_11_18_10 200 leopard 85 1668795705.4622974 2022-11-18T18:21:45.462297+00:00 15110.1
exp_2022_11_18_10 200 leopard 86 1668795705.4672976 2022-11-18T18:21:45.467298+00:00 15109.9
exp_2022_11_18_10 200 leopard 87 1668795705.4722974 2022-11-18T18:21:45.472297+00:00 15109.8
exp_2022_11_18_10 200 leopard 88 1668795705.4772975 2022-11-18T18:21:45.477298+00:00 15109.6
exp_2022_11_18_10 200 leopard 89 1668795705.4822974 2022-11-18T18:21:45.482297+00:00 15109.5
exp_2022_11_18_10 200 leopard 90 1668795705.4872975 2022-11-18T18:21:45.487298+00:00 15109.3
exp_2022_11_18_10 200 leopard 91 1668795705.4922974 2022-11-18T18:21:45.492297+00:00 15109.1
exp_2022_11_18_10 200 leopard 92 1668795705.4972975 2022-11-18T18:21:45.497298+00:00 15109.0
exp_2022_11_18_10 200 leopard 93 1668795705.5022974 2022-11-18T18:21:45.502297+00:00 15108.8
exp_2022_11_18_10 200 leopard 94 1668795705.5072975 2022-11-18T18:21:45.507298+00:00 15108.7
exp_2022_11_18_10 200 leopard 95 1668795705.5122974 2022-11-18T18:21:45.512297+00:00 15108.5
exp_2022_11_18_10 200 leopard 96 1668795705.5172975 2022-11-18T18:21:45.517298+00:00 15108.3
exp_2022_11_18_10 200 leopard 97 1668795705.5222974 2022-11-18T18:21:45.522297+00:00 15108.2
exp_2022_11_18_10 200 leopard 98 1668795705.5272975 2022-11-18T18:21:45.527297+00:00 15108.0
exp_2022_11_18_10 200 leopard 99 1668795705.5322974 2022-11-18T18:21:45.532297+00:00 15107.8

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