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

- remove filter - group_session station participant id task timestamp_unix timestamp_iso8601 s1_d1_hbo s1_d2_hbo s2_d1_hbo s2_d3_hbo s3_d1_hbo s3_d3_hbo s3_d4_hbo s4_d2_hbo s4_d4_hbo s4_d5_hbo s5_d3_hbo s5_d4_hbo s5_d6_hbo s6_d4_hbo s6_d6_hbo s6_d7_hbo s7_d5_hbo s7_d7_hbo s8_d6_hbo s8_d7_hbo s1_d1_hbr s1_d2_hbr s2_d1_hbr s2_d3_hbr s3_d1_hbr s3_d3_hbr s3_d4_hbr s4_d2_hbr s4_d4_hbr s4_d5_hbr s5_d3_hbr s5_d4_hbr s5_d6_hbr s6_d4_hbr s6_d6_hbr s6_d7_hbr s7_d5_hbr s7_d7_hbr s8_d6_hbr s8_d7_hbr s1_d1_raw760 s1_d2_raw760 s2_d1_raw760 s2_d3_raw760 s3_d1_raw760 s3_d3_raw760 s3_d4_raw760 s4_d2_raw760 s4_d4_raw760 s4_d5_raw760 s5_d3_raw760 s5_d4_raw760 s5_d6_raw760 s6_d4_raw760 s6_d6_raw760 s6_d7_raw760 s7_d5_raw760 s7_d7_raw760 s8_d6_raw760 s8_d7_raw760 s1_d1_raw850 s1_d2_raw850 s2_d1_raw850 s2_d3_raw850 s3_d1_raw850 s3_d3_raw850 s3_d4_raw850 s4_d2_raw850 s4_d4_raw850 s4_d5_raw850 s5_d3_raw850 s5_d4_raw850 s5_d6_raw850 s6_d4_raw850 s6_d6_raw850 s6_d7_raw850 s7_d5_raw850 s7_d7_raw850 s8_d6_raw850 s8_d7_raw850

= != 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 s1_d1_hbo s1_d2_hbo s2_d1_hbo s2_d3_hbo s3_d1_hbo s3_d3_hbo s3_d4_hbo s4_d2_hbo s4_d4_hbo s4_d5_hbo s5_d3_hbo s5_d4_hbo s5_d6_hbo s6_d4_hbo s6_d6_hbo s6_d7_hbo s7_d5_hbo s7_d7_hbo s8_d6_hbo s8_d7_hbo s1_d1_hbr s1_d2_hbr s2_d1_hbr s2_d3_hbr s3_d1_hbr s3_d3_hbr s3_d4_hbr s4_d2_hbr s4_d4_hbr s4_d5_hbr s5_d3_hbr s5_d4_hbr s5_d6_hbr s6_d4_hbr s6_d6_hbr s6_d7_hbr s7_d5_hbr s7_d7_hbr s8_d6_hbr s8_d7_hbr s1_d1_raw760 s1_d2_raw760 s2_d1_raw760 s2_d3_raw760 s3_d1_raw760 s3_d3_raw760 s3_d4_raw760 s4_d2_raw760 s4_d4_raw760 s4_d5_raw760 s5_d3_raw760 s5_d4_raw760 s5_d6_raw760 s6_d4_raw760 s6_d6_raw760 s6_d7_raw760 s7_d5_raw760 s7_d7_raw760 s8_d6_raw760 s8_d7_raw760 s1_d1_raw850 s1_d2_raw850 s2_d1_raw850 s2_d3_raw850 s3_d1_raw850 s3_d3_raw850 s3_d4_raw850 s4_d2_raw850 s4_d4_raw850 s4_d5_raw850 s5_d3_raw850 s5_d4_raw850 s5_d6_raw850 s6_d4_raw850 s6_d6_raw850 s6_d7_raw850 s7_d5_raw850 s7_d7_raw850 s8_d6_raw850 s8_d7_raw850

= != 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 s1_d1_hbo Sort by s1_d2_hbo Sort by s2_d1_hbo Sort by s2_d3_hbo Sort by s3_d1_hbo Sort by s3_d3_hbo Sort by s3_d4_hbo Sort by s4_d2_hbo Sort by s4_d4_hbo Sort by s4_d5_hbo Sort by s5_d3_hbo Sort by s5_d4_hbo Sort by s5_d6_hbo Sort by s6_d4_hbo Sort by s6_d6_hbo Sort by s6_d7_hbo Sort by s7_d5_hbo Sort by s7_d7_hbo Sort by s8_d6_hbo Sort by s8_d7_hbo Sort by s1_d1_hbr Sort by s1_d2_hbr Sort by s2_d1_hbr Sort by s2_d3_hbr Sort by s3_d1_hbr Sort by s3_d3_hbr Sort by s3_d4_hbr Sort by s4_d2_hbr Sort by s4_d4_hbr Sort by s4_d5_hbr Sort by s5_d3_hbr Sort by s5_d4_hbr Sort by s5_d6_hbr Sort by s6_d4_hbr Sort by s6_d6_hbr Sort by s6_d7_hbr Sort by s7_d5_hbr Sort by s7_d7_hbr Sort by s8_d6_hbr Sort by s8_d7_hbr Sort by s1_d1_raw760 Sort by s1_d2_raw760 Sort by s2_d1_raw760 Sort by s2_d3_raw760 Sort by s3_d1_raw760 Sort by s3_d3_raw760 Sort by s3_d4_raw760 Sort by s4_d2_raw760 Sort by s4_d4_raw760 Sort by s4_d5_raw760 Sort by s5_d3_raw760 Sort by s5_d4_raw760 Sort by s5_d6_raw760 Sort by s6_d4_raw760 Sort by s6_d6_raw760 Sort by s6_d7_raw760 Sort by s7_d5_raw760 Sort by s7_d7_raw760 Sort by s8_d6_raw760 Sort by s8_d7_raw760 Sort by s1_d1_raw850 Sort by s1_d2_raw850 Sort by s2_d1_raw850 Sort by s2_d3_raw850 Sort by s3_d1_raw850 Sort by s3_d3_raw850 Sort by s3_d4_raw850 Sort by s4_d2_raw850 Sort by s4_d4_raw850 Sort by s4_d5_raw850 Sort by s5_d3_raw850 Sort by s5_d4_raw850 Sort by s5_d6_raw850 Sort by s6_d4_raw850 Sort by s6_d6_raw850 Sort by s6_d7_raw850 Sort by s7_d5_raw850 Sort by s7_d7_raw850 Sort by s8_d6_raw850 Sort by s8_d7_raw850

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: station, timestamp_iso8601 (date)

Next page

CREATE TABLE "fnirs_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,
   [s1_d1_hbo] FLOAT,
   [s1_d2_hbo] FLOAT,
   [s2_d1_hbo] FLOAT,
   [s2_d3_hbo] FLOAT,
   [s3_d1_hbo] FLOAT,
   [s3_d3_hbo] FLOAT,
   [s3_d4_hbo] FLOAT,
   [s4_d2_hbo] FLOAT,
   [s4_d4_hbo] FLOAT,
   [s4_d5_hbo] FLOAT,
   [s5_d3_hbo] FLOAT,
   [s5_d4_hbo] FLOAT,
   [s5_d6_hbo] FLOAT,
   [s6_d4_hbo] FLOAT,
   [s6_d6_hbo] FLOAT,
   [s6_d7_hbo] FLOAT,
   [s7_d5_hbo] FLOAT,
   [s7_d7_hbo] FLOAT,
   [s8_d6_hbo] FLOAT,
   [s8_d7_hbo] FLOAT,
   [s1_d1_hbr] FLOAT,
   [s1_d2_hbr] FLOAT,
   [s2_d1_hbr] FLOAT,
   [s2_d3_hbr] FLOAT,
   [s3_d1_hbr] FLOAT,
   [s3_d3_hbr] FLOAT,
   [s3_d4_hbr] FLOAT,
   [s4_d2_hbr] FLOAT,
   [s4_d4_hbr] FLOAT,
   [s4_d5_hbr] FLOAT,
   [s5_d3_hbr] FLOAT,
   [s5_d4_hbr] FLOAT,
   [s5_d6_hbr] FLOAT,
   [s6_d4_hbr] FLOAT,
   [s6_d6_hbr] FLOAT,
   [s6_d7_hbr] FLOAT,
   [s7_d5_hbr] FLOAT,
   [s7_d7_hbr] FLOAT,
   [s8_d6_hbr] FLOAT,
   [s8_d7_hbr] FLOAT,
   [s1_d1_raw760] FLOAT,
   [s1_d2_raw760] FLOAT,
   [s2_d1_raw760] FLOAT,
   [s2_d3_raw760] FLOAT,
   [s3_d1_raw760] FLOAT,
   [s3_d3_raw760] FLOAT,
   [s3_d4_raw760] FLOAT,
   [s4_d2_raw760] FLOAT,
   [s4_d4_raw760] FLOAT,
   [s4_d5_raw760] FLOAT,
   [s5_d3_raw760] FLOAT,
   [s5_d4_raw760] FLOAT,
   [s5_d6_raw760] FLOAT,
   [s6_d4_raw760] FLOAT,
   [s6_d6_raw760] FLOAT,
   [s6_d7_raw760] FLOAT,
   [s7_d5_raw760] FLOAT,
   [s7_d7_raw760] FLOAT,
   [s8_d6_raw760] FLOAT,
   [s8_d7_raw760] FLOAT,
   [s1_d1_raw850] FLOAT,
   [s1_d2_raw850] FLOAT,
   [s2_d1_raw850] FLOAT,
   [s2_d3_raw850] FLOAT,
   [s3_d1_raw850] FLOAT,
   [s3_d3_raw850] FLOAT,
   [s3_d4_raw850] FLOAT,
   [s4_d2_raw850] FLOAT,
   [s4_d4_raw850] FLOAT,
   [s4_d5_raw850] FLOAT,
   [s5_d3_raw850] FLOAT,
   [s5_d4_raw850] FLOAT,
   [s5_d6_raw850] FLOAT,
   [s6_d4_raw850] FLOAT,
   [s6_d6_raw850] FLOAT,
   [s6_d7_raw850] FLOAT,
   [s7_d5_raw850] FLOAT,
   [s7_d7_raw850] FLOAT,
   [s8_d6_raw850] FLOAT,
   [s8_d7_raw850] FLOAT,
   PRIMARY KEY ([group_session], [station], [participant], [id])
);
CREATE INDEX [idx_fnirs_raw_task]
    ON [fnirs_raw] ([task]);
CREATE INDEX [idx_fnirs_raw_participant]
    ON [fnirs_raw] ([participant]);
CREATE INDEX [idx_fnirs_raw_station]
    ON [fnirs_raw] ([station]);
CREATE INDEX [idx_fnirs_raw_group_session]
    ON [fnirs_raw] ([group_session]);