musiccaps_details (view)
4 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "low quality" and musiccaps_names contains "Banjo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- fun · 4 ✖
- happy 4
- low quality · 4 ✖
- noisy 3
- live performance 2
- "4 on the floor" kick pattern 1
- arpeggiated acoustic guitar melody 1
- arpeggiated and strummed banjo melody 1
- arpeggiated guitar melody 1
- birds chirping 1
- country 1
- cover 1
- crowd chattering 1
- energetic 1
- flat girl vocal 1
- folk 1
- groovy acoustic rhythm guitar melody 1
- groovy bass 1
- groovy mandoline melody 1
- groovy steel guitars melody 1
- harmonizing male vocals 1
- mono 1
- passionate 1
- ragtime 1
- shimmering shaker 1
musiccaps_names (array) 9 ✖
- Banjo · 4 ✖
- Music 3
- Country 2
- Mandolin 2
- Musical instrument 2
- Plucked string instrument 2
- Strum 2
- Bluegrass 1
- Guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Doyle Lawson and Quicksilver performs "Sea of Life" at the High Country Bluegrass Festival | The low quality recording features a live performance of a country song and it consists of harmonizing male vocals singing over groovy steel guitar, groovy mandoline melody and groovy acoustic rhythm guitar chords. There are some crowd chattering noises in the background. It sounds passionate, happy and fun. | 2009-08-26T02:22:15Z | GrasshopperSlim | Doyle Lawson and Quicksilver performs "Sea of Life" at the High Country Bluegrass Festival in Boone North Carolina on July 25, 2009. | ["Banjo", "Country", "Music", "Bluegrass"] | ["low quality", "live performance", "country", "harmonizing male vocals", "groovy steel guitars melody", "noisy", "groovy mandoline melody", "groovy acoustic rhythm guitar melody", "passionate", "happy", "fun", "crowd chattering"] | 4 | ZX2fVPmUidA | 3388 | |
the sleepover club S01 ep 12 part 2: outdoor trip | The low quality recording features a flat girl vocal talking over a folk song that consists of an arpeggiated guitar melody played over groovy bass, shimmering shakers and "4 on the floor" kick pattern. There are some birds chirping sounds in the background. It sounds energetic, fun and happy. | 2009-06-06T04:26:32Z | lay low | ["Banjo", "Country"] | ["low quality", "flat girl vocal", "folk", "arpeggiated guitar melody", "shimmering shaker", "groovy bass", "\"4 on the floor\" kick pattern", "energetic", "fun", "happy", "birds chirping"] | 4 | ecS6SJGkhIw | 3885 | ||
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 | |
"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;