Column descriptions
- group_session
- The group session the task is a part of.
- station
- Participant ID.
- minecraft_mission_id
- ID of the minecraft mission the audio was recorded.
- id
- sequential ID of the signal.
- timestamp_unix
- The Unix timestamp of the signal.
- timestamp_iso8601
- The ISO-8601 timestamp of the signal.
- frame_time
- The frame time in seconds.
- features
- A list of OpenSMILE features extracted from the audio.
where group_session = "exp_2022_09_30_10"
✎ View and edit SQL
This data as json, copyable
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])
);