musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "banjo" and musiccaps_names contains "Mandolin"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Banjo Music "Potato Head Blues" Eddy Davis Tenor Banjo | Someone is strumming a banjo along with playing a lead melody. This may be playing sitting in the countryside in front of your house in the garden. | 2009-10-22T23:22:11Z | Wyatt Urban | Eddy Davis plays POTATO HEAD BLUES, Sept. 25, 2009 in NYC, on a Gibson Mastertone TB5, which originally belonged to Jim Robinson, who purchased it new in 1931. Jim played it until 2005, when he died at the age of 92. | ["Banjo", "Music", "Mandolin", "Bluegrass"] | ["amateur recording", "banjo", "uptempo"] | 6 | VAqgpoyD2jc | 2979 | |
Man Of Constant Sorrow - Verse Part 1 - Banjo with Rob | This audio contains someone playing a melody on a banjo. A male voice is speaking with a deeper voice. This is an amateur recording. | 2010-07-22T17:09:49Z | Rob Bourassa | We have skipped to the second part of the verse, before we tackle the difficult roll in the first part. This will prepare us. For free lessons, visit https://www.facebook.com/pages/Banjo-with-Rob/769249856456422 | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "banjo", "male voice speaking", "medium to uptempo"] | 6 | YqZNMFyPJOQ | 3315 |
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;