musiccaps_details (view)
1 row where musiccaps_aspects contains "riser", musiccaps_aspects contains "wood percussion" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Obigies festival 2015 Pulse On Tour | Here we have an electronic dance song that is building up to a crescendo moment. We hear a synth sound that is almost like a combination between a wood percussion instrument and the sound of water droplets. The sound has reverb applied to it, and speeds up towards the end as the song builds up. We hear a riser sound effect as well. | 2015-07-25T21:37:04Z | Pulse café official | Le Pulse sera cette année encore au Festival d'Obigies 2015. RDV le vendredi 14 Août pour retrouver le Pulse On Tour ainsi que pour la première fois, La Bush Réunion en plein air Voir les 2 evenements sur facebook Pulse On Tour https://www.facebook.com/events/859577010800540/ La Bush Reunion https://www.facebook.com/events/777414552375798/ | ["Electronic music", "Music", "Pulse"] | ["electronic dance music", "reverb", "clock tempo", "build-up", "riser", "wood percussion", "water droplet"] | 3 | UCBocxMCdck | 2892 |
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;