musiccaps
2 rows where aspect_list contains "male vocal" and end_s = 240
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 |
---|---|---|---|---|---|---|---|---|---|---|
WT_wvvEvkw4 | This is an outro for a kids song. The song features quirky male vocals. Right after the end of the phrase, thunderstorm sounds start to play in the background as well as ocean SFX. | ["outro", "kids music", "rain", "thunder", "male vocal", "ocean sound effects"] | ["Silence", "Music", "Eruption"] | 5 | 230 | 240 | 1 | 1 | ["/m/028v0c", "/m/04rlf", "/m/07pxg6y"] | |
wMN-Xp9IMUw | This is an Afro-cuban music piece in the style of rumba. It is a live performance. There is a male vocal and a choir singing in a joyful manner. The rhythmic background is composed of Afro-Cuban percussive elements such as the shekere and the conga. The atmosphere is lively and vibrant. This piece could be used as an accompaniment piece for a rumba dance course. | ["afro cuban", "rumba", "live performance", "male vocal", "choir", "joyful singing", "percussion", "shekere", "conga", "lively", "vibrant", "dance"] | ["Drum", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | 9 | 230 | 240 | 0 | 0 | ["/m/026t6", "/m/04rlf", "/m/04szw", "/m/05r5wn", "/m/0l14md"] |
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 );