musiccaps
1 row where aspect_list contains "digital/acoustic drums" and audioset_ids contains "/m/0bm02"
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 |
---|---|---|---|---|---|---|---|---|---|---|
gjujPd1lP8E | A digital kick in playing on every beat along with short voice samples with breathy sounds that sound seductive. Then the song changes into someone fingerpicking an acoustic guitar along to someone playing an acoustic snare/hihat with brushes. This first song may be playing in a club and the second one at a live concert. | ["techno/singer-songwriter", "acoustic guitar", "digital/acoustic drums", "male voice samples", "seductive", "medium to uptempo"] | ["Cymbal", "Drum", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 6 | 0 | 10 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/03qtq", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/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 );