musiccaps_details (view)
4 rows where musiccaps_aspects contains "no percussion" and musiccaps_names contains "Country"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Bluegrass Gospel Music - You've Got To Choose | This bluegrass song features a solo played on a mandolin. This is accompanied by an acoustic guitar strumming chords. A double bass plays the root note and fifth of the chords. A banjo player fills in between phrases. This song is at a moderate tempo and has a country feel. The mood of this song is happy. This song can be played in an inspirational movie. | 2007-06-26T00:26:55Z | Billy Pollard | Bill Jolliff, Jacob Henry and Band, Southern Gospel Music, Strolling Down Memory Lane, Billy & Willie Pollard's Country Gospel TV Program, http://billyandwillie.tripod.com | ["Gospel music", "Country", "Music", "Rhythm and blues", "Bluegrass", "Soul music"] | ["bluegrass", "country", "instrumental", "no voice", "no percussion", "mandolin", "acoustic guitar", "banjo", "double bass", "moderate tempo", "happy mood"] | 0 | REpuZwvyThM | 2681 | |
| Faith Hill & Carlos Santana - Breathe (High Quality) | This pop ballad features a female voice singing the main melody. This is accompanied by an acoustic guitar playing chords. An electric guitar plays a descending lick after one line. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2009-05-23T21:06:44Z | butt3rfli3z88 | I can feel the magic floating in the air Being with you gets me that way I watch the sunlight dance across your face and I've Never been this swept away All my thoughts just seem to settle on the breeze When I'm lying wrapped up in your arms The whole world just fades away The only thing I hear Is the beating of your heart 'Cause I can feel you breathe It's washing over me Suddenly I'm melting into you There's nothing left to prove Baby all we need is just to be Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe In a way I know my heart is waking up As all the walls come tumbling down I'm closer than I've ever felt before And I know And you know There's no need for words right now 'Cause I can feel you breathe It's washing over me Suddenly I'm melting into you There's nothing left to prove Baby all we need is just to be Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe I can feel the magic floating in the air Being with you gets me that way | ["Singing", "Country", "Bluegrass"] | ["pop ballad", "female voice", "acoustic guitar", "bass", "electric guitar", "no percussion", "no other instruments", "pop song", "slow tempo", "romantic mood"] | 0 | VJ1RqPqF9O4 | 2990 | |
| Never Live Life (Like This) Country Music Video | This country song features a male voice singing in a Southern accent. The main melody is a typical country melody. This is accompanied by a violin playing backing notes. The guitar strums chords. The double bass plays the root note and lower fifth of the chords. This song has a happy mood. At the end, there are multiple male voices singing one word together. This song can be played in a happy Country Western movie. | 2013-08-03T02:08:03Z | Papa Darwell | Darwell and The RiskTaker Band Filmed at Darwells Cafe Our Tribute to the Great Earnest Tubb | ["Country", "Music", "Bluegrass"] | ["country song", "violin", "double bass", "male voice", "acoustic guitar", "moderate tempo", "happy mood", "no percussion"] | 0 | colnyHv9CAA | 3744 | |
| Scar Tissue (The Red Hot Chili Peppers) | This folk song is a duet and features a male and a female voice singing in harmony. This is accompanied by an acoustic guitar strumming chords. A banjo player fills in between lines. There is no percussion in this song. The mood of this song is happy and upbeat. This song can be played in a coffee shop. | 2012-12-24T02:14:04Z | goosebearmusic | if you dig the tune you can download it here: https://soundcloud.com/thejunebugs/scar-tissue-the-red-hot-chili Goose and me throwing out some 90's folk... or something like that. | ["Christmas music", "Banjo", "Country", "Music", "Song", "Bluegrass"] | ["folk song", "duet", "male voice", "female voice", "vocal harmony", "banjo song", "guitar song", "no percussion", "minimal instruments", "happy mood", "moderate tempo", "repetitive melody"] | 0 | f6wrXzvByrg | 3922 |
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;