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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_04_21_10 200 leopard 0 1682100781.9314458 2023-04-21T18:13:01.931446+00:00 23825.8
exp_2023_04_21_10 200 leopard 1 1682100781.936446 2023-04-21T18:13:01.936446+00:00 23442.6
exp_2023_04_21_10 200 leopard 2 1682100781.9414458 2023-04-21T18:13:01.941446+00:00 23059.2
exp_2023_04_21_10 200 leopard 3 1682100781.946446 2023-04-21T18:13:01.946446+00:00 22677.0
exp_2023_04_21_10 200 leopard 4 1682100781.9514458 2023-04-21T18:13:01.951446+00:00 22297.1
exp_2023_04_21_10 200 leopard 5 1682100781.956446 2023-04-21T18:13:01.956446+00:00 21920.9
exp_2023_04_21_10 200 leopard 6 1682100781.9614458 2023-04-21T18:13:01.961446+00:00 21549.7
exp_2023_04_21_10 200 leopard 7 1682100781.966446 2023-04-21T18:13:01.966446+00:00 21184.5
exp_2023_04_21_10 200 leopard 8 1682100781.9714458 2023-04-21T18:13:01.971446+00:00 20826.7
exp_2023_04_21_10 200 leopard 9 1682100781.976446 2023-04-21T18:13:01.976446+00:00 20477.3
exp_2023_04_21_10 200 leopard 10 1682100781.9814458 2023-04-21T18:13:01.981446+00:00 20137.3
exp_2023_04_21_10 200 leopard 11 1682100781.986446 2023-04-21T18:13:01.986446+00:00 19807.8
exp_2023_04_21_10 200 leopard 12 1682100781.9914458 2023-04-21T18:13:01.991446+00:00 19489.7
exp_2023_04_21_10 200 leopard 13 1682100781.996446 2023-04-21T18:13:01.996446+00:00 19183.7
exp_2023_04_21_10 200 leopard 14 1682100782.0014458 2023-04-21T18:13:02.001446+00:00 18890.6
exp_2023_04_21_10 200 leopard 15 1682100782.006446 2023-04-21T18:13:02.006446+00:00 18611.2
exp_2023_04_21_10 200 leopard 16 1682100782.0114458 2023-04-21T18:13:02.011446+00:00 18345.8
exp_2023_04_21_10 200 leopard 17 1682100782.0164459 2023-04-21T18:13:02.016446+00:00 18094.9
exp_2023_04_21_10 200 leopard 18 1682100782.0214458 2023-04-21T18:13:02.021446+00:00 17859.1
exp_2023_04_21_10 200 leopard 19 1682100782.0264459 2023-04-21T18:13:02.026446+00:00 17638.4
exp_2023_04_21_10 200 leopard 20 1682100782.0314457 2023-04-21T18:13:02.031446+00:00 17433.0
exp_2023_04_21_10 200 leopard 21 1682100782.0364459 2023-04-21T18:13:02.036446+00:00 17243.1
exp_2023_04_21_10 200 leopard 22 1682100782.0414457 2023-04-21T18:13:02.041446+00:00 17068.6
exp_2023_04_21_10 200 leopard 23 1682100782.0464458 2023-04-21T18:13:02.046446+00:00 16909.4
exp_2023_04_21_10 200 leopard 24 1682100782.0514457 2023-04-21T18:13:02.051446+00:00 16765.4
exp_2023_04_21_10 200 leopard 25 1682100782.0564458 2023-04-21T18:13:02.056446+00:00 16636.1
exp_2023_04_21_10 200 leopard 26 1682100782.061446 2023-04-21T18:13:02.061446+00:00 16521.4
exp_2023_04_21_10 200 leopard 27 1682100782.0664458 2023-04-21T18:13:02.066446+00:00 16420.8
exp_2023_04_21_10 200 leopard 28 1682100782.071446 2023-04-21T18:13:02.071446+00:00 16333.8
exp_2023_04_21_10 200 leopard 29 1682100782.0764458 2023-04-21T18:13:02.076446+00:00 16259.9
exp_2023_04_21_10 200 leopard 30 1682100782.081446 2023-04-21T18:13:02.081446+00:00 16198.4
exp_2023_04_21_10 200 leopard 31 1682100782.0864458 2023-04-21T18:13:02.086446+00:00 16148.9
exp_2023_04_21_10 200 leopard 32 1682100782.091446 2023-04-21T18:13:02.091446+00:00 16110.5
exp_2023_04_21_10 200 leopard 33 1682100782.0964458 2023-04-21T18:13:02.096446+00:00 16082.6
exp_2023_04_21_10 200 leopard 34 1682100782.101446 2023-04-21T18:13:02.101446+00:00 16064.5
exp_2023_04_21_10 200 leopard 35 1682100782.1064458 2023-04-21T18:13:02.106446+00:00 16055.5
exp_2023_04_21_10 200 leopard 36 1682100782.111446 2023-04-21T18:13:02.111446+00:00 16054.7
exp_2023_04_21_10 200 leopard 37 1682100782.1164458 2023-04-21T18:13:02.116446+00:00 16061.5
exp_2023_04_21_10 200 leopard 38 1682100782.121446 2023-04-21T18:13:02.121446+00:00 16074.9
exp_2023_04_21_10 200 leopard 39 1682100782.1264458 2023-04-21T18:13:02.126446+00:00 16094.4
exp_2023_04_21_10 200 leopard 40 1682100782.131446 2023-04-21T18:13:02.131446+00:00 16119.2
exp_2023_04_21_10 200 leopard 41 1682100782.1364458 2023-04-21T18:13:02.136446+00:00 16148.4
exp_2023_04_21_10 200 leopard 42 1682100782.1414459 2023-04-21T18:13:02.141446+00:00 16181.4
exp_2023_04_21_10 200 leopard 43 1682100782.1464458 2023-04-21T18:13:02.146446+00:00 16217.5
exp_2023_04_21_10 200 leopard 44 1682100782.1514459 2023-04-21T18:13:02.151446+00:00 16256.0
exp_2023_04_21_10 200 leopard 45 1682100782.1564457 2023-04-21T18:13:02.156446+00:00 16296.4
exp_2023_04_21_10 200 leopard 46 1682100782.1614459 2023-04-21T18:13:02.161446+00:00 16337.9
exp_2023_04_21_10 200 leopard 47 1682100782.1664457 2023-04-21T18:13:02.166446+00:00 16380.1
exp_2023_04_21_10 200 leopard 48 1682100782.1714458 2023-04-21T18:13:02.171446+00:00 16422.3
exp_2023_04_21_10 200 leopard 49 1682100782.1764457 2023-04-21T18:13:02.176446+00:00 16464.1
exp_2023_04_21_10 200 leopard 50 1682100782.1814458 2023-04-21T18:13:02.181446+00:00 16505.1
exp_2023_04_21_10 200 leopard 51 1682100782.186446 2023-04-21T18:13:02.186446+00:00 16544.9
exp_2023_04_21_10 200 leopard 52 1682100782.1914458 2023-04-21T18:13:02.191446+00:00 16582.9
exp_2023_04_21_10 200 leopard 53 1682100782.196446 2023-04-21T18:13:02.196446+00:00 16619.0
exp_2023_04_21_10 200 leopard 54 1682100782.2014458 2023-04-21T18:13:02.201446+00:00 16652.8
exp_2023_04_21_10 200 leopard 55 1682100782.206446 2023-04-21T18:13:02.206446+00:00 16684.2
exp_2023_04_21_10 200 leopard 56 1682100782.2114458 2023-04-21T18:13:02.211446+00:00 16712.7
exp_2023_04_21_10 200 leopard 57 1682100782.216446 2023-04-21T18:13:02.216446+00:00 16738.4
exp_2023_04_21_10 200 leopard 58 1682100782.2214458 2023-04-21T18:13:02.221446+00:00 16761.0
exp_2023_04_21_10 200 leopard 59 1682100782.226446 2023-04-21T18:13:02.226446+00:00 16780.4
exp_2023_04_21_10 200 leopard 60 1682100782.2314458 2023-04-21T18:13:02.231446+00:00 16796.6
exp_2023_04_21_10 200 leopard 61 1682100782.236446 2023-04-21T18:13:02.236446+00:00 16809.5
exp_2023_04_21_10 200 leopard 62 1682100782.2414458 2023-04-21T18:13:02.241446+00:00 16819.2
exp_2023_04_21_10 200 leopard 63 1682100782.246446 2023-04-21T18:13:02.246446+00:00 16825.5
exp_2023_04_21_10 200 leopard 64 1682100782.2514458 2023-04-21T18:13:02.251446+00:00 16828.6
exp_2023_04_21_10 200 leopard 65 1682100782.256446 2023-04-21T18:13:02.256446+00:00 16828.4
exp_2023_04_21_10 200 leopard 66 1682100782.2614458 2023-04-21T18:13:02.261446+00:00 16825.1
exp_2023_04_21_10 200 leopard 67 1682100782.2664459 2023-04-21T18:13:02.266446+00:00 16818.8
exp_2023_04_21_10 200 leopard 68 1682100782.2714458 2023-04-21T18:13:02.271446+00:00 16809.5
exp_2023_04_21_10 200 leopard 69 1682100782.2764459 2023-04-21T18:13:02.276446+00:00 16797.4
exp_2023_04_21_10 200 leopard 70 1682100782.2814457 2023-04-21T18:13:02.281446+00:00 16782.6
exp_2023_04_21_10 200 leopard 71 1682100782.2864459 2023-04-21T18:13:02.286446+00:00 16765.2
exp_2023_04_21_10 200 leopard 72 1682100782.2914457 2023-04-21T18:13:02.291446+00:00 16745.4
exp_2023_04_21_10 200 leopard 73 1682100782.2964458 2023-04-21T18:13:02.296446+00:00 16723.4
exp_2023_04_21_10 200 leopard 74 1682100782.3014457 2023-04-21T18:13:02.301446+00:00 16699.2
exp_2023_04_21_10 200 leopard 75 1682100782.3064458 2023-04-21T18:13:02.306446+00:00 16673.1
exp_2023_04_21_10 200 leopard 76 1682100782.311446 2023-04-21T18:13:02.311446+00:00 16645.2
exp_2023_04_21_10 200 leopard 77 1682100782.3164458 2023-04-21T18:13:02.316446+00:00 16615.6
exp_2023_04_21_10 200 leopard 78 1682100782.321446 2023-04-21T18:13:02.321446+00:00 16584.6
exp_2023_04_21_10 200 leopard 79 1682100782.3264458 2023-04-21T18:13:02.326446+00:00 16552.4
exp_2023_04_21_10 200 leopard 80 1682100782.331446 2023-04-21T18:13:02.331446+00:00 16518.9
exp_2023_04_21_10 200 leopard 81 1682100782.3364458 2023-04-21T18:13:02.336446+00:00 16484.6
exp_2023_04_21_10 200 leopard 82 1682100782.341446 2023-04-21T18:13:02.341446+00:00 16449.4
exp_2023_04_21_10 200 leopard 83 1682100782.3464458 2023-04-21T18:13:02.346446+00:00 16413.7
exp_2023_04_21_10 200 leopard 84 1682100782.351446 2023-04-21T18:13:02.351446+00:00 16377.6
exp_2023_04_21_10 200 leopard 85 1682100782.3564458 2023-04-21T18:13:02.356446+00:00 16341.2
exp_2023_04_21_10 200 leopard 86 1682100782.361446 2023-04-21T18:13:02.361446+00:00 16304.7
exp_2023_04_21_10 200 leopard 87 1682100782.3664458 2023-04-21T18:13:02.366446+00:00 16268.5
exp_2023_04_21_10 200 leopard 88 1682100782.371446 2023-04-21T18:13:02.371446+00:00 16232.5
exp_2023_04_21_10 200 leopard 89 1682100782.3764458 2023-04-21T18:13:02.376446+00:00 16197.1
exp_2023_04_21_10 200 leopard 90 1682100782.381446 2023-04-21T18:13:02.381446+00:00 16162.4
exp_2023_04_21_10 200 leopard 91 1682100782.3864458 2023-04-21T18:13:02.386446+00:00 16128.8
exp_2023_04_21_10 200 leopard 92 1682100782.3914459 2023-04-21T18:13:02.391446+00:00 16096.4
exp_2023_04_21_10 200 leopard 93 1682100782.3964458 2023-04-21T18:13:02.396446+00:00 16065.3
exp_2023_04_21_10 200 leopard 94 1682100782.4014459 2023-04-21T18:13:02.401446+00:00 16036.1
exp_2023_04_21_10 200 leopard 95 1682100782.4064457 2023-04-21T18:13:02.406446+00:00 16008.8
exp_2023_04_21_10 200 leopard 96 1682100782.4114459 2023-04-21T18:13:02.411446+00:00 15983.7
exp_2023_04_21_10 200 leopard 97 1682100782.4164457 2023-04-21T18:13:02.416446+00:00 15961.1
exp_2023_04_21_10 200 leopard 98 1682100782.4214458 2023-04-21T18:13:02.421446+00:00 15941.4
exp_2023_04_21_10 200 leopard 99 1682100782.4264457 2023-04-21T18:13:02.426446+00:00 15924.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]);