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.

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_09_30_10 200 leopard 0 1664562938.2463894 2022-09-30T18:35:38.246389+00:00 192823.0
exp_2022_09_30_10 200 leopard 1 1664562938.2513895 2022-09-30T18:35:38.251390+00:00 192822.0
exp_2022_09_30_10 200 leopard 2 1664562938.2563894 2022-09-30T18:35:38.256389+00:00 192820.0
exp_2022_09_30_10 200 leopard 3 1664562938.2613895 2022-09-30T18:35:38.261389+00:00 192818.0
exp_2022_09_30_10 200 leopard 4 1664562938.2663894 2022-09-30T18:35:38.266389+00:00 192817.0
exp_2022_09_30_10 200 leopard 5 1664562938.2713895 2022-09-30T18:35:38.271389+00:00 192815.0
exp_2022_09_30_10 200 leopard 6 1664562938.2763894 2022-09-30T18:35:38.276389+00:00 192813.0
exp_2022_09_30_10 200 leopard 7 1664562938.2813895 2022-09-30T18:35:38.281389+00:00 192811.0
exp_2022_09_30_10 200 leopard 8 1664562938.2863894 2022-09-30T18:35:38.286389+00:00 192809.0
exp_2022_09_30_10 200 leopard 9 1664562938.2913895 2022-09-30T18:35:38.291389+00:00 192807.0
exp_2022_09_30_10 200 leopard 10 1664562938.2963893 2022-09-30T18:35:38.296389+00:00 192804.0
exp_2022_09_30_10 200 leopard 11 1664562938.3013895 2022-09-30T18:35:38.301389+00:00 192802.0
exp_2022_09_30_10 200 leopard 12 1664562938.3063893 2022-09-30T18:35:38.306389+00:00 192799.0
exp_2022_09_30_10 200 leopard 13 1664562938.3113894 2022-09-30T18:35:38.311389+00:00 192797.0
exp_2022_09_30_10 200 leopard 14 1664562938.3163893 2022-09-30T18:35:38.316389+00:00 192794.0
exp_2022_09_30_10 200 leopard 15 1664562938.3213894 2022-09-30T18:35:38.321389+00:00 192791.0
exp_2022_09_30_10 200 leopard 16 1664562938.3263893 2022-09-30T18:35:38.326389+00:00 192788.0
exp_2022_09_30_10 200 leopard 17 1664562938.3313894 2022-09-30T18:35:38.331389+00:00 192785.0
exp_2022_09_30_10 200 leopard 18 1664562938.3363893 2022-09-30T18:35:38.336389+00:00 192781.0
exp_2022_09_30_10 200 leopard 19 1664562938.3413894 2022-09-30T18:35:38.341389+00:00 192778.0
exp_2022_09_30_10 200 leopard 20 1664562938.3463893 2022-09-30T18:35:38.346389+00:00 192774.0
exp_2022_09_30_10 200 leopard 21 1664562938.3513894 2022-09-30T18:35:38.351389+00:00 192770.0
exp_2022_09_30_10 200 leopard 22 1664562938.3563893 2022-09-30T18:35:38.356389+00:00 192766.0
exp_2022_09_30_10 200 leopard 23 1664562938.3613894 2022-09-30T18:35:38.361389+00:00 192762.0
exp_2022_09_30_10 200 leopard 24 1664562938.3663893 2022-09-30T18:35:38.366389+00:00 192758.0
exp_2022_09_30_10 200 leopard 25 1664562938.3713894 2022-09-30T18:35:38.371389+00:00 192754.0
exp_2022_09_30_10 200 leopard 26 1664562938.3763895 2022-09-30T18:35:38.376390+00:00 192749.0
exp_2022_09_30_10 200 leopard 27 1664562938.3813894 2022-09-30T18:35:38.381389+00:00 192745.0
exp_2022_09_30_10 200 leopard 28 1664562938.3863895 2022-09-30T18:35:38.386389+00:00 192740.0
exp_2022_09_30_10 200 leopard 29 1664562938.3913894 2022-09-30T18:35:38.391389+00:00 192735.0
exp_2022_09_30_10 200 leopard 30 1664562938.3963895 2022-09-30T18:35:38.396389+00:00 192730.0
exp_2022_09_30_10 200 leopard 31 1664562938.4013894 2022-09-30T18:35:38.401389+00:00 192725.0
exp_2022_09_30_10 200 leopard 32 1664562938.4063895 2022-09-30T18:35:38.406389+00:00 192720.0
exp_2022_09_30_10 200 leopard 33 1664562938.4113894 2022-09-30T18:35:38.411389+00:00 192715.0
exp_2022_09_30_10 200 leopard 34 1664562938.4163895 2022-09-30T18:35:38.416389+00:00 192709.0
exp_2022_09_30_10 200 leopard 35 1664562938.4213893 2022-09-30T18:35:38.421389+00:00 192704.0
exp_2022_09_30_10 200 leopard 36 1664562938.4263895 2022-09-30T18:35:38.426389+00:00 192698.0
exp_2022_09_30_10 200 leopard 37 1664562938.4313893 2022-09-30T18:35:38.431389+00:00 192692.0
exp_2022_09_30_10 200 leopard 38 1664562938.4363894 2022-09-30T18:35:38.436389+00:00 192687.0
exp_2022_09_30_10 200 leopard 39 1664562938.4413893 2022-09-30T18:35:38.441389+00:00 192681.0
exp_2022_09_30_10 200 leopard 40 1664562938.4463894 2022-09-30T18:35:38.446389+00:00 192675.0
exp_2022_09_30_10 200 leopard 41 1664562938.4513893 2022-09-30T18:35:38.451389+00:00 192669.0
exp_2022_09_30_10 200 leopard 42 1664562938.4563894 2022-09-30T18:35:38.456389+00:00 192663.0
exp_2022_09_30_10 200 leopard 43 1664562938.4613893 2022-09-30T18:35:38.461389+00:00 192657.0
exp_2022_09_30_10 200 leopard 44 1664562938.4663894 2022-09-30T18:35:38.466389+00:00 192651.0
exp_2022_09_30_10 200 leopard 45 1664562938.4713893 2022-09-30T18:35:38.471389+00:00 192645.0
exp_2022_09_30_10 200 leopard 46 1664562938.4763894 2022-09-30T18:35:38.476389+00:00 192638.0
exp_2022_09_30_10 200 leopard 47 1664562938.4813893 2022-09-30T18:35:38.481389+00:00 192632.0
exp_2022_09_30_10 200 leopard 48 1664562938.4863894 2022-09-30T18:35:38.486389+00:00 192626.0
exp_2022_09_30_10 200 leopard 49 1664562938.4913893 2022-09-30T18:35:38.491389+00:00 192620.0
exp_2022_09_30_10 200 leopard 50 1664562938.4963894 2022-09-30T18:35:38.496389+00:00 192614.0
exp_2022_09_30_10 200 leopard 51 1664562938.5013895 2022-09-30T18:35:38.501390+00:00 192607.0
exp_2022_09_30_10 200 leopard 52 1664562938.5063894 2022-09-30T18:35:38.506389+00:00 192601.0
exp_2022_09_30_10 200 leopard 53 1664562938.5113895 2022-09-30T18:35:38.511389+00:00 192595.0
exp_2022_09_30_10 200 leopard 54 1664562938.5163894 2022-09-30T18:35:38.516389+00:00 192588.0
exp_2022_09_30_10 200 leopard 55 1664562938.5213895 2022-09-30T18:35:38.521389+00:00 192582.0
exp_2022_09_30_10 200 leopard 56 1664562938.5263894 2022-09-30T18:35:38.526389+00:00 192576.0
exp_2022_09_30_10 200 leopard 57 1664562938.5313895 2022-09-30T18:35:38.531389+00:00 192570.0
exp_2022_09_30_10 200 leopard 58 1664562938.5363894 2022-09-30T18:35:38.536389+00:00 192563.0
exp_2022_09_30_10 200 leopard 59 1664562938.5413895 2022-09-30T18:35:38.541389+00:00 192557.0
exp_2022_09_30_10 200 leopard 60 1664562938.5463893 2022-09-30T18:35:38.546389+00:00 192551.0
exp_2022_09_30_10 200 leopard 61 1664562938.5513895 2022-09-30T18:35:38.551389+00:00 192545.0
exp_2022_09_30_10 200 leopard 62 1664562938.5563893 2022-09-30T18:35:38.556389+00:00 192538.0
exp_2022_09_30_10 200 leopard 63 1664562938.5613894 2022-09-30T18:35:38.561389+00:00 192532.0
exp_2022_09_30_10 200 leopard 64 1664562938.5663893 2022-09-30T18:35:38.566389+00:00 192526.0
exp_2022_09_30_10 200 leopard 65 1664562938.5713894 2022-09-30T18:35:38.571389+00:00 192520.0
exp_2022_09_30_10 200 leopard 66 1664562938.5763893 2022-09-30T18:35:38.576389+00:00 192513.0
exp_2022_09_30_10 200 leopard 67 1664562938.5813894 2022-09-30T18:35:38.581389+00:00 192507.0
exp_2022_09_30_10 200 leopard 68 1664562938.5863893 2022-09-30T18:35:38.586389+00:00 192501.0
exp_2022_09_30_10 200 leopard 69 1664562938.5913894 2022-09-30T18:35:38.591389+00:00 192494.0
exp_2022_09_30_10 200 leopard 70 1664562938.5963893 2022-09-30T18:35:38.596389+00:00 192488.0
exp_2022_09_30_10 200 leopard 71 1664562938.6013894 2022-09-30T18:35:38.601389+00:00 192482.0
exp_2022_09_30_10 200 leopard 72 1664562938.6063893 2022-09-30T18:35:38.606389+00:00 192475.0
exp_2022_09_30_10 200 leopard 73 1664562938.6113894 2022-09-30T18:35:38.611389+00:00 192469.0
exp_2022_09_30_10 200 leopard 74 1664562938.6163893 2022-09-30T18:35:38.616389+00:00 192462.0
exp_2022_09_30_10 200 leopard 75 1664562938.6213894 2022-09-30T18:35:38.621389+00:00 192456.0
exp_2022_09_30_10 200 leopard 76 1664562938.6263895 2022-09-30T18:35:38.626390+00:00 192450.0
exp_2022_09_30_10 200 leopard 77 1664562938.6313894 2022-09-30T18:35:38.631389+00:00 192443.0
exp_2022_09_30_10 200 leopard 78 1664562938.6363895 2022-09-30T18:35:38.636389+00:00 192436.0
exp_2022_09_30_10 200 leopard 79 1664562938.6413894 2022-09-30T18:35:38.641389+00:00 192430.0
exp_2022_09_30_10 200 leopard 80 1664562938.6463895 2022-09-30T18:35:38.646389+00:00 192423.0
exp_2022_09_30_10 200 leopard 81 1664562938.6513894 2022-09-30T18:35:38.651389+00:00 192416.0
exp_2022_09_30_10 200 leopard 82 1664562938.6563895 2022-09-30T18:35:38.656389+00:00 192410.0
exp_2022_09_30_10 200 leopard 83 1664562938.6613894 2022-09-30T18:35:38.661389+00:00 192403.0
exp_2022_09_30_10 200 leopard 84 1664562938.6663895 2022-09-30T18:35:38.666389+00:00 192396.0
exp_2022_09_30_10 200 leopard 85 1664562938.6713893 2022-09-30T18:35:38.671389+00:00 192389.0
exp_2022_09_30_10 200 leopard 86 1664562938.6763895 2022-09-30T18:35:38.676389+00:00 192382.0
exp_2022_09_30_10 200 leopard 87 1664562938.6813893 2022-09-30T18:35:38.681389+00:00 192375.0
exp_2022_09_30_10 200 leopard 88 1664562938.6863894 2022-09-30T18:35:38.686389+00:00 192368.0
exp_2022_09_30_10 200 leopard 89 1664562938.6913893 2022-09-30T18:35:38.691389+00:00 192360.0
exp_2022_09_30_10 200 leopard 90 1664562938.6963894 2022-09-30T18:35:38.696389+00:00 192353.0
exp_2022_09_30_10 200 leopard 91 1664562938.7013893 2022-09-30T18:35:38.701389+00:00 192346.0
exp_2022_09_30_10 200 leopard 92 1664562938.7063894 2022-09-30T18:35:38.706389+00:00 192339.0
exp_2022_09_30_10 200 leopard 93 1664562938.7113893 2022-09-30T18:35:38.711389+00:00 192331.0
exp_2022_09_30_10 200 leopard 94 1664562938.7163894 2022-09-30T18:35:38.716389+00:00 192324.0
exp_2022_09_30_10 200 leopard 95 1664562938.7213893 2022-09-30T18:35:38.721389+00:00 192316.0
exp_2022_09_30_10 200 leopard 96 1664562938.7263894 2022-09-30T18:35:38.726389+00:00 192308.0
exp_2022_09_30_10 200 leopard 97 1664562938.7313893 2022-09-30T18:35:38.731389+00:00 192301.0
exp_2022_09_30_10 200 leopard 98 1664562938.7363894 2022-09-30T18:35:38.736389+00:00 192293.0
exp_2022_09_30_10 200 leopard 99 1664562938.7413893 2022-09-30T18:35:38.741389+00:00 192285.0

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