musiccaps_details (view)
2 rows where musiccaps_aspects contains "no instruments" and musiccaps_names contains "Choir"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- no instruments · 2 ✖
- acapella 1
- chanting song 1
- choir song 1
- choral arrangement 1
- female vocal harmony 1
- female voices 1
- gospel hymn 1
- male vocal harmony 1
- male voices 1
- moderate tempo 1
- religious song 1
- reverb effect on voice 1
- slow tempo 1
musiccaps_names (array) 5 ✖
- Choir · 2 ✖
- /t/dd00003 1
- /t/dd00004 1
- Chant 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Veni Sancte Spiritus, Come Holy Spirit - Gregorian Chant with lyrics | This religious song features the main melody first sung by male voices in harmony followed by female voices in harmony. The voices sing in a hall environment giving a reverb effect. There are no instruments in this song. This song gives a holy feel. This song can be played in a church. | 2010-10-21T00:51:39Z | Petrus Josephus | A well known hymn, Veni Sancte Spiritus is a pentecostal chant of worship and adoration. It is a sequentia meant specifically, though not exclusively, for the Pentecost season of the Church. This hymn can be heard and sung as a daily prayer to God, imploring Him to set us on fire with the Holy Spirit; a cleansing and restoring fire. The English translation is as follows: Come, Holy Spirit, send forth the heavenly radiance of your light. Come, father of the poor, come giver of gifts, come, light of the heart. Greatest comforter, sweet guest of the soul, sweet consolation. In labor, rest, in heat, temperance, in tears, solace. O most blessed light, fill the inmost heart of your faithful. Without your divine will, there is nothing in man, nothing is harmless. Wash that which is unclean, water that which is dry, heal that which is wounded. Bend that which is inflexible, warm that which is chilled, make right that which is wrong. Give to your faithful, who rely on you, the sevenfold gifts. Give reward to virtue, give salvation at our passing on, give eternal joy. Amen. Alleluia. | ["Chant", "Music", "Choir"] | ["chanting song", "religious song", "male vocal harmony", "female vocal harmony", "no instruments", "choral arrangement", "slow tempo", "reverb effect on voice"] | 0 | 3pU34vUoO9g | 506 | |
Chantage choir singing the Battle of Jericho | This choir song features male and female voices. The voices sing different parts. The female voices sing the soprano and alto parts. The male voices sing the tenor and bass parts. The voices sing in harmony. This is an acapella song. There are no instruments in this song. The song is a gospel hymn. This song can be played in a historic animation movie before a battle scene. | 2006-12-17T04:13:06Z | Richard W Collins | Chantage UK choir singing Moses Hogan's arrangement of The Battle of Jericho, winning the BBC Radio 3 Choir of the Year 2006 competition. | ["Choir", "/t/dd00003", "/t/dd00004"] | ["choir song", "male voices", "female voices", "no instruments", "acapella", "moderate tempo", "gospel hymn"] | 0 | 7AC9RqECN5k | 817 |
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;