musiccaps_details (view)
3 rows where musiccaps_author = 8 and musiccaps_names = "["Brass instrument", "French horn"]"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
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 | |
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;