musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic dance music", musiccaps_author = 3, musiccaps_names contains "Electronic music" 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 | |
Samantha James - Right Now | Whilst this clip is mellow, it feels like the song has a general sense of budding energy. On the bass guitar we have a simple three note motif repeated across different chords. The singer has a seductive, airy and sultry female voice. In the background, we hear an atmospheric, futuristic pad synth. | 2010-02-21T08:10:47Z | TranceMusicStation | This is a very chill and relaxing song. By Samantha James. Enjoy : ) | ["Electronic music", "Music", "Ambient music"] | ["complex synth arpeggio melodies", "sensual high pitched female vocal", "atmospheric pad synth", "electronic dance music", "mellow", "energy building"] | 3 | nFkmTa4oY84 | 4527 |
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;