data_validity

Table with information about which participants were involved in the tasks, and whether the data from the EEG, fNIRS, and eye tracking modalities are valid. In most cases, when an experimenter stepped in to replace a participant (e.g., for a no-show participant), they did not wear fNIRS/EEG devices, and in some cases, they did not wear the eye tracker either. Not all groups completed all the tasks, and for some tasks, the data is missing. In cases such as these, the table simply omits rows for which we do not have data.

Column descriptions

group_session
Group session ID
participant
Participant ID
station
The iMac that the participant was stationed at.
task
Task ID.
modality
The modality of the data.
is_valid
Whether the data for the relevant participant/task/modality is valid (1) or invalid (0).

where station = "cheetah"

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE "data_validity" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [participant] INTEGER REFERENCES [participant]([id]),
   [station] TEXT REFERENCES [station]([id]),
   [task] TEXT REFERENCES [task]([id]),
   [modality] TEXT REFERENCES [modality]([id]),
   [is_valid] INTEGER,
   PRIMARY KEY ([group_session], [participant], [station], [task], [modality], [is_valid])
);
CREATE INDEX [idx_data_validity_modality]
    ON [data_validity] ([modality]);
CREATE INDEX [idx_data_validity_task]
    ON [data_validity] ([task]);
CREATE INDEX [idx_data_validity_station]
    ON [data_validity] ([station]);
CREATE INDEX [idx_data_validity_participant]
    ON [data_validity] ([participant]);
CREATE INDEX [idx_data_validity_group_session]
    ON [data_validity] ([group_session]);