affective_task_event

Events from the individual and team affective tasks.

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 arousal_score = "-1" and participant = 152

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: event_type, image_path, valence_score, timestamp_iso8601 (date)

Link group_session participant task_type timestamp_unix timestamp_iso8601 event_type image_path arousal_score valence_score
exp_2023_04_28_10,152,individual,1682706152.5130944 exp_2023_04_28_10 152 individual 1682706152.5130944 2023-04-28T18:22:32.513094+00:00 intermediate_selection individual000.jpg -1  
exp_2023_04_28_10,152,individual,1682706156.0791447 exp_2023_04_28_10 152 individual 1682706156.0791447 2023-04-28T18:22:36.079145+00:00 final_submission individual000.jpg -1 -2
exp_2023_04_28_10,152,individual,1682706255.448356 exp_2023_04_28_10 152 individual 1682706255.448356 2023-04-28T18:24:15.448356+00:00 intermediate_selection individual009.jpg -1  
exp_2023_04_28_10,152,individual,1682706257.6665065 exp_2023_04_28_10 152 individual 1682706257.6665065 2023-04-28T18:24:17.666507+00:00 final_submission individual009.jpg -1 0
exp_2023_04_28_10,152,individual,1682706275.72342 exp_2023_04_28_10 152 individual 1682706275.72342 2023-04-28T18:24:35.723420+00:00 intermediate_selection individual011.jpg -1  
exp_2023_04_28_10,152,individual,1682706279.2271569 exp_2023_04_28_10 152 individual 1682706279.2271569 2023-04-28T18:24:39.227157+00:00 final_submission individual011.jpg -1 0

Advanced export

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

CSV options: 

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