musiccaps_details (view)
5 rows where musiccaps_aspects contains "trumpets", musiccaps_author = 6 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- trumpets · 5 ✖
- acoustic drums 2
- amateur recording 2
- e-bass 2
- medium to uptempo 2
- acoustic piano 1
- adventures 1
- alarm ringing 1
- baritone saxophone 1
- bass horns 1
- brass performance 1
- classical 1
- jazz 1
- kids voice streaming 1
- oboes/flutes 1
- orchestral 1
- out of tune 1
- parody 1
- saxophones 1
- slow tempo 1
- trombones 1
- tuba 1
- uptempo 1
- very fast tempo 1
musiccaps_names (array) 8 ✖
- Brass instrument · 5 ✖
- Trumpet 3
- French horn 1
- Inside, small room 1
- Music 1
- Saxophone 1
- Telephone bell ringing 1
- Trombone 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 | |
He's a Pirate | This song contains an overlayer of trumpets playing a melody in a higher register along to a tuba serving as bass. This song may be playing for a video layering sounds on top of each other. | 2009-08-05T04:49:19Z | Greg Ah Sue | Become a fan on Facebook for updates and sheet music! http://www.facebook.com/pages/Greg-Ah-Sue-Multi-tracks/110190309002217 SHEET MUSIC: http://img8.imageshack.us/gal.php?g=pirates0001.tif Hey, I watched trombone player zoot69 do this and liked it so I loosely arranged what she played and tried it myself. I pitched one trumpet down an octave and another one down two instead of having a real trombone and tuba. Video edited with Sony Vegas and audio edited with Sony Acid. | ["Brass instrument", "Trumpet"] | ["amateur recording", "trumpets", "tuba", "uptempo", "adventures"] | 6 | G18Nt0ZeEJQ | 1686 | |
Expectations vs. Reality of a Studyblr | This audio contains trumpets playing the main melody in the higher mid range while oboes and flutes are playing a melody that sounds like a bunny hopping over obstacles. Then the music stops with a crashing sound and an alarm clock starts ringing. This song may be playing live as part of an orchestra composition. | 2015-10-02T11:32:00Z | Leo Studies | Hope you guys like the video! Obviously it's all a bit exaggerated ;) Make sure to subscribe for more videos! Lots of love, Leo xx ---- LINKS --- TUMBLR: leostudies.com (yay I got my own domain!) INSTAGRAM: @leoleclerc | ["Brass instrument", "Music", "Telephone bell ringing", "Inside, small room"] | ["orchestral", "classical", "trumpets", "oboes/flutes", "alarm ringing", "medium to uptempo"] | 6 | XW6tS4zAZ5E | 3188 | |
Art of Brass Vienna plays Austrian Christmas Carols | This audio contains a composition played by brass instruments such as trumpets playing a melody in the higher range along with a deeper horn and a bass horn. This song may be playing at a theater presenting this composition. | 2014-04-13T18:51:13Z | brassysounds | Art of Brass Vienna (Hans Gansch, Heinrich Bruckner, Thomas Bieber, Erich Kojeder, Jonathan Sass) plays Austrian Christmas Carols arr. by Heinrich Bruckner. This arrangement is available at https://primverlag.at/produkte/weihnachtslieder/ | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["brass performance", "trumpets", "bass horns", "slow tempo"] | 6 | r_KdRKquXsM | 4886 |
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;