musiccaps_details (view)

1 row where musiccaps_aspects contains "rich", musiccaps_author = 7, musiccaps_names contains "Didgeridoo" and musiccaps_names contains "Speech"

✎ View and edit SQL

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
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

CSV options: 

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;