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

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_02_03_10 104 individual 1675449225.2410264 2023-02-03T18:33:45.241026+00:00 start_affective_task      
exp_2023_02_03_10 104 individual 1675449235.742625 2023-02-03T18:33:55.742625+00:00 intermediate_selection individual000.jpg 1  
exp_2023_02_03_10 104 individual 1675449237.111184 2023-02-03T18:33:57.111184+00:00 intermediate_selection individual000.jpg   0
exp_2023_02_03_10 104 individual 1675449237.928225 2023-02-03T18:33:57.928225+00:00 final_submission individual000.jpg 1 0
exp_2023_02_03_10 104 individual 1675449245.6066375 2023-02-03T18:34:05.606637+00:00 intermediate_selection individual001.jpg 0  
exp_2023_02_03_10 104 individual 1675449247.417078 2023-02-03T18:34:07.417078+00:00 intermediate_selection individual001.jpg   0
exp_2023_02_03_10 104 individual 1675449248.8886793 2023-02-03T18:34:08.888679+00:00 final_submission individual001.jpg 0 0
exp_2023_02_03_10 104 individual 1675449258.349511 2023-02-03T18:34:18.349511+00:00 intermediate_selection individual002.jpg 0  
exp_2023_02_03_10 104 individual 1675449259.439099 2023-02-03T18:34:19.439099+00:00 intermediate_selection individual002.jpg   0
exp_2023_02_03_10 104 individual 1675449260.7449555 2023-02-03T18:34:20.744956+00:00 final_submission individual002.jpg 0 0
exp_2023_02_03_10 104 individual 1675449270.367329 2023-02-03T18:34:30.367329+00:00 intermediate_selection individual003.jpg -1  
exp_2023_02_03_10 104 individual 1675449273.1421318 2023-02-03T18:34:33.142132+00:00 intermediate_selection individual003.jpg   0
exp_2023_02_03_10 104 individual 1675449275.6336038 2023-02-03T18:34:35.633604+00:00 final_submission individual003.jpg -1 0
exp_2023_02_03_10 104 individual 1675449284.329379 2023-02-03T18:34:44.329379+00:00 intermediate_selection individual004.jpg -2  
exp_2023_02_03_10 104 individual 1675449291.13521 2023-02-03T18:34:51.135210+00:00 intermediate_selection individual004.jpg   1
exp_2023_02_03_10 104 individual 1675449292.7537196 2023-02-03T18:34:52.753720+00:00 final_submission individual004.jpg -2 1
exp_2023_02_03_10 104 individual 1675449300.3118007 2023-02-03T18:35:00.311801+00:00 intermediate_selection individual005.jpg 2  
exp_2023_02_03_10 104 individual 1675449300.7999833 2023-02-03T18:35:00.799983+00:00 intermediate_selection individual005.jpg   2
exp_2023_02_03_10 104 individual 1675449302.0183685 2023-02-03T18:35:02.018368+00:00 final_submission individual005.jpg 2 2
exp_2023_02_03_10 104 individual 1675449310.609097 2023-02-03T18:35:10.609097+00:00 intermediate_selection individual006.jpg -2  
exp_2023_02_03_10 104 individual 1675449312.2017713 2023-02-03T18:35:12.201771+00:00 intermediate_selection individual006.jpg   1
exp_2023_02_03_10 104 individual 1675449313.2025797 2023-02-03T18:35:13.202580+00:00 final_submission individual006.jpg -2 1
exp_2023_02_03_10 104 individual 1675449322.6638308 2023-02-03T18:35:22.663831+00:00 intermediate_selection individual007.jpg 0  
exp_2023_02_03_10 104 individual 1675449324.3765311 2023-02-03T18:35:24.376531+00:00 intermediate_selection individual007.jpg   1
exp_2023_02_03_10 104 individual 1675449325.0993316 2023-02-03T18:35:25.099332+00:00 final_submission individual007.jpg 0 1
exp_2023_02_03_10 104 individual 1675449335.9373844 2023-02-03T18:35:35.937384+00:00 intermediate_selection individual008.jpg -1  
exp_2023_02_03_10 104 individual 1675449336.8660843 2023-02-03T18:35:36.866084+00:00 intermediate_selection individual008.jpg 0  
exp_2023_02_03_10 104 individual 1675449338.108378 2023-02-03T18:35:38.108378+00:00 intermediate_selection individual008.jpg   1
exp_2023_02_03_10 104 individual 1675449339.1078904 2023-02-03T18:35:39.107890+00:00 final_submission individual008.jpg 0 1
exp_2023_02_03_10 104 individual 1675449347.306513 2023-02-03T18:35:47.306513+00:00 intermediate_selection individual009.jpg -2  
exp_2023_02_03_10 104 individual 1675449348.5373223 2023-02-03T18:35:48.537322+00:00 intermediate_selection individual009.jpg   2
exp_2023_02_03_10 104 individual 1675449349.5081902 2023-02-03T18:35:49.508190+00:00 final_submission individual009.jpg -2 2
exp_2023_02_03_10 104 individual 1675449357.2911663 2023-02-03T18:35:57.291166+00:00 intermediate_selection individual010.jpg 2  
exp_2023_02_03_10 104 individual 1675449358.1251695 2023-02-03T18:35:58.125170+00:00 intermediate_selection individual010.jpg   1
exp_2023_02_03_10 104 individual 1675449359.0604162 2023-02-03T18:35:59.060416+00:00 final_submission individual010.jpg 2 1
exp_2023_02_03_10 104 individual 1675449367.35509 2023-02-03T18:36:07.355090+00:00 intermediate_selection individual011.jpg 0  
exp_2023_02_03_10 104 individual 1675449369.183451 2023-02-03T18:36:09.183451+00:00 intermediate_selection individual011.jpg   0
exp_2023_02_03_10 104 individual 1675449369.9330668 2023-02-03T18:36:09.933067+00:00 final_submission individual011.jpg 0 0
exp_2023_02_03_10 104 individual 1675449378.9967465 2023-02-03T18:36:18.996747+00:00 intermediate_selection individual012.jpg 0  
exp_2023_02_03_10 104 individual 1675449379.7979317 2023-02-03T18:36:19.797932+00:00 intermediate_selection individual012.jpg   0
exp_2023_02_03_10 104 individual 1675449380.429552 2023-02-03T18:36:20.429552+00:00 final_submission individual012.jpg 0 0
exp_2023_02_03_10 104 individual 1675449391.2214613 2023-02-03T18:36:31.221461+00:00 intermediate_selection individual013.jpg 1  
exp_2023_02_03_10 104 individual 1675449393.1189687 2023-02-03T18:36:33.118969+00:00 intermediate_selection individual013.jpg   -1
exp_2023_02_03_10 104 individual 1675449394.1417263 2023-02-03T18:36:34.141726+00:00 final_submission individual013.jpg 1 -1
exp_2023_02_03_10 104 individual 1675449401.7794967 2023-02-03T18:36:41.779497+00:00 intermediate_selection individual014.jpg 0  
exp_2023_02_03_10 104 individual 1675449402.4368176 2023-02-03T18:36:42.436818+00:00 intermediate_selection individual014.jpg   -1
exp_2023_02_03_10 104 individual 1675449403.0141687 2023-02-03T18:36:43.014169+00:00 final_submission individual014.jpg 0 -1
exp_2023_02_03_10 104 team 1675449615.6713264 2023-02-03T18:40:15.671326+00:00 intermediate_selection Team002.jpg -1  
exp_2023_02_03_10 104 team 1675449618.6127734 2023-02-03T18:40:18.612773+00:00 intermediate_selection Team002.jpg   -1
exp_2023_02_03_10 104 team 1675449620.183447 2023-02-03T18:40:20.183447+00:00 final_submission Team002.jpg -1 -1
exp_2023_02_03_10 104 team 1675449751.7344375 2023-02-03T18:42:31.734437+00:00 intermediate_selection Team005.jpg 2  
exp_2023_02_03_10 104 team 1675449752.499532 2023-02-03T18:42:32.499532+00:00 intermediate_selection Team005.jpg   1
exp_2023_02_03_10 104 team 1675449754.117272 2023-02-03T18:42:34.117272+00:00 final_submission Team005.jpg 2 1
exp_2023_02_03_10 104 team 1675449877.8536336 2023-02-03T18:44:37.853634+00:00 intermediate_selection Team008.jpg -2  
exp_2023_02_03_10 104 team 1675449878.810351 2023-02-03T18:44:38.810351+00:00 intermediate_selection Team008.jpg   0
exp_2023_02_03_10 104 team 1675449880.271298 2023-02-03T18:44:40.271298+00:00 final_submission Team008.jpg -2 0
exp_2023_02_03_10 104 team 1675450009.4779088 2023-02-03T18:46:49.477909+00:00 intermediate_selection Team011.jpg -1  
exp_2023_02_03_10 104 team 1675450010.4693632 2023-02-03T18:46:50.469363+00:00 intermediate_selection Team011.jpg   -1
exp_2023_02_03_10 104 team 1675450012.2615356 2023-02-03T18:46:52.261536+00:00 intermediate_selection Team011.jpg 0  
exp_2023_02_03_10 104 team 1675450017.0107682 2023-02-03T18:46:57.010768+00:00 final_submission Team011.jpg 0 -1
exp_2023_02_03_10 104 team 1675450145.3748329 2023-02-03T18:49:05.374833+00:00 intermediate_selection Team014.jpg -2  
exp_2023_02_03_10 104 team 1675450147.123242 2023-02-03T18:49:07.123242+00:00 intermediate_selection Team014.jpg   0
exp_2023_02_03_10 104 team 1675450149.088829 2023-02-03T18:49:09.088829+00:00 final_submission Team014.jpg -2 0

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