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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_12_05_12 200 leopard 0 1670271146.4872324 2022-12-05T20:12:26.487232+00:00 -1243.86
exp_2022_12_05_12 200 leopard 1 1670271146.4922326 2022-12-05T20:12:26.492233+00:00 -1243.67
exp_2022_12_05_12 200 leopard 2 1670271146.4972324 2022-12-05T20:12:26.497232+00:00 -1243.48
exp_2022_12_05_12 200 leopard 3 1670271146.5022326 2022-12-05T20:12:26.502233+00:00 -1243.28
exp_2022_12_05_12 200 leopard 4 1670271146.5072324 2022-12-05T20:12:26.507232+00:00 -1243.07
exp_2022_12_05_12 200 leopard 5 1670271146.5122325 2022-12-05T20:12:26.512233+00:00 -1242.86
exp_2022_12_05_12 200 leopard 6 1670271146.5172324 2022-12-05T20:12:26.517232+00:00 -1242.64
exp_2022_12_05_12 200 leopard 7 1670271146.5222325 2022-12-05T20:12:26.522233+00:00 -1242.42
exp_2022_12_05_12 200 leopard 8 1670271146.5272324 2022-12-05T20:12:26.527232+00:00 -1242.2
exp_2022_12_05_12 200 leopard 9 1670271146.5322325 2022-12-05T20:12:26.532233+00:00 -1241.98
exp_2022_12_05_12 200 leopard 10 1670271146.5372324 2022-12-05T20:12:26.537232+00:00 -1241.76
exp_2022_12_05_12 200 leopard 11 1670271146.5422325 2022-12-05T20:12:26.542233+00:00 -1241.54
exp_2022_12_05_12 200 leopard 12 1670271146.5472324 2022-12-05T20:12:26.547232+00:00 -1241.33
exp_2022_12_05_12 200 leopard 13 1670271146.5522325 2022-12-05T20:12:26.552233+00:00 -1241.12
exp_2022_12_05_12 200 leopard 14 1670271146.5572324 2022-12-05T20:12:26.557232+00:00 -1240.91
exp_2022_12_05_12 200 leopard 15 1670271146.5622325 2022-12-05T20:12:26.562232+00:00 -1240.71
exp_2022_12_05_12 200 leopard 16 1670271146.5672324 2022-12-05T20:12:26.567232+00:00 -1240.52
exp_2022_12_05_12 200 leopard 17 1670271146.5722325 2022-12-05T20:12:26.572232+00:00 -1240.34
exp_2022_12_05_12 200 leopard 18 1670271146.5772324 2022-12-05T20:12:26.577232+00:00 -1240.18
exp_2022_12_05_12 200 leopard 19 1670271146.5822325 2022-12-05T20:12:26.582232+00:00 -1240.02
exp_2022_12_05_12 200 leopard 20 1670271146.5872324 2022-12-05T20:12:26.587232+00:00 -1239.88
exp_2022_12_05_12 200 leopard 21 1670271146.5922325 2022-12-05T20:12:26.592232+00:00 -1239.76
exp_2022_12_05_12 200 leopard 22 1670271146.5972323 2022-12-05T20:12:26.597232+00:00 -1239.65
exp_2022_12_05_12 200 leopard 23 1670271146.6022325 2022-12-05T20:12:26.602232+00:00 -1239.57
exp_2022_12_05_12 200 leopard 24 1670271146.6072323 2022-12-05T20:12:26.607232+00:00 -1239.5
exp_2022_12_05_12 200 leopard 25 1670271146.6122324 2022-12-05T20:12:26.612232+00:00 -1239.45
exp_2022_12_05_12 200 leopard 26 1670271146.6172326 2022-12-05T20:12:26.617233+00:00 -1239.42
exp_2022_12_05_12 200 leopard 27 1670271146.6222324 2022-12-05T20:12:26.622232+00:00 -1239.42
exp_2022_12_05_12 200 leopard 28 1670271146.6272326 2022-12-05T20:12:26.627233+00:00 -1239.44
exp_2022_12_05_12 200 leopard 29 1670271146.6322324 2022-12-05T20:12:26.632232+00:00 -1239.48
exp_2022_12_05_12 200 leopard 30 1670271146.6372325 2022-12-05T20:12:26.637233+00:00 -1239.54
exp_2022_12_05_12 200 leopard 31 1670271146.6422324 2022-12-05T20:12:26.642232+00:00 -1239.63
exp_2022_12_05_12 200 leopard 32 1670271146.6472325 2022-12-05T20:12:26.647233+00:00 -1239.75
exp_2022_12_05_12 200 leopard 33 1670271146.6522324 2022-12-05T20:12:26.652232+00:00 -1239.89
exp_2022_12_05_12 200 leopard 34 1670271146.6572325 2022-12-05T20:12:26.657233+00:00 -1240.05
exp_2022_12_05_12 200 leopard 35 1670271146.6622324 2022-12-05T20:12:26.662232+00:00 -1240.23
exp_2022_12_05_12 200 leopard 36 1670271146.6672325 2022-12-05T20:12:26.667233+00:00 -1240.44
exp_2022_12_05_12 200 leopard 37 1670271146.6722324 2022-12-05T20:12:26.672232+00:00 -1240.67
exp_2022_12_05_12 200 leopard 38 1670271146.6772325 2022-12-05T20:12:26.677233+00:00 -1240.92
exp_2022_12_05_12 200 leopard 39 1670271146.6822324 2022-12-05T20:12:26.682232+00:00 -1241.19
exp_2022_12_05_12 200 leopard 40 1670271146.6872325 2022-12-05T20:12:26.687232+00:00 -1241.48
exp_2022_12_05_12 200 leopard 41 1670271146.6922324 2022-12-05T20:12:26.692232+00:00 -1241.78
exp_2022_12_05_12 200 leopard 42 1670271146.6972325 2022-12-05T20:12:26.697232+00:00 -1242.1
exp_2022_12_05_12 200 leopard 43 1670271146.7022324 2022-12-05T20:12:26.702232+00:00 -1242.44
exp_2022_12_05_12 200 leopard 44 1670271146.7072325 2022-12-05T20:12:26.707232+00:00 -1242.78
exp_2022_12_05_12 200 leopard 45 1670271146.7122324 2022-12-05T20:12:26.712232+00:00 -1243.14
exp_2022_12_05_12 200 leopard 46 1670271146.7172325 2022-12-05T20:12:26.717232+00:00 -1243.51
exp_2022_12_05_12 200 leopard 47 1670271146.7222323 2022-12-05T20:12:26.722232+00:00 -1243.88
exp_2022_12_05_12 200 leopard 48 1670271146.7272325 2022-12-05T20:12:26.727232+00:00 -1244.25
exp_2022_12_05_12 200 leopard 49 1670271146.7322323 2022-12-05T20:12:26.732232+00:00 -1244.63
exp_2022_12_05_12 200 leopard 50 1670271146.7372324 2022-12-05T20:12:26.737232+00:00 -1245.01
exp_2022_12_05_12 200 leopard 51 1670271146.7422326 2022-12-05T20:12:26.742233+00:00 -1245.39
exp_2022_12_05_12 200 leopard 52 1670271146.7472324 2022-12-05T20:12:26.747232+00:00 -1245.76
exp_2022_12_05_12 200 leopard 53 1670271146.7522326 2022-12-05T20:12:26.752233+00:00 -1246.12
exp_2022_12_05_12 200 leopard 54 1670271146.7572324 2022-12-05T20:12:26.757232+00:00 -1246.48
exp_2022_12_05_12 200 leopard 55 1670271146.7622325 2022-12-05T20:12:26.762233+00:00 -1246.83
exp_2022_12_05_12 200 leopard 56 1670271146.7672324 2022-12-05T20:12:26.767232+00:00 -1247.16
exp_2022_12_05_12 200 leopard 57 1670271146.7722325 2022-12-05T20:12:26.772233+00:00 -1247.49
exp_2022_12_05_12 200 leopard 58 1670271146.7772324 2022-12-05T20:12:26.777232+00:00 -1247.79
exp_2022_12_05_12 200 leopard 59 1670271146.7822325 2022-12-05T20:12:26.782233+00:00 -1248.08
exp_2022_12_05_12 200 leopard 60 1670271146.7872324 2022-12-05T20:12:26.787232+00:00 -1248.35
exp_2022_12_05_12 200 leopard 61 1670271146.7922325 2022-12-05T20:12:26.792233+00:00 -1248.6
exp_2022_12_05_12 200 leopard 62 1670271146.7972324 2022-12-05T20:12:26.797232+00:00 -1248.83
exp_2022_12_05_12 200 leopard 63 1670271146.8022325 2022-12-05T20:12:26.802233+00:00 -1249.04
exp_2022_12_05_12 200 leopard 64 1670271146.8072324 2022-12-05T20:12:26.807232+00:00 -1249.23
exp_2022_12_05_12 200 leopard 65 1670271146.8122325 2022-12-05T20:12:26.812232+00:00 -1249.39
exp_2022_12_05_12 200 leopard 66 1670271146.8172324 2022-12-05T20:12:26.817232+00:00 -1249.53
exp_2022_12_05_12 200 leopard 67 1670271146.8222325 2022-12-05T20:12:26.822232+00:00 -1249.64
exp_2022_12_05_12 200 leopard 68 1670271146.8272324 2022-12-05T20:12:26.827232+00:00 -1249.73
exp_2022_12_05_12 200 leopard 69 1670271146.8322325 2022-12-05T20:12:26.832232+00:00 -1249.79
exp_2022_12_05_12 200 leopard 70 1670271146.8372324 2022-12-05T20:12:26.837232+00:00 -1249.83
exp_2022_12_05_12 200 leopard 71 1670271146.8422325 2022-12-05T20:12:26.842232+00:00 -1249.85
exp_2022_12_05_12 200 leopard 72 1670271146.8472323 2022-12-05T20:12:26.847232+00:00 -1249.84
exp_2022_12_05_12 200 leopard 73 1670271146.8522325 2022-12-05T20:12:26.852232+00:00 -1249.81
exp_2022_12_05_12 200 leopard 74 1670271146.8572323 2022-12-05T20:12:26.857232+00:00 -1249.76
exp_2022_12_05_12 200 leopard 75 1670271146.8622324 2022-12-05T20:12:26.862232+00:00 -1249.69
exp_2022_12_05_12 200 leopard 76 1670271146.8672326 2022-12-05T20:12:26.867233+00:00 -1249.59
exp_2022_12_05_12 200 leopard 77 1670271146.8722324 2022-12-05T20:12:26.872232+00:00 -1249.47
exp_2022_12_05_12 200 leopard 78 1670271146.8772326 2022-12-05T20:12:26.877233+00:00 -1249.34
exp_2022_12_05_12 200 leopard 79 1670271146.8822324 2022-12-05T20:12:26.882232+00:00 -1249.19
exp_2022_12_05_12 200 leopard 80 1670271146.8872325 2022-12-05T20:12:26.887233+00:00 -1249.02
exp_2022_12_05_12 200 leopard 81 1670271146.8922324 2022-12-05T20:12:26.892232+00:00 -1248.84
exp_2022_12_05_12 200 leopard 82 1670271146.8972325 2022-12-05T20:12:26.897233+00:00 -1248.64
exp_2022_12_05_12 200 leopard 83 1670271146.9022324 2022-12-05T20:12:26.902232+00:00 -1248.43
exp_2022_12_05_12 200 leopard 84 1670271146.9072325 2022-12-05T20:12:26.907233+00:00 -1248.21
exp_2022_12_05_12 200 leopard 85 1670271146.9122324 2022-12-05T20:12:26.912232+00:00 -1247.98
exp_2022_12_05_12 200 leopard 86 1670271146.9172325 2022-12-05T20:12:26.917233+00:00 -1247.75
exp_2022_12_05_12 200 leopard 87 1670271146.9222324 2022-12-05T20:12:26.922232+00:00 -1247.51
exp_2022_12_05_12 200 leopard 88 1670271146.9272325 2022-12-05T20:12:26.927233+00:00 -1247.26
exp_2022_12_05_12 200 leopard 89 1670271146.9322324 2022-12-05T20:12:26.932232+00:00 -1247.01
exp_2022_12_05_12 200 leopard 90 1670271146.9372325 2022-12-05T20:12:26.937232+00:00 -1246.76
exp_2022_12_05_12 200 leopard 91 1670271146.9422324 2022-12-05T20:12:26.942232+00:00 -1246.52
exp_2022_12_05_12 200 leopard 92 1670271146.9472325 2022-12-05T20:12:26.947232+00:00 -1246.27
exp_2022_12_05_12 200 leopard 93 1670271146.9522324 2022-12-05T20:12:26.952232+00:00 -1246.02
exp_2022_12_05_12 200 leopard 94 1670271146.9572325 2022-12-05T20:12:26.957232+00:00 -1245.78
exp_2022_12_05_12 200 leopard 95 1670271146.9622324 2022-12-05T20:12:26.962232+00:00 -1245.55
exp_2022_12_05_12 200 leopard 96 1670271146.9672325 2022-12-05T20:12:26.967232+00:00 -1245.32
exp_2022_12_05_12 200 leopard 97 1670271146.9722323 2022-12-05T20:12:26.972232+00:00 -1245.1
exp_2022_12_05_12 200 leopard 98 1670271146.9772325 2022-12-05T20:12:26.977232+00:00 -1244.89
exp_2022_12_05_12 200 leopard 99 1670271146.9822323 2022-12-05T20:12:26.982232+00:00 -1244.69

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