musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality recording" and musiccaps_aspects contains "stringed instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- low quality recording · 2 ✖
- stringed instrument · 2 ✖
- amateur folk music 1
- female voice 1
- foreign language 1
- live recording 1
- no percussion 1
- shaker like percussion 1
- sound of the crowd 1
- sound of whistling 1
- tenor guitar 1
musiccaps_names (array) 6 ✖
- Harp 1
- Mandolin 1
- Music 1
- Musical instrument 1
- Pizzicato 1
- Rattle (instrument) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
FIESTA EN POQUE HUANUCO HUAMALIES CON EDWIN JARA | This amateur folk song features a stringed instrument being played by plucking the strings. This is accompanied by a percussion that sounds like a shaker. This is a low quality recording and the sound of whistling can be heard in the background. There are no voices in the song. This song can be played in a movie featuring a visit to a village. | 2015-10-21T17:32:29Z | Alejandro francisco roque | MARYORDOMO FM MOISES FRANCISCO . EUTEMIA MORALES | ["Harp", "Pizzicato"] | ["amateur folk music", "stringed instrument", "shaker like percussion", "low quality recording", "sound of whistling", "sound of the crowd"] | 0 | pS1X6Au1EAU | 4710 |
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;