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

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_28_10 144 individual 1682706142.6541078 2023-04-28T18:22:22.654108+00:00 start_affective_task      
exp_2023_04_28_10 144 individual 1682706142.6546 2023-04-28T18:22:22.654600+00:00 show_blank_screen individual000.jpg    
exp_2023_04_28_10 144 individual 1682706143.6746938 2023-04-28T18:22:23.674694+00:00 show_cross_screen individual000.jpg    
exp_2023_04_28_10 144 individual 1682706144.1894386 2023-04-28T18:22:24.189439+00:00 show_image individual000.jpg    
exp_2023_04_28_10 144 individual 1682706149.2261076 2023-04-28T18:22:29.226108+00:00 show_rating_screen individual000.jpg    
exp_2023_04_28_10 144 individual 1682706153.8037822 2023-04-28T18:22:33.803782+00:00 intermediate_selection individual000.jpg 1  
exp_2023_04_28_10 144 individual 1682706160.1969922 2023-04-28T18:22:40.196992+00:00 intermediate_selection individual000.jpg   -1
exp_2023_04_28_10 144 individual 1682706161.2293935 2023-04-28T18:22:41.229393+00:00 final_submission individual000.jpg 1 -1
exp_2023_04_28_10 144 individual 1682706161.330216 2023-04-28T18:22:41.330216+00:00 show_blank_screen individual001.jpg    
exp_2023_04_28_10 144 individual 1682706162.3415854 2023-04-28T18:22:42.341585+00:00 show_cross_screen individual001.jpg    
exp_2023_04_28_10 144 individual 1682706162.856099 2023-04-28T18:22:42.856099+00:00 show_image individual001.jpg    
exp_2023_04_28_10 144 individual 1682706167.8759747 2023-04-28T18:22:47.875975+00:00 show_rating_screen individual001.jpg    
exp_2023_04_28_10 144 individual 1682706169.7331302 2023-04-28T18:22:49.733130+00:00 intermediate_selection individual001.jpg 1  
exp_2023_04_28_10 144 individual 1682706172.4692073 2023-04-28T18:22:52.469207+00:00 intermediate_selection individual001.jpg   0
exp_2023_04_28_10 144 individual 1682706175.6453083 2023-04-28T18:22:55.645308+00:00 final_submission individual001.jpg 1 0
exp_2023_04_28_10 144 individual 1682706175.7460327 2023-04-28T18:22:55.746033+00:00 show_blank_screen individual002.jpg    
exp_2023_04_28_10 144 individual 1682706176.7547698 2023-04-28T18:22:56.754770+00:00 show_cross_screen individual002.jpg    
exp_2023_04_28_10 144 individual 1682706177.2753499 2023-04-28T18:22:57.275350+00:00 show_image individual002.jpg    
exp_2023_04_28_10 144 individual 1682706182.2961113 2023-04-28T18:23:02.296111+00:00 show_rating_screen individual002.jpg    
exp_2023_04_28_10 144 individual 1682706183.8371515 2023-04-28T18:23:03.837152+00:00 intermediate_selection individual002.jpg 1  
exp_2023_04_28_10 144 individual 1682706186.4222806 2023-04-28T18:23:06.422281+00:00 intermediate_selection individual002.jpg   -1
exp_2023_04_28_10 144 individual 1682706187.341521 2023-04-28T18:23:07.341521+00:00 final_submission individual002.jpg 1 -1
exp_2023_04_28_10 144 individual 1682706187.4424927 2023-04-28T18:23:07.442493+00:00 show_blank_screen individual003.jpg    
exp_2023_04_28_10 144 individual 1682706188.4675422 2023-04-28T18:23:08.467542+00:00 show_cross_screen individual003.jpg    
exp_2023_04_28_10 144 individual 1682706188.9828508 2023-04-28T18:23:08.982851+00:00 show_image individual003.jpg    
exp_2023_04_28_10 144 individual 1682706194.008909 2023-04-28T18:23:14.008909+00:00 show_rating_screen individual003.jpg    
exp_2023_04_28_10 144 individual 1682706195.8620284 2023-04-28T18:23:15.862028+00:00 intermediate_selection individual003.jpg -2  
exp_2023_04_28_10 144 individual 1682706198.508122 2023-04-28T18:23:18.508122+00:00 intermediate_selection individual003.jpg   2
exp_2023_04_28_10 144 individual 1682706199.6539793 2023-04-28T18:23:19.653979+00:00 final_submission individual003.jpg -2 2
exp_2023_04_28_10 144 individual 1682706199.7547007 2023-04-28T18:23:19.754701+00:00 show_blank_screen individual004.jpg    
exp_2023_04_28_10 144 individual 1682706200.7654908 2023-04-28T18:23:20.765491+00:00 show_cross_screen individual004.jpg    
exp_2023_04_28_10 144 individual 1682706201.2796848 2023-04-28T18:23:21.279685+00:00 show_image individual004.jpg    
exp_2023_04_28_10 144 individual 1682706206.3001113 2023-04-28T18:23:26.300111+00:00 show_rating_screen individual004.jpg    
exp_2023_04_28_10 144 individual 1682706208.407094 2023-04-28T18:23:28.407094+00:00 intermediate_selection individual004.jpg -2  
exp_2023_04_28_10 144 individual 1682706213.222493 2023-04-28T18:23:33.222493+00:00 intermediate_selection individual004.jpg   -1
exp_2023_04_28_10 144 individual 1682706214.3732457 2023-04-28T18:23:34.373246+00:00 intermediate_selection individual004.jpg   1
exp_2023_04_28_10 144 individual 1682706216.3662932 2023-04-28T18:23:36.366293+00:00 final_submission individual004.jpg -2 1
exp_2023_04_28_10 144 individual 1682706216.4671001 2023-04-28T18:23:36.467100+00:00 show_blank_screen individual005.jpg    
exp_2023_04_28_10 144 individual 1682706217.4750109 2023-04-28T18:23:37.475011+00:00 show_cross_screen individual005.jpg    
exp_2023_04_28_10 144 individual 1682706217.99286 2023-04-28T18:23:37.992860+00:00 show_image individual005.jpg    
exp_2023_04_28_10 144 individual 1682706223.010526 2023-04-28T18:23:43.010526+00:00 show_rating_screen individual005.jpg    
exp_2023_04_28_10 144 individual 1682706224.3670304 2023-04-28T18:23:44.367030+00:00 intermediate_selection individual005.jpg 1  
exp_2023_04_28_10 144 individual 1682706225.056763 2023-04-28T18:23:45.056763+00:00 intermediate_selection individual005.jpg   0
exp_2023_04_28_10 144 individual 1682706226.070822 2023-04-28T18:23:46.070822+00:00 final_submission individual005.jpg 1 0
exp_2023_04_28_10 144 individual 1682706226.1715076 2023-04-28T18:23:46.171508+00:00 show_blank_screen individual006.jpg    
exp_2023_04_28_10 144 individual 1682706227.1873984 2023-04-28T18:23:47.187398+00:00 show_cross_screen individual006.jpg    
exp_2023_04_28_10 144 individual 1682706227.700953 2023-04-28T18:23:47.700953+00:00 show_image individual006.jpg    
exp_2023_04_28_10 144 individual 1682706232.7258108 2023-04-28T18:23:52.725811+00:00 show_rating_screen individual006.jpg    
exp_2023_04_28_10 144 individual 1682706234.457608 2023-04-28T18:23:54.457608+00:00 intermediate_selection individual006.jpg -2  
exp_2023_04_28_10 144 individual 1682706235.9564335 2023-04-28T18:23:55.956434+00:00 intermediate_selection individual006.jpg   -2
exp_2023_04_28_10 144 individual 1682706238.5374093 2023-04-28T18:23:58.537409+00:00 intermediate_selection individual006.jpg   1
exp_2023_04_28_10 144 individual 1682706239.146138 2023-04-28T18:23:59.146138+00:00 intermediate_selection individual006.jpg   0
exp_2023_04_28_10 144 individual 1682706241.031224 2023-04-28T18:24:01.031224+00:00 final_submission individual006.jpg -2 0
exp_2023_04_28_10 144 individual 1682706241.1320658 2023-04-28T18:24:01.132066+00:00 show_blank_screen individual007.jpg    
exp_2023_04_28_10 144 individual 1682706242.139268 2023-04-28T18:24:02.139268+00:00 show_cross_screen individual007.jpg    
exp_2023_04_28_10 144 individual 1682706242.65607 2023-04-28T18:24:02.656070+00:00 show_image individual007.jpg    
exp_2023_04_28_10 144 individual 1682706247.690601 2023-04-28T18:24:07.690601+00:00 show_rating_screen individual007.jpg    
exp_2023_04_28_10 144 individual 1682706250.415188 2023-04-28T18:24:10.415188+00:00 intermediate_selection individual007.jpg 2  
exp_2023_04_28_10 144 individual 1682706250.9583654 2023-04-28T18:24:10.958365+00:00 intermediate_selection individual007.jpg   2
exp_2023_04_28_10 144 individual 1682706251.9034362 2023-04-28T18:24:11.903436+00:00 final_submission individual007.jpg 2 2
exp_2023_04_28_10 144 individual 1682706252.0043826 2023-04-28T18:24:12.004383+00:00 show_blank_screen individual008.jpg    
exp_2023_04_28_10 144 individual 1682706253.0184765 2023-04-28T18:24:13.018476+00:00 show_cross_screen individual008.jpg    
exp_2023_04_28_10 144 individual 1682706253.5279388 2023-04-28T18:24:13.527939+00:00 show_image individual008.jpg    
exp_2023_04_28_10 144 individual 1682706258.5474076 2023-04-28T18:24:18.547408+00:00 show_rating_screen individual008.jpg    
exp_2023_04_28_10 144 individual 1682706259.9611285 2023-04-28T18:24:19.961128+00:00 intermediate_selection individual008.jpg 1  
exp_2023_04_28_10 144 individual 1682706260.7682936 2023-04-28T18:24:20.768294+00:00 intermediate_selection individual008.jpg   2
exp_2023_04_28_10 144 individual 1682706261.615632 2023-04-28T18:24:21.615632+00:00 final_submission individual008.jpg 1 2
exp_2023_04_28_10 144 individual 1682706261.7164707 2023-04-28T18:24:21.716471+00:00 show_blank_screen individual009.jpg    
exp_2023_04_28_10 144 individual 1682706262.7282639 2023-04-28T18:24:22.728264+00:00 show_cross_screen individual009.jpg    
exp_2023_04_28_10 144 individual 1682706263.2473304 2023-04-28T18:24:23.247330+00:00 show_image individual009.jpg    
exp_2023_04_28_10 144 individual 1682706268.27246 2023-04-28T18:24:28.272460+00:00 show_rating_screen individual009.jpg    
exp_2023_04_28_10 144 individual 1682706269.600609 2023-04-28T18:24:29.600609+00:00 intermediate_selection individual009.jpg -2  
exp_2023_04_28_10 144 individual 1682706270.3534567 2023-04-28T18:24:30.353457+00:00 intermediate_selection individual009.jpg   2
exp_2023_04_28_10 144 individual 1682706272.4815814 2023-04-28T18:24:32.481581+00:00 intermediate_selection individual009.jpg -1  
exp_2023_04_28_10 144 individual 1682706273.4481273 2023-04-28T18:24:33.448127+00:00 final_submission individual009.jpg -1 2
exp_2023_04_28_10 144 individual 1682706273.5489116 2023-04-28T18:24:33.548912+00:00 show_blank_screen individual010.jpg    
exp_2023_04_28_10 144 individual 1682706274.5742533 2023-04-28T18:24:34.574253+00:00 show_cross_screen individual010.jpg    
exp_2023_04_28_10 144 individual 1682706275.0830755 2023-04-28T18:24:35.083076+00:00 show_image individual010.jpg    
exp_2023_04_28_10 144 individual 1682706280.1056395 2023-04-28T18:24:40.105639+00:00 show_rating_screen individual010.jpg    
exp_2023_04_28_10 144 individual 1682706282.8101914 2023-04-28T18:24:42.810191+00:00 intermediate_selection individual010.jpg 1  
exp_2023_04_28_10 144 individual 1682706283.872366 2023-04-28T18:24:43.872366+00:00 intermediate_selection individual010.jpg   0
exp_2023_04_28_10 144 individual 1682706284.5607336 2023-04-28T18:24:44.560734+00:00 final_submission individual010.jpg 1 0
exp_2023_04_28_10 144 individual 1682706284.6614215 2023-04-28T18:24:44.661422+00:00 show_blank_screen individual011.jpg    
exp_2023_04_28_10 144 individual 1682706285.6844156 2023-04-28T18:24:45.684416+00:00 show_cross_screen individual011.jpg    
exp_2023_04_28_10 144 individual 1682706286.1973112 2023-04-28T18:24:46.197311+00:00 show_image individual011.jpg    
exp_2023_04_28_10 144 individual 1682706291.2232747 2023-04-28T18:24:51.223275+00:00 show_rating_screen individual011.jpg    
exp_2023_04_28_10 144 individual 1682706292.437878 2023-04-28T18:24:52.437878+00:00 intermediate_selection individual011.jpg 1  
exp_2023_04_28_10 144 individual 1682706293.2714713 2023-04-28T18:24:53.271471+00:00 intermediate_selection individual011.jpg   1
exp_2023_04_28_10 144 individual 1682706294.0485477 2023-04-28T18:24:54.048548+00:00 final_submission individual011.jpg 1 1
exp_2023_04_28_10 144 individual 1682706294.1492422 2023-04-28T18:24:54.149242+00:00 show_blank_screen individual012.jpg    
exp_2023_04_28_10 144 individual 1682706295.1672509 2023-04-28T18:24:55.167251+00:00 show_cross_screen individual012.jpg    
exp_2023_04_28_10 144 individual 1682706295.682321 2023-04-28T18:24:55.682321+00:00 show_image individual012.jpg    
exp_2023_04_28_10 144 individual 1682706300.7072716 2023-04-28T18:25:00.707272+00:00 show_rating_screen individual012.jpg    
exp_2023_04_28_10 144 individual 1682706302.8077967 2023-04-28T18:25:02.807797+00:00 intermediate_selection individual012.jpg 1  
exp_2023_04_28_10 144 individual 1682706303.4246507 2023-04-28T18:25:03.424651+00:00 intermediate_selection individual012.jpg   -1
exp_2023_04_28_10 144 individual 1682706303.9534237 2023-04-28T18:25:03.953424+00:00 final_submission individual012.jpg 1 -1
exp_2023_04_28_10 144 individual 1682706304.0542223 2023-04-28T18:25:04.054222+00:00 show_blank_screen individual013.jpg    
exp_2023_04_28_10 144 individual 1682706305.0769556 2023-04-28T18:25:05.076956+00:00 show_cross_screen individual013.jpg    
exp_2023_04_28_10 144 individual 1682706305.592265 2023-04-28T18:25:05.592265+00:00 show_image individual013.jpg    
exp_2023_04_28_10 144 individual 1682706310.6148944 2023-04-28T18:25:10.614894+00:00 show_rating_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]);