musiccaps_details (view)
1 row where musiccaps_aspects contains "didgeridoo", musiccaps_aspects contains "electronic" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Electronically Modified Didgeridoo Kyle Evans | This piece contains a modified didgeridoo sound. Sound effects were made to create an atmosphere that is unnatural and ominous. This sound could be used in an outer space dystopian sci-fi movie. It could also be used in a video game that involves robots/automated mechanisms. | 2009-11-05T08:24:51Z | Kyle Evans | Electronically Modified Didgeridoo Kyle Evans www.kyleellisevans.com/ I created this instrument to experiment in the combination of the organic sound qualities of a didgeridoo with the advanced signal processing capabilities of modern computer programming and sound synthesis. This custom built didgeridoo features externally mounted modules that allow the performer to process and manipulate the sound of the instrument in real time. All control data is transmitted wirelessly via blue tooth and is controlling several audio processes created in a custom-built software environment. If you have any questions about the instrument please feel free to ask. | ["Didgeridoo", "Music", "Musical instrument"] | ["didgeridoo", "instrumental", "sound effects", "ominous", "robotic", "electronic"] | 9 | d1VB1vA-UsI | 3756 |
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;