musiccaps
1 row where aspect_list contains "bad audio quality", aspect_list contains "drum demonstration", aspect_list contains "energetic" and aspect_list contains "instrumental music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
NcsYdCbKgcc | The song is an instrumental. The song is medium fast tempo with percussionists playing a groovy rhythm on three clap boxes. The sound quality is poor with a lot of ambient crowd noise. | ["clap box rhythm", "percussionist", "medium fast tempo", "live performance", "exciting", "energetic", "passionate", "drum demonstration", "youtube music video", "instrumental music", "ambient crowd noise", "groovy rhythm", "people talking", "bad audio quality", "percussion demonstration"] | ["Wood block", "Percussion"] | 1 | 90 | 100 | 0 | 0 | ["/m/01sm1g", "/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 );