musiccaps_details (view)
4 rows where musiccaps_aspects contains "trumpet", musiccaps_author = 3 and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- trumpet · 4 ✖
- tuba 2
- big 1
- brass 1
- brass quintet 1
- cheery 1
- clarinets 1
- classical style 1
- complex brass motif 1
- cymbals 1
- exciting 1
- french horn 1
- french horns 1
- grand 1
- high pitched brass instrument 1
- important moment 1
- orchestra 1
- quintet 1
- rapid trumpet motif 1
- repeated motif 1
- solo trumpet 1
- thrilling 1
- timpani 1
- trombone 1
- upbeat trumpet peace 1
musiccaps_names (array) 10 ✖
- Brass instrument · 4 ✖
- Trumpet 3
- Music 2
- Trombone 2
- Classical music 1
- French horn 1
- Jazz 1
- Musical instrument 1
- Orchestra 1
- Timpani 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Super Mario 64 Bob-omb Battlefield Theme Sheet Music - Trumpet | This is a solo trumpet piece which is cheery and upbeat. The pitch is generally high, with a few low notes which contrast and stand out against the high notes. | 2009-06-01T00:42:40Z | smashbros1321 | This is sheet music for "Super Mario 64 Main Theme" from the game Super Mario 64 arranged for Trumpet in B flat, but can also be played by B flat Clarinet, and Tenor Sax. Arranged in Finale NotePad 2008. If anyone has a song they want the sheet music for, just leave a comment or message me. Sheet Music: http://i577.photobucket.com/albums/ss212/smashbros1321/SuperMario64MainTheme.jpg Rate, Comment, and Subscribe! | ["Brass instrument", "Trombone", "Trumpet"] | ["trumpet", "solo trumpet", "upbeat trumpet peace", "cheery"] | 3 | Lc6OfmzV7Pk | 2208 | |
Shostakovich: Symphony No. 12 / Dudamel · Berliner Philharmoniker | This is a symphonic orchestra playing a piece that's riveting, thrilling and exciting. The peace would be suitable in a movie when something grand and impressive happens. There are clarinets, tubas, trumpets and french horns being played. The brass instruments help create that sense of a momentous occasion. The percussion is done on timpanis and a cymbal. | 2009-12-29T09:21:58Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/248/?a=youtube&c=true Dmitri Shostakovich: Symphony No. 12 "The Year 1917" / Gustavo Dudamel, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 September 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Timpani", "Brass instrument", "Music", "Orchestra", "Classical music"] | ["timpani", "orchestra", "grand", "big", "french horns", "tuba", "trumpet", "clarinets", "cymbals", "thrilling", "exciting", "important moment"] | 3 | XM4hxyK-Ddo | 3178 | |
Adam Rapa's "Flight of the Bumble Bee" | This clip is a live recording of a complex and rapid piece being played on the trumpet. The trumpet is very high pitched and the piece ascends and descends rapidly in succession. | 2008-10-29T06:12:39Z | MonetteCorporation | Adam Rapa playing some of his 7/8 arrangement of "Flight of the Bumble Bee" just half an hour after he took delivery of his new PRANA P3S Bb, March 2007. | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet"] | ["high pitched brass instrument", "trumpet", "rapid trumpet motif", "complex brass motif"] | 3 | _vwBe9ZXWXE | 3498 | |
ALMA PROJECT 24/7 - Brass Quintet AS - Wedding March (Felix Mendelssohn) | This is a classical style of music played by a brass quintet. The instruments featured include the trombone, tuba, french horn and trumpets. The motif they play is repeated, and it has a celebratory feel - as if for a big occasion. | 2015-03-10T09:14:01Z | ALMA PROJECT - 24/7 | 2 trumpets 1 french horn 1 trombone 1 tuba ALMA PROJECT 24/7 - Brass Quintet AS - Wedding March (Felix Mendelssohn) Booking: info@almaproject.it www.almaproject.it Live Music, Dj Services, Live Cover Bands, Audio and Lighting Systems, Backline rental and full technical assistance, Video Projections, Initials and Logos projection, Stages, Dancefloors, Dj Booths, Customized Productions, Bulbs, Fairy lights, Recording Studio, Design and Rendering, and every related service always providing the best solutions for your Event! #entertainment #tuscany #wedding #corporateevents #lighting #dancefloors #stages | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["quintet", "brass", "tuba", "trumpet", "french horn", "brass quintet", "trombone", "repeated motif", "classical style"] | 3 | bZXQlQnleL4 | 3635 |
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;