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

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_02_14 158 individual 1683066559.6650856 2023-05-02T22:29:19.665086+00:00 start_affective_task      
exp_2023_05_02_14 158 individual 1683066559.6656306 2023-05-02T22:29:19.665631+00:00 show_blank_screen individual000.jpg    
exp_2023_05_02_14 158 individual 1683066560.687397 2023-05-02T22:29:20.687397+00:00 show_cross_screen individual000.jpg    
exp_2023_05_02_14 158 individual 1683066561.2035894 2023-05-02T22:29:21.203589+00:00 show_image individual000.jpg    
exp_2023_05_02_14 158 individual 1683066566.2325585 2023-05-02T22:29:26.232558+00:00 show_rating_screen individual000.jpg    
exp_2023_05_02_14 158 individual 1683066570.4707997 2023-05-02T22:29:30.470800+00:00 intermediate_selection individual000.jpg 1  
exp_2023_05_02_14 158 individual 1683066573.4029222 2023-05-02T22:29:33.402922+00:00 intermediate_selection individual000.jpg   -1
exp_2023_05_02_14 158 individual 1683066575.5794005 2023-05-02T22:29:35.579401+00:00 intermediate_selection individual000.jpg   0
exp_2023_05_02_14 158 individual 1683066576.2036107 2023-05-02T22:29:36.203611+00:00 final_submission individual000.jpg 1 0
exp_2023_05_02_14 158 individual 1683066576.304183 2023-05-02T22:29:36.304183+00:00 show_blank_screen individual001.jpg    
exp_2023_05_02_14 158 individual 1683066577.32377 2023-05-02T22:29:37.323770+00:00 show_cross_screen individual001.jpg    
exp_2023_05_02_14 158 individual 1683066577.836666 2023-05-02T22:29:37.836666+00:00 show_image individual001.jpg    
exp_2023_05_02_14 158 individual 1683066582.8597264 2023-05-02T22:29:42.859726+00:00 show_rating_screen individual001.jpg    
exp_2023_05_02_14 158 individual 1683066583.8793368 2023-05-02T22:29:43.879337+00:00 intermediate_selection individual001.jpg -1  
exp_2023_05_02_14 158 individual 1683066585.1434906 2023-05-02T22:29:45.143491+00:00 intermediate_selection individual001.jpg   -2
exp_2023_05_02_14 158 individual 1683066587.3237298 2023-05-02T22:29:47.323730+00:00 final_submission individual001.jpg -1 -2
exp_2023_05_02_14 158 individual 1683066587.4242926 2023-05-02T22:29:47.424293+00:00 show_blank_screen individual002.jpg    
exp_2023_05_02_14 158 individual 1683066588.4364965 2023-05-02T22:29:48.436496+00:00 show_cross_screen individual002.jpg    
exp_2023_05_02_14 158 individual 1683066588.956839 2023-05-02T22:29:48.956839+00:00 show_image individual002.jpg    
exp_2023_05_02_14 158 individual 1683066593.9782703 2023-05-02T22:29:53.978270+00:00 show_rating_screen individual002.jpg    
exp_2023_05_02_14 158 individual 1683066594.7093923 2023-05-02T22:29:54.709392+00:00 intermediate_selection individual002.jpg 0  
exp_2023_05_02_14 158 individual 1683066595.4766886 2023-05-02T22:29:55.476689+00:00 intermediate_selection individual002.jpg   0
exp_2023_05_02_14 158 individual 1683066596.1399486 2023-05-02T22:29:56.139949+00:00 final_submission individual002.jpg 0 0
exp_2023_05_02_14 158 individual 1683066596.2405043 2023-05-02T22:29:56.240504+00:00 show_blank_screen individual003.jpg    
exp_2023_05_02_14 158 individual 1683066597.24993 2023-05-02T22:29:57.249930+00:00 show_cross_screen individual003.jpg    
exp_2023_05_02_14 158 individual 1683066597.767906 2023-05-02T22:29:57.767906+00:00 show_image individual003.jpg    
exp_2023_05_02_14 158 individual 1683066602.797118 2023-05-02T22:30:02.797118+00:00 show_rating_screen individual003.jpg    
exp_2023_05_02_14 158 individual 1683066603.7291253 2023-05-02T22:30:03.729125+00:00 intermediate_selection individual003.jpg -2  
exp_2023_05_02_14 158 individual 1683066606.9157133 2023-05-02T22:30:06.915713+00:00 intermediate_selection individual003.jpg   0
exp_2023_05_02_14 158 individual 1683066607.6844673 2023-05-02T22:30:07.684467+00:00 final_submission individual003.jpg -2 0
exp_2023_05_02_14 158 individual 1683066607.7852888 2023-05-02T22:30:07.785289+00:00 show_blank_screen individual004.jpg    
exp_2023_05_02_14 158 individual 1683066608.8010588 2023-05-02T22:30:08.801059+00:00 show_cross_screen individual004.jpg    
exp_2023_05_02_14 158 individual 1683066609.321961 2023-05-02T22:30:09.321961+00:00 show_image individual004.jpg    
exp_2023_05_02_14 158 individual 1683066614.3491488 2023-05-02T22:30:14.349149+00:00 show_rating_screen individual004.jpg    
exp_2023_05_02_14 158 individual 1683066615.455053 2023-05-02T22:30:15.455053+00:00 intermediate_selection individual004.jpg -2  
exp_2023_05_02_14 158 individual 1683066616.4857118 2023-05-02T22:30:16.485712+00:00 intermediate_selection individual004.jpg   1
exp_2023_05_02_14 158 individual 1683066617.1564543 2023-05-02T22:30:17.156454+00:00 final_submission individual004.jpg -2 1
exp_2023_05_02_14 158 individual 1683066617.2571838 2023-05-02T22:30:17.257184+00:00 show_blank_screen individual005.jpg    
exp_2023_05_02_14 158 individual 1683066618.2846658 2023-05-02T22:30:18.284666+00:00 show_cross_screen individual005.jpg    
exp_2023_05_02_14 158 individual 1683066618.8073354 2023-05-02T22:30:18.807335+00:00 show_image individual005.jpg    
exp_2023_05_02_14 158 individual 1683066623.8310978 2023-05-02T22:30:23.831098+00:00 show_rating_screen individual005.jpg    
exp_2023_05_02_14 158 individual 1683066624.8201115 2023-05-02T22:30:24.820112+00:00 intermediate_selection individual005.jpg 2  
exp_2023_05_02_14 158 individual 1683066625.231119 2023-05-02T22:30:25.231119+00:00 intermediate_selection individual005.jpg   2
exp_2023_05_02_14 158 individual 1683066625.820967 2023-05-02T22:30:25.820967+00:00 final_submission individual005.jpg 2 2
exp_2023_05_02_14 158 individual 1683066625.9216406 2023-05-02T22:30:25.921641+00:00 show_blank_screen individual006.jpg    
exp_2023_05_02_14 158 individual 1683066626.9391189 2023-05-02T22:30:26.939119+00:00 show_cross_screen individual006.jpg    
exp_2023_05_02_14 158 individual 1683066627.4559026 2023-05-02T22:30:27.455903+00:00 show_image individual006.jpg    
exp_2023_05_02_14 158 individual 1683066632.4740255 2023-05-02T22:30:32.474025+00:00 show_rating_screen individual006.jpg    
exp_2023_05_02_14 158 individual 1683066633.3383965 2023-05-02T22:30:33.338397+00:00 intermediate_selection individual006.jpg -2  
exp_2023_05_02_14 158 individual 1683066634.2166176 2023-05-02T22:30:34.216618+00:00 intermediate_selection individual006.jpg   0
exp_2023_05_02_14 158 individual 1683066634.5973353 2023-05-02T22:30:34.597335+00:00 final_submission individual006.jpg -2 0
exp_2023_05_02_14 158 individual 1683066634.6980062 2023-05-02T22:30:34.698006+00:00 show_blank_screen individual007.jpg    
exp_2023_05_02_14 158 individual 1683066635.7071564 2023-05-02T22:30:35.707156+00:00 show_cross_screen individual007.jpg    
exp_2023_05_02_14 158 individual 1683066636.229968 2023-05-02T22:30:36.229968+00:00 show_image individual007.jpg    
exp_2023_05_02_14 158 individual 1683066641.2533793 2023-05-02T22:30:41.253379+00:00 show_rating_screen individual007.jpg    
exp_2023_05_02_14 158 individual 1683066642.151057 2023-05-02T22:30:42.151057+00:00 intermediate_selection individual007.jpg 0  
exp_2023_05_02_14 158 individual 1683066642.824788 2023-05-02T22:30:42.824788+00:00 intermediate_selection individual007.jpg   1
exp_2023_05_02_14 158 individual 1683066643.5578132 2023-05-02T22:30:43.557813+00:00 final_submission individual007.jpg 0 1
exp_2023_05_02_14 158 individual 1683066643.6584277 2023-05-02T22:30:43.658428+00:00 show_blank_screen individual008.jpg    
exp_2023_05_02_14 158 individual 1683066644.668001 2023-05-02T22:30:44.668001+00:00 show_cross_screen individual008.jpg    
exp_2023_05_02_14 158 individual 1683066645.1823888 2023-05-02T22:30:45.182389+00:00 show_image individual008.jpg    
exp_2023_05_02_14 158 individual 1683066650.2061012 2023-05-02T22:30:50.206101+00:00 show_rating_screen individual008.jpg    
exp_2023_05_02_14 158 individual 1683066651.1686282 2023-05-02T22:30:51.168628+00:00 intermediate_selection individual008.jpg 0  
exp_2023_05_02_14 158 individual 1683066652.1471987 2023-05-02T22:30:52.147199+00:00 intermediate_selection individual008.jpg   1
exp_2023_05_02_14 158 individual 1683066652.989783 2023-05-02T22:30:52.989783+00:00 final_submission individual008.jpg 0 1
exp_2023_05_02_14 158 individual 1683066653.0903418 2023-05-02T22:30:53.090342+00:00 show_blank_screen individual009.jpg    
exp_2023_05_02_14 158 individual 1683066654.1003222 2023-05-02T22:30:54.100322+00:00 show_cross_screen individual009.jpg    
exp_2023_05_02_14 158 individual 1683066654.6250634 2023-05-02T22:30:54.625063+00:00 show_image individual009.jpg    
exp_2023_05_02_14 158 individual 1683066659.6508398 2023-05-02T22:30:59.650840+00:00 show_rating_screen individual009.jpg    
exp_2023_05_02_14 158 individual 1683066661.0867627 2023-05-02T22:31:01.086763+00:00 intermediate_selection individual009.jpg 0  
exp_2023_05_02_14 158 individual 1683066661.980428 2023-05-02T22:31:01.980428+00:00 intermediate_selection individual009.jpg   2
exp_2023_05_02_14 158 individual 1683066662.6311066 2023-05-02T22:31:02.631107+00:00 intermediate_selection individual009.jpg 1  
exp_2023_05_02_14 158 individual 1683066662.9143038 2023-05-02T22:31:02.914304+00:00 intermediate_selection individual009.jpg   1
exp_2023_05_02_14 158 individual 1683066663.6172569 2023-05-02T22:31:03.617257+00:00 intermediate_selection individual009.jpg   2
exp_2023_05_02_14 158 individual 1683066664.0779755 2023-05-02T22:31:04.077976+00:00 final_submission individual009.jpg 1 2
exp_2023_05_02_14 158 individual 1683066664.1787632 2023-05-02T22:31:04.178763+00:00 show_blank_screen individual010.jpg    
exp_2023_05_02_14 158 individual 1683066665.2021031 2023-05-02T22:31:05.202103+00:00 show_cross_screen individual010.jpg    
exp_2023_05_02_14 158 individual 1683066665.724205 2023-05-02T22:31:05.724205+00:00 show_image individual010.jpg    
exp_2023_05_02_14 158 individual 1683066670.7494016 2023-05-02T22:31:10.749402+00:00 show_rating_screen individual010.jpg    
exp_2023_05_02_14 158 individual 1683066672.909331 2023-05-02T22:31:12.909331+00:00 intermediate_selection individual010.jpg 1  
exp_2023_05_02_14 158 individual 1683066673.7175884 2023-05-02T22:31:13.717588+00:00 intermediate_selection individual010.jpg   0
exp_2023_05_02_14 158 individual 1683066674.2509806 2023-05-02T22:31:14.250981+00:00 intermediate_selection individual010.jpg   -2
exp_2023_05_02_14 158 individual 1683066674.7186685 2023-05-02T22:31:14.718668+00:00 final_submission individual010.jpg 1 -2
exp_2023_05_02_14 158 individual 1683066674.8193567 2023-05-02T22:31:14.819357+00:00 show_blank_screen individual011.jpg    
exp_2023_05_02_14 158 individual 1683066675.8364081 2023-05-02T22:31:15.836408+00:00 show_cross_screen individual011.jpg    
exp_2023_05_02_14 158 individual 1683066676.354575 2023-05-02T22:31:16.354575+00:00 show_image individual011.jpg    
exp_2023_05_02_14 158 individual 1683066681.3744218 2023-05-02T22:31:21.374422+00:00 show_rating_screen individual011.jpg    
exp_2023_05_02_14 158 individual 1683066682.1533635 2023-05-02T22:31:22.153363+00:00 intermediate_selection individual011.jpg 0  
exp_2023_05_02_14 158 individual 1683066682.809064 2023-05-02T22:31:22.809064+00:00 intermediate_selection individual011.jpg   -2
exp_2023_05_02_14 158 individual 1683066683.3430467 2023-05-02T22:31:23.343047+00:00 final_submission individual011.jpg 0 -2
exp_2023_05_02_14 158 individual 1683066683.443848 2023-05-02T22:31:23.443848+00:00 show_blank_screen individual012.jpg    
exp_2023_05_02_14 158 individual 1683066684.458093 2023-05-02T22:31:24.458093+00:00 show_cross_screen individual012.jpg    
exp_2023_05_02_14 158 individual 1683066684.9726963 2023-05-02T22:31:24.972696+00:00 show_image individual012.jpg    
exp_2023_05_02_14 158 individual 1683066689.9991915 2023-05-02T22:31:29.999192+00:00 show_rating_screen individual012.jpg    
exp_2023_05_02_14 158 individual 1683066690.8227706 2023-05-02T22:31:30.822771+00:00 intermediate_selection individual012.jpg 0  
exp_2023_05_02_14 158 individual 1683066691.4750051 2023-05-02T22:31:31.475005+00:00 intermediate_selection individual012.jpg   -1
exp_2023_05_02_14 158 individual 1683066692.75187 2023-05-02T22:31:32.751870+00:00 final_submission individual012.jpg 0 -1
exp_2023_05_02_14 158 individual 1683066692.8524551 2023-05-02T22:31:32.852455+00:00 show_blank_screen individual013.jpg    
exp_2023_05_02_14 158 individual 1683066693.8696275 2023-05-02T22:31:33.869627+00:00 show_cross_screen individual013.jpg    
exp_2023_05_02_14 158 individual 1683066694.3836462 2023-05-02T22:31:34.383646+00:00 show_image 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]);