musiccaps_details (view)
1 row where musiccaps_aspects contains "reverb", musiccaps_aspects contains "solo horn" and "youtube_published" is on date 2011-03-16
This data as json, CSV (advanced)
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 |
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;