musiccaps_details (view)
4 rows where musiccaps_names contains "Banjo", musiccaps_names contains "Bluegrass", musiccaps_names contains "Mandolin" and musiccaps_names contains "Plucked string 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Maxwell Swing by Texas Gypsies | The Jazz song features a passionate solo acoustic guitar melody and acoustic rhythm guitar chords, followed by simple double bass. It sounds smooth and elegant, something you would hear in fancy restaurants or good jazz clubs. | 2012-07-31T05:33:50Z | maxwellswing | Original Gypsy Jazz tune by Texas Gypsies from the Cafe du Swing CD! www.texasgypsies.com Photos by John Heiman, Bruce Buhrow, Chad Windham,David Meadows | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["jazz", "passionate solo acoustic guitar melody", "acoustic rhythm guitar chords", "simple double bass", "smooth", "elegant"] | 4 | AmAThmRphk0 | 1168 | |
Best banjo player ever (Foggy Mountain Breakdown) | The low quality recording features a manically arpeggiated steel guitar. The recording is noisy and in mono, as it sounds like the player is practicing to execute the melody properly -probably recorded with a phone. | 2013-04-01T00:16:15Z | JesusLovesYou | 25 Worst Parents of All Time - https://www.youtube.com/watch?v=hBPSllGLYDw | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "manically arpeggiated steel guitar", "noisy", "mono"] | 4 | EZi80fUpBfE | 1570 | |
Memphis Yodel | This amateur recording features a male voice singing the main melody. This is accompanied by a banjo being strummed in a country rhythm. This song is sung at a moderate tempo. This song has a patriotic feel. There are no other instruments in this song apart from the tenor banjo. This song can be played in a patriotic American movie. | 2008-12-23T05:34:54Z | lewdite | This is one of my favorite Jimmie Rodgers songs. Recorded in 1928. Here I am with my trusty tenor banjo. I recorded this song with my friend Johnny Fast. He has a fantastic voice (I do the yodeling) and to make it easy for you to check it out I've posted as a video response. THE WORDS & CHORDS TO THIS SONG AT: www.youtube.com/LDsongscreen | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["country song", "banjo song", "amateur recording", "no percussion", "male voice", "moderate tempo", "folk song", "minimal instruments", "patriotic song"] | 0 | LFYRuK8YstI | 2168 |
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;