musiccaps_details (view)
6 rows where musiccaps_aspects contains "noisy" and musiccaps_aspects contains "regional mexican"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- low quality 6
- noisy · 6 ✖
- regional mexican · 6 ✖
- passionate 5
- emotional 4
- mono 3
- cover 2
- flat male vocal 2
- groovy bass 2
- passionate male vocal 2
- accordion chords 1
- accordion melody 1
- acoustic rhythm guitar 1
- asphalt sounds 1
- car rev sound 1
- crowd chattering 1
- electric guitar melody 1
- emotiona 1
- flamenco acoustic guitar melody 1
- groovy bass guitar 1
- groovy trombone 1
- harmonizing female vocals 1
- live performance 1
- mellow harp melody 1
- passionate reverberant male vocal 1
- playback 1
- punchy kick 1
- raw 1
- shimmering hi hats 1
- shimmering tambourine 1
- short brass melody 1
- soft synth keys melody 1
- soulful 1
- staccato brass melody 1
- vintage 1
- wooden percussive elements 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jorge Luis Cabrera - Se Acabaron Las Caricias | The low quality recording features a regional Mexican song that consists of a passionate male vocal singing over groovy trombone and short brass melody. It sounds passionate and emotional, even though the recording is noisy. | 2012-05-24T23:15:53Z | Jorge Luis Cabrera Official | Hola amigos, su amigo Jorge Luis Cabrera saludandolos desde Culiacan Sinaloa. Este canal lo diseñe para compartir mi vida personal y musical al igual que mi musica y mis canciones. Espero les guste. Gracias por su apoyo en toda mi carrera artistica. Saludos. Sigueme en Instagram: https://www.instagram.com/jorgeluiscabreraoficial/?hl=en #JorgeLuisCabrera #BandaSinaloense #Culiacan #Norteno #MusicaRomantica #LaChicadeMisSuenos #Compositor | ["Folk music", "Music"] | ["low quality", "regional mexican", "groovy trombone", "short brass melody", "passionate reverberant male vocal", "passionate", "emotional", "noisy"] | 4 | 8Z5xnSxUmGE | 929 | |
Salsa Yuri Buenaventura. | The low quality recording features a regional Mexican song that contains wooden percussive elements, groovy bass and staccato brass melody over which flat male vocalists sing. It sounds vintage, as the recording is very noisy and in mono. | 2006-08-10T01:30:53Z | Latino Grooves Dance Studio | Yuri Buenaventura - The Best of Yuri Buenaventura In the late 90s, a Colombian singer took the French charts by storm, his name was Yuri Buenaventura. www.latinogrooves.com.au | ["Afrobeat", "Music", "Salsa music"] | ["low quality", "flat male vocal", "wooden percussive elements", "staccato brass melody", "groovy bass", "mono", "noisy", "regional mexican", "vintage"] | 4 | B_kAtTBUDIA | 1260 | |
Julio Chaidez Hombre de Negocios | The low quality recording features an accordion melody played over regional Mexican playback that consists of accordion chords, groovy bass and flat male vocal singing over it. The recording is in mono, noisy and it sounds emotional and passionate. | 2009-05-27T05:57:03Z | jgg171990 | Tono de Sib | ["Accordion"] | ["regional mexican", "low quality", "mono", "noisy", "playback", "groovy bass", "accordion chords", "flat male vocal", "accordion melody", "passionate", "emotiona"] | 4 | FLJPxFCPeDY | 1638 | |
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 | |
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 | |
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;