musiccaps_details (view)
7 rows where musiccaps_names contains "Banjo", musiccaps_names contains "Country" and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 74 ✖
- banjo 4
- country music 3
- amateur recording 2
- bluegrass 2
- dance rhythm 2
- emotional 2
- instrumental music 2
- live performance 2
- mandolin 2
- passionate 2
- spirited 2
- upbeat 2
- upright bass 2
- acoustic guitar 1
- acoustic guitar solo melody 1
- acoustic guitars strumming 1
- auto harp accomapniment 1
- background noises 1
- background voices 1
- bad audio quality 1
- banjo melody 1
- cheerful 1
- child performers 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country folk song 1
- dexterous 1
- eldery male vocals 1
- energetic 1
- exciting 1
- fast tempo 1
- fiddlers 1
- folk 1
- folk music 1
- groovy bas slime 1
- groovy bass line 1
- groovy rhythm 1
- guitar band 1
- guitar strumming 1
- home music video 1
- infectious drumming 1
- instrumental 1
- irish bouzouki guitark 1
- irish folk singing 1
- live perforamnce 1
- low quality 1
- low quality audio 1
- medium fast tempo 1
- medium tempo 1
- medium to uptempo 1
- music jam 1
- nature sounds 1
- never give up 1
- noisy 1
- poor audio quality 1
- positive 1
- punchy 1
- regional music 1
- semi acoustic mandolin 1
- string instrument 1
- tambourine beats 1
- the country life 1
- the wild west 1
- traditional music 1
- ukulele playing 1
- unbalanced stereo 1
- vibrant 1
- vigorous 1
- vigorous mandolin harmony 1
- violinists 1
- vivacious 1
- youthful 1
- youtube songs 1
musiccaps_names (array) 12 ✖
- Banjo · 7 ✖
- Country · 7 ✖
- Music 7
- Musical instrument 7
- Plucked string instrument · 7 ✖
- Guitar 4
- Bluegrass 3
- Bowed string instrument 2
- Mandolin 2
- Gospel music 1
- Speech 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 |
---|---|---|---|---|---|---|---|---|---|---|
Susie & Mick Darling - Rattle Tattle Gypsy | This is the performance of an Irish folk song using a banjo and a mandolin. The singer is elderly and the guitars are layered. The banjo is used to play a simple motif that revolves around two chords. | 2012-08-26T21:47:41Z | Teesside Steve | Friday 24th August 2012 - http://www.fb.com/saltburnopen | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass", "Bowed string instrument"] | ["live performance", "low quality audio", "folk music", "banjo", "mandolin", "irish bouzouki guitark", "irish folk singing", "eldery male vocals"] | 3 | 0hfU27A6tus | 199 | |
Awesome Mandolin Playing by 15 year old Jake | A banjo is playing chords while an upright bass is playing a bassline. These two form the rhythmic section. On top of that a mandolin is playing a fast and complex solo. In the background you can hear the crowd cheering and clapping hands. This is an amateur recording. This song may be playing in a big pub. | 2007-10-28T00:10:19Z | Billy Pollard | Mandolin playing by Jake Jolliff with Bill Jolliff on Banjo, Louanne Fugal on Upright Bass, Steve Blanchard on Rythym Guitar, Awesome Mandolin Pickin' n' Grinnin', Bluegrass Style Music, Strolling Down Memory Lane, Billy and Willie Pollard's Country Gospel T.V. Program, WillieAndBilly@Yahoo.com , http://billyandwillie.tripod.com | ["Gospel music", "Banjo", "Country", "Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "semi acoustic mandolin", "banjo", "upright bass", "background noises", "amateur recording"] | 6 | 4KqSdK5KM-I | 556 | |
Carl Jackson - Foggy Mountain Breakdown | This music is instrumental. The tempo is fast with a vigorous banjo harmony, infectious drumming, auto harp, mandolin and tambourine accompaniment. The music is an upbeat, high-spirited, energetic,enthusiastic ,effervescent Country Music instrumental. | 2008-11-13T05:16:04Z | bluegrasbanjolover | Carl Jackson performs Foggy Mountain Breakdown on the banjo. | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "fast tempo", "tambourine beats", "regional music", "dexterous", "vigorous mandolin harmony", "infectious drumming", "auto harp accomapniment", "mandolin", "upbeat", "punchy", "vibrant", "vigorous", "vivacious", "country music", "country folk song", "string instrument"] | 7 | 5hEt87nd7os | 682 | |
Bluegrass jam ( Rebecca) | An acoustic guitar is strumming chords while a banjo is playing a fast melody over it. In the background you can hear an upright bass playing a fast walking bassline. Also in the background noises of people speaking can be heard. This song may be playing live on the streets performed by buskers. | 2006-11-06T22:08:09Z | monrobro | Jamming at Memramcook Festival with True Blue Banjo- Dominic Cormier Bass- Jean-Marc Boucher Mandolin- Ron Girouard Guitar- 1st Break Michael Alain Guitar- 2nd Break Richard Bourque | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "amateur recording", "banjo", "acoustic guitar", "upright bass", "background voices", "medium to uptempo"] | 6 | 669Fk7afszw | 724 | |
Gypsy - Tyler May & The Kentucky School of Bluegrass and Traditional Music Ensemble | The song is an instrumental. The song is medium fast tempo with a groovy bass line, acoustic guitars strumming rhythm, and a ukulele playing lead. The song is spirited and exciting. The song is an instrumental with country music influences. | 2011-04-23T00:46:35Z | Stewart Tyler May | Gypsy © 2011 by Stewart Tyler May Guitar - Josh Reimen Guitar - Leslie Strong Banjo - Jeremy Moses Mandolin - Isaac May Bass - Tina May Fiddle/Clawhammer Banjo - Tyler May | ["Banjo", "Country", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["ukulele playing", "acoustic guitars strumming", "groovy bass line", "dance rhythm", "home music video", "youtube songs", "music jam", "spirited", "poor audio quality", "guitar band", "country music", "groovy bas slime", "energetic", "youthful", "exciting", "emotional", "dance rhythm", "instrumental music", "medium fast tempo"] | 1 | CudxWnS7ukw | 1413 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
Willow & Lee - Foggy Mountain Breakdown | The low quality recording features a live performance of a folk song and it consists of acoustic guitar solo melody, followed by banjo melody. The recording is noisy, there are some natural sounds - since it was performed outdoors and the stereo image is unbalanced due to the fact that the instruments are leaning towards the right channel of the stereo image. It still sounds passionate and upbeat. | 2014-06-01T14:36:03Z | WillowOsborne | 13-year Old Willow Osborne & Lee Marcus performs "Foggy Mountain Breakdown" at Dollywood, Pigeon Forge, TN. (May 2014) | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "live perforamnce", "unbalanced stereo", "nature sounds", "acoustic guitar solo melody", "upbeat", "banjo melody", "folk", "passionate"] | 4 | qyCea2TuUV4 | 4840 |
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;