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

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_01_31_14 94 individual 1675206508.3518152 2023-01-31T23:08:28.351815+00:00 start_affective_task      
exp_2023_01_31_14 94 individual 1675206518.7313402 2023-01-31T23:08:38.731340+00:00 intermediate_selection individual000.jpg 1  
exp_2023_01_31_14 94 individual 1675206522.670433 2023-01-31T23:08:42.670433+00:00 intermediate_selection individual000.jpg   -2
exp_2023_01_31_14 94 individual 1675206523.5638292 2023-01-31T23:08:43.563829+00:00 intermediate_selection individual000.jpg   -1
exp_2023_01_31_14 94 individual 1675206524.319158 2023-01-31T23:08:44.319158+00:00 final_submission individual000.jpg 1 -1
exp_2023_01_31_14 94 individual 1675206534.141767 2023-01-31T23:08:54.141767+00:00 intermediate_selection individual001.jpg 1  
exp_2023_01_31_14 94 individual 1675206535.9392629 2023-01-31T23:08:55.939263+00:00 intermediate_selection individual001.jpg   1
exp_2023_01_31_14 94 individual 1675206537.4075847 2023-01-31T23:08:57.407585+00:00 final_submission individual001.jpg 1 1
exp_2023_01_31_14 94 individual 1675206545.2875934 2023-01-31T23:09:05.287593+00:00 intermediate_selection individual002.jpg -1  
exp_2023_01_31_14 94 individual 1675206547.5568898 2023-01-31T23:09:07.556890+00:00 intermediate_selection individual002.jpg   0
exp_2023_01_31_14 94 individual 1675206549.4028056 2023-01-31T23:09:09.402806+00:00 intermediate_selection individual002.jpg 0  
exp_2023_01_31_14 94 individual 1675206550.640144 2023-01-31T23:09:10.640144+00:00 final_submission individual002.jpg 0 0
exp_2023_01_31_14 94 individual 1675206560.0463555 2023-01-31T23:09:20.046355+00:00 intermediate_selection individual003.jpg -1  
exp_2023_01_31_14 94 individual 1675206562.9506223 2023-01-31T23:09:22.950622+00:00 intermediate_selection individual003.jpg   1
exp_2023_01_31_14 94 individual 1675206563.9183393 2023-01-31T23:09:23.918339+00:00 intermediate_selection individual003.jpg   2
exp_2023_01_31_14 94 individual 1675206566.280348 2023-01-31T23:09:26.280348+00:00 final_submission individual003.jpg -1 2
exp_2023_01_31_14 94 individual 1675206578.1741898 2023-01-31T23:09:38.174190+00:00 intermediate_selection individual004.jpg -2  
exp_2023_01_31_14 94 individual 1675206579.1497324 2023-01-31T23:09:39.149732+00:00 intermediate_selection individual004.jpg   2
exp_2023_01_31_14 94 individual 1675206580.5609002 2023-01-31T23:09:40.560900+00:00 final_submission individual004.jpg -2 2
exp_2023_01_31_14 94 individual 1675206588.2838972 2023-01-31T23:09:48.283897+00:00 intermediate_selection individual005.jpg 0  
exp_2023_01_31_14 94 individual 1675206596.5974195 2023-01-31T23:09:56.597420+00:00 intermediate_selection individual005.jpg   -2
exp_2023_01_31_14 94 individual 1675206599.1134925 2023-01-31T23:09:59.113492+00:00 final_submission individual005.jpg 0 -2
exp_2023_01_31_14 94 individual 1675206608.3020236 2023-01-31T23:10:08.302024+00:00 intermediate_selection individual006.jpg -2  
exp_2023_01_31_14 94 individual 1675206609.6597197 2023-01-31T23:10:09.659720+00:00 intermediate_selection individual006.jpg   1
exp_2023_01_31_14 94 individual 1675206611.1378696 2023-01-31T23:10:11.137870+00:00 final_submission individual006.jpg -2 1
exp_2023_01_31_14 94 individual 1675206620.2796721 2023-01-31T23:10:20.279672+00:00 intermediate_selection individual007.jpg 1  
exp_2023_01_31_14 94 individual 1675206621.5439286 2023-01-31T23:10:21.543929+00:00 intermediate_selection individual007.jpg   1
exp_2023_01_31_14 94 individual 1675206622.5542297 2023-01-31T23:10:22.554230+00:00 final_submission individual007.jpg 1 1
exp_2023_01_31_14 94 individual 1675206631.1525776 2023-01-31T23:10:31.152578+00:00 intermediate_selection individual008.jpg -2  
exp_2023_01_31_14 94 individual 1675206632.6247618 2023-01-31T23:10:32.624762+00:00 intermediate_selection individual008.jpg   -2
exp_2023_01_31_14 94 individual 1675206633.4645855 2023-01-31T23:10:33.464586+00:00 intermediate_selection individual008.jpg   -2
exp_2023_01_31_14 94 individual 1675206634.4721715 2023-01-31T23:10:34.472172+00:00 intermediate_selection individual008.jpg   1
exp_2023_01_31_14 94 individual 1675206635.906663 2023-01-31T23:10:35.906663+00:00 final_submission individual008.jpg -2 1
exp_2023_01_31_14 94 individual 1675206645.876364 2023-01-31T23:10:45.876364+00:00 intermediate_selection individual009.jpg -2  
exp_2023_01_31_14 94 individual 1675206647.5369806 2023-01-31T23:10:47.536981+00:00 intermediate_selection individual009.jpg   2
exp_2023_01_31_14 94 individual 1675206648.674792 2023-01-31T23:10:48.674792+00:00 final_submission individual009.jpg -2 2
exp_2023_01_31_14 94 individual 1675206657.0472443 2023-01-31T23:10:57.047244+00:00 intermediate_selection individual010.jpg 1  
exp_2023_01_31_14 94 individual 1675206659.1865075 2023-01-31T23:10:59.186507+00:00 intermediate_selection individual010.jpg   -2
exp_2023_01_31_14 94 individual 1675206660.107498 2023-01-31T23:11:00.107498+00:00 final_submission individual010.jpg 1 -2
exp_2023_01_31_14 94 individual 1675206669.5676785 2023-01-31T23:11:09.567678+00:00 intermediate_selection individual011.jpg 0  
exp_2023_01_31_14 94 individual 1675206670.8349924 2023-01-31T23:11:10.834992+00:00 intermediate_selection individual011.jpg   -2
exp_2023_01_31_14 94 individual 1675206671.7717032 2023-01-31T23:11:11.771703+00:00 final_submission individual011.jpg 0 -2
exp_2023_01_31_14 94 individual 1675206679.841938 2023-01-31T23:11:19.841938+00:00 intermediate_selection individual012.jpg 0  
exp_2023_01_31_14 94 individual 1675206681.305328 2023-01-31T23:11:21.305328+00:00 intermediate_selection individual012.jpg   -2
exp_2023_01_31_14 94 individual 1675206682.356004 2023-01-31T23:11:22.356004+00:00 final_submission individual012.jpg 0 -2
exp_2023_01_31_14 94 individual 1675206691.9331458 2023-01-31T23:11:31.933146+00:00 intermediate_selection individual013.jpg 1  
exp_2023_01_31_14 94 individual 1675206693.8763337 2023-01-31T23:11:33.876334+00:00 intermediate_selection individual013.jpg   0
exp_2023_01_31_14 94 individual 1675206695.4205468 2023-01-31T23:11:35.420547+00:00 final_submission individual013.jpg 1 0
exp_2023_01_31_14 94 individual 1675206703.8443015 2023-01-31T23:11:43.844301+00:00 intermediate_selection individual014.jpg 0  
exp_2023_01_31_14 94 individual 1675206708.9845643 2023-01-31T23:11:48.984564+00:00 intermediate_selection individual014.jpg   -1
exp_2023_01_31_14 94 individual 1675206714.2900443 2023-01-31T23:11:54.290044+00:00 intermediate_selection individual014.jpg -1  
exp_2023_01_31_14 94 individual 1675206716.075496 2023-01-31T23:11:56.075496+00:00 final_submission individual014.jpg -1 -1
exp_2023_01_31_14 94 team 1675206901.4249704 2023-01-31T23:15:01.424970+00:00 intermediate_selection Team000.jpg -2  
exp_2023_01_31_14 94 team 1675206903.4091663 2023-01-31T23:15:03.409166+00:00 intermediate_selection Team000.jpg   2
exp_2023_01_31_14 94 team 1675206905.301308 2023-01-31T23:15:05.301308+00:00 final_submission Team000.jpg -2 2
exp_2023_01_31_14 94 team 1675207039.617535 2023-01-31T23:17:19.617535+00:00 intermediate_selection Team003.jpg 0  
exp_2023_01_31_14 94 team 1675207042.770918 2023-01-31T23:17:22.770918+00:00 intermediate_selection Team003.jpg   0
exp_2023_01_31_14 94 team 1675207044.5376217 2023-01-31T23:17:24.537622+00:00 final_submission Team003.jpg 0 0
exp_2023_01_31_14 94 team 1675207181.386401 2023-01-31T23:19:41.386401+00:00 intermediate_selection Team006.jpg 2  
exp_2023_01_31_14 94 team 1675207183.9363797 2023-01-31T23:19:43.936380+00:00 intermediate_selection Team006.jpg   0
exp_2023_01_31_14 94 team 1675207185.7061543 2023-01-31T23:19:45.706154+00:00 final_submission Team006.jpg 2 0
exp_2023_01_31_14 94 team 1675207314.879865 2023-01-31T23:21:54.879865+00:00 intermediate_selection Team009.jpg -2  
exp_2023_01_31_14 94 team 1675207316.6816316 2023-01-31T23:21:56.681632+00:00 intermediate_selection Team009.jpg   2
exp_2023_01_31_14 94 team 1675207318.7329426 2023-01-31T23:21:58.732943+00:00 final_submission Team009.jpg -2 2
exp_2023_01_31_14 94 team 1675207445.0148792 2023-01-31T23:24:05.014879+00:00 intermediate_selection Team012.jpg 1  
exp_2023_01_31_14 94 team 1675207447.8069162 2023-01-31T23:24:07.806916+00:00 intermediate_selection Team012.jpg   -1
exp_2023_01_31_14 94 team 1675207449.6966445 2023-01-31T23:24:09.696645+00:00 final_submission Team012.jpg 1 -1

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