musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "trombone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- brass · 2 ✖
- instrumental · 2 ✖
- trombone · 2 ✖
- band 1
- brass band 1
- bright 1
- cheerful 1
- clarinet 1
- cymbals 1
- dramatic 1
- energetic 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- fun 1
- happy 1
- lively 1
- peppy 1
- perky 1
- royal 1
- single instrument 1
- spirited 1
- trumpet 1
- tuba 1
- wind instrument 1
musiccaps_names (array) 3 ✖
- Brass instrument 2
- Clarinet 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banda musicale dell'arma dei carabinieri.Italia.Москва.brass band | This music is a lively instrumental. The tempo is fast with an enthusiastic Brass and wind instrument harmony. The vigorous trumpets, trombone and tuba accompaniment, along with clanging cymbals and playful clarinet make for an upbeat, cheerful, happy, energetic and Perky Band Music. | 2012-09-04T16:25:29Z | umo61 | Спасская Башня.Кремль.Красная Площадь.Orchestra Carabineros.Militari orchestra Italia.оркестр Италии.духовые инструменты.winds. | ["Brass instrument", "Clarinet"] | ["instrumental", "fast tempo", "enthusiastic", "brass band", "cheerful", "happy", "bright", "fun", "engaging", "perky", "peppy", "bright", "energetic", "lively", "spirited", "cymbals", "clarinet", "trumpet", "tuba", "trombone", "wind instrument", "brass", "band", "engaging"] | 7 | Aak-VLHtFPM | 1142 | |
YouTube Symphony Orchestra Audition 2011 Trombone.mp4 | This is a trombone performance piece for an audition. The tune being played resembles something that would be heard at the royal court of a western kingdom. The atmosphere is dramatic. This piece could be used in the soundtrack of a historical drama movie, especially during the scenes where the king is attending a feast. | 2010-11-28T23:42:46Z | MrVuvuzelaman | http://goo.gl/2wxGn Roman Riedel, Trombone/ Posaune Member "YouTubeSymphonyOrchestra2011" Hello! This video is my application for the YouTube Symphony Orchestra Audition 2011. I'm a trombonist from Germany, my name is Roman. Recorded live in one take without any cuts in November 2010 Location: ,Rossini- Saal' , Bad Kissingen -Ferdinand David from Concertino op.4: first movement, Edition Hofmeister -4 Orchestral Excerpts (H. Berlioz, from: Damnation of Faust, Hungarian March/ W.A. Mozart, from Requiem: Tuba Mirum/ R. Wagner, from 'The Valkyrie' : 'The Ride of the Valkyries' & R. Schumann, from Symphony No.3: Beginning 4th movement) Instrumentarium: modified CONN 88H fitted by Kromat Mouthpiece: modified Bach 5G from Klier Recording equipment: Flip cam- no external microphone used | ["Brass instrument", "Trombone"] | ["instrumental", "single instrument", "brass", "trombone", "royal", "dramatic"] | 9 | mZNNWTrvGoA | 4478 |
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;