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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: task_type, 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,1682706188.8520734 exp_2023_04_28_10 152 individual 1682706188.8520734 2023-04-28T18:23:08.852073+00:00 intermediate_selection individual003.jpg -2  
exp_2023_04_28_10,152,individual,1682706192.696241 exp_2023_04_28_10 152 individual 1682706192.696241 2023-04-28T18:23:12.696241+00:00 final_submission individual003.jpg -2 0
exp_2023_04_28_10,152,individual,1682706201.059506 exp_2023_04_28_10 152 individual 1682706201.059506 2023-04-28T18:23:21.059506+00:00 intermediate_selection individual004.jpg -2  
exp_2023_04_28_10,152,individual,1682706203.9847145 exp_2023_04_28_10 152 individual 1682706203.9847145 2023-04-28T18:23:23.984715+00:00 final_submission individual004.jpg -2 0
exp_2023_04_28_10,152,individual,1682706225.241333 exp_2023_04_28_10 152 individual 1682706225.241333 2023-04-28T18:23:45.241333+00:00 intermediate_selection individual006.jpg -2  
exp_2023_04_28_10,152,individual,1682706226.9851792 exp_2023_04_28_10 152 individual 1682706226.9851792 2023-04-28T18:23:46.985179+00:00 final_submission individual006.jpg -2 1
exp_2023_04_28_10,152,team,1682706763.3836558 exp_2023_04_28_10 152 team 1682706763.3836558 2023-04-28T18:32:43.383656+00:00 intermediate_selection Team007.jpg -2  
exp_2023_04_28_10,152,team,1682706764.9666295 exp_2023_04_28_10 152 team 1682706764.9666295 2023-04-28T18:32:44.966630+00:00 final_submission Team007.jpg -2 2

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