musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "regional mexican" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 37 ✖
- groovy bass · 5 ✖
- regional mexican · 5 ✖
- low quality 3
- passionate 3
- energetic 2
- fun 2
- happy 2
- passionate male vocal 2
- punchy kick 2
- accordion melody 1
- acoustic guitar chords 1
- acoustic rhythm guitar 1
- baby goat bleating sound effect 1
- bagpipe melody 1
- bright brass melody 1
- drum roll 1
- emotional 1
- flat female vocal 1
- funky piano chords 1
- groovy 1
- groovy piano melody 1
- guiro percussion 1
- harmonizing male vocals 1
- joyful 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
- soulful 1
- strings melody 1
- wide acoustic guitar chords 1
- wide acoustic rhythm guitar 1
- wide bouncy wooden percussion 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
- Music 5
- Ska 2
- Country 1
- Goat 1
- Music of Latin America 1
- Pop music 1
- Salsa 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 | ||
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 | ||
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 |
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;