musiccaps_details (view)
8 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_author = 9 and musiccaps_names contains "Country"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- acoustic guitar · 8 ✖
- easygoing 5
- bass guitar 3
- bluegrass 3
- cozy 3
- electric guitar 3
- fiddle 3
- live performance 3
- male vocal 3
- male vocals 3
- mandolin 3
- melodic singing 3
- banjo 2
- country music 2
- female vocal 2
- gospel 2
- joyful 2
- sentimental 2
- steady tempo 2
- acoustic rock 1
- acoustic sounding drums 1
- american folk 1
- americana 1
- christian 1
- country 1
- cover 1
- devotional 1
- friendly 1
- gentle playing 1
- gravelly voice 1
- harmony singing 1
- longing 1
- melancholic 1
- melodic 1
- nostalgic 1
- percussion 1
- playful 1
- religious 1
- rock 1
- rural 1
- simple 1
- simple tune 1
- slow tempo 1
- spiritual 1
- upbeat 1
musiccaps_names (array) 9 ✖
- Country · 8 ✖
- Music 7
- Bluegrass 3
- Singing 2
- Song 2
- Mandolin 1
- Music of Africa 1
- Ska 1
- Synthetic singing 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 | ||
Johnny Cash Your Own Personal Jesus Music Video | This is a country/Americana music piece. There is a male vocalist with a gravelly voice singing in the lead. An acoustic guitar is playing a simple tune. There is a faint percussive element that can be heard in the background that resembles pinched harmonics coming from a guitar. The atmosphere is melancholic. This piece could be used in the soundtrack of a drama movie or a TV show during a scene of introspection where a character is experiencing dark thoughts. | 2008-01-30T02:15:17Z | bayekane | Johnny Cash Your Own Personal Jesus Music Video | ["Country", "Music", "Bluegrass"] | ["country", "americana", "rock", "male vocal", "gravelly voice", "acoustic guitar", "percussion", "melancholic", "sentimental", "steady tempo"] | 9 | 6OcoDIrbMtY | 750 | |
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 | |
Paradise - Jim and Jesse McReynolds - High Lonesome: The Story of Bluegrass Music | This is a bluegrass music piece. Two male vocals are singing melodically in the lead. The tune is played by a rich chordophone background composed of the fiddle, the mandolin and the acoustic guitar. The atmosphere of the piece is joyful and nostalgic. It has a steady tempo. The piece could be used in the soundtrack of a movie or a TV series taking place in rural USA, especially in the scenes where there is some sense of yearning. It could be playing in the background at an American diner or a bar. | 2014-02-20T00:24:23Z | CMH Records | Paradise by Jim and Jesse McReynolds on CMH Records' High Lonesome: The Story of Bluegrass Music -- Available Now at CMH Records, iTunes, and Amazon!!! CMH Records: http://www.cmhrecords.com/web/page.as... iTunes: https://itunes.apple.com/us/album/hig... Amazon: http://www.amazon.com/High-Lonesome-S... Also be sure to connect with us on… Facebook: https://www.facebook.com/PickinOnSeries/ Instagram: https://www.instagram.com/cmhrecords/ Twitter: https://twitter.com/PickinOnSeries Pinterest: https://www.pinterest.com/cmhrecords/ Tumblr: http://cmhrecords.tumblr.com | ["Music of Africa", "Country", "Music", "Song"] | ["bluegrass", "american folk", "male vocals", "melodic singing", "mandolin", "fiddle", "acoustic guitar", "bass guitar", "joyful", "cozy", "friendly", "nostalgic", "steady tempo"] | 9 | ZiHlhUvmgzQ | 3406 | |
fuel - in bluegrass style - iron horse | This is a bluegrass cover of an originally heavy metal music piece. There is a male vocalist singing melodically in the lead. The tune is being played by the banjo, the mandolin and the acoustic guitar while the bass guitar is playing in the background. The atmosphere is playful and there is a rural feel to the piece. This piece could be used in the soundtrack of a comedy movie that takes place in the rural parts of the USA. | 2007-09-19T18:28:14Z | oddis123 | Fade to Bluegrass Tribute to Metallica is available at http://www.cmhrecords.com on iTunes and retailers nationwide. Kirk Hammett also likes this tribute! Check out the interview here: http://youtube.com/watch?v=jdh_0H77Dkc | ["Country", "Music", "Bluegrass"] | ["bluegrass", "cover", "male vocal", "melodic singing", "banjo", "mandolin", "acoustic guitar", "bass guitar", "playful", "easygoing", "rural"] | 9 | _AVegKwklcg | 3451 | |
Dos Eddies-Come And Get Your Love (cover)-HD-Ogden Tap Room-Ogden, NC-6/14/14 | This is a live acoustic performance of a rock music song. There is a male vocalist singing at a medium-to-high pitch in a melodic manner while two acoustic guitars are carrying the background with a simple tune composed of only four chords. The music might be played at a bar in the background. | 2014-06-17T01:56:11Z | castromusicfreak | Dos Eddies performing Redbone's "Come And Get Your Love" at the Ogden Tap Room in Ogden, NC on 6/14/14. Greg Miller and Mark Weathers have created an acoustic duo version of The Steady Eddies, streamlined for those events that call for an unplugged experience. For more information about Dos Eddies, visit their Facebook page at: https://www.facebook.com/pages/Dos-Eddies/152709704894082 Video by Sue Kropp A Stolen Rune Recording | ["Country", "Music"] | ["acoustic rock", "acoustic guitar", "male vocal", "live performance", "simple", "melodic", "easygoing"] | 9 | eiFyXXqd9Rk | 3892 | |
Doyle Lawson and Quicksilver - Just Over In Heaven | This is the live performance of a bluegrass gospel music piece. There are male vocals synchronously harmony singing which is called a "stack" in bluegrass music. The melody is being played by the fiddle, the banjo, the acoustic guitar and the mandolin. There is a cozy atmosphere in this piece. It could be playing in the background of an American roadside diner. This piece could also be played at a Christian religious event. | 2010-11-26T01:42:06Z | Colt28683 | Doyle Lawson and Quicksilver - Just Over In Heaven Bluegrass Gospel | ["Singing", "Country", "Music", "Bluegrass"] | ["bluegrass", "gospel", "live performance", "male vocals", "harmony singing", "fiddle", "banjo", "acoustic guitar", "mandolin", "easygoing", "cozy"] | 9 | hHqrcLiKJRg | 4093 | |
Mildred Lorton Walton/ DON'T OVERLOOK SALVATION | This is a Christian gospel music piece. There is a female vocalist singing melodically. An acoustic guitar and an electric guitar are playing in the melodic background. The atmosphere is religious. This piece could be used as a background music for Christian social media content. | 2007-04-15T23:19:37Z | emmylousings | Country Gospel/ by Mildred Walton; Kitty Wells Tribute Artist | ["Country", "Music", "Synthetic singing"] | ["gospel", "christian", "female vocal", "melodic singing", "acoustic guitar", "electric guitar", "religious", "spiritual", "devotional"] | 9 | m-eyGzf9Ux4 | 4438 |
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;