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 group_session = "exp_2022_12_05_12"

View and edit SQL

Suggested facets: station, timestamp_iso8601 (date)

Link group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin
exp_2022_12_05_12 leopard 99908 4892 finger_tapping 1670271566.405027 2022-12-05T20:19:26.405027+00:00 2022-12-05T20_19_26.405027981Z.png creation
exp_2022_12_05_12 leopard 99908 4893 finger_tapping 1670271566.513032 2022-12-05T20:19:26.513032+00:00 2022-12-05T20_19_26.513032151Z.png creation
exp_2022_12_05_12 leopard 99908 4894 finger_tapping 1670271566.633036 2022-12-05T20:19:26.633036+00:00 2022-12-05T20_19_26.633036787Z.png creation
exp_2022_12_05_12 leopard 99908 4895 finger_tapping 1670271566.709039 2022-12-05T20:19:26.709039+00:00 2022-12-05T20_19_26.709039723Z.png creation
exp_2022_12_05_12 leopard 99908 4896 finger_tapping 1670271566.825044 2022-12-05T20:19:26.825044+00:00 2022-12-05T20_19_26.825044204Z.png creation
exp_2022_12_05_12 leopard 99908 4897 finger_tapping 1670271566.933048 2022-12-05T20:19:26.933048+00:00 2022-12-05T20_19_26.933048374Z.png creation
exp_2022_12_05_12 leopard 99908 4898 finger_tapping 1670271567.045052 2022-12-05T20:19:27.045052+00:00 2022-12-05T20_19_27.045052698Z.png creation
exp_2022_12_05_12 leopard 99908 4899 finger_tapping 1670271567.105055 2022-12-05T20:19:27.105055+00:00 2022-12-05T20_19_27.105055017Z.png creation
exp_2022_12_05_12 leopard 99908 4900 finger_tapping 1670271567.201058 2022-12-05T20:19:27.201058+00:00 2022-12-05T20_19_27.201058725Z.png creation
exp_2022_12_05_12 leopard 99908 4901 finger_tapping 1670271567.313063 2022-12-05T20:19:27.313063+00:00 2022-12-05T20_19_27.313063052Z.png creation
exp_2022_12_05_12 leopard 99908 4902 finger_tapping 1670271567.433067 2022-12-05T20:19:27.433067+00:00 2022-12-05T20_19_27.433067683Z.png creation
exp_2022_12_05_12 leopard 99908 4903 finger_tapping 1670271567.50507 2022-12-05T20:19:27.505070+00:00 2022-12-05T20_19_27.505070466Z.png creation
exp_2022_12_05_12 leopard 99908 4904 finger_tapping 1670271567.637075 2022-12-05T20:19:27.637075+00:00 2022-12-05T20_19_27.637075562Z.png creation
exp_2022_12_05_12 leopard 99908 4905 finger_tapping 1670271567.725078 2022-12-05T20:19:27.725078+00:00 2022-12-05T20_19_27.725078964Z.png creation
exp_2022_12_05_12 leopard 99908 4906 finger_tapping 1670271567.801081 2022-12-05T20:19:27.801081+00:00 2022-12-05T20_19_27.801081900Z.png creation
exp_2022_12_05_12 leopard 99908 4907 finger_tapping 1670271567.925086 2022-12-05T20:19:27.925086+00:00 2022-12-05T20_19_27.925086689Z.png creation
exp_2022_12_05_12 leopard 99908 4908 finger_tapping 1670271568.02109 2022-12-05T20:19:28.021090+00:00 2022-12-05T20_19_28.021090394Z.png creation
exp_2022_12_05_12 leopard 99908 4909 finger_tapping 1670271568.133094 2022-12-05T20:19:28.133094+00:00 2022-12-05T20_19_28.133094722Z.png creation
exp_2022_12_05_12 leopard 99908 4910 finger_tapping 1670271568.217097 2022-12-05T20:19:28.217097+00:00 2022-12-05T20_19_28.217097966Z.png creation
exp_2022_12_05_12 leopard 99908 4911 finger_tapping 1670271568.333102 2022-12-05T20:19:28.333102+00:00 2022-12-05T20_19_28.333102447Z.png creation
exp_2022_12_05_12 leopard 99908 4912 finger_tapping 1670271568.413105 2022-12-05T20:19:28.413105+00:00 2022-12-05T20_19_28.413105537Z.png creation
exp_2022_12_05_12 leopard 99908 4913 finger_tapping 1670271568.53311 2022-12-05T20:19:28.533110+00:00 2022-12-05T20_19_28.533110172Z.png creation
exp_2022_12_05_12 leopard 99908 4914 finger_tapping 1670271568.645114 2022-12-05T20:19:28.645114+00:00 2022-12-05T20_19_28.645114498Z.png creation
exp_2022_12_05_12 leopard 99908 4915 finger_tapping 1670271568.749118 2022-12-05T20:19:28.749118+00:00 2022-12-05T20_19_28.749118515Z.png creation
exp_2022_12_05_12 leopard 99908 4916 finger_tapping 1670271568.80912 2022-12-05T20:19:28.809120+00:00 2022-12-05T20_19_28.809120832Z.png creation
exp_2022_12_05_12 leopard 99908 4917 finger_tapping 1670271568.933125 2022-12-05T20:19:28.933125+00:00 2022-12-05T20_19_28.933125621Z.png creation
exp_2022_12_05_12 leopard 99908 4918 finger_tapping 1670271569.045129 2022-12-05T20:19:29.045129+00:00 2022-12-05T20_19_29.045129948Z.png creation
exp_2022_12_05_12 leopard 99908 4919 finger_tapping 1670271569.153134 2022-12-05T20:19:29.153134+00:00 2022-12-05T20_19_29.153134119Z.png creation
exp_2022_12_05_12 leopard 99908 4920 finger_tapping 1670271569.209136 2022-12-05T20:19:29.209136+00:00 2022-12-05T20_19_29.209136282Z.png creation
exp_2022_12_05_12 leopard 99908 4921 finger_tapping 1670271569.337141 2022-12-05T20:19:29.337141+00:00 2022-12-05T20_19_29.337141224Z.png creation
exp_2022_12_05_12 leopard 99908 4922 finger_tapping 1670271569.417144 2022-12-05T20:19:29.417144+00:00 2022-12-05T20_19_29.417144314Z.png creation
exp_2022_12_05_12 leopard 99908 4923 finger_tapping 1670271569.545149 2022-12-05T20:19:29.545149+00:00 2022-12-05T20_19_29.545149260Z.png creation
exp_2022_12_05_12 leopard 99908 4924 finger_tapping 1670271569.617152 2022-12-05T20:19:29.617152+00:00 2022-12-05T20_19_29.617152042Z.png creation
exp_2022_12_05_12 leopard 99908 4925 finger_tapping 1670271569.737156 2022-12-05T20:19:29.737156+00:00 2022-12-05T20_19_29.737156677Z.png creation
exp_2022_12_05_12 leopard 99908 4926 finger_tapping 1670271569.817159 2022-12-05T20:19:29.817159+00:00 2022-12-05T20_19_29.817159767Z.png creation
exp_2022_12_05_12 leopard 99908 4927 finger_tapping 1670271569.933164 2022-12-05T20:19:29.933164+00:00 2022-12-05T20_19_29.933164248Z.png creation
exp_2022_12_05_12 leopard 99908 4928 finger_tapping 1670271570.049168 2022-12-05T20:19:30.049168+00:00 2022-12-05T20_19_30.049168725Z.png creation
exp_2022_12_05_12 leopard 99908 4929 finger_tapping 1670271570.153172 2022-12-05T20:19:30.153172+00:00 2022-12-05T20_19_30.153172745Z.png creation
exp_2022_12_05_12 leopard 99908 4930 finger_tapping 1670271570.225175 2022-12-05T20:19:30.225175+00:00 2022-12-05T20_19_30.225175524Z.png creation
exp_2022_12_05_12 leopard 99908 4931 finger_tapping 1670271570.34118 2022-12-05T20:19:30.341180+00:00 2022-12-05T20_19_30.341180004Z.png creation
exp_2022_12_05_12 leopard 99908 4932 finger_tapping 1670271570.417182 2022-12-05T20:19:30.417182+00:00 2022-12-05T20_19_30.417182940Z.png creation
exp_2022_12_05_12 leopard 99908 4933 finger_tapping 1670271570.545187 2022-12-05T20:19:30.545187+00:00 2022-12-05T20_19_30.545187887Z.png creation
exp_2022_12_05_12 leopard 99908 4934 finger_tapping 1670271570.61719 2022-12-05T20:19:30.617190+00:00 2022-12-05T20_19_30.617190668Z.png creation
exp_2022_12_05_12 leopard 99908 4935 finger_tapping 1670271570.733195 2022-12-05T20:19:30.733195+00:00 2022-12-05T20_19_30.733195149Z.png creation
exp_2022_12_05_12 leopard 99908 4936 finger_tapping 1670271570.853199 2022-12-05T20:19:30.853199+00:00 2022-12-05T20_19_30.853199784Z.png creation
exp_2022_12_05_12 leopard 99908 4937 finger_tapping 1670271570.921202 2022-12-05T20:19:30.921202+00:00 2022-12-05T20_19_30.921202410Z.png creation
exp_2022_12_05_12 leopard 99908 4938 finger_tapping 1670271571.029206 2022-12-05T20:19:31.029206+00:00 2022-12-05T20_19_31.029206582Z.png creation
exp_2022_12_05_12 leopard 99908 4939 finger_tapping 1670271571.14121 2022-12-05T20:19:31.141210+00:00 2022-12-05T20_19_31.141210909Z.png creation
exp_2022_12_05_12 leopard 99908 4940 finger_tapping 1670271571.249215 2022-12-05T20:19:31.249215+00:00 2022-12-05T20_19_31.249215080Z.png creation
exp_2022_12_05_12 leopard 99908 4941 finger_tapping 1670271571.353219 2022-12-05T20:19:31.353219+00:00 2022-12-05T20_19_31.353219098Z.png creation
exp_2022_12_05_12 leopard 99908 4942 finger_tapping 1670271571.445222 2022-12-05T20:19:31.445222+00:00 2022-12-05T20_19_31.445222649Z.png creation
exp_2022_12_05_12 leopard 99908 4943 finger_tapping 1670271571.513225 2022-12-05T20:19:31.513225+00:00 2022-12-05T20_19_31.513225278Z.png creation
exp_2022_12_05_12 leopard 99908 4944 finger_tapping 1670271571.621229 2022-12-05T20:19:31.621229+00:00 2022-12-05T20_19_31.621229447Z.png creation
exp_2022_12_05_12 leopard 99908 4945 finger_tapping 1670271571.749234 2022-12-05T20:19:31.749234+00:00 2022-12-05T20_19_31.749234394Z.png creation
exp_2022_12_05_12 leopard 99908 4946 finger_tapping 1670271571.817237 2022-12-05T20:19:31.817237+00:00 2022-12-05T20_19_31.817237021Z.png creation
exp_2022_12_05_12 leopard 99908 4947 finger_tapping 1670271571.933241 2022-12-05T20:19:31.933241+00:00 2022-12-05T20_19_31.933241502Z.png creation
exp_2022_12_05_12 leopard 99908 4948 finger_tapping 1670271572.037245 2022-12-05T20:19:32.037245+00:00 2022-12-05T20_19_32.037245519Z.png creation
exp_2022_12_05_12 leopard 99908 4949 finger_tapping 1670271572.125248 2022-12-05T20:19:32.125248+00:00 2022-12-05T20_19_32.125248919Z.png creation
exp_2022_12_05_12 leopard 99908 4950 finger_tapping 1670271572.249253 2022-12-05T20:19:32.249253+00:00 2022-12-05T20_19_32.249253708Z.png creation
exp_2022_12_05_12 leopard 99908 4951 finger_tapping 1670271572.313256 2022-12-05T20:19:32.313256+00:00 2022-12-05T20_19_32.313256181Z.png creation
exp_2022_12_05_12 leopard 99908 4952 finger_tapping 1670271572.42526 2022-12-05T20:19:32.425260+00:00 2022-12-05T20_19_32.425260508Z.png creation
exp_2022_12_05_12 leopard 99908 4953 finger_tapping 1670271572.545265 2022-12-05T20:19:32.545265+00:00 2022-12-05T20_19_32.545265143Z.png creation
exp_2022_12_05_12 leopard 99908 4954 finger_tapping 1670271572.617267 2022-12-05T20:19:32.617267+00:00 2022-12-05T20_19_32.617267925Z.png creation
exp_2022_12_05_12 leopard 99908 4955 finger_tapping 1670271572.737272 2022-12-05T20:19:32.737272+00:00 2022-12-05T20_19_32.737272560Z.png creation
exp_2022_12_05_12 leopard 99908 4956 finger_tapping 1670271572.813275 2022-12-05T20:19:32.813275+00:00 2022-12-05T20_19_32.813275495Z.png creation
exp_2022_12_05_12 leopard 99908 4957 finger_tapping 1670271572.94128 2022-12-05T20:19:32.941280+00:00 2022-12-05T20_19_32.941280440Z.png creation
exp_2022_12_05_12 leopard 99908 4958 finger_tapping 1670271573.025283 2022-12-05T20:19:33.025283+00:00 2022-12-05T20_19_33.025283684Z.png creation
exp_2022_12_05_12 leopard 99908 4959 finger_tapping 1670271573.145288 2022-12-05T20:19:33.145288+00:00 2022-12-05T20_19_33.145288321Z.png creation
exp_2022_12_05_12 leopard 99908 4960 finger_tapping 1670271573.249292 2022-12-05T20:19:33.249292+00:00 2022-12-05T20_19_33.249292338Z.png creation
exp_2022_12_05_12 leopard 99908 4961 finger_tapping 1670271573.313294 2022-12-05T20:19:33.313294+00:00 2022-12-05T20_19_33.313294808Z.png creation
exp_2022_12_05_12 leopard 99908 4962 finger_tapping 1670271573.425299 2022-12-05T20:19:33.425299+00:00 2022-12-05T20_19_33.425299135Z.png creation
exp_2022_12_05_12 leopard 99908 4963 finger_tapping 1670271573.545303 2022-12-05T20:19:33.545303+00:00 2022-12-05T20_19_33.545303773Z.png creation
exp_2022_12_05_12 leopard 99908 4964 finger_tapping 1670271573.621306 2022-12-05T20:19:33.621306+00:00 2022-12-05T20_19_33.621306709Z.png creation
exp_2022_12_05_12 leopard 99908 4965 finger_tapping 1670271573.737311 2022-12-05T20:19:33.737311+00:00 2022-12-05T20_19_33.737311190Z.png creation
exp_2022_12_05_12 leopard 99908 4966 finger_tapping 1670271573.849315 2022-12-05T20:19:33.849315+00:00 2022-12-05T20_19_33.849315516Z.png creation
exp_2022_12_05_12 leopard 99908 4967 finger_tapping 1670271573.949319 2022-12-05T20:19:33.949319+00:00 2022-12-05T20_19_33.949319377Z.png creation
exp_2022_12_05_12 leopard 99908 4968 finger_tapping 1670271574.029322 2022-12-05T20:19:34.029322+00:00 2022-12-05T20_19_34.029322470Z.png creation
exp_2022_12_05_12 leopard 99908 4969 finger_tapping 1670271574.133326 2022-12-05T20:19:34.133326+00:00 2022-12-05T20_19_34.133326486Z.png creation
exp_2022_12_05_12 leopard 99908 4970 finger_tapping 1670271574.24933 2022-12-05T20:19:34.249330+00:00 2022-12-05T20_19_34.249330970Z.png creation
exp_2022_12_05_12 leopard 99908 4971 finger_tapping 1670271574.353334 2022-12-05T20:19:34.353334+00:00 2022-12-05T20_19_34.353334986Z.png creation
exp_2022_12_05_12 leopard 99908 4972 finger_tapping 1670271574.457339 2022-12-05T20:19:34.457339+00:00 2022-12-05T20_19_34.457339005Z.png creation
exp_2022_12_05_12 leopard 99908 4973 finger_tapping 1670271574.525341 2022-12-05T20:19:34.525341+00:00 2022-12-05T20_19_34.525341629Z.png creation
exp_2022_12_05_12 leopard 99908 4974 finger_tapping 1670271574.641346 2022-12-05T20:19:34.641346+00:00 2022-12-05T20_19_34.641346113Z.png creation
exp_2022_12_05_12 leopard 99908 4975 finger_tapping 1670271574.74535 2022-12-05T20:19:34.745350+00:00 2022-12-05T20_19_34.745350128Z.png creation
exp_2022_12_05_12 leopard 99908 4976 finger_tapping 1670271574.821353 2022-12-05T20:19:34.821353+00:00 2022-12-05T20_19_34.821353064Z.png creation
exp_2022_12_05_12 leopard 99908 4977 finger_tapping 1670271574.945357 2022-12-05T20:19:34.945357+00:00 2022-12-05T20_19_34.945357856Z.png creation
exp_2022_12_05_12 leopard 99908 4978 finger_tapping 1670271575.029361 2022-12-05T20:19:35.029361+00:00 2022-12-05T20_19_35.029361102Z.png creation
exp_2022_12_05_12 leopard 99908 4979 finger_tapping 1670271575.149365 2022-12-05T20:19:35.149365+00:00 2022-12-05T20_19_35.149365737Z.png creation
exp_2022_12_05_12 leopard 99908 4980 finger_tapping 1670271575.257369 2022-12-05T20:19:35.257369+00:00 2022-12-05T20_19_35.257369910Z.png creation
exp_2022_12_05_12 leopard 99908 4981 finger_tapping 1670271575.317372 2022-12-05T20:19:35.317372+00:00 2022-12-05T20_19_35.317372226Z.png creation
exp_2022_12_05_12 leopard 99908 4982 finger_tapping 1670271575.433376 2022-12-05T20:19:35.433376+00:00 2022-12-05T20_19_35.433376710Z.png creation
exp_2022_12_05_12 leopard 99908 4983 finger_tapping 1670271575.549381 2022-12-05T20:19:35.549381+00:00 2022-12-05T20_19_35.549381191Z.png creation
exp_2022_12_05_12 leopard 99908 4984 finger_tapping 1670271575.613383 2022-12-05T20:19:35.613383+00:00 2022-12-05T20_19_35.613383664Z.png creation
exp_2022_12_05_12 leopard 99908 4985 finger_tapping 1670271575.729388 2022-12-05T20:19:35.729388+00:00 2022-12-05T20_19_35.729388145Z.png creation
exp_2022_12_05_12 leopard 99908 4986 finger_tapping 1670271575.841392 2022-12-05T20:19:35.841392+00:00 2022-12-05T20_19_35.841392472Z.png creation
exp_2022_12_05_12 leopard 99908 4987 finger_tapping 1670271575.953396 2022-12-05T20:19:35.953396+00:00 2022-12-05T20_19_35.953396798Z.png creation
exp_2022_12_05_12 leopard 99908 4988 finger_tapping 1670271576.017399 2022-12-05T20:19:36.017399+00:00 2022-12-05T20_19_36.017399272Z.png creation
exp_2022_12_05_12 leopard 99908 4989 finger_tapping 1670271576.137403 2022-12-05T20:19:36.137403+00:00 2022-12-05T20_19_36.137403906Z.png creation
exp_2022_12_05_12 leopard 99908 4990 finger_tapping 1670271576.221407 2022-12-05T20:19:36.221407+00:00 2022-12-05T20_19_36.221407153Z.png creation
exp_2022_12_05_12 leopard 99908 4991 finger_tapping 1670271576.337411 2022-12-05T20:19:36.337411+00:00 2022-12-05T20_19_36.337411632Z.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]);