musiccaps_details (view)
4 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "country music" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 66 ✖
- cheerful · 4 ✖
- country music · 4 ✖
- live performance · 4 ✖
- auto harp 3
- country folk music 3
- fast tempo 3
- spirited 3
- acoustic guitar 2
- banjo 2
- clapping 2
- concert 2
- enthusiastic 2
- lively 2
- male vocalist 2
- regional music 2
- amateur recording 1
- ambient noises 1
- animated 1
- bad audio quality 1
- beatle’s song country style 1
- bluegrass 1
- celebratory 1
- cello 1
- cheering 1
- child performers 1
- country bluegrass 1
- country dance music 1
- dance rhythm 1
- emotional 1
- female vocal backup 1
- festive 1
- fiddle 1
- fiddlers 1
- folk musc 1
- fun 1
- gig 1
- groovy bass lines 1
- groovy rhythm 1
- guitar strumming 1
- happy 1
- high energy 1
- inferior audio quality 1
- instrumental music 1
- keyboard accompaniment 1
- live audience 1
- lively backup 1
- lively vocals 1
- male vocalists 1
- mandolin 1
- medium tempo 1
- melodious 1
- merry 1
- never give up 1
- passionate 1
- people talking 1
- peppy 1
- popular songs 1
- positive 1
- the country life 1
- the wild west 1
- traditional music 1
- vigorous banjo 1
- violinists 1
- vivacious 1
- vocalisation 1
- youthful 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Muddy Hill Boys - Bluegrass To Rockin'The Country Jamboree | A group of male vocalists sing this happy, upbeat country /bluegrass song. The tempo is fast with vigorous and animated acoustic guitar, banjo, mandolin and auto harp lead and harmony. The song is a live performance with ambient sounds of clapping, cheering and people talking. This song is a cheerful Country Pop/Bluegrass song. | 2015-04-05T21:37:46Z | chrisdixie1 | https://www.facebook.com/themuddyhillboys?fref=ts Rockin' The Country Jamboree N°1 - à TOURS 37 FRANCE organisé par DiscOldies le 28/03/2015 | ["Banjo", "Country", "Music", "Rock and roll", "Bluegrass"] | ["male vocalists", "fast tempo", "cheerful", "happy", "acoustic guitar", "vigorous banjo", "auto harp", "mandolin", "ambient noises", "clapping", "cheering", "people talking", "live performance", "gig", "concert", "cheering", "country music", "country folk music", "bluegrass", "inferior audio quality", "amateur recording", "lively", "spirited", "enthusiastic", "vivacious", "youthful", "happy", "celebratory", "festive"] | 7 | 0XxinBtKouQ | 179 | |
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 | |
Kim Fisher & Florian Stölzel The Beatles From Me To You auf ZITHER | A male vocalist sings this famous Beatle’s song in Country style. The tempo is medium with an auto harp accompaniment, groovy bass line, keyboard harmony, female vocal backup and sound of clapping and cheering indicating that this is a live performance . The song is cheerful, melodious, engaging, energetic,youthful and upbeat. | 2014-10-03T10:29:48Z | Florian Stölzel official | Auszug der Show "Kim kommt" vom 15.08.2014 https://de-de.facebook.com/florian.stolzel.9 | ["Gospel music", "Music"] | ["male vocalist", "fast tempo", "groovy bass lines", "beatle’s song country style", "auto harp", "female vocal backup", "clapping", "keyboard accompaniment", "lively", "spirited", "live performance", "cheerful", "country music", "folk musc", "regional music", "popular songs", "cheerful", "peppy", "spirited", "melodious"] | 7 | cTzJlLzN-xU | 3711 | |
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 |
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;