musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "male vocal" and musiccaps_aspects contains "slow tempo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ROSE N FLY after MV (korea indie band) | This is a Korean indie rock piece. There is a male vocalist in the lead singing melodically. The main tune is being played by an acoustic guitar with an electric guitar and a bass guitar backing. There is a 4/4 slow tempo acoustic drum beat playing in the rhythmic background. The atmosphere is easygoing. This piece could be used in the soundtrack of a drama movie or TV series that takes place in Korea. | 2010-12-19T12:14:19Z | ROSE N FLY LAUS DEO | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["korean indie rock", "alternative rock", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "gentle", "mellow", "easygoing", "simple tune", "slow tempo"] | 9 | cnvmLwFZr28 | 3742 | ||
The Weeknd - The Hills [Cover by Twenty One Two] | This is a cover of a pop music piece. There is a male vocalist singing melodically. The melody is being played by the acoustic guitar and the electric guitar while the bass guitar is playing in the background. The rhythm is provided by a slow tempo acoustic drum beat. There is a mellow atmosphere in this piece. It could be used in the soundtrack of a drama TV series. | 2015-12-10T20:23:27Z | Twenty One Two | Download/Stream our cover of 'The Hills' by The Weeknd: iTunes: http://full.sc/1nbaTyR Spotify: http://full.sc/1OcaZ20 Loudr: http://full.sc/1nbaZXr The Hills Have Eyes... Hope you like our cover of The Weeknd's "The Hills" :) If you wanna see more videos from us in the future make sure to subscribe: http://full.sc/1iTcqQ4 Please help us share our cover videos with the world by posting them on your Facebook, Twitter, Tumblr etc. Every share helps us immensely, Thanks! Follow us on twitter, instagram, tumblr and facebook to keep up with all our shenanigans! https://twitter.com/twentyonetwose http://instagram.com/twentyonetwose http://twentyonetwose.tumblr.com https://www.facebook.com/twentyonetwose "The Hills" - originally by The Weeknd Written by: Ahmad Balshe, Carlo Montagnese, Emmanuel Nickerson, Abel Tesfaye Published by: The Weeknd XO, Inc., Manufactured and Marketed by Republic Records, a Division of UMG Recordings, Inc | ["Singing", "Independent music"] | ["cover", "pop music", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "mellow", "simple tune", "slow tempo"] | 9 | gkMbHlNAFig | 4052 |
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;