musiccaps_details (view)
4 rows where musiccaps_aspects contains "maracas" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- maracas · 4 ✖
- bongos 2
- dance 2
- latin american music 2
- salsa music 2
- acoustic guitar 1
- acoustic piano 1
- backing vocals 1
- bongo drums 1
- brass instruments 1
- complex upbeat bassline 1
- cowbell 1
- dainty female vocal 1
- fiesta 1
- group male vocalists 1
- harmonies 1
- jam 1
- latin music 1
- latin percussion 1
- male vocals 1
- male voice singing 1
- mid range 1
- party 1
- passionate tenor male vocal 1
- piano 1
- rhythmic latin percussion 1
- salsa 1
- spanish 1
- spanish singing 1
- trumpet 1
- upbeat 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Music 4
- Music of Latin America · 4 ✖
- Salsa music 3
- Maraca 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joropo Maracas jamming #2 | This is an amateur recording of a percussive jam over a backing track that has the acoustic guitar and hollering male vocals singing in the Spanish language, iconic features of latin folk music. Two pairs of maracas are being played to create the rhythm. | 2013-05-22T02:59:20Z | tonydven | Twelve year old Edgar Sebastian Bermejo of Bogota, Colombia shows how to play joropo maracas with real style. Little Johan is learning too. | ["Music", "Music of Latin America", "Maraca"] | ["maracas", "latin percussion", "jam", "male vocals", "spanish", "acoustic guitar", "latin music"] | 9 | bpKbpKZB0Q0 | 3653 | |
mezcla de salsa romantica 2012-2013 | This song is a salsa song, with various layers of upbeat percussion which are suitable for dancing. There are bongo drums and maracas, played at a medium to high tempo. The vocalist has a dainty voice and sings in almost a high pitched voice in almost a whisper. There are brass instruments, especially trumpet and the song would be suitable for a salsa party. | 2013-04-25T05:38:43Z | Dickson Villarroel | para los amantes de la salsa, espero que les guste... | ["Music", "Music of Latin America", "Salsa music"] | ["salsa music", "latin american music", "dance", "rhythmic latin percussion", "brass instruments", "trumpet", "bongo drums", "maracas", "piano", "dainty female vocal"] | 3 | gRGiTueWUVI | 4029 | |
angel bonne - Si faltas tu - letra | This salsa song contains percussive elements as maracas,cowbell and bongos creating a typical salsa rhythm spread across both sides of the speakers. An e-bass is playing a complex walking bassline. An acoustic piano is playing a melody up and down the scales along with backing vocals singing in harmony as a countermelody to the male lead voice singing in the midrange. This song may be playing in a latin bar. | 2010-02-11T04:19:51Z | Beto Mina | para los verdaderos amantes de la musica cubana, una excelente cancion de un icono de la timba cubana. espero que la disfruten cancion: Si faltas tú interprete: Angel Bonne album: Pa' decir lo que siento año: 1995 | ["Music", "Music of Latin America", "Salsa music"] | ["salsa", "cowbell", "bongos", "maracas", "acoustic piano", "backing vocals", "male voice singing", "mid range", "uptempo"] | 6 | gsEk62Efbh4 | 4063 | |
amo mi soledad - la rebelion | This is a Latin American dance song in the salsa style. We hear layers of upbeat, rhythmic percussion that's suitable for dancing. Maracas, bongos, and a groovy and complex bassline coupled with a melodic instrument make for a vibrant and fun party/dance song. | 2010-09-14T00:59:18Z | salsasanta | bajo la dirección de fernando martinez nace en 1986 en medellin, colombia orquesta la rebelión, aqui tenemos su mayor exito en la voz de marco vinicio. | ["Music", "Music of Latin America", "Salsa music"] | ["latin american music", "spanish singing", "salsa music", "dance", "fiesta", "party", "upbeat", "passionate tenor male vocal", "group male vocalists", "harmonies", "complex upbeat bassline", "maracas", "bongos"] | 3 | vByuZEzCZJg | 5162 |
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;