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_18_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_18_10 -2 team 1668796604.5084164 2022-11-18T18:36:44.508416+00:00 start_affective_task      
exp_2022_11_18_10 35 individual 1668796351.025028 2022-11-18T18:32:31.025028+00:00 start_affective_task      
exp_2022_11_18_10 35 individual 1668796359.3174157 2022-11-18T18:32:39.317416+00:00 intermediate_selection individual000.jpg 1  
exp_2022_11_18_10 35 individual 1668796360.992652 2022-11-18T18:32:40.992652+00:00 intermediate_selection individual000.jpg   -1
exp_2022_11_18_10 35 individual 1668796361.8504288 2022-11-18T18:32:41.850429+00:00 final_submission individual000.jpg 1 -1
exp_2022_11_18_10 35 individual 1668796369.4373925 2022-11-18T18:32:49.437392+00:00 intermediate_selection individual001.jpg 1  
exp_2022_11_18_10 35 individual 1668796371.4404342 2022-11-18T18:32:51.440434+00:00 intermediate_selection individual001.jpg   0
exp_2022_11_18_10 35 individual 1668796372.6511533 2022-11-18T18:32:52.651153+00:00 final_submission individual001.jpg 1 0
exp_2022_11_18_10 35 individual 1668796380.7040098 2022-11-18T18:33:00.704010+00:00 intermediate_selection individual002.jpg 1  
exp_2022_11_18_10 35 individual 1668796381.5902295 2022-11-18T18:33:01.590230+00:00 intermediate_selection individual002.jpg   -1
exp_2022_11_18_10 35 individual 1668796382.5598316 2022-11-18T18:33:02.559832+00:00 intermediate_selection individual002.jpg   0
exp_2022_11_18_10 35 individual 1668796383.067759 2022-11-18T18:33:03.067759+00:00 final_submission individual002.jpg 1 0
exp_2022_11_18_10 35 individual 1668796391.441708 2022-11-18T18:33:11.441708+00:00 intermediate_selection individual003.jpg -1  
exp_2022_11_18_10 35 individual 1668796393.1927257 2022-11-18T18:33:13.192726+00:00 intermediate_selection individual003.jpg   1
exp_2022_11_18_10 35 individual 1668796393.8126516 2022-11-18T18:33:13.812652+00:00 intermediate_selection individual003.jpg   2
exp_2022_11_18_10 35 individual 1668796394.6060348 2022-11-18T18:33:14.606035+00:00 intermediate_selection individual003.jpg   1
exp_2022_11_18_10 35 individual 1668796395.803781 2022-11-18T18:33:15.803781+00:00 final_submission individual003.jpg -1 1
exp_2022_11_18_10 35 individual 1668796403.5474186 2022-11-18T18:33:23.547419+00:00 intermediate_selection individual004.jpg -2  
exp_2022_11_18_10 35 individual 1668796404.3678746 2022-11-18T18:33:24.367875+00:00 intermediate_selection individual004.jpg   2
exp_2022_11_18_10 35 individual 1668796405.036037 2022-11-18T18:33:25.036037+00:00 final_submission individual004.jpg -2 2
exp_2022_11_18_10 35 individual 1668796412.576581 2022-11-18T18:33:32.576581+00:00 intermediate_selection individual005.jpg 1  
exp_2022_11_18_10 35 individual 1668796413.7004957 2022-11-18T18:33:33.700496+00:00 intermediate_selection individual005.jpg   -1
exp_2022_11_18_10 35 individual 1668796414.524447 2022-11-18T18:33:34.524447+00:00 final_submission individual005.jpg 1 -1
exp_2022_11_18_10 35 individual 1668796422.843844 2022-11-18T18:33:42.843844+00:00 intermediate_selection individual006.jpg -2  
exp_2022_11_18_10 35 individual 1668796424.0054455 2022-11-18T18:33:44.005445+00:00 intermediate_selection individual006.jpg   2
exp_2022_11_18_10 35 individual 1668796424.9408329 2022-11-18T18:33:44.940833+00:00 final_submission individual006.jpg -2 2
exp_2022_11_18_10 35 individual 1668796433.1226196 2022-11-18T18:33:53.122620+00:00 intermediate_selection individual007.jpg 2  
exp_2022_11_18_10 35 individual 1668796434.1961677 2022-11-18T18:33:54.196168+00:00 intermediate_selection individual007.jpg   2
exp_2022_11_18_10 35 individual 1668796434.8610888 2022-11-18T18:33:54.861089+00:00 final_submission individual007.jpg 2 2
exp_2022_11_18_10 35 individual 1668796443.777277 2022-11-18T18:34:03.777277+00:00 intermediate_selection individual008.jpg -1  
exp_2022_11_18_10 35 individual 1668796444.5463047 2022-11-18T18:34:04.546305+00:00 intermediate_selection individual008.jpg 0  
exp_2022_11_18_10 35 individual 1668796445.560322 2022-11-18T18:34:05.560322+00:00 intermediate_selection individual008.jpg -1  
exp_2022_11_18_10 35 individual 1668796447.0573773 2022-11-18T18:34:07.057377+00:00 intermediate_selection individual008.jpg   2
exp_2022_11_18_10 35 individual 1668796447.7896242 2022-11-18T18:34:07.789624+00:00 final_submission individual008.jpg -1 2
exp_2022_11_18_10 35 individual 1668796455.8121824 2022-11-18T18:34:15.812182+00:00 intermediate_selection individual009.jpg -2  
exp_2022_11_18_10 35 individual 1668796457.027024 2022-11-18T18:34:17.027024+00:00 intermediate_selection individual009.jpg   1
exp_2022_11_18_10 35 individual 1668796457.404777 2022-11-18T18:34:17.404777+00:00 intermediate_selection individual009.jpg   2
exp_2022_11_18_10 35 individual 1668796458.022359 2022-11-18T18:34:18.022359+00:00 final_submission individual009.jpg -2 2
exp_2022_11_18_10 35 individual 1668796465.9361784 2022-11-18T18:34:25.936178+00:00 intermediate_selection individual010.jpg 1  
exp_2022_11_18_10 35 individual 1668796467.6364672 2022-11-18T18:34:27.636467+00:00 intermediate_selection individual010.jpg   -1
exp_2022_11_18_10 35 individual 1668796468.6359975 2022-11-18T18:34:28.635998+00:00 intermediate_selection individual010.jpg   1
exp_2022_11_18_10 35 individual 1668796470.0759845 2022-11-18T18:34:30.075984+00:00 intermediate_selection individual010.jpg   -1
exp_2022_11_18_10 35 individual 1668796470.5826278 2022-11-18T18:34:30.582628+00:00 final_submission individual010.jpg 1 -1
exp_2022_11_18_10 35 individual 1668796478.6499116 2022-11-18T18:34:38.649912+00:00 intermediate_selection individual011.jpg   1
exp_2022_11_18_10 35 individual 1668796480.9813035 2022-11-18T18:34:40.981303+00:00 intermediate_selection individual011.jpg -1  
exp_2022_11_18_10 35 individual 1668796482.8253722 2022-11-18T18:34:42.825372+00:00 intermediate_selection individual011.jpg 0  
exp_2022_11_18_10 35 individual 1668796483.5083685 2022-11-18T18:34:43.508368+00:00 intermediate_selection individual011.jpg   0
exp_2022_11_18_10 35 individual 1668796484.0795152 2022-11-18T18:34:44.079515+00:00 final_submission individual011.jpg 0 0
exp_2022_11_18_10 35 individual 1668796491.426871 2022-11-18T18:34:51.426871+00:00 intermediate_selection individual012.jpg -1  
exp_2022_11_18_10 35 individual 1668796492.2422588 2022-11-18T18:34:52.242259+00:00 intermediate_selection individual012.jpg   1
exp_2022_11_18_10 35 individual 1668796493.423272 2022-11-18T18:34:53.423272+00:00 final_submission individual012.jpg -1 1
exp_2022_11_18_10 35 individual 1668796500.8937793 2022-11-18T18:35:00.893779+00:00 intermediate_selection individual013.jpg 1  
exp_2022_11_18_10 35 individual 1668796502.0925431 2022-11-18T18:35:02.092543+00:00 intermediate_selection individual013.jpg   -1
exp_2022_11_18_10 35 individual 1668796502.788439 2022-11-18T18:35:02.788439+00:00 intermediate_selection individual013.jpg   -2
exp_2022_11_18_10 35 individual 1668796504.9359102 2022-11-18T18:35:04.935910+00:00 final_submission individual013.jpg 1 -2
exp_2022_11_18_10 35 individual 1668796513.1025598 2022-11-18T18:35:13.102560+00:00 intermediate_selection individual014.jpg -1  
exp_2022_11_18_10 35 individual 1668796514.6753979 2022-11-18T18:35:14.675398+00:00 intermediate_selection individual014.jpg   -2
exp_2022_11_18_10 35 individual 1668796516.0375962 2022-11-18T18:35:16.037596+00:00 intermediate_selection individual014.jpg   -1
exp_2022_11_18_10 35 individual 1668796516.4800231 2022-11-18T18:35:16.480023+00:00 final_submission individual014.jpg -1 -1
exp_2022_11_18_10 35 team 1668796648.5382962 2022-11-18T18:37:28.538296+00:00 intermediate_selection Team000.jpg   1
exp_2022_11_18_10 35 team 1668796650.259035 2022-11-18T18:37:30.259035+00:00 intermediate_selection Team000.jpg -1  
exp_2022_11_18_10 35 team 1668796651.259123 2022-11-18T18:37:31.259123+00:00 intermediate_selection Team000.jpg -2  
exp_2022_11_18_10 35 team 1668796652.7290862 2022-11-18T18:37:32.729086+00:00 final_submission Team000.jpg -2 1
exp_2022_11_18_10 35 team 1668796793.1125126 2022-11-18T18:39:53.112513+00:00 intermediate_selection Team003.jpg 1  
exp_2022_11_18_10 35 team 1668796795.4234374 2022-11-18T18:39:55.423437+00:00 final_submission Team003.jpg 1  
exp_2022_11_18_10 35 team 1668796924.5724547 2022-11-18T18:42:04.572455+00:00 intermediate_selection Team006.jpg 1  
exp_2022_11_18_10 35 team 1668796926.3036568 2022-11-18T18:42:06.303657+00:00 intermediate_selection Team006.jpg   1
exp_2022_11_18_10 35 team 1668796927.5270848 2022-11-18T18:42:07.527085+00:00 final_submission Team006.jpg 1 1
exp_2022_11_18_10 35 team 1668797070.2105536 2022-11-18T18:44:30.210554+00:00 final_submission Team009.jpg    
exp_2022_11_18_10 35 team 1668797200.9377158 2022-11-18T18:46:40.937716+00:00 intermediate_selection Team012.jpg   1
exp_2022_11_18_10 35 team 1668797202.4169066 2022-11-18T18:46:42.416907+00:00 intermediate_selection Team012.jpg 1  
exp_2022_11_18_10 35 team 1668797203.3926826 2022-11-18T18:46:43.392683+00:00 final_submission Team012.jpg 1 1
exp_2022_11_18_10 56 individual 1668796351.064713 2022-11-18T18:32:31.064713+00:00 start_affective_task      
exp_2022_11_18_10 56 individual 1668796363.1557543 2022-11-18T18:32:43.155754+00:00 intermediate_selection individual000.jpg 0  
exp_2022_11_18_10 56 individual 1668796367.6603959 2022-11-18T18:32:47.660396+00:00 intermediate_selection individual000.jpg   -2
exp_2022_11_18_10 56 individual 1668796369.2010348 2022-11-18T18:32:49.201035+00:00 final_submission individual000.jpg 0 -2
exp_2022_11_18_10 56 individual 1668796378.324362 2022-11-18T18:32:58.324362+00:00 intermediate_selection individual001.jpg 2  
exp_2022_11_18_10 56 individual 1668796383.414092 2022-11-18T18:33:03.414092+00:00 intermediate_selection individual001.jpg   0
exp_2022_11_18_10 56 individual 1668796386.7522786 2022-11-18T18:33:06.752279+00:00 intermediate_selection individual001.jpg   -2
exp_2022_11_18_10 56 individual 1668796387.607674 2022-11-18T18:33:07.607674+00:00 final_submission individual001.jpg 2 -2
exp_2022_11_18_10 56 individual 1668796395.886086 2022-11-18T18:33:15.886086+00:00 intermediate_selection individual002.jpg 0  
exp_2022_11_18_10 56 individual 1668796396.8960514 2022-11-18T18:33:16.896051+00:00 intermediate_selection individual002.jpg   -2
exp_2022_11_18_10 56 individual 1668796398.3335042 2022-11-18T18:33:18.333504+00:00 final_submission individual002.jpg 0 -2
exp_2022_11_18_10 56 individual 1668796408.9026973 2022-11-18T18:33:28.902697+00:00 intermediate_selection individual003.jpg -1  
exp_2022_11_18_10 56 individual 1668796410.739982 2022-11-18T18:33:30.739982+00:00 intermediate_selection individual003.jpg   1
exp_2022_11_18_10 56 individual 1668796413.2541337 2022-11-18T18:33:33.254134+00:00 final_submission individual003.jpg -1 1
exp_2022_11_18_10 56 individual 1668796421.9250221 2022-11-18T18:33:41.925022+00:00 intermediate_selection individual004.jpg -1  
exp_2022_11_18_10 56 individual 1668796423.1839128 2022-11-18T18:33:43.183913+00:00 intermediate_selection individual004.jpg   -2
exp_2022_11_18_10 56 individual 1668796424.5587156 2022-11-18T18:33:44.558716+00:00 final_submission individual004.jpg -1 -2
exp_2022_11_18_10 56 individual 1668796433.1764383 2022-11-18T18:33:53.176438+00:00 intermediate_selection individual005.jpg 2  
exp_2022_11_18_10 56 individual 1668796435.1176236 2022-11-18T18:33:55.117624+00:00 intermediate_selection individual005.jpg   0
exp_2022_11_18_10 56 individual 1668796436.159389 2022-11-18T18:33:56.159389+00:00 final_submission individual005.jpg 2 0
exp_2022_11_18_10 56 individual 1668796444.2728705 2022-11-18T18:34:04.272871+00:00 intermediate_selection individual006.jpg -2  
exp_2022_11_18_10 56 individual 1668796446.7806904 2022-11-18T18:34:06.780690+00:00 intermediate_selection individual006.jpg   1
exp_2022_11_18_10 56 individual 1668796448.3200145 2022-11-18T18:34:08.320014+00:00 final_submission individual006.jpg -2 1
exp_2022_11_18_10 56 individual 1668796456.675883 2022-11-18T18:34:16.675883+00:00 intermediate_selection individual007.jpg 0  
exp_2022_11_18_10 56 individual 1668796457.8313503 2022-11-18T18:34:17.831350+00:00 intermediate_selection individual007.jpg   -2
exp_2022_11_18_10 56 individual 1668796458.7521994 2022-11-18T18:34:18.752199+00:00 final_submission individual007.jpg 0 -2
exp_2022_11_18_10 56 individual 1668796467.9615567 2022-11-18T18:34:27.961557+00:00 intermediate_selection individual008.jpg 0  
exp_2022_11_18_10 56 individual 1668796470.1236897 2022-11-18T18:34:30.123690+00:00 intermediate_selection individual008.jpg   -2

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