musiccaps_details (view)
4 rows where musiccaps_aspects contains "banjo", musiccaps_author = 7 and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- banjo · 4 ✖
- instrumental 4
- african instrument 2
- bluegrass 2
- country music 2
- folk music 2
- lively 2
- medium tempo 2
- spirited 2
- stringed instrument 2
- 9 stringed instrument 1
- acoustic guitar 1
- amateur musicians 1
- amateur recording 1
- american instrument 1
- blue grass 1
- cheerful 1
- country 1
- engaging 1
- fast tempo 1
- folk 1
- home video 1
- loud 1
- mellow tune 1
- melodic 1
- melodious 1
- pleasant 1
- plucked string instrument 1
- plucking 1
- popping 1
- popping sound 1
- rhythmic 1
- sharp 1
- skilful 1
- snappy 1
- string instrument 1
- sweet melody 1
- vibration 1
- vibrations 1
musiccaps_names (array) 10 ✖
- Music 4
- Plucked string instrument · 4 ✖
- Banjo 3
- Musical instrument 3
- Guitar 2
- Acoustic guitar 1
- Bluegrass 1
- Country 1
- Mandolin 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 |
---|---|---|---|---|---|---|---|---|---|---|
Cluck Old Hen - clawhammer banjo | This music is instrumental. The tempo is medium with an animated Banjo lead harmony. There is minimal instrumentation with cheerful ,popping vibrations of this beautiful instrument. It is lively ,spirited, cheerful and adds a beautiful layer to Country and Folk Songs. | 2012-03-18T20:37:35Z | Merit C | Playing Cluck Old Hen with a Deering Goodtime Openback Banjo. First clawhammer song I ever learned. | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "medium tempo", "banjo", "popping", "cheerful", "stringed instrument", "lively", "spirited", "vibrations", "stringed instrument", "country music", "plucking", "folk music", "bluegrass", "african instrument", "melodious", "rhythmic"] | 7 | 4i9DgH80kDg | 597 | |
Little Rock Getaway Performed by Daniel Patrick | This music is a lively Banjo instrumental. The tempo is fast with the musician dexterously playing a very spirited, vivacious and complex harmony. There is no other instrument accompaniment. This instrument is often heard in Country and Bluegrass. | 2009-03-21T18:53:07Z | James Duckworth | Number one of a session of seven song I was privileged to video of the young 14 year old self taught banjo talent Daniel Patrick from my area. Sit back enjoy the tune. Look for the others soon. www.danielpatrickandfamily.com | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "fast tempo", "banjo", "stringed instrument", "country music", "folk music", "bluegrass", "popping sound", "snappy", "vibration", "lively", "spirited", "melodic", "engaging", "pleasant", "skilful"] | 7 | BWvKAcOV_co | 1251 | |
ccb hinos | This is an amateur music video of a male musician playing a mellow harmony on the banjo with another amateur musician accompanying him on the acoustic guitar. This song has a simple melody but the recording is loud and sharp. | 2009-07-06T21:42:26Z | Daniele Batista | Guitarra Havaiana e Violão | ["Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["instrumental", "banjo", "acoustic guitar", "sharp", "amateur recording", "amateur musicians", "loud", "home video", "mellow tune", "amateur recording"] | 7 | LH3mAtCou6g | 2172 | |
Luap plays Old Gray Goose (take 2) | This music clip is of a musician playing a lilting melody on the Banjo. The tempo is medium with a rhythmic lead harmony. There is no other instrument used. The music is soft, mellow, nostalgic, and calming. Soothing and simple. | 2009-01-12T01:39:50Z | llmckee | More practice and improvement | ["Banjo", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["instrumental", "medium tempo", "string instrument", "plucked string instrument", "banjo", "african instrument", "american instrument", "9 stringed instrument", "sweet melody", "folk", "country", "blue grass"] | 7 | YbLR6dgY-K4 | 3297 |
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;