musiccaps_details (view)
7 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "slow tempo" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- acoustic guitar · 7 ✖
- slow tempo · 7 ✖
- acoustic drums 4
- bass guitar 4
- easygoing 4
- mellow 4
- melodic singing 4
- electric guitar 3
- male vocal 3
- pop music 3
- ballad 2
- cover 2
- emotional 2
- fiddle 2
- gentle playing 2
- sentimental 2
- simple tune 2
- acoustic 1
- alternative rock 1
- american folk music 1
- banjo 1
- country 1
- country music 1
- cozy 1
- crowd singing 1
- female vocal 1
- folk singing 1
- gentle 1
- korean indie rock 1
- live performance 1
- longing 1
- male back vocal 1
- melancholic 1
- rock music 1
- spanish 1
- teen female vocal 1
musiccaps_names (array) 12 ✖
- Music 5
- Singing 3
- Independent music 2
- Song 2
- A capella 1
- Acoustic guitar 1
- Bluegrass 1
- Country 1
- Flamenco 1
- Happy music 1
- Plucked string instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
Dean Brody - Wildflower | This is a country music piece. There is a fiddle playing the main melody. The acoustic guitar and the electric guitar are playing gently in the background. The song has a slow tempo. The atmosphere is sentimental. This piece can be used in the soundtrack of an American drama movie, especially during the scenes where the feeling of longing is emphasized. | 2010-03-25T14:34:30Z | Dean Brody | ["Country"] | ["country music", "fiddle", "acoustic guitar", "electric guitar", "gentle playing", "slow tempo", "easygoing", "sentimental", "longing"] | 9 | -O9mnfC61Ac | 40 | ||
Invencible/Music Club de Vázquez Sounds | This is a live performance of a pop music piece. There is a teenage female vocalist singing melodically in the Spanish language. An acoustic guitar plays the main tune while there is a slow tempo acoustic drum beat in the rhythmic background. The spectators are joining the song at a volume that is sometimes higher than the song itself and it creates an irritating aura. | 2014-09-29T02:14:40Z | Vázquez Sounds Support Mexico | Nuestras redes sociales: Facebook: http://bitly.com/1rW5VpV Youtube: http://bitly.com/1vpC2gw Instagram: http://bit.ly/1oHYlJB Twitter: http://bitly.com/1yEsrar Ask: http://bit.ly/1CKk6AM {Grabado por nosotros} Club de fans oficial. Vazquez Sounds en vivo (Live) | ["Singing", "Music", "Song", "A capella"] | ["live performance", "pop music", "ballad", "teen female vocal", "melodic singing", "acoustic guitar", "acoustic drums", "crowd singing", "emotional", "slow tempo", "spanish"] | 9 | BaMBwXQwK3g | 1263 | |
insomnia female version (acoustic) | This is a pop music piece. There is a female vocalist singing melodically in the lead. The acoustic guitar is playing the main tune while the bass guitar is playing in the background. The rhythm is provided by a slow tempo acoustic drum beat. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie where the characters are missing each other at night. | 2010-01-21T06:26:22Z | drauf | insomnia female version | ["Music", "Happy music"] | ["pop music", "ballad", "female vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "slow tempo", "mellow", "emotional"] | 9 | bxF2vxTzlvo | 3666 | |
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 | |
Hotel California -Guitar Harmonica solo | This is an acoustic cover of a rock music piece. There is an acoustic guitar playing a gentle melody. The piece has a slow tempo. The atmosphere is sentimental. This piece can be included in the soundtrack of a romantic movie. | 2014-08-22T20:06:06Z | Todd Emrick | I do not make money off this song or Youtube. UMPG owns the publishing rights. Please do not take this video down. "Hotel California" is the title track from the Eagles' album of the same name and was released as a single in February 1977.[6] Writing credits for the song are shared by Don Felder (music), Don Henley, and Glenn Frey (lyrics). The Eagles' original recording of the song features Henley singing the lead vocals and concludes with an extended section of electric guitar interplay between Felder and Joe Walsh. | ["Flamenco", "Acoustic guitar", "Music", "Plucked string instrument"] | ["cover", "acoustic", "rock music", "acoustic guitar", "gentle playing", "slow tempo", "mellow", "easygoing", "sentimental"] | 9 | hbCaMcbT8to | 4120 | |
RALPH STANLEY WITH CJ THE DJ "WHITE DOVE" | This is an American folk music piece. There is a male vocal singing melodically as the lead and there is a male back vocal accompanying the lead in different harmonies. The melody is composed of a rich amalgam of chordophones such as the fiddle, the acoustic guitar, the bass guitar and the banjo. The atmosphere is easygoing but melancholic. This piece could be playing in the background at an American diner or a pub. It could also work well in the soundtrack of a movie taking place in rural USA. | 2011-02-01T02:16:16Z | elizabethmoore1980 | RALPH STANLEY WITH CJ THE DJ FROM NEW CD "MUSIC AMONG FRIENDS" WHITE DOVE | ["Music", "Bluegrass"] | ["american folk music", "country", "male vocal", "male back vocal", "folk singing", "fiddle", "acoustic guitar", "banjo", "bass guitar", "cozy", "easygoing", "melancholic", "slow tempo"] | 9 | wT2Y0DCq5LI | 5270 |
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;