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

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_2022_11_15_13 30 individual 1668547218.3541563 2022-11-15T21:20:18.354156+00:00 start_affective_task      
exp_2022_11_15_13 30 individual 1668547228.3886592 2022-11-15T21:20:28.388659+00:00 intermediate_selection individual000.jpg 1  
exp_2022_11_15_13 30 individual 1668547230.1478462 2022-11-15T21:20:30.147846+00:00 intermediate_selection individual000.jpg   -1
exp_2022_11_15_13 30 individual 1668547230.8085954 2022-11-15T21:20:30.808595+00:00 final_submission individual000.jpg 1 -1
exp_2022_11_15_13 30 individual 1668547238.341812 2022-11-15T21:20:38.341812+00:00 intermediate_selection individual001.jpg 0  
exp_2022_11_15_13 30 individual 1668547239.052518 2022-11-15T21:20:39.052518+00:00 intermediate_selection individual001.jpg   0
exp_2022_11_15_13 30 individual 1668547240.3039846 2022-11-15T21:20:40.303985+00:00 final_submission individual001.jpg 0 0
exp_2022_11_15_13 30 individual 1668547250.0393465 2022-11-15T21:20:50.039346+00:00 intermediate_selection individual002.jpg   1
exp_2022_11_15_13 30 individual 1668547250.6459649 2022-11-15T21:20:50.645965+00:00 intermediate_selection individual002.jpg 1  
exp_2022_11_15_13 30 individual 1668547251.8245444 2022-11-15T21:20:51.824544+00:00 final_submission individual002.jpg 1 1
exp_2022_11_15_13 30 individual 1668547259.465638 2022-11-15T21:20:59.465638+00:00 intermediate_selection individual003.jpg -1  
exp_2022_11_15_13 30 individual 1668547260.2563293 2022-11-15T21:21:00.256329+00:00 intermediate_selection individual003.jpg   1
exp_2022_11_15_13 30 individual 1668547261.265387 2022-11-15T21:21:01.265387+00:00 final_submission individual003.jpg -1 1
exp_2022_11_15_13 30 individual 1668547269.0519023 2022-11-15T21:21:09.051902+00:00 intermediate_selection individual004.jpg -2  
exp_2022_11_15_13 30 individual 1668547269.8371096 2022-11-15T21:21:09.837110+00:00 intermediate_selection individual004.jpg   1
exp_2022_11_15_13 30 individual 1668547272.6977696 2022-11-15T21:21:12.697770+00:00 final_submission individual004.jpg -2 1
exp_2022_11_15_13 30 individual 1668547280.1219766 2022-11-15T21:21:20.121977+00:00 intermediate_selection individual005.jpg 1  
exp_2022_11_15_13 30 individual 1668547280.9083495 2022-11-15T21:21:20.908350+00:00 intermediate_selection individual005.jpg   -1
exp_2022_11_15_13 30 individual 1668547281.706254 2022-11-15T21:21:21.706254+00:00 final_submission individual005.jpg 1 -1
exp_2022_11_15_13 30 individual 1668547289.430325 2022-11-15T21:21:29.430325+00:00 intermediate_selection individual006.jpg   2
exp_2022_11_15_13 30 individual 1668547290.7194202 2022-11-15T21:21:30.719420+00:00 intermediate_selection individual006.jpg   1
exp_2022_11_15_13 30 individual 1668547291.7670515 2022-11-15T21:21:31.767051+00:00 intermediate_selection individual006.jpg -2  
exp_2022_11_15_13 30 individual 1668547292.2776577 2022-11-15T21:21:32.277658+00:00 intermediate_selection individual006.jpg -1  
exp_2022_11_15_13 30 individual 1668547292.8262136 2022-11-15T21:21:32.826214+00:00 final_submission individual006.jpg -1 1
exp_2022_11_15_13 30 individual 1668547300.6041186 2022-11-15T21:21:40.604119+00:00 intermediate_selection individual007.jpg   2
exp_2022_11_15_13 30 individual 1668547301.7349913 2022-11-15T21:21:41.734991+00:00 intermediate_selection individual007.jpg 0  
exp_2022_11_15_13 30 individual 1668547302.450869 2022-11-15T21:21:42.450869+00:00 final_submission individual007.jpg 0 2
exp_2022_11_15_13 30 individual 1668547310.0479076 2022-11-15T21:21:50.047908+00:00 intermediate_selection individual008.jpg 1  
exp_2022_11_15_13 30 individual 1668547310.4458582 2022-11-15T21:21:50.445858+00:00 intermediate_selection individual008.jpg 0  
exp_2022_11_15_13 30 individual 1668547310.747964 2022-11-15T21:21:50.747964+00:00 intermediate_selection individual008.jpg -1  
exp_2022_11_15_13 30 individual 1668547311.2405303 2022-11-15T21:21:51.240530+00:00 intermediate_selection individual008.jpg   1
exp_2022_11_15_13 30 individual 1668547311.778956 2022-11-15T21:21:51.778956+00:00 final_submission individual008.jpg -1 1
exp_2022_11_15_13 30 individual 1668547320.1826177 2022-11-15T21:22:00.182618+00:00 intermediate_selection individual009.jpg   1
exp_2022_11_15_13 30 individual 1668547321.1844878 2022-11-15T21:22:01.184488+00:00 intermediate_selection individual009.jpg -1  
exp_2022_11_15_13 30 individual 1668547321.6749756 2022-11-15T21:22:01.674976+00:00 final_submission individual009.jpg -1 1
exp_2022_11_15_13 30 individual 1668547329.1111834 2022-11-15T21:22:09.111183+00:00 intermediate_selection individual010.jpg 1  
exp_2022_11_15_13 30 individual 1668547329.4540431 2022-11-15T21:22:09.454043+00:00 intermediate_selection individual010.jpg   2
exp_2022_11_15_13 30 individual 1668547330.310522 2022-11-15T21:22:10.310522+00:00 intermediate_selection individual010.jpg   0
exp_2022_11_15_13 30 individual 1668547330.5504596 2022-11-15T21:22:10.550460+00:00 intermediate_selection individual010.jpg   -1
exp_2022_11_15_13 30 individual 1668547331.4915864 2022-11-15T21:22:11.491586+00:00 final_submission individual010.jpg 1 -1
exp_2022_11_15_13 30 individual 1668547338.9287279 2022-11-15T21:22:18.928728+00:00 intermediate_selection individual011.jpg 0  
exp_2022_11_15_13 30 individual 1668547340.153597 2022-11-15T21:22:20.153597+00:00 intermediate_selection individual011.jpg   0
exp_2022_11_15_13 30 individual 1668547340.8407884 2022-11-15T21:22:20.840788+00:00 intermediate_selection individual011.jpg   -1
exp_2022_11_15_13 30 individual 1668547341.9798615 2022-11-15T21:22:21.979861+00:00 final_submission individual011.jpg 0 -1
exp_2022_11_15_13 30 individual 1668547349.7741117 2022-11-15T21:22:29.774112+00:00 intermediate_selection individual012.jpg   -2
exp_2022_11_15_13 30 individual 1668547350.9220235 2022-11-15T21:22:30.922024+00:00 intermediate_selection individual012.jpg 0  
exp_2022_11_15_13 30 individual 1668547351.5167363 2022-11-15T21:22:31.516736+00:00 final_submission individual012.jpg 0 -2
exp_2022_11_15_13 30 individual 1668547360.7606015 2022-11-15T21:22:40.760602+00:00 intermediate_selection individual013.jpg 0  
exp_2022_11_15_13 30 individual 1668547361.4198687 2022-11-15T21:22:41.419869+00:00 intermediate_selection individual013.jpg   0
exp_2022_11_15_13 30 individual 1668547362.108702 2022-11-15T21:22:42.108702+00:00 final_submission individual013.jpg 0 0
exp_2022_11_15_13 30 individual 1668547369.5606961 2022-11-15T21:22:49.560696+00:00 intermediate_selection individual014.jpg 1  
exp_2022_11_15_13 30 individual 1668547370.1900544 2022-11-15T21:22:50.190054+00:00 intermediate_selection individual014.jpg   -1
exp_2022_11_15_13 30 individual 1668547370.5964787 2022-11-15T21:22:50.596479+00:00 final_submission individual014.jpg 1 -1
exp_2022_11_15_13 30 team 1668547548.906604 2022-11-15T21:25:48.906604+00:00 intermediate_selection Team001.jpg 0  
exp_2022_11_15_13 30 team 1668547549.4630382 2022-11-15T21:25:49.463038+00:00 intermediate_selection Team001.jpg   0
exp_2022_11_15_13 30 team 1668547552.2274148 2022-11-15T21:25:52.227415+00:00 final_submission Team001.jpg 0 0
exp_2022_11_15_13 30 team 1668547675.978467 2022-11-15T21:27:55.978467+00:00 intermediate_selection Team004.jpg 2  
exp_2022_11_15_13 30 team 1668547676.6047726 2022-11-15T21:27:56.604773+00:00 intermediate_selection Team004.jpg   2
exp_2022_11_15_13 30 team 1668547677.5758886 2022-11-15T21:27:57.575889+00:00 final_submission Team004.jpg 2 2
exp_2022_11_15_13 30 team 1668547801.1587546 2022-11-15T21:30:01.158755+00:00 intermediate_selection Team007.jpg -2  
exp_2022_11_15_13 30 team 1668547802.0467496 2022-11-15T21:30:02.046750+00:00 intermediate_selection Team007.jpg   2
exp_2022_11_15_13 30 team 1668547802.835812 2022-11-15T21:30:02.835812+00:00 final_submission Team007.jpg -2 2
exp_2022_11_15_13 30 team 1668547926.339347 2022-11-15T21:32:06.339347+00:00 intermediate_selection Team010.jpg 0  
exp_2022_11_15_13 30 team 1668547927.1394968 2022-11-15T21:32:07.139497+00:00 intermediate_selection Team010.jpg   0
exp_2022_11_15_13 30 team 1668547928.2083678 2022-11-15T21:32:08.208368+00:00 final_submission Team010.jpg 0 0
exp_2022_11_15_13 30 team 1668548054.6330795 2022-11-15T21:34:14.633080+00:00 intermediate_selection Team013.jpg 2  
exp_2022_11_15_13 30 team 1668548055.392927 2022-11-15T21:34:15.392927+00:00 intermediate_selection Team013.jpg   1
exp_2022_11_15_13 30 team 1668548056.5566688 2022-11-15T21:34:16.556669+00:00 final_submission Team013.jpg 2 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]);