musiccaps_details (view)
4 rows where musiccaps_aspects contains "arpeggiated acoustic guitar melody", musiccaps_aspects contains "passionate" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- arpeggiated acoustic guitar melody · 4 ✖
- emotional 4
- passionate · 4 ✖
- low quality 3
- cover 2
- mono 2
- noisy 2
- soft 2
- acoustic rhythm guitar chords 1
- ballad 1
- choir 1
- country 1
- dynamic 1
- emotional piano chords 1
- gospel 1
- groovy bass 1
- heartfelt 1
- joyful 1
- mandoline melody 1
- passionate male vocal 1
- rock 1
- shimmering cymbals 1
- smooth bass 1
- soft female vocal 1
- soft hi hats 1
- sustained strings melody 1
musiccaps_names (array) 13 ✖
- Music · 4 ✖
- Country 2
- Acoustic guitar 1
- Bluegrass 1
- Guitar 1
- Mandolin 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Steel guitar, slide guitar 1
- Strum 1
- Tender music 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Going to California (Led Zeppelin) | The low quality recording features a cover of a rock song and it consists of an arpeggiated acoustic guitar melody over which there is a soft female vocal singing. The recording is noisy, in mono and it sounds emotional, soft and passionate. | 2011-01-17T17:58:17Z | iLoveSHELmusic | I haven't been able to get this song out of my head the last few months, so I decided to play with it a little using my friend Wendy's bright little Fender mando. -Eva Keep in touch with SHEL - http://shelmusic.com Facebook: http://on.fb.me/1X7qCMV Twitter: http://bit.ly/1UinXkS instagram: http://bit.ly/1KnWWb0 iTunes: http://apple.co/1fS1zvB | ["Singing", "Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "soft female vocal", "arpeggiated acoustic guitar melody", "noisy", "mono", "passionate", "emotional", "soft", "cover", "rock"] | 4 | 62L5kn1qFeY | 719 | |
Tìm lại bầu trời - hướng dẫn guitarist CHop Bi (phần 2 - chơi mẫu) | The low quality song features a cover of a ballad song and it consists of arpeggiated acoustic guitar melody and passionate male vocal singing over it. The recording is very noisy and in mono, like it was recorded with a phone, but regardless it sounds emotional and passionate. | 2012-03-10T11:35:16Z | thachsungabc | Lớp guitar - CLB nghệ thuật trẻ Hà Nội - link: http://enbac.com/Ha-Noi/Tong-hop/p1174061/Lop-guitar-CLB-nghe-thuat-tre-chieu-sinh-Thong-bao-chuong-trinh-tang-dan-guitar-cho-hoc-vien-moi.html | ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["low quality", "arpeggiated acoustic guitar melody", "noisy", "passionate male vocal", "cover", "ballad", "passionate", "emotional", "mono"] | 4 | cOgNXgF21u4 | 3702 | |
hero of the day - in bluegrass style - iron horse | The low quality recording features a country song that consists of a passionate male vocal singing over arpeggiated acoustic guitar melody, acoustic rhythm guitar chords, mandoline guitar melody and groovy bass. It sounds passionate, joyful and emotional. | 2008-01-06T16:36:25Z | oddis123 | Fade to Bluegrass Tribute to Metallica is available at http://www.cmhrecords.com on iTunes and retailers nationwide. Kirk Hammett also likes this tribute! Check out the interview here: http://youtube.com/watch?v=jdh_0H77Dkc | ["Country", "Music", "Bluegrass"] | ["low quality", "country", "groovy bass", "arpeggiated acoustic guitar melody", "acoustic rhythm guitar chords", "mandoline melody", "passionate", "joyful", "emotional"] | 4 | dzPPmuFUicc | 3832 | |
With All I Am - Hillsong - Lyric Video | The Gospel song features a choir singing over shimmering cymbals, soft hi-hats, smooth bass, arpeggiated acoustic guitar melody, sustained strings melody and emotional piano chords. It sounds passionate and heartfelt as the instrumentation is played dynamically, as the listener can really feel the softness of the instruments. | 2012-09-02T20:10:49Z | Mine Is Jesus | You hold my world in the palm of Your hand, and I am Yours, Forever. http://www.OneTrueGod.ca http://www.MineIsJesus.com Free Worship Music Radio Stream: http://www.TheMastersRadio.com Find us on Facebook: https://www.facebook.com/LoveObeysJesus | ["Music", "Tender music"] | ["smooth bass", "choir", "emotional", "shimmering cymbals", "soft hi hats", "arpeggiated acoustic guitar melody", "sustained strings melody", "emotional piano chords", "gospel", "dynamic", "passionate", "heartfelt", "soft"] | 4 | qZ_-5JplSVg | 4797 |
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;