Column descriptions

group_session

Group session ID

task

Task ID.

station

The iMac that the participant was stationed at.

participant

Participant ID. A participant ID of -1 indicates an unknown participant. All rows that do not have values for the `task` column will have their participant ID set to -1. In the future, we will label some of these inter/pre/post task rows with the correct participant ID.

timestamp_unix

The Unix timestamp of the event.

timestamp_iso8601

The ISO-8601 timestamp of the event.

where participant = "-3"

- remove filter - group_session station participant id task timestamp_unix timestamp_iso8601 aff1h f7 fc5 c3 t7 tp9 pz p3 p7 o1 o2 p8 p4 tp10 cz c4 t8 fc6 fcz f8 aff2h aux_gsr aux_ekg aff5h fc1 cp5 cp1 po9 oz po10 cp6 cp2 fc2 aff6h

= != 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 participant id task timestamp_unix timestamp_iso8601 aff1h f7 fc5 c3 t7 tp9 pz p3 p7 o1 o2 p8 p4 tp10 cz c4 t8 fc6 fcz f8 aff2h aux_gsr aux_ekg aff5h fc1 cp5 cp1 po9 oz po10 cp6 cp2 fc2 aff6h

= != 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 participant Sort by id Sort by task Sort by timestamp_unix Sort by timestamp_iso8601 Sort by aff1h Sort by f7 Sort by fc5 Sort by c3 Sort by t7 Sort by tp9 Sort by pz Sort by p3 Sort by p7 Sort by o1 Sort by o2 Sort by p8 Sort by p4 Sort by tp10 Sort by cz Sort by c4 Sort by t8 Sort by fc6 Sort by fcz Sort by f8 Sort by aff2h Sort by aux_gsr Sort by aux_ekg Sort by aff5h Sort by fc1 Sort by cp5 Sort by cp1 Sort by po9 Sort by oz Sort by po10 Sort by cp6 Sort by cp2 Sort by fc2 Sort by aff6h

descending

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE "eeg_raw" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [station] TEXT REFERENCES [station]([id]),
   [participant] INTEGER REFERENCES [participant]([id]),
   [id] INTEGER,
   [task] TEXT REFERENCES [task]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [aff1h] FLOAT,
   [f7] FLOAT,
   [fc5] FLOAT,
   [c3] FLOAT,
   [t7] FLOAT,
   [tp9] FLOAT,
   [pz] FLOAT,
   [p3] FLOAT,
   [p7] FLOAT,
   [o1] FLOAT,
   [o2] FLOAT,
   [p8] FLOAT,
   [p4] FLOAT,
   [tp10] FLOAT,
   [cz] FLOAT,
   [c4] FLOAT,
   [t8] FLOAT,
   [fc6] FLOAT,
   [fcz] FLOAT,
   [f8] FLOAT,
   [aff2h] FLOAT,
   [aux_gsr] FLOAT,
   [aux_ekg] FLOAT,
   [aff5h] FLOAT,
   [fc1] FLOAT,
   [cp5] FLOAT,
   [cp1] FLOAT,
   [po9] FLOAT,
   [oz] FLOAT,
   [po10] FLOAT,
   [cp6] FLOAT,
   [cp2] FLOAT,
   [fc2] FLOAT,
   [aff6h] FLOAT,
   PRIMARY KEY ([group_session], [station], [participant], [id])
);
CREATE INDEX [idx_eeg_raw_task]
    ON [eeg_raw] ([task]);
CREATE INDEX [idx_eeg_raw_participant]
    ON [eeg_raw] ([participant]);
CREATE INDEX [idx_eeg_raw_station]
    ON [eeg_raw] ([station]);
CREATE INDEX [idx_eeg_raw_group_session]
    ON [eeg_raw] ([group_session]);