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 group_session = "exp_2023_04_27_14"

View and edit SQL

Suggested facets: participant, 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_04_27_14 -2 team 1682633873.3254669 2023-04-27T22:17:53.325467+00:00 start_affective_task      
exp_2023_04_27_14 154 individual 1682633618.31577 2023-04-27T22:13:38.315770+00:00 start_affective_task      
exp_2023_04_27_14 154 individual 1682633618.3163307 2023-04-27T22:13:38.316331+00:00 show_blank_screen individual000.jpg    
exp_2023_04_27_14 154 individual 1682633619.3323257 2023-04-27T22:13:39.332326+00:00 show_cross_screen individual000.jpg    
exp_2023_04_27_14 154 individual 1682633619.849396 2023-04-27T22:13:39.849396+00:00 show_image individual000.jpg    
exp_2023_04_27_14 154 individual 1682633624.8710103 2023-04-27T22:13:44.871010+00:00 show_rating_screen individual000.jpg    
exp_2023_04_27_14 154 individual 1682633630.1868114 2023-04-27T22:13:50.186811+00:00 intermediate_selection individual000.jpg 0  
exp_2023_04_27_14 154 individual 1682633631.4587498 2023-04-27T22:13:51.458750+00:00 intermediate_selection individual000.jpg   0
exp_2023_04_27_14 154 individual 1682633632.2113936 2023-04-27T22:13:52.211394+00:00 final_submission individual000.jpg 0 0
exp_2023_04_27_14 154 individual 1682633632.3119786 2023-04-27T22:13:52.311979+00:00 show_blank_screen individual001.jpg    
exp_2023_04_27_14 154 individual 1682633633.3264751 2023-04-27T22:13:53.326475+00:00 show_cross_screen individual001.jpg    
exp_2023_04_27_14 154 individual 1682633633.8489227 2023-04-27T22:13:53.848923+00:00 show_image individual001.jpg    
exp_2023_04_27_14 154 individual 1682633638.8740451 2023-04-27T22:13:58.874045+00:00 show_rating_screen individual001.jpg    
exp_2023_04_27_14 154 individual 1682633640.307582 2023-04-27T22:14:00.307582+00:00 intermediate_selection individual001.jpg 1  
exp_2023_04_27_14 154 individual 1682633641.9499722 2023-04-27T22:14:01.949972+00:00 intermediate_selection individual001.jpg   1
exp_2023_04_27_14 154 individual 1682633642.811796 2023-04-27T22:14:02.811796+00:00 final_submission individual001.jpg 1 1
exp_2023_04_27_14 154 individual 1682633642.9124596 2023-04-27T22:14:02.912460+00:00 show_blank_screen individual002.jpg    
exp_2023_04_27_14 154 individual 1682633643.9216363 2023-04-27T22:14:03.921636+00:00 show_cross_screen individual002.jpg    
exp_2023_04_27_14 154 individual 1682633644.4318702 2023-04-27T22:14:04.431870+00:00 show_image individual002.jpg    
exp_2023_04_27_14 154 individual 1682633649.4461236 2023-04-27T22:14:09.446124+00:00 show_rating_screen individual002.jpg    
exp_2023_04_27_14 154 individual 1682633650.6295333 2023-04-27T22:14:10.629533+00:00 intermediate_selection individual002.jpg 0  
exp_2023_04_27_14 154 individual 1682633651.4243243 2023-04-27T22:14:11.424324+00:00 intermediate_selection individual002.jpg   0
exp_2023_04_27_14 154 individual 1682633652.1163661 2023-04-27T22:14:12.116366+00:00 final_submission individual002.jpg 0 0
exp_2023_04_27_14 154 individual 1682633652.2170718 2023-04-27T22:14:12.217072+00:00 show_blank_screen individual003.jpg    
exp_2023_04_27_14 154 individual 1682633653.2278993 2023-04-27T22:14:13.227899+00:00 show_cross_screen individual003.jpg    
exp_2023_04_27_14 154 individual 1682633653.743139 2023-04-27T22:14:13.743139+00:00 show_image individual003.jpg    
exp_2023_04_27_14 154 individual 1682633658.7644312 2023-04-27T22:14:18.764431+00:00 show_rating_screen individual003.jpg    
exp_2023_04_27_14 154 individual 1682633661.0586076 2023-04-27T22:14:21.058608+00:00 intermediate_selection individual003.jpg -1  
exp_2023_04_27_14 154 individual 1682633665.840694 2023-04-27T22:14:25.840694+00:00 intermediate_selection individual003.jpg   0
exp_2023_04_27_14 154 individual 1682633666.7483454 2023-04-27T22:14:26.748345+00:00 final_submission individual003.jpg -1 0
exp_2023_04_27_14 154 individual 1682633666.8489747 2023-04-27T22:14:26.848975+00:00 show_blank_screen individual004.jpg    
exp_2023_04_27_14 154 individual 1682633667.862386 2023-04-27T22:14:27.862386+00:00 show_cross_screen individual004.jpg    
exp_2023_04_27_14 154 individual 1682633668.3887348 2023-04-27T22:14:28.388735+00:00 show_image individual004.jpg    
exp_2023_04_27_14 154 individual 1682633673.4096284 2023-04-27T22:14:33.409628+00:00 show_rating_screen individual004.jpg    
exp_2023_04_27_14 154 individual 1682633676.260875 2023-04-27T22:14:36.260875+00:00 intermediate_selection individual004.jpg -1  
exp_2023_04_27_14 154 individual 1682633684.1631446 2023-04-27T22:14:44.163145+00:00 intermediate_selection individual004.jpg   1
exp_2023_04_27_14 154 individual 1682633685.3706038 2023-04-27T22:14:45.370604+00:00 final_submission individual004.jpg -1 1
exp_2023_04_27_14 154 individual 1682633685.4713204 2023-04-27T22:14:45.471320+00:00 show_blank_screen individual005.jpg    
exp_2023_04_27_14 154 individual 1682633686.4915628 2023-04-27T22:14:46.491563+00:00 show_cross_screen individual005.jpg    
exp_2023_04_27_14 154 individual 1682633687.0075877 2023-04-27T22:14:47.007588+00:00 show_image individual005.jpg    
exp_2023_04_27_14 154 individual 1682633692.0258512 2023-04-27T22:14:52.025851+00:00 show_rating_screen individual005.jpg    
exp_2023_04_27_14 154 individual 1682633694.080725 2023-04-27T22:14:54.080725+00:00 intermediate_selection individual005.jpg 0  
exp_2023_04_27_14 154 individual 1682633694.6860635 2023-04-27T22:14:54.686064+00:00 intermediate_selection individual005.jpg   0
exp_2023_04_27_14 154 individual 1682633695.3015187 2023-04-27T22:14:55.301519+00:00 final_submission individual005.jpg 0 0
exp_2023_04_27_14 154 individual 1682633695.4022381 2023-04-27T22:14:55.402238+00:00 show_blank_screen individual006.jpg    
exp_2023_04_27_14 154 individual 1682633696.4116883 2023-04-27T22:14:56.411688+00:00 show_cross_screen individual006.jpg    
exp_2023_04_27_14 154 individual 1682633696.9288807 2023-04-27T22:14:56.928881+00:00 show_image individual006.jpg    
exp_2023_04_27_14 154 individual 1682633701.944099 2023-04-27T22:15:01.944099+00:00 show_rating_screen individual006.jpg    
exp_2023_04_27_14 154 individual 1682633705.103917 2023-04-27T22:15:05.103917+00:00 intermediate_selection individual006.jpg -2  
exp_2023_04_27_14 154 individual 1682633711.30971 2023-04-27T22:15:11.309710+00:00 intermediate_selection individual006.jpg   0
exp_2023_04_27_14 154 individual 1682633711.938383 2023-04-27T22:15:11.938383+00:00 intermediate_selection individual006.jpg   1
exp_2023_04_27_14 154 individual 1682633712.8164163 2023-04-27T22:15:12.816416+00:00 final_submission individual006.jpg -2 1
exp_2023_04_27_14 154 individual 1682633712.917232 2023-04-27T22:15:12.917232+00:00 show_blank_screen individual007.jpg    
exp_2023_04_27_14 154 individual 1682633713.9317577 2023-04-27T22:15:13.931758+00:00 show_cross_screen individual007.jpg    
exp_2023_04_27_14 154 individual 1682633714.4407053 2023-04-27T22:15:14.440705+00:00 show_image individual007.jpg    
exp_2023_04_27_14 154 individual 1682633719.462161 2023-04-27T22:15:19.462161+00:00 show_rating_screen individual007.jpg    
exp_2023_04_27_14 154 individual 1682633722.0200517 2023-04-27T22:15:22.020052+00:00 intermediate_selection individual007.jpg 0  
exp_2023_04_27_14 154 individual 1682633722.5276659 2023-04-27T22:15:22.527666+00:00 intermediate_selection individual007.jpg   0
exp_2023_04_27_14 154 individual 1682633723.070273 2023-04-27T22:15:23.070273+00:00 final_submission individual007.jpg 0 0
exp_2023_04_27_14 154 individual 1682633723.1708782 2023-04-27T22:15:23.170878+00:00 show_blank_screen individual008.jpg    
exp_2023_04_27_14 154 individual 1682633724.1833045 2023-04-27T22:15:24.183305+00:00 show_cross_screen individual008.jpg    
exp_2023_04_27_14 154 individual 1682633724.6965063 2023-04-27T22:15:24.696506+00:00 show_image individual008.jpg    
exp_2023_04_27_14 154 individual 1682633729.7161086 2023-04-27T22:15:29.716109+00:00 show_rating_screen individual008.jpg    
exp_2023_04_27_14 154 individual 1682633730.6221156 2023-04-27T22:15:30.622116+00:00 intermediate_selection individual008.jpg -1  
exp_2023_04_27_14 154 individual 1682633731.1358278 2023-04-27T22:15:31.135828+00:00 intermediate_selection individual008.jpg   0
exp_2023_04_27_14 154 individual 1682633731.6230702 2023-04-27T22:15:31.623070+00:00 final_submission individual008.jpg -1 0
exp_2023_04_27_14 154 individual 1682633731.7236438 2023-04-27T22:15:31.723644+00:00 show_blank_screen individual009.jpg    
exp_2023_04_27_14 154 individual 1682633732.7398329 2023-04-27T22:15:32.739833+00:00 show_cross_screen individual009.jpg    
exp_2023_04_27_14 154 individual 1682633733.2616105 2023-04-27T22:15:33.261611+00:00 show_image individual009.jpg    
exp_2023_04_27_14 154 individual 1682633738.2821255 2023-04-27T22:15:38.282125+00:00 show_rating_screen individual009.jpg    
exp_2023_04_27_14 154 individual 1682633741.2975898 2023-04-27T22:15:41.297590+00:00 intermediate_selection individual009.jpg -1  
exp_2023_04_27_14 154 individual 1682633742.6647036 2023-04-27T22:15:42.664704+00:00 intermediate_selection individual009.jpg   1
exp_2023_04_27_14 154 individual 1682633743.5751214 2023-04-27T22:15:43.575121+00:00 final_submission individual009.jpg -1 1
exp_2023_04_27_14 154 individual 1682633743.6758988 2023-04-27T22:15:43.675899+00:00 show_blank_screen individual010.jpg    
exp_2023_04_27_14 154 individual 1682633744.7000415 2023-04-27T22:15:44.700042+00:00 show_cross_screen individual010.jpg    
exp_2023_04_27_14 154 individual 1682633745.2255492 2023-04-27T22:15:45.225549+00:00 show_image individual010.jpg    
exp_2023_04_27_14 154 individual 1682633750.25093 2023-04-27T22:15:50.250930+00:00 show_rating_screen individual010.jpg    
exp_2023_04_27_14 154 individual 1682633752.3510325 2023-04-27T22:15:52.351032+00:00 intermediate_selection individual010.jpg 1  
exp_2023_04_27_14 154 individual 1682633753.0658774 2023-04-27T22:15:53.065877+00:00 intermediate_selection individual010.jpg   1
exp_2023_04_27_14 154 individual 1682633753.94344 2023-04-27T22:15:53.943440+00:00 final_submission individual010.jpg 1 1
exp_2023_04_27_14 154 individual 1682633754.0439937 2023-04-27T22:15:54.043994+00:00 show_blank_screen individual011.jpg    
exp_2023_04_27_14 154 individual 1682633755.062752 2023-04-27T22:15:55.062752+00:00 show_cross_screen individual011.jpg    
exp_2023_04_27_14 154 individual 1682633755.587783 2023-04-27T22:15:55.587783+00:00 show_image individual011.jpg    
exp_2023_04_27_14 154 individual 1682633760.6057026 2023-04-27T22:16:00.605703+00:00 show_rating_screen individual011.jpg    
exp_2023_04_27_14 154 individual 1682633762.162707 2023-04-27T22:16:02.162707+00:00 intermediate_selection individual011.jpg 0  
exp_2023_04_27_14 154 individual 1682633762.4748244 2023-04-27T22:16:02.474824+00:00 intermediate_selection individual011.jpg   0
exp_2023_04_27_14 154 individual 1682633762.8316908 2023-04-27T22:16:02.831691+00:00 final_submission individual011.jpg 0 0
exp_2023_04_27_14 154 individual 1682633762.9322305 2023-04-27T22:16:02.932230+00:00 show_blank_screen individual012.jpg    
exp_2023_04_27_14 154 individual 1682633763.946857 2023-04-27T22:16:03.946857+00:00 show_cross_screen individual012.jpg    
exp_2023_04_27_14 154 individual 1682633764.466714 2023-04-27T22:16:04.466714+00:00 show_image individual012.jpg    
exp_2023_04_27_14 154 individual 1682633769.4833345 2023-04-27T22:16:09.483335+00:00 show_rating_screen individual012.jpg    
exp_2023_04_27_14 154 individual 1682633773.193015 2023-04-27T22:16:13.193015+00:00 intermediate_selection individual012.jpg 0  
exp_2023_04_27_14 154 individual 1682633774.6872127 2023-04-27T22:16:14.687213+00:00 intermediate_selection individual012.jpg   -1
exp_2023_04_27_14 154 individual 1682633775.9121575 2023-04-27T22:16:15.912158+00:00 final_submission individual012.jpg 0 -1
exp_2023_04_27_14 154 individual 1682633776.012944 2023-04-27T22:16:16.012944+00:00 show_blank_screen individual013.jpg    
exp_2023_04_27_14 154 individual 1682633777.0350754 2023-04-27T22:16:17.035075+00:00 show_cross_screen individual013.jpg    
exp_2023_04_27_14 154 individual 1682633777.5488281 2023-04-27T22:16:17.548828+00:00 show_image individual013.jpg    
exp_2023_04_27_14 154 individual 1682633782.566267 2023-04-27T22:16:22.566267+00:00 show_rating_screen individual013.jpg    
exp_2023_04_27_14 154 individual 1682633785.66656 2023-04-27T22:16:25.666560+00:00 intermediate_selection individual013.jpg 0  
exp_2023_04_27_14 154 individual 1682633786.3561773 2023-04-27T22:16:26.356177+00:00 intermediate_selection individual013.jpg   0

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