musiccaps_details (view)
103 rows where search matches "guitar" and musiccaps_names contains "Acoustic guitar" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_names (array) >30 ✖
- Acoustic guitar · 103 ✖
- Music 103
- Plucked string instrument 84
- Guitar 78
- Musical instrument 67
- Strum 47
- Steel guitar, slide guitar 21
- Flamenco 16
- Mandolin 13
- Speech 12
- Blues 10
- Country 10
- Bass guitar 9
- Bluegrass 8
- Electronic tuner 7
- Electric guitar 6
- Tapping (guitar technique) 6
- Chorus effect 4
- Singing 4
- Ukulele 4
- Banjo 3
- Folk music 3
- Jazz 3
- Tender music 3
- Bowed string instrument 2
- Effects unit 2
- Happy music 2
- Inside, small room 2
- Music for children 2
- Music of Latin America 2
- …
musiccaps_aspects (array) >30 ✖
- acoustic guitar 33
- low quality 33
- noisy 24
- instrumental 23
- emotional 19
- passionate 16
- amateur recording 15
- mono 14
- medium tempo 11
- slow tempo 10
- cover 8
- easygoing 8
- mellow 7
- no other instruments 7
- flamenco 6
- male voice 6
- no singer 6
- relaxing 6
- soft 6
- acoustic rhythm guitar 5
- blues 5
- fast tempo 5
- live performance 5
- sad 5
- soothing 5
- tutorial 5
- acoustic guitar accompaniment 4
- calming 4
- electric guitar 4
- fingerstyle 4
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ライオンハート SMAP cover, Gibson Humming bird ( ギター 弾き語り スマップカバー ギブソン ハミングバード) | Someone is strumming an acoustic guitar while a male voice is singing along. This may be playing at a bonfire. | 2015-05-31T09:04:29Z | MA channel | ライオンハート SMAP cover 8曲目のアップとなります!是非!聞いてください。 | ["Blues", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] | ["singer-songwriter/pop", "acoustic guitar", "male voice singing", "medium to uptempo", "amateur recording"] | 6 | em7akjDUsWk | 3895 | |
林宥嘉 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 | |
歌うたいのバラッド(結婚式披露宴) | The low quality recording features a soft rock song sung by passionate male vocals followed by muffled acoustic rhythm guitar. It sounds emotional and like it was recorded with a phone. | 2008-09-13T01:43:42Z | うたいたいのばらっと | 自分の結婚式で歌うたいのバラッドを歌うのが夢だったんで思い出としてアップしてみました。 多少間違えてますがあたたかい目で見てやってください。 | ["Guitar", "Acoustic guitar", "Music", "/t/dd00003"] | ["low quality", "soft rock", "passionate male vocal", "muffled acoustic rhythm guitar", "emotional"] | 4 | rh0vBy1JD8A | 4895 |
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;