OpenSMILE vocalic features extracted from the audios during the Minecraft missions.
0 records
CREATE TABLE "audio_vocalics" ( [group_session] TEXT REFERENCES [group_session]([id]), [station] TEXT REFERENCES [station]([id]), [minecraft_mission_id] TEXT REFERENCES [minecraft_mission]([id]), [id] INTEGER, [timestamp_unix] TEXT, [timestamp_iso8601] TEXT, [frame_time] FLOAT, [f0final_sma] FLOAT, [voicingfinalunclipped_sma] FLOAT, [jitterlocal_sma] FLOAT, [jitterddp_sma] FLOAT, [shimmerlocal_sma] FLOAT, [loghnr_sma] FLOAT, [audspec_lengthl1norm_sma] FLOAT, [audspecrasta_lengthl1norm_sma] FLOAT, [wave_rmsenergy_sma] FLOAT, [wave_zcr_sma] FLOAT, [audspec_rfilt_sma_0_] FLOAT, [audspec_rfilt_sma_1_] FLOAT, [audspec_rfilt_sma_2_] FLOAT, [audspec_rfilt_sma_3_] FLOAT, [audspec_rfilt_sma_4_] FLOAT, [audspec_rfilt_sma_5_] FLOAT, [audspec_rfilt_sma_6_] FLOAT, [audspec_rfilt_sma_7_] FLOAT, [audspec_rfilt_sma_8_] FLOAT, [audspec_rfilt_sma_9_] FLOAT, [audspec_rfilt_sma_10_] FLOAT, [audspec_rfilt_sma_11_] FLOAT, [audspec_rfilt_sma_12_] FLOAT, [audspec_rfilt_sma_13_] FLOAT, [audspec_rfilt_sma_14_] FLOAT, [audspec_rfilt_sma_15_] FLOAT, [audspec_rfilt_sma_16_] FLOAT, [audspec_rfilt_sma_17_] FLOAT, [audspec_rfilt_sma_18_] FLOAT, [audspec_rfilt_sma_19_] FLOAT, [audspec_rfilt_sma_20_] FLOAT, [audspec_rfilt_sma_21_] FLOAT, [audspec_rfilt_sma_22_] FLOAT, [audspec_rfilt_sma_23_] FLOAT, [audspec_rfilt_sma_24_] FLOAT, [audspec_rfilt_sma_25_] FLOAT, [wave_fftmag_fband250-650_sma] FLOAT, [wave_fftmag_fband1000-4000_sma] FLOAT, [wave_fftmag_spectralrolloff25.0_sma] FLOAT, [wave_fftmag_spectralrolloff50.0_sma] FLOAT, [wave_fftmag_spectralrolloff75.0_sma] FLOAT, [wave_fftmag_spectralrolloff90.0_sma] FLOAT, [wave_fftmag_spectralflux_sma] FLOAT, [wave_fftmag_spectralcentroid_sma] FLOAT, [wave_fftmag_spectralentropy_sma] FLOAT, [wave_fftmag_spectralvariance_sma] FLOAT, [wave_fftmag_spectralskewness_sma] FLOAT, [wave_fftmag_spectralkurtosis_sma] FLOAT, [wave_fftmag_spectralslope_sma] FLOAT, [wave_fftmag_psysharpness_sma] FLOAT, [wave_fftmag_spectralharmonicity_sma] FLOAT, [mfcc_sma_1_] FLOAT, [mfcc_sma_2_] FLOAT, [mfcc_sma_3_] FLOAT, [mfcc_sma_4_] FLOAT, [mfcc_sma_5_] FLOAT, [mfcc_sma_6_] FLOAT, [mfcc_sma_7_] FLOAT, [mfcc_sma_8_] FLOAT, [mfcc_sma_9_] FLOAT, [mfcc_sma_10_] FLOAT, [mfcc_sma_11_] FLOAT, [mfcc_sma_12_] FLOAT, [mfcc_sma_13_] FLOAT, [mfcc_sma_14_] FLOAT, [f0final_sma_de] FLOAT, [voicingfinalunclipped_sma_de] FLOAT, [jitterlocal_sma_de] FLOAT, [jitterddp_sma_de] FLOAT, [shimmerlocal_sma_de] FLOAT, [loghnr_sma_de] FLOAT, [audspec_lengthl1norm_sma_de] FLOAT, [audspecrasta_lengthl1norm_sma_de] FLOAT, [wave_rmsenergy_sma_de] FLOAT, [wave_zcr_sma_de] FLOAT, [audspec_rfilt_sma_de_0_] FLOAT, [audspec_rfilt_sma_de_1_] FLOAT, [audspec_rfilt_sma_de_2_] FLOAT, [audspec_rfilt_sma_de_3_] FLOAT, [audspec_rfilt_sma_de_4_] FLOAT, [audspec_rfilt_sma_de_5_] FLOAT, [audspec_rfilt_sma_de_6_] FLOAT, [audspec_rfilt_sma_de_7_] FLOAT, [audspec_rfilt_sma_de_8_] FLOAT, [audspec_rfilt_sma_de_9_] FLOAT, [audspec_rfilt_sma_de_10_] FLOAT, [audspec_rfilt_sma_de_11_] FLOAT, [audspec_rfilt_sma_de_12_] FLOAT, [audspec_rfilt_sma_de_13_] FLOAT, [audspec_rfilt_sma_de_14_] FLOAT, [audspec_rfilt_sma_de_15_] FLOAT, [audspec_rfilt_sma_de_16_] FLOAT, [audspec_rfilt_sma_de_17_] FLOAT, [audspec_rfilt_sma_de_18_] FLOAT, [audspec_rfilt_sma_de_19_] FLOAT, [audspec_rfilt_sma_de_20_] FLOAT, [audspec_rfilt_sma_de_21_] FLOAT, [audspec_rfilt_sma_de_22_] FLOAT, [audspec_rfilt_sma_de_23_] FLOAT, [audspec_rfilt_sma_de_24_] FLOAT, [audspec_rfilt_sma_de_25_] FLOAT, [wave_fftmag_fband250-650_sma_de] FLOAT, [wave_fftmag_fband1000-4000_sma_de] FLOAT, [wave_fftmag_spectralrolloff25.0_sma_de] FLOAT, [wave_fftmag_spectralrolloff50.0_sma_de] FLOAT, [wave_fftmag_spectralrolloff75.0_sma_de] FLOAT, [wave_fftmag_spectralrolloff90.0_sma_de] FLOAT, [wave_fftmag_spectralflux_sma_de] FLOAT, [wave_fftmag_spectralcentroid_sma_de] FLOAT, [wave_fftmag_spectralentropy_sma_de] FLOAT, [wave_fftmag_spectralvariance_sma_de] FLOAT, [wave_fftmag_spectralskewness_sma_de] FLOAT, [wave_fftmag_spectralkurtosis_sma_de] FLOAT, [wave_fftmag_spectralslope_sma_de] FLOAT, [wave_fftmag_psysharpness_sma_de] FLOAT, [wave_fftmag_spectralharmonicity_sma_de] FLOAT, [mfcc_sma_de_1_] FLOAT, [mfcc_sma_de_2_] FLOAT, [mfcc_sma_de_3_] FLOAT, [mfcc_sma_de_4_] FLOAT, [mfcc_sma_de_5_] FLOAT, [mfcc_sma_de_6_] FLOAT, [mfcc_sma_de_7_] FLOAT, [mfcc_sma_de_8_] FLOAT, [mfcc_sma_de_9_] FLOAT, [mfcc_sma_de_10_] FLOAT, [mfcc_sma_de_11_] FLOAT, [mfcc_sma_de_12_] FLOAT, [mfcc_sma_de_13_] FLOAT, [mfcc_sma_de_14_] FLOAT, [f0final_sma_de.1] FLOAT, [voicingfinalunclipped_sma_de.1] FLOAT, [jitterlocal_sma_de.1] FLOAT, [jitterddp_sma_de.1] FLOAT, [shimmerlocal_sma_de.1] FLOAT, [loghnr_sma_de.1] FLOAT, [audspec_lengthl1norm_sma_de.1] FLOAT, [audspecrasta_lengthl1norm_sma_de.1] FLOAT, [wave_rmsenergy_sma_de.1] FLOAT, [wave_zcr_sma_de.1] FLOAT, [audspec_rfilt_sma_de_0_.1] FLOAT, [audspec_rfilt_sma_de_1_.1] FLOAT, [audspec_rfilt_sma_de_2_.1] FLOAT, [audspec_rfilt_sma_de_3_.1] FLOAT, [audspec_rfilt_sma_de_4_.1] FLOAT, [audspec_rfilt_sma_de_5_.1] FLOAT, [audspec_rfilt_sma_de_6_.1] FLOAT, [audspec_rfilt_sma_de_7_.1] FLOAT, [audspec_rfilt_sma_de_8_.1] FLOAT, [audspec_rfilt_sma_de_9_.1] FLOAT, [audspec_rfilt_sma_de_10_.1] FLOAT, [audspec_rfilt_sma_de_11_.1] FLOAT, [audspec_rfilt_sma_de_12_.1] FLOAT, [audspec_rfilt_sma_de_13_.1] FLOAT, [audspec_rfilt_sma_de_14_.1] FLOAT, [audspec_rfilt_sma_de_15_.1] FLOAT, [audspec_rfilt_sma_de_16_.1] FLOAT, [audspec_rfilt_sma_de_17_.1] FLOAT, [audspec_rfilt_sma_de_18_.1] FLOAT, [audspec_rfilt_sma_de_19_.1] FLOAT, [audspec_rfilt_sma_de_20_.1] FLOAT, [audspec_rfilt_sma_de_21_.1] FLOAT, [audspec_rfilt_sma_de_22_.1] FLOAT, [audspec_rfilt_sma_de_23_.1] FLOAT, [audspec_rfilt_sma_de_24_.1] FLOAT, [audspec_rfilt_sma_de_25_.1] FLOAT, [wave_fftmag_fband250-650_sma_de.1] FLOAT, [wave_fftmag_fband1000-4000_sma_de.1] FLOAT, [wave_fftmag_spectralrolloff25.0_sma_de.1] FLOAT, [wave_fftmag_spectralrolloff50.0_sma_de.1] FLOAT, [wave_fftmag_spectralrolloff75.0_sma_de.1] FLOAT, [wave_fftmag_spectralrolloff90.0_sma_de.1] FLOAT, [wave_fftmag_spectralflux_sma_de.1] FLOAT, [wave_fftmag_spectralcentroid_sma_de.1] FLOAT, [wave_fftmag_spectralentropy_sma_de.1] FLOAT, [wave_fftmag_spectralvariance_sma_de.1] FLOAT, [wave_fftmag_spectralskewness_sma_de.1] FLOAT, [wave_fftmag_spectralkurtosis_sma_de.1] FLOAT, [wave_fftmag_spectralslope_sma_de.1] FLOAT, [wave_fftmag_psysharpness_sma_de.1] FLOAT, [wave_fftmag_spectralharmonicity_sma_de.1] FLOAT, [mfcc_sma_de_1_.1] FLOAT, [mfcc_sma_de_2_.1] FLOAT, [mfcc_sma_de_3_.1] FLOAT, [mfcc_sma_de_4_.1] FLOAT, [mfcc_sma_de_5_.1] FLOAT, [mfcc_sma_de_6_.1] FLOAT, [mfcc_sma_de_7_.1] FLOAT, [mfcc_sma_de_8_.1] FLOAT, [mfcc_sma_de_9_.1] FLOAT, [mfcc_sma_de_10_.1] FLOAT, [mfcc_sma_de_11_.1] FLOAT, [mfcc_sma_de_12_.1] FLOAT, [mfcc_sma_de_13_.1] FLOAT, [mfcc_sma_de_14_.1] FLOAT, PRIMARY KEY ([group_session], [station], [minecraft_mission_id], [id]) );