musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "cover" and musiccaps_aspects contains "gentle playing" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- cover · 3 ✖
- gentle playing · 3 ✖
- acoustic guitar 2
- easygoing 2
- acoustic 1
- alternative rock 1
- amateur recording 1
- calming 1
- clean sound 1
- dreamy 1
- electric guitar 1
- flute 1
- hazy 1
- instrumental 1
- mellow 1
- pop music 1
- reverb 1
- rock music 1
- sentimental 1
- slow tempo 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Supper Moment - 幸福之歌 guitar 結他 cover by Eric Lo | This is a cover of an alternative rock music piece. There is an electric guitar with a clean sound and a lot of reverb playing a gentle arpeggio. The atmosphere is dreamy and hazy. This piece could be used in the background of a tutorial video. | 2015-06-07T07:58:15Z | Eric Lo Guitar | My tabs : https://www.mymusicsheet.com/ericmusic1437/23233 Buy all my other tabs :https://www.mymusicsheet.com/ericmusic1437/ Guitar lesson / Buy my tabs / tab arrangement request : https://ericmusic1437.wixsite.com/guitar Homepage: https://ericmusic1437.wixsite.com/guitar My Tabs : https://www.mymusicsheet.com/ericmusic1437 Facebook Fanspage : https://www.facebook.com/ericlomusic Personal Facebook: http://www.facebook.com/ericmusic1437 Youtube: http://www.youtube.com/user/ericmusic1437 Ig: https://www.instagram.com/ericmusic1437/ E-mail: ericmusic1437@gmail.com Wtsapp : 852-98633697 Contact details : Mobile : 852-98633697 ( welcome whatsapp ) E-mail : ericmusic1437@gmail.com | ["Guitar", "Music", "Musical instrument", "Harmonic", "Plucked string instrument", "Inside, small room"] | ["cover", "alternative rock", "electric guitar", "clean sound", "reverb", "gentle playing", "dreamy", "hazy"] | 9 | MS8VU468rKk | 2268 | |
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 | |
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 |
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;