musiccaps_details (view)
5 rows where musiccaps_author = 8 and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 23 ✖
- male voice over 3
- brass ensemble 2
- chamber music 1
- classical 1
- counterpoint 1
- cymbal 1
- fast 1
- french horn solo 1
- glockenspiel 1
- jazz 1
- live recording 1
- natural reverb 1
- noble 1
- orchestral 1
- quick tempo 1
- recital hall 1
- reverb 1
- solo horn 1
- solo oboe melody in background 1
- stately 1
- triad based melody 1
- virtuosity 1
- woodwinds 1
musiccaps_names (array) 4 ✖
- Brass instrument 5
- French horn · 5 ✖
- Trombone 2
- Trumpet 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Horn lessons with Radovan Vlatkovic, Strauss 1st Horn Concerto, Play With a Pro | Solo horn with reverb performing a triad based melody. A male voice over can be heard in the beginning. | 2011-03-16T19:14:59Z | Play With A Pro Music Academy | Full horn lesson with Radovan Vlatkovic, Strauss 1st Horn Concerto @ http://playwithapro.com/video/artist/radovan-vlatkovic See the big horn master Radovan Vlatkovic share his thoughts on one of the great masterpieces for horn, Strauss 1st Concerto. Get deep insight of all the small details and see how a truly great artist teaches. | ["Brass instrument", "French horn"] | ["solo horn", "male voice over", "reverb", "triad based melody"] | 8 | 1VKSpjXZvKo | 281 | |
Canadian Brass: "Perfect Landing" CD Discussion | A brass ensemble playing a fast piece with a quick tempo and virtuosity. Male voice over. | 2015-11-05T14:10:33Z | Canadian Brass | "Perfect Landing," the new Canadian Brass album to be released Nov. 6th by Opening Day Entertainment, comes after the wildly successful album "Takes Flight". This discussion is a rare insight into the making of a groundbreaking album which will feature a slew of new compositions, new arrangements and audience favourites. | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["fast", "quick tempo", "brass ensemble", "male voice over", "virtuosity"] | 8 | 86YDiQjYU1U | 897 | |
Ewald - Quintet No. 1, I. Moderato | A live recording of a brass ensemble in a chamber style arrangement. Natural reverb from a recital hall is present. The music features counterpoint amongst the different instruments, and the mood is stately and noble. | 2010-03-03T22:12:00Z | FlatironsBrass | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["live recording", "recital hall", "natural reverb", "brass ensemble", "chamber music", "stately", "noble", "counterpoint"] | 8 | dzW5M4sCphI | 3833 | ||
Solo de trompa 2 - Adalto Soares - Orquestra de Sopros Brasileira (Tatuí) | French horn solo with orchestral accompaniment, woodwinds, glockenspiel and cymbals. The genre is jazz and classical. | 2011-12-17T15:16:44Z | Rafael Sobral | Quatro Peças Brasileiras para Trompa e Banda O Rei do Maracatu A Bandinha no Coreto Quando não se Sonha mais Frevando Sem Parar | ["Brass instrument", "French horn"] | ["french horn solo", "glockenspiel", "orchestral", "woodwinds", "jazz", "classical", "cymbal"] | 8 | p0oRrGDrQQw | 4675 | |
EUIV Sweden is Overpowered 49 | Male voice over with a solo oboe melody in the background. | 2015-07-18T19:00:02Z | Arumba | Let's play Europa Universalis IV with the Common Sense expansion! In this campaign we will try out the beta patch 1.13, go for a few achievements and enjoy the now much more balanced development system. If you enjoyed this video please consider hitting the Like button, it helps the channel grow by affecting search results on YouTube. Make sure to subscribe to the channel so you stay up to date on new releases!: http://www.youtube.com/subscription_center?add_user=Arumba07 This series is best viewed from the playlist: https://www.youtube.com/playlist?list=PLH-huzMEgGWAyWhNurVDECbIZlfutb1iV | ["Brass instrument", "French horn"] | ["male voice over", "solo oboe melody in background"] | 8 | ryEXhKy1QUI | 4909 |
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;