musiccaps_details (view)
1 row where musiccaps_aspects contains "reverb" and musiccaps_names contains "Pulse" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 7 ✖
- build-up 1
- clock tempo 1
- electronic dance music 1
- reverb · 1 ✖
- riser 1
- water droplet 1
- wood percussion 1
musiccaps_names (array) 3 ✖
- Electronic music 1
- Music 1
- Pulse · 1 ✖
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;