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

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 96 individual 1675449225.2220616 2023-02-03T18:33:45.222062+00:00 start_affective_task      
exp_2023_02_03_10 96 individual 1675449236.040721 2023-02-03T18:33:56.040721+00:00 intermediate_selection individual000.jpg 2  
exp_2023_02_03_10 96 individual 1675449239.563457 2023-02-03T18:33:59.563457+00:00 intermediate_selection individual000.jpg   0
exp_2023_02_03_10 96 individual 1675449241.7527988 2023-02-03T18:34:01.752799+00:00 intermediate_selection individual000.jpg   1
exp_2023_02_03_10 96 individual 1675449242.820648 2023-02-03T18:34:02.820648+00:00 final_submission individual000.jpg 2 1
exp_2023_02_03_10 96 individual 1675449251.7798734 2023-02-03T18:34:11.779873+00:00 intermediate_selection individual001.jpg 1  
exp_2023_02_03_10 96 individual 1675449253.2525175 2023-02-03T18:34:13.252517+00:00 intermediate_selection individual001.jpg   0
exp_2023_02_03_10 96 individual 1675449254.844479 2023-02-03T18:34:14.844479+00:00 final_submission individual001.jpg 1 0
exp_2023_02_03_10 96 individual 1675449262.7073717 2023-02-03T18:34:22.707372+00:00 intermediate_selection individual002.jpg 0  
exp_2023_02_03_10 96 individual 1675449263.769279 2023-02-03T18:34:23.769279+00:00 intermediate_selection individual002.jpg   0
exp_2023_02_03_10 96 individual 1675449264.5164928 2023-02-03T18:34:24.516493+00:00 final_submission individual002.jpg 0 0
exp_2023_02_03_10 96 individual 1675449272.1651452 2023-02-03T18:34:32.165145+00:00 intermediate_selection individual003.jpg -2  
exp_2023_02_03_10 96 individual 1675449277.3391163 2023-02-03T18:34:37.339116+00:00 intermediate_selection individual003.jpg   1
exp_2023_02_03_10 96 individual 1675449277.9341743 2023-02-03T18:34:37.934174+00:00 intermediate_selection individual003.jpg   0
exp_2023_02_03_10 96 individual 1675449278.8053145 2023-02-03T18:34:38.805315+00:00 final_submission individual003.jpg -2 0
exp_2023_02_03_10 96 individual 1675449287.3006601 2023-02-03T18:34:47.300660+00:00 intermediate_selection individual004.jpg -2  
exp_2023_02_03_10 96 individual 1675449290.2130728 2023-02-03T18:34:50.213073+00:00 intermediate_selection individual004.jpg   0
exp_2023_02_03_10 96 individual 1675449294.2136137 2023-02-03T18:34:54.213614+00:00 final_submission individual004.jpg -2 0
exp_2023_02_03_10 96 individual 1675449302.2426593 2023-02-03T18:35:02.242659+00:00 intermediate_selection individual005.jpg 0  
exp_2023_02_03_10 96 individual 1675449302.9965749 2023-02-03T18:35:02.996575+00:00 intermediate_selection individual005.jpg   -1
exp_2023_02_03_10 96 individual 1675449304.3984258 2023-02-03T18:35:04.398426+00:00 final_submission individual005.jpg 0 -1
exp_2023_02_03_10 96 individual 1675449311.912098 2023-02-03T18:35:11.912098+00:00 intermediate_selection individual006.jpg -2  
exp_2023_02_03_10 96 individual 1675449313.3455775 2023-02-03T18:35:13.345577+00:00 intermediate_selection individual006.jpg -1  
exp_2023_02_03_10 96 individual 1675449315.3552651 2023-02-03T18:35:15.355265+00:00 intermediate_selection individual006.jpg   -1
exp_2023_02_03_10 96 individual 1675449317.7108562 2023-02-03T18:35:17.710856+00:00 final_submission individual006.jpg -1 -1
exp_2023_02_03_10 96 individual 1675449325.1811833 2023-02-03T18:35:25.181183+00:00 intermediate_selection individual007.jpg 1  
exp_2023_02_03_10 96 individual 1675449326.909456 2023-02-03T18:35:26.909456+00:00 intermediate_selection individual007.jpg   0
exp_2023_02_03_10 96 individual 1675449327.6949615 2023-02-03T18:35:27.694962+00:00 final_submission individual007.jpg 1 0
exp_2023_02_03_10 96 individual 1675449336.4147012 2023-02-03T18:35:36.414701+00:00 intermediate_selection individual008.jpg   1
exp_2023_02_03_10 96 individual 1675449338.443351 2023-02-03T18:35:38.443351+00:00 intermediate_selection individual008.jpg -1  
exp_2023_02_03_10 96 individual 1675449339.4392703 2023-02-03T18:35:39.439270+00:00 final_submission individual008.jpg -1 1
exp_2023_02_03_10 96 individual 1675449346.9543352 2023-02-03T18:35:46.954335+00:00 intermediate_selection individual009.jpg -2  
exp_2023_02_03_10 96 individual 1675449347.8045595 2023-02-03T18:35:47.804559+00:00 intermediate_selection individual009.jpg   1
exp_2023_02_03_10 96 individual 1675449348.4633007 2023-02-03T18:35:48.463301+00:00 final_submission individual009.jpg -2 1
exp_2023_02_03_10 96 individual 1675449356.0686836 2023-02-03T18:35:56.068684+00:00 intermediate_selection individual010.jpg 1  
exp_2023_02_03_10 96 individual 1675449356.9575 2023-02-03T18:35:56.957500+00:00 intermediate_selection individual010.jpg   -1
exp_2023_02_03_10 96 individual 1675449357.8159661 2023-02-03T18:35:57.815966+00:00 final_submission individual010.jpg 1 -1
exp_2023_02_03_10 96 individual 1675449365.3312094 2023-02-03T18:36:05.331209+00:00 intermediate_selection individual011.jpg 0  
exp_2023_02_03_10 96 individual 1675449366.1014297 2023-02-03T18:36:06.101430+00:00 intermediate_selection individual011.jpg   -2
exp_2023_02_03_10 96 individual 1675449366.9362698 2023-02-03T18:36:06.936270+00:00 final_submission individual011.jpg 0 -2
exp_2023_02_03_10 96 individual 1675449374.6726148 2023-02-03T18:36:14.672615+00:00 intermediate_selection individual012.jpg 1  
exp_2023_02_03_10 96 individual 1675449375.5407636 2023-02-03T18:36:15.540764+00:00 intermediate_selection individual012.jpg   -2
exp_2023_02_03_10 96 individual 1675449376.280628 2023-02-03T18:36:16.280628+00:00 final_submission individual012.jpg 1 -2
exp_2023_02_03_10 96 individual 1675449383.7990165 2023-02-03T18:36:23.799016+00:00 intermediate_selection individual013.jpg 1  
exp_2023_02_03_10 96 individual 1675449384.8011875 2023-02-03T18:36:24.801188+00:00 intermediate_selection individual013.jpg   -1
exp_2023_02_03_10 96 individual 1675449385.5207787 2023-02-03T18:36:25.520779+00:00 final_submission individual013.jpg 1 -1
exp_2023_02_03_10 96 individual 1675449393.9499927 2023-02-03T18:36:33.949993+00:00 intermediate_selection individual014.jpg   -1
exp_2023_02_03_10 96 individual 1675449394.9349678 2023-02-03T18:36:34.934968+00:00 intermediate_selection individual014.jpg 0  
exp_2023_02_03_10 96 individual 1675449397.3290133 2023-02-03T18:36:37.329013+00:00 final_submission individual014.jpg 0 -1
exp_2023_02_03_10 96 team 1675449522.3526368 2023-02-03T18:38:42.352637+00:00 intermediate_selection Team000.jpg -1  
exp_2023_02_03_10 96 team 1675449524.126567 2023-02-03T18:38:44.126567+00:00 intermediate_selection Team000.jpg   0
exp_2023_02_03_10 96 team 1675449524.4672313 2023-02-03T18:38:44.467231+00:00 final_submission Team000.jpg -1 0
exp_2023_02_03_10 96 team 1675449660.001894 2023-02-03T18:41:00.001894+00:00 intermediate_selection Team003.jpg 1  
exp_2023_02_03_10 96 team 1675449661.8100202 2023-02-03T18:41:01.810020+00:00 intermediate_selection Team003.jpg   -1
exp_2023_02_03_10 96 team 1675449662.586279 2023-02-03T18:41:02.586279+00:00 intermediate_selection Team003.jpg   0
exp_2023_02_03_10 96 team 1675449665.3725371 2023-02-03T18:41:05.372537+00:00 intermediate_selection Team003.jpg   1
exp_2023_02_03_10 96 team 1675449668.215388 2023-02-03T18:41:08.215388+00:00 final_submission Team003.jpg 1 1
exp_2023_02_03_10 96 team 1675449793.8918054 2023-02-03T18:43:13.891805+00:00 intermediate_selection Team006.jpg 2  
exp_2023_02_03_10 96 team 1675449795.301814 2023-02-03T18:43:15.301814+00:00 intermediate_selection Team006.jpg   1
exp_2023_02_03_10 96 team 1675449797.0864692 2023-02-03T18:43:17.086469+00:00 final_submission Team006.jpg 2 1
exp_2023_02_03_10 96 team 1675449920.3781955 2023-02-03T18:45:20.378196+00:00 intermediate_selection Team009.jpg -2  
exp_2023_02_03_10 96 team 1675449921.6015651 2023-02-03T18:45:21.601565+00:00 intermediate_selection Team009.jpg   -1
exp_2023_02_03_10 96 team 1675449922.3184965 2023-02-03T18:45:22.318496+00:00 intermediate_selection Team009.jpg   0
exp_2023_02_03_10 96 team 1675449923.2659237 2023-02-03T18:45:23.265924+00:00 intermediate_selection Team009.jpg   -1
exp_2023_02_03_10 96 team 1675449924.2909467 2023-02-03T18:45:24.290947+00:00 final_submission Team009.jpg -2 -1
exp_2023_02_03_10 96 team 1675450056.9271455 2023-02-03T18:47:36.927145+00:00 intermediate_selection Team012.jpg 1  
exp_2023_02_03_10 96 team 1675450058.5444667 2023-02-03T18:47:38.544467+00:00 intermediate_selection Team012.jpg   0
exp_2023_02_03_10 96 team 1675450059.085036 2023-02-03T18:47:39.085036+00:00 intermediate_selection Team012.jpg   1
exp_2023_02_03_10 96 team 1675450063.3306117 2023-02-03T18:47:43.330612+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]);