musiccaps_details (view)
4 rows where musiccaps_aspects contains "banjo", musiccaps_aspects contains "country music", musiccaps_author = 7 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 | |
EGIL SKJELNES - LOOK AT US | This music is a country song instrumental. The tempo is slow with a mellifluous Auto Harp harmony, steady drumming, rhythmic acoustic guitar, and subtle bass lines. The music is melodic, soothing, peaceful, nostalgic,mellow and dulcet Country Song Instrumental. | 2012-07-08T07:31:41Z | Steelnes | Homevideo Live July 2012 | ["Echo", "Electric guitar", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar"] | ["instrumental", "slow tempo", "steady drumming", "banjo", "dobro", "dulcet", "country pop instrumental", "peaceful", "acoustic guitar accompaniment", "auto harp harmony", "country music", "country pop", "country folk song", "country song instrumental", "mellow", "soothing", "mellifluous"] | 7 | XaUXJG0BZuk | 3198 | |
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 |
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;