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_2022_11_07_10"

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_2022_11_07_10 -2 team 1667845627.5227656 2022-11-07T18:27:07.522766+00:00 start_affective_task      
exp_2022_11_07_10 27 individual 1667845372.641115 2022-11-07T18:22:52.641115+00:00 start_affective_task      
exp_2022_11_07_10 27 individual 1667845382.2903788 2022-11-07T18:23:02.290379+00:00 intermediate_selection individual000.jpg 1  
exp_2022_11_07_10 27 individual 1667845383.8104103 2022-11-07T18:23:03.810410+00:00 intermediate_selection individual000.jpg   -1
exp_2022_11_07_10 27 individual 1667845385.2516356 2022-11-07T18:23:05.251636+00:00 final_submission individual000.jpg 1 -1
exp_2022_11_07_10 27 individual 1667845395.0090737 2022-11-07T18:23:15.009074+00:00 intermediate_selection individual001.jpg   -1
exp_2022_11_07_10 27 individual 1667845395.6333086 2022-11-07T18:23:15.633309+00:00 intermediate_selection individual001.jpg   -2
exp_2022_11_07_10 27 individual 1667845397.2658677 2022-11-07T18:23:17.265868+00:00 intermediate_selection individual001.jpg   0
exp_2022_11_07_10 27 individual 1667845398.4893425 2022-11-07T18:23:18.489342+00:00 intermediate_selection individual001.jpg   -2
exp_2022_11_07_10 27 individual 1667845400.2729063 2022-11-07T18:23:20.272906+00:00 intermediate_selection individual001.jpg 1  
exp_2022_11_07_10 27 individual 1667845401.2926524 2022-11-07T18:23:21.292652+00:00 final_submission individual001.jpg 1 -2
exp_2022_11_07_10 27 individual 1667845410.0220814 2022-11-07T18:23:30.022081+00:00 intermediate_selection individual002.jpg   -1
exp_2022_11_07_10 27 individual 1667845411.8116634 2022-11-07T18:23:31.811663+00:00 intermediate_selection individual002.jpg -2  
exp_2022_11_07_10 27 individual 1667845412.4366763 2022-11-07T18:23:32.436676+00:00 final_submission individual002.jpg -2 -1
exp_2022_11_07_10 27 individual 1667845420.6772704 2022-11-07T18:23:40.677270+00:00 intermediate_selection individual003.jpg   1
exp_2022_11_07_10 27 individual 1667845421.6651998 2022-11-07T18:23:41.665200+00:00 intermediate_selection individual003.jpg -2  
exp_2022_11_07_10 27 individual 1667845422.4290257 2022-11-07T18:23:42.429026+00:00 final_submission individual003.jpg -2 1
exp_2022_11_07_10 27 individual 1667845430.0288017 2022-11-07T18:23:50.028802+00:00 intermediate_selection individual004.jpg -2  
exp_2022_11_07_10 27 individual 1667845430.7238612 2022-11-07T18:23:50.723861+00:00 intermediate_selection individual004.jpg   1
exp_2022_11_07_10 27 individual 1667845431.253622 2022-11-07T18:23:51.253622+00:00 final_submission individual004.jpg -2 1
exp_2022_11_07_10 27 individual 1667845439.529723 2022-11-07T18:23:59.529723+00:00 intermediate_selection individual005.jpg 2  
exp_2022_11_07_10 27 individual 1667845440.4771507 2022-11-07T18:24:00.477151+00:00 intermediate_selection individual005.jpg   0
exp_2022_11_07_10 27 individual 1667845441.8861902 2022-11-07T18:24:01.886190+00:00 final_submission individual005.jpg 2 0
exp_2022_11_07_10 27 individual 1667845449.442254 2022-11-07T18:24:09.442254+00:00 intermediate_selection individual006.jpg -2  
exp_2022_11_07_10 27 individual 1667845450.1736114 2022-11-07T18:24:10.173611+00:00 intermediate_selection individual006.jpg   1
exp_2022_11_07_10 27 individual 1667845450.7741697 2022-11-07T18:24:10.774170+00:00 final_submission individual006.jpg -2 1
exp_2022_11_07_10 27 individual 1667845459.6517124 2022-11-07T18:24:19.651712+00:00 intermediate_selection individual007.jpg 0  
exp_2022_11_07_10 27 individual 1667845460.7228234 2022-11-07T18:24:20.722823+00:00 intermediate_selection individual007.jpg   0
exp_2022_11_07_10 27 individual 1667845461.3426557 2022-11-07T18:24:21.342656+00:00 final_submission individual007.jpg 0 0
exp_2022_11_07_10 27 individual 1667845469.0454583 2022-11-07T18:24:29.045458+00:00 intermediate_selection individual008.jpg   1
exp_2022_11_07_10 27 individual 1667845470.5892804 2022-11-07T18:24:30.589280+00:00 intermediate_selection individual008.jpg -1  
exp_2022_11_07_10 27 individual 1667845471.6792026 2022-11-07T18:24:31.679203+00:00 final_submission individual008.jpg -1 1
exp_2022_11_07_10 27 individual 1667845479.963093 2022-11-07T18:24:39.963093+00:00 intermediate_selection individual009.jpg   1
exp_2022_11_07_10 27 individual 1667845480.9726415 2022-11-07T18:24:40.972641+00:00 intermediate_selection individual009.jpg -2  
exp_2022_11_07_10 27 individual 1667845482.415303 2022-11-07T18:24:42.415303+00:00 final_submission individual009.jpg -2 1
exp_2022_11_07_10 27 individual 1667845490.0269299 2022-11-07T18:24:50.026930+00:00 intermediate_selection individual010.jpg 2  
exp_2022_11_07_10 27 individual 1667845490.5982432 2022-11-07T18:24:50.598243+00:00 intermediate_selection individual010.jpg   1
exp_2022_11_07_10 27 individual 1667845491.4556613 2022-11-07T18:24:51.455661+00:00 final_submission individual010.jpg 2 1
exp_2022_11_07_10 27 individual 1667845499.261566 2022-11-07T18:24:59.261566+00:00 intermediate_selection individual011.jpg 2  
exp_2022_11_07_10 27 individual 1667845500.111115 2022-11-07T18:25:00.111115+00:00 intermediate_selection individual011.jpg   1
exp_2022_11_07_10 27 individual 1667845501.3825243 2022-11-07T18:25:01.382524+00:00 intermediate_selection individual011.jpg   0
exp_2022_11_07_10 27 individual 1667845502.0637465 2022-11-07T18:25:02.063746+00:00 final_submission individual011.jpg 2 0
exp_2022_11_07_10 27 individual 1667845509.8878098 2022-11-07T18:25:09.887810+00:00 intermediate_selection individual012.jpg -1  
exp_2022_11_07_10 27 individual 1667845510.9349582 2022-11-07T18:25:10.934958+00:00 intermediate_selection individual012.jpg   -2
exp_2022_11_07_10 27 individual 1667845512.0086832 2022-11-07T18:25:12.008683+00:00 final_submission individual012.jpg -1 -2
exp_2022_11_07_10 27 individual 1667845519.8368883 2022-11-07T18:25:19.836888+00:00 intermediate_selection individual013.jpg 1  
exp_2022_11_07_10 27 individual 1667845520.407157 2022-11-07T18:25:20.407157+00:00 intermediate_selection individual013.jpg   1
exp_2022_11_07_10 27 individual 1667845521.0891514 2022-11-07T18:25:21.089151+00:00 final_submission individual013.jpg 1 1
exp_2022_11_07_10 27 individual 1667845529.0543172 2022-11-07T18:25:29.054317+00:00 intermediate_selection individual014.jpg -2  
exp_2022_11_07_10 27 individual 1667845531.1034722 2022-11-07T18:25:31.103472+00:00 intermediate_selection individual014.jpg   0
exp_2022_11_07_10 27 individual 1667845531.5292077 2022-11-07T18:25:31.529208+00:00 final_submission individual014.jpg -2 0
exp_2022_11_07_10 27 team 1667845756.0143259 2022-11-07T18:29:16.014326+00:00 intermediate_selection Team002.jpg -2  
exp_2022_11_07_10 27 team 1667845756.6930022 2022-11-07T18:29:16.693002+00:00 intermediate_selection Team002.jpg   1
exp_2022_11_07_10 27 team 1667845757.7613456 2022-11-07T18:29:17.761346+00:00 final_submission Team002.jpg -2 1
exp_2022_11_07_10 27 team 1667845882.9487138 2022-11-07T18:31:22.948714+00:00 intermediate_selection Team005.jpg 1  
exp_2022_11_07_10 27 team 1667845883.6521187 2022-11-07T18:31:23.652119+00:00 intermediate_selection Team005.jpg   1
exp_2022_11_07_10 27 team 1667845884.5257998 2022-11-07T18:31:24.525800+00:00 final_submission Team005.jpg 1 1
exp_2022_11_07_10 27 team 1667846012.5402136 2022-11-07T18:33:32.540214+00:00 intermediate_selection Team008.jpg -2  
exp_2022_11_07_10 27 team 1667846013.3403623 2022-11-07T18:33:33.340362+00:00 intermediate_selection Team008.jpg   1
exp_2022_11_07_10 27 team 1667846013.8055863 2022-11-07T18:33:33.805586+00:00 final_submission Team008.jpg -2 1
exp_2022_11_07_10 27 team 1667846136.6865194 2022-11-07T18:35:36.686519+00:00 intermediate_selection Team011.jpg 0  
exp_2022_11_07_10 27 team 1667846137.3474185 2022-11-07T18:35:37.347419+00:00 intermediate_selection Team011.jpg   -1
exp_2022_11_07_10 27 team 1667846138.3910887 2022-11-07T18:35:38.391089+00:00 final_submission Team011.jpg 0 -1
exp_2022_11_07_10 27 team 1667846261.768784 2022-11-07T18:37:41.768784+00:00 intermediate_selection Team014.jpg -2  
exp_2022_11_07_10 27 team 1667846262.4449022 2022-11-07T18:37:42.444902+00:00 intermediate_selection Team014.jpg   2
exp_2022_11_07_10 27 team 1667846263.123464 2022-11-07T18:37:43.123464+00:00 final_submission Team014.jpg -2 2
exp_2022_11_07_10 65 individual 1667845372.679022 2022-11-07T18:22:52.679022+00:00 start_affective_task      
exp_2022_11_07_10 65 individual 1667845382.6752737 2022-11-07T18:23:02.675274+00:00 intermediate_selection individual000.jpg 1  
exp_2022_11_07_10 65 individual 1667845384.4488313 2022-11-07T18:23:04.448831+00:00 intermediate_selection individual000.jpg   -1
exp_2022_11_07_10 65 individual 1667845385.2757843 2022-11-07T18:23:05.275784+00:00 final_submission individual000.jpg 1 -1
exp_2022_11_07_10 65 individual 1667845394.0413592 2022-11-07T18:23:14.041359+00:00 intermediate_selection individual001.jpg 1  
exp_2022_11_07_10 65 individual 1667845394.9565675 2022-11-07T18:23:14.956568+00:00 intermediate_selection individual001.jpg   -1
exp_2022_11_07_10 65 individual 1667845396.684358 2022-11-07T18:23:16.684358+00:00 final_submission individual001.jpg 1 -1
exp_2022_11_07_10 65 individual 1667845404.9956706 2022-11-07T18:23:24.995671+00:00 intermediate_selection individual002.jpg 1  
exp_2022_11_07_10 65 individual 1667845405.8923564 2022-11-07T18:23:25.892356+00:00 intermediate_selection individual002.jpg   1
exp_2022_11_07_10 65 individual 1667845408.25406 2022-11-07T18:23:28.254060+00:00 intermediate_selection individual002.jpg   0
exp_2022_11_07_10 65 individual 1667845408.7007227 2022-11-07T18:23:28.700723+00:00 final_submission individual002.jpg 1 0
exp_2022_11_07_10 65 individual 1667845417.6838315 2022-11-07T18:23:37.683831+00:00 intermediate_selection individual003.jpg -1  
exp_2022_11_07_10 65 individual 1667845419.468949 2022-11-07T18:23:39.468949+00:00 intermediate_selection individual003.jpg   1
exp_2022_11_07_10 65 individual 1667845421.867365 2022-11-07T18:23:41.867365+00:00 intermediate_selection individual003.jpg   0
exp_2022_11_07_10 65 individual 1667845423.3810499 2022-11-07T18:23:43.381050+00:00 final_submission individual003.jpg -1 0
exp_2022_11_07_10 65 individual 1667845431.2982452 2022-11-07T18:23:51.298245+00:00 intermediate_selection individual004.jpg -2  
exp_2022_11_07_10 65 individual 1667845433.2416003 2022-11-07T18:23:53.241600+00:00 intermediate_selection individual004.jpg   1
exp_2022_11_07_10 65 individual 1667845434.0933802 2022-11-07T18:23:54.093380+00:00 intermediate_selection individual004.jpg   0
exp_2022_11_07_10 65 individual 1667845434.6920962 2022-11-07T18:23:54.692096+00:00 intermediate_selection individual004.jpg   1
exp_2022_11_07_10 65 individual 1667845435.1976097 2022-11-07T18:23:55.197610+00:00 final_submission individual004.jpg -2 1
exp_2022_11_07_10 65 individual 1667845442.9078012 2022-11-07T18:24:02.907801+00:00 intermediate_selection individual005.jpg 0  
exp_2022_11_07_10 65 individual 1667845443.678318 2022-11-07T18:24:03.678318+00:00 intermediate_selection individual005.jpg   -1
exp_2022_11_07_10 65 individual 1667845444.4213989 2022-11-07T18:24:04.421399+00:00 final_submission individual005.jpg 0 -1
exp_2022_11_07_10 65 individual 1667845452.0995507 2022-11-07T18:24:12.099551+00:00 intermediate_selection individual006.jpg -2  
exp_2022_11_07_10 65 individual 1667845452.9012845 2022-11-07T18:24:12.901284+00:00 intermediate_selection individual006.jpg   1
exp_2022_11_07_10 65 individual 1667845453.5182884 2022-11-07T18:24:13.518288+00:00 final_submission individual006.jpg -2 1
exp_2022_11_07_10 65 individual 1667845461.489477 2022-11-07T18:24:21.489477+00:00 intermediate_selection individual007.jpg   0
exp_2022_11_07_10 65 individual 1667845463.2616673 2022-11-07T18:24:23.261667+00:00 intermediate_selection individual007.jpg 1  
exp_2022_11_07_10 65 individual 1667845464.7187123 2022-11-07T18:24:24.718712+00:00 final_submission individual007.jpg 1 0
exp_2022_11_07_10 65 individual 1667845472.6990924 2022-11-07T18:24:32.699092+00:00 intermediate_selection individual008.jpg   2
exp_2022_11_07_10 65 individual 1667845474.0691755 2022-11-07T18:24:34.069175+00:00 intermediate_selection individual008.jpg -1  
exp_2022_11_07_10 65 individual 1667845475.438997 2022-11-07T18:24:35.438997+00:00 final_submission individual008.jpg -1 2
exp_2022_11_07_10 65 individual 1667845483.1773322 2022-11-07T18:24:43.177332+00:00 intermediate_selection individual009.jpg -2  
exp_2022_11_07_10 65 individual 1667845483.9841428 2022-11-07T18:24:43.984143+00:00 intermediate_selection individual009.jpg   2

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