musiccaps_details (view)
2 rows where musiccaps_aspects contains "country", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "passionate male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic rhythm guitar 2
- country · 2 ✖
- low quality · 2 ✖
- passionate male vocal · 2 ✖
- addictive 1
- compressed 1
- crowd clapping 1
- electric guitar melody 1
- groovy bass guitar 1
- joyful 1
- live performance 1
- punchy snare 1
- shimmering hi hats 1
- simple kick 1
- steel guitar repetitive guitar 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 |
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;