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

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_07_14 111 individual 1675807778.8011775 2023-02-07T22:09:38.801178+00:00 start_affective_task      
exp_2023_02_07_14 111 individual 1675807788.978395 2023-02-07T22:09:48.978395+00:00 intermediate_selection individual000.jpg 0  
exp_2023_02_07_14 111 individual 1675807790.7351422 2023-02-07T22:09:50.735142+00:00 intermediate_selection individual000.jpg   -1
exp_2023_02_07_14 111 individual 1675807792.0038188 2023-02-07T22:09:52.003819+00:00 final_submission individual000.jpg 0 -1
exp_2023_02_07_14 111 individual 1675807801.0959423 2023-02-07T22:10:01.095942+00:00 intermediate_selection individual001.jpg 0  
exp_2023_02_07_14 111 individual 1675807802.4632983 2023-02-07T22:10:02.463298+00:00 intermediate_selection individual001.jpg   0
exp_2023_02_07_14 111 individual 1675807803.0041301 2023-02-07T22:10:03.004130+00:00 final_submission individual001.jpg 0 0
exp_2023_02_07_14 111 individual 1675807813.864686 2023-02-07T22:10:13.864686+00:00 intermediate_selection individual002.jpg 1  
exp_2023_02_07_14 111 individual 1675807814.4796026 2023-02-07T22:10:14.479603+00:00 intermediate_selection individual002.jpg 2  
exp_2023_02_07_14 111 individual 1675807816.5313091 2023-02-07T22:10:16.531309+00:00 intermediate_selection individual002.jpg   -1
exp_2023_02_07_14 111 individual 1675807818.0447445 2023-02-07T22:10:18.044744+00:00 final_submission individual002.jpg 2 -1
exp_2023_02_07_14 111 individual 1675807827.2738006 2023-02-07T22:10:27.273801+00:00 intermediate_selection individual003.jpg -1  
exp_2023_02_07_14 111 individual 1675807828.1290421 2023-02-07T22:10:28.129042+00:00 intermediate_selection individual003.jpg 0  
exp_2023_02_07_14 111 individual 1675807830.7856731 2023-02-07T22:10:30.785673+00:00 intermediate_selection individual003.jpg   0
exp_2023_02_07_14 111 individual 1675807832.645636 2023-02-07T22:10:32.645636+00:00 final_submission individual003.jpg 0 0
exp_2023_02_07_14 111 individual 1675807840.5634942 2023-02-07T22:10:40.563494+00:00 intermediate_selection individual004.jpg -2  
exp_2023_02_07_14 111 individual 1675807843.2909322 2023-02-07T22:10:43.290932+00:00 intermediate_selection individual004.jpg   0
exp_2023_02_07_14 111 individual 1675807844.0455413 2023-02-07T22:10:44.045541+00:00 final_submission individual004.jpg -2 0
exp_2023_02_07_14 111 individual 1675807852.1771903 2023-02-07T22:10:52.177190+00:00 intermediate_selection individual005.jpg 2  
exp_2023_02_07_14 111 individual 1675807852.9176233 2023-02-07T22:10:52.917623+00:00 intermediate_selection individual005.jpg   2
exp_2023_02_07_14 111 individual 1675807854.821901 2023-02-07T22:10:54.821901+00:00 final_submission individual005.jpg 2 2
exp_2023_02_07_14 111 individual 1675807863.3424768 2023-02-07T22:11:03.342477+00:00 intermediate_selection individual006.jpg -1  
exp_2023_02_07_14 111 individual 1675807867.016226 2023-02-07T22:11:07.016226+00:00 intermediate_selection individual006.jpg   -1
exp_2023_02_07_14 111 individual 1675807869.5201693 2023-02-07T22:11:09.520169+00:00 intermediate_selection individual006.jpg   0
exp_2023_02_07_14 111 individual 1675807871.1340992 2023-02-07T22:11:11.134099+00:00 intermediate_selection individual006.jpg   -1
exp_2023_02_07_14 111 individual 1675807871.9070208 2023-02-07T22:11:11.907021+00:00 intermediate_selection individual006.jpg   0
exp_2023_02_07_14 111 individual 1675807872.2763677 2023-02-07T22:11:12.276368+00:00 final_submission individual006.jpg -1 0
exp_2023_02_07_14 111 individual 1675807880.9720228 2023-02-07T22:11:20.972023+00:00 intermediate_selection individual007.jpg 1  
exp_2023_02_07_14 111 individual 1675807881.814104 2023-02-07T22:11:21.814104+00:00 intermediate_selection individual007.jpg   1
exp_2023_02_07_14 111 individual 1675807884.550723 2023-02-07T22:11:24.550723+00:00 final_submission individual007.jpg 1 1
exp_2023_02_07_14 111 individual 1675807892.9217322 2023-02-07T22:11:32.921732+00:00 intermediate_selection individual008.jpg -2  
exp_2023_02_07_14 111 individual 1675807894.4884639 2023-02-07T22:11:34.488464+00:00 intermediate_selection individual008.jpg   0
exp_2023_02_07_14 111 individual 1675807896.2155037 2023-02-07T22:11:36.215504+00:00 final_submission individual008.jpg -2 0
exp_2023_02_07_14 111 individual 1675807903.8168595 2023-02-07T22:11:43.816859+00:00 intermediate_selection individual009.jpg -2  
exp_2023_02_07_14 111 individual 1675807905.7392862 2023-02-07T22:11:45.739286+00:00 intermediate_selection individual009.jpg   0
exp_2023_02_07_14 111 individual 1675807908.927803 2023-02-07T22:11:48.927803+00:00 final_submission individual009.jpg -2 0
exp_2023_02_07_14 111 individual 1675807916.9409997 2023-02-07T22:11:56.941000+00:00 intermediate_selection individual010.jpg 1  
exp_2023_02_07_14 111 individual 1675807917.9643934 2023-02-07T22:11:57.964393+00:00 intermediate_selection individual010.jpg   1
exp_2023_02_07_14 111 individual 1675807918.8399904 2023-02-07T22:11:58.839990+00:00 final_submission individual010.jpg 1 1
exp_2023_02_07_14 111 individual 1675807926.1073422 2023-02-07T22:12:06.107342+00:00 intermediate_selection individual011.jpg 0  
exp_2023_02_07_14 111 individual 1675807926.4718528 2023-02-07T22:12:06.471853+00:00 intermediate_selection individual011.jpg   0
exp_2023_02_07_14 111 individual 1675807927.1606576 2023-02-07T22:12:07.160658+00:00 final_submission individual011.jpg 0 0
exp_2023_02_07_14 111 individual 1675807934.7562351 2023-02-07T22:12:14.756235+00:00 intermediate_selection individual012.jpg -1  
exp_2023_02_07_14 111 individual 1675807936.1901972 2023-02-07T22:12:16.190197+00:00 intermediate_selection individual012.jpg   0
exp_2023_02_07_14 111 individual 1675807936.9929423 2023-02-07T22:12:16.992942+00:00 final_submission individual012.jpg -1 0
exp_2023_02_07_14 111 individual 1675807945.1092277 2023-02-07T22:12:25.109228+00:00 intermediate_selection individual013.jpg 1  
exp_2023_02_07_14 111 individual 1675807946.6766768 2023-02-07T22:12:26.676677+00:00 intermediate_selection individual013.jpg   0
exp_2023_02_07_14 111 individual 1675807947.9026895 2023-02-07T22:12:27.902689+00:00 intermediate_selection individual013.jpg   1
exp_2023_02_07_14 111 individual 1675807949.361265 2023-02-07T22:12:29.361265+00:00 final_submission individual013.jpg 1 1
exp_2023_02_07_14 111 individual 1675807957.635465 2023-02-07T22:12:37.635465+00:00 intermediate_selection individual014.jpg 0  
exp_2023_02_07_14 111 individual 1675807958.824871 2023-02-07T22:12:38.824871+00:00 intermediate_selection individual014.jpg   0
exp_2023_02_07_14 111 individual 1675807960.561849 2023-02-07T22:12:40.561849+00:00 final_submission individual014.jpg 0 0
exp_2023_02_07_14 111 team 1675808122.4164948 2023-02-07T22:15:22.416495+00:00 intermediate_selection Team001.jpg 2  
exp_2023_02_07_14 111 team 1675808124.570638 2023-02-07T22:15:24.570638+00:00 intermediate_selection Team001.jpg 1  
exp_2023_02_07_14 111 team 1675808126.1275804 2023-02-07T22:15:26.127580+00:00 intermediate_selection Team001.jpg   -2
exp_2023_02_07_14 111 team 1675808129.0997372 2023-02-07T22:15:29.099737+00:00 intermediate_selection Team001.jpg 2  
exp_2023_02_07_14 111 team 1675808129.9061358 2023-02-07T22:15:29.906136+00:00 final_submission Team001.jpg 2 -2
exp_2023_02_07_14 111 team 1675808258.514924 2023-02-07T22:17:38.514924+00:00 intermediate_selection Team004.jpg 1  
exp_2023_02_07_14 111 team 1675808260.3179116 2023-02-07T22:17:40.317912+00:00 intermediate_selection Team004.jpg   0
exp_2023_02_07_14 111 team 1675808265.8625546 2023-02-07T22:17:45.862555+00:00 intermediate_selection Team004.jpg   2
exp_2023_02_07_14 111 team 1675808267.6653965 2023-02-07T22:17:47.665396+00:00 final_submission Team004.jpg 1 2
exp_2023_02_07_14 111 team 1675808393.3979123 2023-02-07T22:19:53.397912+00:00 intermediate_selection Team007.jpg 0  
exp_2023_02_07_14 111 team 1675808394.366021 2023-02-07T22:19:54.366021+00:00 intermediate_selection Team007.jpg   -2
exp_2023_02_07_14 111 team 1675808395.728152 2023-02-07T22:19:55.728152+00:00 final_submission Team007.jpg 0 -2
exp_2023_02_07_14 111 team 1675808520.3802876 2023-02-07T22:22:00.380288+00:00 intermediate_selection Team010.jpg 0  
exp_2023_02_07_14 111 team 1675808521.083267 2023-02-07T22:22:01.083267+00:00 intermediate_selection Team010.jpg   0
exp_2023_02_07_14 111 team 1675808521.90841 2023-02-07T22:22:01.908410+00:00 final_submission Team010.jpg 0 0
exp_2023_02_07_14 111 team 1675808645.773844 2023-02-07T22:24:05.773844+00:00 intermediate_selection Team013.jpg 2  
exp_2023_02_07_14 111 team 1675808646.5386817 2023-02-07T22:24:06.538682+00:00 intermediate_selection Team013.jpg   1
exp_2023_02_07_14 111 team 1675808647.392646 2023-02-07T22:24:07.392646+00:00 final_submission Team013.jpg 2 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]);