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_01_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_01_10 -2 team 1667327709.2374027 2022-11-01T18:35:09.237403+00:00 start_affective_task      
exp_2022_11_01_10 63 individual 1667327411.4839463 2022-11-01T18:30:11.483946+00:00 start_affective_task      
exp_2022_11_01_10 63 individual 1667327420.0397587 2022-11-01T18:30:20.039759+00:00 intermediate_selection individual000.jpg -1  
exp_2022_11_01_10 63 individual 1667327422.100468 2022-11-01T18:30:22.100468+00:00 intermediate_selection individual000.jpg   -2
exp_2022_11_01_10 63 individual 1667327424.4398835 2022-11-01T18:30:24.439883+00:00 final_submission individual000.jpg -1 -2
exp_2022_11_01_10 63 individual 1667327432.4869223 2022-11-01T18:30:32.486922+00:00 intermediate_selection individual001.jpg 0  
exp_2022_11_01_10 63 individual 1667327433.4878852 2022-11-01T18:30:33.487885+00:00 intermediate_selection individual001.jpg   0
exp_2022_11_01_10 63 individual 1667327434.6482673 2022-11-01T18:30:34.648267+00:00 final_submission individual001.jpg 0 0
exp_2022_11_01_10 63 individual 1667327442.645551 2022-11-01T18:30:42.645551+00:00 intermediate_selection individual002.jpg 1  
exp_2022_11_01_10 63 individual 1667327444.0026896 2022-11-01T18:30:44.002690+00:00 intermediate_selection individual002.jpg   0
exp_2022_11_01_10 63 individual 1667327445.7157674 2022-11-01T18:30:45.715767+00:00 intermediate_selection individual002.jpg   1
exp_2022_11_01_10 63 individual 1667327447.8277934 2022-11-01T18:30:47.827793+00:00 intermediate_selection individual002.jpg   0
exp_2022_11_01_10 63 individual 1667327448.5935478 2022-11-01T18:30:48.593548+00:00 final_submission individual002.jpg 1 0
exp_2022_11_01_10 63 individual 1667327457.6940062 2022-11-01T18:30:57.694006+00:00 intermediate_selection individual003.jpg -2  
exp_2022_11_01_10 63 individual 1667327459.4292116 2022-11-01T18:30:59.429212+00:00 intermediate_selection individual003.jpg   2
exp_2022_11_01_10 63 individual 1667327461.8208961 2022-11-01T18:31:01.820896+00:00 intermediate_selection individual003.jpg   1
exp_2022_11_01_10 63 individual 1667327467.164668 2022-11-01T18:31:07.164668+00:00 intermediate_selection individual003.jpg   -2
exp_2022_11_01_10 63 individual 1667327468.2000606 2022-11-01T18:31:08.200061+00:00 final_submission individual003.jpg -2 -2
exp_2022_11_01_10 63 individual 1667327475.9318871 2022-11-01T18:31:15.931887+00:00 intermediate_selection individual004.jpg -2  
exp_2022_11_01_10 63 individual 1667327477.0536158 2022-11-01T18:31:17.053616+00:00 intermediate_selection individual004.jpg   2
exp_2022_11_01_10 63 individual 1667327479.4420166 2022-11-01T18:31:19.442017+00:00 final_submission individual004.jpg -2 2
exp_2022_11_01_10 63 individual 1667327487.2386847 2022-11-01T18:31:27.238685+00:00 intermediate_selection individual005.jpg 0  
exp_2022_11_01_10 63 individual 1667327487.8467395 2022-11-01T18:31:27.846740+00:00 intermediate_selection individual005.jpg   0
exp_2022_11_01_10 63 individual 1667327488.8342006 2022-11-01T18:31:28.834201+00:00 final_submission individual005.jpg 0 0
exp_2022_11_01_10 63 individual 1667327497.048513 2022-11-01T18:31:37.048513+00:00 intermediate_selection individual006.jpg -2  
exp_2022_11_01_10 63 individual 1667327498.6059248 2022-11-01T18:31:38.605925+00:00 intermediate_selection individual006.jpg   0
exp_2022_11_01_10 63 individual 1667327499.3107119 2022-11-01T18:31:39.310712+00:00 intermediate_selection individual006.jpg   1
exp_2022_11_01_10 63 individual 1667327502.4640067 2022-11-01T18:31:42.464007+00:00 intermediate_selection individual006.jpg   0
exp_2022_11_01_10 63 individual 1667327504.538747 2022-11-01T18:31:44.538747+00:00 final_submission individual006.jpg -2 0
exp_2022_11_01_10 63 individual 1667327512.4620924 2022-11-01T18:31:52.462092+00:00 intermediate_selection individual007.jpg 2  
exp_2022_11_01_10 63 individual 1667327513.0955014 2022-11-01T18:31:53.095501+00:00 intermediate_selection individual007.jpg   2
exp_2022_11_01_10 63 individual 1667327513.6747997 2022-11-01T18:31:53.674800+00:00 final_submission individual007.jpg 2 2
exp_2022_11_01_10 63 individual 1667327523.633027 2022-11-01T18:32:03.633027+00:00 intermediate_selection individual008.jpg -2  
exp_2022_11_01_10 63 individual 1667327524.6653998 2022-11-01T18:32:04.665400+00:00 intermediate_selection individual008.jpg   2
exp_2022_11_01_10 63 individual 1667327525.515629 2022-11-01T18:32:05.515629+00:00 final_submission individual008.jpg -2 2
exp_2022_11_01_10 63 individual 1667327533.2859244 2022-11-01T18:32:13.285924+00:00 intermediate_selection individual009.jpg -2  
exp_2022_11_01_10 63 individual 1667327534.172217 2022-11-01T18:32:14.172217+00:00 intermediate_selection individual009.jpg   2
exp_2022_11_01_10 63 individual 1667327534.8520067 2022-11-01T18:32:14.852007+00:00 final_submission individual009.jpg -2 2
exp_2022_11_01_10 63 individual 1667327543.824374 2022-11-01T18:32:23.824374+00:00 intermediate_selection individual010.jpg 2  
exp_2022_11_01_10 63 individual 1667327545.031478 2022-11-01T18:32:25.031478+00:00 intermediate_selection individual010.jpg   1
exp_2022_11_01_10 63 individual 1667327545.644121 2022-11-01T18:32:25.644121+00:00 final_submission individual010.jpg 2 1
exp_2022_11_01_10 63 individual 1667327553.6864169 2022-11-01T18:32:33.686417+00:00 intermediate_selection individual011.jpg 0  
exp_2022_11_01_10 63 individual 1667327554.3109465 2022-11-01T18:32:34.310946+00:00 intermediate_selection individual011.jpg   0
exp_2022_11_01_10 63 individual 1667327555.300078 2022-11-01T18:32:35.300078+00:00 final_submission individual011.jpg 0 0
exp_2022_11_01_10 63 individual 1667327562.767439 2022-11-01T18:32:42.767439+00:00 intermediate_selection individual012.jpg 0  
exp_2022_11_01_10 63 individual 1667327563.512092 2022-11-01T18:32:43.512092+00:00 intermediate_selection individual012.jpg   0
exp_2022_11_01_10 63 individual 1667327565.668871 2022-11-01T18:32:45.668871+00:00 final_submission individual012.jpg 0 0
exp_2022_11_01_10 63 individual 1667327573.3558064 2022-11-01T18:32:53.355806+00:00 intermediate_selection individual013.jpg 1  
exp_2022_11_01_10 63 individual 1667327573.905132 2022-11-01T18:32:53.905132+00:00 intermediate_selection individual013.jpg   1
exp_2022_11_01_10 63 individual 1667327574.588663 2022-11-01T18:32:54.588663+00:00 final_submission individual013.jpg 1 1
exp_2022_11_01_10 63 individual 1667327582.1189294 2022-11-01T18:33:02.118929+00:00 intermediate_selection individual014.jpg -2  
exp_2022_11_01_10 63 individual 1667327584.3720443 2022-11-01T18:33:04.372044+00:00 intermediate_selection individual014.jpg   -2
exp_2022_11_01_10 63 individual 1667327585.2292178 2022-11-01T18:33:05.229218+00:00 final_submission individual014.jpg -2 -2
exp_2022_11_01_10 63 team 1667327758.2092257 2022-11-01T18:35:58.209226+00:00 final_submission Team000.jpg    
exp_2022_11_01_10 63 team 1667327892.6871595 2022-11-01T18:38:12.687160+00:00 intermediate_selection Team003.jpg 2  
exp_2022_11_01_10 63 team 1667327893.5191736 2022-11-01T18:38:13.519174+00:00 intermediate_selection Team003.jpg   2
exp_2022_11_01_10 63 team 1667327897.7235985 2022-11-01T18:38:17.723598+00:00 final_submission Team003.jpg 2 2
exp_2022_11_01_10 63 team 1667328028.7050083 2022-11-01T18:40:28.705008+00:00 intermediate_selection Team006.jpg -2  
exp_2022_11_01_10 63 team 1667328029.3914938 2022-11-01T18:40:29.391494+00:00 intermediate_selection Team006.jpg   -2
exp_2022_11_01_10 63 team 1667328031.3324926 2022-11-01T18:40:31.332493+00:00 final_submission Team006.jpg -2 -2
exp_2022_11_01_10 63 team 1667328154.774659 2022-11-01T18:42:34.774659+00:00 intermediate_selection Team009.jpg -2  
exp_2022_11_01_10 63 team 1667328155.2868373 2022-11-01T18:42:35.286837+00:00 intermediate_selection Team009.jpg   -2
exp_2022_11_01_10 63 team 1667328156.0088174 2022-11-01T18:42:36.008817+00:00 final_submission Team009.jpg -2 -2
exp_2022_11_01_10 63 team 1667328282.5371258 2022-11-01T18:44:42.537126+00:00 intermediate_selection Team012.jpg 0  
exp_2022_11_01_10 63 team 1667328283.4314299 2022-11-01T18:44:43.431430+00:00 intermediate_selection Team012.jpg 1  
exp_2022_11_01_10 63 team 1667328286.105684 2022-11-01T18:44:46.105684+00:00 intermediate_selection Team012.jpg 0  
exp_2022_11_01_10 63 team 1667328286.672995 2022-11-01T18:44:46.672995+00:00 intermediate_selection Team012.jpg   0
exp_2022_11_01_10 63 team 1667328288.315573 2022-11-01T18:44:48.315573+00:00 final_submission Team012.jpg 0 0
exp_2022_11_01_10 67 individual 1667327411.503102 2022-11-01T18:30:11.503102+00:00 start_affective_task      
exp_2022_11_01_10 67 individual 1667327422.3224118 2022-11-01T18:30:22.322412+00:00 intermediate_selection individual000.jpg 1  
exp_2022_11_01_10 67 individual 1667327424.1213653 2022-11-01T18:30:24.121365+00:00 intermediate_selection individual000.jpg   -2
exp_2022_11_01_10 67 individual 1667327425.0387301 2022-11-01T18:30:25.038730+00:00 final_submission individual000.jpg 1 -2
exp_2022_11_01_10 67 individual 1667327434.2459342 2022-11-01T18:30:34.245934+00:00 intermediate_selection individual001.jpg 0  
exp_2022_11_01_10 67 individual 1667327436.779253 2022-11-01T18:30:36.779253+00:00 intermediate_selection individual001.jpg   -2
exp_2022_11_01_10 67 individual 1667327437.8718235 2022-11-01T18:30:37.871824+00:00 final_submission individual001.jpg 0 -2
exp_2022_11_01_10 67 individual 1667327447.1543787 2022-11-01T18:30:47.154379+00:00 intermediate_selection individual002.jpg 0  
exp_2022_11_01_10 67 individual 1667327449.8762019 2022-11-01T18:30:49.876202+00:00 intermediate_selection individual002.jpg   -1
exp_2022_11_01_10 67 individual 1667327458.7499244 2022-11-01T18:30:58.749924+00:00 final_submission individual002.jpg 0 -1
exp_2022_11_01_10 67 individual 1667327468.6150107 2022-11-01T18:31:08.615011+00:00 intermediate_selection individual003.jpg -1  
exp_2022_11_01_10 67 individual 1667327470.958021 2022-11-01T18:31:10.958021+00:00 intermediate_selection individual003.jpg   -2
exp_2022_11_01_10 67 individual 1667327473.581692 2022-11-01T18:31:13.581692+00:00 intermediate_selection individual003.jpg   0
exp_2022_11_01_10 67 individual 1667327474.5097425 2022-11-01T18:31:14.509742+00:00 intermediate_selection individual003.jpg   -2
exp_2022_11_01_10 67 individual 1667327475.4725494 2022-11-01T18:31:15.472549+00:00 final_submission individual003.jpg -1 -2
exp_2022_11_01_10 67 individual 1667327483.3304942 2022-11-01T18:31:23.330494+00:00 intermediate_selection individual004.jpg -1  
exp_2022_11_01_10 67 individual 1667327485.9100668 2022-11-01T18:31:25.910067+00:00 intermediate_selection individual004.jpg   -1
exp_2022_11_01_10 67 individual 1667327486.6488667 2022-11-01T18:31:26.648867+00:00 final_submission individual004.jpg -1 -1
exp_2022_11_01_10 67 individual 1667327495.5483265 2022-11-01T18:31:35.548326+00:00 intermediate_selection individual005.jpg 1  
exp_2022_11_01_10 67 individual 1667327497.1977751 2022-11-01T18:31:37.197775+00:00 intermediate_selection individual005.jpg   0
exp_2022_11_01_10 67 individual 1667327499.6415682 2022-11-01T18:31:39.641568+00:00 final_submission individual005.jpg 1 0
exp_2022_11_01_10 67 individual 1667327508.3729768 2022-11-01T18:31:48.372977+00:00 intermediate_selection individual006.jpg -2  
exp_2022_11_01_10 67 individual 1667327511.1967933 2022-11-01T18:31:51.196793+00:00 intermediate_selection individual006.jpg   0
exp_2022_11_01_10 67 individual 1667327512.1698482 2022-11-01T18:31:52.169848+00:00 final_submission individual006.jpg -2 0
exp_2022_11_01_10 67 individual 1667327520.0581377 2022-11-01T18:32:00.058138+00:00 intermediate_selection individual007.jpg 0  
exp_2022_11_01_10 67 individual 1667327522.3825624 2022-11-01T18:32:02.382562+00:00 intermediate_selection individual007.jpg   0
exp_2022_11_01_10 67 individual 1667327523.1226132 2022-11-01T18:32:03.122613+00:00 final_submission individual007.jpg 0 0
exp_2022_11_01_10 67 individual 1667327532.2632399 2022-11-01T18:32:12.263240+00:00 intermediate_selection individual008.jpg 0  
exp_2022_11_01_10 67 individual 1667327535.6629553 2022-11-01T18:32:15.662955+00:00 intermediate_selection individual008.jpg   1
exp_2022_11_01_10 67 individual 1667327536.6344779 2022-11-01T18:32:16.634478+00:00 final_submission individual008.jpg 0 1
exp_2022_11_01_10 67 individual 1667327547.9408212 2022-11-01T18:32:27.940821+00:00 intermediate_selection individual009.jpg -2  
exp_2022_11_01_10 67 individual 1667327551.0618725 2022-11-01T18:32:31.061872+00:00 intermediate_selection individual009.jpg   0

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