musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "raw" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- noisy · 3 ✖
- raw · 3 ✖
- cover 2
- emotional 2
- low quality 2
- arpeggiated acoustic guitar melody 1
- ballad 1
- boisterous 1
- car rev sound 1
- distorted sounds 1
- electronic music 1
- fast tempo 1
- flamenco acoustic guitar melody 1
- harmonizing female vocals 1
- harsh 1
- inferior audio quality 1
- instrumental 1
- intense 1
- loud electric guitar feedback 1
- mellow harp melody 1
- messy 1
- muddy 1
- passionate 1
- passionate muddy male vocal 1
- regional mexican 1
- sharp 1
- subdued song in background 1
- unpleasant 1
- vigorous 1
musiccaps_names (array) 16 ✖
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 | |
Humor: That's how regular guitar sounds with Guitar Hero chords | This music is instrumental. The tempo is medium with a loud , distorted electric guitar harmony. The audio is inferior quality and the sound is raw, loud , unpleasant , boisterous and harsh. There is some noise, like a subdued song playing in the background. | 2009-01-21T04:02:38Z | scooperfield | Is it hard to play Guitar hero with normal guitar? | ["Bass guitar", "Reverberation", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Clatter", "Distortion"] | ["instrumental", "fast tempo", "distorted sounds", "subdued song in background", "harsh", "raw", "inferior audio quality", "vigorous", "boisterous", "noisy", "unpleasant", "electronic music", "intense", "loud electric guitar feedback", "unpleasant", "sharp"] | 7 | c-8SLUH5pp4 | 3673 | |
Las Morenitas - La Despedida (Tonada con arpa) | The low quality recording features a cover of a regional Mexican song and it consists of harmonizing female vocals singing over a mellow harp melody and flamenco acoustic guitar melody. It sounds raw, emotional and passionate. The recording is a bit noisy and there are some car rev noises in the background. | 2013-01-28T22:29:18Z | LasMorenitas Cantoras | Tonada chilena "La despedida" interpretada por Chabelita Fuentes (arpa), Fani Flores (tormento) y Mili Ramirez (guitarra), y que juntas conforman la agrupación de cantoras "Las Morenitas", de San Vicente de Tagua Tagua. Tonada compuesta por Ana Flores Espínola, integrante de Las del Puerto, de la región de Valparaíso. Registro realizado por Diego Barrera el 16 de enero en la comuna en San Vicente de Tagua-Tagua, Región de O'higgins, Chile. Mas información y contactos: Correos: lasmorenitascantoras@gmail.com, dbarrerab@gmail.com Blog: http://lasmorenitascantoras.blogspot.com/ Mas musica en: https://soundcloud.com/las-morenitas-cantoras | ["Harp", "Pizzicato"] | ["low quality", "noisy", "car rev sound", "mellow harp melody", "harmonizing female vocals", "flamenco acoustic guitar melody", "passionate", "raw", "emotional", "cover", "regional mexican"] | 4 | mQ1E8rx2dnI | 4469 |
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;