eeg_raw

Table with raw EEG data.

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, CSV (advanced)

Suggested facets: timestamp_iso8601 (date)

Link 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
exp_2022_10_24_12,lion,93,411439 exp_2022_10_24_12 lion 93 411439 affective_individual 1675114.353398952 1970-01-20T09:18:34.353399+00:00 -0.000600146 -0.0142203 0.00451304 -0.0056041 -0.0163695 -0.025294 -0.0059395 0.0107167 -0.0162306 -0.0166933 0.00433408 -0.00405273 0.00807324 -0.0176892 -0.00387446 0.00709346 -0.00788989 -0.00941982 0.00652681 -0.0183684 -0.00554312 0.58286 -0.11219 -0.407755 -0.408071 -0.40805 -0.408402 -0.40941 -0.408894 -0.409236 -0.408407 -0.408391 -0.408251 -0.406826

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);