musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "country", musiccaps_aspects contains "passionate male vocal" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- acoustic rhythm guitar 3
- country · 3 ✖
- passionate male vocal · 3 ✖
- low quality 2
- 4 on the floor cowbell pattern 1
- 4 on the floor kick 1
- accordion melody 1
- addictive 1
- boomy 1
- compressed 1
- crowd clapping 1
- electric guitar melody 1
- fun 1
- groovy bass 1
- groovy bass guitar 1
- happy 1
- joyful 1
- live performance 1
- poor mix 1
- punchy snare 1
- shimmering hi hats 1
- shimmering shakers 1
- simple kick 1
- soft crash cymbal 1
- steel guitar repetitive guitar 1
- syncopated snare 1
- uptempo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dr Hook and the medicine show - Yodel Song | The low quality recording features an uptempo country song sung by passionate male vocalists, followed by acoustic rhythm guitar and electric guitar melody. It sounds really bad and imbalanced, as the left channel is louder than the right. | 2009-03-05T00:21:41Z | chiefskis | Dr Hook and the medicine show - Yodel Song | ["Singing", "Yodeling", "Music"] | ["low quality", "country", "acoustic rhythm guitar", "passionate male vocal", "compressed", "electric guitar melody", "uptempo"] | 4 | CHufyCHSF1U | 1348 | |
Gary Stewart She's Acting Single | The low quality recording features a live performance of a country song that consists of an acoustic rhythm guitar, groovy bass guitar, shimmering hi hats, simple kick, punchy snare and steel guitar repetitive melody. At the end of the loop, there is a short snippet of passionate male vocal singing, while at the beginning there is a crowd clapping sound. It sounds joyful and addictive. | 2008-07-26T23:11:42Z | bigruss2069 | My ALL TIME FAV Gary sings what all us men have felt at one time or another. Anyone familiar with Gary Stewart and his tragic ending, KNOWS that when this guy sang love songs, he sang them from the heart... I met him briefly in Oklahoma City at a dinner showplace called "Henson's" circa 1983 and was struck by how friendly and real this guy was. Gary, you will not be forgotten! | ["Blues", "Singing"] | ["low quality", "live performance", "country", "acoustic rhythm guitar", "groovy bass guitar", "shimmering hi hats", "simple kick", "punchy snare", "steel guitar repetitive guitar", "passionate male vocal", "crowd clapping", "joyful", "addictive"] | 4 | D9893od03Sc | 1444 | |
Javier Molina & Eldorado - Cowboy Cumbia (Official Music Video) | The Country song features a passionate male vocalist singing over accordion melody, groovy bass, layered "4 on the floor" kick and cowbell pattern, soft crash cymbal, shimmering shakers and acoustic rhythm guitar. It sounds fun and happy, even though the song is poorly mixed, as it sounds a bit boomy. | 2011-08-01T16:05:34Z | TejanoSA | Javier Molina & Eldorado performing Cowboy Cumbia (Official Music Video) © 1998 Javier Molina | ["Singing", "Music", "Salsa music"] | ["country", "passionate male vocal", "accordion melody", "groovy bass", "4 on the floor cowbell pattern", "acoustic rhythm guitar", "fun", "happy", "4 on the floor kick", "syncopated snare", "soft crash cymbal", "shimmering shakers", "poor mix", "boomy"] | 4 | bLjOJRg2P_Q | 3618 |
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;