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_22_10"

- remove filter - group_session participant station task modality is_valid

= != 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 participant station task modality is_valid

= != 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 participant Sort by station Sort by task Sort by modality Sort by is_valid

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: participant, station, task, modality

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