musiccaps_details (view)
3 rows where musiccaps_aspects contains "fun", musiccaps_names contains "Banjo" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- fun · 3 ✖
- happy 2
- live performance 2
- low quality 2
- noisy 2
- acoustic guitar 1
- animated 1
- arpeggiated acoustic guitar melody 1
- arpeggiated and strummed banjo melody 1
- auto harp 1
- banjo 1
- cello 1
- cheerful 1
- concert 1
- country folk music 1
- country music 1
- cover 1
- enthusiastic 1
- fast tempo 1
- fiddle 1
- high energy 1
- live audience 1
- lively backup 1
- lively vocals 1
- male vocalist 1
- merry 1
- mono 1
- ragtime 1
- regional music 1
- vocalisation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Entertainer (S.Joplin) Advanced Slide Guitar Version - Marc Athlan | The low quality recording features a cover of a ragtime song and it consists of arpeggiated acoustic guitar melody. The recording is noisy, but it sounds happy and fun regardless. | 2014-07-27T15:55:10Z | Marc Athlan | This is an attempt to adapt the famous Scott Joplin tune (whole version) on slide guitar. If it has been said that it's a challenge to play this song on guitar, it's even more challenging on slide guitar ! I tried to be as close as possible to the original version. Played on resonator guitar with Diamond Bottleneck (The BEST in the world !). Thanks to Nathalie Athlan, Ian McWee and others at Diamond Bottlenecks.com. Thanks to Keni Lee Burgess for having inspired me with his video (https://youtu.be/X0VL_js9sWs) to do my version of this tune. Thanks for watching ! | ["Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "cover", "arpeggiated acoustic guitar melody", "noisy", "happy", "fun", "ragtime"] | 4 | iCIa_pmLDqs | 4168 | |
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 | |
"Dueling Banjos" - Beginning Banjo Lesson (With Tab) | The low quality recording features an arpeggiated and strummed banjo melody. The recording is noisy, in mono and the melody sounds happy and fun. | 2012-04-02T18:31:36Z | happybanjodude | Link to tab: http://www.happybanjodude.com Tab for Part 2 available now! Follow me on twitter: http://www.twitter.com/happybanjodude | ["Banjo", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["live performance", "noisy", "arpeggiated and strummed banjo melody", "happy", "fun", "low quality", "mono"] | 4 | srEOZzpdhs8 | 4983 |
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;