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 = 64

View and edit SQL

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

Link group_session participant task_type timestamp_unix timestamp_iso8601 event_type image_path arousal_score valence_score
exp_2022_10_31_10 64 individual 1667241166.7763896 2022-10-31T18:32:46.776390+00:00 start_affective_task      
exp_2022_10_31_10 64 individual 1667241177.6093287 2022-10-31T18:32:57.609329+00:00 intermediate_selection individual000.jpg 0  
exp_2022_10_31_10 64 individual 1667241180.285617 2022-10-31T18:33:00.285617+00:00 intermediate_selection individual000.jpg   -1
exp_2022_10_31_10 64 individual 1667241181.3258665 2022-10-31T18:33:01.325866+00:00 final_submission individual000.jpg 0 -1
exp_2022_10_31_10 64 individual 1667241190.0050323 2022-10-31T18:33:10.005032+00:00 intermediate_selection individual001.jpg 1  
exp_2022_10_31_10 64 individual 1667241191.4664292 2022-10-31T18:33:11.466429+00:00 intermediate_selection individual001.jpg   1
exp_2022_10_31_10 64 individual 1667241192.9508708 2022-10-31T18:33:12.950871+00:00 final_submission individual001.jpg 1 1
exp_2022_10_31_10 64 individual 1667241200.4183106 2022-10-31T18:33:20.418311+00:00 intermediate_selection individual002.jpg 0  
exp_2022_10_31_10 64 individual 1667241201.078942 2022-10-31T18:33:21.078942+00:00 intermediate_selection individual002.jpg   0
exp_2022_10_31_10 64 individual 1667241201.8789947 2022-10-31T18:33:21.878995+00:00 final_submission individual002.jpg 0 0
exp_2022_10_31_10 64 individual 1667241210.8148816 2022-10-31T18:33:30.814882+00:00 intermediate_selection individual003.jpg 0  
exp_2022_10_31_10 64 individual 1667241211.8444536 2022-10-31T18:33:31.844454+00:00 intermediate_selection individual003.jpg   1
exp_2022_10_31_10 64 individual 1667241215.941899 2022-10-31T18:33:35.941899+00:00 intermediate_selection individual003.jpg   2
exp_2022_10_31_10 64 individual 1667241217.6150472 2022-10-31T18:33:37.615047+00:00 final_submission individual003.jpg 0 2
exp_2022_10_31_10 64 individual 1667241226.5407374 2022-10-31T18:33:46.540737+00:00 intermediate_selection individual004.jpg -1  
exp_2022_10_31_10 64 individual 1667241229.311118 2022-10-31T18:33:49.311118+00:00 intermediate_selection individual004.jpg   0
exp_2022_10_31_10 64 individual 1667241230.3172557 2022-10-31T18:33:50.317256+00:00 intermediate_selection individual004.jpg 0  
exp_2022_10_31_10 64 individual 1667241231.0161605 2022-10-31T18:33:51.016160+00:00 final_submission individual004.jpg 0 0
exp_2022_10_31_10 64 individual 1667241239.572007 2022-10-31T18:33:59.572007+00:00 intermediate_selection individual005.jpg 0  
exp_2022_10_31_10 64 individual 1667241240.1377964 2022-10-31T18:34:00.137796+00:00 intermediate_selection individual005.jpg   0
exp_2022_10_31_10 64 individual 1667241241.3925261 2022-10-31T18:34:01.392526+00:00 final_submission individual005.jpg 0 0
exp_2022_10_31_10 64 individual 1667241249.9495234 2022-10-31T18:34:09.949523+00:00 intermediate_selection individual006.jpg -2  
exp_2022_10_31_10 64 individual 1667241250.5338733 2022-10-31T18:34:10.533873+00:00 intermediate_selection individual006.jpg   -2
exp_2022_10_31_10 64 individual 1667241252.3898528 2022-10-31T18:34:12.389853+00:00 intermediate_selection individual006.jpg   -1
exp_2022_10_31_10 64 individual 1667241253.6544917 2022-10-31T18:34:13.654492+00:00 intermediate_selection individual006.jpg   0
exp_2022_10_31_10 64 individual 1667241254.0127444 2022-10-31T18:34:14.012744+00:00 intermediate_selection individual006.jpg   0
exp_2022_10_31_10 64 individual 1667241254.401839 2022-10-31T18:34:14.401839+00:00 intermediate_selection individual006.jpg   0
exp_2022_10_31_10 64 individual 1667241254.7808073 2022-10-31T18:34:14.780807+00:00 intermediate_selection individual006.jpg   0
exp_2022_10_31_10 64 individual 1667241255.3177202 2022-10-31T18:34:15.317720+00:00 intermediate_selection individual006.jpg   1
exp_2022_10_31_10 64 individual 1667241255.758801 2022-10-31T18:34:15.758801+00:00 intermediate_selection individual006.jpg   1
exp_2022_10_31_10 64 individual 1667241257.4358246 2022-10-31T18:34:17.435825+00:00 intermediate_selection individual006.jpg   2
exp_2022_10_31_10 64 individual 1667241258.3048835 2022-10-31T18:34:18.304883+00:00 final_submission individual006.jpg -2 2
exp_2022_10_31_10 64 individual 1667241266.637452 2022-10-31T18:34:26.637452+00:00 intermediate_selection individual007.jpg 1  
exp_2022_10_31_10 64 individual 1667241267.90759 2022-10-31T18:34:27.907590+00:00 intermediate_selection individual007.jpg   0
exp_2022_10_31_10 64 individual 1667241268.3930194 2022-10-31T18:34:28.393019+00:00 final_submission individual007.jpg 1 0
exp_2022_10_31_10 64 individual 1667241276.679322 2022-10-31T18:34:36.679322+00:00 intermediate_selection individual008.jpg -1  
exp_2022_10_31_10 64 individual 1667241277.9352357 2022-10-31T18:34:37.935236+00:00 intermediate_selection individual008.jpg   1
exp_2022_10_31_10 64 individual 1667241278.4890447 2022-10-31T18:34:38.489045+00:00 final_submission individual008.jpg -1 1
exp_2022_10_31_10 64 individual 1667241286.2771833 2022-10-31T18:34:46.277183+00:00 intermediate_selection individual009.jpg -2  
exp_2022_10_31_10 64 individual 1667241287.5259347 2022-10-31T18:34:47.525935+00:00 intermediate_selection individual009.jpg   2
exp_2022_10_31_10 64 individual 1667241288.0702686 2022-10-31T18:34:48.070269+00:00 intermediate_selection individual009.jpg   1
exp_2022_10_31_10 64 individual 1667241288.5028303 2022-10-31T18:34:48.502830+00:00 intermediate_selection individual009.jpg   2
exp_2022_10_31_10 64 individual 1667241289.417779 2022-10-31T18:34:49.417779+00:00 final_submission individual009.jpg -2 2
exp_2022_10_31_10 64 individual 1667241297.157908 2022-10-31T18:34:57.157908+00:00 intermediate_selection individual010.jpg 0  
exp_2022_10_31_10 64 individual 1667241297.6941974 2022-10-31T18:34:57.694197+00:00 intermediate_selection individual010.jpg 1  
exp_2022_10_31_10 64 individual 1667241298.268948 2022-10-31T18:34:58.268948+00:00 intermediate_selection individual010.jpg   1
exp_2022_10_31_10 64 individual 1667241299.2662446 2022-10-31T18:34:59.266245+00:00 final_submission individual010.jpg 1 1
exp_2022_10_31_10 64 individual 1667241309.0463982 2022-10-31T18:35:09.046398+00:00 intermediate_selection individual011.jpg 1  
exp_2022_10_31_10 64 individual 1667241310.7359529 2022-10-31T18:35:10.735953+00:00 intermediate_selection individual011.jpg   -1
exp_2022_10_31_10 64 individual 1667241311.6187212 2022-10-31T18:35:11.618721+00:00 final_submission individual011.jpg 1 -1
exp_2022_10_31_10 64 individual 1667241319.3912354 2022-10-31T18:35:19.391235+00:00 intermediate_selection individual012.jpg   -2
exp_2022_10_31_10 64 individual 1667241320.2784364 2022-10-31T18:35:20.278436+00:00 intermediate_selection individual012.jpg 0  
exp_2022_10_31_10 64 individual 1667241320.9551919 2022-10-31T18:35:20.955192+00:00 final_submission individual012.jpg 0 -2
exp_2022_10_31_10 64 individual 1667241329.1415637 2022-10-31T18:35:29.141564+00:00 intermediate_selection individual013.jpg   -2
exp_2022_10_31_10 64 individual 1667241330.6176646 2022-10-31T18:35:30.617665+00:00 intermediate_selection individual013.jpg 2  
exp_2022_10_31_10 64 individual 1667241332.4192753 2022-10-31T18:35:32.419275+00:00 final_submission individual013.jpg 2 -2
exp_2022_10_31_10 64 individual 1667241340.1857812 2022-10-31T18:35:40.185781+00:00 intermediate_selection individual014.jpg 0  
exp_2022_10_31_10 64 individual 1667241340.5809543 2022-10-31T18:35:40.580954+00:00 intermediate_selection individual014.jpg   0
exp_2022_10_31_10 64 individual 1667241341.0192802 2022-10-31T18:35:41.019280+00:00 final_submission individual014.jpg 0 0
exp_2022_10_31_10 64 team 1667241547.6087534 2022-10-31T18:39:07.608753+00:00 intermediate_selection Team001.jpg   -1
exp_2022_10_31_10 64 team 1667241549.8790011 2022-10-31T18:39:09.879001+00:00 intermediate_selection Team001.jpg   -2
exp_2022_10_31_10 64 team 1667241550.2940893 2022-10-31T18:39:10.294089+00:00 intermediate_selection Team001.jpg   -1
exp_2022_10_31_10 64 team 1667241554.119413 2022-10-31T18:39:14.119413+00:00 intermediate_selection Team001.jpg 1  
exp_2022_10_31_10 64 team 1667241555.0800445 2022-10-31T18:39:15.080045+00:00 final_submission Team001.jpg 1 -1
exp_2022_10_31_10 64 team 1667241695.828287 2022-10-31T18:41:35.828287+00:00 intermediate_selection Team004.jpg 1  
exp_2022_10_31_10 64 team 1667241697.2465928 2022-10-31T18:41:37.246593+00:00 intermediate_selection Team004.jpg 0  
exp_2022_10_31_10 64 team 1667241697.6320426 2022-10-31T18:41:37.632043+00:00 intermediate_selection Team004.jpg 1  
exp_2022_10_31_10 64 team 1667241699.2655468 2022-10-31T18:41:39.265547+00:00 intermediate_selection Team004.jpg   0
exp_2022_10_31_10 64 team 1667241700.8090336 2022-10-31T18:41:40.809034+00:00 final_submission Team004.jpg 1 0
exp_2022_10_31_10 64 team 1667241835.3246396 2022-10-31T18:43:55.324640+00:00 intermediate_selection Team007.jpg 0  
exp_2022_10_31_10 64 team 1667241837.2906678 2022-10-31T18:43:57.290668+00:00 intermediate_selection Team007.jpg   1
exp_2022_10_31_10 64 team 1667241838.8291628 2022-10-31T18:43:58.829163+00:00 final_submission Team007.jpg 0 1
exp_2022_10_31_10 64 team 1667241967.5573428 2022-10-31T18:46:07.557343+00:00 intermediate_selection Team010.jpg   -2
exp_2022_10_31_10 64 team 1667241968.5291238 2022-10-31T18:46:08.529124+00:00 intermediate_selection Team010.jpg 0  
exp_2022_10_31_10 64 team 1667241969.6579437 2022-10-31T18:46:09.657944+00:00 final_submission Team010.jpg 0 -2
exp_2022_10_31_10 64 team 1667242103.4847589 2022-10-31T18:48:23.484759+00:00 intermediate_selection Team013.jpg 2  
exp_2022_10_31_10 64 team 1667242106.3475602 2022-10-31T18:48:26.347560+00:00 intermediate_selection Team013.jpg   2
exp_2022_10_31_10 64 team 1667242106.9108434 2022-10-31T18:48:26.910843+00:00 final_submission Team013.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])
);
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]);