musiccaps_details (view)
1 row where musiccaps_aspects contains "deep bass sound", musiccaps_aspects contains "low pitch instrument" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
Didgeridoo Dubstep | Raymond Ashley | This tribal music is played on a didgeridoo. It is played by vibrating the lips over the instrument using breathing techniques. The song has a continuous droning sound and inter spread with low pitch bass sounds. There are no voices in this song. This audio can be used in a movie where the protagonist is trapped in a forest. | 2010-07-30T15:27:04Z | ididjaustralia | Didgeridoo dubstep by Raymond Ashley. Raymond is a superb practitioner of the didgeridoo. He has international performance experience and has also been recorded in the studio for commercial releases. Here Raymond starts with the Mimih song and plays the didgeridoo in the overtone-absent style particular to parts of western Arnhem Land and elsewhere. -------- -------- ------- -------- -------- ------- -------- -------- Follow and like us on Facebook, one standout didgeridoo given away each month until the end of 2014 simply for being awesome and for watching our videos, 7 superlative didgeridoos to give away in 2014 :) https://www.facebook.com/ididjaustralia Subscribe to the iDIDJ channel: http://bit.ly/1qEvCHO | ["Didgeridoo", "Music"] | ["tribal music", "didgeridoo", "wind instrument", "droning sound", "deep bass sound", "played with vibrating lips", "low pitch instrument"] | 0 | 1yWGmdevTuM | 321 |
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;