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 participant = 105

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: task, modality

Link group_session participant station task modality is_valid
exp_2023_02_06_13,105,lion,affective_individual,eeg,1 exp_2023_02_06_13 105 lion affective_individual eeg 1
exp_2023_02_06_13,105,lion,affective_individual,fnirs,1 exp_2023_02_06_13 105 lion affective_individual fnirs 1
exp_2023_02_06_13,105,lion,affective_individual,gaze,1 exp_2023_02_06_13 105 lion affective_individual gaze 1
exp_2023_02_06_13,105,lion,affective_team,eeg,1 exp_2023_02_06_13 105 lion affective_team eeg 1
exp_2023_02_06_13,105,lion,affective_team,fnirs,1 exp_2023_02_06_13 105 lion affective_team fnirs 1
exp_2023_02_06_13,105,lion,affective_team,gaze,1 exp_2023_02_06_13 105 lion affective_team gaze 1
exp_2023_02_06_13,105,lion,finger_tapping,eeg,1 exp_2023_02_06_13 105 lion finger_tapping eeg 1
exp_2023_02_06_13,105,lion,finger_tapping,fnirs,1 exp_2023_02_06_13 105 lion finger_tapping fnirs 1
exp_2023_02_06_13,105,lion,finger_tapping,gaze,1 exp_2023_02_06_13 105 lion finger_tapping gaze 1
exp_2023_02_06_13,105,lion,hands_on_training,eeg,1 exp_2023_02_06_13 105 lion hands_on_training eeg 1
exp_2023_02_06_13,105,lion,hands_on_training,fnirs,1 exp_2023_02_06_13 105 lion hands_on_training fnirs 1
exp_2023_02_06_13,105,lion,hands_on_training,gaze,1 exp_2023_02_06_13 105 lion hands_on_training gaze 1
exp_2023_02_06_13,105,lion,ping_pong_competitive,eeg,1 exp_2023_02_06_13 105 lion ping_pong_competitive eeg 1
exp_2023_02_06_13,105,lion,ping_pong_competitive,fnirs,1 exp_2023_02_06_13 105 lion ping_pong_competitive fnirs 1
exp_2023_02_06_13,105,lion,ping_pong_competitive,gaze,1 exp_2023_02_06_13 105 lion ping_pong_competitive gaze 1
exp_2023_02_06_13,105,lion,ping_pong_cooperative,eeg,1 exp_2023_02_06_13 105 lion ping_pong_cooperative eeg 1
exp_2023_02_06_13,105,lion,ping_pong_cooperative,fnirs,1 exp_2023_02_06_13 105 lion ping_pong_cooperative fnirs 1
exp_2023_02_06_13,105,lion,ping_pong_cooperative,gaze,1 exp_2023_02_06_13 105 lion ping_pong_cooperative gaze 1
exp_2023_02_06_13,105,lion,rest_state,eeg,1 exp_2023_02_06_13 105 lion rest_state eeg 1
exp_2023_02_06_13,105,lion,rest_state,fnirs,1 exp_2023_02_06_13 105 lion rest_state fnirs 1
exp_2023_02_06_13,105,lion,rest_state,gaze,1 exp_2023_02_06_13 105 lion rest_state gaze 1
exp_2023_02_06_13,105,lion,saturn_a,eeg,1 exp_2023_02_06_13 105 lion saturn_a eeg 1
exp_2023_02_06_13,105,lion,saturn_a,fnirs,1 exp_2023_02_06_13 105 lion saturn_a fnirs 1
exp_2023_02_06_13,105,lion,saturn_a,gaze,1 exp_2023_02_06_13 105 lion saturn_a gaze 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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