musiccaps_details (view)
2 rows where musiccaps_aspects contains "background noises" and musiccaps_aspects contains "bluegrass" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_names (array) 9 ✖
- Bluegrass 2
- Country 2
- Music 2
- Banjo 1
- Gospel music 1
- Guitar 1
- Mandolin 1
- Musical instrument 1
- Plucked string instrument 1
musiccaps_aspects (array) 9 ✖
- amateur recording 2
- background noises · 2 ✖
- bluegrass · 2 ✖
- acoustic guitars 1
- banjo 1
- male voices singing 1
- medium tempo 1
- semi acoustic mandolin 1
- upright bass 1
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 | |
Will You Miss Me - Rosine Kentucky Bluegrass Barn Jamboree - Traditional Bluegrass Music | Acoustic guitars are strumming chords while male voices are singing along. There are a lot of background noises of people talking. The recording is of very poor quality. This song may be playing at a local small town event. | 2009-11-10T07:40:04Z | db | Melvin Gill & Pat Meehan of the Kentuckiana Grass band play music with a few friends (Doug Morris & Guynn Cagle on flat top guitars, Sandy Morris on the Dobro) at the Rosine, KY Barn Jamboree Friday Nov. 6, 2009. *Pat Meehan-Mandolin *Melvin Gill-Singing & flat pickin. | ["Country", "Music", "Bluegrass"] | ["bluegrass", "acoustic guitars", "male voices singing", "background noises", "amateur recording", "medium tempo"] | 6 | ZqnbgQeeRbM | 3420 |
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;