musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "no percussion" and musiccaps_names contains "Mandolin" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- no percussion · 3 ✖
- acoustic guitar music 1
- blues feel 1
- blues guitar 1
- female voice 1
- fingerstyle guitar 1
- foreign language 1
- instrumental 1
- instrumental music 1
- live recording 1
- low quality recording 1
- no other instruments 1
- no voice 1
- no voices 1
- raking guitar strings 1
- relaxing 1
- resonator guitar 1
- slow tempo 1
- string bending 1
- stringed instrument 1
- tenor guitar 1
musiccaps_names (array) 9 ✖
- Mandolin · 3 ✖
- Music 3
- Musical instrument 3
- Guitar 2
- Plucked string instrument 2
- Acoustic guitar 1
- Blues 1
- Rattle (instrument) 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Andrea Valeri: Carrasecare | This instrumental song features an acoustic guitar being played. The strings are raked followed by a bend to a higher note. This is followed by a descending run using three notes. This song has a blues feel. There are no other instruments in this song. There are no voices in this song. This song can be played in a Wild West movie. | 2011-04-19T05:56:08Z | Fingerpicking net | Andrea Valeri for fingerpicking.net. High resolution video on http://www.fingerpicking.net | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["acoustic guitar music", "raking guitar strings", "slow tempo", "string bending", "blues feel", "no percussion", "no other instruments", "no voice", "instrumental"] | 0 | 4ueN2gGsH5Y | 614 | |
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 | |
Mike Dowling " Blues In G ." | This blues guitar song features a resonator guitar. Fingerstyle guitar is being played. The melody is a blues style guitar. There are no other instruments in this song. There are no voices in this song. This song can be played in a bar. | 2014-05-08T19:25:05Z | nationalguitars | Mike Dowling presents "Blues In G." courtesy of Homespun. | ["Blues", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["blues guitar", "fingerstyle guitar", "no percussion", "resonator guitar", "no voices", "instrumental music", "relaxing"] | 0 | F1X7egd8Us0 | 1608 |
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;