musiccaps
1 row where aspect_list contains "amateur drumming" and aspect_list contains "chaotic"
This data as json, CSV (advanced)
aspect_list (array) 15 ✖
- amateur drumming · 1 ✖
- amateur singing 1
- chaotic · 1 ✖
- dissonant keyboard 1
- dissonant music playing over song 1
- electric guitar riff 1
- groovy background bass 1
- intense drumming 1
- karaoke 1
- male vocalist 1
- melodious background electric guitar harmony 1
- melodious background music 1
- not in sync 1
- off key singing 1
- rhythmic background drumming 1
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"] |
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 );