musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "foreign language" and musiccaps_names contains "Rattle (instrument)" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- foreign language · 3 ✖
- lively 2
- simple 2
- acordion melody 1
- acoustic guitar accompaniment 1
- ambient outdoor sounds 1
- animated acoustic guitar rhythm 1
- bongos 1
- celebratory 1
- cheerful 1
- classic latin songs 1
- congas 1
- earnest singing 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- female singer 1
- female voice 1
- folk song 1
- guiro 1
- hand percussions 1
- happy 1
- latin folk songs 1
- latin music 1
- latin percussions 1
- live recording 1
- low quality recording 1
- male backup 1
- male vocalists 1
- medium tempo 1
- melodic 1
- muddled audio 1
- no percussion 1
- outdoor singing 1
- regional song 1
- shakers 1
- smal hand drum 1
- spanish music 1
- spirited 1
- steady bass line 1
- stringed instrument 1
- tambourine 1
- tambourine used as hand drum 1
- tenor guitar 1
- world music 1
musiccaps_names (array) 8 ✖
- Music 3
- Rattle (instrument) · 3 ✖
- Musical instrument 2
- Bowed string instrument 1
- Christian music 1
- Christmas music 1
- Mandolin 1
- Mantra 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LLEGO DICIEMBRE CON SU ALEGRIA | A female vocalist sings this classic Spanish song. The tempo is medium with a lively accordion harmony, guiro , congas and bongos rhythm, steady bass line, and acoustic guitar accompaniment. The music is simple, light, happy, joyful, cheerful, celebratory and spirited with vocal backup.There are sounds of people cheering in the background. This is a Classic Latin Folk Song. | 2012-12-02T02:33:13Z | max pardo | LLEGO DICIEMBRE | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "cheerful", "happy", "spirited", "celebratory", "simple", "classic latin songs", "lively", "latin folk songs", "latin percussions", "latin music", "spanish music", "guiro", "acordion melody", "foreign language", "world music", "congas", "bongos", "acoustic guitar accompaniment", "steady bass line", "male backup", "muddled audio"] | 7 | wQN7fRaPl2A | 5264 | |
Remigio Fuentes_Joropo y Estribillo con Mónico Márquez | This song is a low quality live recording. This features an older female voice singing the main melody. This is accompanied by a tenor guitar playing two chords in a repeated rhythm. A male voice sings a fill after a line by the female voice. There is no percussion in this song. There are no other instruments. This is a celebration song sung in a foreign language. | 2009-05-25T20:10:09Z | Escucha Joropo | Joropo Tradicional del Oriente Venezolano. Remigio Fuentes popularmente conocido como "Morocho Fuentes" es extraordinario en la ejecución de La Mandolina con un alto dominio en la interpretación del Joropo con Estribillo. Músico del estado Sucre. Posee la gran jocosidad que caracteriza al oriental. Disfruta con mucha humildad de su música y de la compañía de sus coterráneos. Celebramos su amistad | ["Music", "Mandolin", "Musical instrument", "Rattle (instrument)"] | ["live recording", "low quality recording", "foreign language", "female voice", "stringed instrument", "tenor guitar", "no percussion"] | 0 | nb_7c2xPKYA | 4562 | |
SINCHI WAIRA. MANTRA SUMA AMBIWASKA | A group of male vocalists sing this folk song in a foreign language. The tempo is fast with minimalist instruments like a lively acoustic guitar harmony, shakers and tambourine beat;The vocals are energetic, youthful, earnest, cheerful , happy, simple and chirpy. | 2013-04-23T07:17:55Z | Daniel Ortega | Poderoso mantra de sanación. Taita John Muchavisoy, Nicolas Lozada y Cristiam Herrán. Centro de sanación SINCHI WAIRA. | ["Mantra", "Music", "Musical instrument", "Rattle (instrument)", "Bowed string instrument"] | ["male vocalists", "fast tempo", "foreign language", "tambourine", "tambourine used as hand drum", "animated acoustic guitar rhythm", "hand percussions", "shakers", "smal hand drum", "folk song", "regional song", "outdoor singing", "ambient outdoor sounds", "engaging", "lively", "simple", "earnest singing", "enthusiastic", "melodic"] | 7 | qbIPQGY8RRA | 4800 |
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;