musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "country folk music" and musiccaps_names contains "Bluegrass" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- cheerful 3
- country folk music · 3 ✖
- acoustic guitar 2
- auto harp 2
- concert 2
- country music 2
- enthusiastic 2
- fast tempo 2
- live performance 2
- amateur recording 1
- ambient noises 1
- animated 1
- banjo 1
- bluegrass 1
- celebratory 1
- cello 1
- cheering 1
- clapping 1
- country 1
- elderly raspy male country vocal 1
- electric guitar licks 1
- festive 1
- fiddle 1
- fun 1
- gig 1
- happy 1
- high energy 1
- inferior audio quality 1
- intricate bassline 1
- joyful 1
- live audience 1
- lively 1
- lively backup 1
- lively vocals 1
- male vocalist 1
- male vocalists 1
- mandolin 1
- merry 1
- people talking 1
- regional music 1
- southern 1
- spirited 1
- storytelling style singing 1
- vibrant piano playing 1
- vigorous banjo 1
- violin lick 1
- vivacious 1
- vocalisation 1
- youthful 1
musiccaps_names (array) 10 ✖
- Bluegrass · 3 ✖
- Country 3
- Music 3
- Banjo 2
- Exciting music 1
- Middle Eastern music 1
- Musical instrument 1
- Pop music 1
- Rock and roll 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Cow Girl (Comedy Country Music Video) | This is a country folk song with a generally positive, cheerful and joyful vibe to it. The singer is a man with an elderly voice that has a quality that sounds like a gurgle. His style of singing and the content of lyrics and melody are similar to hearing a story being told. There aren't really any rhyming lyrics - it's more like he is telling a story in song form. There are licks being played on an electric guitar, as well as certain motifs on the violin in between particular phrases by the singer. | 2013-07-31T05:05:40Z | Papa Darwell | Darwell and The Risktaker Band filmed at Darwell's Cafe Long Beach Ms | ["Country", "Music", "Pop music", "Middle Eastern music", "Bluegrass", "Exciting music"] | ["country folk music", "electric guitar licks", "violin lick", "elderly raspy male country vocal", "intricate bassline", "country", "southern", "vibrant piano playing", "cheerful", "storytelling style singing", "joyful"] | 3 | GFGwPa9d9XQ | 1702 | |
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 |
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;