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 = "-3"

- remove filter - group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

- column - group_session station participant id task timestamp_unix timestamp_iso8601 filename url timestamp_origin

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

Sort... Sort by group_session Sort by station Sort by participant Sort by id Sort by task Sort by timestamp_unix Sort by timestamp_iso8601 Sort by filename Sort by url Sort by timestamp_origin

descending

✎ View and edit SQL

This data as json, copyable

0 records

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