musiccaps
3 rows where aspect_list contains "upright bass" and audioset_ids contains "/m/06ncr"
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 |
---|---|---|---|---|---|---|---|---|---|---|
9UCLvFqkFxk | This is a jazz music piece. There is a saxophone playing a jazzy solo for the melody. There is an upright bass playing in the background. The rhythmic background consists of a slow tempo acoustic drum beat that is played with brushes. The atmosphere is mellow. This piece could be playing in the background of a classy restaurant or a coffee shop. | ["jazz", "instrumental", "saxophone", "upright bass", "acoustic drums", "brushes", "mellow", "gentle", "slow tempo"] | ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] | 9 | 140 | 150 | 0 | 0 | ["/m/01kcd", "/m/06ncr", "/m/085jw"] | |
XpueyrkcMyQ | This is a jazz music piece. There is a trumpet and a saxophone playing the lead melody. The piano is playing the chords of the piece while the upright bass is playing a groovy bass line. The acoustic drums are playing a swing type beat for the rhythmic background. The atmosphere is groovy. This piece could be playing in the background at a coffee shop. | ["jazz", "instrumental", "trumpet", "saxophone", "upright bass", "piano", "acoustic drums", "groovy", "vibrant"] | ["Brass instrument", "Saxophone", "Trumpet"] | 9 | 280 | 290 | 0 | 0 | ["/m/01kcd", "/m/06ncr", "/m/07gql"] | |
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 );