musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "regional mexican" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- emotional · 5 ✖
- passionate 5
- regional mexican · 5 ✖
- passionate male vocal 4
- low quality 3
- noisy 3
- acoustic rhythm guitar 2
- cover 2
- soulful 2
- accordion melody 1
- addictive brass melody 1
- asphalt sounds 1
- car rev sound 1
- crowd chattering 1
- electric guitar melody 1
- flamenco acoustic guitar melody 1
- groovy bass 1
- groovy bass guitar 1
- harmonizing female vocals 1
- live performance 1
- mellow 1
- mellow harp melody 1
- mono 1
- punchy kick 1
- raw 1
- repetitive acoustic guitar chord 1
- shimmering hi hats 1
- shimmering shakers 1
- shimmering tambourine 1
- smooth bass 1
- soft 1
- soft piano melody 1
- soft synth keys melody 1
musiccaps_names (array) 13 ✖
- Music 3
- Acoustic guitar 1
- Brass instrument 1
- Christmas music 1
- Country 1
- Gospel music 1
- Harp 1
- Pizzicato 1
- Plucked string instrument 1
- Song 1
- Steel guitar, slide guitar 1
- Strum 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Los Lobos - Bella Maria De Mi Alma | The Regional Mexican song features a soft piano melody, rhythm acoustic guitar, smooth bass, addictive brass melody and passionate male vocal singing on top of it. It sounds soft, mellow, passionate and emotional. | 2008-07-30T15:32:28Z | Rumpun Melayu | One of my all time favorites | ["Brass instrument", "Trumpet"] | ["regional mexican", "soft piano melody", "acoustic rhythm guitar", "smooth bass", "passionate male vocal", "addictive brass melody", "soft", "mellow", "emotional", "passionate"] | 4 | 7FHzw4HV75Y | 821 | |
El Rey - George Strait - Twang (George Sings SPANISH) | The Regional Mexican song features a passionate male vocal singing over repetitive acoustic guitar chord and groovy bass, after which there are shimmering shakers and accordion melody playing. It sounds passionate, emotional and soulful. | 2009-07-28T20:20:14Z | Frank Drebbin | That's right, first copy of the song.. and its GRAIT | ["Country", "Music"] | ["regional mexican", "repetitive acoustic guitar chord", "groovy bass", "passionate male vocal", "shimmering shakers", "accordion melody", "passionate", "emotional", "soulful"] | 4 | wt-f7K_suBc | 5291 | |
vicente de montpellier | The low quality recording features a cover of a regional Mexican song and it consists of a passionate male vocalist singing over acoustic rhythm guitar. There are some crowd chattering and asphalt sounds in the background. The recording is noisy, in mono and it sounds passionate and emotional. | 2009-11-09T14:59:52Z | bentana100 | aqui el vicente de montpelier cantando en su barrio monteberou | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["low quality", "mono", "regional mexican", "passionate male vocal", "cover", "noisy", "acoustic rhythm guitar", "crowd chattering", "asphalt sounds", "low quality", "emotional", "passionate"] | 4 | lI8aGjIb8Jg | 4389 | |
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 | |
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;