Column descriptions

group_session

The group session the task is a part of.

participant

Participant ID.

timestamp_unix

The Unix timestamp of the event.

timestamp_iso8601

The ISO-8601 timestamp of the event.

event_type

The type of the event.

image_path

The path to the image that was shown on the participant screen(s).

arousal_score

The arousal score reported by the participant. Null if not applicable.

valence_score

The valence score reported by the participant. Null if not applicable.

where participant = "-3"

- remove filter - group_session participant task_type timestamp_unix timestamp_iso8601 event_type image_path arousal_score valence_score

= != 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 participant task_type timestamp_unix timestamp_iso8601 event_type image_path arousal_score valence_score

= != 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 participant Sort by task_type Sort by timestamp_unix Sort by timestamp_iso8601 Sort by event_type Sort by image_path Sort by arousal_score Sort by valence_score

descending

✎ View and edit SQL

This data as json, copyable

0 records

CREATE TABLE "affective_task_event" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [participant] INTEGER REFERENCES [participant]([id]),
   [task_type] TEXT,
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [event_type] TEXT,
   [image_path] TEXT,
   [arousal_score] INTEGER,
   [valence_score] INTEGER,
   PRIMARY KEY ([group_session], [participant], [task_type], [timestamp_unix])
);
CREATE INDEX [idx_affective_task_event_participant]
    ON [affective_task_event] ([participant]);
CREATE INDEX [idx_affective_task_event_group_session]
    ON [affective_task_event] ([group_session]);