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_18_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_18_14 -2 team 1681856724.549839 2023-04-18T22:25:24.549839+00:00 start_affective_task      
exp_2023_04_18_14 134 individual 1681856469.5243287 2023-04-18T22:21:09.524329+00:00 start_affective_task      
exp_2023_04_18_14 134 individual 1681856469.5248885 2023-04-18T22:21:09.524889+00:00 show_blank_screen individual000.jpg    
exp_2023_04_18_14 134 individual 1681856470.5379732 2023-04-18T22:21:10.537973+00:00 show_cross_screen individual000.jpg    
exp_2023_04_18_14 134 individual 1681856471.0600736 2023-04-18T22:21:11.060074+00:00 show_image individual000.jpg    
exp_2023_04_18_14 134 individual 1681856476.0883272 2023-04-18T22:21:16.088327+00:00 show_rating_screen individual000.jpg    
exp_2023_04_18_14 134 individual 1681856480.7377484 2023-04-18T22:21:20.737748+00:00 intermediate_selection individual000.jpg 2  
exp_2023_04_18_14 134 individual 1681856483.0708535 2023-04-18T22:21:23.070853+00:00 intermediate_selection individual000.jpg 1  
exp_2023_04_18_14 134 individual 1681856483.9882472 2023-04-18T22:21:23.988247+00:00 intermediate_selection individual000.jpg   1
exp_2023_04_18_14 134 individual 1681856484.5304923 2023-04-18T22:21:24.530492+00:00 final_submission individual000.jpg 1 1
exp_2023_04_18_14 134 individual 1681856484.631051 2023-04-18T22:21:24.631051+00:00 show_blank_screen individual001.jpg    
exp_2023_04_18_14 134 individual 1681856485.6476154 2023-04-18T22:21:25.647615+00:00 show_cross_screen individual001.jpg    
exp_2023_04_18_14 134 individual 1681856486.165302 2023-04-18T22:21:26.165302+00:00 show_image individual001.jpg    
exp_2023_04_18_14 134 individual 1681856491.1916196 2023-04-18T22:21:31.191620+00:00 show_rating_screen individual001.jpg    
exp_2023_04_18_14 134 individual 1681856496.0393436 2023-04-18T22:21:36.039344+00:00 intermediate_selection individual001.jpg   2
exp_2023_04_18_14 134 individual 1681856497.215534 2023-04-18T22:21:37.215534+00:00 intermediate_selection individual001.jpg 1  
exp_2023_04_18_14 134 individual 1681856498.6509025 2023-04-18T22:21:38.650903+00:00 final_submission individual001.jpg 1 2
exp_2023_04_18_14 134 individual 1681856498.751423 2023-04-18T22:21:38.751423+00:00 show_blank_screen individual002.jpg    
exp_2023_04_18_14 134 individual 1681856499.766587 2023-04-18T22:21:39.766587+00:00 show_cross_screen individual002.jpg    
exp_2023_04_18_14 134 individual 1681856500.2903743 2023-04-18T22:21:40.290374+00:00 show_image individual002.jpg    
exp_2023_04_18_14 134 individual 1681856505.314299 2023-04-18T22:21:45.314299+00:00 show_rating_screen individual002.jpg    
exp_2023_04_18_14 134 individual 1681856508.7885406 2023-04-18T22:21:48.788541+00:00 intermediate_selection individual002.jpg   -2
exp_2023_04_18_14 134 individual 1681856510.4292784 2023-04-18T22:21:50.429278+00:00 intermediate_selection individual002.jpg 0  
exp_2023_04_18_14 134 individual 1681856511.3955114 2023-04-18T22:21:51.395511+00:00 final_submission individual002.jpg 0 -2
exp_2023_04_18_14 134 individual 1681856511.4961157 2023-04-18T22:21:51.496116+00:00 show_blank_screen individual003.jpg    
exp_2023_04_18_14 134 individual 1681856512.5097594 2023-04-18T22:21:52.509759+00:00 show_cross_screen individual003.jpg    
exp_2023_04_18_14 134 individual 1681856513.026885 2023-04-18T22:21:53.026885+00:00 show_image individual003.jpg    
exp_2023_04_18_14 134 individual 1681856518.0496817 2023-04-18T22:21:58.049682+00:00 show_rating_screen individual003.jpg    
exp_2023_04_18_14 134 individual 1681856520.9976199 2023-04-18T22:22:00.997620+00:00 intermediate_selection individual003.jpg   0
exp_2023_04_18_14 134 individual 1681856524.1816278 2023-04-18T22:22:04.181628+00:00 intermediate_selection individual003.jpg -1  
exp_2023_04_18_14 134 individual 1681856525.4437842 2023-04-18T22:22:05.443784+00:00 final_submission individual003.jpg -1 0
exp_2023_04_18_14 134 individual 1681856525.5443442 2023-04-18T22:22:05.544344+00:00 show_blank_screen individual004.jpg    
exp_2023_04_18_14 134 individual 1681856526.5566645 2023-04-18T22:22:06.556664+00:00 show_cross_screen individual004.jpg    
exp_2023_04_18_14 134 individual 1681856527.0672276 2023-04-18T22:22:07.067228+00:00 show_image individual004.jpg    
exp_2023_04_18_14 134 individual 1681856532.096036 2023-04-18T22:22:12.096036+00:00 show_rating_screen individual004.jpg    
exp_2023_04_18_14 134 individual 1681856533.5664642 2023-04-18T22:22:13.566464+00:00 intermediate_selection individual004.jpg -2  
exp_2023_04_18_14 134 individual 1681856535.4060621 2023-04-18T22:22:15.406062+00:00 intermediate_selection individual004.jpg   -1
exp_2023_04_18_14 134 individual 1681856536.6870966 2023-04-18T22:22:16.687097+00:00 intermediate_selection individual004.jpg   -2
exp_2023_04_18_14 134 individual 1681856537.9082828 2023-04-18T22:22:17.908283+00:00 final_submission individual004.jpg -2 -2
exp_2023_04_18_14 134 individual 1681856538.008914 2023-04-18T22:22:18.008914+00:00 show_blank_screen individual005.jpg    
exp_2023_04_18_14 134 individual 1681856539.032634 2023-04-18T22:22:19.032634+00:00 show_cross_screen individual005.jpg    
exp_2023_04_18_14 134 individual 1681856539.5519 2023-04-18T22:22:19.551900+00:00 show_image individual005.jpg    
exp_2023_04_18_14 134 individual 1681856544.5767736 2023-04-18T22:22:24.576774+00:00 show_rating_screen individual005.jpg    
exp_2023_04_18_14 134 individual 1681856545.6949477 2023-04-18T22:22:25.694948+00:00 intermediate_selection individual005.jpg 2  
exp_2023_04_18_14 134 individual 1681856546.5689363 2023-04-18T22:22:26.568936+00:00 intermediate_selection individual005.jpg   2
exp_2023_04_18_14 134 individual 1681856547.72448 2023-04-18T22:22:27.724480+00:00 final_submission individual005.jpg 2 2
exp_2023_04_18_14 134 individual 1681856547.8252335 2023-04-18T22:22:27.825233+00:00 show_blank_screen individual006.jpg    
exp_2023_04_18_14 134 individual 1681856548.8492496 2023-04-18T22:22:28.849250+00:00 show_cross_screen individual006.jpg    
exp_2023_04_18_14 134 individual 1681856549.3719873 2023-04-18T22:22:29.371987+00:00 show_image individual006.jpg    
exp_2023_04_18_14 134 individual 1681856554.4042487 2023-04-18T22:22:34.404249+00:00 show_rating_screen individual006.jpg    
exp_2023_04_18_14 134 individual 1681856555.4250984 2023-04-18T22:22:35.425098+00:00 intermediate_selection individual006.jpg -2  
exp_2023_04_18_14 134 individual 1681856556.5235581 2023-04-18T22:22:36.523558+00:00 intermediate_selection individual006.jpg   0
exp_2023_04_18_14 134 individual 1681856557.156607 2023-04-18T22:22:37.156607+00:00 final_submission individual006.jpg -2 0
exp_2023_04_18_14 134 individual 1681856557.2572157 2023-04-18T22:22:37.257216+00:00 show_blank_screen individual007.jpg    
exp_2023_04_18_14 134 individual 1681856558.2683675 2023-04-18T22:22:38.268368+00:00 show_cross_screen individual007.jpg    
exp_2023_04_18_14 134 individual 1681856558.7825422 2023-04-18T22:22:38.782542+00:00 show_image individual007.jpg    
exp_2023_04_18_14 134 individual 1681856563.8160648 2023-04-18T22:22:43.816065+00:00 show_rating_screen individual007.jpg    
exp_2023_04_18_14 134 individual 1681856567.3492906 2023-04-18T22:22:47.349291+00:00 intermediate_selection individual007.jpg 2  
exp_2023_04_18_14 134 individual 1681856568.4391818 2023-04-18T22:22:48.439182+00:00 intermediate_selection individual007.jpg   2
exp_2023_04_18_14 134 individual 1681856569.1334426 2023-04-18T22:22:49.133443+00:00 final_submission individual007.jpg 2 2
exp_2023_04_18_14 134 individual 1681856569.234135 2023-04-18T22:22:49.234135+00:00 show_blank_screen individual008.jpg    
exp_2023_04_18_14 134 individual 1681856570.2476685 2023-04-18T22:22:50.247669+00:00 show_cross_screen individual008.jpg    
exp_2023_04_18_14 134 individual 1681856570.7699785 2023-04-18T22:22:50.769979+00:00 show_image individual008.jpg    
exp_2023_04_18_14 134 individual 1681856575.7888258 2023-04-18T22:22:55.788826+00:00 show_rating_screen individual008.jpg    
exp_2023_04_18_14 134 individual 1681856577.2295399 2023-04-18T22:22:57.229540+00:00 intermediate_selection individual008.jpg -2  
exp_2023_04_18_14 134 individual 1681856578.0331967 2023-04-18T22:22:58.033197+00:00 intermediate_selection individual008.jpg   0
exp_2023_04_18_14 134 individual 1681856580.3805664 2023-04-18T22:23:00.380566+00:00 intermediate_selection individual008.jpg   1
exp_2023_04_18_14 134 individual 1681856580.925653 2023-04-18T22:23:00.925653+00:00 final_submission individual008.jpg -2 1
exp_2023_04_18_14 134 individual 1681856581.026115 2023-04-18T22:23:01.026115+00:00 show_blank_screen individual009.jpg    
exp_2023_04_18_14 134 individual 1681856582.0429192 2023-04-18T22:23:02.042919+00:00 show_cross_screen individual009.jpg    
exp_2023_04_18_14 134 individual 1681856582.5570836 2023-04-18T22:23:02.557084+00:00 show_image individual009.jpg    
exp_2023_04_18_14 134 individual 1681856587.5835452 2023-04-18T22:23:07.583545+00:00 show_rating_screen individual009.jpg    
exp_2023_04_18_14 134 individual 1681856589.7005699 2023-04-18T22:23:09.700570+00:00 intermediate_selection individual009.jpg -2  
exp_2023_04_18_14 134 individual 1681856591.0488431 2023-04-18T22:23:11.048843+00:00 intermediate_selection individual009.jpg   0
exp_2023_04_18_14 134 individual 1681856593.765881 2023-04-18T22:23:13.765881+00:00 intermediate_selection individual009.jpg   1
exp_2023_04_18_14 134 individual 1681856594.1340525 2023-04-18T22:23:14.134053+00:00 final_submission individual009.jpg -2 1
exp_2023_04_18_14 134 individual 1681856594.2348638 2023-04-18T22:23:14.234864+00:00 show_blank_screen individual010.jpg    
exp_2023_04_18_14 134 individual 1681856595.2455847 2023-04-18T22:23:15.245585+00:00 show_cross_screen individual010.jpg    
exp_2023_04_18_14 134 individual 1681856595.7694516 2023-04-18T22:23:15.769452+00:00 show_image individual010.jpg    
exp_2023_04_18_14 134 individual 1681856600.7983863 2023-04-18T22:23:20.798386+00:00 show_rating_screen individual010.jpg    
exp_2023_04_18_14 134 individual 1681856603.5389862 2023-04-18T22:23:23.538986+00:00 intermediate_selection individual010.jpg 1  
exp_2023_04_18_14 134 individual 1681856604.1301897 2023-04-18T22:23:24.130190+00:00 intermediate_selection individual010.jpg   -2
exp_2023_04_18_14 134 individual 1681856604.6623077 2023-04-18T22:23:24.662308+00:00 final_submission individual010.jpg 1 -2
exp_2023_04_18_14 134 individual 1681856604.7631934 2023-04-18T22:23:24.763193+00:00 show_blank_screen individual011.jpg    
exp_2023_04_18_14 134 individual 1681856605.7898006 2023-04-18T22:23:25.789801+00:00 show_cross_screen individual011.jpg    
exp_2023_04_18_14 134 individual 1681856606.3033283 2023-04-18T22:23:26.303328+00:00 show_image individual011.jpg    
exp_2023_04_18_14 134 individual 1681856611.32663 2023-04-18T22:23:31.326630+00:00 show_rating_screen individual011.jpg    
exp_2023_04_18_14 134 individual 1681856612.3399315 2023-04-18T22:23:32.339931+00:00 intermediate_selection individual011.jpg 2  
exp_2023_04_18_14 134 individual 1681856613.946999 2023-04-18T22:23:33.946999+00:00 intermediate_selection individual011.jpg   0
exp_2023_04_18_14 134 individual 1681856615.3811996 2023-04-18T22:23:35.381200+00:00 intermediate_selection individual011.jpg   1
exp_2023_04_18_14 134 individual 1681856616.6393497 2023-04-18T22:23:36.639350+00:00 final_submission individual011.jpg 2 1
exp_2023_04_18_14 134 individual 1681856616.739935 2023-04-18T22:23:36.739935+00:00 show_blank_screen individual012.jpg    
exp_2023_04_18_14 134 individual 1681856617.7501156 2023-04-18T22:23:37.750116+00:00 show_cross_screen individual012.jpg    
exp_2023_04_18_14 134 individual 1681856618.2702851 2023-04-18T22:23:38.270285+00:00 show_image individual012.jpg    
exp_2023_04_18_14 134 individual 1681856623.2973695 2023-04-18T22:23:43.297369+00:00 show_rating_screen individual012.jpg    
exp_2023_04_18_14 134 individual 1681856624.7876565 2023-04-18T22:23:44.787657+00:00 intermediate_selection individual012.jpg 0  
exp_2023_04_18_14 134 individual 1681856625.5818286 2023-04-18T22:23:45.581829+00:00 intermediate_selection individual012.jpg   -1
exp_2023_04_18_14 134 individual 1681856625.9010124 2023-04-18T22:23:45.901012+00:00 intermediate_selection individual012.jpg   -2
exp_2023_04_18_14 134 individual 1681856626.9350903 2023-04-18T22:23:46.935090+00:00 final_submission individual012.jpg 0 -2
exp_2023_04_18_14 134 individual 1681856627.035824 2023-04-18T22:23:47.035824+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]);