musiccaps_details (view)
5 rows where musiccaps_aspects contains "fun" and musiccaps_aspects contains "regional mexican" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- fun · 5 ✖
- regional mexican · 5 ✖
- low quality 4
- groovy bass 3
- happy 3
- energetic 2
- groovy piano melody 2
- acoustic guitar chords 1
- baby goat bleating sound effect 1
- bagpipe melody 1
- drum roll 1
- exotic 1
- flat female vocal 1
- funky piano chords 1
- groovy accordion chords 1
- groovy piano chord progression 1
- marimba 1
- metallic percussive elements 1
- punchy kick 1
- punchy snare 1
- reverberant make vocal 1
- reverberant male vocal 1
- shimmering shakers 1
- shimmering snare 1
- simple hi hats 1
- smooth bass 1
- snare roll 1
- solo flute melody 1
- traditional 1
- tropical 1
- uplifting 1
- walking bass guitar 1
- wide acoustic guitar chords 1
- wide brass section 1
- wide groovy percussive elements 1
- wooden percussive elements 1
musiccaps_names (array) 8 ✖
- Music 5
- Salsa music 2
- Goat 1
- Marimba, xylophone 1
- Musical instrument 1
- Pop music 1
- Rattle (instrument) 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
reyna chalchiteca en ojo de agua aguacatan | The low quality recording features a marimba melody, groovy accordion chords and walking bass guitar, followed by metallic percussive elements and shimmering snare. It sounds fun and happy, even though it is probably recorded via phone. | 2014-03-29T16:08:05Z | francisco alcon | ["Music", "Musical instrument", "Rattle (instrument)", "Marimba, xylophone"] | ["low quality", "regional mexican", "marimba", "metallic percussive elements", "walking bass guitar", "shimmering snare", "groovy accordion chords", "happy", "fun"] | 4 | a-3cZREZh3k | 3510 | ||
Como has llegado a mi vida | The low quality recording features a regional Mexican song that consists of a reverberant male vocal singing over widely spread groovy piano chord progression, brass section, shimmering shakers, groovy percussive elements and smooth bass. It sounds tropical, exotic and fun, like something you would hear at latin weddings. | 2011-11-16T17:34:58Z | losecontroldiscplay1 | ["Music", "Salsa music"] | ["low quality", "groovy piano chord progression", "wide brass section", "shimmering shakers", "wide groovy percussive elements", "smooth bass", "reverberant make vocal", "traditional", "regional mexican", "tropical", "exotic", "fun"] | 4 | 7y9RfZXJZsk | 892 |
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;