Data license: CC BY-NC-SA 4.0

Custom SQL query

Tables

affective_task_event

group_session, participant, task_type, timestamp_unix, timestamp_iso8601, event_type, image_path, arousal_score, valence_score

14,586 rows

audio_vocalics

group_session, station, minecraft_mission_id, id, timestamp_unix, timestamp_iso8601, frame_time, F0final_sma, voicingFinalUnclipped_sma, jitterLocal_sma, jitterDDP_sma, shimmerLocal_sma, logHNR_sma, audspec_lengthL1norm_sma, audspecRasta_lengthL1norm_sma, wave_RMSenergy_sma, wave_zcr_sma, audSpec_Rfilt_sma_0_, audSpec_Rfilt_sma_1_, audSpec_Rfilt_sma_2_, audSpec_Rfilt_sma_3_, audSpec_Rfilt_sma_4_, audSpec_Rfilt_sma_5_, audSpec_Rfilt_sma_6_, audSpec_Rfilt_sma_7_, audSpec_Rfilt_sma_8_, audSpec_Rfilt_sma_9_, audSpec_Rfilt_sma_10_, audSpec_Rfilt_sma_11_, audSpec_Rfilt_sma_12_, audSpec_Rfilt_sma_13_, audSpec_Rfilt_sma_14_, audSpec_Rfilt_sma_15_, audSpec_Rfilt_sma_16_, audSpec_Rfilt_sma_17_, audSpec_Rfilt_sma_18_, audSpec_Rfilt_sma_19_, audSpec_Rfilt_sma_20_, audSpec_Rfilt_sma_21_, audSpec_Rfilt_sma_22_, audSpec_Rfilt_sma_23_, audSpec_Rfilt_sma_24_, audSpec_Rfilt_sma_25_, wave_fftMag_fband250-650_sma, wave_fftMag_fband1000-4000_sma, wave_fftMag_spectralRollOff25.0_sma, wave_fftMag_spectralRollOff50.0_sma, wave_fftMag_spectralRollOff75.0_sma, wave_fftMag_spectralRollOff90.0_sma, wave_fftMag_spectralFlux_sma, wave_fftMag_spectralCentroid_sma, wave_fftMag_spectralEntropy_sma, wave_fftMag_spectralVariance_sma, wave_fftMag_spectralSkewness_sma, wave_fftMag_spectralKurtosis_sma, wave_fftMag_spectralSlope_sma, wave_fftMag_psySharpness_sma, wave_fftMag_spectralHarmonicity_sma, mfcc_sma_1_, mfcc_sma_2_, mfcc_sma_3_, mfcc_sma_4_, mfcc_sma_5_, mfcc_sma_6_, mfcc_sma_7_, mfcc_sma_8_, mfcc_sma_9_, mfcc_sma_10_, mfcc_sma_11_, mfcc_sma_12_, mfcc_sma_13_, mfcc_sma_14_, F0final_sma_de, voicingFinalUnclipped_sma_de, jitterLocal_sma_de, jitterDDP_sma_de, shimmerLocal_sma_de, logHNR_sma_de, audspec_lengthL1norm_sma_de, audspecRasta_lengthL1norm_sma_de, wave_RMSenergy_sma_de, wave_zcr_sma_de, audSpec_Rfilt_sma_de_0_, audSpec_Rfilt_sma_de_1_, audSpec_Rfilt_sma_de_2_, audSpec_Rfilt_sma_de_3_, audSpec_Rfilt_sma_de_4_, audSpec_Rfilt_sma_de_5_, audSpec_Rfilt_sma_de_6_, audSpec_Rfilt_sma_de_7_, audSpec_Rfilt_sma_de_8_, audSpec_Rfilt_sma_de_9_, audSpec_Rfilt_sma_de_10_, audSpec_Rfilt_sma_de_11_, audSpec_Rfilt_sma_de_12_, audSpec_Rfilt_sma_de_13_, audSpec_Rfilt_sma_de_14_, audSpec_Rfilt_sma_de_15_, audSpec_Rfilt_sma_de_16_, audSpec_Rfilt_sma_de_17_, audSpec_Rfilt_sma_de_18_, audSpec_Rfilt_sma_de_19_, audSpec_Rfilt_sma_de_20_, audSpec_Rfilt_sma_de_21_, audSpec_Rfilt_sma_de_22_, audSpec_Rfilt_sma_de_23_, audSpec_Rfilt_sma_de_24_, audSpec_Rfilt_sma_de_25_, wave_fftMag_fband250-650_sma_de, wave_fftMag_fband1000-4000_sma_de, wave_fftMag_spectralRollOff25.0_sma_de, wave_fftMag_spectralRollOff50.0_sma_de, wave_fftMag_spectralRollOff75.0_sma_de, wave_fftMag_spectralRollOff90.0_sma_de, wave_fftMag_spectralFlux_sma_de, wave_fftMag_spectralCentroid_sma_de, wave_fftMag_spectralEntropy_sma_de, wave_fftMag_spectralVariance_sma_de, wave_fftMag_spectralSkewness_sma_de, wave_fftMag_spectralKurtosis_sma_de, wave_fftMag_spectralSlope_sma_de, wave_fftMag_psySharpness_sma_de, wave_fftMag_spectralHarmonicity_sma_de, mfcc_sma_de_1_, mfcc_sma_de_2_, mfcc_sma_de_3_, mfcc_sma_de_4_, mfcc_sma_de_5_, mfcc_sma_de_6_, mfcc_sma_de_7_, mfcc_sma_de_8_, mfcc_sma_de_9_, mfcc_sma_de_10_, mfcc_sma_de_11_, mfcc_sma_de_12_, mfcc_sma_de_13_, mfcc_sma_de_14_, F0final_sma_de.1, voicingFinalUnclipped_sma_de.1, jitterLocal_sma_de.1, jitterDDP_sma_de.1, shimmerLocal_sma_de.1, logHNR_sma_de.1, audspec_lengthL1norm_sma_de.1, audspecRasta_lengthL1norm_sma_de.1, wave_RMSenergy_sma_de.1, wave_zcr_sma_de.1, audSpec_Rfilt_sma_de_0_.1, audSpec_Rfilt_sma_de_1_.1, audSpec_Rfilt_sma_de_2_.1, audSpec_Rfilt_sma_de_3_.1, audSpec_Rfilt_sma_de_4_.1, audSpec_Rfilt_sma_de_5_.1, audSpec_Rfilt_sma_de_6_.1, audSpec_Rfilt_sma_de_7_.1, audSpec_Rfilt_sma_de_8_.1, audSpec_Rfilt_sma_de_9_.1, audSpec_Rfilt_sma_de_10_.1, audSpec_Rfilt_sma_de_11_.1, audSpec_Rfilt_sma_de_12_.1, audSpec_Rfilt_sma_de_13_.1, audSpec_Rfilt_sma_de_14_.1, audSpec_Rfilt_sma_de_15_.1, audSpec_Rfilt_sma_de_16_.1, audSpec_Rfilt_sma_de_17_.1, audSpec_Rfilt_sma_de_18_.1, audSpec_Rfilt_sma_de_19_.1, audSpec_Rfilt_sma_de_20_.1, audSpec_Rfilt_sma_de_21_.1, audSpec_Rfilt_sma_de_22_.1, audSpec_Rfilt_sma_de_23_.1, audSpec_Rfilt_sma_de_24_.1, audSpec_Rfilt_sma_de_25_.1, wave_fftMag_fband250-650_sma_de.1, wave_fftMag_fband1000-4000_sma_de.1, wave_fftMag_spectralRollOff25.0_sma_de.1, wave_fftMag_spectralRollOff50.0_sma_de.1, wave_fftMag_spectralRollOff75.0_sma_de.1, wave_fftMag_spectralRollOff90.0_sma_de.1, wave_fftMag_spectralFlux_sma_de.1, wave_fftMag_spectralCentroid_sma_de.1, wave_fftMag_spectralEntropy_sma_de.1, wave_fftMag_spectralVariance_sma_de.1, wave_fftMag_spectralSkewness_sma_de.1, wave_fftMag_spectralKurtosis_sma_de.1, wave_fftMag_spectralSlope_sma_de.1, wave_fftMag_psySharpness_sma_de.1, wave_fftMag_spectralHarmonicity_sma_de.1, mfcc_sma_de_1_.1, mfcc_sma_de_2_.1, mfcc_sma_de_3_.1, mfcc_sma_de_4_.1, mfcc_sma_de_5_.1, mfcc_sma_de_6_.1, mfcc_sma_de_7_.1, mfcc_sma_de_8_.1, mfcc_sma_de_9_.1, mfcc_sma_de_10_.1, mfcc_sma_de_11_.1, mfcc_sma_de_12_.1, mfcc_sma_de_13_.1, mfcc_sma_de_14_.1

33,049,497 rows

data_validity

group_session, participant, station, task, modality, is_valid

3,060 rows

eeg_device

group_session, station, device_id

120 rows

eeg_raw

group_session, station, participant, id, task, timestamp_unix, timestamp_iso8601, aff1h, f7, fc5, c3, t7, tp9, pz, p3, p7, o1, o2, p8, p4, tp10, cz, c4, t8, fc6, fcz, f8, aff2h, aux_gsr, aux_ekg, aff5h, fc1, cp5, cp1, po9, oz, po10, cp6, cp2, fc2, aff6h

320,700,934 rows

eeg_sync

group_session, frequency, station, id, timestamp_unix, timestamp_iso8601, aff1h, f7, fc5, c3, t7, tp9, pz, p3, p7, o1, o2, p8, p4, tp10, cz, c4, t8, fc6, fcz, f8, aff2h

124,351,398 rows

ekg_sync

group_session, frequency, station, id, timestamp_unix, timestamp_iso8601, ekg, heart_rate

97,446,792 rows

finger_tapping_task_observation

group_session, timestamp_unix, timestamp_iso8601, event_type, countdown_timer, lion_spacebar_pressed, tiger_spacebar_pressed, leopard_spacebar_pressed

99,875 rows

fnirs_raw

group_session, station, participant, id, task, timestamp_unix, timestamp_iso8601, s1_d1_hbo, s1_d2_hbo, s2_d1_hbo, s2_d3_hbo, s3_d1_hbo, s3_d3_hbo, s3_d4_hbo, s4_d2_hbo, s4_d4_hbo, s4_d5_hbo, s5_d3_hbo, s5_d4_hbo, s5_d6_hbo, s6_d4_hbo, s6_d6_hbo, s6_d7_hbo, s7_d5_hbo, s7_d7_hbo, s8_d6_hbo, s8_d7_hbo, s1_d1_hbr, s1_d2_hbr, s2_d1_hbr, s2_d3_hbr, s3_d1_hbr, s3_d3_hbr, s3_d4_hbr, s4_d2_hbr, s4_d4_hbr, s4_d5_hbr, s5_d3_hbr, s5_d4_hbr, s5_d6_hbr, s6_d4_hbr, s6_d6_hbr, s6_d7_hbr, s7_d5_hbr, s7_d7_hbr, s8_d6_hbr, s8_d7_hbr, s1_d1_raw760, s1_d2_raw760, s2_d1_raw760, s2_d3_raw760, s3_d1_raw760, s3_d3_raw760, s3_d4_raw760, s4_d2_raw760, s4_d4_raw760, s4_d5_raw760, s5_d3_raw760, s5_d4_raw760, s5_d6_raw760, s6_d4_raw760, s6_d6_raw760, s6_d7_raw760, s7_d5_raw760, s7_d7_raw760, s8_d6_raw760, s8_d7_raw760, s1_d1_raw850, s1_d2_raw850, s2_d1_raw850, s2_d3_raw850, s3_d1_raw850, s3_d3_raw850, s3_d4_raw850, s4_d2_raw850, s4_d4_raw850, s4_d5_raw850, s5_d3_raw850, s5_d4_raw850, s5_d6_raw850, s6_d4_raw850, s6_d6_raw850, s6_d7_raw850, s7_d5_raw850, s7_d7_raw850, s8_d6_raw850, s8_d7_raw850

6,849,295 rows

fnirs_sync

group_session, frequency, station, id, timestamp_unix, timestamp_iso8601, s1_d1_hbo, s1_d2_hbo, s2_d1_hbo, s2_d3_hbo, s3_d1_hbo, s3_d3_hbo, s3_d4_hbo, s4_d2_hbo, s4_d4_hbo, s4_d5_hbo, s5_d3_hbo, s5_d4_hbo, s5_d6_hbo, s6_d4_hbo, s6_d6_hbo, s6_d7_hbo, s7_d5_hbo, s7_d7_hbo, s8_d6_hbo, s8_d7_hbo, s1_d1_hbr, s1_d2_hbr, s2_d1_hbr, s2_d3_hbr, s3_d1_hbr, s3_d3_hbr, s3_d4_hbr, s4_d2_hbr, s4_d4_hbr, s4_d5_hbr, s5_d3_hbr, s5_d4_hbr, s5_d6_hbr, s6_d4_hbr, s6_d6_hbr, s6_d7_hbr, s7_d5_hbr, s7_d7_hbr, s8_d6_hbr, s8_d7_hbr

125,359,661 rows

gaze_raw

group_session, station, participant, id, task, timestamp_unix, timestamp_iso8601, confidence, norm_pos_x, norm_pos_y, gaze_point_3d_x, gaze_point_3d_y, gaze_point_3d_z, eye_center0_3d_x, eye_center0_3d_y, eye_center0_3d_z, eye_center1_3d_x, eye_center1_3d_y, eye_center1_3d_z, gaze_normal0_x, gaze_normal0_y, gaze_normal0_z, gaze_normal1_x, gaze_normal1_y, gaze_normal1_z, diameter0_2d, diameter1_2d, diameter0_3d, diameter1_3d

129,554,477 rows

group_session

id, advisor

40 rows

gsr_sync

group_session, frequency, station, id, timestamp_unix, timestamp_iso8601, gsr

124,351,398 rows

minecraft_mission

id, group_session, name, mission_start_timestamp_unix, mission_start_timestamp_iso8601, mission_stop_timestamp_unix, mission_stop_timestamp_iso8601, trial_start_timestamp_unix, trial_start_timestamp_iso8601, trial_stop_timestamp_unix, trial_stop_timestamp_iso8601, final_team_score, testbed_version

100 rows

minecraft_testbed_message

mission, id, topic, timestamp_unix, timestamp_iso8601, message

6,370,941 rows

modality

id

3 rows

participant

id

114 rows

ping_pong_competitive_task_observation

group_session, player_1_id, player_2_id, player_1_station, player_2_station, timestamp_unix, timestamp_iso8601, task_started, seconds, ball_position_x, ball_position_y, player_1_paddle_position_x, player_1_paddle_position_y, player_2_paddle_position_x, player_2_paddle_position_y, player_1_score, player_2_score

647,242 rows

ping_pong_cooperative_task_observation

group_session, player_1_id, player_2_id, player_3_id, timestamp_unix, timestamp_iso8601, task_started, seconds, ball_position_x, ball_position_y, player_1_paddle_position_x, player_1_paddle_position_y, player_2_paddle_position_x, player_2_paddle_position_y, player_3_paddle_position_x, player_3_paddle_position_y, ai_paddle_position_x, ai_paddle_position_y, team_score, ai_score

323,806 rows

rest_state_task

group_session, start_timestamp_unix, start_timestamp_iso8601, stop_timestamp_unix, stop_timestamp_iso8601

40 rows

screen_capture

group_session, station, participant, id, task, timestamp_unix, timestamp_iso8601, filename, url, timestamp_origin

4,100,470 rows

station

id

4 rows

task

id

9 rows

Download SQLite DB: tomcat.db 429.2 GB