musiccaps
1 row where aspect_list contains "male backing vocal" and aspect_list contains "piano"
This data as json, CSV (advanced)
aspect_list (array) 8 ✖
- bass guitar 1
- drums 1
- male backing vocal · 1 ✖
- male voice 1
- medium-fast tempo 1
- piano · 1 ✖
- saxophone 1
- ska genre 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
WPguqXCBQCI | The ska music features a male voice singing and being accompanied by another male backing vocal. The tempo is medium-fast, specific to the ska genre. The drums play a somewhat busy rhythm and the bass guitar plays a simple repeating bass line. In the background a piano accompanies the singer. Towards the end of the music excerpt a saxophone can be heard. | ["male voice", "male backing vocal", "piano", "bass guitar", "drums", "ska genre", "medium-fast tempo", "saxophone"] | ["Music", "Ska"] | 2 | 328 | 338 | 1 | 1 | ["/m/04rlf", "/m/06rqw"] |
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 );