musiccaps_details (view)
4 rows where musiccaps_names contains "Bowed string instrument" and musiccaps_names contains "Country" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- banjo 2
- country music 2
- folk music 2
- live performance 2
- spirited 2
- acoustic guitar strumming 1
- animated 1
- bad audio quality 1
- banjo playing 1
- barnyard 1
- bow stringed 1
- bright 1
- cajun music 1
- cheerful 1
- child performers 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- crowd cheering 1
- crowd clapping 1
- dance rhythm 1
- eldery male vocals 1
- emotional 1
- energetic 1
- fast paced 1
- fast tempo 1
- fiddle 1
- fiddlers 1
- four stringed instrument 1
- fun 1
- …
musiccaps_names (array) 11 ✖
- Bowed string instrument · 4 ✖
- Country · 4 ✖
- Music 4
- Musical instrument 4
- Plucked string instrument 3
- Banjo 2
- Guitar 2
- Bluegrass 1
- Tambourine 1
- Traditional music 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sam Bush and the Infamous Stringdusters | This is a fun, upbeat country folk song. We hear a banjo player strum rapidly and then go on to do a solo. We hear cheering and clapping fans, intricate basslines and acoustic guitars being rapidly strummed. It's a fun, uptempo song that would be heard in a barnyard. | 2007-08-19T18:07:06Z | Nina | Otis Mountain Festival, Elizabethtown, NY. 8/18/07 | ["Country", "Guitar", "Music", "Musical instrument", "Tambourine", "Plucked string instrument", "Bowed string instrument"] | ["live country folk band", "folk music", "fast paced", "uptempo", "energetic", "banjo playing", "acoustic guitar strumming", "live recording", "poor audio quality", "crowd cheering", "crowd clapping", "fun", "barnyard"] | 3 | puAclKsCbes | 4741 | |
Dewey Balfa - Jai Ete Au Bal - Awesome Fiddlesticks | This music is a lively fiddle instrumental. The tempo is fast with a percussion accompaniment. The music is spirited, vibrant, enthusiastic,cheerful, happy , merry and sunny. This music is Country Folk. | 2008-02-03T02:16:58Z | Paul | Clip is taken from Yasha Aginsky's documentary "Les Blues de Balfa". It is an AWESOME film I would HIGHLY recommend. Dewey Balfa and his nephew Tony Balfa preforming Jai Ete Au Bal (I Went To The Dance). | ["Country", "Traditional music", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "fast tempo", "fiddle", "string instrument", "cajun music", "spirited", "bright", "melodious", "violin", "western classical", "four stringed instrument", "high pitched", "bow stringed", "country music", "lively", "animated", "percussion", "spirited"] | 7 | UFyOGqmITjM | 2901 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
Susie & Mick Darling - Rattle Tattle Gypsy | This is the performance of an Irish folk song using a banjo and a mandolin. The singer is elderly and the guitars are layered. The banjo is used to play a simple motif that revolves around two chords. | 2012-08-26T21:47:41Z | Teesside Steve | Friday 24th August 2012 - http://www.fb.com/saltburnopen | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass", "Bowed string instrument"] | ["live performance", "low quality audio", "folk music", "banjo", "mandolin", "irish bouzouki guitark", "irish folk singing", "eldery male vocals"] | 3 | 0hfU27A6tus | 199 |
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;