musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- live performance · 4 ✖
- low quality 4
- passionate male vocal · 4 ✖
- shimmering hi hats · 4 ✖
- groovy bass guitar 3
- crowd clapping 2
- energetic 2
- passionate 2
- punchy kick 2
- punchy snare 2
- soulful 2
- acoustic rhythm guitar 1
- addictive 1
- country 1
- crowd harmonized singing 1
- electric guitar melody 1
- emotional 1
- exciting 1
- gospel 1
- joyful 1
- noisy 1
- regional mexican 1
- rock 1
- shimmering tambourine 1
- simple kick 1
- soft synth keys melody 1
- steel guitar repetitive guitar 1
- wide electric guitar melody 1
musiccaps_names (array) 8 ✖
- Music 3
- Singing 3
- Gospel music 2
- Song 2
- Blues 1
- Christmas music 1
- Rock and roll 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
The very best of Black Gospel - Hallelujah | The low quality recording features a very interactive live performance of a gospel song that consists of crowd harmonized singing and clapping, alongside passionate male vocals and shimmering hi hats which gives it a subtle rhythm. It sounds passionate, energetic and soulful. | 2009-12-27T00:04:33Z | SissyParker | 13.12.2009 The very Best of Black Gospel live at the St. Michael Church in Schweinfurt. Last year it was already awsome but this year it was even greater. A night filled with lots of Feelings and Emotion | ["Singing", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "passionate male vocal", "crowd harmonized singing", "crowd clapping", "shimmering hi hats", "soulful", "energetic", "passionate", "gospel"] | 4 | Fg8yzA7zifw | 1659 | |
ずっと好きだった | The low quality recording features a live performance of a rock song and it consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melody, shimmering hi hats, punchy kick and snare hits. It sounds energetic and exciting. | 2011-10-08T06:45:59Z | Sheik | ["Singing", "Music", "Rock music", "Rock and roll"] | ["low quality", "rock", "live performance", "passionate male vocal", "wide electric guitar melody", "groovy bass guitar", "shimmering hi hats", "punchy kick", "punchy snare", "energetic", "exciting"] | 4 | InfQUMh935c | 1941 | ||
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 |
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;