musiccaps
2 rows where aspect_list contains "double bass" and audioset_ids contains "/m/02hnl"
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 |
---|---|---|---|---|---|---|---|---|---|---|
OWbfAmrFdp8 | This is an acoustic drum jam. The drummer is playing rapidly using the double bass technique which is an iconic technique used in metal drumming. The atmosphere is loud and aggressive. This piece can be sampled for use in beat-making. | ["jam", "acoustic drums", "rapid playing", "double bass", "metal drumming", "loud", "aggressive"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 9 | 40 | 50 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
_miAGxDX5FM | This jazz song features the main melody played on a reed instrument and a guitar in unison. The melody is an ascending pattern of three notes per beat. This is accompanied by percussion playing a simple beat ending on an extended drum roll. The bass plays a descending run followed by an ascending run. The piano plays jazz chords in the background. There are no voices in this instrumental song. This song can be played in a luxury bar. | ["big band jazz", "percussion", "no voices", "instrumental", "piano", "reed instrument", "guitar", "double bass", "moderate tempo", "easy listening"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 0 | 160 | 170 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/02k_mr", "/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 );