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 192277.0
exp_2022_09_30_10 200 leopard 101 1664562938.7513895 2022-09-30T18:35:38.751390+00:00 192270.0
exp_2022_09_30_10 200 leopard 102 1664562938.7563894 2022-09-30T18:35:38.756389+00:00 192262.0
exp_2022_09_30_10 200 leopard 103 1664562938.7613895 2022-09-30T18:35:38.761389+00:00 192254.0
exp_2022_09_30_10 200 leopard 104 1664562938.7663894 2022-09-30T18:35:38.766389+00:00 192246.0
exp_2022_09_30_10 200 leopard 105 1664562938.7713895 2022-09-30T18:35:38.771389+00:00 192237.0
exp_2022_09_30_10 200 leopard 106 1664562938.7763894 2022-09-30T18:35:38.776389+00:00 192229.0
exp_2022_09_30_10 200 leopard 107 1664562938.7813895 2022-09-30T18:35:38.781389+00:00 192221.0
exp_2022_09_30_10 200 leopard 108 1664562938.7863894 2022-09-30T18:35:38.786389+00:00 192213.0
exp_2022_09_30_10 200 leopard 109 1664562938.7913895 2022-09-30T18:35:38.791389+00:00 192204.0
exp_2022_09_30_10 200 leopard 110 1664562938.7963893 2022-09-30T18:35:38.796389+00:00 192196.0
exp_2022_09_30_10 200 leopard 111 1664562938.8013895 2022-09-30T18:35:38.801389+00:00 192188.0
exp_2022_09_30_10 200 leopard 112 1664562938.8063893 2022-09-30T18:35:38.806389+00:00 192179.0
exp_2022_09_30_10 200 leopard 113 1664562938.8113894 2022-09-30T18:35:38.811389+00:00 192171.0
exp_2022_09_30_10 200 leopard 114 1664562938.8163893 2022-09-30T18:35:38.816389+00:00 192162.0
exp_2022_09_30_10 200 leopard 115 1664562938.8213894 2022-09-30T18:35:38.821389+00:00 192154.0
exp_2022_09_30_10 200 leopard 116 1664562938.8263893 2022-09-30T18:35:38.826389+00:00 192146.0
exp_2022_09_30_10 200 leopard 117 1664562938.8313894 2022-09-30T18:35:38.831389+00:00 192137.0
exp_2022_09_30_10 200 leopard 118 1664562938.8363893 2022-09-30T18:35:38.836389+00:00 192128.0
exp_2022_09_30_10 200 leopard 119 1664562938.8413894 2022-09-30T18:35:38.841389+00:00 192120.0
exp_2022_09_30_10 200 leopard 120 1664562938.8463893 2022-09-30T18:35:38.846389+00:00 192111.0
exp_2022_09_30_10 200 leopard 121 1664562938.8513894 2022-09-30T18:35:38.851389+00:00 192102.0
exp_2022_09_30_10 200 leopard 122 1664562938.8563893 2022-09-30T18:35:38.856389+00:00 192094.0
exp_2022_09_30_10 200 leopard 123 1664562938.8613894 2022-09-30T18:35:38.861389+00:00 192085.0
exp_2022_09_30_10 200 leopard 124 1664562938.8663893 2022-09-30T18:35:38.866389+00:00 192076.0
exp_2022_09_30_10 200 leopard 125 1664562938.8713894 2022-09-30T18:35:38.871389+00:00 192068.0
exp_2022_09_30_10 200 leopard 126 1664562938.8763895 2022-09-30T18:35:38.876390+00:00 192059.0
exp_2022_09_30_10 200 leopard 127 1664562938.8813894 2022-09-30T18:35:38.881389+00:00 192050.0
exp_2022_09_30_10 200 leopard 128 1664562938.8863895 2022-09-30T18:35:38.886389+00:00 192042.0
exp_2022_09_30_10 200 leopard 129 1664562938.8913894 2022-09-30T18:35:38.891389+00:00 192033.0
exp_2022_09_30_10 200 leopard 130 1664562938.8963895 2022-09-30T18:35:38.896389+00:00 192024.0
exp_2022_09_30_10 200 leopard 131 1664562938.9013894 2022-09-30T18:35:38.901389+00:00 192015.0
exp_2022_09_30_10 200 leopard 132 1664562938.9063895 2022-09-30T18:35:38.906389+00:00 192006.0
exp_2022_09_30_10 200 leopard 133 1664562938.9113894 2022-09-30T18:35:38.911389+00:00 191998.0
exp_2022_09_30_10 200 leopard 134 1664562938.9163895 2022-09-30T18:35:38.916389+00:00 191989.0
exp_2022_09_30_10 200 leopard 135 1664562938.9213893 2022-09-30T18:35:38.921389+00:00 191980.0
exp_2022_09_30_10 200 leopard 136 1664562938.9263895 2022-09-30T18:35:38.926389+00:00 191971.0
exp_2022_09_30_10 200 leopard 137 1664562938.9313893 2022-09-30T18:35:38.931389+00:00 191962.0
exp_2022_09_30_10 200 leopard 138 1664562938.9363894 2022-09-30T18:35:38.936389+00:00 191953.0
exp_2022_09_30_10 200 leopard 139 1664562938.9413893 2022-09-30T18:35:38.941389+00:00 191944.0
exp_2022_09_30_10 200 leopard 140 1664562938.9463894 2022-09-30T18:35:38.946389+00:00 191936.0
exp_2022_09_30_10 200 leopard 141 1664562938.9513893 2022-09-30T18:35:38.951389+00:00 191927.0
exp_2022_09_30_10 200 leopard 142 1664562938.9563894 2022-09-30T18:35:38.956389+00:00 191918.0
exp_2022_09_30_10 200 leopard 143 1664562938.9613893 2022-09-30T18:35:38.961389+00:00 191909.0
exp_2022_09_30_10 200 leopard 144 1664562938.9663894 2022-09-30T18:35:38.966389+00:00 191900.0
exp_2022_09_30_10 200 leopard 145 1664562938.9713893 2022-09-30T18:35:38.971389+00:00 191891.0
exp_2022_09_30_10 200 leopard 146 1664562938.9763894 2022-09-30T18:35:38.976389+00:00 191882.0
exp_2022_09_30_10 200 leopard 147 1664562938.9813893 2022-09-30T18:35:38.981389+00:00 191873.0
exp_2022_09_30_10 200 leopard 148 1664562938.9863894 2022-09-30T18:35:38.986389+00:00 191864.0
exp_2022_09_30_10 200 leopard 149 1664562938.9913893 2022-09-30T18:35:38.991389+00:00 191856.0
exp_2022_09_30_10 200 leopard 150 1664562938.9963894 2022-09-30T18:35:38.996389+00:00 191847.0
exp_2022_09_30_10 200 leopard 151 1664562939.0013895 2022-09-30T18:35:39.001390+00:00 191838.0
exp_2022_09_30_10 200 leopard 152 1664562939.0063894 2022-09-30T18:35:39.006389+00:00 191829.0
exp_2022_09_30_10 200 leopard 153 1664562939.0113895 2022-09-30T18:35:39.011389+00:00 191820.0
exp_2022_09_30_10 200 leopard 154 1664562939.0163894 2022-09-30T18:35:39.016389+00:00 191811.0
exp_2022_09_30_10 200 leopard 155 1664562939.0213895 2022-09-30T18:35:39.021389+00:00 191802.0
exp_2022_09_30_10 200 leopard 156 1664562939.0263894 2022-09-30T18:35:39.026389+00:00 191794.0
exp_2022_09_30_10 200 leopard 157 1664562939.0313895 2022-09-30T18:35:39.031389+00:00 191785.0
exp_2022_09_30_10 200 leopard 158 1664562939.0363894 2022-09-30T18:35:39.036389+00:00 191776.0
exp_2022_09_30_10 200 leopard 159 1664562939.0413895 2022-09-30T18:35:39.041389+00:00 191767.0
exp_2022_09_30_10 200 leopard 160 1664562939.0463893 2022-09-30T18:35:39.046389+00:00 191758.0
exp_2022_09_30_10 200 leopard 161 1664562939.0513895 2022-09-30T18:35:39.051389+00:00 191750.0
exp_2022_09_30_10 200 leopard 162 1664562939.0563893 2022-09-30T18:35:39.056389+00:00 191741.0
exp_2022_09_30_10 200 leopard 163 1664562939.0613894 2022-09-30T18:35:39.061389+00:00 191732.0
exp_2022_09_30_10 200 leopard 164 1664562939.0663893 2022-09-30T18:35:39.066389+00:00 191724.0
exp_2022_09_30_10 200 leopard 165 1664562939.0713894 2022-09-30T18:35:39.071389+00:00 191715.0
exp_2022_09_30_10 200 leopard 166 1664562939.0763893 2022-09-30T18:35:39.076389+00:00 191706.0
exp_2022_09_30_10 200 leopard 167 1664562939.0813894 2022-09-30T18:35:39.081389+00:00 191698.0
exp_2022_09_30_10 200 leopard 168 1664562939.0863893 2022-09-30T18:35:39.086389+00:00 191689.0
exp_2022_09_30_10 200 leopard 169 1664562939.0913894 2022-09-30T18:35:39.091389+00:00 191681.0
exp_2022_09_30_10 200 leopard 170 1664562939.0963893 2022-09-30T18:35:39.096389+00:00 191672.0
exp_2022_09_30_10 200 leopard 171 1664562939.1013894 2022-09-30T18:35:39.101389+00:00 191664.0
exp_2022_09_30_10 200 leopard 172 1664562939.1063893 2022-09-30T18:35:39.106389+00:00 191655.0
exp_2022_09_30_10 200 leopard 173 1664562939.1113894 2022-09-30T18:35:39.111389+00:00 191647.0
exp_2022_09_30_10 200 leopard 174 1664562939.1163893 2022-09-30T18:35:39.116389+00:00 191638.0
exp_2022_09_30_10 200 leopard 175 1664562939.1213894 2022-09-30T18:35:39.121389+00:00 191630.0
exp_2022_09_30_10 200 leopard 176 1664562939.1263895 2022-09-30T18:35:39.126390+00:00 191622.0
exp_2022_09_30_10 200 leopard 177 1664562939.1313894 2022-09-30T18:35:39.131389+00:00 191613.0
exp_2022_09_30_10 200 leopard 178 1664562939.1363895 2022-09-30T18:35:39.136389+00:00 191605.0
exp_2022_09_30_10 200 leopard 179 1664562939.1413894 2022-09-30T18:35:39.141389+00:00 191597.0
exp_2022_09_30_10 200 leopard 180 1664562939.1463895 2022-09-30T18:35:39.146389+00:00 191589.0
exp_2022_09_30_10 200 leopard 181 1664562939.1513894 2022-09-30T18:35:39.151389+00:00 191581.0
exp_2022_09_30_10 200 leopard 182 1664562939.1563895 2022-09-30T18:35:39.156389+00:00 191572.0
exp_2022_09_30_10 200 leopard 183 1664562939.1613894 2022-09-30T18:35:39.161389+00:00 191564.0
exp_2022_09_30_10 200 leopard 184 1664562939.1663895 2022-09-30T18:35:39.166389+00:00 191556.0
exp_2022_09_30_10 200 leopard 185 1664562939.1713893 2022-09-30T18:35:39.171389+00:00 191548.0
exp_2022_09_30_10 200 leopard 186 1664562939.1763895 2022-09-30T18:35:39.176389+00:00 191540.0
exp_2022_09_30_10 200 leopard 187 1664562939.1813893 2022-09-30T18:35:39.181389+00:00 191532.0
exp_2022_09_30_10 200 leopard 188 1664562939.1863894 2022-09-30T18:35:39.186389+00:00 191524.0
exp_2022_09_30_10 200 leopard 189 1664562939.1913893 2022-09-30T18:35:39.191389+00:00 191515.0
exp_2022_09_30_10 200 leopard 190 1664562939.1963894 2022-09-30T18:35:39.196389+00:00 191507.0
exp_2022_09_30_10 200 leopard 191 1664562939.2013893 2022-09-30T18:35:39.201389+00:00 191499.0
exp_2022_09_30_10 200 leopard 192 1664562939.2063894 2022-09-30T18:35:39.206389+00:00 191491.0
exp_2022_09_30_10 200 leopard 193 1664562939.2113893 2022-09-30T18:35:39.211389+00:00 191483.0
exp_2022_09_30_10 200 leopard 194 1664562939.2163894 2022-09-30T18:35:39.216389+00:00 191475.0
exp_2022_09_30_10 200 leopard 195 1664562939.2213893 2022-09-30T18:35:39.221389+00:00 191467.0
exp_2022_09_30_10 200 leopard 196 1664562939.2263894 2022-09-30T18:35:39.226389+00:00 191458.0
exp_2022_09_30_10 200 leopard 197 1664562939.2313893 2022-09-30T18:35:39.231389+00:00 191450.0
exp_2022_09_30_10 200 leopard 198 1664562939.2363894 2022-09-30T18:35:39.236389+00:00 191442.0
exp_2022_09_30_10 200 leopard 199 1664562939.2413893 2022-09-30T18:35:39.241389+00:00 191434.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]);