musiccaps
3 rows where aspect_list contains "acoustic drums", aspect_list contains "acoustic piano" and aspect_list contains "jazz"
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 |
---|---|---|---|---|---|---|---|---|---|---|
3dzR3ZWOe8Y | This song contains acoustic drums playing a complex rhythm along with a e-bass playing a walking bassline and a piano playing jazz chords in the mid range. A baritone saxophone is playing the main melody accompanied by other brass instruments. This song may be playing during a live concert. | ["jazz", "baritone saxophone", "acoustic piano", "saxophones", "trombones", "trumpets", "acoustic drums", "e-bass", "very fast tempo"] | ["Brass instrument", "Saxophone"] | 6 | 410 | 420 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] | |
QRKc90kuAaE | This composition contains acoustic drums playing a complex groove on just the snare using brushes. The crowd in the background is cheering, whistling and clapping their hands. A bass, piano and horn section is playing a melody as a counter-beat along with trumpets playing along a modified melody in a higher register. Then saxophones are coming in playing their own countermelody. This song is highly complex and may be playing at a jazz festival. | ["jazz", "acoustic drums", "acoustic piano", "brass section", "horn section", "background crowd", "uptempo"] | ["Brass instrument", "Cymbal", "Drum kit", "Jazz", "Music", "Musical instrument", "Percussion"] | 6 | 560 | 570 | 0 | 1 | ["/m/01kcd", "/m/01qbl", "/m/02hnl", "/m/03_d0", "/m/04rlf", "/m/04szw", "/m/0l14md"] | |
kdxW11WBlQE | This song contains a fast and silent jazz drum rhythm with a fast groove on the ride. Someone is playing an arpeggio melody on an acoustic piano in the midrange, adding a little melody on top being played in the upper register. A upright bass is playing a walking bassline. A saxophone is playing the main melody. This song may be playing live as a concert. | ["jazz", "amateur recording", "upright bass", "acoustic drums", "acoustic piano", "saxophone", "fast tempo", "calm"] | ["Brass instrument", "Cello", "Saxophone", "Pizzicato", "Bowed string instrument"] | 6 | 150 | 160 | 0 | 0 | ["/m/01kcd", "/m/01xqw", "/m/06ncr", "/m/0d8_n", "/m/0l14_3"] |
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 );