musiccaps_details (view)
1 row where musiccaps_aspects contains "claps", musiccaps_aspects contains "happy" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- acoustic drums 1
- bass guitar 1
- claps · 1 ✖
- dance 1
- easygoing 1
- happy · 1 ✖
- jovial 1
- keyboard 1
- male vocal 1
- melodic 1
- pop music 1
- uplifting 1
musiccaps_names (array) 4 ✖
- Afrobeat 1
- Music 1
- Music of Africa 1
- Pop music · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Famous Ramos: Audition for Pharrell Music Video - ("Happy" - Pharrell) | This is a famous pop music piece played over a dance audition video. The male vocalist is singing melodically in one track at a medium pitch and singing the melody at a high pitch in another track. The melody is supported by a bass guitar playing a groovy bassline. A catchy acoustic drum beat and offbeat claps hold the rhythmic background. The atmosphere is jovial and very danceable. This piece could be used in a myriad of different ways from dance videos, online content, sports venues etc. | 2013-09-13T23:39:49Z | Famous Ramos | A teaser to our upcoming video to "Lose Yourself to Dance!" COMING SOON! This was my audition for the casting of Pharrell's video. I booked the job! http://youtu.be/rQD9EBCwlQc?t=56m3s :) It's all improve and a one take performance. Hope you enjoy as much as I did dancing! /Famous | ["Afrobeat", "Music of Africa", "Music", "Pop music"] | ["pop music", "male vocal", "bass guitar", "keyboard", "acoustic drums", "claps", "melodic", "happy", "jovial", "uplifting", "easygoing", "dance"] | 9 | pZgzjL5wbtA | 4721 |
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;