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

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_2023_05_01_13 147 individual 1682975960.5492804 2023-05-01T21:19:20.549280+00:00 start_affective_task      
exp_2023_05_01_13 147 individual 1682975960.5498636 2023-05-01T21:19:20.549864+00:00 show_blank_screen individual000.jpg    
exp_2023_05_01_13 147 individual 1682975961.5701153 2023-05-01T21:19:21.570115+00:00 show_cross_screen individual000.jpg    
exp_2023_05_01_13 147 individual 1682975962.0806024 2023-05-01T21:19:22.080602+00:00 show_image individual000.jpg    
exp_2023_05_01_13 147 individual 1682975967.1140432 2023-05-01T21:19:27.114043+00:00 show_rating_screen individual000.jpg    
exp_2023_05_01_13 147 individual 1682975970.0584624 2023-05-01T21:19:30.058462+00:00 intermediate_selection individual000.jpg 1  
exp_2023_05_01_13 147 individual 1682975970.1070876 2023-05-01T21:19:30.107088+00:00 intermediate_selection individual000.jpg 1  
exp_2023_05_01_13 147 individual 1682975974.0037231 2023-05-01T21:19:34.003723+00:00 intermediate_selection individual000.jpg   0
exp_2023_05_01_13 147 individual 1682975975.505684 2023-05-01T21:19:35.505684+00:00 final_submission individual000.jpg 1 0
exp_2023_05_01_13 147 individual 1682975975.6063344 2023-05-01T21:19:35.606334+00:00 show_blank_screen individual001.jpg    
exp_2023_05_01_13 147 individual 1682975976.626994 2023-05-01T21:19:36.626994+00:00 show_cross_screen individual001.jpg    
exp_2023_05_01_13 147 individual 1682975977.147438 2023-05-01T21:19:37.147438+00:00 show_image individual001.jpg    
exp_2023_05_01_13 147 individual 1682975982.1673722 2023-05-01T21:19:42.167372+00:00 show_rating_screen individual001.jpg    
exp_2023_05_01_13 147 individual 1682975984.2012072 2023-05-01T21:19:44.201207+00:00 intermediate_selection individual001.jpg -1  
exp_2023_05_01_13 147 individual 1682975985.4351609 2023-05-01T21:19:45.435161+00:00 intermediate_selection individual001.jpg   0
exp_2023_05_01_13 147 individual 1682975986.866201 2023-05-01T21:19:46.866201+00:00 final_submission individual001.jpg -1 0
exp_2023_05_01_13 147 individual 1682975986.9669452 2023-05-01T21:19:46.966945+00:00 show_blank_screen individual002.jpg    
exp_2023_05_01_13 147 individual 1682975987.9913948 2023-05-01T21:19:47.991395+00:00 show_cross_screen individual002.jpg    
exp_2023_05_01_13 147 individual 1682975988.5084014 2023-05-01T21:19:48.508401+00:00 show_image individual002.jpg    
exp_2023_05_01_13 147 individual 1682975993.5303445 2023-05-01T21:19:53.530344+00:00 show_rating_screen individual002.jpg    
exp_2023_05_01_13 147 individual 1682975994.5719657 2023-05-01T21:19:54.571966+00:00 intermediate_selection individual002.jpg 0  
exp_2023_05_01_13 147 individual 1682975995.4383206 2023-05-01T21:19:55.438321+00:00 intermediate_selection individual002.jpg   0
exp_2023_05_01_13 147 individual 1682975996.5782726 2023-05-01T21:19:56.578273+00:00 final_submission individual002.jpg 0 0
exp_2023_05_01_13 147 individual 1682975996.6790125 2023-05-01T21:19:56.679013+00:00 show_blank_screen individual003.jpg    
exp_2023_05_01_13 147 individual 1682975997.6902373 2023-05-01T21:19:57.690237+00:00 show_cross_screen individual003.jpg    
exp_2023_05_01_13 147 individual 1682975998.2078683 2023-05-01T21:19:58.207868+00:00 show_image individual003.jpg    
exp_2023_05_01_13 147 individual 1682976003.230376 2023-05-01T21:20:03.230376+00:00 show_rating_screen individual003.jpg    
exp_2023_05_01_13 147 individual 1682976006.426601 2023-05-01T21:20:06.426601+00:00 intermediate_selection individual003.jpg 0  
exp_2023_05_01_13 147 individual 1682976008.4978414 2023-05-01T21:20:08.497841+00:00 intermediate_selection individual003.jpg   1
exp_2023_05_01_13 147 individual 1682976009.4184034 2023-05-01T21:20:09.418403+00:00 final_submission individual003.jpg 0 1
exp_2023_05_01_13 147 individual 1682976009.5191278 2023-05-01T21:20:09.519128+00:00 show_blank_screen individual004.jpg    
exp_2023_05_01_13 147 individual 1682976010.527326 2023-05-01T21:20:10.527326+00:00 show_cross_screen individual004.jpg    
exp_2023_05_01_13 147 individual 1682976011.0442543 2023-05-01T21:20:11.044254+00:00 show_image individual004.jpg    
exp_2023_05_01_13 147 individual 1682976016.0626962 2023-05-01T21:20:16.062696+00:00 show_rating_screen individual004.jpg    
exp_2023_05_01_13 147 individual 1682976019.2290082 2023-05-01T21:20:19.229008+00:00 intermediate_selection individual004.jpg -2  
exp_2023_05_01_13 147 individual 1682976022.5372224 2023-05-01T21:20:22.537222+00:00 intermediate_selection individual004.jpg   1
exp_2023_05_01_13 147 individual 1682976024.3668704 2023-05-01T21:20:24.366870+00:00 intermediate_selection individual004.jpg   0
exp_2023_05_01_13 147 individual 1682976026.297883 2023-05-01T21:20:26.297883+00:00 intermediate_selection individual004.jpg   1
exp_2023_05_01_13 147 individual 1682976027.1562252 2023-05-01T21:20:27.156225+00:00 final_submission individual004.jpg -2 1
exp_2023_05_01_13 147 individual 1682976027.2570748 2023-05-01T21:20:27.257075+00:00 show_blank_screen individual005.jpg    
exp_2023_05_01_13 147 individual 1682976028.273003 2023-05-01T21:20:28.273003+00:00 show_cross_screen individual005.jpg    
exp_2023_05_01_13 147 individual 1682976028.7814655 2023-05-01T21:20:28.781466+00:00 show_image individual005.jpg    
exp_2023_05_01_13 147 individual 1682976033.805172 2023-05-01T21:20:33.805172+00:00 show_rating_screen individual005.jpg    
exp_2023_05_01_13 147 individual 1682976035.0053766 2023-05-01T21:20:35.005377+00:00 intermediate_selection individual005.jpg 1  
exp_2023_05_01_13 147 individual 1682976038.74273 2023-05-01T21:20:38.742730+00:00 intermediate_selection individual005.jpg   -1
exp_2023_05_01_13 147 individual 1682976040.211577 2023-05-01T21:20:40.211577+00:00 final_submission individual005.jpg 1 -1
exp_2023_05_01_13 147 individual 1682976040.3123991 2023-05-01T21:20:40.312399+00:00 show_blank_screen individual006.jpg    
exp_2023_05_01_13 147 individual 1682976041.3361106 2023-05-01T21:20:41.336111+00:00 show_cross_screen individual006.jpg    
exp_2023_05_01_13 147 individual 1682976041.8542638 2023-05-01T21:20:41.854264+00:00 show_image individual006.jpg    
exp_2023_05_01_13 147 individual 1682976046.873695 2023-05-01T21:20:46.873695+00:00 show_rating_screen individual006.jpg    
exp_2023_05_01_13 147 individual 1682976049.5382264 2023-05-01T21:20:49.538226+00:00 intermediate_selection individual006.jpg -1  
exp_2023_05_01_13 147 individual 1682976050.0890555 2023-05-01T21:20:50.089056+00:00 intermediate_selection individual006.jpg -2  
exp_2023_05_01_13 147 individual 1682976055.3797503 2023-05-01T21:20:55.379750+00:00 intermediate_selection individual006.jpg   1
exp_2023_05_01_13 147 individual 1682976056.2039227 2023-05-01T21:20:56.203923+00:00 final_submission individual006.jpg -2 1
exp_2023_05_01_13 147 individual 1682976056.3047066 2023-05-01T21:20:56.304707+00:00 show_blank_screen individual007.jpg    
exp_2023_05_01_13 147 individual 1682976057.311696 2023-05-01T21:20:57.311696+00:00 show_cross_screen individual007.jpg    
exp_2023_05_01_13 147 individual 1682976057.8328185 2023-05-01T21:20:57.832819+00:00 show_image individual007.jpg    
exp_2023_05_01_13 147 individual 1682976062.8591378 2023-05-01T21:21:02.859138+00:00 show_rating_screen individual007.jpg    
exp_2023_05_01_13 147 individual 1682976064.8268664 2023-05-01T21:21:04.826866+00:00 intermediate_selection individual007.jpg 1  
exp_2023_05_01_13 147 individual 1682976066.3330755 2023-05-01T21:21:06.333076+00:00 intermediate_selection individual007.jpg   1
exp_2023_05_01_13 147 individual 1682976067.1566694 2023-05-01T21:21:07.156669+00:00 final_submission individual007.jpg 1 1
exp_2023_05_01_13 147 individual 1682976067.257473 2023-05-01T21:21:07.257473+00:00 show_blank_screen individual008.jpg    
exp_2023_05_01_13 147 individual 1682976068.2815504 2023-05-01T21:21:08.281550+00:00 show_cross_screen individual008.jpg    
exp_2023_05_01_13 147 individual 1682976068.8032353 2023-05-01T21:21:08.803235+00:00 show_image individual008.jpg    
exp_2023_05_01_13 147 individual 1682976073.821791 2023-05-01T21:21:13.821791+00:00 show_rating_screen individual008.jpg    
exp_2023_05_01_13 147 individual 1682976077.0964425 2023-05-01T21:21:17.096442+00:00 intermediate_selection individual008.jpg 0  
exp_2023_05_01_13 147 individual 1682976078.475917 2023-05-01T21:21:18.475917+00:00 intermediate_selection individual008.jpg   1
exp_2023_05_01_13 147 individual 1682976079.564929 2023-05-01T21:21:19.564929+00:00 final_submission individual008.jpg 0 1
exp_2023_05_01_13 147 individual 1682976079.665647 2023-05-01T21:21:19.665647+00:00 show_blank_screen individual009.jpg    
exp_2023_05_01_13 147 individual 1682976080.6746566 2023-05-01T21:21:20.674657+00:00 show_cross_screen individual009.jpg    
exp_2023_05_01_13 147 individual 1682976081.194773 2023-05-01T21:21:21.194773+00:00 show_image individual009.jpg    
exp_2023_05_01_13 147 individual 1682976086.2185774 2023-05-01T21:21:26.218577+00:00 show_rating_screen individual009.jpg    
exp_2023_05_01_13 147 individual 1682976087.152258 2023-05-01T21:21:27.152258+00:00 intermediate_selection individual009.jpg -2  
exp_2023_05_01_13 147 individual 1682976090.4177 2023-05-01T21:21:30.417700+00:00 intermediate_selection individual009.jpg   -1
exp_2023_05_01_13 147 individual 1682976092.0350094 2023-05-01T21:21:32.035009+00:00 intermediate_selection individual009.jpg   1
exp_2023_05_01_13 147 individual 1682976093.2296534 2023-05-01T21:21:33.229653+00:00 final_submission individual009.jpg -2 1
exp_2023_05_01_13 147 individual 1682976093.3302906 2023-05-01T21:21:33.330291+00:00 show_blank_screen individual010.jpg    
exp_2023_05_01_13 147 individual 1682976094.3504066 2023-05-01T21:21:34.350407+00:00 show_cross_screen individual010.jpg    
exp_2023_05_01_13 147 individual 1682976094.8709972 2023-05-01T21:21:34.870997+00:00 show_image individual010.jpg    
exp_2023_05_01_13 147 individual 1682976099.8973565 2023-05-01T21:21:39.897357+00:00 show_rating_screen individual010.jpg    
exp_2023_05_01_13 147 individual 1682976102.6139963 2023-05-01T21:21:42.613996+00:00 intermediate_selection individual010.jpg -1  
exp_2023_05_01_13 147 individual 1682976104.1720545 2023-05-01T21:21:44.172055+00:00 intermediate_selection individual010.jpg   -2
exp_2023_05_01_13 147 individual 1682976105.4458022 2023-05-01T21:21:45.445802+00:00 final_submission individual010.jpg -1 -2
exp_2023_05_01_13 147 individual 1682976105.5464442 2023-05-01T21:21:45.546444+00:00 show_blank_screen individual011.jpg    
exp_2023_05_01_13 147 individual 1682976106.556153 2023-05-01T21:21:46.556153+00:00 show_cross_screen individual011.jpg    
exp_2023_05_01_13 147 individual 1682976107.0753787 2023-05-01T21:21:47.075379+00:00 show_image individual011.jpg    
exp_2023_05_01_13 147 individual 1682976112.0951164 2023-05-01T21:21:52.095116+00:00 show_rating_screen individual011.jpg    
exp_2023_05_01_13 147 individual 1682976116.0262961 2023-05-01T21:21:56.026296+00:00 intermediate_selection individual011.jpg 1  
exp_2023_05_01_13 147 individual 1682976117.678334 2023-05-01T21:21:57.678334+00:00 intermediate_selection individual011.jpg   1
exp_2023_05_01_13 147 individual 1682976118.8545573 2023-05-01T21:21:58.854557+00:00 final_submission individual011.jpg 1 1
exp_2023_05_01_13 147 individual 1682976118.9553819 2023-05-01T21:21:58.955382+00:00 show_blank_screen individual012.jpg    
exp_2023_05_01_13 147 individual 1682976119.978721 2023-05-01T21:21:59.978721+00:00 show_cross_screen individual012.jpg    
exp_2023_05_01_13 147 individual 1682976120.4936247 2023-05-01T21:22:00.493625+00:00 show_image individual012.jpg    
exp_2023_05_01_13 147 individual 1682976125.5181136 2023-05-01T21:22:05.518114+00:00 show_rating_screen individual012.jpg    
exp_2023_05_01_13 147 individual 1682976128.1796756 2023-05-01T21:22:08.179676+00:00 intermediate_selection individual012.jpg 2  
exp_2023_05_01_13 147 individual 1682976130.9344823 2023-05-01T21:22:10.934482+00:00 intermediate_selection individual012.jpg   0
exp_2023_05_01_13 147 individual 1682976132.2693992 2023-05-01T21:22:12.269399+00:00 intermediate_selection individual012.jpg   -1
exp_2023_05_01_13 147 individual 1682976132.6391242 2023-05-01T21:22:12.639124+00:00 intermediate_selection individual012.jpg   -2
exp_2023_05_01_13 147 individual 1682976133.302868 2023-05-01T21:22:13.302868+00:00 final_submission individual012.jpg 2 -2
exp_2023_05_01_13 147 individual 1682976133.4037092 2023-05-01T21:22:13.403709+00:00 show_blank_screen individual013.jpg    

Next page

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