musiccaps_details (view)
2 rows where musiccaps_aspects contains "live recording" and musiccaps_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- live recording · 2 ✖
- accordeon 1
- female voice 1
- foreign language 1
- joyful 1
- latin folk 1
- lively 1
- low quality recording 1
- male vocal 1
- maracas 1
- no percussion 1
- off-key singing 1
- stringed instrument 1
- tenor guitar 1
- ukulele 1
- venezuelan 1
- vibrant 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lucrecio García_Golpe de Arpa con Estribillo | This is a latin folk piece performed at a home setting. There is a male vocalist singing off-key in a shout-like manner. An accordion and a ukulele are providing the melodic background for the piece. A pair of maracas is being played for the rhythmic background. The piece has a joyful atmosphere. The instrumentals can be used for sampling to put them in a beat. | 2009-05-14T23:55:12Z | Escucha Joropo | Forma de Joropo Tradicional del oriente venezolano la cual tiene similitud con la del Joropo Corrío Llanero. Su ciclo armónico es Tónica-Subdominante-Dominante-Tónica (I-IV-V7-I). Tiene salida a Estribillo como es común en el Joropo Oriental. Se caracteriza por ser muy vivaz lo que emociona a cantadores y bailadores. En esta ocasión Lucrecio nos demuestra su dominio en este tipo de acompañamiento logrando la inspiración en el Canto tanto de Mónico Márquez como de Luis Raposo. | ["Music", "Musical instrument", "Rattle (instrument)", "Accordion"] | ["latin folk", "live recording", "male vocal", "off-key singing", "accordeon", "ukulele", "maracas", "lively", "joyful", "vibrant", "venezuelan"] | 9 | ZahBai58_Ec | 3395 | |
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 |
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;