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 = 93
✎ View and edit SQL
This data as json, copyable
0 records
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]);