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

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_09_30_10 200 leopard 100 1664562938.7463894 2022-09-30T18:35:38.746389+00:00 192271.0
exp_2022_09_30_10 200 leopard 101 1664562938.7513895 2022-09-30T18:35:38.751390+00:00 192264.0
exp_2022_09_30_10 200 leopard 102 1664562938.7563894 2022-09-30T18:35:38.756389+00:00 192256.0
exp_2022_09_30_10 200 leopard 103 1664562938.7613895 2022-09-30T18:35:38.761389+00:00 192248.0
exp_2022_09_30_10 200 leopard 104 1664562938.7663894 2022-09-30T18:35:38.766389+00:00 192240.0
exp_2022_09_30_10 200 leopard 105 1664562938.7713895 2022-09-30T18:35:38.771389+00:00 192231.0
exp_2022_09_30_10 200 leopard 106 1664562938.7763894 2022-09-30T18:35:38.776389+00:00 192223.0
exp_2022_09_30_10 200 leopard 107 1664562938.7813895 2022-09-30T18:35:38.781389+00:00 192215.0
exp_2022_09_30_10 200 leopard 108 1664562938.7863894 2022-09-30T18:35:38.786389+00:00 192207.0
exp_2022_09_30_10 200 leopard 109 1664562938.7913895 2022-09-30T18:35:38.791389+00:00 192198.0
exp_2022_09_30_10 200 leopard 110 1664562938.7963893 2022-09-30T18:35:38.796389+00:00 192190.0
exp_2022_09_30_10 200 leopard 111 1664562938.8013895 2022-09-30T18:35:38.801389+00:00 192182.0
exp_2022_09_30_10 200 leopard 112 1664562938.8063893 2022-09-30T18:35:38.806389+00:00 192173.0
exp_2022_09_30_10 200 leopard 113 1664562938.8113894 2022-09-30T18:35:38.811389+00:00 192165.0
exp_2022_09_30_10 200 leopard 114 1664562938.8163893 2022-09-30T18:35:38.816389+00:00 192156.0
exp_2022_09_30_10 200 leopard 115 1664562938.8213894 2022-09-30T18:35:38.821389+00:00 192148.0
exp_2022_09_30_10 200 leopard 116 1664562938.8263893 2022-09-30T18:35:38.826389+00:00 192140.0
exp_2022_09_30_10 200 leopard 117 1664562938.8313894 2022-09-30T18:35:38.831389+00:00 192131.0
exp_2022_09_30_10 200 leopard 118 1664562938.8363893 2022-09-30T18:35:38.836389+00:00 192122.0
exp_2022_09_30_10 200 leopard 119 1664562938.8413894 2022-09-30T18:35:38.841389+00:00 192114.0
exp_2022_09_30_10 200 leopard 120 1664562938.8463893 2022-09-30T18:35:38.846389+00:00 192105.0
exp_2022_09_30_10 200 leopard 121 1664562938.8513894 2022-09-30T18:35:38.851389+00:00 192096.0
exp_2022_09_30_10 200 leopard 122 1664562938.8563893 2022-09-30T18:35:38.856389+00:00 192088.0
exp_2022_09_30_10 200 leopard 123 1664562938.8613894 2022-09-30T18:35:38.861389+00:00 192079.0
exp_2022_09_30_10 200 leopard 124 1664562938.8663893 2022-09-30T18:35:38.866389+00:00 192070.0
exp_2022_09_30_10 200 leopard 125 1664562938.8713894 2022-09-30T18:35:38.871389+00:00 192062.0
exp_2022_09_30_10 200 leopard 126 1664562938.8763895 2022-09-30T18:35:38.876390+00:00 192053.0
exp_2022_09_30_10 200 leopard 127 1664562938.8813894 2022-09-30T18:35:38.881389+00:00 192044.0
exp_2022_09_30_10 200 leopard 128 1664562938.8863895 2022-09-30T18:35:38.886389+00:00 192036.0
exp_2022_09_30_10 200 leopard 129 1664562938.8913894 2022-09-30T18:35:38.891389+00:00 192027.0
exp_2022_09_30_10 200 leopard 130 1664562938.8963895 2022-09-30T18:35:38.896389+00:00 192018.0
exp_2022_09_30_10 200 leopard 131 1664562938.9013894 2022-09-30T18:35:38.901389+00:00 192009.0
exp_2022_09_30_10 200 leopard 132 1664562938.9063895 2022-09-30T18:35:38.906389+00:00 192000.0
exp_2022_09_30_10 200 leopard 133 1664562938.9113894 2022-09-30T18:35:38.911389+00:00 191992.0
exp_2022_09_30_10 200 leopard 134 1664562938.9163895 2022-09-30T18:35:38.916389+00:00 191983.0
exp_2022_09_30_10 200 leopard 135 1664562938.9213893 2022-09-30T18:35:38.921389+00:00 191974.0
exp_2022_09_30_10 200 leopard 136 1664562938.9263895 2022-09-30T18:35:38.926389+00:00 191965.0
exp_2022_09_30_10 200 leopard 137 1664562938.9313893 2022-09-30T18:35:38.931389+00:00 191956.0
exp_2022_09_30_10 200 leopard 138 1664562938.9363894 2022-09-30T18:35:38.936389+00:00 191947.0
exp_2022_09_30_10 200 leopard 139 1664562938.9413893 2022-09-30T18:35:38.941389+00:00 191938.0
exp_2022_09_30_10 200 leopard 140 1664562938.9463894 2022-09-30T18:35:38.946389+00:00 191930.0
exp_2022_09_30_10 200 leopard 141 1664562938.9513893 2022-09-30T18:35:38.951389+00:00 191921.0
exp_2022_09_30_10 200 leopard 142 1664562938.9563894 2022-09-30T18:35:38.956389+00:00 191912.0
exp_2022_09_30_10 200 leopard 143 1664562938.9613893 2022-09-30T18:35:38.961389+00:00 191903.0
exp_2022_09_30_10 200 leopard 144 1664562938.9663894 2022-09-30T18:35:38.966389+00:00 191894.0
exp_2022_09_30_10 200 leopard 145 1664562938.9713893 2022-09-30T18:35:38.971389+00:00 191885.0
exp_2022_09_30_10 200 leopard 146 1664562938.9763894 2022-09-30T18:35:38.976389+00:00 191876.0
exp_2022_09_30_10 200 leopard 147 1664562938.9813893 2022-09-30T18:35:38.981389+00:00 191867.0
exp_2022_09_30_10 200 leopard 148 1664562938.9863894 2022-09-30T18:35:38.986389+00:00 191858.0
exp_2022_09_30_10 200 leopard 149 1664562938.9913893 2022-09-30T18:35:38.991389+00:00 191850.0
exp_2022_09_30_10 200 leopard 150 1664562938.9963894 2022-09-30T18:35:38.996389+00:00 191841.0
exp_2022_09_30_10 200 leopard 151 1664562939.0013895 2022-09-30T18:35:39.001390+00:00 191832.0
exp_2022_09_30_10 200 leopard 152 1664562939.0063894 2022-09-30T18:35:39.006389+00:00 191823.0
exp_2022_09_30_10 200 leopard 153 1664562939.0113895 2022-09-30T18:35:39.011389+00:00 191814.0
exp_2022_09_30_10 200 leopard 154 1664562939.0163894 2022-09-30T18:35:39.016389+00:00 191805.0
exp_2022_09_30_10 200 leopard 155 1664562939.0213895 2022-09-30T18:35:39.021389+00:00 191796.0
exp_2022_09_30_10 200 leopard 156 1664562939.0263894 2022-09-30T18:35:39.026389+00:00 191788.0
exp_2022_09_30_10 200 leopard 157 1664562939.0313895 2022-09-30T18:35:39.031389+00:00 191779.0
exp_2022_09_30_10 200 leopard 158 1664562939.0363894 2022-09-30T18:35:39.036389+00:00 191770.0
exp_2022_09_30_10 200 leopard 159 1664562939.0413895 2022-09-30T18:35:39.041389+00:00 191761.0
exp_2022_09_30_10 200 leopard 160 1664562939.0463893 2022-09-30T18:35:39.046389+00:00 191752.0
exp_2022_09_30_10 200 leopard 161 1664562939.0513895 2022-09-30T18:35:39.051389+00:00 191744.0
exp_2022_09_30_10 200 leopard 162 1664562939.0563893 2022-09-30T18:35:39.056389+00:00 191735.0
exp_2022_09_30_10 200 leopard 163 1664562939.0613894 2022-09-30T18:35:39.061389+00:00 191726.0
exp_2022_09_30_10 200 leopard 164 1664562939.0663893 2022-09-30T18:35:39.066389+00:00 191718.0
exp_2022_09_30_10 200 leopard 165 1664562939.0713894 2022-09-30T18:35:39.071389+00:00 191709.0
exp_2022_09_30_10 200 leopard 166 1664562939.0763893 2022-09-30T18:35:39.076389+00:00 191700.0
exp_2022_09_30_10 200 leopard 167 1664562939.0813894 2022-09-30T18:35:39.081389+00:00 191692.0
exp_2022_09_30_10 200 leopard 168 1664562939.0863893 2022-09-30T18:35:39.086389+00:00 191683.0
exp_2022_09_30_10 200 leopard 169 1664562939.0913894 2022-09-30T18:35:39.091389+00:00 191675.0
exp_2022_09_30_10 200 leopard 170 1664562939.0963893 2022-09-30T18:35:39.096389+00:00 191666.0
exp_2022_09_30_10 200 leopard 171 1664562939.1013894 2022-09-30T18:35:39.101389+00:00 191658.0
exp_2022_09_30_10 200 leopard 172 1664562939.1063893 2022-09-30T18:35:39.106389+00:00 191649.0
exp_2022_09_30_10 200 leopard 173 1664562939.1113894 2022-09-30T18:35:39.111389+00:00 191641.0
exp_2022_09_30_10 200 leopard 174 1664562939.1163893 2022-09-30T18:35:39.116389+00:00 191632.0
exp_2022_09_30_10 200 leopard 175 1664562939.1213894 2022-09-30T18:35:39.121389+00:00 191624.0
exp_2022_09_30_10 200 leopard 176 1664562939.1263895 2022-09-30T18:35:39.126390+00:00 191616.0
exp_2022_09_30_10 200 leopard 177 1664562939.1313894 2022-09-30T18:35:39.131389+00:00 191607.0
exp_2022_09_30_10 200 leopard 178 1664562939.1363895 2022-09-30T18:35:39.136389+00:00 191599.0
exp_2022_09_30_10 200 leopard 179 1664562939.1413894 2022-09-30T18:35:39.141389+00:00 191591.0
exp_2022_09_30_10 200 leopard 180 1664562939.1463895 2022-09-30T18:35:39.146389+00:00 191583.0
exp_2022_09_30_10 200 leopard 181 1664562939.1513894 2022-09-30T18:35:39.151389+00:00 191575.0
exp_2022_09_30_10 200 leopard 182 1664562939.1563895 2022-09-30T18:35:39.156389+00:00 191566.0
exp_2022_09_30_10 200 leopard 183 1664562939.1613894 2022-09-30T18:35:39.161389+00:00 191558.0
exp_2022_09_30_10 200 leopard 184 1664562939.1663895 2022-09-30T18:35:39.166389+00:00 191550.0
exp_2022_09_30_10 200 leopard 185 1664562939.1713893 2022-09-30T18:35:39.171389+00:00 191542.0
exp_2022_09_30_10 200 leopard 186 1664562939.1763895 2022-09-30T18:35:39.176389+00:00 191534.0
exp_2022_09_30_10 200 leopard 187 1664562939.1813893 2022-09-30T18:35:39.181389+00:00 191526.0
exp_2022_09_30_10 200 leopard 188 1664562939.1863894 2022-09-30T18:35:39.186389+00:00 191518.0
exp_2022_09_30_10 200 leopard 189 1664562939.1913893 2022-09-30T18:35:39.191389+00:00 191509.0
exp_2022_09_30_10 200 leopard 190 1664562939.1963894 2022-09-30T18:35:39.196389+00:00 191501.0
exp_2022_09_30_10 200 leopard 191 1664562939.2013893 2022-09-30T18:35:39.201389+00:00 191493.0
exp_2022_09_30_10 200 leopard 192 1664562939.2063894 2022-09-30T18:35:39.206389+00:00 191485.0
exp_2022_09_30_10 200 leopard 193 1664562939.2113893 2022-09-30T18:35:39.211389+00:00 191477.0
exp_2022_09_30_10 200 leopard 194 1664562939.2163894 2022-09-30T18:35:39.216389+00:00 191469.0
exp_2022_09_30_10 200 leopard 195 1664562939.2213893 2022-09-30T18:35:39.221389+00:00 191461.0
exp_2022_09_30_10 200 leopard 196 1664562939.2263894 2022-09-30T18:35:39.226389+00:00 191452.0
exp_2022_09_30_10 200 leopard 197 1664562939.2313893 2022-09-30T18:35:39.231389+00:00 191444.0
exp_2022_09_30_10 200 leopard 198 1664562939.2363894 2022-09-30T18:35:39.236389+00:00 191436.0
exp_2022_09_30_10 200 leopard 199 1664562939.2413893 2022-09-30T18:35:39.241389+00:00 191428.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]);