musiccaps
3 rows where audioset_ids contains "/m/0239kh", audioset_ids contains "/m/0l14md" and author_id = 9
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 |
---|---|---|---|---|---|---|---|---|---|---|
940MNbCeobw | This is the recording of a cowbell. The cowbell is being played with the side and the tip of the drumstick repeatedly. This recording could be sampled for use in beat-making especially for genres that have a heavy usage of cowbells such as latin dance music. | ["instrumental", "percussion", "rhythm", "cowbell"] | ["Cowbell", "Percussion"] | 9 | 0 | 10 | 0 | 0 | ["/m/0239kh", "/m/0l14md"] | |
AkHaDKuiE_s | This is an instrumental percussion piece. There is an acoustic latin drum kit composed of the cowbells and the timbales. The drummer is playing an energetic solo on this kit. This piece could be playing in the background at a drum shop. | ["percussion", "rhythm", "instrumental", "acoustic latin drums", "timbale", "cowbell", "energetic", "latin dance"] | ["Cowbell", "Drum", "Rimshot", "Snare drum", "Percussion"] | 9 | 60 | 70 | 0 | 0 | ["/m/0239kh", "/m/026t6", "/m/03t3fj", "/m/06rvn", "/m/0l14md"] | |
rKRI5UcIICI | This is an acoustic drum solo performance. The drummer is playing rapid and complex fills with a heavy use of cowbells. There is a clear latin music influence in this solo. It has an energetic aura. Parts of this performance could be sampled in use for beat-making. | ["instrumental", "single instrument", "acoustic drums", "drum solo", "cowbells", "latin influence", "energetic"] | ["Cymbal", "Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 9 | 30 | 40 | 0 | 0 | ["/m/01qbl", "/m/0239kh", "/m/026t6", "/m/02hnl", "/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 );