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_09_30_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_09_30_10 -2 team 1664563802.529181 2022-09-30T18:50:02.529181+00:00 start_affective_task      
exp_2022_09_30_10 12 individual 1664563524.8083608 2022-09-30T18:45:24.808361+00:00 start_affective_task      
exp_2022_09_30_10 12 individual 1664563535.500025 2022-09-30T18:45:35.500025+00:00 intermediate_selection individual000.jpg 2  
exp_2022_09_30_10 12 individual 1664563536.9848526 2022-09-30T18:45:36.984853+00:00 intermediate_selection individual000.jpg   0
exp_2022_09_30_10 12 individual 1664563537.9135838 2022-09-30T18:45:37.913584+00:00 intermediate_selection individual000.jpg   -1
exp_2022_09_30_10 12 individual 1664563538.6428947 2022-09-30T18:45:38.642895+00:00 final_submission individual000.jpg 2 -1
exp_2022_09_30_10 12 individual 1664563549.278986 2022-09-30T18:45:49.278986+00:00 intermediate_selection individual001.jpg 0  
exp_2022_09_30_10 12 individual 1664563551.636068 2022-09-30T18:45:51.636068+00:00 intermediate_selection individual001.jpg   -2
exp_2022_09_30_10 12 individual 1664563554.5312445 2022-09-30T18:45:54.531245+00:00 final_submission individual001.jpg 0 -2
exp_2022_09_30_10 12 individual 1664563563.6042747 2022-09-30T18:46:03.604275+00:00 intermediate_selection individual002.jpg 1  
exp_2022_09_30_10 12 individual 1664563564.4097035 2022-09-30T18:46:04.409703+00:00 intermediate_selection individual002.jpg   1
exp_2022_09_30_10 12 individual 1664563565.419436 2022-09-30T18:46:05.419436+00:00 final_submission individual002.jpg 1 1
exp_2022_09_30_10 12 individual 1664563575.3496068 2022-09-30T18:46:15.349607+00:00 intermediate_selection individual003.jpg -1  
exp_2022_09_30_10 12 individual 1664563581.5640442 2022-09-30T18:46:21.564044+00:00 intermediate_selection individual003.jpg   1
exp_2022_09_30_10 12 individual 1664563582.572748 2022-09-30T18:46:22.572748+00:00 final_submission individual003.jpg -1 1
exp_2022_09_30_10 12 individual 1664563592.6640246 2022-09-30T18:46:32.664025+00:00 intermediate_selection individual004.jpg -1  
exp_2022_09_30_10 12 individual 1664563595.0642138 2022-09-30T18:46:35.064214+00:00 intermediate_selection individual004.jpg   2
exp_2022_09_30_10 12 individual 1664563595.724026 2022-09-30T18:46:35.724026+00:00 final_submission individual004.jpg -1 2
exp_2022_09_30_10 12 individual 1664563604.8587275 2022-09-30T18:46:44.858727+00:00 intermediate_selection individual005.jpg 0  
exp_2022_09_30_10 12 individual 1664563606.4849503 2022-09-30T18:46:46.484950+00:00 intermediate_selection individual005.jpg   0
exp_2022_09_30_10 12 individual 1664563607.1573014 2022-09-30T18:46:47.157301+00:00 final_submission individual005.jpg 0 0
exp_2022_09_30_10 12 individual 1664563616.1464636 2022-09-30T18:46:56.146464+00:00 intermediate_selection individual006.jpg -2  
exp_2022_09_30_10 12 individual 1664563617.9212961 2022-09-30T18:46:57.921296+00:00 intermediate_selection individual006.jpg   2
exp_2022_09_30_10 12 individual 1664563619.2535214 2022-09-30T18:46:59.253521+00:00 final_submission individual006.jpg -2 2
exp_2022_09_30_10 12 individual 1664563629.1202233 2022-09-30T18:47:09.120223+00:00 intermediate_selection individual007.jpg 1  
exp_2022_09_30_10 12 individual 1664563631.517855 2022-09-30T18:47:11.517855+00:00 intermediate_selection individual007.jpg   1
exp_2022_09_30_10 12 individual 1664563631.976555 2022-09-30T18:47:11.976555+00:00 intermediate_selection individual007.jpg   1
exp_2022_09_30_10 12 individual 1664563633.9746442 2022-09-30T18:47:13.974644+00:00 final_submission individual007.jpg 1 1
exp_2022_09_30_10 12 individual 1664563643.5611656 2022-09-30T18:47:23.561166+00:00 intermediate_selection individual008.jpg -1  
exp_2022_09_30_10 12 individual 1664563644.7845085 2022-09-30T18:47:24.784508+00:00 intermediate_selection individual008.jpg   1
exp_2022_09_30_10 12 individual 1664563647.1023633 2022-09-30T18:47:27.102363+00:00 final_submission individual008.jpg -1 1
exp_2022_09_30_10 12 individual 1664563657.6907232 2022-09-30T18:47:37.690723+00:00 intermediate_selection individual009.jpg -1  
exp_2022_09_30_10 12 individual 1664563660.0767012 2022-09-30T18:47:40.076701+00:00 intermediate_selection individual009.jpg   1
exp_2022_09_30_10 12 individual 1664563661.8069415 2022-09-30T18:47:41.806942+00:00 final_submission individual009.jpg -1 1
exp_2022_09_30_10 12 individual 1664563671.4387915 2022-09-30T18:47:51.438792+00:00 intermediate_selection individual010.jpg 0  
exp_2022_09_30_10 12 individual 1664563672.6033409 2022-09-30T18:47:52.603341+00:00 intermediate_selection individual010.jpg   -2
exp_2022_09_30_10 12 individual 1664563673.526918 2022-09-30T18:47:53.526918+00:00 final_submission individual010.jpg 0 -2
exp_2022_09_30_10 12 individual 1664563682.9421144 2022-09-30T18:48:02.942114+00:00 intermediate_selection individual011.jpg 1  
exp_2022_09_30_10 12 individual 1664563684.4258757 2022-09-30T18:48:04.425876+00:00 intermediate_selection individual011.jpg   -2
exp_2022_09_30_10 12 individual 1664563685.7117827 2022-09-30T18:48:05.711783+00:00 final_submission individual011.jpg 1 -2
exp_2022_09_30_10 12 individual 1664563694.8008175 2022-09-30T18:48:14.800817+00:00 intermediate_selection individual012.jpg 0  
exp_2022_09_30_10 12 individual 1664563695.5468693 2022-09-30T18:48:15.546869+00:00 intermediate_selection individual012.jpg   -1
exp_2022_09_30_10 12 individual 1664563696.4481695 2022-09-30T18:48:16.448169+00:00 final_submission individual012.jpg 0 -1
exp_2022_09_30_10 12 individual 1664563707.2573798 2022-09-30T18:48:27.257380+00:00 intermediate_selection individual013.jpg 0  
exp_2022_09_30_10 12 individual 1664563709.0862074 2022-09-30T18:48:29.086207+00:00 intermediate_selection individual013.jpg   0
exp_2022_09_30_10 12 individual 1664563709.5608308 2022-09-30T18:48:29.560831+00:00 final_submission individual013.jpg 0 0
exp_2022_09_30_10 12 individual 1664563719.636537 2022-09-30T18:48:39.636537+00:00 intermediate_selection individual014.jpg 0  
exp_2022_09_30_10 12 individual 1664563721.634902 2022-09-30T18:48:41.634902+00:00 intermediate_selection individual014.jpg   -1
exp_2022_09_30_10 12 individual 1664563722.2409482 2022-09-30T18:48:42.240948+00:00 final_submission individual014.jpg 0 -1
exp_2022_09_30_10 12 team 1664563839.8985608 2022-09-30T18:50:39.898561+00:00 intermediate_selection Team000.jpg -2  
exp_2022_09_30_10 12 team 1664563846.5447025 2022-09-30T18:50:46.544703+00:00 final_submission Team000.jpg -2  
exp_2022_09_30_10 12 team 1664563955.622454 2022-09-30T18:52:35.622454+00:00 intermediate_selection Team003.jpg 0  
exp_2022_09_30_10 12 team 1664563956.5328155 2022-09-30T18:52:36.532815+00:00 intermediate_selection Team003.jpg   0
exp_2022_09_30_10 12 team 1664563959.8088644 2022-09-30T18:52:39.808864+00:00 final_submission Team003.jpg 0 0
exp_2022_09_30_10 12 team 1664564047.6803987 2022-09-30T18:54:07.680399+00:00 intermediate_selection Team006.jpg 2  
exp_2022_09_30_10 12 team 1664564049.453916 2022-09-30T18:54:09.453916+00:00 intermediate_selection Team006.jpg   2
exp_2022_09_30_10 12 team 1664564050.5514534 2022-09-30T18:54:10.551453+00:00 final_submission Team006.jpg 2 2
exp_2022_09_30_10 12 team 1664564142.5605898 2022-09-30T18:55:42.560590+00:00 intermediate_selection Team009.jpg -2  
exp_2022_09_30_10 12 team 1664564144.1049838 2022-09-30T18:55:44.104984+00:00 intermediate_selection Team009.jpg   2
exp_2022_09_30_10 12 team 1664564145.4794133 2022-09-30T18:55:45.479413+00:00 final_submission Team009.jpg -2 2
exp_2022_09_30_10 12 team 1664564236.639075 2022-09-30T18:57:16.639075+00:00 intermediate_selection Team012.jpg 1  
exp_2022_09_30_10 12 team 1664564240.8645353 2022-09-30T18:57:20.864535+00:00 intermediate_selection Team012.jpg   0
exp_2022_09_30_10 12 team 1664564242.6025522 2022-09-30T18:57:22.602552+00:00 final_submission Team012.jpg 1 0
exp_2022_09_30_10 13 individual 1664563524.8345137 2022-09-30T18:45:24.834514+00:00 start_affective_task      
exp_2022_09_30_10 13 individual 1664563533.7012768 2022-09-30T18:45:33.701277+00:00 intermediate_selection individual000.jpg 1  
exp_2022_09_30_10 13 individual 1664563535.5867856 2022-09-30T18:45:35.586786+00:00 intermediate_selection individual000.jpg   1
exp_2022_09_30_10 13 individual 1664563536.5826957 2022-09-30T18:45:36.582696+00:00 final_submission individual000.jpg 1 1
exp_2022_09_30_10 13 individual 1664563544.5888603 2022-09-30T18:45:44.588860+00:00 intermediate_selection individual001.jpg 1  
exp_2022_09_30_10 13 individual 1664563545.6930456 2022-09-30T18:45:45.693046+00:00 intermediate_selection individual001.jpg   -1
exp_2022_09_30_10 13 individual 1664563547.2143023 2022-09-30T18:45:47.214302+00:00 final_submission individual001.jpg 1 -1
exp_2022_09_30_10 13 individual 1664563555.0541418 2022-09-30T18:45:55.054142+00:00 intermediate_selection individual002.jpg -1  
exp_2022_09_30_10 13 individual 1664563555.694045 2022-09-30T18:45:55.694045+00:00 intermediate_selection individual002.jpg   -2
exp_2022_09_30_10 13 individual 1664563556.7028058 2022-09-30T18:45:56.702806+00:00 final_submission individual002.jpg -1 -2
exp_2022_09_30_10 13 individual 1664563564.414813 2022-09-30T18:46:04.414813+00:00 intermediate_selection individual003.jpg -2  
exp_2022_09_30_10 13 individual 1664563564.8314462 2022-09-30T18:46:04.831446+00:00 intermediate_selection individual003.jpg   -2
exp_2022_09_30_10 13 individual 1664563565.6472707 2022-09-30T18:46:05.647271+00:00 final_submission individual003.jpg -2 -2
exp_2022_09_30_10 13 individual 1664563573.1148856 2022-09-30T18:46:13.114886+00:00 intermediate_selection individual004.jpg -2  
exp_2022_09_30_10 13 individual 1664563573.4502563 2022-09-30T18:46:13.450256+00:00 intermediate_selection individual004.jpg   -2
exp_2022_09_30_10 13 individual 1664563574.9325151 2022-09-30T18:46:14.932515+00:00 intermediate_selection individual004.jpg   1
exp_2022_09_30_10 13 individual 1664563575.7674317 2022-09-30T18:46:15.767432+00:00 final_submission individual004.jpg -2 1
exp_2022_09_30_10 13 individual 1664563583.4875069 2022-09-30T18:46:23.487507+00:00 intermediate_selection individual005.jpg 0  
exp_2022_09_30_10 13 individual 1664563585.1556804 2022-09-30T18:46:25.155680+00:00 intermediate_selection individual005.jpg   -1
exp_2022_09_30_10 13 individual 1664563586.5436912 2022-09-30T18:46:26.543691+00:00 final_submission individual005.jpg 0 -1
exp_2022_09_30_10 13 individual 1664563594.227816 2022-09-30T18:46:34.227816+00:00 intermediate_selection individual006.jpg -2  
exp_2022_09_30_10 13 individual 1664563595.0854387 2022-09-30T18:46:35.085439+00:00 intermediate_selection individual006.jpg   -1
exp_2022_09_30_10 13 individual 1664563595.392252 2022-09-30T18:46:35.392252+00:00 final_submission individual006.jpg -2 -1
exp_2022_09_30_10 13 individual 1664563602.709528 2022-09-30T18:46:42.709528+00:00 intermediate_selection individual007.jpg 0  
exp_2022_09_30_10 13 individual 1664563603.0672107 2022-09-30T18:46:43.067211+00:00 intermediate_selection individual007.jpg   1
exp_2022_09_30_10 13 individual 1664563603.9993138 2022-09-30T18:46:43.999314+00:00 intermediate_selection individual007.jpg   0
exp_2022_09_30_10 13 individual 1664563604.3445024 2022-09-30T18:46:44.344502+00:00 final_submission individual007.jpg 0 0
exp_2022_09_30_10 13 individual 1664563611.8772967 2022-09-30T18:46:51.877297+00:00 intermediate_selection individual008.jpg -1  
exp_2022_09_30_10 13 individual 1664563613.0154784 2022-09-30T18:46:53.015478+00:00 intermediate_selection individual008.jpg   1
exp_2022_09_30_10 13 individual 1664563614.2007034 2022-09-30T18:46:54.200703+00:00 final_submission individual008.jpg -1 1
exp_2022_09_30_10 13 individual 1664563621.605229 2022-09-30T18:47:01.605229+00:00 intermediate_selection individual009.jpg -2  
exp_2022_09_30_10 13 individual 1664563622.3731425 2022-09-30T18:47:02.373142+00:00 intermediate_selection individual009.jpg   2
exp_2022_09_30_10 13 individual 1664563622.8172405 2022-09-30T18:47:02.817240+00:00 final_submission individual009.jpg -2 2
exp_2022_09_30_10 13 individual 1664563630.9173682 2022-09-30T18:47:10.917368+00:00 intermediate_selection individual010.jpg 1  
exp_2022_09_30_10 13 individual 1664563631.7438402 2022-09-30T18:47:11.743840+00:00 intermediate_selection individual010.jpg   -1
exp_2022_09_30_10 13 individual 1664563632.1062384 2022-09-30T18:47:12.106238+00:00 intermediate_selection individual010.jpg   -2
exp_2022_09_30_10 13 individual 1664563632.4437807 2022-09-30T18:47:12.443781+00:00 intermediate_selection individual010.jpg   -1

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