musiccaps
2 rows where aspect_list contains "amateur singing" and aspect_list contains "male vocalist"
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 |
---|---|---|---|---|---|---|---|---|---|---|
2BGzxAuetOA | A male vocalist sings this song. The tempo is slow, with intense drumming; keyboard harmony, groovy bass lines and electric guitar harmony in the background. The vocalist is singing a dissonant tune along with syncopated music over the melodious and rhythmic background. This is probably karaoke. | ["male vocalist", "electric guitar riff", "intense drumming", "melodious background music", "rhythmic background drumming", "groovy background bass", "melodious background electric guitar harmony", "dissonant music playing over song", "dissonant keyboard", "karaoke", "amateur singing", "amateur drumming", "chaotic", "off key singing", "not in sync"] | ["Music", "Roll", "Rock and roll"] | 7 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/07s8j8t", "/m/07sbbz2"] | |
4W8IZxn3nEI | A male vocalist sings this animated song. The tempo is medium fast with keyboard harmony, acoustic guitar , steady drumming and simple bass lines. The song is simple, catchy, funny, spirited, animated and easy to sing along. The lyrics are funny. | ["male vocalist", "medium fast tempo", "off key singing", "relatable", "simple melody", "funny", "homer simpson cover", "home video", "amateur singing", "animated", "childish lyrics", "keyboard harmony", "steady drumming", "simple bass lines", "auto tune", "rhythmic acoustic", "guitar"] | ["Music", "/t/dd00003", "Synthetic singing"] | 7 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/t/dd00003", "/t/dd00006"] |
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 );