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_10_27_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_10_27_10 -2 team 1666895688.003323 2022-10-27T18:34:48.003323+00:00 start_affective_task      
exp_2022_10_27_10 66 individual 1666895351.5725725 2022-10-27T18:29:11.572572+00:00 start_affective_task      
exp_2022_10_27_10 66 individual 1666895365.9080148 2022-10-27T18:29:25.908015+00:00 intermediate_selection individual000.jpg 1  
exp_2022_10_27_10 66 individual 1666895374.524626 2022-10-27T18:29:34.524626+00:00 intermediate_selection individual000.jpg   -2
exp_2022_10_27_10 66 individual 1666895375.5772913 2022-10-27T18:29:35.577291+00:00 final_submission individual000.jpg 1 -2
exp_2022_10_27_10 66 individual 1666895384.632739 2022-10-27T18:29:44.632739+00:00 intermediate_selection individual001.jpg 1  
exp_2022_10_27_10 66 individual 1666895392.633065 2022-10-27T18:29:52.633065+00:00 intermediate_selection individual001.jpg   0
exp_2022_10_27_10 66 individual 1666895393.9539406 2022-10-27T18:29:53.953941+00:00 final_submission individual001.jpg 1 0
exp_2022_10_27_10 66 individual 1666895408.808498 2022-10-27T18:30:08.808498+00:00 intermediate_selection individual002.jpg 1  
exp_2022_10_27_10 66 individual 1666895409.9465044 2022-10-27T18:30:09.946504+00:00 intermediate_selection individual002.jpg   1
exp_2022_10_27_10 66 individual 1666895413.9613574 2022-10-27T18:30:13.961357+00:00 final_submission individual002.jpg 1 1
exp_2022_10_27_10 66 individual 1666895427.0665653 2022-10-27T18:30:27.066565+00:00 intermediate_selection individual003.jpg -1  
exp_2022_10_27_10 66 individual 1666895434.8599062 2022-10-27T18:30:34.859906+00:00 intermediate_selection individual003.jpg   1
exp_2022_10_27_10 66 individual 1666895440.897988 2022-10-27T18:30:40.897988+00:00 final_submission individual003.jpg -1 1
exp_2022_10_27_10 66 individual 1666895452.0495715 2022-10-27T18:30:52.049572+00:00 intermediate_selection individual004.jpg -2  
exp_2022_10_27_10 66 individual 1666895454.0422819 2022-10-27T18:30:54.042282+00:00 intermediate_selection individual004.jpg -1  
exp_2022_10_27_10 66 individual 1666895467.677477 2022-10-27T18:31:07.677477+00:00 intermediate_selection individual004.jpg   -1
exp_2022_10_27_10 66 individual 1666895467.9627292 2022-10-27T18:31:07.962729+00:00 final_submission individual004.jpg -1 -1
exp_2022_10_27_10 66 individual 1666895477.394739 2022-10-27T18:31:17.394739+00:00 intermediate_selection individual005.jpg 0  
exp_2022_10_27_10 66 individual 1666895479.3621397 2022-10-27T18:31:19.362140+00:00 intermediate_selection individual005.jpg   0
exp_2022_10_27_10 66 individual 1666895480.306818 2022-10-27T18:31:20.306818+00:00 final_submission individual005.jpg 0 0
exp_2022_10_27_10 66 individual 1666895496.2332072 2022-10-27T18:31:36.233207+00:00 intermediate_selection individual006.jpg -1  
exp_2022_10_27_10 66 individual 1666895498.7970195 2022-10-27T18:31:38.797019+00:00 intermediate_selection individual006.jpg   0
exp_2022_10_27_10 66 individual 1666895501.7498493 2022-10-27T18:31:41.749849+00:00 final_submission individual006.jpg -1 0
exp_2022_10_27_10 66 individual 1666895509.890511 2022-10-27T18:31:49.890511+00:00 intermediate_selection individual007.jpg 0  
exp_2022_10_27_10 66 individual 1666895510.8805735 2022-10-27T18:31:50.880574+00:00 intermediate_selection individual007.jpg   1
exp_2022_10_27_10 66 individual 1666895511.7796896 2022-10-27T18:31:51.779690+00:00 final_submission individual007.jpg 0 1
exp_2022_10_27_10 66 individual 1666895519.4381633 2022-10-27T18:31:59.438163+00:00 intermediate_selection individual008.jpg 0  
exp_2022_10_27_10 66 individual 1666895523.4130392 2022-10-27T18:32:03.413039+00:00 intermediate_selection individual008.jpg   1
exp_2022_10_27_10 66 individual 1666895524.579839 2022-10-27T18:32:04.579839+00:00 final_submission individual008.jpg 0 1
exp_2022_10_27_10 66 individual 1666895533.1648796 2022-10-27T18:32:13.164880+00:00 intermediate_selection individual009.jpg -1  
exp_2022_10_27_10 66 individual 1666895535.9674237 2022-10-27T18:32:15.967424+00:00 intermediate_selection individual009.jpg   0
exp_2022_10_27_10 66 individual 1666895536.9647903 2022-10-27T18:32:16.964790+00:00 final_submission individual009.jpg -1 0
exp_2022_10_27_10 66 individual 1666895544.711232 2022-10-27T18:32:24.711232+00:00 intermediate_selection individual010.jpg 1  
exp_2022_10_27_10 66 individual 1666895545.8053267 2022-10-27T18:32:25.805327+00:00 intermediate_selection individual010.jpg   1
exp_2022_10_27_10 66 individual 1666895547.5811129 2022-10-27T18:32:27.581113+00:00 final_submission individual010.jpg 1 1
exp_2022_10_27_10 66 individual 1666895555.097712 2022-10-27T18:32:35.097712+00:00 intermediate_selection individual011.jpg 0  
exp_2022_10_27_10 66 individual 1666895555.9109745 2022-10-27T18:32:35.910975+00:00 intermediate_selection individual011.jpg   0
exp_2022_10_27_10 66 individual 1666895556.6612406 2022-10-27T18:32:36.661241+00:00 final_submission individual011.jpg 0 0
exp_2022_10_27_10 66 individual 1666895564.7622292 2022-10-27T18:32:44.762229+00:00 intermediate_selection individual012.jpg 0  
exp_2022_10_27_10 66 individual 1666895565.9543254 2022-10-27T18:32:45.954325+00:00 intermediate_selection individual012.jpg   0
exp_2022_10_27_10 66 individual 1666895568.0410435 2022-10-27T18:32:48.041044+00:00 intermediate_selection individual012.jpg   -2
exp_2022_10_27_10 66 individual 1666895570.9292579 2022-10-27T18:32:50.929258+00:00 intermediate_selection individual012.jpg   -1
exp_2022_10_27_10 66 individual 1666895571.6938894 2022-10-27T18:32:51.693889+00:00 final_submission individual012.jpg 0 -1
exp_2022_10_27_10 66 individual 1666895579.439021 2022-10-27T18:32:59.439021+00:00 intermediate_selection individual013.jpg 0  
exp_2022_10_27_10 66 individual 1666895580.7426732 2022-10-27T18:33:00.742673+00:00 intermediate_selection individual013.jpg   -1
exp_2022_10_27_10 66 individual 1666895581.4379354 2022-10-27T18:33:01.437935+00:00 final_submission individual013.jpg 0 -1
exp_2022_10_27_10 66 individual 1666895589.3371742 2022-10-27T18:33:09.337174+00:00 intermediate_selection individual014.jpg 0  
exp_2022_10_27_10 66 individual 1666895590.1208813 2022-10-27T18:33:10.120881+00:00 intermediate_selection individual014.jpg   0
exp_2022_10_27_10 66 individual 1666895590.9105608 2022-10-27T18:33:10.910561+00:00 final_submission individual014.jpg 0 0
exp_2022_10_27_10 66 team 1666895826.1475706 2022-10-27T18:37:06.147571+00:00 intermediate_selection Team002.jpg -1  
exp_2022_10_27_10 66 team 1666895831.6185298 2022-10-27T18:37:11.618530+00:00 intermediate_selection Team002.jpg   -1
exp_2022_10_27_10 66 team 1666895831.9883394 2022-10-27T18:37:11.988339+00:00 final_submission Team002.jpg -1 -1
exp_2022_10_27_10 66 team 1666895962.5094972 2022-10-27T18:39:22.509497+00:00 intermediate_selection Team005.jpg 1  
exp_2022_10_27_10 66 team 1666895963.7266018 2022-10-27T18:39:23.726602+00:00 intermediate_selection Team005.jpg   2
exp_2022_10_27_10 66 team 1666895964.8438416 2022-10-27T18:39:24.843842+00:00 final_submission Team005.jpg 1 2
exp_2022_10_27_10 66 team 1666896093.4633117 2022-10-27T18:41:33.463312+00:00 intermediate_selection Team008.jpg -1  
exp_2022_10_27_10 66 team 1666896096.1499069 2022-10-27T18:41:36.149907+00:00 intermediate_selection Team008.jpg   -1
exp_2022_10_27_10 66 team 1666896098.4992979 2022-10-27T18:41:38.499298+00:00 final_submission Team008.jpg -1 -1
exp_2022_10_27_10 66 team 1666896233.3966668 2022-10-27T18:43:53.396667+00:00 intermediate_selection Team011.jpg 2  
exp_2022_10_27_10 66 team 1666896234.4282708 2022-10-27T18:43:54.428271+00:00 intermediate_selection Team011.jpg   1
exp_2022_10_27_10 66 team 1666896236.3336751 2022-10-27T18:43:56.333675+00:00 final_submission Team011.jpg 2 1
exp_2022_10_27_10 66 team 1666896368.1907585 2022-10-27T18:46:08.190758+00:00 intermediate_selection Team014.jpg -2  
exp_2022_10_27_10 66 team 1666896369.4809995 2022-10-27T18:46:09.480999+00:00 intermediate_selection Team014.jpg   0
exp_2022_10_27_10 66 team 1666896370.6029053 2022-10-27T18:46:10.602905+00:00 final_submission Team014.jpg -2 0
exp_2022_10_27_10 68 individual 1666895351.5501683 2022-10-27T18:29:11.550168+00:00 start_affective_task      
exp_2022_10_27_10 68 individual 1666895361.3898075 2022-10-27T18:29:21.389807+00:00 intermediate_selection individual000.jpg 1  
exp_2022_10_27_10 68 individual 1666895364.470972 2022-10-27T18:29:24.470972+00:00 intermediate_selection individual000.jpg   0
exp_2022_10_27_10 68 individual 1666895365.2328942 2022-10-27T18:29:25.232894+00:00 final_submission individual000.jpg 1 0
exp_2022_10_27_10 68 individual 1666895374.1968853 2022-10-27T18:29:34.196885+00:00 intermediate_selection individual001.jpg 1  
exp_2022_10_27_10 68 individual 1666895376.9729605 2022-10-27T18:29:36.972960+00:00 intermediate_selection individual001.jpg   0
exp_2022_10_27_10 68 individual 1666895377.8171017 2022-10-27T18:29:37.817102+00:00 final_submission individual001.jpg 1 0
exp_2022_10_27_10 68 individual 1666895388.0669894 2022-10-27T18:29:48.066989+00:00 intermediate_selection individual002.jpg 0  
exp_2022_10_27_10 68 individual 1666895388.792151 2022-10-27T18:29:48.792151+00:00 intermediate_selection individual002.jpg   0
exp_2022_10_27_10 68 individual 1666895390.121519 2022-10-27T18:29:50.121519+00:00 final_submission individual002.jpg 0 0
exp_2022_10_27_10 68 individual 1666895398.8970299 2022-10-27T18:29:58.897030+00:00 intermediate_selection individual003.jpg -2  
exp_2022_10_27_10 68 individual 1666895403.800611 2022-10-27T18:30:03.800611+00:00 intermediate_selection individual003.jpg   1
exp_2022_10_27_10 68 individual 1666895404.6101158 2022-10-27T18:30:04.610116+00:00 final_submission individual003.jpg -2 1
exp_2022_10_27_10 68 individual 1666895412.5820363 2022-10-27T18:30:12.582036+00:00 intermediate_selection individual004.jpg -2  
exp_2022_10_27_10 68 individual 1666895413.6500225 2022-10-27T18:30:13.650023+00:00 intermediate_selection individual004.jpg   2
exp_2022_10_27_10 68 individual 1666895414.442445 2022-10-27T18:30:14.442445+00:00 final_submission individual004.jpg -2 2
exp_2022_10_27_10 68 individual 1666895423.5266497 2022-10-27T18:30:23.526650+00:00 intermediate_selection individual005.jpg 0  
exp_2022_10_27_10 68 individual 1666895424.5274544 2022-10-27T18:30:24.527454+00:00 intermediate_selection individual005.jpg   0
exp_2022_10_27_10 68 individual 1666895426.373189 2022-10-27T18:30:26.373189+00:00 intermediate_selection individual005.jpg 1  
exp_2022_10_27_10 68 individual 1666895427.1866086 2022-10-27T18:30:27.186609+00:00 final_submission individual005.jpg 1 0
exp_2022_10_27_10 68 individual 1666895436.3115923 2022-10-27T18:30:36.311592+00:00 intermediate_selection individual006.jpg -2  
exp_2022_10_27_10 68 individual 1666895437.577924 2022-10-27T18:30:37.577924+00:00 intermediate_selection individual006.jpg   1
exp_2022_10_27_10 68 individual 1666895438.5472958 2022-10-27T18:30:38.547296+00:00 final_submission individual006.jpg -2 1
exp_2022_10_27_10 68 individual 1666895448.6386998 2022-10-27T18:30:48.638700+00:00 intermediate_selection individual007.jpg 1  
exp_2022_10_27_10 68 individual 1666895451.3108644 2022-10-27T18:30:51.310864+00:00 intermediate_selection individual007.jpg   -1
exp_2022_10_27_10 68 individual 1666895452.147654 2022-10-27T18:30:52.147654+00:00 final_submission individual007.jpg 1 -1
exp_2022_10_27_10 68 individual 1666895462.281374 2022-10-27T18:31:02.281374+00:00 intermediate_selection individual008.jpg 0  
exp_2022_10_27_10 68 individual 1666895463.9979243 2022-10-27T18:31:03.997924+00:00 intermediate_selection individual008.jpg   -1
exp_2022_10_27_10 68 individual 1666895465.308775 2022-10-27T18:31:05.308775+00:00 intermediate_selection individual008.jpg   1
exp_2022_10_27_10 68 individual 1666895465.875733 2022-10-27T18:31:05.875733+00:00 final_submission individual008.jpg 0 1
exp_2022_10_27_10 68 individual 1666895474.0043137 2022-10-27T18:31:14.004314+00:00 intermediate_selection individual009.jpg -2  
exp_2022_10_27_10 68 individual 1666895475.1970766 2022-10-27T18:31:15.197077+00:00 intermediate_selection individual009.jpg   1
exp_2022_10_27_10 68 individual 1666895476.5882099 2022-10-27T18:31:16.588210+00:00 final_submission individual009.jpg -2 1
exp_2022_10_27_10 68 individual 1666895485.0865078 2022-10-27T18:31:25.086508+00:00 intermediate_selection individual010.jpg   -2
exp_2022_10_27_10 68 individual 1666895486.840486 2022-10-27T18:31:26.840486+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]);