musiccaps
2 rows where aspect_list contains "poor audio quality" and audioset_ids contains "/m/01jnbd"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
R4b_-IT43P4 | The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. | ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] | ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | 1 | 30 | 40 | 0 | 1 | ["/m/0155w", "/m/01jnbd", "/m/02rr_", "/m/02sgy", "/m/04rlf", "/m/0g12c5"] | |
RczzNAr1T_Q | The song is an instrumental. The tempo is medium with a guitar strumming to different settings of an effects delay pedal with echoes and effects being heard. The song is an effects pedal demonstration. The audio quality is poor with hissing sounds. | ["instrumental music", "turning knobs", "delay pedal", "poor audio quality", "hissing sounds", "rehearsals session", "ambient room noise", "guitar effects pedal", "tone generator", "poor audio quality", "guitar strumming", "echo tones", "testing effects", "guitar demo", "energetic", "casual playing", "reverb peas", "echoes", "medium tempo"] | ["Reverberation", "Tapping (guitar technique)", "Echo", "Effects unit", "Guitar", "Music", "Distortion"] | 1 | 30 | 40 | 0 | 1 | ["/m/01b9nn", "/m/01glhc", "/m/01jnbd", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/0g12c5"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );