musiccaps_details (view)
5 rows where musiccaps_aspects contains "arpeggiated acoustic guitar melody", musiccaps_author = 4 and musiccaps_names contains "Plucked string instrument"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 林宥嘉 Yoga Lin [ 寵兒 The Loved Ones ] Music Video (電影「我的蛋男情人」主題曲) 陳星合 Acoustic Cover | The low quality recording features a cover of a ballad song that consists of passionate, muddy male vocal singing over arpeggiated acoustic guitar melody. It sounds noisy, muddy and messy, as the frequencies are clashing, but it is also emotional and raw. | 2016-10-01T13:18:56Z | 我是星合HE's channel | 林宥嘉 [ 寵兒 The Loved Ones ] Acoustic Cover 吉他翻唱改編 ►陳星合Facebook粉絲頁 : https://www.facebook.com/shinghemusic ►Instagram : https://www.instagram.com/shinghe0807/ →歡迎追蹤與訂閱← 每週三都會有新的音樂作品哦！！！ 希望你們會喜歡這次的翻唱 :) | ["Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument", "Tender music"] | ["low quality", "passionate muddy male vocal", "arpeggiated acoustic guitar melody", "noisy", "muddy", "cover", "emotional", "ballad", "raw", "messy"] | 4 | -8cgbhIR_pw | 21 | |
| How to play romanza (romance) classical guitar lessons with Gary | The low quality recording features a guitar tutorial that consists of a flat male vocal talking and counting the rhythm over an arpeggiated acoustic guitar melody. The recording is mono and noisy. | 2008-01-09T06:25:04Z | Taffypro | TO HEAR THIS WITHOUT THE ANNOYING ACCENT AND AT FULL QUALITY PLEASE VISIT: http://taffyproductions.com/ How to play romance classical guitar lesson, Guitar lessons, classical guitar lessons, How to play, beginning guitar lesson How to play romanza romanza on the guitar | ["Guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["low quality", "flat male vocal", "arpeggiated acoustic guitar melody", "tutorial", "noisy", "mono"] | 4 | 0K-zyeLuKho | 146 | |
| 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 | |
| The Entertainer (S.Joplin) Advanced Slide Guitar Version - Marc Athlan | The low quality recording features a cover of a ragtime song and it consists of arpeggiated acoustic guitar melody. The recording is noisy, but it sounds happy and fun regardless. | 2014-07-27T15:55:10Z | Marc Athlan | This is an attempt to adapt the famous Scott Joplin tune (whole version) on slide guitar. If it has been said that it's a challenge to play this song on guitar, it's even more challenging on slide guitar ! I tried to be as close as possible to the original version. Played on resonator guitar with Diamond Bottleneck (The BEST in the world !). Thanks to Nathalie Athlan, Ian McWee and others at Diamond Bottlenecks.com. Thanks to Keni Lee Burgess for having inspired me with his video (https://youtu.be/X0VL_js9sWs) to do my version of this tune. Thanks for watching ! | ["Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "cover", "arpeggiated acoustic guitar melody", "noisy", "happy", "fun", "ragtime"] | 4 | iCIa_pmLDqs | 4168 | |
| Stairway to Heaven - [Led Zeppelin] | The low quality recording features an arpeggiated acoustic guitar melody and some cars passing by sounds in the background. It sounds heartfelt, emotional and sad. The recording is noisy. | 2006-12-01T13:01:34Z | Ted Kim | I think best of Led Zeppelin | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "car passing by", "arpeggiated acoustic guitar melody", "emotional", "sad", "heartfelt", "noisy"] | 4 | j-TVVmVmygg | 4227 |
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;