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

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_02_16_14 leopard 114 1011 rest_state 1676585623.545314 2023-02-16T22:13:43.545314+00:00 2023-02-16T22_13_43.545314537Z.png creation
exp_2023_02_16_14 leopard 114 1012 rest_state 1676585623.657318 2023-02-16T22:13:43.657318+00:00 2023-02-16T22_13_43.657318938Z.png creation
exp_2023_02_16_14 leopard 114 1013 rest_state 1676585623.761323 2023-02-16T22:13:43.761323+00:00 2023-02-16T22_13_43.761323022Z.png creation
exp_2023_02_16_14 leopard 114 1014 rest_state 1676585623.837326 2023-02-16T22:13:43.837326+00:00 2023-02-16T22_13_43.837326011Z.png creation
exp_2023_02_16_14 leopard 114 1015 rest_state 1676585623.933329 2023-02-16T22:13:43.933329+00:00 2023-02-16T22_13_43.933329781Z.png creation
exp_2023_02_16_14 leopard 114 1016 rest_state 1676585624.045334 2023-02-16T22:13:44.045334+00:00 2023-02-16T22_13_44.045334182Z.png creation
exp_2023_02_16_14 leopard 114 1017 rest_state 1676585624.157338 2023-02-16T22:13:44.157338+00:00 2023-02-16T22_13_44.157338586Z.png creation
exp_2023_02_16_14 leopard 114 1018 rest_state 1676585624.265342 2023-02-16T22:13:44.265342+00:00 2023-02-16T22_13_44.265342828Z.png creation
exp_2023_02_16_14 leopard 114 1019 rest_state 1676585624.337345 2023-02-16T22:13:44.337345+00:00 2023-02-16T22_13_44.337345659Z.png creation
exp_2023_02_16_14 leopard 114 1020 rest_state 1676585624.44935 2023-02-16T22:13:44.449350+00:00 2023-02-16T22_13_44.449350059Z.png creation
exp_2023_02_16_14 leopard 114 1021 rest_state 1676585624.529353 2023-02-16T22:13:44.529353+00:00 2023-02-16T22_13_44.529353204Z.png creation
exp_2023_02_16_14 leopard 114 1022 rest_state 1676585624.641357 2023-02-16T22:13:44.641357+00:00 2023-02-16T22_13_44.641357603Z.png creation
exp_2023_02_16_14 leopard 114 1023 rest_state 1676585624.749361 2023-02-16T22:13:44.749361+00:00 2023-02-16T22_13_44.749361846Z.png creation
exp_2023_02_16_14 leopard 114 1024 rest_state 1676585624.853365 2023-02-16T22:13:44.853365+00:00 2023-02-16T22_13_44.853365933Z.png creation
exp_2023_02_16_14 leopard 114 1025 rest_state 1676585624.96137 2023-02-16T22:13:44.961370+00:00 2023-02-16T22_13_44.961370180Z.png creation
exp_2023_02_16_14 leopard 114 1026 rest_state 1676585625.073374 2023-02-16T22:13:45.073374+00:00 2023-02-16T22_13_45.073374579Z.png creation
exp_2023_02_16_14 leopard 114 1027 rest_state 1676585625.161378 2023-02-16T22:13:45.161378+00:00 2023-02-16T22_13_45.161378037Z.png creation
exp_2023_02_16_14 leopard 114 1028 rest_state 1676585625.245381 2023-02-16T22:13:45.245381+00:00 2023-02-16T22_13_45.245381340Z.png creation
exp_2023_02_16_14 leopard 114 1029 rest_state 1676585625.385386 2023-02-16T22:13:45.385386+00:00 2023-02-16T22_13_45.385386839Z.png creation
exp_2023_02_16_14 leopard 114 1030 rest_state 1676585625.47739 2023-02-16T22:13:45.477390+00:00 2023-02-16T22_13_45.477390454Z.png creation
exp_2023_02_16_14 leopard 114 1031 rest_state 1676585625.565393 2023-02-16T22:13:45.565393+00:00 2023-02-16T22_13_45.565393915Z.png creation
exp_2023_02_16_14 leopard 114 1032 rest_state 1676585625.693398 2023-02-16T22:13:45.693398+00:00 2023-02-16T22_13_45.693398942Z.png creation
exp_2023_02_16_14 leopard 114 1033 rest_state 1676585625.777402 2023-02-16T22:13:45.777402+00:00 2023-02-16T22_13_45.777402245Z.png creation
exp_2023_02_16_14 leopard 114 1034 rest_state 1676585625.849405 2023-02-16T22:13:45.849405+00:00 2023-02-16T22_13_45.849405075Z.png creation
exp_2023_02_16_14 leopard 114 1035 rest_state 1676585625.98541 2023-02-16T22:13:45.985410+00:00 2023-02-16T22_13_45.985410419Z.png creation
exp_2023_02_16_14 leopard 114 1036 rest_state 1676585626.069413 2023-02-16T22:13:46.069413+00:00 2023-02-16T22_13_46.069413718Z.png creation
exp_2023_02_16_14 leopard 114 1037 rest_state 1676585626.173417 2023-02-16T22:13:46.173417+00:00 2023-02-16T22_13_46.173417805Z.png creation
exp_2023_02_16_14 leopard 114 1038 rest_state 1676585626.285422 2023-02-16T22:13:46.285422+00:00 2023-02-16T22_13_46.285422206Z.png creation
exp_2023_02_16_14 leopard 114 1039 rest_state 1676585626.381425 2023-02-16T22:13:46.381425+00:00 2023-02-16T22_13_46.381425981Z.png creation
exp_2023_02_16_14 leopard 114 1040 rest_state 1676585626.469429 2023-02-16T22:13:46.469429+00:00 2023-02-16T22_13_46.469429437Z.png creation
exp_2023_02_16_14 leopard 114 1041 rest_state 1676585626.553432 2023-02-16T22:13:46.553432+00:00 2023-02-16T22_13_46.553432740Z.png creation
exp_2023_02_16_14 leopard 114 1042 rest_state 1676585626.681437 2023-02-16T22:13:46.681437+00:00 2023-02-16T22_13_46.681437767Z.png creation
exp_2023_02_16_14 leopard 114 1043 rest_state 1676585626.793442 2023-02-16T22:13:46.793442+00:00 2023-02-16T22_13_46.793442168Z.png creation
exp_2023_02_16_14 leopard 114 1044 rest_state 1676585626.881445 2023-02-16T22:13:46.881445+00:00 2023-02-16T22_13_46.881445629Z.png creation
exp_2023_02_16_14 leopard 114 1045 rest_state 1676585626.973449 2023-02-16T22:13:46.973449+00:00 2023-02-16T22_13_46.973449244Z.png creation
exp_2023_02_16_14 leopard 114 1046 rest_state 1676585627.069453 2023-02-16T22:13:47.069453+00:00 2023-02-16T22_13_47.069453014Z.png creation
exp_2023_02_16_14 leopard 114 1047 rest_state 1676585627.145456 2023-02-16T22:13:47.145456+00:00 2023-02-16T22_13_47.145456000Z.png creation
exp_2023_02_16_14 leopard 114 1048 rest_state 1676585627.281461 2023-02-16T22:13:47.281461+00:00 2023-02-16T22_13_47.281461344Z.png creation
exp_2023_02_16_14 leopard 114 1049 rest_state 1676585627.373464 2023-02-16T22:13:47.373464+00:00 2023-02-16T22_13_47.373464960Z.png creation
exp_2023_02_16_14 leopard 114 1050 rest_state 1676585627.457468 2023-02-16T22:13:47.457468+00:00 2023-02-16T22_13_47.457468262Z.png creation
exp_2023_02_16_14 leopard 114 1051 rest_state 1676585627.589473 2023-02-16T22:13:47.589473+00:00 2023-02-16T22_13_47.589473448Z.png creation
exp_2023_02_16_14 leopard 114 1052 rest_state 1676585627.677476 2023-02-16T22:13:47.677476+00:00 2023-02-16T22_13_47.677476909Z.png creation
exp_2023_02_16_14 leopard 114 1053 rest_state 1676585627.77348 2023-02-16T22:13:47.773480+00:00 2023-02-16T22_13_47.773480679Z.png creation
exp_2023_02_16_14 leopard 114 1054 rest_state 1676585627.877484 2023-02-16T22:13:47.877484+00:00 2023-02-16T22_13_47.877484766Z.png creation
exp_2023_02_16_14 leopard 114 1055 rest_state 1676585627.997489 2023-02-16T22:13:47.997489+00:00 2023-02-16T22_13_47.997489481Z.png creation
exp_2023_02_16_14 leopard 114 1056 rest_state 1676585628.093493 2023-02-16T22:13:48.093493+00:00 2023-02-16T22_13_48.093493254Z.png creation
exp_2023_02_16_14 leopard 114 1057 rest_state 1676585628.185496 2023-02-16T22:13:48.185496+00:00 2023-02-16T22_13_48.185496871Z.png creation
exp_2023_02_16_14 leopard 114 1058 rest_state 1676585628.2655 2023-02-16T22:13:48.265500+00:00 2023-02-16T22_13_48.265500014Z.png creation
exp_2023_02_16_14 leopard 114 1059 rest_state 1676585628.365503 2023-02-16T22:13:48.365503+00:00 2023-02-16T22_13_48.365503942Z.png creation
exp_2023_02_16_14 leopard 114 1060 rest_state 1676585628.453507 2023-02-16T22:13:48.453507+00:00 2023-02-16T22_13_48.453507400Z.png creation
exp_2023_02_16_14 leopard 114 1061 rest_state 1676585628.585512 2023-02-16T22:13:48.585512+00:00 2023-02-16T22_13_48.585512590Z.png creation
exp_2023_02_16_14 leopard 114 1062 rest_state 1676585628.685516 2023-02-16T22:13:48.685516+00:00 2023-02-16T22_13_48.685516519Z.png creation
exp_2023_02_16_14 leopard 114 1063 rest_state 1676585628.77752 2023-02-16T22:13:48.777520+00:00 2023-02-16T22_13_48.777520134Z.png creation
exp_2023_02_16_14 leopard 114 1064 rest_state 1676585628.865523 2023-02-16T22:13:48.865523+00:00 2023-02-16T22_13_48.865523591Z.png creation
exp_2023_02_16_14 leopard 114 1065 rest_state 1676585628.965527 2023-02-16T22:13:48.965527+00:00 2023-02-16T22_13_48.965527520Z.png creation
exp_2023_02_16_14 leopard 114 1066 rest_state 1676585629.069531 2023-02-16T22:13:49.069531+00:00 2023-02-16T22_13_49.069531607Z.png creation
exp_2023_02_16_14 leopard 114 1067 rest_state 1676585629.161535 2023-02-16T22:13:49.161535+00:00 2023-02-16T22_13_49.161535222Z.png creation
exp_2023_02_16_14 leopard 114 1068 rest_state 1676585629.253538 2023-02-16T22:13:49.253538+00:00 2023-02-16T22_13_49.253538839Z.png creation
exp_2023_02_16_14 leopard 114 1069 rest_state 1676585629.385544 2023-02-16T22:13:49.385544+00:00 2023-02-16T22_13_49.385544024Z.png creation
exp_2023_02_16_14 leopard 114 1070 rest_state 1676585629.473547 2023-02-16T22:13:49.473547+00:00 2023-02-16T22_13_49.473547482Z.png creation
exp_2023_02_16_14 leopard 114 1071 rest_state 1676585629.56155 2023-02-16T22:13:49.561550+00:00 2023-02-16T22_13_49.561550943Z.png creation
exp_2023_02_16_14 leopard 114 1072 rest_state 1676585629.649554 2023-02-16T22:13:49.649554+00:00 2023-02-16T22_13_49.649554399Z.png creation
exp_2023_02_16_14 leopard 114 1073 rest_state 1676585629.79756 2023-02-16T22:13:49.797560+00:00 2023-02-16T22_13_49.797560215Z.png creation
exp_2023_02_16_14 leopard 114 1074 rest_state 1676585629.889563 2023-02-16T22:13:49.889563+00:00 2023-02-16T22_13_49.889563830Z.png creation
exp_2023_02_16_14 leopard 114 1075 rest_state 1676585629.985567 2023-02-16T22:13:49.985567+00:00 2023-02-16T22_13_49.985567602Z.png creation
exp_2023_02_16_14 leopard 114 1076 rest_state 1676585630.06557 2023-02-16T22:13:50.065570+00:00 2023-02-16T22_13_50.065570746Z.png creation
exp_2023_02_16_14 leopard 114 1077 rest_state 1676585630.165574 2023-02-16T22:13:50.165574+00:00 2023-02-16T22_13_50.165574678Z.png creation
exp_2023_02_16_14 leopard 114 1078 rest_state 1676585630.289579 2023-02-16T22:13:50.289579+00:00 2023-02-16T22_13_50.289579551Z.png creation
exp_2023_02_16_14 leopard 114 1079 rest_state 1676585630.381583 2023-02-16T22:13:50.381583+00:00 2023-02-16T22_13_50.381583166Z.png creation
exp_2023_02_16_14 leopard 114 1080 rest_state 1676585630.461586 2023-02-16T22:13:50.461586+00:00 2023-02-16T22_13_50.461586310Z.png creation
exp_2023_02_16_14 leopard 114 1081 rest_state 1676585630.593591 2023-02-16T22:13:50.593591+00:00 2023-02-16T22_13_50.593591495Z.png creation
exp_2023_02_16_14 leopard 114 1082 rest_state 1676585630.669594 2023-02-16T22:13:50.669594+00:00 2023-02-16T22_13_50.669594481Z.png creation
exp_2023_02_16_14 leopard 114 1083 rest_state 1676585630.773598 2023-02-16T22:13:50.773598+00:00 2023-02-16T22_13_50.773598568Z.png creation
exp_2023_02_16_14 leopard 114 1084 rest_state 1676585630.857601 2023-02-16T22:13:50.857601+00:00 2023-02-16T22_13_50.857601871Z.png creation
exp_2023_02_16_14 leopard 114 1085 rest_state 1676585630.997607 2023-02-16T22:13:50.997607+00:00 2023-02-16T22_13_50.997607370Z.png creation
exp_2023_02_16_14 leopard 114 1086 rest_state 1676585631.093611 2023-02-16T22:13:51.093611+00:00 2023-02-16T22_13_51.093611143Z.png creation
exp_2023_02_16_14 leopard 114 1087 rest_state 1676585631.189614 2023-02-16T22:13:51.189614+00:00 2023-02-16T22_13_51.189614918Z.png creation
exp_2023_02_16_14 leopard 114 1088 rest_state 1676585631.277618 2023-02-16T22:13:51.277618+00:00 2023-02-16T22_13_51.277618375Z.png creation
exp_2023_02_16_14 leopard 114 1089 rest_state 1676585631.357621 2023-02-16T22:13:51.357621+00:00 2023-02-16T22_13_51.357621519Z.png creation
exp_2023_02_16_14 leopard 114 1090 rest_state 1676585631.485626 2023-02-16T22:13:51.485626+00:00 2023-02-16T22_13_51.485626549Z.png creation
exp_2023_02_16_14 leopard 114 1091 rest_state 1676585631.58963 2023-02-16T22:13:51.589630+00:00 2023-02-16T22_13_51.589630633Z.png creation
exp_2023_02_16_14 leopard 114 1092 rest_state 1676585631.669633 2023-02-16T22:13:51.669633+00:00 2023-02-16T22_13_51.669633777Z.png creation
exp_2023_02_16_14 leopard 114 1093 rest_state 1676585631.797638 2023-02-16T22:13:51.797638+00:00 2023-02-16T22_13_51.797638808Z.png creation
exp_2023_02_16_14 leopard 114 1094 rest_state 1676585631.881642 2023-02-16T22:13:51.881642+00:00 2023-02-16T22_13_51.881642110Z.png creation
exp_2023_02_16_14 leopard 114 1095 rest_state 1676585631.977645 2023-02-16T22:13:51.977645+00:00 2023-02-16T22_13_51.977645881Z.png creation
exp_2023_02_16_14 leopard 114 1096 rest_state 1676585632.081649 2023-02-16T22:13:52.081649+00:00 2023-02-16T22_13_52.081649968Z.png creation
exp_2023_02_16_14 leopard 114 1097 rest_state 1676585632.157652 2023-02-16T22:13:52.157652+00:00 2023-02-16T22_13_52.157652954Z.png creation
exp_2023_02_16_14 leopard 114 1098 rest_state 1676585632.289658 2023-02-16T22:13:52.289658+00:00 2023-02-16T22_13_52.289658143Z.png creation
exp_2023_02_16_14 leopard 114 1099 rest_state 1676585632.36166 2023-02-16T22:13:52.361660+00:00 2023-02-16T22_13_52.361660973Z.png creation
exp_2023_02_16_14 leopard 114 1100 rest_state 1676585632.457664 2023-02-16T22:13:52.457664+00:00 2023-02-16T22_13_52.457664743Z.png creation
exp_2023_02_16_14 leopard 114 1101 rest_state 1676585632.581669 2023-02-16T22:13:52.581669+00:00 2023-02-16T22_13_52.581669616Z.png creation
exp_2023_02_16_14 leopard 114 1102 rest_state 1676585632.661672 2023-02-16T22:13:52.661672+00:00 2023-02-16T22_13_52.661672760Z.png creation
exp_2023_02_16_14 leopard 114 1103 rest_state 1676585632.785677 2023-02-16T22:13:52.785677+00:00 2023-02-16T22_13_52.785677632Z.png creation
exp_2023_02_16_14 leopard 114 1104 rest_state 1676585632.86568 2023-02-16T22:13:52.865680+00:00 2023-02-16T22_13_52.865680776Z.png creation
exp_2023_02_16_14 leopard 114 1105 rest_state 1676585632.997685 2023-02-16T22:13:52.997685+00:00 2023-02-16T22_13_52.997685966Z.png creation
exp_2023_02_16_14 leopard 114 1106 rest_state 1676585633.085689 2023-02-16T22:13:53.085689+00:00 2023-02-16T22_13_53.085689422Z.png creation
exp_2023_02_16_14 leopard 114 1107 rest_state 1676585633.173692 2023-02-16T22:13:53.173692+00:00 2023-02-16T22_13_53.173692880Z.png creation
exp_2023_02_16_14 leopard 114 1108 rest_state 1676585633.257696 2023-02-16T22:13:53.257696+00:00 2023-02-16T22_13_53.257696182Z.png creation
exp_2023_02_16_14 leopard 114 1109 rest_state 1676585633.389701 2023-02-16T22:13:53.389701+00:00 2023-02-16T22_13_53.389701368Z.png creation
exp_2023_02_16_14 leopard 114 1110 rest_state 1676585633.489705 2023-02-16T22:13:53.489705+00:00 2023-02-16T22_13_53.489705297Z.png creation

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