musiccaps_details (view)
1 row where musiccaps_aspects contains "breathing technique", musiccaps_aspects contains "poignant", musiccaps_aspects contains "traditional music" and musiccaps_names contains "Didgeridoo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Guida sulla Respirazione Circolare - Circular Breathing [ AboriginalTrip - Marcello Ballardini ] | The song is an instrumental. The song is medium fast tempo with a didgeridoo playing percussively with no other instrumentation. The song is played passionately and spirited. The audio quality is very poor. | 2010-03-08T15:58:09Z | Norbiz90 | Circular Breathing is one of the greatest difficulties encountered in learning to play the didjeridoo. Here is a video help guide on how to learn this technique. Happy viewing! This and other videos on: http://www.aboriginaltrip.com/ - All About Didjeridoo -- La Respirazione Circolare è una delle più grandi difficoltà che si incontrano nell'imparare a suonare il Didjeridoo. In aiuto eccovi una video guida su come imparare questa tecnica. Buona Visione!! Questo ed altri video Su: http://www.aboriginaltrip.com/ - Tutto sul Didjeridoo - | ["Didgeridoo", "Music"] | ["didgeridoo", "sonorous tones", "aboriginal instruments", "groovy rhythm", "deep breaths", "breathing technique", "home music video", "solo instrument", "instrumental music", "home video", "bad audio quality", "music video", "traditional music", "emotional", "poignant", "percussive blowing patterns"] | 1 | qfVIeq7s6tw | 4806 |
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;