musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "country music" and musiccaps_names contains "Country"
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- acoustic guitar · 4 ✖
- country music · 4 ✖
- live performance 3
- auto harp 2
- cheerful 2
- concert 2
- country folk music 2
- easygoing 2
- electric guitar 2
- enthusiastic 2
- fast tempo 2
- fiddle 2
- acoustic sounding drums 1
- amateur recording 1
- ambient noises 1
- animated 1
- banjo 1
- bass guitar 1
- bluegrass 1
- celebratory 1
- cello 1
- cheering 1
- clapping 1
- cozy 1
- female vocal 1
- festive 1
- fun 1
- gentle playing 1
- gig 1
- happy 1
- high energy 1
- inferior audio quality 1
- joyful 1
- live audience 1
- lively 1
- lively backup 1
- lively vocals 1
- longing 1
- male vocalist 1
- male vocalists 1
- male vocals 1
- mandolin 1
- merry 1
- people talking 1
- regional music 1
- sentimental 1
- simple tune 1
- slow tempo 1
- spirited 1
- upbeat 1
- vigorous banjo 1
- vivacious 1
- vocalisation 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dean Brody - Wildflower | This is a country music piece. There is a fiddle playing the main melody. The acoustic guitar and the electric guitar are playing gently in the background. The song has a slow tempo. The atmosphere is sentimental. This piece can be used in the soundtrack of an American drama movie, especially during the scenes where the feeling of longing is emphasized. | 2010-03-25T14:34:30Z | Dean Brody | ["Country"] | ["country music", "fiddle", "acoustic guitar", "electric guitar", "gentle playing", "slow tempo", "easygoing", "sentimental", "longing"] | 9 | -O9mnfC61Ac | 40 | ||
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 | |
Mandolin Bridge Part 1 | This is the live performance of a country music piece. There is a female vocal and two male vocals taking turns and sometimes singing the words at the same time. The melody consists of an electric guitar, an acoustic guitar and a bass guitar while in the rhythmic background there is an acoustic sounding upbeat drum beat. The atmosphere is cozy. There is an easygoing aura to it. This piece could be used in the soundtrack of a movie or a TV show that takes place in rural USA. | 2014-04-08T18:01:39Z | janrohan | This video is about the Mandolin Bridge band Ohio -- rocking country, dance and oldies! Visit us at www.mandolinbridge.com ! | ["Singing", "Country", "Music", "Mandolin", "Ska", "Song"] | ["country music", "female vocal", "male vocals", "electric guitar", "acoustic guitar", "acoustic sounding drums", "bass guitar", "simple tune", "easygoing", "cozy", "joyful", "upbeat", "live performance"] | 9 | QSaX7QfeWog | 2620 | |
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;