musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate", musiccaps_names contains "Gospel music" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- low quality 3
- passionate · 3 ✖
- live performance 2
- noisy 2
- passionate male vocal 2
- shimmering hi hats 2
- soulful 2
- crowd clapping 1
- crowd harmonized singing 1
- electric guitar melody 1
- emotional 1
- energetic 1
- fruity male vocal 1
- gospel 1
- groovy bass guitar 1
- joyful 1
- mono 1
- passionate harmonizing choir vocals 1
- punchy kick 1
- regional mexican 1
- shimmering tambourine 1
- soft synth keys melody 1
- traditional 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
UNAM Choir - Ba Nyorilweng (Song of Prayer) | The low quality recording features passionate harmonizing choir vocals, alongside fruity male vocals. It sounds passionate, traditional and joyful. The recording is noisy and in mono. | 2011-12-02T23:42:18Z | GT Choir Ongwediva | The UNAM (University of Namibia) Choir performing at the UNAM Northern Campus during the October 2011 Northern Namibia Choral Extravaganza. | ["Gospel music", "Music", "Song", "Choir", "A capella"] | ["low quality", "mono", "noisy", "passionate harmonizing choir vocals", "fruity male vocal", "traditional", "joyful", "passionate"] | 4 | rizanOQM61k | 4897 |
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;