Column descriptions

group_session
Group session ID
task
Task ID.
station
The iMac that the participant was stationed at.
participant
Participant ID. A participant ID of -1 indicates an unknown participant. All rows that do not have values for the `task` column will have their participant ID set to -1. In the future, we will label some of these inter/pre/post task rows with the correct participant ID.
timestamp_unix
The Unix timestamp of the event.
timestamp_iso8601
The ISO-8601 timestamp of the event.
filename
Name of the screenshot file.
timestamp_origin
The source of the timestamp. The priority is precision-driven. LSL time are used if available, otherwise, creation time is used if available. Modification time is used as last resort.

where participant = 19

View and edit SQL

Suggested facets: task, timestamp_iso8601 (date)

Link group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin
exp_2022_09_30_10 leopard 19 1156 rest_state 1664562998.3261445 2022-09-30T18:36:38.326144+00:00 output001157.png modification
exp_2022_09_30_10 leopard 19 1157 rest_state 1664562998.4021475 2022-09-30T18:36:38.402148+00:00 output001158.png modification
exp_2022_09_30_10 leopard 19 1158 rest_state 1664562998.5261524 2022-09-30T18:36:38.526152+00:00 output001159.png modification
exp_2022_09_30_10 leopard 19 1159 rest_state 1664562998.618156 2022-09-30T18:36:38.618156+00:00 output001160.png modification
exp_2022_09_30_10 leopard 19 1160 rest_state 1664562998.7261603 2022-09-30T18:36:38.726160+00:00 output001161.png modification
exp_2022_09_30_10 leopard 19 1161 rest_state 1664562998.822164 2022-09-30T18:36:38.822164+00:00 output001162.png modification
exp_2022_09_30_10 leopard 19 1162 rest_state 1664562998.9021673 2022-09-30T18:36:38.902167+00:00 output001163.png modification
exp_2022_09_30_10 leopard 19 1163 rest_state 1664562999.022172 2022-09-30T18:36:39.022172+00:00 output001164.png modification
exp_2022_09_30_10 leopard 19 1164 rest_state 1664562999.122176 2022-09-30T18:36:39.122176+00:00 output001165.png modification
exp_2022_09_30_10 leopard 19 1165 rest_state 1664562999.2181797 2022-09-30T18:36:39.218180+00:00 output001166.png modification
exp_2022_09_30_10 leopard 19 1166 rest_state 1664562999.3221838 2022-09-30T18:36:39.322184+00:00 output001167.png modification
exp_2022_09_30_10 leopard 19 1167 rest_state 1664562999.4221878 2022-09-30T18:36:39.422188+00:00 output001168.png modification
exp_2022_09_30_10 leopard 19 1168 rest_state 1664562999.526192 2022-09-30T18:36:39.526192+00:00 output001169.png modification
exp_2022_09_30_10 leopard 19 1169 rest_state 1664562999.630196 2022-09-30T18:36:39.630196+00:00 output001170.png modification
exp_2022_09_30_10 leopard 19 1170 rest_state 1664562999.7301998 2022-09-30T18:36:39.730200+00:00 output001171.png modification
exp_2022_09_30_10 leopard 19 1171 rest_state 1664562999.8462045 2022-09-30T18:36:39.846205+00:00 output001172.png modification
exp_2022_09_30_10 leopard 19 1172 rest_state 1664562999.9222076 2022-09-30T18:36:39.922208+00:00 output001173.png modification
exp_2022_09_30_10 leopard 19 1173 rest_state 1664563000.0502126 2022-09-30T18:36:40.050213+00:00 output001174.png modification
exp_2022_09_30_10 leopard 19 1174 rest_state 1664563000.1302156 2022-09-30T18:36:40.130216+00:00 output001175.png modification
exp_2022_09_30_10 leopard 19 1175 rest_state 1664563000.2542207 2022-09-30T18:36:40.254221+00:00 output001176.png modification
exp_2022_09_30_10 leopard 19 1176 rest_state 1664563000.3302236 2022-09-30T18:36:40.330224+00:00 output001177.png modification
exp_2022_09_30_10 leopard 19 1177 rest_state 1664563000.4262273 2022-09-30T18:36:40.426227+00:00 output001178.png modification
exp_2022_09_30_10 leopard 19 1178 rest_state 1664563000.542232 2022-09-30T18:36:40.542232+00:00 output001179.png modification
exp_2022_09_30_10 leopard 19 1179 rest_state 1664563000.622235 2022-09-30T18:36:40.622235+00:00 output001180.png modification
exp_2022_09_30_10 leopard 19 1180 rest_state 1664563000.74224 2022-09-30T18:36:40.742240+00:00 output001181.png modification
exp_2022_09_30_10 leopard 19 1181 rest_state 1664563000.8302433 2022-09-30T18:36:40.830243+00:00 output001182.png modification
exp_2022_09_30_10 leopard 19 1182 rest_state 1664563000.946248 2022-09-30T18:36:40.946248+00:00 output001183.png modification
exp_2022_09_30_10 leopard 19 1183 rest_state 1664563001.0342515 2022-09-30T18:36:41.034251+00:00 output001184.png modification
exp_2022_09_30_10 leopard 19 1184 rest_state 1664563001.1062543 2022-09-30T18:36:41.106254+00:00 output001185.png modification
exp_2022_09_30_10 leopard 19 1185 rest_state 1664563001.226259 2022-09-30T18:36:41.226259+00:00 output001186.png modification
exp_2022_09_30_10 leopard 19 1186 rest_state 1664563001.3382635 2022-09-30T18:36:41.338264+00:00 output001187.png modification
exp_2022_09_30_10 leopard 19 1187 rest_state 1664563001.4182665 2022-09-30T18:36:41.418267+00:00 output001188.png modification
exp_2022_09_30_10 leopard 19 1188 rest_state 1664563001.5382712 2022-09-30T18:36:41.538271+00:00 output001189.png modification
exp_2022_09_30_10 leopard 19 1189 rest_state 1664563001.6662765 2022-09-30T18:36:41.666276+00:00 output001190.png modification
exp_2022_09_30_10 leopard 19 1190 rest_state 1664563001.7422793 2022-09-30T18:36:41.742279+00:00 output001191.png modification
exp_2022_09_30_10 leopard 19 1191 rest_state 1664563001.8262827 2022-09-30T18:36:41.826283+00:00 output001192.png modification
exp_2022_09_30_10 leopard 19 1192 rest_state 1664563001.9342868 2022-09-30T18:36:41.934287+00:00 output001193.png modification
exp_2022_09_30_10 leopard 19 1193 rest_state 1664563002.0702922 2022-09-30T18:36:42.070292+00:00 output001194.png modification
exp_2022_09_30_10 leopard 19 1194 rest_state 1664563002.162296 2022-09-30T18:36:42.162296+00:00 output001195.png modification
exp_2022_09_30_10 leopard 19 1195 rest_state 1664563002.242299 2022-09-30T18:36:42.242299+00:00 output001196.png modification
exp_2022_09_30_10 leopard 19 1196 rest_state 1664563002.3463032 2022-09-30T18:36:42.346303+00:00 output001197.png modification
exp_2022_09_30_10 leopard 19 1197 rest_state 1664563002.4263062 2022-09-30T18:36:42.426306+00:00 output001198.png modification
exp_2022_09_30_10 leopard 19 1198 rest_state 1664563002.542311 2022-09-30T18:36:42.542311+00:00 output001199.png modification
exp_2022_09_30_10 leopard 19 1199 rest_state 1664563002.6263142 2022-09-30T18:36:42.626314+00:00 output001200.png modification
exp_2022_09_30_10 leopard 19 1200 rest_state 1664563002.746319 2022-09-30T18:36:42.746319+00:00 output001201.png modification
exp_2022_09_30_10 leopard 19 1201 rest_state 1664563002.822322 2022-09-30T18:36:42.822322+00:00 output001202.png modification
exp_2022_09_30_10 leopard 19 1202 rest_state 1664563002.9383266 2022-09-30T18:36:42.938327+00:00 output001203.png modification
exp_2022_09_30_10 leopard 19 1203 rest_state 1664563003.0583313 2022-09-30T18:36:43.058331+00:00 output001204.png modification
exp_2022_09_30_10 leopard 19 1204 rest_state 1664563003.1383345 2022-09-30T18:36:43.138335+00:00 output001205.png modification
exp_2022_09_30_10 leopard 19 1205 rest_state 1664563003.254339 2022-09-30T18:36:43.254339+00:00 output001206.png modification
exp_2022_09_30_10 leopard 19 1206 rest_state 1664563003.3223417 2022-09-30T18:36:43.322342+00:00 output001207.png modification
exp_2022_09_30_10 leopard 19 1207 rest_state 1664563003.4423466 2022-09-30T18:36:43.442347+00:00 output001208.png modification
exp_2022_09_30_10 leopard 19 1208 rest_state 1664563003.5263498 2022-09-30T18:36:43.526350+00:00 output001209.png modification
exp_2022_09_30_10 leopard 19 1209 rest_state 1664563003.6503546 2022-09-30T18:36:43.650355+00:00 output001210.png modification
exp_2022_09_30_10 leopard 19 1210 rest_state 1664563003.7463584 2022-09-30T18:36:43.746358+00:00 output001211.png modification
exp_2022_09_30_10 leopard 19 1211 rest_state 1664563003.8663633 2022-09-30T18:36:43.866363+00:00 output001212.png modification
exp_2022_09_30_10 leopard 19 1212 rest_state 1664563003.9463663 2022-09-30T18:36:43.946366+00:00 output001213.png modification
exp_2022_09_30_10 leopard 19 1213 rest_state 1664563004.0743713 2022-09-30T18:36:44.074371+00:00 output001214.png modification
exp_2022_09_30_10 leopard 19 1214 rest_state 1664563004.142374 2022-09-30T18:36:44.142374+00:00 output001215.png modification
exp_2022_09_30_10 leopard 19 1215 rest_state 1664563004.218377 2022-09-30T18:36:44.218377+00:00 output001216.png modification
exp_2022_09_30_10 leopard 19 1216 rest_state 1664563004.3383818 2022-09-30T18:36:44.338382+00:00 output001217.png modification
exp_2022_09_30_10 leopard 19 1217 rest_state 1664563004.446386 2022-09-30T18:36:44.446386+00:00 output001218.png modification
exp_2022_09_30_10 leopard 19 1218 rest_state 1664563004.5303893 2022-09-30T18:36:44.530389+00:00 output001219.png modification
exp_2022_09_30_10 leopard 19 1219 rest_state 1664563004.6423938 2022-09-30T18:36:44.642394+00:00 output001220.png modification
exp_2022_09_30_10 leopard 19 1220 rest_state 1664563004.7703989 2022-09-30T18:36:44.770399+00:00 output001221.png modification
exp_2022_09_30_10 leopard 19 1221 rest_state 1664563004.846402 2022-09-30T18:36:44.846402+00:00 output001222.png modification
exp_2022_09_30_10 leopard 19 1222 rest_state 1664563004.9344053 2022-09-30T18:36:44.934405+00:00 output001223.png modification
exp_2022_09_30_10 leopard 19 1223 rest_state 1664563005.0544102 2022-09-30T18:36:45.054410+00:00 output001224.png modification
exp_2022_09_30_10 leopard 19 1224 rest_state 1664563005.1344132 2022-09-30T18:36:45.134413+00:00 output001225.png modification
exp_2022_09_30_10 leopard 19 1225 rest_state 1664563005.258418 2022-09-30T18:36:45.258418+00:00 output001226.png modification
exp_2022_09_30_10 leopard 19 1226 rest_state 1664563005.3424215 2022-09-30T18:36:45.342422+00:00 output001227.png modification
exp_2022_09_30_10 leopard 19 1227 rest_state 1664563005.4264247 2022-09-30T18:36:45.426425+00:00 output001228.png modification
exp_2022_09_30_10 leopard 19 1228 rest_state 1664563005.5504296 2022-09-30T18:36:45.550430+00:00 output001229.png modification
exp_2022_09_30_10 leopard 19 1229 rest_state 1664563005.6384332 2022-09-30T18:36:45.638433+00:00 output001230.png modification
exp_2022_09_30_10 leopard 19 1230 rest_state 1664563005.7544377 2022-09-30T18:36:45.754438+00:00 output001231.png modification
exp_2022_09_30_10 leopard 19 1231 rest_state 1664563005.8384411 2022-09-30T18:36:45.838441+00:00 output001232.png modification
exp_2022_09_30_10 leopard 19 1232 rest_state 1664563005.9064438 2022-09-30T18:36:45.906444+00:00 output001233.png modification
exp_2022_09_30_10 leopard 19 1233 rest_state 1664563006.0304487 2022-09-30T18:36:46.030449+00:00 output001234.png modification
exp_2022_09_30_10 leopard 19 1234 rest_state 1664563006.138453 2022-09-30T18:36:46.138453+00:00 output001235.png modification
exp_2022_09_30_10 leopard 19 1235 rest_state 1664563006.2504573 2022-09-30T18:36:46.250457+00:00 output001236.png modification
exp_2022_09_30_10 leopard 19 1236 rest_state 1664563006.3304605 2022-09-30T18:36:46.330461+00:00 output001237.png modification
exp_2022_09_30_10 leopard 19 1237 rest_state 1664563006.4624658 2022-09-30T18:36:46.462466+00:00 output001238.png modification
exp_2022_09_30_10 leopard 19 1238 rest_state 1664563006.5344687 2022-09-30T18:36:46.534469+00:00 output001239.png modification
exp_2022_09_30_10 leopard 19 1239 rest_state 1664563006.650473 2022-09-30T18:36:46.650473+00:00 output001240.png modification
exp_2022_09_30_10 leopard 19 1240 rest_state 1664563006.7264762 2022-09-30T18:36:46.726476+00:00 output001241.png modification
exp_2022_09_30_10 leopard 19 1241 rest_state 1664563006.8664815 2022-09-30T18:36:46.866482+00:00 output001242.png modification
exp_2022_09_30_10 leopard 19 1242 rest_state 1664563006.930484 2022-09-30T18:36:46.930484+00:00 output001243.png modification
exp_2022_09_30_10 leopard 19 1243 rest_state 1664563007.0704896 2022-09-30T18:36:47.070490+00:00 output001244.png modification
exp_2022_09_30_10 leopard 19 1244 rest_state 1664563007.150493 2022-09-30T18:36:47.150493+00:00 output001245.png modification
exp_2022_09_30_10 leopard 19 1245 rest_state 1664563007.2224958 2022-09-30T18:36:47.222496+00:00 output001246.png modification
exp_2022_09_30_10 leopard 19 1246 rest_state 1664563007.354501 2022-09-30T18:36:47.354501+00:00 output001247.png modification
exp_2022_09_30_10 leopard 19 1247 rest_state 1664563007.4425044 2022-09-30T18:36:47.442504+00:00 output001248.png modification
exp_2022_09_30_10 leopard 19 1248 rest_state 1664563007.5585089 2022-09-30T18:36:47.558509+00:00 output001249.png modification
exp_2022_09_30_10 leopard 19 1249 rest_state 1664563007.634512 2022-09-30T18:36:47.634512+00:00 output001250.png modification
exp_2022_09_30_10 leopard 19 1250 rest_state 1664563007.7665172 2022-09-30T18:36:47.766517+00:00 output001251.png modification
exp_2022_09_30_10 leopard 19 1251 rest_state 1664563007.8465204 2022-09-30T18:36:47.846520+00:00 output001252.png modification
exp_2022_09_30_10 leopard 19 1252 rest_state 1664563007.9265234 2022-09-30T18:36:47.926523+00:00 output001253.png modification
exp_2022_09_30_10 leopard 19 1253 rest_state 1664563008.0505283 2022-09-30T18:36:48.050528+00:00 output001254.png modification
exp_2022_09_30_10 leopard 19 1254 rest_state 1664563008.1305315 2022-09-30T18:36:48.130532+00:00 output001255.png modification
exp_2022_09_30_10 leopard 19 1255 rest_state 1664563008.2585366 2022-09-30T18:36:48.258537+00:00 output001256.png modification

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "screen_capture" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [station] TEXT REFERENCES [station]([id]),
   [participant] INTEGER REFERENCES [participant]([id]),
   [id] INTEGER,
   [task] TEXT REFERENCES [task]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [filename] TEXT,
   [url] TEXT,
   [timestamp_origin] TEXT,
   PRIMARY KEY ([group_session], [station], [participant], [id], [timestamp_unix])
);
CREATE INDEX [idx_screen_capture_task]
    ON [screen_capture] ([task]);
CREATE INDEX [idx_screen_capture_participant]
    ON [screen_capture] ([participant]);
CREATE INDEX [idx_screen_capture_station]
    ON [screen_capture] ([station]);
CREATE INDEX [idx_screen_capture_group_session]
    ON [screen_capture] ([group_session]);