musiccaps_details (view)
4 rows where musiccaps_aspects contains "easygoing", musiccaps_aspects contains "live performance" and musiccaps_names contains "Country"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- easygoing · 4 ✖
- live performance · 4 ✖
- acoustic guitar 3
- cozy 2
- male vocals 2
- acoustic rock 1
- acoustic sounding drums 1
- banjo 1
- bass guitar 1
- bluegrass 1
- country music 1
- electric guitar 1
- female vocal 1
- fiddle 1
- flat male vocal 1
- funky 1
- gospel 1
- groovy 1
- groovy keys chords 1
- harmony singing 1
- joyful 1
- low quality 1
- male vocal 1
- mandolin 1
- melodic 1
- punchy kick 1
- punchy snare 1
- rock 1
- shimmering hi hats 1
- shimmering open hats 1
- simple 1
- simple tune 1
- smooth bass guitar 1
- upbeat 1
- wide electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
Shake Rattle n' Roll demo video 1 | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over a wide electric guitar melody, groovy keys chords, located in the right channel of the stereo image, smooth bass guitar, shimmering open hats and hi hats and punchy kick and snare hits. It sounds groovy, funky and easygoing - like something you could lightly dance to. | 2009-09-30T03:58:48Z | Bill Crane | Demo video recorded 9/28/09. | ["Country", "Music", "Ska", "Rock and roll"] | ["low quality", "rock", "live performance", "flat male vocal", "wide electric guitar melody", "groovy keys chords", "smooth bass guitar", "shimmering hi hats", "punchy snare", "punchy kick", "shimmering open hats", "groovy", "funky", "easygoing"] | 4 | rmKh9uaikTU | 4900 |
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;