musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy music" and musiccaps_names contains "Banjo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- groovy music · 2 ✖
- instrumental music 2
- spirited 2
- average audio quality 1
- banjo player 1
- celtic music 1
- country blue grass 1
- country music 1
- emotional 1
- energetic 1
- entertaining 1
- exciting 1
- fast tempo 1
- fiddler 1
- guitar strumming 1
- home music video 1
- instrumentalist 1
- live performance 1
- love performance 1
- love video performance 1
- medium tempo 1
- mome music video 1
- passionate 1
- playful 1
- poor audio quality 1
- soloist 1
- traditional folk music 1
- traditional percussion instruments 1
- violin 1
- violins playing 1
- virtuoso 1
- walking bass line 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
World Fastest Banjo Player | The song is an instrumental. The song is medium tempo with a groovy rhythm and fast fingers playing this banjo solo. The song is entertaining and exciting. The song is of poor audio quality and a live performance video. | 2009-05-12T15:23:34Z | eriobras | Erio Meili on May 10, 2009, picking the tune "Sunday", at 330 bpm at the Titanic Harbor Stage, 660 notes per minute (10 notes per second) - former record was on June15, 2008 at 320 bpm | ["Banjo", "Music", "Bluegrass"] | ["banjo player", "fast tempo", "groovy music", "love video performance", "instrumental music", "virtuoso", "walking bass line", "entertaining", "love performance", "soloist", "country blue grass", "entertaining", "energetic", "passionate", "spirited", "instrumentalist", "poor audio quality", "live performance"] | 1 | 0HXYdGGKV2k | 141 | |
8 Year Old Jonny Mizzone - Flint Hill Special - Sleepy Man Banjo Boys | The song is an instrumental. The song is slow tempo with a fiddler plays a rhythmic melody accompanied by a guitar accompaniment and other percussive instruments. The song is spirited and energetic. The song has country or Celtic influences. The song has average quality audio. | 2011-02-21T02:57:35Z | Sleepy Man | Our new single "Rain" https://www.youtube.com/watch?v=ZcoOKXrJqY0 http://sleepyman.com **From 2011** Another bedroom practice of Earl Scruggs's Flint Hill Special. Brothers Jonny Mizzone age 8 on banjo, Robbie Mizzone age 12 on fiddle, and Tommy Mizzone age 13 on guitar. http://www.sleepymanbanjo.com http://facebook.com/sleepymanbanjo | ["Banjo", "Music"] | ["fiddler", "instrumental music", "celtic music", "spirited", "home music video", "exciting", "traditional folk music", "violin", "average audio quality", "mome music video", "groovy music", "traditional folk music", "guitar strumming", "traditional percussion instruments", "emotional", "playful", "exciting", "country music", "violins playing", "medium tempo"] | 1 | I3qbB4Kq3Y0 | 1869 |
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;