fnirs_sync

Table with fNIRS data synchronized to a main clock with fixed frequency. The start and end timestamps of the main clock spans across all the tasks in the experiment.

Column descriptions

group_session
Group session ID
frequency
Frequency of the samples (main clock frequency).
station
The iMac that the participant was stationed at.
timestamp_unix
The Unix timestamp of the event.
timestamp_iso8601
The ISO-8601 timestamp of the event.

where station = "cheetah"

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE "fnirs_sync" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [frequency] INTEGER,
   [station] TEXT REFERENCES [station]([id]),
   [id] INTEGER,
   [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,
   PRIMARY KEY ([group_session], [frequency], [station], [id])
);
CREATE INDEX [idx_fnirs_sync_station]
    ON [fnirs_sync] ([station]);
CREATE INDEX [idx_fnirs_sync_group_session]
    ON [fnirs_sync] ([group_session]);