musiccaps_details (view)
2 rows where musiccaps_aspects contains "choir" and musiccaps_aspects contains "male vocals"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- choir · 2 ✖
- male vocals · 2 ✖
- acapella 1
- bass guitar 1
- church hymn 1
- cumbia 1
- dance 1
- female vocal 1
- festive christian 1
- gospel 1
- harmony singing 1
- latin 1
- latin dance 1
- latin percussion 1
- piano 1
- playful 1
- religious 1
- seductive singing 1
- spiritual 1
- trumpets 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ven a mi casa mama ( original ) HQ | This is a cumbia piece. There is a female vocal singing seductively joined by male back vocals singing in the chorus. The trumpet is playing the main melody joined by the piano and the bass guitar in the background. Latin percussion playing a cumbia beat provides the rhythmic background. The atmosphere of the piece is very playful. The ideal setting for this piece can be a latin dance course. | 2011-07-15T21:44:16Z | tecoloves | sonideros | ["Swing music", "Music"] | ["cumbia", "latin", "latin dance", "female vocal", "seductive singing", "male vocals", "choir", "latin percussion", "trumpets", "piano", "bass guitar", "playful", "dance"] | 9 | 7NnvEryyYdo | 840 | |
Mansion Robe and Crown ( Acapella with Lyrics ) | This is a gospel music piece. The piece is a church hymn that is being sung by a choir in the style of acapella. The male vocals are harmony singing. The atmosphere is festive. This piece can be played at Christian religious events. It could also be used in the soundtrack of a modern drama movie during religious scenes. | 2011-08-03T18:53:32Z | CHURCHofCHRIST24 | * I do not own any part of this video. All song materials belong to rightful owner. Lyrics: I'm gonna trade my earthly home For a better one, bright and fair. Christ left to prepare a mansion For His children in the air. I'll join Him in that land Where tears nor sorrows can be found And I'll receive my mansion, Robe, and crown. Chorus (bass Mansion, robe, and a crown Lord I want a brand new mansion, robe, and a crown in glory There love always abound There I know that peace and love will always abound forever Let me Your throne surround Let me be among the saved to Your throne surround Lord, please reserve my mansion, robe and crown And I'll receive my mansion Robe, and crown. The weather there is always fair, There is sunshine day and night No cold and no rain will fall there For the sun shines ever bright I'll need no heavy garments, I'll just wrap my robe around When I receive my mansion, Robe, and crown. Chorus My head is bowed and bloody now From the work that I've tried to do But one day I'll be rewarded With a crown so bright and new I'll wear a smile so bright For there'll be no cause for a frown When I receive my mansion, Robe, and crown Chorus | ["Chant", "Music", "Choir", "A capella"] | ["gospel", "church hymn", "acapella", "male vocals", "choir", "harmony singing", "festive christian", "religious", "spiritual"] | 9 | IDHHAwqDpzU | 1882 |
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;