musiccaps
2 rows where aspect_list contains "toms" and audioset_ids contains "/m/01qbl"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BcVapmCbULQ | This is a drum beat in the rock and roll style, with a drum roll in between that's intricate. The snare, toms, hi-hats and crash cymbal are used. | ["drum beat", "rock drum pattern", "drum roll", "snare", "toms", "hi-hats", "crash cymbal", "complex drum roll"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 3 | 30 | 40 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/03qtq", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
c8gD6153aNI | This song features a drum solo being played. The hi-hat, snare, kick and toms are played in this clip. There are no other instruments in this song. There are no voices in this song. This song can be played in an instruction video. | ["drum solo", "no other instruments", "no voices", "kick drum", "snare", "hi-hat", "toms", "moderate tempo"] | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 0 | 80 | 90 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/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 );