musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice over" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- male voice over · 3 ✖
- brass ensemble 1
- fast 1
- quick tempo 1
- reverb 1
- solo horn 1
- solo oboe melody in background 1
- triad based melody 1
- virtuosity 1
musiccaps_names (array) 4 ✖
- Brass instrument 3
- French horn · 3 ✖
- Trombone 1
- Trumpet 1
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 | |
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;