musiccaps_details (view)
4 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "regional mexican"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- happy · 4 ✖
- low quality · 4 ✖
- regional mexican · 4 ✖
- fun 2
- groovy bass 2
- groovy piano melody 2
- baby goat bleating sound effect 1
- bagpipe melody 1
- brass melody 1
- drum roll 1
- emotional 1
- energetic 1
- flat female vocal 1
- flat male vocal 1
- groovy accordion chords 1
- groovy trombone 1
- joyful 1
- marimba 1
- metallic percussive elements 1
- passionate 1
- passionate male vocal 1
- shimmering shakers 1
- shimmering snare 1
- short brass melody 1
- tinny metallic percussions 1
- walking bass guitar 1
- wide acoustic guitar chords 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banda San miguel " volvere" | The low quality recording features a regional Mexican song that consists of a flat male vocal singing over groovy trombone, shimmering shakers, short brass melody and wooden percussive elements. It sounds emotional, passionate and happy. | 2009-04-07T03:20:06Z | HEAD SHOOT | ["Music", "Music of Latin America"] | ["low quality", "short brass melody", "groovy trombone", "shimmering shakers", "regional mexican", "wooden percussive elements", "happy", "emotional", "passionate", "flat male vocal"] | 4 | LYO7_GxyaZc | 2197 | ||
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 | ||
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 |
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;