musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "cover" and musiccaps_aspects contains "pop music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic guitar 2
- cover · 2 ✖
- pop music · 2 ✖
- acoustic drums 1
- amateur recording 1
- bass guitar 1
- calming 1
- easygoing 1
- electric guitar 1
- flute 1
- gentle playing 1
- instrumental 1
- male vocal 1
- mellow 1
- melodic singing 1
- simple tune 1
- slow tempo 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Safe and sound - Taylor Swift flute cover | This is an amateur flute cover of a pop music piece. The flute is playing a gentle melody in the major key. There is a backing track that has a mellow acoustic guitar playing. The atmosphere is calming and easygoing. Although the audio quality is not that great, this piece could be sampled for use in beat-making. | 2012-03-24T11:55:13Z | Melissa.Flutes | Sorry I've been gone so long! But I'm back now making more videos so keep the requests coming!! Love you guys!!! Links: Notes: http://www.melissaflutes.com/notes/ Facebook: https://www.facebook.com/Missmelflute Twitter: https://twitter.com/Missmelflute Instagram: http://instagram.com/missmelflute Vlog channel : http://www.youtube.com/user/Missmelflutevlogs Facebook: http://www.facebook.com/Missmelflute Twitter: https://twitter.com/#!/Missmelflute | ["Wind instrument, woodwind instrument", "Flute"] | ["cover", "amateur recording", "pop music", "instrumental", "flute", "gentle playing", "acoustic guitar", "calming", "easygoing"] | 9 | _IP6zlayY7k | 3460 |
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;