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

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_04_17_13 131 individual 1681767188.6992226 2023-04-17T21:33:08.699223+00:00 start_affective_task      
exp_2023_04_17_13 131 individual 1681767188.6998317 2023-04-17T21:33:08.699832+00:00 show_blank_screen individual000.jpg    
exp_2023_04_17_13 131 individual 1681767189.714525 2023-04-17T21:33:09.714525+00:00 show_cross_screen individual000.jpg    
exp_2023_04_17_13 131 individual 1681767190.2357955 2023-04-17T21:33:10.235795+00:00 show_image individual000.jpg    
exp_2023_04_17_13 131 individual 1681767195.2587905 2023-04-17T21:33:15.258790+00:00 show_rating_screen individual000.jpg    
exp_2023_04_17_13 131 individual 1681767200.5708368 2023-04-17T21:33:20.570837+00:00 intermediate_selection individual000.jpg 0  
exp_2023_04_17_13 131 individual 1681767203.2515767 2023-04-17T21:33:23.251577+00:00 intermediate_selection individual000.jpg   -2
exp_2023_04_17_13 131 individual 1681767204.6416442 2023-04-17T21:33:24.641644+00:00 final_submission individual000.jpg 0 -2
exp_2023_04_17_13 131 individual 1681767204.7424889 2023-04-17T21:33:24.742489+00:00 show_blank_screen individual001.jpg    
exp_2023_04_17_13 131 individual 1681767205.7507322 2023-04-17T21:33:25.750732+00:00 show_cross_screen individual001.jpg    
exp_2023_04_17_13 131 individual 1681767206.2737985 2023-04-17T21:33:26.273798+00:00 show_image individual001.jpg    
exp_2023_04_17_13 131 individual 1681767211.2988746 2023-04-17T21:33:31.298875+00:00 show_rating_screen individual001.jpg    
exp_2023_04_17_13 131 individual 1681767213.7261655 2023-04-17T21:33:33.726166+00:00 intermediate_selection individual001.jpg 2  
exp_2023_04_17_13 131 individual 1681767215.4486268 2023-04-17T21:33:35.448627+00:00 intermediate_selection individual001.jpg   1
exp_2023_04_17_13 131 individual 1681767216.6897228 2023-04-17T21:33:36.689723+00:00 final_submission individual001.jpg 2 1
exp_2023_04_17_13 131 individual 1681767216.7902803 2023-04-17T21:33:36.790280+00:00 show_blank_screen individual002.jpg    
exp_2023_04_17_13 131 individual 1681767217.8101044 2023-04-17T21:33:37.810104+00:00 show_cross_screen individual002.jpg    
exp_2023_04_17_13 131 individual 1681767218.3382106 2023-04-17T21:33:38.338211+00:00 show_image individual002.jpg    
exp_2023_04_17_13 131 individual 1681767223.364459 2023-04-17T21:33:43.364459+00:00 show_rating_screen individual002.jpg    
exp_2023_04_17_13 131 individual 1681767226.408412 2023-04-17T21:33:46.408412+00:00 intermediate_selection individual002.jpg 0  
exp_2023_04_17_13 131 individual 1681767228.3302593 2023-04-17T21:33:48.330259+00:00 intermediate_selection individual002.jpg   -2
exp_2023_04_17_13 131 individual 1681767229.1780543 2023-04-17T21:33:49.178054+00:00 final_submission individual002.jpg 0 -2
exp_2023_04_17_13 131 individual 1681767229.2787619 2023-04-17T21:33:49.278762+00:00 show_blank_screen individual003.jpg    
exp_2023_04_17_13 131 individual 1681767230.292321 2023-04-17T21:33:50.292321+00:00 show_cross_screen individual003.jpg    
exp_2023_04_17_13 131 individual 1681767230.817765 2023-04-17T21:33:50.817765+00:00 show_image individual003.jpg    
exp_2023_04_17_13 131 individual 1681767235.8443758 2023-04-17T21:33:55.844376+00:00 show_rating_screen individual003.jpg    
exp_2023_04_17_13 131 individual 1681767237.0619357 2023-04-17T21:33:57.061936+00:00 intermediate_selection individual003.jpg -2  
exp_2023_04_17_13 131 individual 1681767239.0153527 2023-04-17T21:33:59.015353+00:00 intermediate_selection individual003.jpg   0
exp_2023_04_17_13 131 individual 1681767239.6122873 2023-04-17T21:33:59.612287+00:00 intermediate_selection individual003.jpg   1
exp_2023_04_17_13 131 individual 1681767242.844583 2023-04-17T21:34:02.844583+00:00 intermediate_selection individual003.jpg   2
exp_2023_04_17_13 131 individual 1681767243.5547364 2023-04-17T21:34:03.554736+00:00 final_submission individual003.jpg -2 2
exp_2023_04_17_13 131 individual 1681767243.6553705 2023-04-17T21:34:03.655370+00:00 show_blank_screen individual004.jpg    
exp_2023_04_17_13 131 individual 1681767244.672814 2023-04-17T21:34:04.672814+00:00 show_cross_screen individual004.jpg    
exp_2023_04_17_13 131 individual 1681767245.1950102 2023-04-17T21:34:05.195010+00:00 show_image individual004.jpg    
exp_2023_04_17_13 131 individual 1681767250.217257 2023-04-17T21:34:10.217257+00:00 show_rating_screen individual004.jpg    
exp_2023_04_17_13 131 individual 1681767251.9403224 2023-04-17T21:34:11.940322+00:00 intermediate_selection individual004.jpg -2  
exp_2023_04_17_13 131 individual 1681767253.3813038 2023-04-17T21:34:13.381304+00:00 intermediate_selection individual004.jpg   0
exp_2023_04_17_13 131 individual 1681767253.7843707 2023-04-17T21:34:13.784371+00:00 intermediate_selection individual004.jpg   1
exp_2023_04_17_13 131 individual 1681767254.4832523 2023-04-17T21:34:14.483252+00:00 final_submission individual004.jpg -2 1
exp_2023_04_17_13 131 individual 1681767254.5838256 2023-04-17T21:34:14.583826+00:00 show_blank_screen individual005.jpg    
exp_2023_04_17_13 131 individual 1681767255.6015544 2023-04-17T21:34:15.601554+00:00 show_cross_screen individual005.jpg    
exp_2023_04_17_13 131 individual 1681767256.1196039 2023-04-17T21:34:16.119604+00:00 show_image individual005.jpg    
exp_2023_04_17_13 131 individual 1681767261.138144 2023-04-17T21:34:21.138144+00:00 show_rating_screen individual005.jpg    
exp_2023_04_17_13 131 individual 1681767262.5353665 2023-04-17T21:34:22.535367+00:00 intermediate_selection individual005.jpg 0  
exp_2023_04_17_13 131 individual 1681767263.634659 2023-04-17T21:34:23.634659+00:00 intermediate_selection individual005.jpg   -2
exp_2023_04_17_13 131 individual 1681767264.7954538 2023-04-17T21:34:24.795454+00:00 final_submission individual005.jpg 0 -2
exp_2023_04_17_13 131 individual 1681767264.8962011 2023-04-17T21:34:24.896201+00:00 show_blank_screen individual006.jpg    
exp_2023_04_17_13 131 individual 1681767265.9101572 2023-04-17T21:34:25.910157+00:00 show_cross_screen individual006.jpg    
exp_2023_04_17_13 131 individual 1681767266.4363139 2023-04-17T21:34:26.436314+00:00 show_image individual006.jpg    
exp_2023_04_17_13 131 individual 1681767271.4629173 2023-04-17T21:34:31.462917+00:00 show_rating_screen individual006.jpg    
exp_2023_04_17_13 131 individual 1681767273.0924091 2023-04-17T21:34:33.092409+00:00 intermediate_selection individual006.jpg -2  
exp_2023_04_17_13 131 individual 1681767274.66383 2023-04-17T21:34:34.663830+00:00 intermediate_selection individual006.jpg   2
exp_2023_04_17_13 131 individual 1681767275.4996376 2023-04-17T21:34:35.499638+00:00 final_submission individual006.jpg -2 2
exp_2023_04_17_13 131 individual 1681767275.6002188 2023-04-17T21:34:35.600219+00:00 show_blank_screen individual007.jpg    
exp_2023_04_17_13 131 individual 1681767276.6084878 2023-04-17T21:34:36.608488+00:00 show_cross_screen individual007.jpg    
exp_2023_04_17_13 131 individual 1681767277.1242814 2023-04-17T21:34:37.124281+00:00 show_image individual007.jpg    
exp_2023_04_17_13 131 individual 1681767282.1442285 2023-04-17T21:34:42.144228+00:00 show_rating_screen individual007.jpg    
exp_2023_04_17_13 131 individual 1681767283.5923557 2023-04-17T21:34:43.592356+00:00 intermediate_selection individual007.jpg 1  
exp_2023_04_17_13 131 individual 1681767285.1801648 2023-04-17T21:34:45.180165+00:00 intermediate_selection individual007.jpg   0
exp_2023_04_17_13 131 individual 1681767285.7642095 2023-04-17T21:34:45.764210+00:00 final_submission individual007.jpg 1 0
exp_2023_04_17_13 131 individual 1681767285.864718 2023-04-17T21:34:45.864718+00:00 show_blank_screen individual008.jpg    
exp_2023_04_17_13 131 individual 1681767286.8760407 2023-04-17T21:34:46.876041+00:00 show_cross_screen individual008.jpg    
exp_2023_04_17_13 131 individual 1681767287.402673 2023-04-17T21:34:47.402673+00:00 show_image individual008.jpg    
exp_2023_04_17_13 131 individual 1681767292.430146 2023-04-17T21:34:52.430146+00:00 show_rating_screen individual008.jpg    
exp_2023_04_17_13 131 individual 1681767294.0303693 2023-04-17T21:34:54.030369+00:00 intermediate_selection individual008.jpg -1  
exp_2023_04_17_13 131 individual 1681767295.0609741 2023-04-17T21:34:55.060974+00:00 intermediate_selection individual008.jpg   1
exp_2023_04_17_13 131 individual 1681767295.652505 2023-04-17T21:34:55.652505+00:00 final_submission individual008.jpg -1 1
exp_2023_04_17_13 131 individual 1681767295.7532108 2023-04-17T21:34:55.753211+00:00 show_blank_screen individual009.jpg    
exp_2023_04_17_13 131 individual 1681767296.7699385 2023-04-17T21:34:56.769938+00:00 show_cross_screen individual009.jpg    
exp_2023_04_17_13 131 individual 1681767297.2843041 2023-04-17T21:34:57.284304+00:00 show_image individual009.jpg    
exp_2023_04_17_13 131 individual 1681767302.305106 2023-04-17T21:35:02.305106+00:00 show_rating_screen individual009.jpg    
exp_2023_04_17_13 131 individual 1681767303.0468597 2023-04-17T21:35:03.046860+00:00 intermediate_selection individual009.jpg -2  
exp_2023_04_17_13 131 individual 1681767303.9821093 2023-04-17T21:35:03.982109+00:00 intermediate_selection individual009.jpg   1
exp_2023_04_17_13 131 individual 1681767304.8853514 2023-04-17T21:35:04.885351+00:00 final_submission individual009.jpg -2 1
exp_2023_04_17_13 131 individual 1681767304.9858603 2023-04-17T21:35:04.985860+00:00 show_blank_screen individual010.jpg    
exp_2023_04_17_13 131 individual 1681767306.0099218 2023-04-17T21:35:06.009922+00:00 show_cross_screen individual010.jpg    
exp_2023_04_17_13 131 individual 1681767306.5213454 2023-04-17T21:35:06.521345+00:00 show_image individual010.jpg    
exp_2023_04_17_13 131 individual 1681767311.5513897 2023-04-17T21:35:11.551390+00:00 show_rating_screen individual010.jpg    
exp_2023_04_17_13 131 individual 1681767315.6177242 2023-04-17T21:35:15.617724+00:00 intermediate_selection individual010.jpg 2  
exp_2023_04_17_13 131 individual 1681767316.4298377 2023-04-17T21:35:16.429838+00:00 intermediate_selection individual010.jpg   1
exp_2023_04_17_13 131 individual 1681767317.4054804 2023-04-17T21:35:17.405480+00:00 final_submission individual010.jpg 2 1
exp_2023_04_17_13 131 individual 1681767317.5062685 2023-04-17T21:35:17.506269+00:00 show_blank_screen individual011.jpg    
exp_2023_04_17_13 131 individual 1681767318.5244389 2023-04-17T21:35:18.524439+00:00 show_cross_screen individual011.jpg    
exp_2023_04_17_13 131 individual 1681767319.0364509 2023-04-17T21:35:19.036451+00:00 show_image individual011.jpg    
exp_2023_04_17_13 131 individual 1681767324.0556147 2023-04-17T21:35:24.055615+00:00 show_rating_screen individual011.jpg    
exp_2023_04_17_13 131 individual 1681767325.6593373 2023-04-17T21:35:25.659337+00:00 intermediate_selection individual011.jpg 0  
exp_2023_04_17_13 131 individual 1681767326.6374595 2023-04-17T21:35:26.637460+00:00 intermediate_selection individual011.jpg   0
exp_2023_04_17_13 131 individual 1681767328.3173268 2023-04-17T21:35:28.317327+00:00 final_submission individual011.jpg 0 0
exp_2023_04_17_13 131 individual 1681767328.4178755 2023-04-17T21:35:28.417876+00:00 show_blank_screen individual012.jpg    
exp_2023_04_17_13 131 individual 1681767329.4366882 2023-04-17T21:35:29.436688+00:00 show_cross_screen individual012.jpg    
exp_2023_04_17_13 131 individual 1681767329.9520254 2023-04-17T21:35:29.952025+00:00 show_image individual012.jpg    
exp_2023_04_17_13 131 individual 1681767334.980187 2023-04-17T21:35:34.980187+00:00 show_rating_screen individual012.jpg    
exp_2023_04_17_13 131 individual 1681767335.7907183 2023-04-17T21:35:35.790718+00:00 intermediate_selection individual012.jpg 1  
exp_2023_04_17_13 131 individual 1681767338.2577732 2023-04-17T21:35:38.257773+00:00 intermediate_selection individual012.jpg   -2
exp_2023_04_17_13 131 individual 1681767338.8616838 2023-04-17T21:35:38.861684+00:00 final_submission individual012.jpg 1 -2
exp_2023_04_17_13 131 individual 1681767338.9623885 2023-04-17T21:35:38.962389+00:00 show_blank_screen individual013.jpg    
exp_2023_04_17_13 131 individual 1681767339.9812102 2023-04-17T21:35:39.981210+00:00 show_cross_screen individual013.jpg    
exp_2023_04_17_13 131 individual 1681767340.5041137 2023-04-17T21:35:40.504114+00:00 show_image individual013.jpg    
exp_2023_04_17_13 131 individual 1681767345.530233 2023-04-17T21:35:45.530233+00:00 show_rating_screen individual013.jpg    
exp_2023_04_17_13 131 individual 1681767347.4878125 2023-04-17T21:35:47.487813+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]);