musiccaps_details (view)
2 rows where musiccaps_aspects contains "classical music", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "no other instrumentation"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- classical music · 2 ✖
- instrumental music · 2 ✖
- medium tempo 2
- no other instrumentation · 2 ✖
- amateur play 1
- average audio quality 1
- bad audio quality 1
- banjo band 1
- banjo players 1
- banjo playing demonstration 1
- clean tones 1
- emotional 1
- folk music 1
- harmony 1
- home video 1
- home video recording 1
- instrumental duet 1
- learner 1
- legato playing 1
- music practice 1
- mysterious 1
- no percussion instruments 1
- no percussions 1
- passionate 1
- poor audio quality 1
- powerful 1
- recital 1
- romantic 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- spirited 1
- strong tones 1
- tenor sax 1
- vibrato style 1
- youthful 1
- youtube music video 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dueling Banjos - Sleepy Man Banjo Boys - Revenge of the Guitar | Two banjo players trade solos in this instrumental song. The song is medium tempo with banjos playing in a call and response manner and no other instrumentation. The song is energetic and has a middle eastern classical music vibe. The audio quality is average and recorded at Jo e. | 2012-03-13T03:15:13Z | Sleepy Man | Become a fan! https://sleepyman.com/fanclub The boys practice a version of Eric Weissberg's "Dueling Banjos" in the Bedroom - Sleepy Man Banjo Boys - 9 Year old Jonny Mizzone (banjo) and his brothers Robbie Mizzone, 13 (fiddle), and Tommy Mizzone,14 (guitar). | ["Banjo", "Music", "Strum"] | ["banjo players", "instrumental duet", "average audio quality", "harmony", "home video recording", "banjo band", "youthful", "classical music", "clean tones", "mysterious", "folk music", "instrumental music", "medium tempo", "banjo playing demonstration", "no percussion instruments", "powerful", "strong tones", "music practice", "no other instrumentation"] | 1 | RFbWkL818XQ | 2685 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 |
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;