musiccaps_details (view)
1 row where musiccaps_aspects contains "forest music", musiccaps_aspects contains "groovy rhythm" and musiccaps_aspects contains "healing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ondrej Smeykal Didjeridu Solo 2 | The song is an instrumental. The tempo is medium with a wood block percussion and a didgeridoo playing percussively. The song is spiritual and emotional in nature. The audio quality is poor. | 2009-05-01T20:56:34Z | Barry Martin | Here's the much anticipated second clip of Ondrej Smeykal playing didgeridoo while visiting LA Outback. Ondrej is playing this didjeridu solo with a pair of clapsticks. If you ever have the chance to see him live definitely make it a point to do so. Check out a wide selection of didgerdioo made in Australia and available in the US at http://www.laoutback.com | ["Didgeridoo", "Music"] | ["didgeridoo", "didgeridoo player", "live music", "home music video", "demonstration", "aboriginal instruments", "poor audio quality", "wood clock percussions", "instrumental music", "hand percussions", "tapping sounds", "medium tempo", "percussive horn play", "groovy rhythm", "emotional", "devotional", "healing", "forest music"] | 1 | q7U8p-m8J3s | 4753 |
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;