musiccaps_details (view)
5 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 88 ✖
- female singer · 5 ✖
- keyboard accompaniment · 5 ✖
- buoyant 2
- devotional 2
- emotional 2
- medium tempo 2
- vivacious 2
- youthful 2
- acordion harmony 1
- acoustic guitar 1
- amateur recording 1
- ambient sounds 1
- animated 1
- backup vocals 1
- bright bass lines 1
- bright vocals 1
- catchy riff 1
- chant 1
- cheering 1
- choral backup 1
- christian gospel song 1
- christian music 1
- christian song 1
- clapping 1
- classic rock 1
- club music 1
- congas beat 1
- contemporary 1
- dance music 1
- earnest 1
- electric guitar 1
- energetic electric guitar harmony 1
- engaging 1
- enigmatic 1
- enthusiastic 1
- fast tempo 1
- fervent 1
- flute melody 1
- foreign language introduction 1
- groovy bass 1
- groovy bass lines 1
- groovy dance beat 1
- hymns 1
- hypnotic 1
- indian classical 1
- indian god 1
- inferior audio quality 1
- live performance 1
- lively 1
- meditative 1
- medium fast tempo 1
- melancholic 1
- mellow 1
- mellow electric guitar 1
- melodious 1
- minimal music 1
- muffled audio 1
- nostalgic 1
- outdoors 1
- passionate 1
- people talking 1
- perky 1
- pop 1
- pop rock 1
- praise and worship 1
- psychedelic harmony 1
- puja 1
- punchy 1
- rhythmic acoustic guitar 1
- sentimental 1
- slow tempo 1
- small hand cymbals 1
- soft lilting flute 1
- soft pop 1
- soothing 1
- spanish 1
- spirited 1
- steel pan percussion 1
- subtle bass lines 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- tambourine beats 1
- teen pop 1
- trance 1
- vibrant 1
- vigorous drumming 1
- vocal emphasis 1
- worship 1
musiccaps_names (array) 13 ✖
- Music 5
- Singing 2
- Angry music 1
- Choir 1
- Christian music 1
- Crowd 1
- Folk music 1
- Gospel music 1
- Mantra 1
- Middle Eastern music 1
- Rattle (instrument) 1
- Sad music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Coro Gospel AGUAVIVA en Albacete 1 | A female vocalist sings this Gospel song. The tempo is medium with groovy bass lines, keyboard accompaniment, electric guitar and acoustic guitar rhythm,tambourine beats and choral harmony. The song is a spirited,emotional,fervent, earnest and devotional Christian Worship Song. | 2010-02-07T02:22:15Z | MakinGospel | Video Oficial producido por MAKINGOSPEL del concierto del Coro Gospel Aguaviva en Albacete el 21-03-09, primera parte. | ["Singing", "Gospel music", "Christian music", "Crowd", "Music", "Choir"] | ["female singer", "medium tempo", "electric guitar", "groovy bass", "keyboard accompaniment", "choral backup", "christian music", "christian song", "hymns", "christian gospel song", "devotional", "praise and worship", "fervent", "earnest", "passionate", "emotional", "acoustic guitar"] | 7 | 0oIFGARD9xE | 210 | |
"ANGEL OF BENGAL" - The Religion of Love, music video | A female vocalist sings this soft melody. The song is slow tempo with a mellow electric guitar harmony, soft keyboard accompaniment , a soft lilting flute melody and subtle bass line. There is no use of percussion. The song is soft, mellow, emotional, nostalgic and sentimental . This song is Soft pop. | 2008-07-09T03:19:08Z | Hassan Ali | Devotional music written, performed, and produced by Jaraneh Nova. Dedicated to our Spiritual Master, Mother Rytasha, The Angel of Bengal. A Razzaque Khan Production. http://thereligionoflove.net ,http://www.chela.net/rytasha ,-- love@chela.net | ["Music", "Sad music"] | ["female singer", "slow tempo", "mellow electric guitar", "soft lilting flute", "keyboard accompaniment", "subtle bass lines", "vocal emphasis", "minimal music", "soft pop", "mellow", "soothing", "emotional", "sentimental", "nostalgic", "melancholic"] | 7 | 9aE33JEIGOg | 1028 | |
Chicas Roland's - Cumbia - El Hijo De Tuta | A female vocalist sings this Spanish melody. The tempo is medium with keyboard harmony, tambourine beats, rhythmic congas and acoustic guitar. The song is upbeat, buoyant, groovy, lively, spirited,youthful and engaging. This is an outdoor live performance as there are ambient sounds like gentle wind, people talking, clapping and cheering. This song is a lively Spanish Pop song. | 2008-06-13T21:36:48Z | Palmeras Disco | Video "del Baul De Los Recuerdos" de Las Chicas Roland's interpretando la cumbia "El Hijo De Tuta" en Junio del 2002. Espero les guste... | ["Singing", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "pop", "spirited", "lively", "buoyant", "engaging", "vivacious", "spanish", "amateur recording", "muffled audio", "acordion harmony", "congas beat", "keyboard accompaniment", "rhythmic acoustic guitar", "live performance", "outdoors", "ambient sounds", "people talking", "cheering", "clapping", "inferior audio quality", "groovy dance beat", "buoyant", "youthful", "tambourine beats"] | 7 | Py8Vd0-qxYU | 2583 | |
Hawaiian Roller Coaster Ride- Jump 5 (Lyrics) | A female vocalist sings this spirited pop song. The tempo is fast with vigorous drumming, animated electric guitar harmony, keyboard accompaniment and groovy bass lines along with backup vocals. The first bit of the song is sung in foreign language. The song is energetic, youthful, passionate, vibrant and vivacious with a dance groove. This song is Teen Pop/Pop Rock. | 2009-08-22T02:50:00Z | Javiix7 | lyrics this is one of my favorite songs | ["Music", "Angry music"] | ["female singer", "fast tempo", "vigorous drumming", "teen pop", "foreign language introduction", "vibrant", "vivacious", "teen pop", "dance music", "club music", "energetic electric guitar harmony", "bright bass lines", "bright vocals", "backup vocals", "animated", "youthful", "enthusiastic", "dance music", "perky", "punchy", "buoyant", "pop rock", "classic rock", "keyboard accompaniment"] | 7 | id5ibIqjRto | 4208 | |
Maha Mantra Hare Krishna | A female vocalist sings this pleasant chant. The song is medium fast tempo with groovy basslines, mellifluous flute, steel pan beat,small hand cymbals and synthesiser arrangement. The song is sweet, melodic, hypnotic, enthralling, enigmatic, trance-like, trippy and psychedelic. This song is a contemporary indian worship song. | 2010-06-28T19:06:46Z | Nettan Von Pavarga | Hare Krishna mantra sung by Krishna Premi Krishna Premi (ACBSP) from her album "Nectar of the Holy Name". | ["Mantra", "Folk music", "Music", "Middle Eastern music", "Song"] | ["female singer", "medium fast tempo", "enigmatic", "hypnotic", "trance", "contemporary", "synthesiser arrangements", "flute melody", "small hand cymbals", "groovy bass lines", "keyboard accompaniment", "steel pan percussion", "synthesiser arrangement", "psychedelic harmony", "chant", "meditative", "indian classical", "puja", "devotional", "catchy riff", "melodious", "contemporary", "indian god", "worship"] | 7 | tdrz4EkIsow | 5055 |
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;