musiccaps_details (view)
9 rows where musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "regional mexican"
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- groovy bass · 9 ✖
- regional mexican · 9 ✖
- low quality 6
- energetic 4
- happy 4
- passionate 4
- fun 3
- groovy piano melody 3
- passionate male vocal 3
- accordion melody 2
- flat male vocal 2
- joyful 2
- mono 2
- noisy 2
- punchy kick 2
- wooden percussions 2
- wooden percussive elements 2
- accordion chords 1
- acoustic guitar chords 1
- acoustic rhythm guitar 1
- baby goat bleating sound effect 1
- bagpipe melody 1
- brass melody 1
- bright brass melody 1
- drum roll 1
- emotiona 1
- emotional 1
- flat female vocal 1
- funky piano chords 1
- groovy 1
- guiro percussion 1
- harmonizing male vocals 1
- playback 1
- punchy snare 1
- repetitive acoustic guitar chord 1
- reverberant male vocal 1
- shimmering cymbals 1
- shimmering shakers 1
- simple hi hats 1
- snare roll 1
- solo flute melody 1
- soulful 1
- staccato brass melody 1
- strings melody 1
- tinny metallic percussions 1
- uplifting 1
- vintage 1
- wide acoustic guitar chords 1
- wide acoustic rhythm guitar 1
- wide bouncy wooden percussion 1
youtube_published (date) 9 ✖
- 2006-08-10 1
- 2009-02-08 1
- 2009-04-08 1
- 2009-05-27 1
- 2009-07-28 1
- 2009-09-17 1
- 2010-03-10 1
- 2012-07-23 1
- 2013-03-29 1
musiccaps_names (array) 9 ✖
- Music 8
- Salsa music 4
- Music of Latin America 2
- Ska 2
- Accordion 1
- Afrobeat 1
- Country 1
- Goat 1
- Pop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
La Bamba - twist And Shout - Anderson Palopoli | The Low Quality recording features a regional Mexican song sung by reverberant male vocals over acoustic guitar chords, punchy snare and kick hits, groovy bass and funky piano chords. There is a short snare roll at one point that serves as a transition to the next section of the song. Sounds a bit muffled, as it is a live performance, but also energetic and fun. | 2010-03-10T03:24:15Z | WJSTUDIO2010 | Musica do DVD do Showman Anderson Palopoli | ["Music", "Pop music", "Ska"] | ["low quality", "regional mexican", "reverberant male vocal", "acoustic guitar chords", "groovy bass", "funky piano chords", "simple hi hats", "punchy kick", "punchy snare", "snare roll", "energetic", "fun"] | 4 | 1Q9DXhXMSFI | 269 | |
El Pali - De Agujeritos! | The low quality recording features a regional Mexican song that consists of harmonizing male vocals singing over wide, bouncy wooden percussion, wide acoustic rhythm guitar, groovy bass, punchy kick and strings melody. It sounds passionate, energetic and groovy. | 2009-02-08T22:49:27Z | frager046 | ["Music", "Ska"] | ["regional mexican", "low quality", "wide bouncy wooden percussion", "wide acoustic rhythm guitar", "harmonizing male vocals", "groovy bass", "punchy kick", "strings melody", "passionate", "energetic", "groovy"] | 4 | 3rbWoeUg9yo | 508 | ||
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 | |
Chango - Henry Fiol | The Regional Mexican song features a passionate male vocal singing over guiro percussion, followed by wooden percussion, shimmering cymbals, acoustic rhythm guitar in the left channel of the stereo image and bright brass melody in the right channel. It sounds joyful, happy and passionate. | 2009-09-17T01:58:57Z | Pedro Velazco | ["Music", "Music of Latin America", "Salsa music"] | ["regional mexican", "passionate male vocal", "guiro percussion", "wooden percussions", "shimmering cymbals", "bright brass melody", "groovy bass", "acoustic rhythm guitar", "passionate", "happy", "joyful"] | 4 | UJA5AWbt6HM | 2905 | ||
Hoy yo te pido perdon salsa | The low quality recording features a regional Mexican song that consists of a passionate male vocal singing over brass melody, wooden percussions, tinny metallic percussions, groovy piano melody and groovy bass. It sounds joyful, happy and energetic. | 2009-04-08T06:41:41Z | Edgarcet17 | Salsa romantica hoy yo te pido perdon los chicos de la salsa | ["Music", "Music of Latin America", "Salsa music"] | ["low quality", "regional mexican", "brass melody", "wooden percussions", "tinny metallic percussions", "groovy piano melody", "groovy bass", "passionate male vocal", "joyful", "happy", "energetic"] | 4 | c3T1gWSVp6c | 3676 | |
Parto de un cabra murciana|MrSaravillo|. | The low quality recording features a baby goat bleating sound effects and regional Mexican song, that consists of wide acoustic guitar chords, groovy piano melody, drum roll, bagpipe melody and groovy, playing in the background. It sounds fun and happy and it seems like it is some kind of animal related TV show. | 2013-03-29T17:31:44Z | Mr Saravillo | Os invitamos a ver cómo pare una cabra en la cuadra del Queso de Saravillo. Cabritos para el Queso de Saravillo. www.quesodesaravillo.com info@quesodesaravillo.com | ["Goat", "Music"] | ["baby goat bleating sound effect", "regional mexican", "wide acoustic guitar chords", "groovy bass", "drum roll", "bagpipe melody", "flat female vocal", "groovy piano melody", "fun", "happy", "low quality"] | 4 | hTNKYJ6suII | 4108 | |
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 | |
Sonando - Orlando Valle - Maraca feat: Yumuri , Aramis Galindo, Pio Leyva | The Regional Mexican song features solo flute melody over wooden percussive elements, groovy piano melody and groovy bass. It sounds fun, happy and it is uplifting and energetic - like something you would dance to in some latin bar. | 2012-07-23T20:38:48Z | elchicoplayboy2003 | Orlando Valle Maraca - Sonando - Ahi na' ma Music | ["Music", "Salsa music"] | ["regional mexican", "groovy piano melody", "solo flute melody", "wooden percussive elements", "groovy bass", "fun", "happy", "uplifting", "energetic"] | 4 | y8oi64M0IyE | 5386 |
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;