musiccaps_details (view)
1 row where musiccaps_aspects contains "haunting sound", musiccaps_aspects contains "waterfall", musiccaps_aspects contains "woodwind" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Adèle & Zalem, Didgeridoo Duet | This song is an instrumental. The tempo is medium with the melody of an oboe and percussion rhythm like the bongos and the sound of a waterfall and faint female vocals in the background.the sound quality of the song is inferior and the sounds are distorted and muffled This song is an instrumental pop. | 2013-02-14T16:46:07Z | Zalem Delarbre | To listen & order our albums: ► CD BABY : https://store.cdbaby.com/Artist/AdeleZalem ► SPOTiFY: https://open.spotify.com/artist/1kivdQIreUXoEYFwEuf8FP ► DEEZER: https://www.deezer.com/fr/artist/5203567 ► iTUNES: https://music.apple.com/fr/artist/678921159 facebook : http://www.facebook.com/adelezalem booking : adelezalem@gmail.com Learn Didgeridoo Online with Zalem https://www.didgexploration.com Didgeridoo from Didgelement : http://www.didgelement.com filmed & edited by thewill, http://www.williambelle.com Recording, mix & mastering by Zalem and Thibault Cano-Bruyère | ["Didgeridoo", "Music"] | ["instrumental", "medium tempo", "oboe", "woodwind", "distant female vocals", "waterfall", "congas", "bongos", "oboist", "congos", "sound of waterfall", "inferior quality sound recording", "muddled recording", "haunting sound", "enigmatic sound", "orchestral instrument"] | 7 | oXBGZoBYaLY | 4638 |
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;