musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "muddy", musiccaps_aspects contains "noisy" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 3
- muddy · 3 ✖
- noisy · 3 ✖
- messy 2
- addictive 1
- aggressive strumming 1
- arpeggiated acoustic guitar melody 1
- ballad 1
- boomy 1
- boomy steel guitar melody 1
- cover 1
- emotional 1
- groovy bass guitar 1
- mono 1
- passionate muddy male vocal 1
- playback drums instrumental 1
- raw 1
- reverberant 1
musiccaps_names (array) 11 ✖
- Music 3
- Musical instrument · 3 ✖
- Plucked string instrument 2
- Acoustic guitar 1
- Bass guitar 1
- Blues 1
- Guitar 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 |
---|---|---|---|---|---|---|---|---|---|---|
林宥嘉 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 | |
Anatole, true maestro of the balalaika! | The low quality recording a boomy steel guitar being aggressively strummed. The recording is noisy, reverberant and it sounds muddy, but regardless, the melody is addictive. | 2006-12-01T23:55:55Z | HuwTube | A demonstration of some classic tunes on the Russian instrument, by a man who really knows what he's doing. | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "boomy steel guitar melody", "aggressive strumming", "reverberant", "noisy", "muddy", "addictive"] | 4 | HU7oqkJeItQ | 1806 | |
VALDECI MOURA(Groove soul) IVAN LOPES (PG) slap bass | The low quality recording features a groovy bass guitar played over drums instrumental playback. It sounds muddy, messy and boomy, as the frequencies are clashing with each other. The recording is noisy and in mono. | 2008-07-06T18:52:21Z | valdecimoura | VALDECI MOURA(Groove soul) IVAN LOPES (PG) slap bass | ["Blues", "Bass guitar", "Music", "Musical instrument"] | ["mono", "low quality", "groovy bass guitar", "boomy", "messy", "muddy", "playback drums instrumental", "noisy"] | 4 | ye6O_T8YuHQ | 5424 |
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;