musiccaps_details (view)
2 rows where musiccaps_aspects contains "reverb" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- reverb · 2 ✖
- acoustic bass 1
- audience sounds 1
- danceable 1
- latin jazz 1
- male voice over 1
- piano 1
- recital hall 1
- sneeze 1
- solo horn 1
- syncopated drums 1
- triad based melody 1
- trumpet solo 1
- upbeat rhythm 1
musiccaps_names (array) 7 ✖
- Brass instrument · 2 ✖
- French horn 1
- Inside, large room or hall 1
- Jazz 1
- Music 1
- Musical instrument 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 | |
Arturo & Doc Solos.mp4 | a latin jazz ensemble performing in a recital hall. A trumpet solo is accompanied by acoustic bass, syncopated drums and piano. The rhythm is upbeat and danceable. You can hear the reverb of the recital hall as well as audience sounds, someone sneezing. | 2010-11-29T02:19:26Z | jazzman1222 | This is my second Video of Doc and Arturo at the Rafael Mendez Trumpet Festival in Mexico City. Hard to believe that Doc is 83, he still has a wonderful sound!!! Arturo is still burnin´as usual!! | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Trumpet", "Inside, large room or hall"] | ["latin jazz", "trumpet solo", "acoustic bass", "recital hall", "reverb", "audience sounds", "sneeze", "piano", "syncopated drums", "upbeat rhythm", "danceable"] | 8 | eiyyoUt64Zc | 3894 |
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;