musiccaps_details (view)
5 rows where musiccaps_aspects contains "acoustic drums", musiccaps_author = 6 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- acoustic drums · 5 ✖
- acoustic piano 3
- jazz 3
- amateur recording 2
- e-bass 2
- trumpets 2
- upright bass 2
- uptempo 2
- acoustic guitar 1
- background crowd 1
- baritone saxophone 1
- brass 1
- brass section 1
- calm 1
- country 1
- fast tempo 1
- higher key 1
- horn section 1
- kids voice streaming 1
- male voice singing 1
- medium to uptempo 1
- out of tune 1
- parody 1
- piano 1
- saxophone 1
- saxophones 1
- trombones 1
- uplifting energy 1
- very fast tempo 1
musiccaps_names (array) 12 ✖
- Brass instrument · 5 ✖
- Saxophone 2
- Trumpet 2
- Bowed string instrument 1
- Cello 1
- Cymbal 1
- Drum kit 1
- Jazz 1
- Music 1
- Musical instrument 1
- Percussion 1
- Pizzicato 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
AGK Angry German Kid vs Stacey Hedger-Star Wars Trumpet Solo | This audio contains an acoustic drum playing a groove along with a simple bassline. Trumpets are playing a melody that sounds out of tune and all over the place while a kids voice is streaming and you can hear some aggressive clicking sounds. This song may be playing for a parody video. | 2007-11-11T13:53:01Z | nexiva | Angry German Kid takes on his most talentless opponent yet: Stacey Hedger, from the infamous "Star Wars Trumpet Solo" pageant video. This continues the tradition of the AGK videos where fake english subtitles are overlayed the original vision, and intercut with a cult internet video. | ["Brass instrument", "Trumpet"] | ["amateur recording", "kids voice streaming", "trumpets", "acoustic drums", "e-bass", "out of tune", "parody", "medium to uptempo"] | 6 | -mB_XLq6g1g | 84 | |
Buddy Rich / Channel One Suite Part 2 | 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. | 2009-08-04T16:41:44Z | Bob Bowlby | Berlin Jazz Festival. November 3, 1984. | ["Brass instrument", "Saxophone"] | ["jazz", "baritone saxophone", "acoustic piano", "saxophones", "trombones", "trumpets", "acoustic drums", "e-bass", "very fast tempo"] | 6 | 3dzR3ZWOe8Y | 490 | |
Buddy Rich Live at The Montreal Jazz Festival | 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. | 2013-01-30T04:49:46Z | Raphael Moura | The Buddy Rich Big Band | ["Brass instrument", "Cymbal", "Drum kit", "Jazz", "Music", "Musical instrument", "Percussion"] | ["jazz", "acoustic drums", "acoustic piano", "brass section", "horn section", "background crowd", "uptempo"] | 6 | QRKc90kuAaE | 2618 | |
6 WHITE BOOMERS 2013 | This song contains a piano playing short rhythmic chords along with an acoustic guitar and an upright bass playing the same melody. A brass melody is opening the scene. sound A male voice is singing in a higher register. This song may be playing while celebrating with the whole family on a national holiday. | 2014-11-25T23:03:53Z | Snapshot 21st Century | ["Brass instrument", "Trumpet"] | ["country", "acoustic guitar", "piano", "acoustic drums", "upright bass", "male voice singing", "higher key", "brass", "uptempo", "uplifting energy"] | 6 | Qu76GhRO9Yk | 2648 | ||
James Farm, Chronos.mp4 | 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. | 2012-03-23T03:37:24Z | Jennifer Kessler | James Farm featuring Joshua Redman, Aaron Parks, Matt Penman, and Eric Harland, at the Jazz Standard, June 2011 Produced by Jennifer Kessler, James Sapione, and Stuart Schulzke | ["Brass instrument", "Cello", "Saxophone", "Pizzicato", "Bowed string instrument"] | ["jazz", "amateur recording", "upright bass", "acoustic drums", "acoustic piano", "saxophone", "fast tempo", "calm"] | 6 | kdxW11WBlQE | 4337 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;