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_2023_02_20_01"

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_2023_02_20_01 -2 team 1676928504.2266495 2023-02-20T21:28:24.226650+00:00 start_affective_task      
exp_2023_02_20_01 112 individual 1676928233.5004246 2023-02-20T21:23:53.500425+00:00 start_affective_task      
exp_2023_02_20_01 112 individual 1676928246.1007578 2023-02-20T21:24:06.100758+00:00 intermediate_selection individual000.jpg 2  
exp_2023_02_20_01 112 individual 1676928249.7849145 2023-02-20T21:24:09.784914+00:00 intermediate_selection individual000.jpg   0
exp_2023_02_20_01 112 individual 1676928254.2529445 2023-02-20T21:24:14.252944+00:00 final_submission individual000.jpg 2 0
exp_2023_02_20_01 112 individual 1676928262.2523355 2023-02-20T21:24:22.252336+00:00 intermediate_selection individual001.jpg 2  
exp_2023_02_20_01 112 individual 1676928263.7344697 2023-02-20T21:24:23.734470+00:00 intermediate_selection individual001.jpg   1
exp_2023_02_20_01 112 individual 1676928264.82891 2023-02-20T21:24:24.828910+00:00 final_submission individual001.jpg 2 1
exp_2023_02_20_01 112 individual 1676928272.323646 2023-02-20T21:24:32.323646+00:00 intermediate_selection individual002.jpg 1  
exp_2023_02_20_01 112 individual 1676928274.7693448 2023-02-20T21:24:34.769345+00:00 intermediate_selection individual002.jpg   0
exp_2023_02_20_01 112 individual 1676928275.9671605 2023-02-20T21:24:35.967160+00:00 intermediate_selection individual002.jpg   -1
exp_2023_02_20_01 112 individual 1676928277.4855237 2023-02-20T21:24:37.485524+00:00 final_submission individual002.jpg 1 -1
exp_2023_02_20_01 112 individual 1676928285.707701 2023-02-20T21:24:45.707701+00:00 intermediate_selection individual003.jpg -1  
exp_2023_02_20_01 112 individual 1676928287.3806918 2023-02-20T21:24:47.380692+00:00 intermediate_selection individual003.jpg   1
exp_2023_02_20_01 112 individual 1676928288.037679 2023-02-20T21:24:48.037679+00:00 final_submission individual003.jpg -1 1
exp_2023_02_20_01 112 individual 1676928295.6617239 2023-02-20T21:24:55.661724+00:00 intermediate_selection individual004.jpg 0  
exp_2023_02_20_01 112 individual 1676928296.7785094 2023-02-20T21:24:56.778509+00:00 intermediate_selection individual004.jpg   -1
exp_2023_02_20_01 112 individual 1676928297.243932 2023-02-20T21:24:57.243932+00:00 intermediate_selection individual004.jpg   0
exp_2023_02_20_01 112 individual 1676928298.190409 2023-02-20T21:24:58.190409+00:00 intermediate_selection individual004.jpg   1
exp_2023_02_20_01 112 individual 1676928298.9004948 2023-02-20T21:24:58.900495+00:00 intermediate_selection individual004.jpg   0
exp_2023_02_20_01 112 individual 1676928300.4377606 2023-02-20T21:25:00.437761+00:00 final_submission individual004.jpg 0 0
exp_2023_02_20_01 112 individual 1676928308.0616987 2023-02-20T21:25:08.061699+00:00 intermediate_selection individual005.jpg 0  
exp_2023_02_20_01 112 individual 1676928308.8295162 2023-02-20T21:25:08.829516+00:00 intermediate_selection individual005.jpg   0
exp_2023_02_20_01 112 individual 1676928309.3176312 2023-02-20T21:25:09.317631+00:00 intermediate_selection individual005.jpg   -1
exp_2023_02_20_01 112 individual 1676928309.9874496 2023-02-20T21:25:09.987450+00:00 intermediate_selection individual005.jpg   0
exp_2023_02_20_01 112 individual 1676928313.4865465 2023-02-20T21:25:13.486547+00:00 final_submission individual005.jpg 0 0
exp_2023_02_20_01 112 individual 1676928321.0361364 2023-02-20T21:25:21.036136+00:00 intermediate_selection individual006.jpg -2  
exp_2023_02_20_01 112 individual 1676928322.2452044 2023-02-20T21:25:22.245204+00:00 intermediate_selection individual006.jpg   1
exp_2023_02_20_01 112 individual 1676928324.4149 2023-02-20T21:25:24.414900+00:00 final_submission individual006.jpg -2 1
exp_2023_02_20_01 112 individual 1676928331.9532096 2023-02-20T21:25:31.953210+00:00 intermediate_selection individual007.jpg   0
exp_2023_02_20_01 112 individual 1676928332.7071834 2023-02-20T21:25:32.707183+00:00 intermediate_selection individual007.jpg 1  
exp_2023_02_20_01 112 individual 1676928334.5593393 2023-02-20T21:25:34.559339+00:00 final_submission individual007.jpg 1 0
exp_2023_02_20_01 112 individual 1676928341.8780446 2023-02-20T21:25:41.878045+00:00 intermediate_selection individual008.jpg 2  
exp_2023_02_20_01 112 individual 1676928342.7903295 2023-02-20T21:25:42.790329+00:00 intermediate_selection individual008.jpg   1
exp_2023_02_20_01 112 individual 1676928343.7116823 2023-02-20T21:25:43.711682+00:00 final_submission individual008.jpg 2 1
exp_2023_02_20_01 112 individual 1676928352.3909013 2023-02-20T21:25:52.390901+00:00 intermediate_selection individual009.jpg -1  
exp_2023_02_20_01 112 individual 1676928356.2470481 2023-02-20T21:25:56.247048+00:00 intermediate_selection individual009.jpg   0
exp_2023_02_20_01 112 individual 1676928360.013671 2023-02-20T21:26:00.013671+00:00 intermediate_selection individual009.jpg   1
exp_2023_02_20_01 112 individual 1676928360.7217624 2023-02-20T21:26:00.721762+00:00 final_submission individual009.jpg -1 1
exp_2023_02_20_01 112 individual 1676928368.1557214 2023-02-20T21:26:08.155721+00:00 intermediate_selection individual010.jpg 2  
exp_2023_02_20_01 112 individual 1676928368.6528108 2023-02-20T21:26:08.652811+00:00 intermediate_selection individual010.jpg   1
exp_2023_02_20_01 112 individual 1676928369.1482792 2023-02-20T21:26:09.148279+00:00 intermediate_selection individual010.jpg   2
exp_2023_02_20_01 112 individual 1676928370.335798 2023-02-20T21:26:10.335798+00:00 intermediate_selection individual010.jpg   1
exp_2023_02_20_01 112 individual 1676928371.3099606 2023-02-20T21:26:11.309961+00:00 intermediate_selection individual010.jpg   2
exp_2023_02_20_01 112 individual 1676928372.3128119 2023-02-20T21:26:12.312812+00:00 intermediate_selection individual010.jpg   1
exp_2023_02_20_01 112 individual 1676928373.5048642 2023-02-20T21:26:13.504864+00:00 final_submission individual010.jpg 2 1
exp_2023_02_20_01 112 individual 1676928381.615267 2023-02-20T21:26:21.615267+00:00 intermediate_selection individual011.jpg 0  
exp_2023_02_20_01 112 individual 1676928382.5268586 2023-02-20T21:26:22.526859+00:00 intermediate_selection individual011.jpg   -1
exp_2023_02_20_01 112 individual 1676928383.773313 2023-02-20T21:26:23.773313+00:00 intermediate_selection individual011.jpg   0
exp_2023_02_20_01 112 individual 1676928384.3272538 2023-02-20T21:26:24.327254+00:00 intermediate_selection individual011.jpg   -1
exp_2023_02_20_01 112 individual 1676928384.792984 2023-02-20T21:26:24.792984+00:00 final_submission individual011.jpg 0 -1
exp_2023_02_20_01 112 individual 1676928392.326482 2023-02-20T21:26:32.326482+00:00 intermediate_selection individual012.jpg 1  
exp_2023_02_20_01 112 individual 1676928393.5192754 2023-02-20T21:26:33.519275+00:00 intermediate_selection individual012.jpg   0
exp_2023_02_20_01 112 individual 1676928394.0058846 2023-02-20T21:26:34.005885+00:00 intermediate_selection individual012.jpg   -1
exp_2023_02_20_01 112 individual 1676928395.7447312 2023-02-20T21:26:35.744731+00:00 final_submission individual012.jpg 1 -1
exp_2023_02_20_01 112 individual 1676928403.1091263 2023-02-20T21:26:43.109126+00:00 intermediate_selection individual013.jpg 1  
exp_2023_02_20_01 112 individual 1676928404.2067492 2023-02-20T21:26:44.206749+00:00 intermediate_selection individual013.jpg   -1
exp_2023_02_20_01 112 individual 1676928404.8895407 2023-02-20T21:26:44.889541+00:00 final_submission individual013.jpg 1 -1
exp_2023_02_20_01 112 individual 1676928412.38067 2023-02-20T21:26:52.380670+00:00 intermediate_selection individual014.jpg -1  
exp_2023_02_20_01 112 individual 1676928413.5748916 2023-02-20T21:26:53.574892+00:00 intermediate_selection individual014.jpg   1
exp_2023_02_20_01 112 individual 1676928414.2479548 2023-02-20T21:26:54.247955+00:00 intermediate_selection individual014.jpg   0
exp_2023_02_20_01 112 individual 1676928415.0020733 2023-02-20T21:26:55.002073+00:00 final_submission individual014.jpg -1 0
exp_2023_02_20_01 112 team 1676928552.2553325 2023-02-20T21:29:12.255332+00:00 intermediate_selection Team000.jpg -1  
exp_2023_02_20_01 112 team 1676928553.2757058 2023-02-20T21:29:13.275706+00:00 final_submission Team000.jpg -1  
exp_2023_02_20_01 112 team 1676928677.9572933 2023-02-20T21:31:17.957293+00:00 intermediate_selection Team003.jpg 2  
exp_2023_02_20_01 112 team 1676928678.7043588 2023-02-20T21:31:18.704359+00:00 intermediate_selection Team003.jpg   2
exp_2023_02_20_01 112 team 1676928681.2427473 2023-02-20T21:31:21.242747+00:00 final_submission Team003.jpg 2 2
exp_2023_02_20_01 112 team 1676928804.092297 2023-02-20T21:33:24.092297+00:00 intermediate_selection Team006.jpg 1  
exp_2023_02_20_01 112 team 1676928805.4283247 2023-02-20T21:33:25.428325+00:00 intermediate_selection Team006.jpg   0
exp_2023_02_20_01 112 team 1676928808.0786402 2023-02-20T21:33:28.078640+00:00 final_submission Team006.jpg 1 0
exp_2023_02_20_01 112 team 1676928931.2189867 2023-02-20T21:35:31.218987+00:00 intermediate_selection Team009.jpg -2  
exp_2023_02_20_01 112 team 1676928931.9886615 2023-02-20T21:35:31.988662+00:00 intermediate_selection Team009.jpg   2
exp_2023_02_20_01 112 team 1676928933.1786568 2023-02-20T21:35:33.178657+00:00 final_submission Team009.jpg -2 2
exp_2023_02_20_01 112 team 1676929055.5523686 2023-02-20T21:37:35.552369+00:00 intermediate_selection Team012.jpg 1  
exp_2023_02_20_01 112 team 1676929056.2754061 2023-02-20T21:37:36.275406+00:00 intermediate_selection Team012.jpg   1
exp_2023_02_20_01 112 team 1676929056.8948894 2023-02-20T21:37:36.894889+00:00 final_submission Team012.jpg 1 1
exp_2023_02_20_01 118 individual 1676928233.5415325 2023-02-20T21:23:53.541533+00:00 start_affective_task      
exp_2023_02_20_01 118 individual 1676928247.7168818 2023-02-20T21:24:07.716882+00:00 intermediate_selection individual000.jpg 1  
exp_2023_02_20_01 118 individual 1676928251.1196513 2023-02-20T21:24:11.119651+00:00 intermediate_selection individual000.jpg   1
exp_2023_02_20_01 118 individual 1676928252.2973855 2023-02-20T21:24:12.297385+00:00 final_submission individual000.jpg 1 1
exp_2023_02_20_01 118 individual 1676928261.9733768 2023-02-20T21:24:21.973377+00:00 intermediate_selection individual001.jpg -1  
exp_2023_02_20_01 118 individual 1676928262.9423525 2023-02-20T21:24:22.942353+00:00 intermediate_selection individual001.jpg   -1
exp_2023_02_20_01 118 individual 1676928263.5751972 2023-02-20T21:24:23.575197+00:00 final_submission individual001.jpg -1 -1
exp_2023_02_20_01 118 individual 1676928274.2535992 2023-02-20T21:24:34.253599+00:00 intermediate_selection individual002.jpg 1  
exp_2023_02_20_01 118 individual 1676928276.1241262 2023-02-20T21:24:36.124126+00:00 intermediate_selection individual002.jpg   1
exp_2023_02_20_01 118 individual 1676928277.3285308 2023-02-20T21:24:37.328531+00:00 intermediate_selection individual002.jpg   0
exp_2023_02_20_01 118 individual 1676928279.7356172 2023-02-20T21:24:39.735617+00:00 final_submission individual002.jpg 1 0
exp_2023_02_20_01 118 individual 1676928288.2555666 2023-02-20T21:24:48.255567+00:00 intermediate_selection individual003.jpg -2  
exp_2023_02_20_01 118 individual 1676928290.072302 2023-02-20T21:24:50.072302+00:00 intermediate_selection individual003.jpg   -2
exp_2023_02_20_01 118 individual 1676928290.7755868 2023-02-20T21:24:50.775587+00:00 intermediate_selection individual003.jpg   -1
exp_2023_02_20_01 118 individual 1676928292.0401037 2023-02-20T21:24:52.040104+00:00 final_submission individual003.jpg -2 -1
exp_2023_02_20_01 118 individual 1676928301.3266494 2023-02-20T21:25:01.326649+00:00 intermediate_selection individual004.jpg -2  
exp_2023_02_20_01 118 individual 1676928307.9319057 2023-02-20T21:25:07.931906+00:00 intermediate_selection individual004.jpg   1
exp_2023_02_20_01 118 individual 1676928310.0384166 2023-02-20T21:25:10.038417+00:00 intermediate_selection individual004.jpg   2
exp_2023_02_20_01 118 individual 1676928310.6063879 2023-02-20T21:25:10.606388+00:00 final_submission individual004.jpg -2 2
exp_2023_02_20_01 118 individual 1676928319.74277 2023-02-20T21:25:19.742770+00:00 intermediate_selection individual005.jpg 1  
exp_2023_02_20_01 118 individual 1676928320.5251272 2023-02-20T21:25:20.525127+00:00 intermediate_selection individual005.jpg   1
exp_2023_02_20_01 118 individual 1676928321.0971892 2023-02-20T21:25:21.097189+00:00 final_submission individual005.jpg 1 1
exp_2023_02_20_01 118 individual 1676928329.1904037 2023-02-20T21:25:29.190404+00:00 intermediate_selection individual006.jpg -2  
exp_2023_02_20_01 118 individual 1676928332.7466419 2023-02-20T21:25:32.746642+00:00 intermediate_selection individual006.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]);