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 = 100

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_2023_01_31_14 leopard 100 1011 rest_state 1675205893.7964 2023-01-31T22:58:13.796400+00:00 output001012.png modification
exp_2023_01_31_14 leopard 100 1012 rest_state 1675205894.0084085 2023-01-31T22:58:14.008409+00:00 output001013.png modification
exp_2023_01_31_14 leopard 100 1013 rest_state 1675205894.0804114 2023-01-31T22:58:14.080411+00:00 output001014.png modification
exp_2023_01_31_14 leopard 100 1014 rest_state 1675205894.1564145 2023-01-31T22:58:14.156415+00:00 output001015.png modification
exp_2023_01_31_14 leopard 100 1015 rest_state 1675205894.240418 2023-01-31T22:58:14.240418+00:00 output001016.png modification
exp_2023_01_31_14 leopard 100 1016 rest_state 1675205894.3244214 2023-01-31T22:58:14.324421+00:00 output001017.png modification
exp_2023_01_31_14 leopard 100 1017 rest_state 1675205894.4004245 2023-01-31T22:58:14.400424+00:00 output001018.png modification
exp_2023_01_31_14 leopard 100 1018 rest_state 1675205894.4764276 2023-01-31T22:58:14.476428+00:00 output001019.png modification
exp_2023_01_31_14 leopard 100 1019 rest_state 1675205894.592432 2023-01-31T22:58:14.592432+00:00 output001020.png modification
exp_2023_01_31_14 leopard 100 1020 rest_state 1675205894.668435 2023-01-31T22:58:14.668435+00:00 output001021.png modification
exp_2023_01_31_14 leopard 100 1021 rest_state 1675205894.7924402 2023-01-31T22:58:14.792440+00:00 output001022.png modification
exp_2023_01_31_14 leopard 100 1022 rest_state 1675205894.8764436 2023-01-31T22:58:14.876444+00:00 output001023.png modification
exp_2023_01_31_14 leopard 100 1023 rest_state 1675205894.9884481 2023-01-31T22:58:14.988448+00:00 output001024.png modification
exp_2023_01_31_14 leopard 100 1024 rest_state 1675205895.1204534 2023-01-31T22:58:15.120453+00:00 output001025.png modification
exp_2023_01_31_14 leopard 100 1025 rest_state 1675205895.208457 2023-01-31T22:58:15.208457+00:00 output001026.png modification
exp_2023_01_31_14 leopard 100 1026 rest_state 1675205895.2884603 2023-01-31T22:58:15.288460+00:00 output001027.png modification
exp_2023_01_31_14 leopard 100 1027 rest_state 1675205895.4404664 2023-01-31T22:58:15.440466+00:00 output001028.png modification
exp_2023_01_31_14 leopard 100 1028 rest_state 1675205895.5444705 2023-01-31T22:58:15.544471+00:00 output001029.png modification
exp_2023_01_31_14 leopard 100 1029 rest_state 1675205895.6444747 2023-01-31T22:58:15.644475+00:00 output001030.png modification
exp_2023_01_31_14 leopard 100 1030 rest_state 1675205895.7324781 2023-01-31T22:58:15.732478+00:00 output001031.png modification
exp_2023_01_31_14 leopard 100 1031 rest_state 1675205895.8364823 2023-01-31T22:58:15.836482+00:00 output001032.png modification
exp_2023_01_31_14 leopard 100 1032 rest_state 1675205895.9364865 2023-01-31T22:58:15.936486+00:00 output001033.png modification
exp_2023_01_31_14 leopard 100 1033 rest_state 1675205896.0164897 2023-01-31T22:58:16.016490+00:00 output001034.png modification
exp_2023_01_31_14 leopard 100 1034 rest_state 1675205896.120494 2023-01-31T22:58:16.120494+00:00 output001035.png modification
exp_2023_01_31_14 leopard 100 1035 rest_state 1675205896.224498 2023-01-31T22:58:16.224498+00:00 output001036.png modification
exp_2023_01_31_14 leopard 100 1036 rest_state 1675205896.320502 2023-01-31T22:58:16.320502+00:00 output001037.png modification
exp_2023_01_31_14 leopard 100 1037 rest_state 1675205896.4285064 2023-01-31T22:58:16.428506+00:00 output001038.png modification
exp_2023_01_31_14 leopard 100 1038 rest_state 1675205896.5325105 2023-01-31T22:58:16.532511+00:00 output001039.png modification
exp_2023_01_31_14 leopard 100 1039 rest_state 1675205896.6285143 2023-01-31T22:58:16.628514+00:00 output001040.png modification
exp_2023_01_31_14 leopard 100 1040 rest_state 1675205896.716518 2023-01-31T22:58:16.716518+00:00 output001041.png modification
exp_2023_01_31_14 leopard 100 1041 rest_state 1675205896.8165221 2023-01-31T22:58:16.816522+00:00 output001042.png modification
exp_2023_01_31_14 leopard 100 1042 rest_state 1675205896.9085257 2023-01-31T22:58:16.908526+00:00 output001043.png modification
exp_2023_01_31_14 leopard 100 1043 rest_state 1675205897.0125299 2023-01-31T22:58:17.012530+00:00 output001044.png modification
exp_2023_01_31_14 leopard 100 1044 rest_state 1675205897.092533 2023-01-31T22:58:17.092533+00:00 output001045.png modification
exp_2023_01_31_14 leopard 100 1045 rest_state 1675205897.2685404 2023-01-31T22:58:17.268540+00:00 output001046.png modification
exp_2023_01_31_14 leopard 100 1046 rest_state 1675205897.360544 2023-01-31T22:58:17.360544+00:00 output001047.png modification
exp_2023_01_31_14 leopard 100 1047 rest_state 1675205897.4525478 2023-01-31T22:58:17.452548+00:00 output001048.png modification
exp_2023_01_31_14 leopard 100 1048 rest_state 1675205897.5405512 2023-01-31T22:58:17.540551+00:00 output001049.png modification
exp_2023_01_31_14 leopard 100 1049 rest_state 1675205897.6285548 2023-01-31T22:58:17.628555+00:00 output001050.png modification
exp_2023_01_31_14 leopard 100 1050 rest_state 1675205897.7125583 2023-01-31T22:58:17.712558+00:00 output001051.png modification
exp_2023_01_31_14 leopard 100 1051 rest_state 1675205897.8125622 2023-01-31T22:58:17.812562+00:00 output001052.png modification
exp_2023_01_31_14 leopard 100 1052 rest_state 1675205897.9165664 2023-01-31T22:58:17.916566+00:00 output001053.png modification
exp_2023_01_31_14 leopard 100 1053 rest_state 1675205898.032571 2023-01-31T22:58:18.032571+00:00 output001054.png modification
exp_2023_01_31_14 leopard 100 1054 rest_state 1675205898.1365755 2023-01-31T22:58:18.136575+00:00 output001055.png modification
exp_2023_01_31_14 leopard 100 1055 rest_state 1675205898.2365794 2023-01-31T22:58:18.236579+00:00 output001056.png modification
exp_2023_01_31_14 leopard 100 1056 rest_state 1675205898.3365834 2023-01-31T22:58:18.336583+00:00 output001057.png modification
exp_2023_01_31_14 leopard 100 1057 rest_state 1675205898.4325874 2023-01-31T22:58:18.432587+00:00 output001058.png modification
exp_2023_01_31_14 leopard 100 1058 rest_state 1675205898.524591 2023-01-31T22:58:18.524591+00:00 output001059.png modification
exp_2023_01_31_14 leopard 100 1059 rest_state 1675205898.6125946 2023-01-31T22:58:18.612595+00:00 output001060.png modification
exp_2023_01_31_14 leopard 100 1060 rest_state 1675205898.7085984 2023-01-31T22:58:18.708598+00:00 output001061.png modification
exp_2023_01_31_14 leopard 100 1061 rest_state 1675205898.9046063 2023-01-31T22:58:18.904606+00:00 output001062.png modification
exp_2023_01_31_14 leopard 100 1062 rest_state 1675205899.020611 2023-01-31T22:58:19.020611+00:00 output001063.png modification
exp_2023_01_31_14 leopard 100 1063 rest_state 1675205899.1126149 2023-01-31T22:58:19.112615+00:00 output001064.png modification
exp_2023_01_31_14 leopard 100 1064 rest_state 1675205899.216619 2023-01-31T22:58:19.216619+00:00 output001065.png modification
exp_2023_01_31_14 leopard 100 1065 rest_state 1675205899.3046227 2023-01-31T22:58:19.304623+00:00 output001066.png modification
exp_2023_01_31_14 leopard 100 1066 rest_state 1675205899.4006264 2023-01-31T22:58:19.400626+00:00 output001067.png modification
exp_2023_01_31_14 leopard 100 1067 rest_state 1675205899.5006304 2023-01-31T22:58:19.500630+00:00 output001068.png modification
exp_2023_01_31_14 leopard 100 1068 rest_state 1675205899.5966344 2023-01-31T22:58:19.596634+00:00 output001069.png modification
exp_2023_01_31_14 leopard 100 1069 rest_state 1675205899.6966383 2023-01-31T22:58:19.696638+00:00 output001070.png modification
exp_2023_01_31_14 leopard 100 1070 rest_state 1675205899.7966423 2023-01-31T22:58:19.796642+00:00 output001071.png modification
exp_2023_01_31_14 leopard 100 1071 rest_state 1675205899.8966465 2023-01-31T22:58:19.896646+00:00 output001072.png modification
exp_2023_01_31_14 leopard 100 1072 rest_state 1675205899.98865 2023-01-31T22:58:19.988650+00:00 output001073.png modification
exp_2023_01_31_14 leopard 100 1073 rest_state 1675205900.080654 2023-01-31T22:58:20.080654+00:00 output001074.png modification
exp_2023_01_31_14 leopard 100 1074 rest_state 1675205900.184658 2023-01-31T22:58:20.184658+00:00 output001075.png modification
exp_2023_01_31_14 leopard 100 1075 rest_state 1675205900.2726617 2023-01-31T22:58:20.272662+00:00 output001076.png modification
exp_2023_01_31_14 leopard 100 1076 rest_state 1675205900.3646653 2023-01-31T22:58:20.364665+00:00 output001077.png modification
exp_2023_01_31_14 leopard 100 1077 rest_state 1675205900.4486687 2023-01-31T22:58:20.448669+00:00 output001078.png modification
exp_2023_01_31_14 leopard 100 1078 rest_state 1675205900.5446727 2023-01-31T22:58:20.544673+00:00 output001079.png modification
exp_2023_01_31_14 leopard 100 1079 rest_state 1675205900.6326761 2023-01-31T22:58:20.632676+00:00 output001080.png modification
exp_2023_01_31_14 leopard 100 1080 rest_state 1675205900.7286801 2023-01-31T22:58:20.728680+00:00 output001081.png modification
exp_2023_01_31_14 leopard 100 1081 rest_state 1675205900.828684 2023-01-31T22:58:20.828684+00:00 output001082.png modification
exp_2023_01_31_14 leopard 100 1082 rest_state 1675205900.924688 2023-01-31T22:58:20.924688+00:00 output001083.png modification
exp_2023_01_31_14 leopard 100 1083 rest_state 1675205901.0206919 2023-01-31T22:58:21.020692+00:00 output001084.png modification
exp_2023_01_31_14 leopard 100 1084 rest_state 1675205901.1166956 2023-01-31T22:58:21.116696+00:00 output001085.png modification
exp_2023_01_31_14 leopard 100 1085 rest_state 1675205901.2166998 2023-01-31T22:58:21.216700+00:00 output001086.png modification
exp_2023_01_31_14 leopard 100 1086 rest_state 1675205901.3087034 2023-01-31T22:58:21.308703+00:00 output001087.png modification
exp_2023_01_31_14 leopard 100 1087 rest_state 1675205901.4007072 2023-01-31T22:58:21.400707+00:00 output001088.png modification
exp_2023_01_31_14 leopard 100 1088 rest_state 1675205901.5807145 2023-01-31T22:58:21.580714+00:00 output001089.png modification
exp_2023_01_31_14 leopard 100 1089 rest_state 1675205901.6847186 2023-01-31T22:58:21.684719+00:00 output001090.png modification
exp_2023_01_31_14 leopard 100 1090 rest_state 1675205901.7807226 2023-01-31T22:58:21.780723+00:00 output001091.png modification
exp_2023_01_31_14 leopard 100 1091 rest_state 1675205901.8847268 2023-01-31T22:58:21.884727+00:00 output001092.png modification
exp_2023_01_31_14 leopard 100 1092 rest_state 1675205901.9767306 2023-01-31T22:58:21.976731+00:00 output001093.png modification
exp_2023_01_31_14 leopard 100 1093 rest_state 1675205902.064734 2023-01-31T22:58:22.064734+00:00 output001094.png modification
exp_2023_01_31_14 leopard 100 1094 rest_state 1675205902.1527376 2023-01-31T22:58:22.152738+00:00 output001095.png modification
exp_2023_01_31_14 leopard 100 1095 rest_state 1675205902.2327409 2023-01-31T22:58:22.232741+00:00 output001096.png modification
exp_2023_01_31_14 leopard 100 1096 rest_state 1675205902.3247445 2023-01-31T22:58:22.324744+00:00 output001097.png modification
exp_2023_01_31_14 leopard 100 1097 rest_state 1675205902.4167483 2023-01-31T22:58:22.416748+00:00 output001098.png modification
exp_2023_01_31_14 leopard 100 1098 rest_state 1675205902.512752 2023-01-31T22:58:22.512752+00:00 output001099.png modification
exp_2023_01_31_14 leopard 100 1099 rest_state 1675205902.6047559 2023-01-31T22:58:22.604756+00:00 output001100.png modification
exp_2023_01_31_14 leopard 100 1100 rest_state 1675205902.7367613 2023-01-31T22:58:22.736761+00:00 output001101.png modification
exp_2023_01_31_14 leopard 100 1101 rest_state 1675205902.8367653 2023-01-31T22:58:22.836765+00:00 output001102.png modification
exp_2023_01_31_14 leopard 100 1102 rest_state 1675205902.9167686 2023-01-31T22:58:22.916769+00:00 output001103.png modification
exp_2023_01_31_14 leopard 100 1103 rest_state 1675205903.0167725 2023-01-31T22:58:23.016773+00:00 output001104.png modification
exp_2023_01_31_14 leopard 100 1104 rest_state 1675205903.1167765 2023-01-31T22:58:23.116776+00:00 output001105.png modification
exp_2023_01_31_14 leopard 100 1105 rest_state 1675205903.2127805 2023-01-31T22:58:23.212780+00:00 output001106.png modification
exp_2023_01_31_14 leopard 100 1106 rest_state 1675205903.3167846 2023-01-31T22:58:23.316785+00:00 output001107.png modification
exp_2023_01_31_14 leopard 100 1107 rest_state 1675205903.4127886 2023-01-31T22:58:23.412789+00:00 output001108.png modification
exp_2023_01_31_14 leopard 100 1108 rest_state 1675205903.5607946 2023-01-31T22:58:23.560795+00:00 output001109.png modification
exp_2023_01_31_14 leopard 100 1109 rest_state 1675205903.6407979 2023-01-31T22:58:23.640798+00:00 output001110.png modification
exp_2023_01_31_14 leopard 100 1110 rest_state 1675205903.7368016 2023-01-31T22:58:23.736802+00:00 output001111.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]);