Column descriptions

group_session

Group session ID.

station

The iMac that the participant was stationed at.

device_id

The id of the EEG device used in the station.

where group_session = "exp_2023_05_01_13"

- remove filter - group_session station device_id

= != 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 device_id

= != 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 device_id

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

CREATE TABLE "eeg_device" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [station] TEXT REFERENCES [station]([id]),
   [device_id] TEXT,
   PRIMARY KEY ([group_session], [station])
);
CREATE INDEX [idx_eeg_device_station]
    ON [eeg_device] ([station]);
CREATE INDEX [idx_eeg_device_group_session]
    ON [eeg_device] ([group_session]);