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

View and edit SQL

Suggested facets: participant, station, task, modality

Link group_session participant station task modality is_valid
exp_2022_11_15_13 14 lion affective_individual eeg 1
exp_2022_11_15_13 14 lion affective_individual fnirs 1
exp_2022_11_15_13 14 lion affective_individual gaze 1
exp_2022_11_15_13 14 lion affective_team eeg 1
exp_2022_11_15_13 14 lion affective_team fnirs 1
exp_2022_11_15_13 14 lion affective_team gaze 1
exp_2022_11_15_13 14 lion finger_tapping eeg 1
exp_2022_11_15_13 14 lion finger_tapping fnirs 1
exp_2022_11_15_13 14 lion finger_tapping gaze 1
exp_2022_11_15_13 14 lion hands_on_training eeg 1
exp_2022_11_15_13 14 lion hands_on_training fnirs 1
exp_2022_11_15_13 14 lion hands_on_training gaze 1
exp_2022_11_15_13 14 lion ping_pong_competitive eeg 1
exp_2022_11_15_13 14 lion ping_pong_competitive fnirs 1
exp_2022_11_15_13 14 lion ping_pong_competitive gaze 1
exp_2022_11_15_13 14 lion ping_pong_cooperative eeg 1
exp_2022_11_15_13 14 lion ping_pong_cooperative fnirs 1
exp_2022_11_15_13 14 lion ping_pong_cooperative gaze 1
exp_2022_11_15_13 14 lion rest_state eeg 1
exp_2022_11_15_13 14 lion rest_state fnirs 1
exp_2022_11_15_13 14 lion rest_state gaze 1
exp_2022_11_15_13 14 lion saturn_a eeg 1
exp_2022_11_15_13 14 lion saturn_a fnirs 1
exp_2022_11_15_13 14 lion saturn_a gaze 1
exp_2022_11_15_13 14 lion saturn_b eeg 1
exp_2022_11_15_13 14 lion saturn_b fnirs 1
exp_2022_11_15_13 14 lion saturn_b gaze 1
exp_2022_11_15_13 30 tiger affective_individual eeg 1
exp_2022_11_15_13 30 tiger affective_individual fnirs 1
exp_2022_11_15_13 30 tiger affective_individual gaze 1
exp_2022_11_15_13 30 tiger affective_team eeg 1
exp_2022_11_15_13 30 tiger affective_team fnirs 1
exp_2022_11_15_13 30 tiger affective_team gaze 1
exp_2022_11_15_13 30 tiger finger_tapping eeg 1
exp_2022_11_15_13 30 tiger finger_tapping fnirs 1
exp_2022_11_15_13 30 tiger finger_tapping gaze 1
exp_2022_11_15_13 30 tiger hands_on_training eeg 1
exp_2022_11_15_13 30 tiger hands_on_training fnirs 1
exp_2022_11_15_13 30 tiger hands_on_training gaze 1
exp_2022_11_15_13 30 tiger ping_pong_competitive eeg 1
exp_2022_11_15_13 30 tiger ping_pong_competitive fnirs 1
exp_2022_11_15_13 30 tiger ping_pong_competitive gaze 1
exp_2022_11_15_13 30 tiger ping_pong_cooperative eeg 1
exp_2022_11_15_13 30 tiger ping_pong_cooperative fnirs 1
exp_2022_11_15_13 30 tiger ping_pong_cooperative gaze 1
exp_2022_11_15_13 30 tiger rest_state eeg 1
exp_2022_11_15_13 30 tiger rest_state fnirs 1
exp_2022_11_15_13 30 tiger rest_state gaze 1
exp_2022_11_15_13 30 tiger saturn_a eeg 1
exp_2022_11_15_13 30 tiger saturn_a fnirs 1
exp_2022_11_15_13 30 tiger saturn_a gaze 1
exp_2022_11_15_13 30 tiger saturn_b eeg 1
exp_2022_11_15_13 30 tiger saturn_b fnirs 1
exp_2022_11_15_13 30 tiger saturn_b gaze 1
exp_2022_11_15_13 40 leopard affective_individual eeg 1
exp_2022_11_15_13 40 leopard affective_individual fnirs 1
exp_2022_11_15_13 40 leopard affective_individual gaze 1
exp_2022_11_15_13 40 leopard affective_team eeg 1
exp_2022_11_15_13 40 leopard affective_team fnirs 1
exp_2022_11_15_13 40 leopard affective_team gaze 1
exp_2022_11_15_13 40 leopard finger_tapping eeg 1
exp_2022_11_15_13 40 leopard finger_tapping fnirs 1
exp_2022_11_15_13 40 leopard finger_tapping gaze 1
exp_2022_11_15_13 40 leopard hands_on_training eeg 1
exp_2022_11_15_13 40 leopard hands_on_training fnirs 1
exp_2022_11_15_13 40 leopard hands_on_training gaze 1
exp_2022_11_15_13 40 leopard ping_pong_competitive eeg 1
exp_2022_11_15_13 40 leopard ping_pong_competitive fnirs 1
exp_2022_11_15_13 40 leopard ping_pong_competitive gaze 1
exp_2022_11_15_13 40 leopard ping_pong_cooperative eeg 1
exp_2022_11_15_13 40 leopard ping_pong_cooperative fnirs 1
exp_2022_11_15_13 40 leopard ping_pong_cooperative gaze 1
exp_2022_11_15_13 40 leopard rest_state eeg 1
exp_2022_11_15_13 40 leopard rest_state fnirs 1
exp_2022_11_15_13 40 leopard rest_state gaze 1
exp_2022_11_15_13 40 leopard saturn_a eeg 1
exp_2022_11_15_13 40 leopard saturn_a fnirs 1
exp_2022_11_15_13 40 leopard saturn_a gaze 1
exp_2022_11_15_13 40 leopard saturn_b eeg 1
exp_2022_11_15_13 40 leopard saturn_b fnirs 1
exp_2022_11_15_13 40 leopard saturn_b 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]);