musiccaps_details (view)
1 row where musiccaps_aspects contains "deep sound", musiccaps_aspects contains "male voice talking" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- ambient outdoor sounds 1
- australian accent 1
- blowing raspberries 1
- breeze 1
- deep sound · 1 ✖
- demonstration 1
- didgeridoo lesson 1
- didgeridoo melody 1
- didgeridoo tutorial 1
- engine sound 1
- how to play didgeridoo 1
- incessant buzz 1
- instrumental 1
- male voice talking · 1 ✖
- medium tempo 1
- people talking 1
- rich 1
- vocal vibrations 1
musiccaps_names (array) 2 ✖
- Didgeridoo 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HOW TO PLAY DIDGERIDOO LONDON UK - Using Your Voice | This music is instrumental. The tempos medium with vocalisation that sounds like blowing raspberries or a motor, followed by a man giving instructions on how to use this technique on a didgeridoo followed by a didgeridoo sound. There are ambient sounds in the background like people talking and gentle breeze. The didgeridoo sound is deep, rich, droning and unique. This clip is a tutorial/lesson on how to play a didgeridoo . | 2007-05-28T08:00:21Z | Aboriginal Arts | You can embellish the basic drone sound of the didgeridoo by using your voice. If we liken the basic drone to the canvas for our musical expression, then your voice is the paint you use to colour that sound. We always advise warming up your voice first so that you do not strain yourself. This is a beginner's instroduction and more information can be found on our website http://www.aboriginalarts.co.uk/howtoplaydidgeridoo.html Or, if you're in London why not come and visit us! http://www.aboriginalarts.co.uk | ["Didgeridoo", "Speech"] | ["instrumental", "medium tempo", "male voice talking", "australian accent", "demonstration", "engine sound", "ambient outdoor sounds", "didgeridoo melody", "didgeridoo lesson", "didgeridoo tutorial", "how to play didgeridoo", "people talking", "breeze", "blowing raspberries", "incessant buzz", "vocal vibrations", "deep sound", "rich"] | 7 | VCozi4GDpxQ | 2982 |
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;