musiccaps_details (view)
4 rows where musiccaps_aspects contains "banjo", musiccaps_aspects contains "instrumental", musiccaps_names contains "Banjo" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
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 | |
Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
Wild Oats: Bluegrass Music | This is a bluegrass music piece. The acoustic guitar follows an offbeat strumming pattern, providing a rhythmic background. The violin and the banjo take turns to play rapid, upbeat solos. The atmosphere is very lively. This piece could be used at a definitively American setting such as a rodeo venue. | 2007-03-08T23:27:07Z | Infinitecre8tions | We met these guys in Pigeon Forge, TN as the opening act in Dolly Parton's Dixie Stampede. They agreed to do a private show just for our cameras! | ["Banjo", "Guitar", "Music", "Musical instrument", "Violin, fiddle", "Plucked string instrument", "Bluegrass", "Bowed string instrument"] | ["bluegrass", "instrumental", "violin", "banjo", "acoustic guitar", "american", "folk", "cozy", "lively"] | 9 | hH6thMA3640 | 4090 |
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;